Data Dictionary -- Customer Direct Invoice

Srl. No.	Table Name	Comment
1	cdi_adjustments_dtl	To store information of adjustments detail
2	cdi_allocations_dtl	To store information ofAllocations detail
3	cdi_apportioned_tcd_dtl	To store information of apportioned tcd detail
4	cdi_ar_postings_dtl	To store information of apportioned posting detail
5	cdi_attributes_dtl	To store information of attributes detail
6	cdi_billbck_doc_dtl	To store Information of Bill Back/Consignment Invoice
7	cdi_billbck_doc_stage_dtl	To store Information of Bill Back/Consignment Invoice Invoice from the caller
8	cdi_billbck_qtybackupd_dtl	To store the information of Quantity Invoiced and Billed for Bill Back Invoice
9	cdi_flightticket_met	To store information of flight ticket detail
10	cdi_frt_dtl	To store information of freight detail
11	cdi_invoice_hdr	To store information of invoice header
12	cdi_item_dtl	To store information of item detail
13	cdi_notes_dtl	To store information of notes detail
14	cdi_payment_dtl	To store information of payment detail
15	cdi_ref_autoerror_met	To store the metadata of Customer Direct Invoice (error description ).
16	cdi_ref_dtl	Customer Direct Invoice -to store the information of Flight Invoice release.
17	CDI_RInvDtl_Rental_Invoice_Dtl	To store the Information of Rental Invoice Details
18	CDI_RInvH_Rental_Invoice_Hdr	To store the Information of Rental Invoice Header Information
19	cdi_serialno_dtl	To store information of serial number detail
20	cdi_shipping_dtl	To store information of shipping detail
21	cdi_tcd_dtl	To store information of tcd detail
22	cdi_vat_dtl	To store information of vat detail
23	cdi_wf_met	cdi_wf_met
24	cmn_bb_acctpost_metadata	To store the Accounting Postings Related static Metadata for BB Invoice

Table Name :	cdi_adjustments_dtl
Comment :	To store information of adjustments 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	Ouinstance	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
ref_doc_type	fin_cmntrantype	varchar(10)	No	Reference document type	Yes
ref_doc_no	fin_documentnumber	varchar(18)	No	Reference document number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
ref_doc_date	fin_datetime	datetime(8)	Yes	Reference document date	No
ref_doc_fb_id	fin_financebookid	varchar(20)	Yes	Reference document FB	No
ref_doc_amount	fin_amount	numeric(13)	Yes	Reference document amount	No
ref_doc_current_os	fin_amount	numeric(13)	Yes	Reference document current os	No
ref_doc_supp_ou	fin_ouinstid	int(4)	Yes	Reference document ou	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

Table Name :	cdi_allocations_dtl
Comment :	To store information ofAllocations 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	Ouinstance	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
line_no	fin_lineno	int(4)	No	Line number	Yes
alloc_line_no	fin_lineno	int(4)	No	Allocation line number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
lot_no	fin_documentno	varchar(40)	Yes	Lot number	No
sublot_no	fin_ccnumber	varchar(18)	Yes	Sublot number	No
zone	fin_zone	varchar(10)	Yes	Zone	No
bin	fin_bin	varchar(10)	Yes	Bin	No
alloc_qty	fin_quantity	numeric(17)	Yes	Allocation quantity	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 :	cdi_apportioned_tcd_dtl
Comment :	To store information of apportioned tcd 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	Ouinstance	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
line_no	fin_lineno	int(4)	No	Line number	Yes
item_tcd_code	fin_itemcode	varchar(40)	No	Item tcd code	Yes
item_tcd_var	fin_itemcode	varchar(40)	No	Item tcd variant	Yes
tcd_version	fin_macseqno	int(4)	No	tcd version	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
item_type	fin_abbreviation	varchar(3)	Yes	Item type	No
tcd_rate	fin_amount	numeric(13)	Yes	tcd rate	No
taxable_amt	fin_amount	numeric(13)	Yes	Taxable amount	No
tcd_amount	fin_amount	numeric(13)	Yes	tcd amount	No
tcd_currency	fin_currency	varchar(5)	Yes	tcd currency	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel currency 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
remarks	fin_text255	varchar(255)	Yes	Remarks	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
tcd_level	fin_chkflag	varchar(1)	Yes	TCD Level	No

Table Name :	cdi_ar_postings_dtl
Comment :	To store information of apportioned posting 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	Ouinstance	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
posting_line_no	fin_lineno	int(4)	No	Posting line number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
line_no	fin_lineno	int(4)	Yes	Line number	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
posting_status	fin_abbreviation	varchar(3)	Yes	Posting status	No
posting_date	fin_datetime	datetime(8)	Yes	Posting date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
account_type	fin_vataccounttype	varchar(40)	Yes	Account type	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_id	fin_chkflag	varchar(1)	Yes	Debit credit id	No
tran_currency	fin_currency	varchar(5)	Yes	Transaction currency	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel currency exchange rate	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
guid	fin_guid	varchar(40)	Yes	Guid	No
entry_date	fin_datetime	datetime(8)	Yes	Entry date	No
auth_date	fin_datetime	datetime(8)	Yes	Author date	No
item_code	fin_itemcode	varchar(40)	Yes	Item code	No
item_variant	fin_itemcode	varchar(40)	Yes	Item variant	No
quantity	fin_quantity	numeric(17)	Yes	Quantity	No
reftran_fbid	fin_financebookid	varchar(20)	Yes	Reference transaction finance book id	No
reftran_no	fin_documentno	varchar(40)	Yes	Reference transaction number	No
reftran_ou	fin_ouinstid	int(4)	Yes	Reference transaction OU	No
reftran_type	fin_cmntrantype	varchar(10)	Yes	Reference type	No
uom	fin_uom	varchar(15)	Yes	UOM	No
org_vat_base_amt	fin_amount	numeric(13)	Yes	Organization vat base 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
cust_code	fin_customer_id	varchar(18)	Yes	Customer code	No
vat_line_no	fin_lineno	int(4)	Yes	Vat line number	No

