Data Dictionary -- Supplier Order Based Invoice

Srl. No.	Table Name	Comment
1	fin_sin_inv_postings_met	Metadata for supplier Invoice related cost booking
2	sin_adjustments_dtl	To store information about adjustments details
3	sin_apportioned_tcd_dtl	To store information about apportioned tcd details
4	sin_ap_postings_dtl	To store information about postings detail
5	sin_dc_apportion_dtl	Delivery Charge Apportion details
6	sin_delivery_charge_dtl	To store information about delivery charge details
7	sin_invoice_fndef_dtl	To store invoice definition detail
8	sin_invoice_hdr	To store information about invoice header
9	sin_item_dtl	To store information about item detail
10	sin_notes_dtl	To store information about notes detail
11	sin_payment_dtl	To store information about payment detail
12	sin_po_gr_map	To store information about actual billed quantity for each transations
13	sin_reconcile_dtl	To store information about reconsile detail
14	sin_reconcile_hdr	To store information about reconsile header
15	sin_susp_upd_dtl	To store informtion about suspension upd detail
16	sin_tcd_dtl	To store informtion about tcd detail
17	SIN_TCD_PO_GR_MAP	To store information about tcd actual billed quantity for each transations
18	sin_vat_dtl	To store information about Vat detail

Table Name :	fin_sin_inv_postings_met
Comment :	Metadata for supplier Invoice related cost booking

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
component	fin_component	varchar(16)	Yes	Component Name	No
entity	fin_flag	varchar(25)	Yes	Entity name	No
row_type	fin_flag	varchar(25)	Yes	Row type	No
ord_exp_type	fin_designparamcode	varchar(5)	Yes	Order expense type	No
match_type	fin_type	varchar(25)	Yes	match type	No
drcr_flag	fin_flag	varchar(25)	Yes	Debit/credit flag	No
tcd_on	fin_category	varchar(15)	Yes	TCD on	No
usg_flag	fin_flag	varchar(25)	Yes	Usage flag	No
dr_Acc	fin_accounttype	varchar(15)	Yes	Debit Account type	No
cr_acc	fin_accounttype	varchar(15)	Yes	Credit Account type	No
ref_doc_type	fin_type	varchar(25)	Yes	Reference Document type	No
inv_cat	fin_category	varchar(15)	Yes	Invoice category	No
charge_opt	fin_designparamcode	varchar(5)	Yes	Charge option	No

Table Name :	sin_adjustments_dtl
Comment :	To store information about adjustments details

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 fb 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 :	sin_apportioned_tcd_dtl
Comment :	To store information about apportioned tcd details

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 :	sin_ap_postings_dtl
Comment :	To store information about postings 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
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
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
vat_line_no	fin_lineno	int(4)	Yes	Vat line number	No
refdoctype_code	fin_desc5	varchar(5)	Yes	Reference document type	No
refdoc_no	fin_documentno	varchar(40)	Yes	Reference document number	No
custorder_no	fin_documentno	varchar(40)	Yes	Customer order number	No
ame_no	fin_documentno	varchar(40)	Yes	AME Number	No
swo_no	fin_documentno	varchar(40)	Yes	Shop work order number	No
customer_id	fin_customer_id	varchar(18)	Yes	Customer Id	No
supplier_Id	fin_vendorcode	varchar(45)	Yes	Supplier Id	No
exchord_no	fin_documentno	varchar(40)	Yes	Exchange order number	No

