Data Dictionary -- Customer Debit Credit Note

Srl. No.	Table Name	Comment
1	cdcn_acc_dtl	To store information of account detail
2	cdcn_adjustments_dtl	To store information of adjustment detail
3	cdcn_apportioned_tcd_dtl	To store information of apportioned tcd detail
4	cdcn_ar_postings_dtl	To store information of apportioned posting detail
5	cdcn_dcnote_fndef_dtl	To store information of transaction number and type of each supplier note
6	cdcn_dcnote_hdr	To store information of transaction number of each supplier note
7	cdcn_item_dtl	To store information of item detail
8	cdcn_notes_dtl	To store information of notes detail
9	cdcn_payment_dtl	To store information of payment detail
10	cdcn_tcd_dtl	To store information of tcd detail
11	cdcn_vat_dtl	To store information of vat detail

Table Name :	cdcn_acc_dtl
Comment :	To store information of account 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
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_id	fin_chkflag	varchar(1)	Yes	Debit credit 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
ref_doc_date	fin_datetime	datetime(8)	Yes	Reference document date	No
ref_doc_amount	fin_amount	numeric(13)	Yes	Reference document amount	No
ordering_ou	fin_ouinstid	int(4)	Yes	Ordering OU	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	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
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel currency 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
expense_class	fin_quickcode	varchar(20)	Yes	Expense class	No

Table Name :	cdcn_adjustments_dtl
Comment :	To store information of adjustment 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
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 finance book id	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 supplier 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 :	cdcn_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	Transaction OU	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 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

Table Name :	cdcn_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	Transaction OU	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_accounttype	varchar(15)	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 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
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_customercode	varchar(16)	Yes	Customer code	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
ref_tran_type	fin_cmntrantype	varchar(10)	Yes	Reference transaction type	No
uom	fin_uom	varchar(15)	Yes	UOM	No
org_vat_base_amt	fin_amount	numeric(13)	Yes	Organization vat base amount	No
vat_line_no	fin_lineno	int(4)	Yes	Vat line number	No
expense_class	fin_quickcode	varchar(20)	Yes	Expense class	No

Table Name :	cdcn_dcnote_fndef_dtl
Comment :	To store information of transaction number and type of each supplier note

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
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 :	cdcn_dcnote_hdr
Comment :	To store information of transaction number of each supplier note

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
timestamp	fin_int	int(4)	Yes	Timestamp	No
tran_status	fin_abbreviation	varchar(3)	Yes	Transaction status	No
note_type	fin_abbreviation	varchar(3)	Yes	Note type	No
note_cat	fin_abbreviation	varchar(3)	Yes	Note category	No
num_type	fin_notypeno	varchar(10)	Yes	Numbering type	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
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	Pay term	No
payterm_version	fin_lineno	int(4)	Yes	Payterm version	No
elec_pay	fin_chkflag	varchar(1)	Yes	Electronic payment	No
pay_mode	fin_paymode	varchar(25)	Yes	Payment mode	No
pay_method	fin_method	varchar(30)	Yes	Payment method	No
cust_ou	fin_ouinstid	int(4)	Yes	Customer OU	No
cust_code	fin_customer_id	varchar(18)	Yes	Customer code	No
cust_note_no	fin_documentnumber	varchar(18)	Yes	Customer note number	No
cust_note_date	fin_datetime	datetime(8)	Yes	Customer note date	No
cust_note_amount	fin_amount	numeric(13)	Yes	Customer note amount	No
comments	fin_comments	varchar(256)	Yes	Comments	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	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
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel 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_reasoncode	varchar(10)	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_reasoncode	varchar(10)	Yes	Hold reason code	No
hld_remarks	fin_remarks	varchar(100)	Yes	Hod 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
discount_proportional	fin_chkflag	varchar(1)	Yes	Discount proportional	No
comp_bp_code	fin_bankcode	varchar(32)	Yes	Comp bp	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 inclusive	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 inclusive amount	No
pre_round_off_amount	fin_amount	numeric(13)	Yes	Pre roundofff amount	No
rounded_off_amount	fin_amount	numeric(13)	Yes	Rounded off 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
forward_cover	fin_desc20	varchar(20)	Yes	Forward cover	No
Fw_cov_flag	fin_desc20	varchar(20)	Yes	Forward coverage flag	No
Fw_cov_rate	fin_exchangerate	numeric(9)	Yes	Forward coverage rate	No
usageid	fin_usageid	varchar(20)	Yes	Usage id	No
exchangerateat	fin_designparamcode	Varchar(5)	Yes	Exchangerate at	No
adj_voucher_no	fin_documentno	varchar(40)	Yes	Adj Voucher No	No
ref_doc_type	fin_type	Varchar(25)	Yes	Ref Doc Type	No
tran_amount_cpa	fin_amount	numeric(13)	Yes	Tran Amount Cpa	No
base_amount_cpa	fin_amount	numeric(13)	Yes	Base Amount Cpa	No
Taxdoc_flag	fin_designparamcode	Varchar(5)	Yes	Tax Doc flag	No

Table Name :	cdcn_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	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
visible_line_no	fin_lineno	int(4)	Yes	Visible line number	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
po_ou	fin_ouinstid	int(4)	Yes	Purchase order Ou	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
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
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
ref_doc_line	fin_lineno	int(4)	Yes	Reference document line number	No
base_value	fin_amount	numeric(13)	Yes	Base value	No

Table Name :	cdcn_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	Transaction OU	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
note_category	fin_category	varchar(15)	No	Note number	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

Table Name :	cdcn_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	Yes
tran_ou	fin_ouinstid	int(4)	No	Transaction OU	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
term_no	fin_termnumber	varchar(20)	No	Term number	Yes
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 component 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

Table Name :	cdcn_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	Transaction OU	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	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

Table Name :	cdcn_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	Transaction OU	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
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 discount 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