Table Name :	cdi_attributes_dtl
Comment :	To store information of attributes 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	Ouinstance	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
line_no	fin_lineno	int(4)	No	Line number	Yes
attr_code	fin_varchar	varchar(800)	No	Attribute code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
attr_desc	fin_desc40	varchar(40)	Yes	Attribute description	No
attr_type	fin_item_genl	varchar(20)	Yes	Attribute type	No
qual_value	fin_item_genl	varchar(20)	Yes	Quality value	No
min_qty_value	fin_attributevalue	numeric(9)	Yes	Minimum quantity value	No
max_qty_value	fin_attributevalue	numeric(9)	Yes	Maximum quantity value	No
std_qty_value	fin_attributevalue	numeric(9)	Yes	Standard quantity value	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 :	cdi_billbck_doc_dtl
Comment :	To store Information of Bill Back/Consignment Invoice

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cdi_seqno	bigint	Bigint(8)	No	Running seqno	Yes
cdi_docno	fin_documentno	varchar(40)	Yes	Billback documentno	No
cdi_doclineno	fin_int	int(4)	No	Document lineno	No
cdi_docdt	fin_datetime	datetime(8)	No	Document date	No
cdi_docou	fin_ctxt_ouinstance	int(4)	No	Ouinstance	No
cdi_doctype	fin_doctype	varchar(40)	No	Document Tyoe	No
cdi_refdoctype	fin_doctype	varchar(40)	No	Reference Document type(PO/Consignment Doc. )	No
cdi_refdocno	fin_documentno	varchar(40)	No	Reference document no	No
cdi_refdocdt	fin_datetime	datetime(8)	No	Reference Document Date	No
cdi_refdoclineno	fin_int	int(4)	No	Reference Document lineno	No
cdi_refdocou	fin_ctxt_ouinstance	int(4)	No	Reference Document OU	No
cdi_supplier	fin_documentno	varchar(40)	No	Reference Supplier no	No
cdi_pono	fin_documentno	varchar(40)	No	Purchase Order no	No
cdi_ponolineno	fin_int	int(4)	No	Purchase Order line no	No
cdi_poou	fin_ctxt_ouinstance	int(4)	No	Purchase order ou instance	No
cdi_podt	fin_date	datetime(8)	No	Purchase order date	No
cdi_custno	fin_customer_id	varchar(18)	No	Customer no	No
cdi_linestatus	fin_status	varchar(25)	No	Line status	No
cdi_billelement	fin_documentno	varchar(40)	No	Billelement	No
cdi_partno	fin_partno	varchar(40)	No	Partno	No
cdi_stksts	fin_status	varchar(25)	No	Stock status	No
cdi_uom	fin_uom	varchar(15)	No	UOM	No
cdi_docqty	fin_quantity	numeric(17)	No	Document Quantity	No
cdi_confqty	fin_quantity	numeric(17)	No	Confirmed Quanitity	No
cdi_billedqty	fin_quantity	numeric(17)	No	Billed quanitity	No
cdi_nonbillableqty	fin_quantity	numeric(17)	No	Non billable quantity	No
cdi_pendqty	fin_quantity	numeric(17)	No	Pending quantity	No
cdi_sysbillableqty	fin_quantity	numeric(17)	No	Sys Billable quantity	No
cdi_pendqty_sys	fin_quantity	numeric(17)	No	System Pending quantity	No
cdi_sysbillable	fin_flag	varchar(25)	No	Billable according to the system	No
cdi_billable	fin_flag	varchar(25)	No	Billable	No
cdi_unitprice	fin_amount	numeric(13)	No	Unit price	No
cdi_taxamt	fin_amount	numeric(13)	No	Tax amount	No
cdi_chgamt	fin_amount	numeric(13)	No	Charge Amount	No
cdi_disamt	fin_amount	numeric(13)	No	Discount Amount	No
cdi_totamt	fin_amount	numeric(13)	No	Total Amount	No
cdi_totamt_bas	fin_amount	numeric(13)	No	Total Amount base	No
cdi_refdoccurr	fin_currency	varchar(5)	No	Reference document Currency	No
cdi_doccurr	fin_currency	varchar(5)	No	Document Currency	No
cdi_refdoccurr_erate	fin_rate	numeric(13)	No	Reference document exchange rate	No
cdi_notes	fin_notes	varchar(2000)	No	Notes	No
cdi_remarks	fin_remarks	varchar(100)	No	Remarks	No
cdi_comments	fin_comments	varchar(256)	No	Comments	No
cdi_costcenter	fin_costcentercode	varchar(10)	No	Cost center	No
cdi_analcode	fin_analysiscode	varchar(5)	No	Analysis code	No
cdi_subanacode	fin_analysiscode	varchar(5)	No	Sub analaysis code	No
cdi_createddate	fin_datetime	datetime(8)	No	Created date	No
cdi_createdby	fin_ctxt_user	varchar(30)	No	Created by	No
cdi_mdofiedby	fin_ctxt_user	varchar(30)	No	Modidfied by	No
cdi_modifieddate	fin_datetime	datetime(8)	No	Modified date	No
cdi_source	fin_ctxt_service	Varchar(32)	No	Soruce	No
cdi_int_inv	fin_flag	varchar(25)	No	Flag to check if the invoice can be intiated	No
cdi_int_req	fin_flag	varchar(25)	No	Invoice required flag	No
cdi_taxbasis	fin_designparamcode	varchar(5)	No	Tax basis	No
cdi_chgbasis	fin_designparamcode	varchar(5)	No	Charge basis	No
cdi_discbasis	fin_designparamcode	varchar(5)	No	Discount basis	No
cdi_unittax	fin_amount	numeric(13)	No	Unit tax	No
cdi_unitchg	fin_amount	numeric(13)	No	Unit charge	No
cdi_unitdis	fin_amount	numeric(13)	No	Unit discount	No
cdi_base_up	fin_amount	numeric(13)	No	Unit price in base	No
cdi_base_cost	fin_amount	numeric(13)	No	Cost	No
cdi_bas_tott	fin_amount	numeric(13)	No	Total Tax price in base	No
cdi_bas_totc	fin_amount	numeric(13)	No	Total charge price in base	No
cdi_bas_totd	fin_amount	numeric(13)	No	Total Discount price in discunt	No
cdi_bas_ut	fin_amount	numeric(13)	No	Unit tax in base	No
cdi_bas_uc	fin_amount	numeric(13)	No	Unit charge in base	No
cdi_bas_ud	fin_amount	numeric(13)	No	Unit discount in base	No