Table Name :	sin_dc_apportion_dtl
Comment :	Delivery Charge Apportion details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_type	fin_cmntrantype	varchar(10)	No	Transaction type for Delivery Charge Invoice	No
tran_ou	fin_ouinstid	int(4)	No	Transaction Ou	No
tran_no	fin_documentnumber	varchar(18)	No	Transaction Number	No
tran_line_no	fin_lineno	int(4)	No	Transaction line number in apportion details	No
timestamp	fin_int	int(4)	Yes	Time stamp	No
ref_doc_no	fin_documentnumber	varchar(18)	Yes	Reference Document Number	No
ref_doc_type	fin_cmntrantype	varchar(10)	Yes	Reference Document Type	No
ref_doc_ou	fin_ouinstid	int(4)	Yes	Reference Document Ou	No
po_no	fin_documentnumber	varchar(18)	Yes	Purchase Order Number	No
tcd_code	fin_itemcode	varchar(40)	Yes	TCD Code	No
tcd_variant	fin_itemcode	varchar(40)	Yes	TCD variant	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction Amount	No
proposed_amount	fin_amount	numeric(13)	Yes	Proposed Amount	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
tcd_type	fin_flag1	varchar(25)	Yes	TCD Type	No
tcd_level	fin_type	varchar(25)	Yes	TCD Level	No
ref_doc_line_no	fin_lineno	int(4)	Yes	Ref.Document Line Number	No
tcdversionno	fin_lineno	int(4)	Yes	TCD version	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	fin_date	datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	fin_date	datetime(8)	Yes	Modified Date	No
costcenter	fin_costcentercode	varchar(10)	Yes	Cost Center	No
part_no	fin_documentno	varchar(40)	Yes	Part number	No
waybill_no_inv	fin_documentno	varchar(40)	Yes	Way bill number in Invoice	No
waybill_no_recp	fin_documentno	varchar(40)	Yes	Waybill number in Receipt	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis Code	No
subanalysis_code	fin_analysiscode	varchar(5)	Yes	Sub Analysis Code	No
Charge_option	fin_designparamcode	varchar(5)	Yes	Charge type for the document	No
refdoc_date	fin_date	datetime(8)	Yes	Ref. Document date	No
expense_class	fin_classification	varchar(20)	Yes	Expense Classificaion	No
part_desc	fin_txt255	varchar(255)	Yes	Part Description	No
orgin_point	fin_ouinstname	varchar(16)	Yes	Originating Point	No
posting_line_no	fin_int	int(4)	Yes	Posting Line number	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
gr_base_amount	fin_amount	numeric(13)	Yes	GR amount	No
gr_tran_amount	fin_amount	numeric(13)	Yes	GR Base Amount	No
part_qty	fin_quantity	numeric(17)	Yes	Part Quantity	No

Table Name :	sin_delivery_charge_dtl
Comment :	To store information about delivery charge details

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
tran_line_no	fin_lineno	int(4)	No	Transaction line number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
ref_doc_no	fin_documentnumber	varchar(18)	Yes	Reference document number	No
ref_doc_type	fin_cmntrantype	varchar(10)	Yes	Reference document type	No
ref_doc_ou	fin_ouinstid	int(4)	Yes	Reference document OU	No
po_no	fin_documentnumber	varchar(18)	Yes	Purchase order number	No
tcd_code	fin_itemcode	varchar(40)	Yes	tcd code	No
tcd_variant	fin_itemcode	varchar(40)	Yes	tcd variant	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
proposed_amount	fin_amount	numeric(13)	Yes	Proposed amount	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
tcd_type	fin_flag1	varchar(25)	Yes	tcd type	No
ref_doc_line_no	fin_lineno	int(4)	Yes	Reference document line number	No
tcdversionno	fin_lineno	int(4)	Yes	tcd version 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
costcenter	fin_costcentercode	varchar(10)	Yes	Cost center	No
waybill_no_inv	fin_documentno	varchar(40)	Yes	way bill number in Invoice	No
waybill_no_recp	fin_documentno	varchar(40)	Yes	way bill number in Receipt	No
analysis_code	fin_analysiscode	varchar(5)	Yes	analysis code	No
subanalysis_code	fin_analysiscode	varchar(5)	Yes	Sub analysis code	No
charge_option	fin_designparamcode	varchar(5)	Yes	Charge Option	No
refdoc_date	fin_date	datetime(8)	Yes	Reference Document Date	No
expense_class	fin_classification	varchar(20)	Yes	Expense classifiction	No
part_no	fin_documentno	varchar(40)	Yes	Part number	No
part_desc	fin_text255	varchar(255)	Yes	Part description	No
orgin_point	fin_desc40	varchar(40)	Yes	Originating Point	No
tcd_level	fin_type	varchar(25)	Yes	TCD Level	No
gr_tcd_erate	fin_exchangerate	numeric(9)	Yes	GR TCD Ex Rate	No
tcd_currency	fin_currency	varchar(5)	Yes	TCD Currency	No
gr_tran_amount	fin_amount	numeric(13)	Yes	GR amount	No
gr_base_amount	fin_amount	numeric(13)	Yes	GR base amount	No
base_amount	fin_amount	numeric(13)	Yes	Invoice Base Amount	No

