Data Dictionary -- Supplier Direct Invoice

Srl. No.	Table Name	Comment
1	sdin_adjustments_dtl	To store information of adjustments detail
2	sdin_apportioned_tcd_dtl	To store information of apportioned tcd details
3	sdin_ap_postings_dtl	To store information of apportioned postings details
4	sdin_asset_dtl	To store information of asset detail
5	sdin_expense_dtl	To store information of expense detail
6	sdin_invoice_fndef_dtl	To store information of invoice definition detail
7	sdin_invoice_hdr	To store information of invoice header
8	sdin_item_dtl	To store information of item detail
9	sdin_notes_dtl	To store information of notes detail
10	sdin_payment_dtl	To store information of payment detail
11	sdin_tcd_dtl	To store information of tcd detail
12	sdin_vat_dtl	To store information of vat detail

Table Name :	sdin_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	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 :	sdin_apportioned_tcd_dtl
Comment :	To store information of 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 :	sdin_ap_postings_dtl
Comment :	To store information of apportioned postings details

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
posting_line_no	fin_lineno	int(4)	No	Posting line number	No
timestamp	fin_int	int(4)	No	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 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 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
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
vat_line_no	fin_lineno	int(4)	Yes	Vat line number	No
remarks	fin_txt255	varchar(255)	Yes	Remarks	No
expense_class	fin_quickcode	varchar(20)	Yes	Expense class	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes
exp_acct_flag	fin_designparamcode	varchar(5)	Yes	Expense Accounting Flag	No
refdoctype_code	fin_desc5	varchar(5)	Yes	Refdoctype code	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	Shopworkorder 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 :	sdin_asset_dtl
Comment :	To store information of asset detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
guid	fin_guid	varchar(40)	Yes	Guid	No
tran_type	fin_cmntrantype	varchar(10)	Yes	Transaction type	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
tran_no	fin_documentnumber	varchar(18)	Yes	Transaction number	No
tran_ou	fin_ouinstid	int(4)	Yes	Transaction OU	No
supp_code	fin_suppliercode	varchar(16)	Yes	Supplier code	No
supp_name	fin_suppliername	varchar(40)	Yes	Supplier name	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
line_no	fin_lineno	int(4)	Yes	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
proposal_no	fin_documentnumber	varchar(18)	Yes	Proposal number	No
item_amount	fin_amount	numeric(13)	Yes	Item 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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	sdin_expense_dtl
Comment :	To store information of expense 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
base_value	fin_amount	numeric(13)	Yes	Base value	No
expense	fin_desc40	varchar(40)	Yes	Expense	No
usage	fin_finusage	varchar(40)	Yes	Usage	No
uom	fin_uom	varchar(15)	Yes	UOM	No
item_qty	fin_quantity	numeric(17)	Yes	Item quantity	No
item_rate	fin_amount	numeric(13)	Yes	Item rate	No
rate_per	fin_quantity	numeric(17)	Yes	Rate percent	No
item_amount	fin_amount	numeric(13)	Yes	Item 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
createdby	fin_ctxt_user	varchar(30)	Yes	Createdby	No
createddate	fin_datetime	datetime(8)	Yes	Createddate	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modifiedby	No
modifieddate	fin_datetime	datetime(8)	Yes	Modifieddate	No
expense_class	fin_quickcode	varchar(20)	Yes	Expense class	No
destn_fbid	fin_financebook	Varchar(40)	Yes	Destination finance book id	No
destn_usage	fin_finusage	varchar(40)	Yes	Destination usage	No
interfjvno	fin_documentno	varchar(40)	Yes	interfjvno	No
ref_no	fin_txt255	varchar(255)	Yes	Reference number	No
Mntobjtype	fin_designparamcode	varchar(5)	Yes	Mntobjtype	No
Mntobjno	fin_componentid	varchar(90)	Yes	Mntobjno	No
custorder_no	fin_documentno	varchar(40)	Yes	custorder_no	No
ame_no	fin_documentno	varchar(40)	Yes	ame_no	No
swo_no	fin_documentno	varchar(40)	Yes	swo_no	No
task_no	fin_taskno	varchar(40)	Yes	task_no	No
task_seqno	fin_seqno	int(4)	Yes	task_seqno	No
dummy_task_no	fin_taskno	varchar(40)	Yes	dummy_task_no	No
Exptype	fin_designparamcode	varchar(5)	Yes	Expense type	No
Proposal_no	fin_documentno	varchar(40)	Yes	Proposal number	No
exp_acct_flag	fin_designparamcode	varchar(5)	Yes	expense accounting flag	No

