Data Dictionary -- Supplier Debit Credit Note

Srl. No.	Table Name	Comment
1	scdn_acc_dtl	To store information of account detail
2	scdn_adjustments_dtl	To store information of adjustment detail
3	scdn_apportioned_tcd_dtl	To store information of apportioned tcd detail
4	scdn_ap_postings_dtl	To store information of apportioned posting detail
5	scdn_dcnote_fndef_dtl	To store information of transaction number and type of each supplier note
6	scdn_dcnote_hdr	To store information of transaction number of each supplier note
7	scdn_item_dtl	To store information of item detail
8	scdn_notes_dtl	To store information of notes detail
9	scdn_payment_dtl	To store information of payment detail
10	scdn_tcd_dtl	To store information of tcd detail
11	scdn_vat_dtl	To store information of vat detail

Table Name :	scdn_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 flag	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 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
Dest_fb	fin_financebookid	varchar(20)	Yes	Destination finance book	No
Dest_acc_code	fin_accountcode	varchar(32)	Yes	Destination account code	No
Intfbjv	fin_documentno	varchar(40)	Yes	Intfbjv	No

Table Name :	scdn_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 :	scdn_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 :	scdn_ap_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	Tiemstamp	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 flag	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 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
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
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
supp_code	fin_suppliercode	varchar(16)	Yes	Supplier code	No
uom	fin_uom	varchar(15)	Yes	UOM	No
org_vat_base_amt	fin_amount	numeric(13)	Yes	Organization vat base amount	No
cust_code	fin_customercode	varchar(16)	Yes	Customer code	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 :	scdn_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 :	scdn_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	Transcation 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	Transation 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 (yes/no)	No
pay_mode	fin_paymode	varchar(25)	Yes	Payment mode	No
pay_method	fin_method	varchar(30)	Yes	Payment method	No
pay_priority	fin_flag1	varchar(25)	Yes	Payment priority	No
payment_ou	fin_ouinstid	int(4)	Yes	Payment OU	No
supp_ou	fin_ouinstid	int(4)	Yes	Supplier OU	No
supp_code	fin_suppliercode	varchar(16)	Yes	Supplier code	No
supp_note_no	fin_documentnumber	varchar(18)	Yes	Supplier note number	No
supp_note_date	fin_datetime	datetime(8)	Yes	Supplier note date	No
supp_note_amount	fin_amount	numeric(13)	Yes	Supplier note amount	No
comments	fin_txt255	varchar(255)	Yes	Comments	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel currency 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 amount	No
rev_doc_ou	fin_ouinstid	int(4)	Yes	Reversaldocument OU	No
rev_date	fin_datetime	datetime(8)	Yes	Reversal date	No
ref_doc_no	fin_documentnumber	varchar(18)	Yes	Reference document	No
ref_doc_ou	fin_ouinstid	int(4)	Yes	Reference document code	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
discount_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
partid_digits	fin_number	int(4)	Yes	Part id digits	No
refno_digits	fin_number	int(4)	Yes	Reference number digits	No
supp_acct_in	fin_route	varchar(10)	Yes	Supplier account information	No
supp_bp_ref	fin_banknumber	varchar(20)	Yes	Supplier bp reference	No
supp_bp_acc_no	fin_bankcode	varchar(32)	Yes	Supplier bp account number	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 description	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 deducted 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 round off 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
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
usage_id	fin_usageid	varchar(20)	Yes	Usage id	No
esrflag	fin_flag	varchar(25)	Yes	esrflag	No
forward_cover	fin_desc20	varchar(20)	Yes	Forward cover	No
Fw_cov_flag	udd_designparamcode	varchar(5)	Yes	Forward cover flag	No
Fw_cov_rate	fin_rate	numeric(13)	Yes	Forward cover rate	No
taxdoc_flag	fin_designparamcode	varchar(5)	Yes	Tax document flag	No

Table Name :	scdn_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
pors_type	fin_chkflag	varchar(1)	Yes	pors_type	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_amount	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
pors_no	fin_documentnumber	varchar(18)	Yes	pors_no	No
proposal_no	fin_documentnumber	varchar(18)	Yes	Proposal number	No
cap_type_ind	fin_documentnumber	varchar(18)	Yes	Capitalized type	No
ref_doc_line	fin_lineno	int(4)	Yes	Reference document line number	No
base_value	fin_amount	numeric(13)	Yes	Base value	No
expense_class	fin_quickcode	varchar(20)	Yes	Expense class	No

Table Name :	scdn_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 category	Yes
category_value	fin_desc40	varchar(40)	No	Category value	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
note_text	fin_notes	varchar(2000)	Yes	Note text	No
line_no	fin_lineno	int(4)	Yes	Line 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

Table Name :	scdn_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 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
esr_amount	fin_amount	numeric(13)	Yes	esr amount	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
base_esr_amount	fin_amount	numeric(13)	Yes	Base esr 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 :	scdn_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 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

Table Name :	scdn_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
item_tcd_desc	fin_itemdesc	varchar(150)	Yes	Item tcd description	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	VAT deducted per	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 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	Value add transaction amount	No
vat_base_amount	fin_amount	numeric(13)	Yes	Vat base amount	No
corr_vat_base_amount	fin_amount	numeric(13)	Yes	Value add tax - 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