Table Name :	sin_invoice_fndef_dtl
Comment :	To store invoice definition 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
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 :	sin_invoice_hdr
Comment :	To store information about 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	Transaction OU	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transcation number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
tran_status	fin_abbreviation	varchar(3)	Yes	Transaction status	No
invoce_cat	fin_status	varchar(25)	Yes	Invoice 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
auto_adjust	fin_chkflag	varchar(1)	Yes	Auto adjust	No
auto_match	fin_chkflag	varchar(1)	Yes	Auto match	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 pay	No
pay_method	fin_method	varchar(30)	Yes	Payment method	No
pay_priority	fin_priority	varchar(12)	Yes	Payment priority	No
payment_ou	fin_ouinstid	int(4)	Yes	Payment OU	No
pay_mode	fin_paymode	varchar(25)	Yes	Payment mode	No
supp_code	fin_suppliercode	varchar(16)	Yes	Supplier code	No
pay_to_supp	fin_suppliercode	varchar(16)	Yes	Payment	No
supp_invoice_no	fin_invoicenumber	varchar(18)	Yes	Supplier invoice number	No
supp_invoice_date	fin_datetime	datetime(8)	Yes	Supplier invoice date	No
supp_invoice_amount	fin_amount	numeric(13)	Yes	Supplier invoice amount	No
comments	fin_txt255	varchar(255)	Yes	Comments	No
proposed_amount	fin_amount	numeric(13)	Yes	Proposed amount	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 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
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 in digits	No
refno_digits	fin_number	int(4)	Yes	Reference number in 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
utilized_invtol_per	fin_amount	numeric(13)	Yes	Utilized invoice tolerance	No
unmatched_per	fin_amount	numeric(13)	Yes	Unmatched percent	No
forcemth_tolper_applied	fin_amount	numeric(13)	Yes	Forcemth tolper applied	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
auto_match_tolper	fin_amount	numeric(13)	Yes	Auto match tolper	No
esr_flag	fin_flag	varchar(25)	Yes	esr flag	No
Foward_Cover_Appl	udd_designparamcode	varchar(5)	Yes	Forward cover applied	No
dc_invoice_type	fin_doctype	varchar(40)	Yes	Document invoice type	No
SIN_WF_DOC_KEY	fin_flag	varchar(25)	Yes	SIN_WF_DOC_KEY	No
SIN_WF_NEW_STATE	fin_txt150	varchar(150)	Yes	SIN_WF_NEW_STATE	No
DataExp_Flag	fin_chkflag	varchar(1)	Yes	Data expiry flag	No
variancependingwithbuyer	fin_option	varchar(20)	Yes	Variance pending with buyer	No
automth_failed_on	fin_designparamcode	varchar(5)	Yes	Automth failed on	No
var_accounting_flag	fin_flag	varchar(25)	Yes	Variant accounting flag	No
var_inv_hold_flag	fin_flag	varchar(25)	Yes	Variant invoice hold flag	No
pregrinv_exists	fin_designparamcode	varchar(5)	Yes	Invoice without GR(yes/no)	No