Table Name :	cdi_billbck_doc_stage_dtl
Comment :	To store Information of Bill Back/Consignment Invoice Invoice from the caller

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cdi_docno	fin_documentno	varchar(40)	Yes	Billback documentno	No
cdi_docou	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
cdi_doctype	fin_doctype	varchar(40)	Yes	Document Tyoe	No
cdi_docdt	fin_date	datetime(8)	Yes	document date	No
cdi_doclineno	fin_int	int(4)	Yes	Document lineno	No
cdi_seqno	bigint	Bigint(8)	No	running seqno	Yes
cdi_refdocno	fin_documentno	varchar(40)	Yes	Reference document no	No
cdi_refdocou	fin_ctxt_ouinstance	int(4)	Yes	Reference Document OU	No
cdi_refdocdt	fin_date	datetime(8)	Yes	Reference Document Date	No
cdi_refdoclineno	fin_int	int(4)	Yes	Reference Document Lineno	No
cdi_pono	fin_documentno	varchar(40)	Yes	Purchase Order no	No
cdi_ponolineno	fin_int	int(4)	Yes	Purchase Order line no	No
cdi_poou	fin_ctxt_ouinstance	int(4)	Yes	Purchase order ou instance	No
cdi_supplier	fin_supplier	Varchar(160)	Yes	Reference Supplier no	No
cdi_custno	fin_customer_id	varchar(18)	Yes	Customer no	No
cdi_linestatus	fin_status	varchar(25)	Yes	Line status	No
cdi_billelement	fin_designparamcode	varchar(5)	Yes	Billelement	No
cdi_partno	fin_partno	varchar(40)	Yes	Partno	No
cdi_stksts	fin_status	varchar(25)	Yes	Stock status	No
cdi_uom	fin_uom	varchar(15)	Yes	UOM	No
cdi_qty	fin_quantity	numeric(17)	Yes	Document Quantity	No
cdi_sysbillable	fin_designparamcode	varchar(5)	Yes	Billable according to the system	No
cdi_unitprice	fin_amount	numeric(13)	Yes	Unit Price	No
cdi_unittax	fin_amount	numeric(13)	Yes	Tax amount-unit price	No
cdi_unitchg	fin_amount	numeric(13)	Yes	Charge Amount-unit price	No
cdi_unitdis	fin_amount	numeric(13)	Yes	Discount Amount-unit price	No
cdi_taxamt	fin_amount	numeric(13)	Yes	Tax amount	No
cdi_chgamt	fin_amount	numeric(13)	Yes	Charge Amount	No
cdi_disamt	fin_amount	numeric(13)	Yes	Discount Amount	No
cdi_totamt	fin_amount	numeric(13)	Yes	Total Amount	No
cdi_refdoccurr	fin_currency	varchar(5)	Yes	Reference document Currency	No
cdi_doccurr	fin_currency	varchar(5)	Yes	Document Currency	No
cdi_refdoccurr_erate	fin_rate	numeric(13)	Yes	Reference document exchange rate	No
cdi_notes	fin_notes	varchar(2000)	Yes	Notes	No
cdi_remarks	fin_remarks	varchar(100)	Yes	Remarks	No
cdi_comments	fin_comments	varchar(256)	Yes	Comments	No
cdi_costcenter	fin_costcentercode	varchar(10)	Yes	Cost center	No
cdi_analcode	fin_analysiscode	varchar(5)	Yes	Analysis code	No
cdi_subanacode	fin_analysiscode	varchar(5)	Yes	Sub analaysis code	No
cdi_createddate	fin_datetime	datetime(8)	Yes	Created date	No
cdi_createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
cdi_modifiedby	fin_ctxt_user	varchar(30)	Yes	Modidfied by	No
cdi_modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
cdi_source	fin_ctxt_service	Varchar(32)	Yes	Source	No
cdi_taxbasis	fin_designparamcode	varchar(5)	Yes	Tax basis	No
cdi_chgbasis	fin_designparamcode	varchar(5)	Yes	Charge basis	No
cdi_discbasis	fin_designparamcode	varchar(5)	Yes	Discount basis	No
cdi_base_up	fin_amount	numeric(13)	Yes	Base Unit price	No
cdi_base_cost	fin_amount	numeric(13)	Yes	Base Cost	No
cdi_bas_tott	fin_amount	numeric(13)	Yes	Total Tax price in base	No
cdi_bas_totc	fin_amount	numeric(13)	Yes	Total charge price in base	No
cdi_bas_totd	fin_amount	numeric(13)	Yes	Total Discount price in discunt	No
cdi_bas_ut	fin_amount	numeric(13)	Yes	Unit tax in base	No
cdi_bas_uc	fin_amount	numeric(13)	Yes	Unit charge in base	No
cdi_bas_ud	fin_amount	numeric(13)	Yes	Unit discount in base	No

Table Name :	cdi_billbck_qtybackupd_dtl
Comment :	To store the information of Quantity Invoiced and Billed for Bill Back Invoice

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cdi_ou	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
cdi_seqno	int	int(4)	No	Running sequence no	Yes
cdi_refseqno	fin_int	int(4)	Yes	Reference sequence no	No
cdi_invno	fin_documentno	varchar(40)	Yes	Invoice Number	No
cdi_cumsysbill_qty	fin_quantity	numeric(17)	Yes	Cumulative Billable quantity	No
cdi_invd_qty	fin_quantity	numeric(17)	Yes	Invoiced Quantity	No
cdi_cuminv_qty	fin_quantity	numeric(17)	Yes	cumulative invoiced quantity	No
cdi_createddate	fin_datetime	datetime(8)	Yes	Created Date	No
cdi_nbill_qty	fin_quantity	numeric(17)	Yes	Non Billable Quantity	No
cdi_createdby	fin_ctxt_user	varchar(30)	Yes	CreatedBy	No
cdi_mdofiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
cdi_modifieddate	fin_datetime	datetime(8)	Yes	Modified Date	No
cdi_delta_nb_qty	fin_amount	numeric(13)	Yes	Delta Non Billable Quantity	No

