Data Dictionary -- Customer Inquiry

Srl. No.	Table Name	Comment
1	ci_acct_balance_matrix	To store Account balance matrix
2	ci_acct_info_dtl	To store account information detail
3	ci_bal_inq	To store balance inquiry
4	ci_bal_inq_smry	To store balance inquiry summary
5	ci_cbadj_crdoc	To store information of credit documents voucher number and adjustment amounts
6	ci_cbadj_crdrdoc	To store information of credit and debit documents voucher number and adjustment amounts
7	ci_cbadj_drdoc	To store information of bebit documents voucher number and adjustment amounts
8	CI_CICIVWORD_ORDDET_DTL	To store information of order detail
9	ci_comp_sr_metdata_mst	To store information of metadata detail
10	ci_cust_balance	To store costomer balance
11	ci_doc_balance	To store document balance
12	ci_doc_balance_matrix	To store document balance matrix
13	ci_doc_hdr	To store document header
14	ci_doc_item_dtl	To store document item detail
15	ci_doc_payterm_dtl	To store document payterm detail
16	ci_posted_doc_log	To store posted document log
17	ci_prepay_adj_dtl	To store prepayment adjacent detail
18	ci_prepay_adj_hdr	To store prepayment adjacent header
19	ci_prepay_tcd_dtl	To store prepayment tcd detail
20	ci_repsrm_cst_dtl	To store detail of customers
21	ci_repsrm_cst_smry	To store customer summary detail
22	ci_taxinvoice_dtl	To store tax details for an invoice

Table Name :	ci_acct_balance_matrix
Comment :	To store Account balance matrix

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
guid	fin_guid	varchar(40)	No	Guid	Yes
tran_currency	fin_currency	varchar(5)	No	Transaction currency	Yes
balance_type	fin_desxc40	varchar(40)	No	Balance type	Yes
balance_currency	fin_currency	varchar(5)	No	Balance currency	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	ci_acct_info_dtl
Comment :	To store account information detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_ou	fin_ouinstid	int(4)	No	Transaction OU	Yes
tran_type	fin_cmntrantype	varchar(10)	No	Transaction type	Yes
tran_no	fin_documentno	varchar(40)	No	Transaction number	Yes
component_id	fin_component	varchar(16)	No	Component id	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
drcr_flag	fin_drcridentifier	varchar(6)	No	Debit credit flag	Yes
line_no	fin_number	int(4)	No	Line number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
lo_id	fin_loid	varchar(20)	Yes	lo id	No
txnou_id	fin_ouinstid	int(4)	Yes	txnou_id	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
tran_qty	fin_quantity	numeric(17)	Yes	Transaction quantity	No
tran_amount_acc_cur	fin_amount	numeric(13)	Yes	Transaction amount account currency	No
ctrl_acct_type	fin_accounttype	varchar(15)	Yes	Control account type	No
auto_post_acct_type	fin_accounttype	varchar(15)	Yes	Auto post account type	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanlyis code	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank code	No
item_code	fin_itemcode	varchar(40)	Yes	Item code	No
item_variant	fin_variant	varchar(8)	Yes	Item variant	No
uom	fin_uom	varchar(15)	Yes	Uom	No
supcust_code	fin_customer_id	varchar(18)	Yes	Supplier customer code	No
acct_currency	fin_currencycode	varchar(5)	Yes	Account currency	No
basecur_erate	fin_exchangerate	numeric(9)	Yes	Base currency exchange rate	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
narration	fin_text255	varchar(255)	Yes	Narration	No
auth_date	fin_datetime	datetime(8)	Yes	Author date	No
ref_doc_ou	fin_ouinstid	int(4)	Yes	Reference document Ou	No
ref_doc_fb_id	fin_financebookid	varchar(20)	Yes	Reference document finance book id	No
ref_doc_type	fin_cmntrantype	varchar(10)	Yes	Reference document type	No
ref_doc_no	fin_documentnumber	varchar(18)	Yes	Reference document number	No
vat_decl_year	fin_financeyear	varchar(15)	Yes	Vat declared year	No
vat_decl_period	fin_financeperiod	varchar(15)	Yes	Vat declared period	No
vat_usage_flag	fin_chkflag	varchar(1)	Yes	Vat usage flag	No
vat_category	fin_vatcategory	varchar(40)	Yes	Vat category	No
vat_class	fin_vatclass	varchar(40)	Yes	Vat class	No
vat_code	fin_vatclass	varchar(40)	Yes	Vat code	No
vat_rate	fin_finrate	numeric(9)	Yes	Vat rate	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
posting_date	fin_datetime	datetime(8)	Yes	Posting date	No
posting_status	fin_chkflag	varchar(1)	Yes	Posting status	No
base_currency	fin_currencycode	varchar(5)	Yes	Base currency	No
par_base_currency	fin_currencycode	varchar(5)	Yes	Parallel base currency	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
vat_posting_flag	fin_chkflag	varchar(1)	Yes	Vat posting flag	No
vat_posting_date	fin_datetime	datetime(8)	Yes	Vat posting date	No
account_type	fin_accounttype	varchar(15)	Yes	Account type	No
vat_line_no	fin_lineno	int(4)	Yes	Vat line number	No
ref_doc_lineno	fin_lineno	int(4)	Yes	Reference document line number	No
expense_class	fin_quickcode	varchar(20)	Yes	Expense class	No