Table Name :	sin_item_dtl
Comment :	To store information about 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	Trancsation number	Yes
line_no	fin_lineno	int(4)	No	Line number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
po_amendment_no	fin_poamendmentno	int(4)	Yes	Purchase order amendment number	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
ref_doc_date	fin_datetime	datetime(8)	Yes	Reference document date	No
pors_type	fin_cmntrantype	varchar(10)	Yes	pors_type	No
po_no	fin_documentnumber	varchar(18)	Yes	Purchase order 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
uom	fin_uom	varchar(15)	Yes	UOM	No
rate_per	fin_quantity	numeric(17)	Yes	Rate percent	No
invoice_qty	fin_quantity	numeric(17)	Yes	Invoice quantity	No
invoice_rate	fin_amount	numeric(13)	Yes	Invoice rate	No
invoice_amount	fin_amount	numeric(13)	Yes	Invoice amount	No
proposed_qty	fin_quantity	numeric(17)	Yes	Proposed quantity	No
proposed_rate	fin_amount	numeric(13)	Yes	Proposed rate	No
proposed_amount	fin_amount	numeric(13)	Yes	Proposed amount	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
ref_doc_ou	fin_ouinstid	int(4)	Yes	Reference document OU	No
unmatched_amount	fin_amount	numeric(13)	Yes	Unmatched amount	No
unmatched_perc	fin_amount	numeric(13)	Yes	Unmatched percent	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
item_amount	fin_amount	numeric(13)	Yes	Item amount	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
original_proposed_amt	fin_amount	numeric(13)	Yes	Original proposed amount	No
original_proposed_qty	fin_quantity	numeric(17)	Yes	Original proposed quantity	No
po_line_no	fin_lineno	int(4)	Yes	Purchase order line number	No
ref_doc_line_no	fin_lineno	int(4)	Yes	Reference document line number	No
par_base_amount	fin_amount	numeric(13)	Yes	Par base amount	No
base_value	fin_amount	numeric(13)	Yes	Base 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
item_desc	fin_description	varchar(100)	Yes	Item description	No
po_expense_type	fin_designparamcode	varchar(5)	Yes	Purchase order expense type	No
tax_key	fin_taxkey	varchar(15)	Yes	Tax key	No
taxkey_desc	fin_desc40	varchar(40)	Yes	Taxkey description	No
po_exchange_rate	fin_exchangerate	numeric(9)	Yes	Purchase order exchange rate	No
min_allowed_rate	fin_amount	numeric(13)	Yes	Minimum allowed rate	No
max_allowed_rate	fin_amount	numeric(13)	Yes	Maximum allowed rate	No
min_allowed_amt	fin_amount	numeric(13)	Yes	Minimum allowed amount	No
max_allowed_amt	fin_amount	numeric(13)	Yes	Maximum allowed amount	No
utilized_invtol_per	fin_amount	numeric(13)	Yes	Utilized invoice tolerance	No
positivematch_status	fin_abbreviation	varchar(3)	Yes	Positive match status	No
negativematch_status	fin_abbreviation	varchar(3)	Yes	Negative match status	No
forcemth_tolper_applied	fin_amount	numeric(13)	Yes	Forcemth tolper applied	No
FacObj_Code	fin_documentnumber	varchar(18)	Yes	FacObj_Code	No
FacObj_Type	fin_documentnumber	varchar(18)	Yes	FacObj_Type	No
Part_LotNum	fin_partserialnumber	varchar(40)	Yes	Part lot number	No
Part_SerialNum	fin_partserialnumber	varchar(40)	Yes	Part serial number	No
Part_Type	fin_parttype	varchar(25)	Yes	Part type	No
Salvage_Amount	fin_amount	numeric(13)	Yes	Salvage amount	No
Part_Status	fin_partstatus	varchar(40)	Yes	Part status	No
ro_quotation	fin_documentno	varchar(40)	Yes	ro_quotation	No
order_pay_mode	fin_paymode	varchar(25)	Yes	Order pay mode	No
order_category	fin_invoicecategory	varchar(40)	Yes	Order category	No
RefDoc_PayMode	fin_paymode	varchar(25)	Yes	Reference document payment mode	No
Service_charge	fin_amount	numeric(13)	Yes	Service charge	No
Ber_flag	fin_flag	varchar(25)	Yes	Ber_flag	No
order_currency	fin_currencycode	varchar(5)	Yes	Order currency	No
org_salvage_amount	fin_amount	numeric(13)	Yes	Organization salvage amount	No
proposal_no	fin_documentnumber	varchar(18)	Yes	Proposal number	No
match_type	fin_type	varchar(25)	Yes	Match type	No
OrderAmended	fin_bit	Bit(1)	Yes	Ordder amende	No
gr_avg_erate	fin_exchangerate	numeric(9)	Yes	Group average exchange rate	No
Order_SuppCode	fin_supplier	nvarchar(160)	Yes	Order supplier code	No