Table Name :	cdi_flightticket_met
Comment :	To store information of flight ticket detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
component_id	fin_componentid	varchar(90)	Yes	Component ID	No
parameter_category	fin_category	varchar(15)	Yes	Parameter category	No
parameter_code	fin_paramcode	varchar(30)	Yes	Parameter code	No
parameter_text	fin_desc28	varchar(28)	Yes	Parameter text	No
language_id	fin_int	int(4)	Yes	Language ID	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_date	datetime(8)	Yes	Created date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	cdi_frt_dtl
Comment :	To store information of freight 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	Ouinstance	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
so_no	fin_documentno	varchar(40)	Yes	so number	No
packslip_no	fin_documentno	varchar(40)	Yes	Packslip number	No
frt_term	fin_terms	varchar(15)	Yes	Freight term	No
frt_amount	fin_amount	numeric(13)	Yes	Freight amount	No
frt_currency	fin_currency	varchar(5)	Yes	Freight currency	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
frt_inv_cur_amount	fin_amount	numeric(13)	Yes	Freight invoice currency 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

Table Name :	cdi_invoice_hdr
Comment :	To store information of invoice header

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	Ouinsatance	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
tran_status	fin_abbreviation	varchar(3)	Yes	Transaction status	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
anchor_date	fin_datetime	datetime(8)	Yes	Anchor date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
bill_to_cust	fin_customer_id	varchar(18)	Yes	Bill to customer	No
auto_adjust	fin_chkflag	varchar(1)	Yes	Auto adjust	No
tran_currency	fin_currency	varchar(5)	Yes	Transaction currency	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
pay_term	fin_quickcodes	varchar(25)	Yes	Payment term	No
payterm_version	fin_lineno	int(4)	Yes	Payterm version	No
receipt_method	fin_method	varchar(30)	Yes	Receipt method	No
comments	fin_comments	varchar(256)	Yes	Comments	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
receipt_type	fin_chkflag	varchar(1)	Yes	Receipt type	No
sales_channel	fin_cashcode	varchar(32)	Yes	Sales channel	No
sales_type	fin_identificationnumber1	varchar(5)	Yes	Sales type	No
ship_to_cust	fin_customer_id	varchar(18)	Yes	Ship to customer	No
ship_to_id	fin_customer_id	varchar(18)	Yes	Ship to id	No
price_list_code	fin_prilistcode	varchar(25)	Yes	Price list code	No
sales_person	fin_code	varchar(6)	Yes	Sales person	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
item_amount	fin_amount	numeric(13)	Yes	Item amount	No
tax_amount	fin_amount	numeric(13)	Yes	Tax amount	No
disc_amount	fin_amount	numeric(13)	Yes	Discount amount	No
gross_frt_amount	fin_amount	numeric(13)	Yes	Gross freight amount	No
net_frt_amount	fin_amount	numeric(13)	Yes	Net freight amount	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel currency base amount	No
rev_doc_no	fin_documentnumber	varchar(18)	Yes	Reversal document number	No
rev_doc_ou	fin_ouinstid	int(4)	Yes	Reversal document OU	No
rev_date	fin_datetime	datetime(8)	Yes	Reversal date	No
ref_doc_no	fin_documentnumber	varchar(18)	Yes	Reference document number	No
ref_doc_ou	fin_ouinstid	int(4)	Yes	Reference document OU	No
rev_reason_code	fin_quickcodes	varchar(25)	Yes	Reversal reason code	No
rev_remarks	fin_remarks	varchar(100)	Yes	Reversal remarks	No
hld_date	fin_datetime	datetime(8)	Yes	Hold date	No
hld_reason_code	fin_quickcodes	varchar(25)	Yes	Hold reason code	No
hld_remarks	fin_remarks	varchar(100)	Yes	Hold remarks	No
auth_date	fin_datetime	datetime(8)	Yes	Author date	No
posting_date	fin_datetime	datetime(8)	Yes	Posting date	No
posting_status	fin_abbreviation	varchar(3)	Yes	Posting status	No
disc_comp_basis	fin_chkflag	varchar(1)	Yes	Discount comp basis	No
disc_proportional	fin_chkflag	varchar(1)	Yes	Discount proportional	No
comp_bp_code	fin_bankcode	varchar(32)	Yes	Comp bp code	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank code	No
lsv_id	fin_participationid	varchar(30)	Yes	lsv id	No
comp_acct_in	fin_route	varchar(10)	Yes	Comp account information	No
comp_bp_ref	fin_banknumber	varchar(20)	Yes	Comp bp reference	No
comp_bp_acc_no	fin_bankcode	varchar(32)	Yes	Comp bp account number	No
esr_id	fin_participationid	varchar(30)	Yes	esr id	No
cust_bank_acct	fin_accountcode	varchar(32)	Yes	Customer bank account	No
cust_bank_id	fin_bankcode	varchar(32)	Yes	Customer bank id	No
vat_applicable	fin_chkflag	varchar(1)	Yes	Vat applicable	No
vat_exchange_rate	fin_exchangerate	numeric(9)	Yes	Vat exchange rate	No
vat_charge	fin_amount	numeric(13)	Yes	Vat charge	No
non_vat_charge	fin_amount	numeric(13)	Yes	Non vat charge	No
doc_level_disc	fin_amount	numeric(13)	Yes	Document level discount	No
vat_incl	fin_chkflag	varchar(1)	Yes	Vat included	No
retain_init_distbn	fin_chkflag	varchar(1)	Yes	Retain initial distribution	No
cap_non_ded_charge	fin_chkflag	varchar(1)	Yes	Capitalized non ded charge	No
average_vat_rate	fin_amount	numeric(13)	Yes	Average vat rate	No
vat_excl_amount	fin_amount	numeric(13)	Yes	Vat exclusive amount	No
vat_amount	fin_amount	numeric(13)	Yes	Vat amount	No
vat_incl_amount	fin_amount	numeric(13)	Yes	Vat included amount	No
frt_cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
frt_analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
frt_subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
pre_round_off_amount	fin_amount	numeric(13)	Yes	Pre round off amount	No
rounded_off_amount	fin_amount	numeric(13)	Yes	Round off amount	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	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
draft_flag	fin_chkflag	varchar(1)	Yes	Draft flag	No
remit_comp_code	fin_companycode	varchar(10)	Yes	Remit to Company	No
remit_bank_ref	fin_banknumber	varchar(20)	Yes	Remit to Bank	No
user_def	fin_txt255	varchar(255)	Yes	User define	No
can_comments	fin_comments	varchar(256)	Yes	To Store Comments	No
chg_amount	fin_amount	numeric(13)	Yes	Charge Amount	No
inv_catg	fin_comments	varchar(256)	Yes	Invoice Category	No
inv_type	fin_doctype	varchar(40)	Yes	Invoice Type	No
refdoc_type	fin_doctype	varchar(40)	Yes	Reference Document Type.	No
inv_category	fin_txt255	varchar(255)	Yes	inv_category	Yes
custno	fin_customer_id	varchar(18)	Yes	custno	Yes
cdi_wf_new_state	fin_txt150	varchar(18)	Yes	cdi_wf_new_state	Yes
receipt_mode	fin_txt255	varchar(255)	Yes	receipt_mode	Yes
city	fin_city	varchar(255)	Yes	city	Yes
bb_cost	fin_amount	numeric(13)	Yes	bb_cost	Yes
userdefined2	fin_txt255	varchar(255)	Yes	userdefined2	Yes
hldinv_flag	fin_designparamcode	varchar(5)	Yes	hldinv_flag	Yes
hdn_rcptmode	fin_desxc40	varchar(5)	Yes	hdn_rcptmode	Yes
year1	fin_int	int(4)	Yes	year1	Yes
card_no	fin_aischar30	int(4)	Yes	card_no	Yes
month1	fin_int	int(4)	Yes	month1	Yes
hdn_rcptype	fin_desxc40	int(4)	Yes	hdn_rcptype	Yes
issuer	accountdescription	int(4)	Yes	issuer	Yes
email_id	fin_email	int(4)	Yes	email_id	Yes
state	fin_state	int(4)	Yes	state	Yes
zip_code	fin_zip	int(4)	Yes	zip_code	Yes
micr_no	fin_aischar30	int(4)	Yes	micr_no	Yes
mobile_no	fin_contactnumber	int(4)	Yes	mobile_no	Yes
instrument_amt	fin_amount	numeric(13)	Yes	instrument_amt	Yes
numtype	fin_doctype	varchar(40)	Yes	numtype	Yes
basic_value	fin_amount	numeric(13)	Yes	basic_value	Yes
pager_no	fin_contactnumber	numeric(13)	Yes	pager_no	Yes
url	fin_url	numeric(13)	Yes	url	Yes
address2	fin_address	varchar(40)	Yes	address2	Yes
bill_to_id	fin_customer_id	varchar(18)	Yes	bill_to_id	Yes
fax_no	fin_contactnumber	varchar(18)	Yes	fax_no	Yes
mail_stop	fin_mailstop	varchar(18)	Yes	mail_stop	Yes
userdefined3	fin_txt255	varchar(255)	Yes	userdefined3	Yes
valid_till	fin_txt255	varchar(255)	Yes	valid_till	Yes
address3	fin_address	varchar(40)	Yes	address3	Yes
receipt_status	fin_status	varchar(25)	Yes	receipt_status	Yes
contact	fin_contact	varchar(25)	Yes	contact	Yes
instrument_no	fin_aischar30	varchar(25)	Yes	instrument_no	Yes
reference_no	fin_aircraftmodel	varchar(25)	Yes	reference_no	Yes
telex	fin_telex	varchar(25)	Yes	telex	Yes
reftcd_amount	fin_amount	numeric(13)	Yes	reftcd_amount	Yes
rr_flag	fin_cmbflag	numeric(13)	Yes	rr_flag	Yes
instrument_date	fin_date	datetime(8)	Yes	instrument_date	Yes
address1	fin_address	varchar(40)	Yes	address1	Yes
country	fin_country	varchar(40)	Yes	country	Yes
phone_no	fin_contactnumber	varchar(40)	Yes	phone_no	Yes
remitter	fin_accountdesc	varchar(40)	Yes	remitter	Yes
bank_no	bankcode	varchar(40)	Yes	bank_no	Yes
authorization_no	fin_reference	varchar(40)	Yes	authorization_no	Yes
cdi_wf_doc_key	fin_flag	varchar(25)	Yes	cdi_wf_doc_key	Yes