Table Name :	ci_bal_inq
Comment :	To store balance inquiry

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
bu	fin_buid	varchar(20)	Yes	Business unit id	No
custgrptype	fin_identificationnumber1	varchar(5)	Yes	Customer group type	No
custgrpcode	fin_code	varchar(6)	Yes	Customer group code	No
custcode	fin_customer_id	varchar(18)	Yes	Customer code	No
custname	fin_custname	varchar(40)	Yes	Customer name	No
tran_type	fin_trantype	varchar(40)	Yes	Transaction type	No
documentno	fin_documentnumber	varchar(18)	Yes	Document number	No
docdate	fin_date	datetime(8)	Yes	Document date	No
fbid	fin_financebookid	varchar(20)	Yes	Financebook id	No
cust_doc_refno	fin_documentnumber	varchar(18)	Yes	Customer document reference number	No
docamount	fin_amount	numeric(13)	Yes	Document amount	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
unadjustedamt	fin_amount	numeric(13)	Yes	Unadjusted amount	No
unadjustedamt_base	fin_amount	numeric(13)	Yes	Unadjusted amount base	No
guid	fin_guid	varchar(40)	Yes	Guid	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	ci_bal_inq_smry
Comment :	To store balance inquiry summary

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
bu	fin_buid	varchar(20)	Yes	Business unit id	No
custgrptype	fin_identificationnumber1	varchar(5)	Yes	Customer group type	No
custgrpcode	fin_code	varchar(6)	Yes	Customer group code	No
custcode	fin_customer_id	varchar(18)	Yes	Customer code	No
total_bill_amt	fin_amount	numeric(13)	Yes	Total bill amount	No
total_rcpt_amt	fin_amount	numeric(13)	Yes	Total receipt amount	No
balance_due_amt	fin_amount	numeric(13)	Yes	Balace due amount	No
guid	fin_guid	varchar(40)	Yes	Guid	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	ci_cbadj_crdoc
Comment :	To store information of credit documents voucher number and adjustment amounts

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
custcode	fin_customer_id	varchar(18)	Yes	Customer code	No
adj_voucher_no	fin_documentnumber	varchar(18)	Yes	Adjusted voucher number	No
documentno	fin_documentnumber	varchar(18)	Yes	Document number	No
tran_type	fin_trantype	varchar(40)	Yes	Transaction type	No
docdate	fin_date	datetime(8)	Yes	Document date	No
currency	fin_currency	varchar(5)	Yes	Currency	No
docamount	fin_amount	numeric(13)	Yes	Document amount	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
adjustedamt	fin_amount	numeric(13)	Yes	Adjusted amount	No
adjustedamt_base	fin_amount	numeric(13)	Yes	Adjusted amount base	No
adjustedamt_parbase	fin_amount	numeric(13)	Yes	Adjusted amount parallel base	No
guid	fin_guid	varchar(40)	Yes	Guid	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_buid	varchar(20)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	ci_cbadj_crdrdoc
Comment :	To store information of credit and debit documents voucher number and adjustment amounts

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
custcode	fin_customer_id	varchar(18)	Yes	Customer code	No
custname	fin_custname	varchar(40)	Yes	Customer name	No
currency	fin_currency	varchar(5)	Yes	Currency	No
tran_type	fin_trantype	varchar(40)	Yes	Transaction type	No
documentno	fin_documentnumber	varchar(18)	Yes	Document number	No
docdate	fin_datetime	datetime(8)	Yes	Document date	No
docamount	fin_amount	numeric(13)	Yes	Document amount	No
adjustedamt	fin_amount	numeric(13)	Yes	Adjusted amount	No
dueamount	fin_amount	numeric(13)	Yes	Due amount	No
ref_doc_type	fin_trantype	varchar(40)	Yes	Reference document type	No
ref_doc_no	fin_documentnumber	varchar(18)	Yes	Reference document number	No
adj_voucher_no	fin_documentnumber	varchar(18)	Yes	Adjusted voucher number	No
guid	fin_guid	varchar(40)	Yes	Guid	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	ci_cbadj_drdoc
Comment :	To store information of bebit documents voucher number and adjustment amounts

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
custcode	fin_customer_id	varchar(18)	Yes	Customer code	No
adj_voucher_no	fin_documentnumber	varchar(18)	Yes	Adjusted voucher number	No
documentno	fin_documentnumber	varchar(18)	Yes	Document number	No
tran_type	fin_trantype	varchar(40)	Yes	Transaction type	No
docdate	fin_date	datetime(8)	Yes	Document date	No
currency	fin_currency	varchar(5)	Yes	Currency	No
dueamount	fin_amount	numeric(13)	Yes	Due amount	No
dueamount_base	fin_amount	numeric(13)	Yes	Due amount base	No
adjustedamt	fin_amount	numeric(13)	Yes	Adjusted amount	No
adjustedamt_base	fin_amount	numeric(13)	Yes	Adjusted amount base	No
written_off_amt_base	fin_amount	numeric(13)	Yes	Written off amount base	No
written_off_amt_parbase	fin_amount	numeric(13)	Yes	Written off amount parallel base	No
write_back_amount_base	fin_amount	numeric(13)	Yes	Written back amount base	No
write_back_amount_parbase	fin_amount	numeric(13)	Yes	Written back amount parallel base	No
exch_gainloss_amt_base	fin_amount	numeric(13)	Yes	Exchange gain loss amount base	No
exch_gainloss_amt_parbase	fin_amount	numeric(13)	Yes	Exchange gain loss amount parallel base	No
guid	fin_guid	varchar(40)	Yes	Guid	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	CI_CICIVWORD_ORDDET_DTL
Comment :	To store information of order detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Guid	fin_guid	varchar(40)	No	Guid	No
CustCode	udd_customer_id	varchar(18)	Yes	Customer Code	No
ref_doc_type	fin_doctype	varchar(40)	Yes	Reference document type	No
ref_doc_no	fin_docuemntno	varchar(18)	Yes	Rference document number	No
Ord_curr	fin_currency	varchar(5)	Yes	Order currency	No
ORD_MAT	fin_amount	numeric(13)	Yes	ORD_MAT	No
ORD_RES	fin_amount	numeric(13)	Yes	ORD_RES	No
ORD_OTH	fin_amount	numeric(13)	Yes	ORD_OTH	No
ORD_TOT	fin_amount	numeric(13)	Yes	ORD_TOT	No
INV_MAT	fin_amount	numeric(13)	Yes	INV_MAT	No
INV_RES	fin_amount	numeric(13)	Yes	INV_RES	No
INV_OTH	fin_amount	numeric(13)	Yes	INV_OTH	No
INV_TOT	fin_amount	numeric(13)	Yes	INV_TOT	No
ORDINPROG_ORDCURR	fin_amount	numeric(13)	Yes	ORDINPROG_ORDCURR	No
EXCH_RATE	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
ORDINPROG	fin_amount	numeric(13)	Yes	ORDINPROG	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	ci_comp_sr_metdata_mst
Comment :	To store information of metadata detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
component_id	fin_component	varchar(16)	No	Component id	Yes
service_name	fin_ctxt_service	varchar(32)	No	Service name	Yes