Table Name :	sin_notes_dtl
Comment :	To store information about 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
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 :	sin_payment_dtl
Comment :	To store information about payment detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_type	fin_cmntrantype	varchar(10)	No	Transcation type	Yes
tran_ou	fin_ouinstid	int(4)	No	Transcation 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	Yimestamp	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 :	sin_po_gr_map
Comment :	To store information about actual billed quantity for each transations

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
ref_doc_ou	fin_ouinstid	int(4)	No	Reference document OU	Yes
ref_doc_no	fin_documentnumber	varchar(18)	No	Reference document number	Yes
ref_doc_line_no	fin_lineno	int(4)	No	Reference document line number	Yes
po_ou	fin_ouinstid	int(4)	No	Purchase order Ou	Yes
po_no	fin_documentno	varchar(40)	No	Purchase order number	Yes
po_line_no	fin_lineno	int(4)	No	Purchase order line number	Yes
po_amendment_no	fin_poamendmentno	int(4)	No	Purchase order amendment 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
timestamp	fin_int	int(4)	Yes	Timestamp	No
pors_type	fin_cmntrantype	varchar(10)	Yes	pors_type	No
item_type	fin_abbreviation	varchar(3)	Yes	Item type	No
recd_qty	fin_quantity	numeric(17)	Yes	Recorded quantity	No
recd_amount	fin_amount	numeric(13)	Yes	Recorded amount	No
acc_qty	fin_quantity	numeric(17)	Yes	Account quantity	No
acc_amount	fin_amount	numeric(13)	Yes	Account amount	No
billed_qty	fin_quantity	numeric(17)	Yes	Billed quantiy	No
billed_amount	fin_amount	numeric(13)	Yes	Billed amount	No
matching_type	fin_matchingtype	varchar(32)	Yes	Matching type	No
tolerance_type	fin_type	varchar(25)	Yes	Tolerance type	No
tolreance_perc	fin_tolerance	int(4)	Yes	Tolerance percent	No
proposed_qty	fin_quantity	numeric(17)	Yes	Propodsed quantity	No
proposed_rate	fin_rate	numeric(13)	Yes	Proposed rate	No
proposed_amount	fin_amount	numeric(13)	Yes	Propoded amount	No
matched_qty	fin_quantity	numeric(17)	Yes	Matched quantity	No
matched_amount	fin_amount	numeric(13)	Yes	Matched amount	No
match_status	fin_abbreviation	varchar(3)	Yes	Match status	No
positivematch_status	fin_abbreviation	varchar(3)	Yes	Positive match status	No
negativematch_status	fin_abbreviation	varchar(3)	Yes	Negative match status	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 :	sin_reconcile_dtl
Comment :	To store information about reconsile 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
po_ou	fin_ouinstid	int(4)	No	Purchase order	Yes
po_no	fin_documentno	varchar(40)	No	Purchase order number	Yes
po_line_no	fin_lineno	int(4)	No	Purchase order line number	Yes
invoice_ou	fin_ouinstid	int(4)	No	Invoice OU	Yes
invoice_no	fin_documentno	varchar(40)	No	Invoice number	Yes
invoice_line_no	fin_lineno	int(4)	No	Invoice line number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
gr_ou	fin_ouinstid	int(4)	Yes	Group OU	No
gr_no	fin_documentno	varchar(40)	Yes	Group number	No
gr_line_no	fin_lineno	int(4)	Yes	Group line number	No
reconcile_qty	fin_quantity	numeric(17)	Yes	Reconcile quantity	No
inv_tran_type	fin_cmntrantype	varchar(10)	Yes	Invoice transaction type	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 :	sin_reconcile_hdr
Comment :	To store information about reconsile 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	Transaction OU	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
num_type	fin_notypeno	varchar(10)	Yes	Number type	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
tran_currency	fin_currency	varchar(5)	Yes	Transaction currency	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_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
rev_reason_code	fin_quickcodes	varchar(25)	Yes	Reversal reason code	No
rev_remarks	fin_remarks	varchar(100)	Yes	Reversal remarks	No
tran_status	fin_abbreviation	varchar(3)	Yes	Transaction status	No
qty_variance_amount	fin_amount	numeric(13)	Yes	Quantity variance amount	No
rate_variance_amount	fin_amount	numeric(13)	Yes	Rate variance amount	No
exchange_variance_amount	fin_amount	numeric(13)	Yes	Exchange variance amount	No
total_variance_amount	fin_amount	numeric(13)	Yes	Total variance 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 :	sin_susp_upd_dtl
Comment :	To store informtion about suspension upd detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
order_ou	fin_ouinstid	int(4)	Yes	Order Organization unit	No
order_no	fin_documentnumber	varchar(18)	Yes	Order number	No
refdoc_no	fin_documentnumber	varchar(18)	Yes	Reference document number	No
refdoc_lineno	fin_lineno	int(4)	Yes	Reference document line number	No
order_amendno	fin_poamendmentno	int(4)	Yes	Order amendment number	No
tran_line_no	fin_lineno	int(4)	Yes	Transaction line number	No
tran_ou	fin_ouinstid	int(4)	Yes	Transaction OU	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
tran_no	fin_documentnumber	varchar(18)	Yes	Transaction number	No
tran_type	fin_cmntrantype	varchar(10)	Yes	Transaction type	No
tran_date	fin_date	datetime(8)	Yes	Transaction date	No
invoice_cat	fin_status	varchar(25)	Yes	Invoice category	No
tran_status	fin_status	varchar(25)	Yes	Transaction status	No
tran_currency	fin_currency	varchar(5)	Yes	Transaction currency	No
exch_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
suspbal_amount	fin_amount	numeric(13)	Yes	Suspension balance amount	No
updated_date	fin_date	datetime(8)	Yes	Updated date	No
account_type	fin_accounttype	varchar(15)	Yes	account_type	No
replication_key	fin_bigint	Bigint(8)	No	replication_key	Yes