Table Name :	cdi_item_dtl
Comment :	To store information of 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	Ouinstance	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
line_no	fin_lineno	int(4)	No	Line number	Yes
timestamp	fin_timestamp	int(4)	Yes	Timestamp	No
visible_line_no	fin_lineno	int(4)	Yes	Visible line number	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
usage_id	fin_usageid	varchar(20)	Yes	Usage id	No
item_type	fin_itemtype	varchar(25)	Yes	Item type	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
base_value	fin_amount	numeric(13)	Yes	Base value	No
item_amount	fin_amount	numeric(13)	Yes	Item amount	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	Par base amount	No
sale_purpose	fin_desc40	varchar(40)	Yes	Sale purchase	No
warehouse_code	fin_accountcode	varchar(32)	Yes	Warehouse code	No
alloc_method	fin_transactiontype	varchar(40)	Yes	Allocation method	No
attr_alloc	fin_param_code	varchar(6)	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	fin_customer_id	varchar(18)	Yes	Ship to customer	No
ship_to_id	fin_customer_id	varchar(18)	Yes	Ship to id	No
packslip_no	fin_documentno	varchar(40)	Yes	Packslip number	No
packslip_ou	fin_ouinstid	int(4)	Yes	Packslip OU	No
packslip_line_no	fin_lineno	int(4)	Yes	Packslip line number	No
remarks	fin_text255	varchar(255)	Yes	Remarks	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
account_code	fin_accountcode	varchar(32)	Yes	Account Code	No
billhead	fin_comments	varchar(256)	Yes	Bill Head	No
item_tcd_desc	fin_text255	varchar(255)	Yes	Item TCD Description	No
docno	fin_documentno	varchar(40)	Yes	docno	Yes
doccurr	fin_currency	varchar(5)	Yes	doccurr	Yes
modnotes	fin_notes	varchar(2000)	Yes	modnotes	Yes
MilestoneDesc	fin_text255	varchar(255)	Yes	MilestoneDesc	Yes
Bill_Line_no	hrint	varchar(255)	Yes	Bill_Line_no	Yes
doc_exch_rt	fin_rate	numeric(13)	Yes	doc_exch_rt	Yes
unitdis	fin_amount	numeric(13)	Yes	unitdis	Yes
bb_cost	fin_amount	numeric(13)	Yes	bb_cost	Yes
refdoctype	fin_type	numeric(13)	Yes	refdoctype	Yes
cum_inv_qty	fin_quantity	numeric(17)	Yes	cum_inv_qty	Yes
ref_unitprice	fin_amount	numeric(13)	Yes	ref_unitprice	Yes
billingprdto	fin_date	datetime(8)	Yes	billingprdto	Yes
billingprdfrom	fin_date	datetime(8)	Yes	billingprdfrom	Yes
extmarkup	fin_amount	numeric(13)	Yes	extmarkup	Yes
exchange_rate	fin_exchangerate	numeric(9)	Yes	exchange_rate	Yes
unit_markup	fin_amount	numeric(13)	Yes	unit_markup	Yes
docou	fin_ctxt_ouinstance	int(4)	Yes	docou	Yes
doclinno	fin_lineno	int(4)	Yes	doclinno	Yes
extfinalprice	fin_amount	numeric(13)	Yes	extfinalprice	Yes
pend_qty	fin_quantity	numeric(17)	Yes	pend_qty	Yes
extprice	fin_amount	numeric(13)	Yes	extprice	Yes
billingMilestone	fin_itemdesc	numeric(13)	Yes	billingMilestone	Yes
exttotalprice	fin_amount	numeric(13)	Yes	exttotalprice	Yes
bb_seqno	bigint	Bigint(8)	Yes	bb_seqno	Yes
intnotes	fin_notes	varchar(2000)	Yes	intnotes	Yes
billable	fin_flag	varchar(25)	Yes	billable	Yes
gr_qty	fin_quantity	numeric(17)	Yes	gr_qty	Yes
refdocdt	fin_date	datetime(8)	Yes	refdocdt	Yes
shpno	fin_documentno	varchar(40)	Yes	shpno	Yes
OrderBook_currency	hrcurrency	varchar(40)	Yes	OrderBook_currency	Yes
ref_conlnno	fin_seqno	int(4)	Yes	ref_conlnno	Yes
unittax	fin_amount	numeric(13)	Yes	unittax	Yes
issno	fin_documentno	varchar(40)	Yes	issno	Yes
Bill_Sch_slno	hrint	varchar(40)	Yes	Bill_Sch_slno	Yes
sys_bill_qty	fin_quantity	numeric(17)	Yes	sys_bill_qty	Yes
docdt	fin_date	datetime(8)	Yes	docdt	Yes
non_bill_qty	fin_quantity	numeric(17)	Yes	non_bill_qty	Yes
proposed_qty	fin_quantity	numeric(17)	Yes	proposed_qty	Yes
unitchg	fin_amount	numeric(13)	Yes	unitchg	Yes
suppno	fin_suppliercode	numeric(13)	Yes	suppno	Yes
exttcdamount	fin_amount	numeric(13)	Yes	exttcdamount	Yes
po_qty	fin_quantity	numeric(17)	Yes	po_qty	Yes