Table Name :	ci_cust_balance
Comment :	To store costomer balance

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fin_year	fin_financeyear	varchar(15)	No	Financial year	Yes
fin_period	fin_financeperiod	varchar(15)	No	Financial period	Yes
cust_code	fin_customer_id	varchar(18)	No	Customer code	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency code	Yes
balance_type	fin_currencycode	varchar(5)	No	Balance type	Yes
balance_currency	fin_currencycode	varchar(5)	No	Balalce currency	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
ob_credit	fin_amount	numeric(13)	Yes	Order base credit	No
ob_debit	fin_amount	numeric(13)	Yes	Order base debit	No
period_credit	fin_amount	numeric(13)	Yes	Period credit	No
period_debit	fin_amount	numeric(13)	Yes	Period debit	No
cb_credit	fin_amount	numeric(13)	Yes	cb credit	No
cb_debit	fin_amount	numeric(13)	Yes	cb debit	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
account_type	fin_account_type	varchar(10)	Yes	Account type	No

Table Name :	ci_doc_balance
Comment :	To store document balance

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_ou	fin_ouinstid	int(4)	No	Transaction OU	Yes
tran_type	fin_cmntrantype	varchar(10)	No	Transaction type	Yes
tran_no	fin_documentno	varchar(40)	No	Transaction number	Yes
term_no	fin_termnumber	varchar(20)	No	Term number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
lo_id	fin_loid	varchar(20)	Yes	lo id	No
tran_currency	fin_currency	varchar(5)	Yes	Transaction currency	No
basecur_erate	fin_exchangerate	numeric(9)	Yes	Base currency exchange rate	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Prarallel exchange rate	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
doc_status	fin_status	varchar(25)	Yes	Document status	No
adjustment_status	fin_status	varchar(25)	Yes	Adjustment status	No
unadjusted_amt	fin_amount	numeric(13)	Yes	Unadjusted amount	No
paid_amt	fin_amount	numeric(13)	Yes	Paid amount	No
disc_availed	fin_amount	numeric(13)	Yes	Discount availed	No
written_off_amt	fin_amount	numeric(13)	Yes	Writtne off amount	No
provision_amt_cm	fin_amount	numeric(13)	Yes	Provision amount cm	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
due_no_cm	fin_number	int(4)	Yes	Due number cm	No
discount_amount	fin_amount	numeric(13)	Yes	Discount amount	No
adjusted_amount	fin_amount	numeric(13)	Yes	Adjusted amount	No
received_amount	fin_amount	numeric(13)	Yes	Received amount	No
penalty_amount	fin_amount	numeric(13)	Yes	Penalty amount	No
write_back_amount	fin_amount	numeric(13)	Yes	Write back amount	No
vat_amount	fin_amount	numeric(13)	Yes	Vat amount	No
outstanding_amount	fin_amount	numeric(13)	Yes	Outstanding amount	No
pay_term	fin_quickcodes	varchar(25)	Yes	Pay term	No
recpt_consumed	fin_amount	numeric(13)	Yes	Receipt consumed	No
rv_amount	fin_amount	numeric(13)	Yes	Receive amount	No
cpi_cr_unadj_amount	fin_amount	numeric(13)	Yes	cpi credit unadjusted amount	No
payterm_version	fin_lineno	int(4)	Yes	Payterm version	No
charges_amount	fin_amount	numeric(13)	Yes	Charges amount	No
cr_adj_amount	fin_amount	numeric(13)	Yes	Credit adjusted amount	No
cpi_cr_amount	fin_amount	numeric(13)	Yes	CPI Credit amount	No

