Supplier Balance Transfer

Table Owner	Table Name	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	stn_acct_info_dtl	ou_id	sql_variant	Organization Unit Id	Yes	No
		company_code		Company Code
		tran_no		Transaction Number
		tran_type		Transaction Type
		account_code		Account Code
		drcr_flag		Debit Credit Flag
		account_type		Account Type	No
		tran_date	datetime	Transaction Date
		fin_post_date		Finance Posting Date
		currency_code	sql_variant	Currency Code
		cost_center		Cost Center
		tran_amount	bigint	Transaction Amount
		fb_id	sql_variant	Finance Book Id
		analysis_code		Analysis Code
		subanalysis_code		Subanalysis Code
		basecur_erate	bigint	Base Currency Exchange Rate
		base_amount		Base Amount
		pbcur_erate		Parallel Base Currency Exchange Rate
		par_base_amt		Parallel Base Amount
		fin_post_status	sql_variant	Finance Posting Status
		guid		Guid
		acct_line_no	int	Account Line Number
		bu_id	sql_variant	Business Unit Id
		transfer_docno		Transfer Document Number
		supplier_code		Supplier Code
	stn_acctlnk_tmp	guid		Guid	Yes
		document_no		Document Number
	stn_attach_notes	trans_credit_note		Transaction Credit Note
		trans_ouid	int	Transaction Organization Unit Id
		notesfor	sql_variant	Notes For	No
		notes		Notes
	stn_comptot_tmp	guid		Guid
		doc_no		Document Number
		doc_ou	int	Document Organization Unit
		doc_type	sql_variant	Document Type
		doc_date	datetime	Document Date
		supp_area	int	Supplier Area
		doc_amount	bigint	Document Amount
		exchange_rate		Exchange Rate
		outstanding_amount		Outstanding Amount
		total_amt		Total Amount
	stn_credit_note_dtl	ou_id	int	Organization Unit Id	Yes
		trns_credit_note	sql_variant	Transfer Credit Notes
		tran_type		Transaction Type
		timestamp	int	Time Stamp	No
		transfer_docno	sql_variant	Transfer Document Number
		notype_no		Numbering Type
		tran_date	datetime	Transaction Date
		supplier_code	sql_variant	Supplier Code
		currency_code		Currency Code
		account_code		Account Code
		fb_id		Finance Book Id
		tran_amount	bigint	Transaction Amount
		cost_center	sql_variant	Cost Center
		analysis_code		Analysis Code
		subanalysis_code		Subanalysis Code
		exchange_rate	bigint	Exchange Rate
		pbcur_erate	sql_variant	Parallel Base Currency Exchange Rate
		transferred_amt	bigint	Transferred Amount
		reason_code	sql_variant	Reason Code
		comments		Comments
		ref_doc_no		Reference Document Number
		status		Status.Values F-Fresh,A-Authorised,H-Hold,D-Draft
		crosscur_erate	bigint	Cross Currency Exchange Rate
		base_amount		Base Amount
		par_base_amt		Parallel Base Amount
		batch_id	sql_variant	Batch Id
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	stn_debit_note_dtl	ou_id	int	Organization Unit Id	Yes
		trns_debit_note	sql_variant	Transfer Debit Notes
		tran_type		Transaction Type
		timestamp	int	Time Stamp	No
		notype_no	sql_variant	Numbering Type
		transfer_docno		Transfer Document Number
		tran_date	datetime	Transaction Date
		supplier_code	sql_variant	Supplier Code
		currency_code		Currency Code
		account_code		Account Code
		fb_id		Finance Book Id
		tran_amount	bigint	Transaction Amount
		cost_center	sql_variant	Cost Center
		analysis_code		Analysis Code
		subanalysis_code		Subanalysis Code
		exchange_rate	bigint	Exchange Rate
		pbcur_erate		Parallel Base Currency Exchange Rate
		transferred_amt		Transferred Amount
		reason_code	sql_variant	Reason Code
		comments		Comments
		ref_doc_no		Reference Document Number
		status		Status.Values F-Fresh,A-Authorised,H-Hold,D-Draft
		crosscur_erate	bigint	Cross Currency Exchange Rate
		base_amount		Base Amount
		par_base_amt		Parallel Base Amount
		batch_id	sql_variant	Batch Id
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	stn_doc_dtl	ou_id	int	Organization Unit Id	Yes
		trns_debit_note	sql_variant	Transfer Debit Note
		tran_type		Transaction Type
		dr_doc_no		Debit Document Number
		ref_tran_type		Reference Transaction Type
		dr_doc_ou	int	Debit Document Organization Unit
		dr_doc_type	sql_variant	Debit Document type	No
		au_doc_date	datetime	Authorized Document Date
		au_supp_area	int	Authorized Supplier Area
		au_document_amount	bigint	Authorized Document Amount
		transfer_status	sql_variant	Transfer Status.Values F-Fresh,A-Authorised,H-Hold,D-Draft
		exchange_rate	bigint	Exchange Rate
		batch_id	sql_variant	Batch Id
	stn_doc_dtl_tmp	guid		Guid	Yes
		ou_id	int	Organization Unit Id
		doc_no	sql_variant	Document Number
		doc_ou	int	Document Organization Unit
		doc_type	sql_variant	Document Type
		doc_date	datetime	Document Date	No
		supp_area	int	Supplier Area
		doc_amount	bigint	Document Amount
		exchange_rate		Exchange Rate
		tran_no	sql_variant	Transaction Number
		tran_ou	int	Transaction Organization Unit
		tran_date	sql_variant	Transaction Date
		supp_ou	int	Supplier Organization Unit
		tran_type	sql_variant	Transaction Type
		drcr_flag		Debit Credit Flag
	stn_doc_rpt_tmp	doctype		Document Type
		docnumber		Document Number
		docdate	datetime	Document Date
		supplierregister	sql_variant	Supplier Register
		amount	bigint	Amount
		tran_type	sql_variant	Transaction Type
		ou_id	int	Organization Unit Id
		trns_credit_note	sql_variant	Transfer Credit Note
		term_no		Term Number
		due_date	datetime	Due Date
		due_amount	bigint	Due Amount
		discount_date	datetime	Discount Date
		disc_percent	bigint	Discount Percentage
		discount		Discount
		penalty_percent		Penalty Percentage
		guid	sql_variant	Guid
		pay_term		Pay Term
		dummy_var		Dummy
	stn_payment_dtl	tran_type		Transaction Type	Yes
		ou_id	int	Organization Unit Id
		trns_credit_note	sql_variant	Transfers Credit Notes
		pay_term		Pay Term
		term_no		Term Number
		due_date	datetime	Due Date	No
		due_amt_type	sql_variant	Due Amount Type
		due_percent	bigint	Due Percentage
		due_amount		Due Amount
		disc_amount_type	sql_variant	Discount Amount Type
		dis_comp_amt	bigint	Discount Computation Amount
		discount_date	datetime	Discount Date
		disc_percent	bigint	Discount Percentage
		discount		Discount
		penalty_percent		Penalty Percentage
		esr_ref_no	sql_variant	ESR Reference Number
		esr_amount	bigint	ESR Amount
		esr_code_line	sql_variant	ESR Code Line
	stn_payment_hdr	ou_id	int	Organization Unit Id	Yes
		trns_credit_note	sql_variant	Transfer Credit Notes
		pay_term		Pay Term
		tran_type		Transaction Type
		status		Status.Values F-Fresh,A-Authorised,H-Hold,D-Draft	No
		disc_computation		Discount Computation
		elec_payment		Electronic Payment
		payment_method		Payment Method
		payment_route		Payment Route
		pay_mode		Pay Mode
		esr_part_id		ESR Part Id
		partid_digits	int	Part Id Digits
		esr_ref_no	sql_variant	ESR Reference Number
		lsv_bank_code		LSV Bank Code
		lsv_contract_id		LSV Contract Id
		lsv_contract_ref		LSV Contract Reference
		comp_acct_in		Component Acctouning Information
		comp_bnkptt_acct		Component Bank / PTT Account
		comp_bnkptt_ref		Component Bank / PTT Reference
		supp_acct_in		Supplier Account Information
		supp_bnkptt_acct		Supplier Bank / PTT Account
		supp_bnkptt_ref		Supplier Bank/Ptt Reference
		ps_pi_flag		Flag
	stn_payment_rpt_tmp	tran_type		Transaction Type
		ou_id	int	Organization Unit Id
		trns_credit_note	sql_variant	Transfer Credit Note
		term_no		Term Number
		due_date	datetime	Due Date
		due_amount	bigint	Due Amount
		discount_date	datetime	Discount Date
		disc_percent	bigint	Discount Percentage
		discount		Discount
		penalty_percent		Penalty Percentage
		dummy_var	sql_variant	Dummy
		guid		Guid
		dummy_var1		Dummy
		payterm		Pay Term
		pay_term		Pay Term.
	stn_stdnotes_tmp	std_notes_id		Standard Notes Id	Yes
		std_notes_desc		Standard Notes Description
		notes		Notes	No
		guid		Guid
	stn_transfer_bal_hdr	ou_id	int	Organization Unit Id	Yes
		transfer_docno	sql_variant	Transfer Document Number
		transfer_date	datetime	Transfer Date	No
		transfer_bal_in	sql_variant	Transfer Balance Information
		transferor		Transferor
		auto_adjust		Auto Adjust
		transferee		Transferee
		transferor_docno		Transferor Document Number
		transferor_doctype		Transferor Document Type
		transferee_docno		Transferee Document Number
		transferee_doctype		Transferee Document Type
		au_account_balance	bigint	Authorized Account Balance
		status	sql_variant	Status.Values F-Fresh,A-Authorised,H-Hold,D-Draft
		au_tran_amount	bigint	Authorized Transaction Amount
		au_account_code	sql_variant	Authorized Account Code
		batch_id		Batch Id