Customer Inquiry

Customer 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	ci_acct_balance_matrix		guid	sql_variant	Guid	Yes	No
			tran_currency		Transaction Currency
			balance_type		Balance Type
			balance_currency		Balance Currency
			timestamp	int	Time Stamp	No
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ci_acct_info_dtl	Table that maintains the posting level info and Amounts for each Transaction numbers	tran_ou	int	Transaction Organization Unit	Yes
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			component_id		Component Id
			company_code		Company Code
			fb_id		Finance Book Id
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			line_no	int	Line Number
			timestamp		Time Stamp	No
			batch_id	sql_variant	Batch Id
			lo_id		Logistics Organization 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		Account Currency
			ctrl_acct_type	sql_variant	Control Account Type
			auto_post_acct_type		Automatic 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
			supcust_code		Supplier Customer Code
			acct_currency		Account Currency
			basecur_erate	bigint	Base Currency Exchange Rate
			base_amount		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 Decimal Year
			vat_decl_period		Value Added Tax Decimal 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
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			posting_date		Posting Date
			posting_status	sql_variant	Posting Status. Values P-Posted
			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
			vat_line_no	int	Value Added Tax Line Number
			ref_doc_lineno		Reference Document Line Number
	ci_bal_inq	Maintains customer balance’s informations	timestamp		Time Stamp
			bu	sql_variant	Business Unit
			custgrptype		Customer Group Type
			custgrpcode		Customer Group Code
			custcode		Customer Code
			custname		Cust Name
			tran_type		Transaction Type
			documentno		Document Number
			docdate	datetime	Document Date
			fbid	sql_variant	Finance Book Id
			cust_doc_refno		Customer Document Reference Number
			docamount	bigint	Document Amount
			base_amount		Base Amount
			unadjustedamt		Other Than Adjusted Amount
			unadjustedamt_base		Other Than Adjusted Amount Base
			guid	sql_variant	Guid
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ci_bal_inq_smry	Maintains customer balance’s informations summary details	timestamp	int	Time Stamp
			bu	sql_variant	Business Unit
			custgrptype		Customer Group Type
			custgrpcode		Customer Group Code
			custcode		Customer Code
			total_bill_amt	bigint	Total Bill Amount
			total_rcpt_amt		Total Receipt Amount
			balance_due_amt		Balance Due Amount
			guid	sql_variant	Guid
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ci_cbadj_crdoc	Maintains credit document’s Adjustment’s.	timestamp	int	Time Stamp
			bu_id	sql_variant	Business Unit Id
			ou_id	int	Organization Unit Id
			custcode	sql_variant	Customer Code
			adj_voucher_no		Adjustment Voucher Number
			documentno		Document Number
			tran_type		Transaction Type
			docdate	datetime	Document Date
			currency	sql_variant	Currency
			docamount	bigint	Document Amount
			base_amount		Base Amount
			adjustedamt		Adjusted Amount
			adjustedamt_base		Adjusted Amount Base
			adjustedamt_parbase		Adjusted Amount Parallel Base
			guid	sql_variant	Guid
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ci_cbadj_crdrdoc	Maintains debit and debit document’s Adjustment’s voucher number’s and adjustment amount’s’	bu_id	sql_variant	Business Unit Id
			ou_id	int	Organization Unit Id
			custcode	sql_variant	Customer Code
			custname		Customer Name
			currency		Currency
			tran_type		Transaction Type
			documentno		Document Number
			docdate	datetime	Document Date
			docamount	bigint	Document Amount
			adjustedamt		Adjusted Amount
			dueamount		Due Amount
			ref_doc_type	sql_variant	Reference Document Type
			ref_doc_no		Reference Document Number
			adj_voucher_no		Adjustment Voucher Number
			guid		Guid
	ci_cbadj_drdoc	Maintains debit document’s Adjustment’s.	timestamp	int	Time Stamp
			bu_id	sql_variant	Business Unit Id
			ou_id	int	Organization Unit Id
			custcode	sql_variant	Customer Code
			adj_voucher_no		Adjustment Voucher Number
			documentno		Document Number
			tran_type		Transaction Type
			docdate	datetime	Document Date
			currency	sql_variant	Currency
			dueamount	bigint	Due Amount
			dueamount_base		Due Amount Base
			adjustedamt		Adjusted Amount
			adjustedamt_base		Adjusted Amount Base
			written_off_amt_base		Written Off Amount Base
			written_off_amt_parbase		Written Off Amount Parallel Base
			write_back_amount_base		Write Back Amount Base
			write_back_amount_parbase		Write Back Amount Parallel Base
			exch_gainloss_amt_base		Exchange Gain / Loss Amount Base
			exch_gainloss_amt_parbase		Exchange Gain / Loss Amount Parallel Base
			guid	sql_variant	Guid
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	CI_CICICrdlmt_tmp		guid	sql_variant	Guid
			custgrp		Customer Group
			Customer_code		Customer Code
			custname		Customer Name
			custcurr		Customer Currency
			crdcurr		Credit Currency
			crdLmt	bigint	Credit Limit
	CI_CICIVwACCBAL_tmp		guid	sql_variant	Guid
			Customer_code		Customer Code
			custcurr		Customer Currency
			balance_currency		Balance Currency
			Acc_balance	bigint	Account Currency
			creditcurr	sql_variant	Credit Currency
	CI_CICIVwACCBAL_tmp2		guid		Guid
			Customer_code		Customer Code
			creditcurr		Credit Currency
			balance_currency		Balance Currency
			Acc_balance	bigint	Account Balance
	CI_CICIVwAvaillmt_tmp		guid	sql_variant	Guid
			Customer_code		Customer Code
			Acc_balance	bigint	Account Balance
			Ordinprog		Organization in Progress
			Utilizedlmt		Utilized Limit
			Availablelmt		Available Limit
	CI_CICIVWBAL_DEBITAMTDUE_TMP		Guid	sql_variant	Guid
			CustCode		Customer Code
			Doc_type		Document Type
			Doc_no		Document Number
			Inv_point	int	Invoice Point
			Doc_date	datetime	Document Date
			Doc_curr	sql_variant	Document Currency
			Doc_amt	bigint	Document Amount
			Amt_adj		Amount Adjusted
			Amt_Due_doccur		Amount Due Document Currency
			Exch_rate		Exchange Rate
			Amt_due		Amount Due
			Due_date	datetime	Due Date
	CI_CICIVWBAL_Unadjcredit_TMP		Guid	sql_variant	Guid
			CustCode		Customer Code
			Doc_type		Document Type
			Doc_no		Document Number
			Doc_date		Document Date
			Doc_curr		Document Currency
			Doc_amt	bigint	Document Amount
			Amt_adj		Amount Adjusted
			Amt_Due_doccur		Amount Due Document Currency
			Exch_rate		Exchange Rate
			Amt_due		Amount Due
	CI_CICIVWBAL_Unadjreceipt_TMP		Guid	sql_variant	Guid
			CustCode		Customer Code
			rcpt_mode		Receipt Mode
			rcpt_no		Receipt Number
			rcpt_date		Receipt Date
			rcpt_curr		Receipt Currency
			rcpt_amt	bigint	Receipt Amount
			Amt_adj		Amount Adjusted
			Amt_Due_doccur		Amount Due in Document Currency
			Exch_rate		Exchange Rate
			Amt_due		Amount Due
			Instr_no	sql_variant	Instrument Number
			Remitter_bank		Remitter Bank
			Instr_date	datetime	Instrument Date
			Instr_amt	bigint	Instrument Amount
			Instr_status	sql_variant	Instrument Status
	CI_CICIVwCuCrspLnk_tmp		GUID		Guid
			CUSTCODE		Customer Code
			FB		Finance Book
	CI_CICIVwCuinfo_tmp		ou_id	int	Organization Unit Id
			Guid	sql_variant	Guid
			Customer_code		Customer Code
			custname		Customer Name
			Currency		Currency
			creditlimit	bigint	Credit Limit
			Acc_balance		Account Balance
			OrdinProgress		Organization in Progress
			UtilizedCrLimit		Utilized Credit Limit
			AvaliableCrLimit		Available Credit Limit
			Crdlmtbased	sql_variant	Credit Limit Based
			Crdbasis		Credit Basis
			Dispoption		Display Option
			Custgrp		Customer Group
	CI_CICIVWORD_ORDDET_DTL	Maintains customer order level Material ,Labour and facility breakup’s and Order in progress informations.	Guid		Guid
			CustCode		Customer Code
			ref_doc_type		Reference Document Type
			ref_doc_no		Reference Document Number
			Ord_curr		Order Currency
			ORD_MAT	bigint	Order Material
			ORD_RES		Order Resource
			ORD_OTH		Order Others
			ORD_TOT		Order Total
			INV_MAT		Invoice Material
			INV_RES		Invoice Resource
			INV_OTH		Invoice Others
			INV_TOT		Invoice Total
			ORDINPROG_ORDCURR		Order Currency
			EXCH_RATE		Exchange Rate
			ORDINPROG		Order in Progress
	CI_CICIVWORD_ORDDET_tmp		Guid	sql_variant	Guid
			CustCode		Customer Code
			ref_doc_type		Reference Document Type
			ref_doc_no		Reference Document Number
			Ord_curr		Order Currency
			ORD_MAT	bigint	Order Materials
			ORD_RES		Order Resource
			ORD_OTH		Order Others
			ORD_TOT		Order Total
			INV_MAT		Invoice Material
			INV_RES		Invoice Resource
			INV_OTH		Invoice Others
			INV_TOT		Invoice Total
			ORDINPROG_ORDCURR		Order Currency
			FWD_APPL	sql_variant	Forward Application
			FWD_RATE	bigint	Forward Rate
			EXCH_RATE		Exchange Rate
			ORDINPROG		Order in Progress
	CI_CICIVwOrdinprog_tmp		guid	sql_variant	Guid
			Customer_code		Customer Code
			custcurr		Customer Currency
			Ordcurr		Order Currency
			Ordinprog	bigint	Order in Progress
			creditcurr	sql_variant	Credit Currency
			fwd_appl		Forward Application
			fwd_rate	bigint	Forward Rate
	CI_CICIVwOrdinprog_tmp2		guid	sql_variant	Guid
			Customer_code		Customer Code
			creditcurr		Credit Currency
			Ordcurr		Order Currency
			Ordinprog	bigint	Order in Progress
			fwd_appl	sql_variant	Forward Application
			fwd_rate	bigint	Forward Rate
	CI_CICIVwutllmt_tmp		guid	sql_variant	Guid
			Customer_code		Customer Code
			Acc_balance	bigint	Account Balance
			Ordinprog		Order in Progress
			Utilizedlmt		Utilized Limit
	ci_comp_sr_metdata_mst	Metadata table that contains the All the authorization service name across all the components.	component_id	sql_variant	Component Id	Yes
			service_name		Service Name
	ci_cur_bal_tmp		guid		Guid	No
			cust_code		Customer Code
			currency		Currency
			due_amount	bigint	Due Amount
	ci_cust_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
			customer_code		Customer Code
			cust_name		Customer Name
			account_code		Account Code
			account_type		Account Type
			acct_currency		Account Currency
			pr_cr_tran_amount	bigint	Credit Transaction Amount
			pr_dr_tran_amount		Debit Transaction Amount
			pr_cr_base_amount		Credit Base Amount
			pr_dr_base_amount		Debit Base Amount
			pr_cr_pab_amount		Credit Parallel Base Amount
			pr_dr_pab_amount		Debit Parallel Base Amount
			op_balance_tran		Opening Balance Transaction
			op_balance_base		Opening Balance Base
			op_balance_pab		Opening Parallel Base Amount
			tran_drcr_flag	sql_variant	Transaction Debit Credit Flag
			base_drcr_flag		Base Debit Credit Flag
			pab_drcr_flag		Parallel Base Amount Credit / Debit 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
			addr_addrline1		Address Line1
			addr_addrline2		Address Line2
			addr_addrline3		Address Line3
			addr_city		City
			addr_state		State
			addr_country		Country
			addr_zip		Zip
			addr_phone		Phone
			addr_email		Email
			addr_fax		Fax
			customer_group		Customer Group
	ci_cust_bal_sim_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			tran_currency		Transaction Currency
			balance_type		Balance Type
			balance_currency		Balance Currency
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			cust_code		Customer 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		Account Currency
			bal_base_curr		Base Currency
			bal_pbase_curr		Parallel Base Currency
			acc_desc	sql_variant	Account Description
			cust_name		Customer 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 in Parallel Base Currency
			exch_gl_pbase		Exchange General Ledger Parallel Base
			exch_gl_pper		Exchange General Ledger Base
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ci_cust_balance	Table that maintains the customer opening ,closing and period balances for all the periods.	ou_id	int	Organization Unit Id	Yes
			company_code	sql_variant	Company Code
			fb_id		Finance Book Id
			fin_year		Finance Year
			fin_period		Finance Period
			cust_code		Customer Code
			account_code		Account Code
			currency_code		Currency Code
			balance_type		Balance Type
			balance_currency		Balance Currency
			timestamp	int	Time Stamp	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
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			batch_id	sql_variant	Batch Id
			account_type		Account Type
	ci_customer_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
			customer_code	sql_variant	Customer 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 Balance
	ci_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
			cust_ou	int	Customer Organization Unit
			cust_code	sql_variant	Customer Code
			cust_name		Customer Name
			cust_inv_no		Customer Invoice Number
			pay_term		Pay Term
			payterm_version	int	Pay Term Version
			doc_status	sql_variant	Document Status
			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 Applicable
			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 Accounting 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	Organization Unit
			ref_doc_fb_id	sql_variant	Finance Book Id
			ref_doc_type		Document Type
			ref_doc_no		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
	ci_doc_balance	Table that maintains the outstanding amounts for each documents numbers	tran_ou	int	Transaction Organization Unit	Yes
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			term_no		Term Number
			timestamp	int	Time Stamp	No
			batch_id	sql_variant	Batch Id
			lo_id		Logistics Organization Id
			tran_currency		Transaction Currency
			basecur_erate	bigint	Base Currency Exchange Rate
			base_amount		Base Amount
			tran_amount		Transaction Amount
			par_exchange_rate		Parallel Exchange Rate
			par_base_amount		Parallel Base Amount
			doc_status	sql_variant	Document Status. Values HL -Held, RL -Released,AU -Authorized, RV -Reversed, TR -To Be Reversed, PA -Paid, VO -Void, RQ -Requested, DP -Deposited, BO -Bounced
			adjustment_status		Adjustment Status. Values Adjustment Status. Values Adj-Adjusted, Padj- Partially adjusted
			unadjusted_amt	bigint	Other Than Adjustment Status
			paid_amt		Paid Amount
			disc_availed		Discount Availed
			written_off_amt		Writtern Off Amount
			provision_amt_cm		Provision Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			due_no_cm	int	Due Number
			discount_amount	bigint	Discount Amount
			adjusted_amount		Adjusted Amount
			received_amount		Received Amount
			penalty_amount		Penalty Amount
			write_back_amount		Write Back Amount
			vat_amount		Value Added Tax Amount
			outstanding_amount		Outstanding Amount
			pay_term	sql_variant	Pay Term
			recpt_consumed	bigint	Receipt Consumed
			rv_amount		Reverse Amount
			cpi_cr_unadj_amount		Credit Unadjusted Amount
			payterm_version	int	Pay Term Version
			charges_amount	bigint	Charges Amount
			cr_adj_amount		Credit Adjusted Amount
	ci_doc_balance_matrix		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
			timestamp	int	Time Stamp	No
			multiplicn_factor		Multiplication Factor
			multiplicn_factor_cr		Multiplication Factor Credit
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ci_doc_hdr	Table that contains the document number and documents status and adjustment and paid status 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
			lo_id	sql_variant	Logistics Organization Id
			batch_id		Batch Id
			fb_id		Finance Book Id
			cust_code		Customer Code
			tran_currency		Transaction Currency
			tran_amount	bigint	Transaction Amount
			basecur_erate		Base Currency Exchange Rate
			par_exchange_rate		Parallel Exchange Rate
			doc_status	sql_variant	Document Status. Values HL -Held, RL -Released, AU -Authorized, RV -Reversed, TR -To Be Reversed, PA -Paid, VO -Void, RQ -Requested, DP -Deposited, BO -Bounced
			instr_no		Instrument Number
			instr_date	datetime	Instrument Date
			instr_status	sql_variant	Instrument Status. Values R -Realized D -Deposited,B -Bounced
			reason_code		Reason Code
			ps_gen_flag		General Flag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			pay_term	sql_variant	Pay Term
			due_amount	bigint	Due Amount
			received_amount		Receiver Amount
			adjusted_amount		Adjusted Amount
			discount_amount		Discount Amount
			discount_availed		Discount Availed
			penalty_amount		Penalty Amount
			write_off_amount		Write Off Amount
			write_back_amount		Write Back Amount
			paid_amount		Paid Amount
			reversed_docno	sql_variant	Reversed Document Number
			reversal_date	datetime	Reversal Date
			adjustment_status	sql_variant	Adjustment Status. Values Values Adj-Adjusted, Padj- Partially adjusted
			provision_amount_cm	bigint	Provision Amount
			tran_date	datetime	Transaction Date
			company_code	sql_variant	Company Code
			bank_code		Bank Code
			payterm_version	int	Pay Term Version
			transfer_status	sql_variant	Transfer Status
			vat_incorporate_flag		Value Added Tax Incorporate Flag
			Forward_cover		Forward Cover
			Fw_cov_flag		Forward Cover Flag
			Fw_cov_rate	bigint	Forward Cover Rate
	ci_doc_item_dtl	Maintains the item amount for each document’s	tran_type	sql_variant	Transaction Type	Yes
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Number
			line_no	int	Line Number
			timestamp		Time Stamp	No
			batch_id	sql_variant	Batch Id
			component_id		Component Id
			company_code		Company Code
			lo_id		Logistics Organization Id
			item_tcd_code		Item Tax Charge Discount Code
			item_tcd_var		Item Tax Charge Discount Variant
			visible_line_no	int	Visible Line Number
			so_no	sql_variant	Supplier Order Number
			so_ou	int	Supplier Order Organization Unit
			ref_doc_no	sql_variant	Reference Document Number
			ref_doc_date	datetime	Reference Document Date
			ref_doc_ou	int	Reference Document Organization Unit
			ship_to_cust	sql_variant	Ship To Customer
			ship_to_id		Ship To Id
			uom		Unit Of Measurement
			item_qty	bigint	Item Quantity
			unit_price		Unit Price
			item_amount		Item Amount
			remarks	sql_variant	Remarks
			item_type		Item Type
			tax_amount	bigint	Tax Amount
			disc_amount		Discount Amount
			line_amount		Line Amount
			base_amount		Base Amount
			par_base_amount		Parallel Base Amount
			cost_center	sql_variant	Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			item_tcd_desc	sql_variant	Item Tax Charge Discount Description
			sale_purpose		Sales Purpose
			warehouse_code		Ware House Code
			alloc_method		Allocation Method
			attr_alloc		Attribute Allocation
			proposal_no		Proposal Number
			shipping_ou	int	Shipping Organization Unit
			ship_to_cust_name	sql_variant	Ship To Customer Name
			packslip_no		Pack Slip Number
			ref_doc_type		Reference Document Type
			po_ou	int	Purchase Order Organization Unit
	ci_doc_payterm_dtl	Table contains the payterm and the due_amount for each document number	tran_type	sql_variant	Transaction Type	Yes
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Number
			pay_term		Pay Term
			term_no		Term Number
			timestamp	int	Time Stamp	No
			lo_id	sql_variant	Logistics Organization Id
			batch_id		Batch Id
			component_id		Component Id
			company_code		Company Code
			due_date	datetime	Due Date
			due_amount_type	sql_variant	Due Amount Type
			due_percent	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_percent	bigint	Discount Percent
			disc_amount		Discount Amount
			penalty_percent		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
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			payterm_version	int	Pay Term Version
	ci_open_tran_input_tmp		batch_id	sql_variant	Batch Id	Yes
			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
			timestamp	int	Time Stamp	No
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ci_open_tran_prd_tmp		batch_id	sql_variant	Batch Id	Yes
			componentid		Component Id
			finyr_code		Finance Year Code
			finprd_code		Finance Period Code
			timestamp	int	Time Stamp	No
			status	sql_variant	Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ci_open_tran_tmp		batch_id	sql_variant	Batch Id
			componentid		Component Id
			tran_type		Transaction Type
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Number
			timestamp	int	Time Stamp
			tran_date	datetime	Transaction Date
			status	sql_variant	Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			tran_desc	sql_variant	Transaction Description
	ci_posted_doc_log	Table that contains the posting amount for each documents	tran_ou	int	Transaction Organization Unit
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			term_no		Term Number
			amt_type	varchar(10)	Amount Type
			ref_doc_ou	int	Reference Document Organization Unit
			ref_doc_type	sql_variant	Reference Document Type
			ref_doc_no		Reference Document Number
			ref_doc_term		Reference Document Term
			adjd_doc_ou	int	Adjusted Document Organization Unit
			adjd_doc_type	sql_variant	Adjusted Document Type
			adjd_doc_no		Adjusted Document Number
			adjd_doc_term		Adjusted Document Term
			createddate	datetime	Created Date
			timestamp	int	Time Stamp
			lo_id	sql_variant	Logistics Organization Id
			batch_id		Batch Id
			tran_date	datetime	Transaction Date
			cust_code	sql_variant	Customer Code
			tran_currency		Transaction Currency
			tran_amount	bigint	Transaction Amount
			basecur_erate		Base Currency Exchange Rate
			base_amount		Base Amount
			par_exchange_rate		Parallel Exchange Rate
			par_base_amount		Parallel Base Amount
			ref_doc_date	datetime	Reference Document Date
			ref_doc_cur	sql_variant	Reference Document Currency
			createdby		Created By
			posting_status		Posting Status. Values P-Posted
			posting_date	datetime	Posting Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			adjust_amount_inv_cur	bigint	Adjusted Amount in Invoice Currency
			crosscur_erate		Cross Currency Exchange Rate
	ci_repsrm_cst_dtl		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			customercode		Customer Code
			customername		Customer Name
			address		Address
			address1		Address 1
			address2		Address 2
			contact_per		Contact Person
			grouptypecode		Group Type Code
			customergroupcode		Customer Group Code
			companycode		Company Code
			codescription		Code Description
			buid		Business Unit Id
			budescription		Business Unit Description
			transactiontype		Transaction Type
			currency		Currency
			documentnumber		Document Number
			docdate	datetime	Document Date
			custdocrefno	sql_variant	Customer Document Reference Number
			amount	bigint	Amount
			outstandingamount		Outstanding Amount
			duedate	datetime	Due Date
			instrumentnumber	sql_variant	Instrument Number
			instrumentdate	datetime	Instrument Date
			openingbalance	bigint	Opening Balance
			balancedue		Balance Due
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ci_repsrm_cst_smry		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			customercode		Customer Code
			customername		Customer Name
			address		Address
			address1		Address 1
			address2		Address 2
			contact_per		Contact Person
			grouptypecode		Group Type Code
			customergroupcode		Customer Group Code
			companycode		Company Code
			openingbalance	bigint	Opening Balance
			billingamount		Billing Amount
			paymentamount		Payment Amount
			advanceamount		Advance Amount
			unadjustrecptamt		Other Than Adjusted Receipt Amount
			closingbalance		Closing Balance
			depositamount		Deposit Amount
			currency	sql_variant	Currency
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ci_sim_balance_tmp		batch_id	sql_variant	Batch Id
			account_code		Account Code
			cust_code		Customer Code
			currencycode		Currency Code
			balance_currency		Balance Currency
			timestamp	int	Time Stamp
			erate_base	bigint	Exchange Rate Base
			erate_par		Exchange Rate Parallel
			bal_acc		Balance Account
			bal_base		Balance Base
			bal_par		Balance Parallel
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ci_sim_cur_revalue_tmp		batch_id	sql_variant	Batch Id
			account_code		Account Code
			cust_code		Customer Code
			currencycode		Currency Code
			balance_currency		Balance Currency
			timestamp	int	Time Stamp
			erate_base	bigint	Exchange Rate Base
			erate_par		Exchange Rate Parallel
			bal_acc		Balance Account
			bal_base		Balance Base
			sim_bal_base		Simple Balance Base
			gain_loss_base		Gain Loss Base
			gain_loss_per_base		Gain Loss Per Base
			bal_par		Balance Parallel
			sim_bal_par		Simple Balance Parallel
			gain_loss_par		Gain Loss Parent
			gain_loss_per_par		Gain Loss Per Parent
			account_code_des	sql_variant	Account Code Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ci_simulate_balance_tmp		batch_id	sql_variant	Batch Id	Yes
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			fb_id		Finance Book Id
			fin_year		Finance Year
			fin_period		Finance Period
			cust_code		Customer Code
			account_code		Account Code
			currency_code		Currency Code
			balance_type		Balance Type
			balance_currency		Balance Currency
			timestamp	int	Time Stamp	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
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			account_type	sql_variant	Account Type
			ctrlact_type		Control Account Type
	ci_vat_inc_out_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			fb_id		Finance Book Id
			from_date	datetime	From Date
			to_date		To Date
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ci_vdec_catclass_acct_tmp		guid	sql_variant	Guid
			company_code		Company Code
			tran_ou	int	Transaction Organization Unit
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			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
			vatable_amount		Value Added Taxable Amount
			account_code	sql_variant	Account Code
			usage_flag		Usage Flag
			drcr_flag		Debit Credit Flag
			acct_type		Account Type
			vat_line_no	int	Value Added Tax Line Number
	ci_vdec_category_class_tmp		company_code	sql_variant	Company Code
			tran_ou	int	Transaction Organization Unit
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			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
			vatable_item_amount		Value Added Taxable Item Amount
			vatable_charge_amount		Value Added Taxable Charge Amount
			vatable_dist_amount		Vatable Distributed Amount
			nonvatable_item_amount		Other Than Value Added Taxable Item Amount
			vatded_item_amount		Value Added Tax Deduction Item Amount
			vatded_charge_amount		Value Added Tax Deduction Charge Amount
			vatded_dist_amount		Vated Distributed Amount
			vatnonded_item_amount		Other Than Value Added Tax Deduction Item Amount
			vatnonded_charge_amount		Other Than Value Added Tax Deduction Charge Amount
			vatnonded_dist_amount		Other Than Value Added Tax Deduction Distribution Amount
			guid	sql_variant	Guid
			vat_line_no	int	Value Added Tax Line Number
			doc_line_no		Document Line Number
	ci_vdec_docinfo_tmp		company_code	sql_variant	Company Code
			buid		Business Unit Id
			component_id		Component Id
			fbid		Finance Book Id
			tran_ou	int	Transaction Organization Unit
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			tran_date	datetime	Transaction Date
			supp_cust_code	sql_variant	Supplier Customer Code
			tranIO		Transaction Input / Output
			weightage_factor	bigint	Weightage Factor
			doc_satus	sql_variant	Document Status
			guid		Guid
	rm_ci_ibe_acc_dtl_tmp
			acc_code		Account Code
			currency		Currency
			fb		Finance Book
			tranamount	bigint	Transaction Amount
			baseamount		Base Amount
			pbamount		Parallel Base Amount
			acc_type	sql_variant	Account Type
	rm_ci_ibe_error_log		guid		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
	rm_ci_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_rm	bigint	Transaction Balance
			bc_bal_rm		Base Currency Balance RM
			pbc_bal_rm		Parallel Base Currency Balance RM
			tran_bal_bk		Transaction Balance Backup
			bc_bal_bk		Base Currency Balance BK
			pbc_bal_bk		Parallel Base Currency Balance Backup
	rm_ci_ibe_tran_tmp		guid	sql_variant	Guid
			tran_ou	int	Transaction Organization Unit
			fb	sql_variant	Finance Book
			line_no	int	Line Number
			tran_no	sql_variant	Transaction Number
			tran_type		Transaction Type
			tran_date	datetime	Transaction Date
			customer_code	sql_variant	Customer Code
			tran_curr		Transaction Currency
			tran_amount	bigint	Transaction Amount
			tran_outstand_amt		Transaction Outstanding Amount
			due_date	datetime	Due Date
			bank_cash_code	sql_variant	Bank Cash Code
			base_amount	bigint	Base Amount
			base_outstand_amt		Base Outstanding Amount
			pbc_amount		Parallel Base Currency Amount
			pbc_outstand_amt		Parallel Base Currency Outstanding Amount
			rec_acc_code	sql_variant	Receipt Account Code
			deposit_acc_code		Deposit Account Code
			prepay_acc_code		Prepay Account Code
			prepay_deposit_flag		Prepay Deposit Flag
			process_flag		Process Flag
	rm_ci_ibe_transactions_tmp		guid		Guid
			tran_ou		Transaction Organization Unit
			fb		Finance Book
			acc_code		Account Code
			line_no	int	Line Number
			tran_no	sql_variant	Transaction Number
			tran_type		Transaction Type
			tran_date	datetime	Transaction Date
			customer_code	sql_variant	Customer Code
			tran_curr		Transaction Currency
			tran_amount	bigint	Transaction Amount
			tran_outstand_amt		Transaction Outstanding Amount
			due_date	datetime	Due Date
			bank_cash_code	sql_variant	Bank Cash Code
			base_amount	bigint	Base Amount
			base_outstand_amt		Base Outstanding Amount
			pbc_amount		Parallel Base Currency Amount
			pbc_outstand_amt		Parallel Base Currency Outstanding Amount
			prepay_deposit_flag	sql_variant	Prepay Deposit Flag
	ci_prepay_adj_hdr		guid	sql_variant	A unique key
			tranou	int	Transaction Ou
			trantype	sql_variant	Transaction Type
			tranno		Transaction Number
			refdocou	int	Reference Document OU
			refdocno	sql_variant	Reference Document Number
			fbid		Finance Book ID
			billtocustno		Customer Code
			invdate	datetime	Invoice Date
			invcurrency	sql_variant	Invoice Currency
			exchrate	bigint	Exchange Rate
			tranamt		Transaction Amount
			line_no	int	Line Number
			itemamt	bigint	Item Amount
			adjtcdamt		Adjusted TCD Amount
			status	sql_variant	Status
	ci_prepay_tcd_dtl		guid	sql_variant	A unique key
			tranou	int	Transaction Ou
			trantype	sql_variant	Transaction Type
			tranno		Transaction Number
			refdocou	int	Reference Document OU
			refdocno	sql_variant	Reference Document Number
			fbid		Finance Book ID
			tcdcurrcode		TCD Currency Code
			line_no	int	Line Number
			tcdcode	sql_variant	TCD Code
			tcdvar		TCD Variant
			tcdamt	bigint	TCD Amount
			adjtcdamt		Adjusted TCD Amount
			seqno	int	Sequence Number
	ci_prepay_adj_dtl		guid	sql_variant	A unique key
			tranou	int	Transaction Ou
			trantype	sql_variant	Transaction Type
			tranno		Transaction Number
			fbid		Finance Book ID
			adjvouchno		Adjustment Voucher Number
			adjdate	datetime	Adjustment Date
			adjamt	bigint	Adjustment Amount
			drdocno	sql_variant	Debit Document Number
			drdocdate	datetime	Debit Document Date
			drdocamt	bigint	Debit Document Amount
			status	sql_variant	Status
			seqno	int	Sequence Number