Table Name :	ci_doc_balance_matrix
Comment :	To store document balance matrix

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_type	fin_cmntrantype	varchar(10)	No	Transaction type	Yes
amt_type	fin_currency	varchar(5)	No	Amount type	Yes
ref_tran_type	fin_cmntrantype	varchar(10)	No	Reference transaction type	Yes
output_val	fin_customersode	varchar(16)	No	Output value	Yes
output_val_cr	fin_customersode	varchar(16)	No	Output value credit	Yes
tran_type_cr	fin_cmntrantype	varchar(10)	No	Transaction type credit	Yes
timestamp	fin_timestamp	int(4)	Yes	Timestamp	No
multiplicn_factor	fin_number	int(4)	Yes	Multiplication factor	No
multiplicn_factor_cr	fin_number	int(4)	Yes	Multiplication factor credit	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	ci_doc_hdr
Comment :	To store document header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_ou	fin_ouinstid	int(4)	No	Transaction OU	Yes
tran_type	fin_cmntrantype	varchar(10)	No	Transaction type	Yes
tran_no	fin_documentno	varchar(40)	No	Transaction number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
lo_id	fin_loid	varchar(20)	Yes	lo id	No
batch_id	fin_guid	varchar(40)	No	Batch id	Yes
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
cust_code	fin_customer_id	varchar(18)	Yes	Customer code	No
tran_currency	fin_currency	varchar(5)	Yes	Transaction currency	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
basecur_erate	fin_exchangerate	numeric(9)	Yes	Base currency exchange rate	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
doc_status	fin_status	varchar(25)	Yes	Document status	No
instr_no	fin_checknumber	varchar(30)	Yes	Instrumnet number	No
instr_date	fin_datetime	datetime(8)	Yes	Instrument date	No
instr_status	fin_status	varchar(25)	Yes	Instrument status	No
reason_code	fin_reasoncode	varchar(10)	Yes	Reason code	No
ps_gen_flag	fin_chkflag	varchar(1)	Yes	ps generation flag	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
pay_term	fin_quickcodes	varchar(25)	Yes	Pay term	No
due_amount	fin_amount	numeric(13)	Yes	Due amount	No
received_amount	fin_amount	numeric(13)	Yes	Received amount	No
adjusted_amount	fin_amount	numeric(13)	Yes	Adjusted amount	No
discount_amount	fin_amount	numeric(13)	Yes	Discount amount	No
discount_availed	fin_amount	numeric(13)	Yes	Discount availed	No
penalty_amount	fin_amount	numeric(13)	Yes	Penalty amount	No
write_off_amount	fin_amount	numeric(13)	Yes	Write off amount	No
write_back_amount	fin_amount	numeric(13)	Yes	Write back amount	No
paid_amount	fin_amount	numeric(13)	Yes	Paid amount	No
reversed_docno	fin_documentno	varchar(40)	Yes	Reversed document number	No
reversal_date	fin_datetime	datetime(8)	Yes	Reversal date	No
adjustment_status	fin_status	varchar(25)	Yes	Adjustment status	No
provision_amount_cm	fin_amount	numeric(13)	Yes	Provision amount cm	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank code	No
payterm_version	fin_lineno	int(4)	Yes	Payterm version	No
transfer_status	fin_status	varchar(25)	Yes	Transfer status	No
vat_incorporate_flag	fin_flag	varchar(25)	Yes	Vat incorporate flag	No
Forward_cover	fin_desc20	varchar(20)	Yes	Forward cover	No
Fw_cov_flag	fin_desc20	varchar(20)	Yes	Forward cover flag	No
Fw_cov_rate	fin_rate	numeric(13)	Yes	Forward cover rate	No
Taxdoc_flag	fin_modeflag	varchar(1)	Yes	Tax document flag	No
pp_adj	fin_flag	varchar(25)	Yes	Prepayment adjustment	No
tran_amount_cr	fin_amount	numeric(13)	Yes	Transaction credit amount	No
base_amount_cr	fin_amount	numeric(13)	Yes	Base credit amount	No