Table Name :	sin_tcd_dtl
Comment :	To store informtion about 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	Transcation 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
tcd_version	fin_macseqno	int(4)	No	tcd version	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
item_tcd_var	fin_itemcode	varchar(40)	No	Item tcd variant	Yes
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
proposed_amount	fin_amount	numeric(13)	Yes	Proposed amount	No
original_proposed_amt	fin_amount	numeric(13)	Yes	Original proposed 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
enflg	fin_flag	varchar(25)	Yes	enflg	No
tcd_exrate	fin_exchangerate	numeric(9)	Yes	tcd exchange rate	No
gr_avg_erate	fin_exchangerate	numeric(9)	Yes	Group average exchange rate	No

Table Name :	SIN_TCD_PO_GR_MAP
Comment :	To store information about tcd actual billed quantity for each transations

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	Transaction OU	No
TRAN_NO	fin_documentnumber	varchar(18)	No	Transaction number	No
LINE_NO	fin_lineno	int(4)	No	Line number	No
REF_DOC_OU	fin_ouinstid	int(4)	No	Reference document OU	No
REF_DOC_NO	fin_documentnumber	varchar(18)	No	Reference document number	No
REF_DOC_LINE_NO	fin_lineno	int(4)	No	Reference document line number	No
PO_OU	fin_ouinstid	int(4)	No	Purchase order OU	No
PO_NO	fin_documentno	varchar(40)	No	Purchase order number	No
PO_LINE_NO	fin_lineno	int(4)	No	Purchase order line number	No
PO_AMENDMENT_NO	fin_poamendmentno	int(4)	No	Purchase order amendment number	No
ITEM_TCD_CODE	fin_itemcode	varchar(40)	No	Item tcd code	No
ITEM_TCD_VAR	fin_itemcode	varchar(40)	No	Item tcd variant	No
TIMESTAMP	fin_int	int(4)	Yes	Timestamp	No
PORS_TYPE	fin_cmntrantype	varchar(10)	Yes	PORS_TYPE	No
ITEM_TYPE	fin_abbreviation	varchar(3)	Yes	Item type	No
RECD_QTY	fin_quantity	numeric(17)	Yes	Record quantity	No
RECD_AMOUNT	fin_amount	numeric(13)	Yes	Record amount	No
ACC_QTY	fin_quantity	numeric(17)	Yes	Account quantity	No
ACC_AMOUNT	fin_amount	numeric(13)	Yes	Account amount	No
BILLED_QTY	fin_quantity	numeric(17)	Yes	Billed quantity	No
BILLED_AMOUNT	fin_amount	numeric(13)	Yes	Billed amount	No
MATCHING_TYPE	fin_matchingtype	varchar(32)	Yes	Matching type	No
TOLERANCE_TYPE	fin_type	varchar(25)	Yes	Tolerance type	No
TOLREANCE_PERC	fin_tolerance	int(4)	Yes	Tolerance percent	No
PROPOSED_QTY	fin_quantity	numeric(17)	Yes	Proposed quantity	No
PROPOSED_RATE	fin_rate	numeric(13)	Yes	Proposed rate	No
PROPOSED_AMOUNT	fin_amount	numeric(13)	Yes	Proposed amount	No
MATCHED_QTY	fin_quantity	numeric(17)	Yes	Matched quantity	No
MATCHED_AMOUNT	fin_amount	numeric(13)	Yes	Matched amount	No
MATCH_STATUS	fin_abbreviation	varchar(3)	Yes	Match status	No
POSITIVEMATCH_STATUS	fin_abbreviation	varchar(3)	Yes	Positive match status	No
NEGATIVEMATCH_STATUS	fin_abbreviation	varchar(3)	Yes	Negative match status	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 :	sin_vat_dtl
Comment :	To store information about 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	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	Correlated 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	Correlated vat base amount	No
account_code	fin_accountcode	varchar(32)	Yes	Account 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