Supplier Inquiry

Supplier Inquiry

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	pm_si_ibe_acc_dtl_tmp		guid	sql_variant	Guid	No	No
			acc_code		Account Code
			acc_type		Account Type
			currency		Currency
			fb		Finance Book
			tranamount	bigint	Transaction Amount
			baseamount		Base Amount
			pbamount		Parallel Base Amount
	pm_si_ibe_error_log		guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			line_no		Line Number
			fb	sql_variant	Finance Book
			tran_type		Transaction Type
			tran_no		Transaction Number
			tran_curr		Transaction Currency
			acc_code		Account Code
			tran_amt	bigint	Transaction Amount
			error_desc	sql_variant	Error Description
	pm_si_ibe_glcompare_tmp		guid		Guid
			fb		Finance Book
			cntrl_acc_type		Control Account Type
			account_code		Account Code
			acc_desc		Account Description
			currency		Currency
			tran_bal_pm	bigint	Transaction balance PM
			bc_bal_pm		Base Currency Balance PM
			pbc_bal_pm		Parallel Base Currency Balance PM
			tran_bal_bk		Transaction Balance BK
			bc_bal_bk		Base Currency Balance BK
			pbc_bal_bk		Parallel Base Currency Balance BK
	pm_si_ibe_tran_tmp		guid	sql_variant	Guid
			line_no	int	Line Number
			fb	sql_variant	Finance Book
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Number
			tran_type		Transaction Type
			tran_date	datetime	Transaction Date
			supplier_code	sql_variant	Supplier Code
			pay_to_supp		Pay To Supplier
			tran_curr		Transaction Currency
			tran_amount	bigint	Transaction Amount
			tran_outstand_amt		Transaction Outstanding Amount
			base_amount		Base Amount
			base_outstand_amt		Base Outstanding Amount
			pbc_amount		Parallel Base Currency Amount
			pbc_outstand_amt		Parallel Base Outstanding Amount
			due_date	datetime	Due Date
			invoice_no	sql_variant	Invoice Number
			invoice_date	datetime	Invoice Date
			invoice_amount	bigint	Invoice Amount
			bank_cash_code	sql_variant	Bank Cash Code
			payment_point	int	Payment Point
			cntrl_acc_code	sql_variant	Control Account Code
			deposit_acc_code		Deposit Account Code
			prepay_acc_code		Prepay Account Code
			process_flag		Process Flag
	pm_si_ibe_transactions_tmp		guid		Guid
			line_no	int	Line Number
			fb	sql_variant	Finance Book
			tran_ou		Transaction Organization Unit
			tran_no		Transaction Number
			tran_type		Transaction Type
			tran_date	datetime	Transaction Date
			supplier_code	sql_variant	Supplier Code
			pay_to_supp		Pay To Supplier
			tran_curr		Transaction Currency
			tran_amount	bigint	Transaction Amount
			tran_outstand_amt		Transaction Outstanding Amount
			base_amount		Base Amount
			base_outstand_amt		Base Outstanding Amount
			pbc_amount		Parallel Base Currency Amount
			pbc_outstand_amt		Parallel Base Currency Outstanding Amount
			due_date	datetime	Due Date
			invoice_no	sql_variant	Invoice Number
			invoice_date	datetime	Invoice Date
			invoice_amount	bigint	Invoice Amount
			bank_cash_code	sql_variant	Bank Cash Code
			payment_point		Payment Point
	si_acct_balance_matrix		guid		Guid	Yes
			tran_currency		Transaction Currency
			balance_type		Balance Type
			balance_currency		Balance Currency
			createdby		Created By	No
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	si_acct_balance_matrix_tmp		guid	sql_variant	Guid
			tran_currency		Transaction Currency
			balance_type		Balance Type
			balance_currency		Balance Currency
			timestamp	int	Time Stamp
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	si_acct_info_dtl	Table that maintains the posting level info and Amounts for each Transaction number	tran_ou	int	Transaction Organization Unit Id
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			line_no	int	Line Number
			company_code	sql_variant	Company Code
			fb_id		Finance Book Id
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			component_id		Component Id
			txnou_id	int	Transaction Organization Unit Id
			bu_id	sql_variant	Business Unit Id
			tran_date	datetime	Transaction Date
			tran_qty	bigint	Transaction Quantity
			tran_amount_acc_cur		Transaction Amount Account Currency
			ctrl_acct_type	sql_variant	Control Account Type
			auto_post_acct_type		Auto Posted Account Type
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			cost_center		Cost Center
			bank_code		Bank Code
			item_code		Item Code
			item_variant		Item Variant
			uom		Unit Of Measurement
			supplier_code		Supplier Code
			acct_currency		Account Currency
			basecur_erate	bigint	Base Currency Exchange Rate
			base_amount		Base Amount
			exchange_rate		Exchange Rate
			par_exchange_rate		Parallel Exchange Rate
			par_base_amount		Parallel Base Amount
			narration	sql_variant	Narration
			auth_date	datetime	Authorized Date
			ref_doc_ou	int	Reference Document Organization Unit
			ref_doc_fb_id	sql_variant	Reference Document Finance Book Id
			ref_doc_type		Reference Document Type
			ref_doc_no		Reference Document Number
			vat_decl_year		Value Added Tax Declaration Year
			vat_decl_period		Value Added Tax Declaration Period
			vat_usage_flag		Value Added Tax Usage Flag
			vat_category		Value Added Tax Category
			vat_class		Value Added Tax Class
			vat_code		Value Added Tax Code
			vat_rate	bigint	Value Added Tax Rate
			posting_date	datetime	Posting Date
			posting_status	sql_variant	Posting Status
			base_currency		Base Currency
			par_base_currency		Parallel Base Currency
			vat_posting_flag		Value Added Tax Posting Flag
			vat_posting_date	datetime	Value Added Tax Posting Date
			account_type	sql_variant	Account Type
			batch_id		Batch Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			vat_line_no	int	Value Added Tax Line Number
			ref_doclineno		Reference Document Line Number
			capitalized_amount	bigint	Capitalized Amount
	si_acct_info_dtl_tmp		tran_ou	int	Transaction Organization Unit
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			line_no	int	Line Number
			timestamp		Time Stamp
			component_id	sql_variant	Component Id
			company_code		Company Code
			fb_id		Finance Book Id
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			txnou_id	int	Transaction Organization Unit Id
			bu_id	sql_variant	Business Unit Id
			tran_date	datetime	Transaction Date
			tran_qty	bigint	Transaction Quantity
			tran_amount_acc_cur		Transaction Amount Account Currency
			ctrl_acct_type	sql_variant	Control Account Type
			auto_post_acct_type		Auto Posted Accounting Type
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			cost_center		Cost Center
			bank_code		Bank Code
			item_code		Item Code
			item_variant		Item Variant
			uom		Unit Of Measurement
			acct_currency		Account Currency
			base_amount	bigint	Base Amount
			par_exchange_rate		Parallel Exchange Rate
			par_base_amount		Parallel Base Amount
			narration	sql_variant	Narration
			auth_date	datetime	Authorized Date
			ref_doc_ou	int	Reference Document Organization Unit
			ref_doc_fb_id	sql_variant	Reference Document Finance Book Id
			ref_doc_type		Reference Document Type
			ref_doc_no		Reference Document Number
			vat_decl_year		Value Added Tax Declaration Year
			vat_decl_period		Value Added Tax Declaration Period
			vat_usage_flag		Value Added Tax Usage Id
			vat_category		Value Added Tax Category
			vat_class		Value Added Tax Class
			vat_code		Value Added Tax Code
			vat_rate	bigint	Value Added Tax Rate
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			posting_date		Posting Date
			posting_status	sql_variant	Posting Status
			base_currency		Base Currency
			par_base_currency		Parallel Base Currency
			modifiedby		Modified By
			modifieddate	datetime	Modified Date
			vat_posting_flag	sql_variant	Value Added Tax Posting Flag
			vat_posting_date	datetime	Value Added Tax Posting Date
			account_type	sql_variant	Account Type
			supplier_code		Supplier Code
			exchange_rate	bigint	Exchange Rate
			batch_id	sql_variant	Batch Id
	si_cur_bal_tmp		guid		Guid
			supplier_code		Supplier Code
			currency		Currency
			due_amount	bigint	Due Amount
			base_amount		Base Amount
			par_base_amount		Parallel Base Amount
			base_curr_erate		Base Currency Exchange Rate
			par_base_curr_erate		Parallel Base Currency Exchange Rate
	si_doc_acct_info_tmp		guid	sql_variant	Guid
			tran_ou	int	Transaction Organization Unit
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			tran_date	datetime	Transaction Date
			component_id	sql_variant	Component Id
			lo_id		Logistics Organization Id
			company_code		Company Code
			bu_id		Business Unit Id
			fb_id		Finance Book Id
			supp_ou	int	Supplier Organization Unit
			supplier_code	sql_variant	Supplier Code
			supp_name		Supplier Name
			supp_inv_no		Supplier Invoice Number
			pay_term		Pay Term
			payterm_version	int	Pay Term Version
			doc_status	sql_variant	Document Status.Values Statuses of various types of transactions.
			reversed_docno		Reversed Document Number
			reversal_date	datetime	Reversal Date
			bank_code	sql_variant	Bank Code
			checkseries_no		Check Series Number
			check_no		Check Number
			paid_status		Paid Status
			vat_applicable		Value Added Tax
			discount_proportional		Discount Proportional
			discount_amount	bigint	Discount Amount
			discount_availed		Discount Availed
			penalty_amount		Penalty Amount
			reversed_docou	int	Reversed Document Organization Unit
			bankcashcode	sql_variant	Bank Cash Code
			line_no	int	Line Number
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			ctrl_acct_type		Control Account Type
			auto_post_acct_type		Auto Posted Account Type
			tran_currency		Transaction Currency
			acct_currency		Account Currency
			tran_amount_acc_cur	bigint	Transaction Amount Account Currency
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			par_exchange_rate		Parallel Exchange Rate
			par_base_amount		Parallel Base Amount
			narration	sql_variant	Narration
			ref_doc_ou	int	Reference Document Organization Unit
			ref_doc_fb_id	sql_variant	Reference Document Finance Book ID
			ref_doc_type		Reference Document Type
			ref_doc_no		Reference Document Number
			auth_date	datetime	Authorized Date
			posting_date		Posting Date
			posting_status	sql_variant	Posting Status
			txnou_id	int	Transaction Organization Unit Id
			tran_qty	bigint	Transaction Quantity
			analysis_code	sql_variant	Analysis Code
			subanalysis_code		Subanalysis Code
			cost_center		Cost Center
	si_doc_balance	Table that maintains the outstanding amounts for each documents numbers	tran_ou		Transaction Organization Unit
			tran_type		Transaction Type
			tran_no		Transaction Number
			term_no		Term Number
			lo_id		Logistics Organization Id
			tran_currency		Transaction Currency
			tran_amount	bigint	Transaction Amount
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			par_exchange_rate		Parallel Exchange Rate
			par_base_amount		Parallel Base Amount
			doc_status	sql_variant	Document Status.Values Statuses of various types of transactions.
			adjustment_status		Adjustment Status.Values Adj-Adjusted,Padj- Partially adjusted.
			discount_amount	bigint	Discount Amount
			disc_availed		Discount Availed
			penalty_amount		Penalty Amount
			paid_amt		Paid Amount
			requested_amount		Requested Amount
			adjusted_amount		Adjusted Amount
			batch_id	sql_variant	Batch Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	si_doc_balance_matrix	Metadata table that contains the balance factor for each transactions numbers	tran_type	sql_variant	Transaction Type	Yes
			amt_type		Amount Type
			ref_tran_type		Reference Transaction Type
			output_val		Output Value
			output_val_cr		Output Value Credit
			tran_type_cr		Transaction Type Credit
			multiplicn_factor	int	Multiplication Factor	No
			multiplicn_factor_cr		Multiplication Factor Credit
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	si_doc_balance_matrix_met		tran_type	sql_variant	Transaction Type	Yes
			amt_type		Amount Type
			ref_tran_type		Reference Transaction Type
			target_col		Target Column
			balance_factor	bigint	Balance Factor	No
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	si_doc_hdr	Table that contains the document number and documents status and adjustment and paid staus for each transaction numbers	tran_ou	int	Transaction Organization Unit	Yes
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			timestamp	int	Time Stamp	No
			tran_date	datetime	Transaction Date
			lo_id	sql_variant	Logistics Organization Id
			fb_id		Finance Book Id
			tran_currency		Transaction Currency
			supplier_code		Supplier Code
			pay_term		Pay Term
			payterm_version	int	Pay Term Version
			tran_amount	bigint	Transaction Amount
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			par_exchange_rate		Parallel Exchange Rate
			par_base_amount		Parallel Base Amount
			doc_status	sql_variant	Document Status. Statuses of various types of transactions.
			reversed_docno		Reversed Document Number
			reversal_date	datetime	Reversal Date
			checkseries_no	sql_variant	Check Series Number
			check_no		Check Number
			bank_code		Bank Code
			paid_status		Paid Status.Values ADJ-Adjusted,REQ-requested,PPAD-partially paid,RVD-reversed,PADJ-partially adjusted,AUT-authorised,VD-void,HLD-Hold,HAU-Hold authorise,PAD-Fully paid,RE-Requested
			vat_applicable		Value Added Tax Applicable
			average_vat_rate	bigint	Average Value Added Tax Rate
			discount_proportional	sql_variant	Discount Proportional
			discount_amount	bigint	Discount Amount
			discount_availed		Discount Availed
			penalty_amount		Penalty Amount
			paid_amount		Paid Amount
			requested_amount		Requested Amount
			adjusted_amount		Adjusted Amount
			batch_id	sql_variant	Batch Id
			supp_ou	int	Supplier Organization Unit
			reversed_docou		Reversed Document Organization Unit
			supp_name	sql_variant	Supplier Name
			supp_inv_no		Supplier Invoice Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			bankcashcode	sql_variant	Bank Cash Code
			remarks		Remarks
			transfer_status		Transfer Status
			vat_incorporate_flag		Vat Incorporate Flag
			component_id		Component Id
			Forward_cover		Forward Cover
			Fw_cov_flag		Forward Cover Flag
			Fw_cov_rate	bigint	Forward Cover Rate
			pay_priority	sql_variant	Payment priority
			supp_invoice_date	datetime	Supplier invoice date
			pay_mode	sql_variant	Pay mode
			pay_method	sql_variant	Pay method
			pay_to_supp	sql_variant	Pay to supplier

	si_eft_payment_dtl	Table that contains the payref-id and pay ref details for each EFT paymode documents	Tran_ou	int	Transaction Organization Unit
			Tran_type	sql_variant	Transaction Type
			Tran_No		Transaction Number
			Pay_Ref_id		Pay Reference Id
			Pay_Ref_Details		Pay Reference Details
			Payment_Instructions		Payment Instructions
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	si_line_dtl		tran_type	sql_variant	Transaction Type
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Number
			line_no	int	Line Number
			row_type	sql_variant	Row Type
			timestamp	int	Time Stamp
			lo_id	sql_variant	Logistics Organization Id
			ref_doc_type		Reference Document Type
			ref_doc_ou	int	Reference Document Organization Unit
			ref_doc_no	sql_variant	Reference Document Number
			ref_doc_term_no		Reference Document Term Number
			item_tcd_code		Item Tax Charge Discount Code
			item_tcd_var		Item Tax Charge Discount Variant
			uom		Unit Of Measurement
			item_qty	bigint	Item Quantity
			unit_price		Unit Price
			rate_per		Rate Per
			item_amount		Item Amount
			tax_amount		Tax Amount
			disc_amount		Discount Amount
			line_amount		Line Amount
			capitalized_amount		Capitalized Amount
			proposal_no	sql_variant	Proposal Number
			cap_doc_flag		Capitalization Document Flag
			batch_id		Batch Id
			usage_id		Usage Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	si_open_tran_input_tmp		batch_id	sql_variant	Batch Id
			company_code		Company Code
			bfgid		Business Function Group Id
			ouinstance	int	Organization Unit Instance
			financebookid	sql_variant	Finance Book Id
			closuretype		Closure Type
			periodyear_flag		Period Year Flag
			finyr_code		Finance Year Code
			finprd_code		Finance Period Code
	si_open_tran_prd_tmp		batch_id		Batch Id
			componentid		Component Id
			finyr_code		Finance Year Code
			finprd_code		Finance Period Code
			status		Status
	si_open_tran_tmp		batch_id		Batch Id
			componentid		Component Id
			tran_type		Transaction Type
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Number
			tran_date	datetime	Transaction Date
			status	sql_variant	Status
			tran_desc		Transaction Description
	si_payment_dtl	Table contains the payterm and the due_amount for each document number	tran_type		Transaction Type	Yes
			tran_no		Transaction Number
			term_no		Term Number
			tran_ou	int	Transaction Organization Unit
			due_date	datetime	Due Date	No
			due_amount_type	sql_variant	Due Amount Type
			due_precent	bigint	Due Percentage
			due_amount		Due Amount
			disc_comp_amount		Discount Company Amount
			disc_amount_type	sql_variant	Discount Amount Type
			disc_date	datetime	Discount Date
			disc_precent	bigint	Discount Percentage
			disc_amount		Discount Amount
			penalty_precent		Penalty Percentage
			esr_ref_no	sql_variant	ESR Reference Number
			esr_coding_line		ESR Coding Line
			base_due_amount	bigint	Base Due Amount
			base_disc_amount		Base Discount Amount
			lo_id	sql_variant	Logistics Organization Id
			batch_id		Batch Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	si_posted_doc_log	Table that contains the posting amount for each documents	tran_ou	int	Transaction Organization Unit	Yes
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			term_no		Term Number
			amt_type		Amount Type
			dr_doc_ou	int	Debit Document Organization Unit
			dr_doc_type	sql_variant	Debit Document Type
			dr_doc_no		Debit Document Number
			cr_doc_ou	int	Credit Document Organization Unit
			cr_doc_type	sql_variant	Credit Document Type
			cr_doc_no		Credit Document Number
			cr_doc_term		Credit Document Term
			dr_doc_term		Debit Document Number	No
			lo_id		Logistics Organization Id
			tran_date	datetime	Transaction Date
			supplier_code	sql_variant	Supplier Code
			tran_currency		Transaction Currency
			tran_amount	bigint	Transaction Amount
			exchange_rate		Exchange Rate
			basecur_erate		Base Currency Exchange Rate
			par_exchange_rate		Parallel Exchange Rate
			cross_curr_erate		Cross Currency Exchange Rate
			par_base_amount		Parallel Base Amount
			base_amount		Base Amount
			posting_status	sql_variant	Posting Status
			posting_date	datetime	Posting Date
			batch_id	sql_variant	Batch Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			adjust_amount_inv_cur	bigint	Adjust Amount Invoice Currency
	si_supp_bal_rpt_summ_tmp		guid	sql_variant	Guid
			start_date	datetime	Start Date
			end_date		End Date
			company_code	sql_variant	Company Code
			bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			supplier_code		Supplier Code
			supp_name		Supplier Name
			account_code		Account Code
			account_type		Account Type
			acct_currency		Account Currency
			pr_cr_tran_amount	bigint	Period credit transaction amount
			pr_dr_tran_amount		Period debit transaction amount
			pr_cr_base_amount		Period credit base amount
			pr_dr_base_amount		Period debit base amount
			pr_cr_pab_amount		Period credit Parallel base amount
			pr_dr_pab_amount		Period debit Parallel base amount
			op_balance_tran		Opening Balance Transaction Amount
			op_balance_base		Opening Balance Base Amount
			op_balance_pab		Opening balance parallel base amount
			tran_drcr_flag	sql_variant	Transaction Credit Debit Flag
			base_drcr_flag		Base Credit Debit Flag
			pab_drcr_flag		Parallel base Debit / Credit flag
			company_name		Company Name
			account_desc		Account Description
			op_balance	bigint	Opening Balance
			pr_cr_balance		Period credit balance
			pr_dr_balance		Period debit balance
			tran_type	sql_variant	Transaction Type
	si_supplier_balance	Table that contains the opening and closing balances for each supplier in a financial period	ou_id	int	Organization Unit Id	Yes
			company_code	sql_variant	Company Code
			fb_id		Finance Book Id
			fin_year		Financial Year
			fin_period		Finance Period
			supplier_code		Supplier Code
			account_code		Account Code
			currency_code		Currency Code
			balance_type		Balance Type
			balance_currency		Balance Currency
			account_type		Account Type	No
			ob_credit	bigint	Opening Balance Credit
			ob_debit		Opening Balance Debit
			period_credit		Period Credit
			period_debit		Period Debit
			cb_credit		Closing Balance Credit
			cb_debit		Closing Balance Debit
			created_by	sql_variant	Created By
			created_date	datetime	Created Date
			last_modified_by	sql_variant	Last Modified By
			last_modified_date	datetime	Last Modified Date
			batch_id	sql_variant	Batch Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	si_supplier_balance_main_tmp		ou_id	int	Organization Unit id
			company_code	sql_variant	Company Code
			fb_id		Finance Book Id
			fin_year		Financial Year
			fin_period		Financial Period
			supplier_code		Supplier Code
			account_code		Account Code
			currency_code		Currency Code
			balance_type		Balance Type
			balance_currency		Balance Currency
			account_type		Account Type
			ob_credit	bigint	Opening Balance Credit
			ob_debit		Opening Balance Debit
			period_credit		Period Credit
			period_debit		Period Debit
			cb_credit		Closing Balance Credit
			cb_debit		Closing Balance Debit
			created_by	sql_variant	Created By
			created_date	datetime	Created Date
			last_modified_by	sql_variant	Last Modified By
			last_modified_date	datetime	Last Modified Date
			batch_id	sql_variant	Batch Id
	si_supplier_balance_rpt_tmp		guid		Guid
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			bu_id		Business Unit Id
			fb_id		Finance Book Id
			as_on_date	datetime	As On Date
			supplier_code	sql_variant	Supplier Code
			account_code		Account Code
			currency_code		Currency Code
			account_type		Account Type
			tran_drcr_flag		Transaction Debit Credit Flag
			base_drcr_flag		Base Debit Credit Flag
			pab_drcr_flag		Parallel base Debit / Credit flag
			tran_balance	bigint	Transaction Balance
			base_balance		Base Balance
			pab_balance		Parallel base amount balance
	si_supplier_balance_tmp		guid	sql_variant	Guid
			tran_currency		Transaction Currency
			balance_type		Balance Type
			balance_currency		Balance Currency
			timestamp	int	Time Stamp
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			supplier_code		Supplier Code
			account_code		Account Code
			currency_code		Currency Code
			fb_id		Finance Book Id
			account_type		Account Type
			exch_rate	bigint	Exchange Rate
			bal_acc_curr		Balance Account Currency
			bal_base_curr		Balance Base Currency
			bal_pbase_curr		Balance Parallel Base Currency
			acc_desc	sql_variant	Account Description
			supp_name		Supplier Name
			rev_bal_base_cur	bigint	Reversal Balance Base Currency
			exch_gl_base		Exchange General Ledger Base
			exch_gl_per		Exchange General Ledger Per
			rev_bal_pbase_cur		Reversal Balance Parallel Base Currency
			exch_gl_pbase		Exchange General Ledger Parallel Base
			exch_gl_pper		Exchange General Ledger Parallel Per
	si_supplier_statment		guid	sql_variant	Guid
			supplier_code		Supplier Code
			currency		Currency
			tran_type		Transaction Type
			tran_descr		Transaction Description
			tran_amount	bigint	Transaction Amount
			tran_date	datetime	Transaction Date
	si_supplier_statment_mid_tmp		guid	sql_variant	Guid
			supplier_code		Supplier Code
			tran_currency		Transaction Currency
			tran_type		Transaction Type
			tran_desc		Transaction Description
			tran_amount	bigint	Transaction Amount
			drcr_flag	sql_variant	Debit Credit Flag
	si_supplier_statment_tmp		guid		Guid
			supplier_code		Supplier Code
			tran_currency		Transaction Currency
			tran_type		Transaction Type
			tran_desc		Transaction Description
			tran_amount	bigint	Transaction Amount
			drcr_flag	sql_variant	Debit Credit Flag