Table Name :	ci_doc_item_dtl
Comment :	To store document item detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_type	fin_cmntrantype	varchar(10)	No	Transaction type	Yes
tran_ou	fin_ouinstid	int(4)	No	Transaction OU	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
line_no	fin_lineno	int(4)	No	Line number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
component_id	fin_component	varchar(16)	Yes	Component id	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
lo_id	fin_loid	varchar(20)	Yes	lo id	No
item_tcd_code	fin_itemcode	varchar(40)	Yes	Item tcd code	No
item_tcd_var	fin_itemcode	varchar(40)	Yes	Item tcd variant	No
visible_line_no	fin_lineno	int(4)	Yes	Visible line number	No
so_no	fin_documentno	varchar(40)	Yes	so number	No
so_ou	fin_ouinstid	int(4)	Yes	so OU	No
ref_doc_no	fin_documentnumber	varchar(18)	Yes	Reference document number	No
ref_doc_date	fin_datetime	datetime(8)	Yes	Reference document date	No
ref_doc_ou	fin_ouinstid	int(4)	Yes	Reference document OU	No
ship_to_cust	fin_customer_id	varchar(18)	Yes	Ship to customer	No
ship_to_id	fin_id	varchar(6)	Yes	Ship to id	No
uom	fin_uom	varchar(15)	Yes	UOM	No
item_qty	fin_quantity	numeric(17)	Yes	Item quantity	No
unit_price	fin_price	numeric(13)	Yes	Unit price	No
item_amount	fin_amount	numeric(13)	Yes	Item amount	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
item_type	fin_itemtype	varchar(25)	Yes	Item type	No
tax_amount	fin_amount	numeric(13)	Yes	Tax amount	No
disc_amount	fin_amount	numeric(13)	Yes	Discount amount	No
line_amount	fin_amount	numeric(13)	Yes	Line amount	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
item_tcd_desc	fin_itemdesc	varchar(150)	Yes	Item tcd description	No
sale_purpose	fin_purpose	varchar(16)	Yes	Sale purchase	No
warehouse_code	fin_warehouse	varchar(10)	Yes	Warehouse date	No
alloc_method	fin_transactiontype	varchar(40)	Yes	Allocation method	No
attr_alloc	fin_chkflag	varchar(1)	Yes	Attribute allocation	No
proposal_no	fin_documentnumber	varchar(18)	Yes	Proposal number	No
shipping_ou	fin_ouinstid	int(4)	Yes	Shipping OU	No
ship_to_cust_name	fin_custname	varchar(40)	Yes	Ship to customer name	No
packslip_no	fin_documentno	varchar(40)	Yes	Packslip number	No
ref_doc_type	fin_cmntrantype	varchar(10)	Yes	Reference document typ	No
po_ou	fin_ouinstid	int(4)	Yes	Purchase order OU	No