Table Name :	cdi_notes_dtl
Comment :	To store information of notes 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	Ouinstance	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
note_category	fin_category	varchar(15)	No	Note category	Yes
category_value	fin_desc40	varchar(40)	No	Category value	Yes
line_no	fin_lineno	int(4)	No	Line number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
note_text	fin_notes	varchar(2000)	Yes	Note text	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
stdnotes_id	fin_id	varchar(6)	Yes	Standard notes id	No
stdnotes_desc	fin_description	varchar(100)	Yes	Standard notes description	No

Table Name :	cdi_payment_dtl
Comment :	To store information of payment detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_type	fin_cmntrantype	varchar(10)	No	Transaction type	No
tran_ou	fin_ouinstid	int(4)	No	Ouinstance	No
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	No
term_no	fin_termnumber	varchar(20)	No	Term number	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
posting_status	fin_abbreviation	varchar(3)	Yes	Posting status	No
posting_date	fin_datetime	datetime(8)	Yes	Posting date	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
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 :	cdi_ref_autoerror_met
Comment :	To store the metadata of Customer Direct Invoice (error description ).

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ref_error_code	fin_number	int(4)	No	Reference Error Code.	No
ref_component_id	fin_compid	varchar(10)	No	Reference Component Id.	No
ref_designerr_code	fin_number	int(4)	No	Reference Designer Code.	No
ref_error_desc	fin_msgtext	varchar(255)	No	Reference Error Description.	No
ref_timestamp	fin_int	int(4)	No	Reference Timestamp.	No
ref_createdby	fin_ctxt_user	varchar(30)	No	Reference Created Person.	No
ref_createddate	fin_datetime	datetime(8)	No	Reference Created Date.	No
ref_modifiedby	fin_ctxt_user	varchar(30)	No	Reference Modified Person.	No
ref_modifieddate	fin_datetime	datetime(8)	No	Refernce Modified Date.	No
REPLICATION_KEY	int	int(4)	No	Unique Key.	Yes

Table Name :	cdi_ref_dtl
Comment :	Customer Direct Invoice -to store the information of Flight Invoice release.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ref_tran_no	fin_documentno	varchar(40)	No	Reference Tranaction Number.	Yes
ref_tran_type	fin_cmntrantype	varchar(10)	No	Reference Transaction Type.	No
ref_lineno	fin_lineno	int(4)	No	Reference Line Number.	Yes
ref_ou	fin_ctxt_ouinstance	int(4)	No	Reference OU.	Yes
ref_doc_type	fin_doctype	varchar(40)	No	Reference Document Type.	No
ref_doc_no	fin_documentno	varchar(40)	No	Reference Document Number.	No
ref_src_doc_type	fin_doctype	varchar(40)	No	Reference Source Document Type.	No
ref_src_doc_no	fin_documentno	varchar(40)	No	Reference Source Document Number.	No
ref_usageid	fin_usageid	varchar(20)	No	Reference Usage Id.	No
ref_billhead	fin_doctype	varchar(40)	No	Reference billhead.	Yes
ref_inv_element	fin_designparamcode	varchar(5)	No	Reference Invoice Element.	No
ref_amount	fin_amount	numeric(13)	No	Reference Amount.	No
ref_baseamount	fin_amount	numeric(13)	No	Reference Base Amount.	No
ref_cost_center	fin_costcentercode	varchar(10)	No	Reference Cost Center.	No
ref_analysis_no	fin_analysiscode	varchar(5)	No	Reference Analysis Number.	No
ref_subanalysis_no	fin_subanalysiscode	varchar(5)	No	Reference Subanalysis Number.	No
ref_remarks	fin_remarks	varchar(100)	No	Reference Remarks.	No
ref_error_id	fin_errorno	int(4)	No	Reference Error Id.	No
ref_timestamp	fin_timestamp	int(4)	No	Reference Timestamp.	No
ref_createdby	fin_ctxt_user	varchar(30)	No	Reference Created Person.	No
ref_created_date	fin_date	datetime(8)	No	Reference Created Date.	No
ref_modifiedby	fin_ctxt_user	varchar(30)	No	Reference Modified Person.	No
ref_modified_date	fin_date	datetime(8)	No	Reference Modified Date.	No
ref_bhlineno	fin_lineno	int(4)	No	Reference Bill Number.	No
ref_expclass	fin_quickcodes	varchar(25)	No	Reference Expensive Classification.	No
ref_amount_sys	fin_amount	numeric(13)	No	Reference Amount System.	No
ref_baseamount_sys	fin_amount	numeric(13)	No	Reference Base Amount system.	No
ref_conlnno	fin_seqno	int(4)	Yes	ref_conlnno	Yes
ref_billcat_hdn	fin_designparamcode	varchar(5)	Yes	ref_billcat_hdn	Yes