Table Name :	sdin_invoice_fndef_dtl
Comment :	To store information of 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 :	sdin_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	Transaction OU	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	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
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	Pay term	No
payterm_version	fin_lineno	int(4)	Yes	Payterm version	No
elec_pay	fin_chkflag	varchar(1)	Yes	Electronic payment	No
pay_method	fin_method	varchar(30)	Yes	Payment method	No
pay_to_supp	fin_suppliercode	varchar(16)	Yes	payment to supplier	No
pay_mode	fin_paymode	varchar(25)	Yes	Payment mode	No
pay_priority	fin_flag1	varchar(25)	Yes	Payment priority	No
payment_ou	fin_ouinstid	int(4)	Yes	Payment OU	No
supp_code	fin_suppliercode	varchar(16)	Yes	Supplier code	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
supp_ou	fin_ouinstid	int(4)	Yes	Supplier OU	No
comments	fin_txt255	varchar(255)	Yes	Comments	No
address1	fin_txt255	varchar(255)	Yes	Address 1	No
address2	fin_txt255	varchar(255)	Yes	Address 2	No
address3	fin_txt255	varchar(255)	Yes	Address 3	No
city	fin_city	varchar(40)	Yes	City	No
state	fin_state	varchar(40)	Yes	State	No
country	fin_country	varchar(40)	Yes	Country	No
zip	fin_zip	varchar(20)	Yes	Zip	No
phone	fin_communicationid	varchar(30)	Yes	Phone	No
telex	fin_communicationid	varchar(30)	Yes	Telex	No
fax	fin_communicationid	varchar(30)	Yes	Fax	No
pager	fin_communicationid	varchar(30)	Yes	Pager	No
mobile	fin_communicationid	varchar(30)	Yes	Mobile	No
mailstop	fin_mailstop	varchar(20)	Yes	Mailstop	No
email	fin_email	varchar(60)	Yes	Email	No
url	fin_url	varchar(50)	Yes	URL	No
contact	fin_contact	varchar(40)	Yes	Contact	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	Reversa 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	Partid 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 discount	No
vat_incl	fin_chkflag	varchar(1)	Yes	Vat inclusive	No
retain_init_distbn	fin_chkflag	varchar(1)	Yes	Retain initail 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
esrflag	fin_flag	varchar(25)	Yes	esrflag	No
expense_category	fin_quickcode	varchar(20)	Yes	Expence category	No
sdin_wf_doc_key	fin_flag	varchar(25)	Yes	sdin_wf_doc_key	No
sdin_wf_new_state	fin_txt150	varchar(150)	Yes	sdin_wf_new_state	No
hldinv_flag	fin_designparamcode	varchar(5)	Yes	Hold invoice flag	No

Table Name :	sdin_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
base_value	fin_amount	numeric(13)	Yes	Base value	No
visible_line_no	fin_lineno	int(4)	Yes	Visible line number	No
gr_ou	fin_ouinstid	int(4)	Yes	Group OU	No
gr_no	fin_documentnumber	varchar(18)	Yes	Group 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
uom	fin_uom	varchar(15)	Yes	UOM	No
item_qty	fin_quantity	numeric(17)	Yes	Item quantity	No
item_rate	fin_amount	numeric(13)	Yes	Item rate	No
rate_per	fin_quantity	numeric(17)	Yes	Rate percent	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	Parallel currency base amount	No
usage	fin_finusage	varchar(40)	Yes	Usage	No
proposal_no	fin_documentnumber	varchar(18)	Yes	Proposal 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
rcpt_qty	fin_quantity	numeric(17)	Yes	Receipt 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 :	sdin_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
line_no	fin_lineno	int(4)	No	Line number	Yes
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 :	sdin_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 :	sdin_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 acurrency	No
usage	fin_finusage	varchar(40)	Yes	Usage	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 :	sdin_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
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	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 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
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