Table Name :	ci_doc_payterm_dtl
Comment :	To store document payterm detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_type	fin_cmntrantype	varchar(10)	No	Transaction type	Yes
tran_ou	fin_ouinstid	int(4)	No	Transaction OU	Yes
tran_no	fin_documentnumber	varchar(18)	No	Trasanction number	Yes
pay_term	fin_quickcodes	varchar(25)	No	Pay term	Yes
term_no	fin_termnumber	varchar(20)	No	Term number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
lo_id	fin_loid	varchar(20)	Yes	lo id	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
component_id	fin_component	varchar(16)	Yes	Component id	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
due_date	fin_datetime	datetime(8)	Yes	Due date	No
due_amount_type	fin_chkflag	varchar(1)	Yes	Due amount type	No
due_percent	fin_duepercentage	numeric(13)	Yes	Due percent	No
due_amount	fin_amount	numeric(13)	Yes	Due amount	No
disc_comp_amount	fin_amount	numeric(13)	Yes	Discount comp amount	No
disc_amount_type	fin_chkflag	varchar(1)	Yes	Discount amount type	No
disc_date	fin_datetime	datetime(8)	Yes	Discount date	No
disc_percent	fin_discountpercentage	numeric(13)	Yes	Discount percent	No
disc_amount	fin_amount	numeric(13)	Yes	Discount amount	No
penalty_percent	fin_penalty	numeric(13)	Yes	Penalty percent	No
esr_ref_no	fin_participationid	varchar(30)	Yes	esr reference number	No
esr_coding_line	fin_reference_det2	varchar(128)	Yes	esr coding line	No
base_due_amount	fin_amount	numeric(13)	Yes	Base due amount	No
base_disc_amount	fin_amount	numeric(13)	Yes	Base discount amount	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
payterm_version	fin_lineno	int(4)	Yes	Payterm version	No