Table Name :	CDI_RInvDtl_Rental_Invoice_Dtl
Comment :	To store the Information of Rental Invoice Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RInvDtl_OUInstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
RInvDtl_RentOrd_No	udd_documentno	varchar(40)	Yes	Rental Order No	No
RInvDtl_Amend_No	udd_seqno	int(4)	Yes	Amendment No	No
RInvDtl_Release_Id	udd_documentno	varchar(40)	Yes	Release Id	No
RInvDtl_Line_No	udd_seqno	int(4)	Yes	LineNo	No
RInvDtl_Param_Type	udd_desc40	varchar(40)	Yes	Parameter Type	No
RInvDtl_Param_Value	udd_quantity	numeric(13)	Yes	Parameter value	No
RInvDtl_Charge_Basis	udd_desc40	varchar(40)	Yes	Charge Basis	No
RInvDtl_Qty	udd_quantity	numeric(13)	Yes	Quantity	No
RInvDtl_Rate	udd_value	numeric(13)	Yes	Rate	No
RInvDtl_Entity	udd_desc40	varchar(40)	Yes	Entity	No
RInvDtl_Amount	udd_value	numeric(13)	Yes	Amount	No
RInvDtl_Processing_Status	udd_designparamcode	varchar(5)	Yes	Processing Status	No
RInvDtl_Invoice_TrnNo	udd_documentno	varchar(40)	Yes	Invoice Tran No	No
RInvDtl_Invoice_Status	udd_designparamcode	varchar(5)	Yes	Invoice Status	No
RInvDtl_Invoice_Qty	udd_quantity	numeric(13)	Yes	Invoice Qty	No
RInvDtl_Invoice_Amount	udd_value	numeric(13)	Yes	Invoice Amount	No
RInvDtl_Created_Date	udd_time	Datetime(8)	Yes	Created Date	No
RInvDtl_Invoice_Date	udd_time	Datetime(8)	Yes	Invoice Date	No

Table Name :	CDI_RInvH_Rental_Invoice_Hdr
Comment :	To store the Information of Rental Invoice Header Information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RInvH_OUInstance	udd_ctxt_ouinstance	int(4)	Yes	OUInstance	No
RInvH_RentOrd_No	udd_documentno	varchar(40)	Yes	Rental Orderded No	No
RInvH_Amend_No	udd_seqno	int(4)	Yes	Amendment No	No
RInvH_Release_Id	udd_documentno	varchar(40)	Yes	Release Id	No
RInvH_Status	udd_financeperiodrange	varchar(40)	Yes	Status	No
RInvH_CustomerNo	udd_customer_id	varchar(18)	Yes	Customer No	No
RInvH_PartNo	udd_partno	varchar(40)	Yes	PartNo	No
RInvH_SerialNo	UDD_SERIALNO	varchar(40)	Yes	Serial No	No
RInvH_Fin_Period	udd_financeperiodrange	varchar(40)	Yes	Final Period	No
RInvH_Start_Date	udd_time	Datetime(8)	Yes	Start Date	No
RInvH_End_Date	udd_time	Datetime(8)	Yes	End Date	No
RInvH_Prog_Inv_Period	udd_seqno	int(4)	Yes	Program Invoice Period	No
RInvH_Currency	udd_currency	varchar(20)	Yes	Currency	No
RInvH_Crated_Date	udd_time	Datetime(8)	Yes	Crated Date	No
RInvH_Created_By	udd_ctxt_user	varchar(30)	Yes	Created By	No
RInvH_Mod_Date	udd_time	Datetime(8)	Yes	Modified Date	No
RInvH_Mod_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
RInvH_Timestamp	udd_seqno	int(4)	Yes	Timestamp	No
RInvH_Comments	udd_remarks	varchar(255)	Yes	Comments	No