Table Name :	ci_posted_doc_log
Comment :	To store posted document log

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_ou	fin_ouinstid	int(4)	No	Transaction OU	No
tran_type	fin_cmntrantype	varchar(10)	No	Transaction type	No
tran_no	fin_documentno	varchar(40)	No	Transaction number	No
term_no	fin_termnumber	varchar(20)	No	Term number	No
amt_type	fin_varchar	varchar(800)	No	Amount type	No
ref_doc_ou	fin_ouinstid	int(4)	No	Reference document OU	No
ref_doc_type	fin_cmntrantype	varchar(10)	No	Reference document type	No
ref_doc_no	fin_documentnumber	varchar(18)	No	Reference document number	No
ref_doc_term	fin_termnumber	varchar(20)	No	Reference document term	No
adjd_doc_ou	fin_ouinstid	int(4)	No	Adjusted document OU	No
adjd_doc_type	fin_cmntrantype	varchar(10)	No	Adjusted document type	No
adjd_doc_no	fin_documentnumber	varchar(18)	No	Adjusted document number	No
adjd_doc_term	fin_termnumber	varchar(20)	No	Adjusted document term	No
createddate	fin_datetime	datetime(8)	No	Created date	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
lo_id	fin_loid	varchar(20)	Yes	lo id	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
cust_code	fin_customer_id	varchar(18)	Yes	Customer code	No
tran_currency	fin_currency	varchar(5)	Yes	Transaction currency	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
basecur_erate	fin_exchangerate	numeric(9)	Yes	Base currency exchange rate	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
ref_doc_date	fin_datetime	datetime(8)	Yes	Reference document date	No
ref_doc_cur	fin_currency	varchar(5)	Yes	Reference document currency	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
posting_status	fin_chkflag	varchar(1)	Yes	Posting status	No
posting_date	fin_datetime	datetime(8)	Yes	Posting date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
adjust_amount_inv_cur	fin_amount	numeric(13)	Yes	Adjusted amount invoice currency	No
crosscur_erate	fin_exchangerate	numeric(9)	Yes	Cross currency exchange rate	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	ci_prepay_adj_dtl
Comment :	To store prepayment adjacent detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tranou	fin_ctxt_ouinstance	int(4)	Yes	Transaction OU	No
trantype	fin_type	varchar(25)	Yes	Transaction type	No
fbid	fin_financebookid	varchar(20)	Yes	Finance book id	No
adjvouchno	fin_invoicenumber	varchar(18)	Yes	Adjusted voucher number	No
adjdate	fin_date	datetime(8)	Yes	Adjusted date	No
adjamt	fin_amount	numeric(13)	Yes	Adjusted amount	No
crdocno	fin_invoicenumber	varchar(18)	Yes	Credit document number	No
crdocdate	fin_datetime	datetime(8)	Yes	Credit document date	No
crdocamt	fin_amount	numeric(13)	Yes	Credit document amount	No
drdocno	fin_invoicenumber	varchar(18)	Yes	Debit document number	No
drdocdate	fin_datetime	datetime(8)	Yes	Debit document date	No
drdocamt	fin_amount	numeric(13)	Yes	Debit document amount	No
status	fin_flag	varchar(25)	Yes	Status	No
seqno	fin_lineno	int(4)	Yes	Sequence number	No
guid	fin_guid	varchar(40)	Yes	Guid	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	ci_prepay_adj_hdr
Comment :	To store prepayment adjacent header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tranou	fin_ctxt_ouinstance	int(4)	No	Transaction OU	No
trantype	fin_type	varchar(25)	No	Transaction type	No
fbid	fin_financebookid	varchar(20)	Yes	Finance book id	No
tranno	fin_invoicenumber	varchar(18)	No	Transaction number	No
refdocou	fin_ctxt_ouinstance	int(4)	No	Reference document OU	No
refdocno	fin_invoicenumber	varchar(18)	No	Reference document number	No
line_no	fin_lineno	int(4)	Yes	Line number	No
billtocustno	fin_customer_id	varchar(18)	Yes	Bill to customer number	No
invdate	fin_date	datetime(8)	Yes	Invoice date	No
invcurrency	fin_currencycode	varchar(5)	Yes	Invoice currency	No
exchrate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
itemamt	fin_amount	numeric(13)	Yes	Item amount	No
tranamt	fin_amount	numeric(13)	Yes	Transaction amout	No
adjtcdamt	fin_amount	numeric(13)	Yes	Adjusted amount	No
status	fin_flag	varchar(25)	Yes	Status	No
guid	fin_guid	varchar(40)	Yes	Guid	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	ci_prepay_tcd_dtl
Comment :	To store prepayment tcd detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tranou	fin_ctxt_ouinstance	int(4)	Yes	Transaction OU	No
trantype	fin_type	varchar(25)	Yes	Transation type	No
fbid	fin_financebookid	varchar(20)	Yes	Finance book id	No
tranno	fin_invoicenumber	varchar(18)	Yes	Transaction number	No
refdocou	fin_ctxt_ouinstance	int(4)	Yes	Reference document OU	No
refdocno	fin_invoicenumber	varchar(18)	Yes	Reference document number	No
line_no	fin_lineno	int(4)	Yes	Line number	No
tcdcode	fin_itemcode	varchar(40)	Yes	tcd code	No
tcdvar	fin_itemcode	varchar(40)	Yes	tcd variant	No
tcdcurrcode	fin_currencycode	varchar(5)	Yes	tcd currency code	No
tcdamt	fin_amount	numeric(13)	Yes	tcd amount	No
adjtcdamt	fin_amount	numeric(13)	Yes	Adjusted amount	No
seqno	fin_lineno	int(4)	Yes	Sequence number	No
guid	fin_guid	varchar(40)	Yes	Guid	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	ci_repsrm_cst_dtl
Comment :	To store detail of customers

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
guid	fin_guid	varchar(40)	Yes	Guid	No
customercode	fin_customer_id	varchar(18)	Yes	Customer code	No
customername	fin_custname	varchar(40)	Yes	Customer name	No
address	fin_address	varchar(40)	Yes	Address	No
address1	fin_address	varchar(40)	Yes	Address1	No
address2	fin_address	varchar(40)	Yes	Address2	No
contact_per	fin_custname	varchar(40)	Yes	Contact person	No
grouptypecode	fin_identificationnumber1	varchar(5)	Yes	Group type code	No
customergroupcode	fin_code	varchar(6)	Yes	Customer group code	No
companycode	fin_companycode	varchar(10)	Yes	Company code	No
codescription	fin_desc40	varchar(40)	Yes	Codescription	No
buid	fin_buid	varchar(20)	Yes	Business unit id	No
budescription	fin_desc40	varchar(40)	Yes	BU description	No
transactiontype	fin_transactiontype	varchar(40)	Yes	Transaction type	No
currency	fin_currency	varchar(5)	Yes	Currency	No
documentnumber	fin_documentnumber	varchar(18)	Yes	Document number	No
docdate	fin_date	datetime(8)	Yes	Document date	No
custdocrefno	fin_documentnumber	varchar(18)	Yes	Customer document reference number	No
amount	fin_amount	numeric(13)	Yes	Amount	No
outstandingamount	fin_amount	numeric(13)	Yes	Outstanding amount	No
duedate	fin_date	datetime(8)	Yes	Due date	No
instrumentnumber	fin_checknumber	varchar(30)	Yes	Instrument number	No
instrumentdate	fin_date	datetime(8)	Yes	Instrument date	No
openingbalance	fin_amount	numeric(13)	Yes	Opening balance	No
balancedue	fin_amount	numeric(13)	Yes	Balance due	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	ci_repsrm_cst_smry
Comment :	To store customer summary detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
guid	fin_hiddencontrol	varchar(128)	Yes	Guid	No
customercode	fin_customer_id	varchar(18)	Yes	Customer code	No
customername	fin_custname	varchar(40)	Yes	Customer name	No
address	fin_address	varchar(40)	Yes	Address	No
address1	fin_address	varchar(40)	Yes	Address1	No
address2	fin_address	varchar(40)	Yes	Address2	No
contact_per	fin_custname	varchar(40)	Yes	Contact person	No
grouptypecode	fin_identificationnumber1	varchar(5)	Yes	Group type code	No
customergroupcode	fin_code	varchar(6)	Yes	Customer group code	No
companycode	fin_companycode	varchar(10)	Yes	Company code	No
openingbalance	fin_amount	numeric(13)	Yes	Opening balance	No
billingamount	fin_amount	numeric(13)	Yes	Billing amount	No
paymentamount	fin_amount	numeric(13)	Yes	Payment amount	No
advanceamount	fin_amount	numeric(13)	Yes	Advance amount	No
unadjustrecptamt	fin_amount	numeric(13)	Yes	Unadjusted receipt amount	No
closingbalance	fin_amount	numeric(13)	Yes	Closing balance	No
depositamount	fin_amount	numeric(13)	Yes	Deposit amount	No
currency	fin_currency	varchar(5)	Yes	Currency	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	ci_taxinvoice_dtl
Comment :	To store tax details for an invoice

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
batch_id	fin_guid	varchar(40)	Yes	Guid	No
taxinv_ou	fin_ouinstid	int(4)	Yes	OU instance	No
taxinv_no	fin_documentno	varchar(40)	No	Tax Invoice No	No
taxinv_status	fin_status	varchar(25)	Yes	Tax Invoice Status	No
adjdoc_ou	fin_ouinstid	int(4)	Yes	Adjustment OU	No
adjdoc_no	fin_documentno	varchar(40)	Yes	Adjustment No	No
adjdoc_type	fin_type	varchar(25)	Yes	Adjustment Doc type	No
cr_doc_no	fin_documentno	varchar(40)	No	Credit Document Number	No
cr_doc_date	fin_date	datetime(8)	Yes	Credit Document Date	No
cr_doc_curr	fin_currency	varchar(5)	Yes	Credit Document Currency	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance Book	No
termno	fin_quickcodes	varchar(25)	Yes	Term no	No
dr_doc_no	fin_documentno	varchar(40)	No	debit Document Number	No
dr_doc_date	fin_date	datetime(8)	Yes	debit Document Date	No
dr_doc_curr	fin_currency	varchar(5)	Yes	debit Document Currency	No
tcd_code	fin_itemcode	varchar(40)	No	Tcd code	No
tcd_var_code	fin_itemcode	varchar(40)	No	Tcd Variant	No
tcd_line_no	fin_lineno	int(4)	No	Tcd lineno	No
tcd_currency	fin_currency	varchar(5)	Yes	Tcd Currency	No
prorated_taxable_tran_amt	fin_amount	numeric(13)	Yes	Taxable Tran Amount	No
prorated_tax_tran_amt	fin_amount	numeric(13)	Yes	Tax Tran Amount	No
prorated_tax_erate	fin_amount	numeric(13)	Yes	Exchange Rate	No
prorated_taxable_base_amt	fin_amount	numeric(13)	Yes	Taxable base Amount	No
prorated_tax_base_amt	fin_amount	numeric(13)	Yes	Tax base Amount	No
created_by	fin_ctxt_user	varchar(30)	Yes	Created by	No
created_date	fin_date	datetime(8)	Yes	Created Date	No
modified_by	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modified_date	fin_date	datetime(8)	Yes	Moified Date	No