Table Name :	cdi_serialno_dtl
Comment :	To store information of serial number detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_type	fin_cmntrantype	varchar(10)	No	Transaction type	No
tran_ou	fin_ouinstid	int(4)	No	Ouinstance	No
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	No
line_no	fin_lineno	int(4)	No	Line number	No
alloc_line_no	fin_lineno	int(4)	No	Allocation line number	No
item_serial_no	fin_desc40	varchar(40)	No	Item serial number	No
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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	cdi_shipping_dtl
Comment :	To store information of shipping detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_type	fin_cmntrantype	varchar(10)	No	Transaction type	No
tran_ou	fin_ouinstid	int(4)	No	Ouinstance	No
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
freight_term	fin_terms	varchar(15)	Yes	Freight term	No
insurance_comp	fin_companyname	varchar(60)	Yes	Insurance comp	No
ship_mode	fin_transportationmode	varchar(25)	Yes	Ship mode	No
ship_label	fin_shipinglabel	varchar(20)	Yes	Ship label	No
trans_doc_no	fin_documentno	varchar(40)	Yes	Transaction document number	No
carrier_code	fin_carriercode	varchar(20)	Yes	Carrier code	No
carrier_name	fin_carriername	varchar(25)	Yes	Carrier name	No
delivery_area	fin_deliveryarea	varchar(18)	Yes	Delivery area	No
frt_amount	fin_amount	numeric(13)	Yes	Freight amount	No
frt_bill_no	fin_documentno	varchar(40)	Yes	Freight bill number	No
remarks	fin_remarks	varchar(100)	Yes	Remarks	No
shelf_life	fin_shelflife	varchar(20)	Yes	Shelf life	No
ship_to_address	fin_address	varchar(40)	Yes	Ship to address	No
ship_time	fin_time	datetime(8)	Yes	Ship time	No
ship_status	fin_abbreviation	varchar(3)	Yes	Ship status	No
tracking_no	fin_trackingnumber	varchar(20)	Yes	Tracking number	No
vehicle_no	fin_trackingnumber	varchar(20)	Yes	Vehicle number	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 :	cdi_tcd_dtl
Comment :	To store information of tcd 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	Ouinstance	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
line_no	fin_lineno	int(4)	No	Line number	Yes
item_tcd_code	fin_itemcode	varchar(40)	No	Item tcd code	Yes
item_tcd_var	fin_itemcode	varchar(40)	No	Item tcd variant	Yes
tcd_version	fin_macseqno	int(4)	No	tcd version	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
item_type	fin_abbreviation	varchar(3)	Yes	Item type	No
tcd_level	fin_chkflag	varchar(1)	Yes	tcd level	No
tcd_rate	fin_amount	numeric(13)	Yes	tcd rate	No
taxable_amount	fin_amount	numeric(13)	Yes	Taxable amount	No
tcd_amount	fin_amount	numeric(13)	Yes	tcd amount	No
tcd_currency	fin_currency	varchar(5)	Yes	tcd currency	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	Subanlysis code	No
remarks	fin_text255	varchar(255)	Yes	Remarks	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
base_value	fin_amount	numeric(13)	Yes	Base value	No
rowno	fin_seqno	int(4)	Yes	Row Number	No
billhead	fin_comments	varchar(256)	Yes	Bill Head	No
tax_amount_sys	fin_amount	numeric(13)	Yes	Tax Amount System	No
mod_flag	fin_flag	varchar(25)	Yes	mod_flag	Yes
tv_taxable_amount	fin_amount	numeric(13)	Yes	tv_taxable_amount	Yes

Table Name :	cdi_vat_dtl
Comment :	To store information of vat 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	Ouinstance	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
vat_line_no	fin_lineno	int(4)	No	Vat line number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
doc_line_no	fin_lineno	int(4)	Yes	Document line number	No
item_type	fin_abbreviation	varchar(3)	Yes	Item type	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	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
vat_category	fin_vatcategory	varchar(40)	Yes	Vat category	No
vat_class	fin_vatclass	varchar(40)	Yes	Vat class	No
tcd_var	fin_itemcode	varchar(40)	Yes	tcd variant	No
vat_rate	fin_amount	numeric(13)	Yes	Vat rate	No
inp_vat_deduct_per	fin_vatdeductible	numeric(9)	Yes	Input vat deducted percent	No
item_amount	fin_amount	numeric(13)	Yes	Item amount	No
vat_item_charge	fin_amount	numeric(13)	Yes	Vat item charge	No
non_vat_item_charge	fin_amount	numeric(13)	Yes	Non vat item charge	No
vat_dist_charge	fin_amount	numeric(13)	Yes	Vat dist charge	No
item_level_disc_amount	fin_amount	numeric(13)	Yes	Item level discount amount	No
dist_disc_amount	fin_amount	numeric(13)	Yes	Discount amount	No
vat_tran_amount	fin_amount	numeric(13)	Yes	Vat transaction amount	No
corr_vat_tran_amount	fin_amount	numeric(13)	Yes	corr vat transaction amount	No
vat_base_amount	fin_amount	numeric(13)	Yes	Vat base amount	No
corr_vat_base_amount	fin_amount	numeric(13)	Yes	corr Vat base 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

Table Name :	cdi_wf_met
Comment :	cdi_wf_met

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
doc_activity_code	varchar	Char(10)	Yes	Activity Code	No
doc_task_code	varchar	Char(10)	Yes	Task Code	No
ctxt_service	varchar	Char(10)	Yes	Service	No
doc_line_no	fin_unique_id	Bigint(8)	No	Line No	Yes

Table Name :	cmn_bb_acctpost_metadata
Comment :	To store the Accounting Postings Related static Metadata for BB Invoice

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
apm_event_id	fin_event	Varchar(40)	Yes	Event Id	No
apm_doc_trn_type	fin_designparamcode	varchar(5)	Yes	Document Tran Type	No
apm_billable	fin_flag	varchar(25)	Yes	Billable	No
apm_doc_type	fin_flag	varchar(25)	Yes	Document type	No
apm_matching_type	fin_designparamcode	varchar(5)	Yes	Matching Type	No
apm_recptrecordopt	fin_designparamcode	varchar(5)	Yes	Recipient Record adopt	No
apm_exp_type	fin_designparamcode	varchar(5)	Yes	expieriment type	No
apm_part_exppolicy	fin_designparamcode	varchar(5)	Yes	part expirement policy	No
apm_entity_accounted	fin_flag	varchar(25)	Yes	entity accounted	No
apm_dr_accounttype	fin_usageid	varchar(20)	Yes	debited account type	No
apm_cr_accounttype	fin_usageid	varchar(20)	Yes	credited account type	No
apm_dr_fbtype	fin_financebookid	varchar(20)	Yes	debited finance book type	No
apm_cr_fbtype	fin_financebookid	varchar(20)	Yes	credited finance book type	No
apm_dr_cctype	fin_flag	varchar(25)	Yes	debited cost center type	No
apm_cr_cctype	fin_flag	varchar(25)	Yes	credited cost center type	No
apm_dr_analtype	fin_flag	varchar(25)	Yes	debited analysis type	No
apm_cr_analtype	fin_flag	varchar(25)	Yes	credited analysis type	No
apm_dr_subanaltype	fin_flag	varchar(25)	Yes	debited sub analysis type	No
apm_cr_subanaltype	fin_flag	varchar(25)	Yes	credited sub analysis type	No
apm_line_no	fin_seqno	int(4)	Yes	line no	No
apm_posting_id	fin_param_text	varchar(255)	Yes	posting id	No
apm_prtexp_type	fin_designparamcode	varchar(5)	Yes	part expence type	No
apm_ownership	fin_designparamcode	varchar(5)	Yes	ownership	No
apm_setoption	fin_designparamcode	varchar(5)	Yes	set option	No
replication_key	uniqueidentifier	Varchar(160)	Yes	replication key	No