Supplier Direct Invoice

Supplier Direct Invoice

Table Name fin_advancepaid_dtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
poou	int	Purchase Order Organization Unit
pono	sql_variant	Purchase Order Number
poamendmentno		Purchase Order Amendment Number
trancurrency		Transaction Currency
suppliercode		Supplier Code
advancepaid	bigint	Advance Paid
pay_date	datetime	Pay Date
voucher_no	sql_variant	Voucher Number

Table Name fin_ar_checksum_data

Table Comment Table that contain the checksum string for each check_digits
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
row_idd	tinyint	Row Id	No	No
check_string	sql_variant	Check String
check_digit	tinyint	Check Digit
ver_flag	sql_variant	Verified Flag

Table Name fin_ftcd_doctoline_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
tcdcode		Tax Charge Discount Code
tcdvariant		Tax Charge Discount Variant
versionno	int	Version Number
tcdlineno		Tax Charge Discount Line Number
tcdamount	bigint	Tax Charge Discount Amount
tcdsign	int	Tax Charge Discount Sign
accountrule	sql_variant	Account Rule

Table Name fin_inv_acc_fetch_methods_met
Table Comment Metadata table that contains the control account type and account descr. And the corresponding procedure to be called to fetch the account code
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
component	sql_variant	Component	No	No
acc_type		Account Type
acc_descr		Account Description
acc_level		Account Level
spname		SP Name

Table Name fin_inv_acc_hdr_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
component		Component
acc_type		Account Type
accountcode		Account Code


Table Name fin_inv_line_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tcd_guid	sql_variant	Tax Charge Discount Guid	No	No
tcd_lineno	int	Tax Charge Discount Line Number
tcd_basicvalue	bigint	Tax Charge Discount Basic Value
tcd_quantity		Tax Charge Discount Quantity


Table Name fin_inv_paydtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
tran_no		Transaction Number
tran_type		Transaction Type
tran_ou	int	Transaction Organization Unit
term_no	sql_variant	Term Number
line_no	int	Line Number
posting_status	sql_variant	Posting Status
posting_date	datetime	Posting Date
due_date		Due Date
due_amount_type	sql_variant	Due Amount Type
due_percent	bigint	Due Percentage
due_amount		Due Amount
disc_comp_amount		Discount Computation Amount
disc_amount_type	sql_variant	Discount Amount Type
disc_date	datetime	Discount Date
disc_percent	bigint	Discount Percentage
disc_amount		Discount Amount
penalty_percent		Penalty Percentage
esr_ref_no	sql_variant	ESR Reference Number
esr_coding_line		ESR Coding Line
esr_amount	bigint	ESR Amount
base_due_amount		Base Due Amount
base_disc_amount		Base Discount Amount
base_esr_amount		Base ESR Amount
pay_term	sql_variant	Pay Term
disc_proportional		Discount Proportional
due_days	int	Due Days
discount_days		Discount Days
modifieddate	datetime	Modified Date
esr_partid	sql_variant	ESR Part Id
disc_comp		Discount Computation
PYTMHD_PAY_Clsficatn		Pay Term Header Payment Classification
PYTMHD_PAY_Frequency		Pay Term Header Payment Frequency


Table Name fin_inv_postings_met

Table Comment Metadata table that contains debit and credit control account’s for each components
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
component	sql_variant	Component	No	No
row_type		Row Type
note_type		Note Type
rev_book		Reversal Book
tc_billable		Transaction Billable
freight_term		Freight Term
vat_inclusive		Transaction Currency Billable
tcd_on		Tax Charge Discount On
dr_acc		Debit Account
cr_acc		Credit Account
usage_id		Usage Id
cash_pay		Cash Payment


Table Name fin_inv_tcdcal_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tcdcal_guid	sql_variant	Guid	No	No
tcdcal_tcdcode		Tax Charge Discount Code
tcdcal_tcddocumentlevel		Tax Charge Discount Document Level
tcdcal_tcdvariant		Tax Charge Discount Variant
tcdcal_line_no	int	Line Number
tcdcal_tcd_amount	bigint	Tax Charge Discount Amount
tcdcal_tcd_versionno	int	Tax Charge Discount Version Number
tcdcal_docsupplier	sql_variant	Document Supplier


Table Name fin_inv_vcal_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
component_id	sql_variant	Component Id	No	No
guid		Guid
tran_ou	int	Transaction Organization Unit
totvatexclamtintran	bigint	Excluded total Value Added Tax Amount in Transaction Currency
totvatexclamtinbase		Excluded total Value Added Tax Amount in Base Currency
totvatinclamtintran		Included total Value Added Tax Amount in Transaction Currency
totvatinclamtinbase		Included total Value Added Tax Amount in Base Currency
totvatamtintran		Total Value Added Tax Amount in Transaction Currency
totvatamtinbase		Total Value Added Tax Amount in Base Currency
docleveldiscintran		Document level Discounted Amount in Transaction Currency
docleveldiscinbase		Document level Discounted Amount in Base Currency
totvatablechargtran		Total Vatable Charge Transaction Currency
totvatablechargbase		Total Vatable Charge Base Currency
totnonvatabletran		Other than Total Vatable Charge Transaction Currency
totnonvatablebase		Other than Total Vatable Charge Base Currency
avgvatrate		Average Value Added Tax Rate
vatinclusiveflag_tmp	sql_variant	Value Added Tax Inclusive Flag Temporary
inpvatdedpercent	bigint	Input Value Added Tax Deductible Percentage


Table Name fin_invoice_posting_inputs_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
tran_type		Transaction Type
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number
row_type	sql_variant	Row Type
rev_book		Reversal Book
tc_billable		Transaction Currency Billable
freight_term		Freight Item
vat_inclusive		Value Added Tax Inclusive
note_type		Note Type
tran_amount	bigint	Transaction Amount
tran_currency	sql_variant	Transaction Currency
customergroup		Customer Group
fbid		Finance Book Id
tran_date	datetime	Transaction Date
itemaccountgroup	sql_variant	Item Account Group
saleordertype		Sales Order Type
saletype		Sales Type
salechannel		Sales Channel
deliveryarea		Delivery Area
reciepttype		Receipt Type
tcdcode		Tax Charge Discount Code
tcdvariant		Tax Charge Discount Variant
resouid	int	Resource Id
usageid	sql_variant	Usage Id
processingaction		Processing Action
salepurpose		Sales Purpose
promotionid		Promotion Id
itemcode		Item Code
itemvar		Item Variant
cost_center		Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
accountcode		Account Code
proposal_no		Proposal Number
tcd_on		Tax Charge Discount On
usage_ard_id		Usage Account Rule Definition Id
cash_pay		Cash Payment
quantity	bigint	Quantity
uom	sql_variant	Unit Of Measurement
ref_tran_no		Reference Transaction Number
ref_tran_ou	int	Reference Transaction Organization Unit
ref_tran_type	sql_variant	Reference Transaction Type
ref_tran_fbid		Reference Transaction Finance Book Id
auth_date	datetime	Authorized Date
vatusage	sql_variant	Value Added Tax Usage
grfbid		Goods Receipt Finance Book Id


Table Name fin_invoice_posting_outputs_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	No	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
posting_line_no	int	Posting Line Number
line_no		Line Number
company_code	sql_variant	Company Code
posting_status		Posting Status
posting_date	datetime	Posting Date
fb_id	sql_variant	Finance Book Id
tran_date	datetime	Transaction Date
account_type	sql_variant	Account Type
account_code		Account Code
drcr_id		Debit Credit Id
tran_currency		Transaction Currency
tran_amount	bigint	Transaction Amount
exchange_rate		Exchange Rate
base_amount		Base Amount
par_exchange_rate		Parallel Exchange Rate
par_base_amount		Parallel Base Amount
cost_center	sql_variant	Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
guid		Guid
quantity	bigint	Quantity
uom	sql_variant	Unit Of Measurement
ref_tran_no		Reference Transaction Number
ref_tran_ou	int	Reference Transaction Organization Unit
ref_tran_type	sql_variant	Reference Transaction Type
ref_tran_fbid		Reference Transaction Finance Book Id
auth_date	datetime	Authorized Date
entry_date		Entry Date
supp_code	sql_variant	Supplier Code
item_code		Item Code
item_variant		Item Variant
org_vat_base_amt	bigint	Organization Value Added Tax Base Amount
vat_line_no	int	Value Added Tax Line Number
vatusage		Value Added Tax Usage


Table Name fin_is_translate_error_met
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
source_component_id	sql_variant	Source Component Id	No	No
source_sp_name		Source SP Name
sp_ret_err_no	int	SP Return Error Number
calling_component_id	sql_variant	Calling Component Od
calling_sp_name		Calling SP Name
error_number	int	Error Number


Table Name fin_m_sys_params
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
param_value	sql_variant	Parameter Value	No	No
company_no		Company Number
locn_no		Location Number
appln_name		Application Name
param_name		Parameter Name


Table Name fin_postings_dtl

Table Comment Posting table that contains the debit and credit amounts for each transactions
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	No	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
posting_line_no	int	Posting Line Number
timestamp		Time Stamp
line_no		Line Number
company_code	sql_variant	Company Code
posting_status		Posting Status
posting_date	datetime	Posting Date
fb_id	sql_variant	Finance Book Id
tran_date	datetime	Transaction Date
account_type	sql_variant	Account Type
account_code		Account Code
drcr_id		Debit Credit Id
tran_currency		Transaction Currency
tran_amount	bigint	Transaction Amount
exchange_rate		Exchange Rate
base_amount		Base Amount
par_exchange_rate		Parallel Exchange Rate
par_base_amount		Parallel Base Amount
cost_center	sql_variant	Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
guid		Guid
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
entry_date		Entry Date
auth_date		Authorized Date
item_code	sql_variant	Item Code
item_variant		Item Variant
quantity	bigint	Quantity
reftran_fbid	sql_variant	Reference Transaction Finance Book Id
reftran_no		Reference Transaction Number
reftran_ou	int	Reference Transaction Organization Unit
ref_tran_type	sql_variant	Reference Transaction Type
custsupp_code		Customer Supplier Code
uom		Unit Of Measurement
org_vat_base_amt	bigint	Organization Value Added Tax Base Amount
vat_exchg_rate		Value Added Tax Exchange Rate
vat_line_no	int	Value Added Tax Line Number


Table Name fin_quick_code_met_tmp1
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
component_id	sql_variant	Component Id	No	No
parameter_type		Parameter Type
parameter_category		Parameter Category
parameter_code		Parameter Code
parameter_text		Parameter Text
timestamp	int	Time Stamp
language_id		Language Id
extension_flag	sql_variant	Extension Flag
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name fin_vat_dtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
tran_type		Transaction Type
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
vat_line_no	int	Line Number
timestamp		Time Stamp
doc_line_no		Document Line Number
item_type	sql_variant	Item Type
account_code		Account Code
item_tcd_code		Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
item_tcd_desc		Item Tax Charge Discount Description
vat_category		Value Added Tax Category
vat_class		Value Added Tax Class
tcd_var		Tax Charge Discount Variant
vat_rate	bigint	Value Added Tax Rate
inp_vat_deduct_per		Input Value Added Tax Deduction Per
item_amount		Item Amount
vat_item_charge		Value Added Tax Item Charge
non_vat_item_charge		Other Than Value Added Tax Item Charge
vat_dist_charge		Value Added Tax Distribution Charge
item_level_disc_amount		Item Level Discount Amount
dist_disc_amount		Distribution Discount Amount
vat_tran_amount		Value Added Tax Transaction Amount
corr_vat_tran_amount		Corrected Value Added Tax Transaction Amount
vat_base_amount		Value Added Tax Base Amount
corr_vat_base_amount		Corrected Value Added Tax Base Amount
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name fin_wf_input
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
log_role	sql_variant	Login Role	No	No
log_user		Login User
log_orgunitid	bigint	Login Organization Unit Id
doc_area_code	sql_variant	Document Area Code
doc_componentcd		Document Component Tax Charge Discount
doc_activitycd		Document Activity Code
doc_taskcd		Document Task Code
doc_orgunitid	bigint	Document Organization Unit Id
doc_parameter	sql_variant	Document Parameter
doc_current_state		Document Current State
doc_action_combo_val		Document Action Combo Value
doc_newst_todo_user_ou	bigint	Document User organization Unit
doc_newst_todo_user	sql_variant	Document User
doc_key		Document Key
doc_unique_id		Document Unique Id
doc_date		Document Date
doc_auth_flag		Document Authorized Flag
doc_float_dummy_1	bigint	Document Float Dummy 1
doc_float_dummy_2		Document Float Dummy 2
doc_char_dummy_1	sql_variant	Document Character Dummy 1
doc_char_dummy_2		Document Character Dummy 2
doc_guid		Document Guid
service		Service


Table Name fin_wf_output
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
doc_success_flag		Document Success Flag
errorid	int	Error Id
doc_new_state	sql_variant	Document New State
doc_open_status		Document Open Status
doc_todo_systsk_flag		Document To Do System Task Flag
doc_key		Document Key


Table Name fin_wf_param_codeval
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
param_code		Parameter Code
param_value		Parameter Value
component_id		Component Id
doc_key		Document Key


Table Name sdin_acc_info_dtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
inv_number		Invoice Number
tran_currency		Transaction Currency
account_code		Account Code
analysis_code		Analysis Code
base_amount	bigint	Base Amount
exchange_rate		Exchange Rate
cost_center	sql_variant	Cost Center
drcr_id		Debit Credit Id
fb_id		Finance Book Id
par_base_amount	bigint	Parallel Base Amount
par_exchange_rate		Parallel Exchange Rate
subanalysis_code	sql_variant	Subanalysis Code
tran_no		Transaction Number
tran_amount	bigint	Transaction Amount
tran_type	sql_variant	Transaction Type
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name sdin_acc_info_hdr_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
inv_number		Invoice Number
tran_no		Transaction Number
tran_date	datetime	Transaction Date
tran_type	sql_variant	Transaction Type
posting_date	datetime	Posting Date
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name sdin_acc_info_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
tran_no		Transaction Number
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name sdin_adjustments_dtl
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
ref_doc_type		Reference Document Type
ref_doc_no		Reference Document Number
timestamp	int	Time Stamp	No
ref_doc_date	datetime	Reference Document Date
ref_doc_fb_id	sql_variant	Reference Document Finance Book Id
ref_doc_amount	bigint	Reference Document Amount
ref_doc_current_os		Reference Document Current Outstanding
ref_doc_supp_ou	int	Reference Document Supplier Outstanding
guid	sql_variant	Guid
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
ref_doc_type		Reference Document Type
ref_doc_no		Reference Document Number

Table Name sdin_adjustments_dtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
tran_ou		Transaction Organization Unit
tran_type	sql_variant	Transaction Type
tran_no		Transaction Number
ref_doc_type		Reference Document Type
ref_doc_no		Reference Document Number
ref_doc_date	datetime	Reference Document Date
ref_doc_fb_id	sql_variant	Reference Document Finance Book Id
ref_doc_amount	bigint	Reference Document Amount
ref_doc_current_os		Reference Document Current Outstanding
ref_doc_supp_ou	int	Reference Document Supplier Outstanding
guid	sql_variant	Guid
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name sdin_ap_postings_dtl

Table Comment Table contains the info &nbspabout the accountposing for supplier against each Transactions
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	No	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
posting_line_no	int	Posting Line Number
timestamp		Time Stamp
line_no		Line Number
company_code	sql_variant	Company Code
posting_status		Posting Status
posting_date	datetime	Posting Date
fb_id	sql_variant	Finance Book Id
tran_date	datetime	Transaction Date
account_type	sql_variant	Account Type
account_code		Account Code
drcr_id		Debit Credit Id
tran_currency		Transaction Currency
tran_amount	bigint	Transaction Amount
exchange_rate		Exchange Rate
base_amount		Base Amount
par_exchange_rate		Parallel Exchange Rate
par_base_amount		Parallel Base Amount
cost_center	sql_variant	Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
guid		Guid
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
entry_date		Entry Date
auth_date		Authorized Date
item_code	sql_variant	Item Code
item_variant		Item Variant
quantity	bigint	Quantity
reftran_fbid	sql_variant	Reference Transaction Finance Book Id
reftran_no		Reference Transaction Number
reftran_ou	int	Reference Transaction Organization Unit
ref_tran_type	sql_variant	Reference Transaction Type
supp_code		Supplier Code
uom		Unit Of Measurement
org_vat_base_amt	bigint	Organization Value Added Tax Base Amount
vat_line_no	int	Value Added Tax Line Number
remarks	varchar(255)	Line level remarks in the multiline


Table Name sdin_apportioned_tcd_dtl

Table Comment Table contains the TCD apportioning for each TCD documents
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number
item_tcd_code	sql_variant	Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
tcd_version	int	Tax Charge Discount Version
timestamp		Time Stamp	No
item_type	sql_variant	Item Type
tcd_rate	bigint	Tax Charge Discount Rate
taxable_amt		Taxable Amount
tcd_amount		Tax Charge Discount Amount
tcd_currency	sql_variant	Tax Charge Discount Currency
base_amount	bigint	Base Amount
par_base_amount		Parallel Base Amount
cost_center	sql_variant	Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
remarks		Remarks
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number
item_tcd_code	sql_variant	Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
tcd_version	int	Tax Charge Discount Version

Table Name sdin_asset_dtl
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
tran_type		Transaction Type
tran_date	datetime	Transaction Date
tran_no	sql_variant	Transaction Number
tran_ou	int	Transaction Organization Unit
supp_code	sql_variant	Supplier Code
supp_name		Supplier Name
fb_id		Finance Book Id
line_no	int	Line Number
item_tcd_code	sql_variant	Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
proposal_no		Proposal Number
item_amount	bigint	Item Amount
account_code	sql_variant	Account Code
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name sdin_cim_intxn_ou_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
subouinstid	int	Suborganization Unit Instance Id
subouinstname	sql_variant	Suborganization Unit Instance Name
subcompname		Subcompany Name
pubouinstid	int	Published Organization Unit instance id
pubouinstname	sql_variant	Published Organization Unit instance Name
pubcompname		Published Company Name
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name sdin_compute_tot_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
quantity	bigint	Quantity
rate		Rate
rateper		Rate Per
amount		Amount
line_no	int	Line Number
expense	sql_variant	Expense
usageid		Usage Id
uom		Unit Of Measurement
remarks		Remarks
costcenter		Cost Center
analysiscode		Analysis Code
subanalysiscode		Subanalysis Code
itemcode		Item Code
variant		Variant
receipt_loc	int	Receipt Location
receiptno	sql_variant	Receipt Number
asset_prop_no		Asset Proposal Number
itemdesc		Item Description
item_type		Item Type
tcd_level		Tax Charge Discount Level
tcdonlineno	int	Tax Charge Discount On Line Number
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
taxkey	varchar(18)	Tax key
taxkeydesc	sql_variant	Taxkey description
expense_class	sql_variant	Expense Classification
destn_fbid	sql_variant	Destination FB
destn_usage	sql_variant	Destination usage id
interfjvno	sql_variant	InterFBJVNO
ref_no	sql_variant	Reference Number

Table Name sdin_expense_dtl

Table Comment Table contains the Usage id’s,Quantity and rate & uom for each expense invoices
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number
timestamp		Time Stamp	No
base_value	bigint	Base Value
expense	sql_variant	Expense
usage		Usage
uom		Unit Of Measurement
item_qty	bigint	Item Quantity
item_rate		Item Rate
rate_per		Rate Per
item_amount		Item Amount
remarks	sql_variant	Remarks
cost_center		Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
expense_class	sql_variant	Expense Classification
destn_fbid	sql_variant	Destination FB
destn_usage	sql_variant	Destination usage id
interfjvno	sql_variant	InterFBJVNO
ref_no	sql_variant	Reference Number
Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number

Table Name sdin_expense_dtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
base_value	bigint	Base Value
tran_ou	int	Transaction Organization Unit
tran_type	sql_variant	Transaction Type
tran_no		Transaction Number
line_no	int	Line Number
expense	sql_variant	Expense
usage		Usage
uom		Unit Of Measurement
item_qty	bigint	Item Quantity
item_rate		Item Rate
rate_per		Rate Per
item_amount		Item Amount
remarks	sql_variant	Remarks
cost_center		Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
guid		Guid
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
taxkey	varchar(18)	Taxkey
taxkeydesc	sql_variant	Taxkey description
expense_class	sql_variant	Expense Classification
destn_fbid	sql_variant	Destination FB
destn_usage	sql_variant	Destination usage id
interfjvno	sql_variant	InterFBJVNO
ref_no	sql_variant	Reference Number

Table Name sdin_inv_summ_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
tran_no		Transaction Number
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name sdin_invoice_fndef_dtl
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
timestamp	int	Time Stamp	No
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number

Table Name sdin_invoice_hdr

Table Comment Table contains the invoice number and the invoices status info for each documents
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
timestamp	int	Time Stamp	No
batch_id	sql_variant	Batch Id
tran_status		Transaction Status.Values AUT - Authorized DEL - Deleted FSH - Fresh HLD - Hold RVD - Reversed
tran_date	datetime	Transaction Date
anchor_date		Anchor Date
fb_id	sql_variant	Finance Book Id
auto_adjust		Auto Adjust
tran_currency		Transaction Currency
exchange_rate	bigint	Exchange Rate
pay_term	sql_variant	Pay Term
payterm_version	int	Pay Term Version
elec_pay	sql_variant	Electronic Payment
pay_method		Pay Method
pay_to_supp		Pay To Supplier
pay_mode		Pay Mode
pay_priority		Pay Priority
payment_ou	int	Payment Organization Unit
supp_code	sql_variant	Supplier Code
supp_invoice_no		Supplier Invoice Number
supp_invoice_date	datetime	Supplier Invoice Date
supp_invoice_amount	bigint	Supplier Invoice Amount
supp_ou	int	Supplier Organization Unit
comments	sql_variant	Comments
address1		Address 1
address2		Address 2
address3		Address 3
city		City
state		State
country		Country
zip		Zip
phone		Phone
telex		Telex
fax		Fax
pager		Pager
mobile		Mobile
mailstop		Mail Stop
email		Email
url		Universal Resource Locator
contact		Contact
tran_amount	bigint	Transaction Amount
par_exchange_rate		Parallel Exchange Rate
item_amount		Item Amount
tax_amount		Tax Amount
disc_amount		Discount Amount
base_amount		Base Amount
par_base_amount		Parallel Base Amount
rev_doc_no	sql_variant	Reversal Document Number
rev_doc_ou	int	Reversal Document Organization Unit
rev_date	datetime	Reversal Date
ref_doc_no	sql_variant	Reference Document Number
ref_doc_ou	int	Reference Document Organization Unit
rev_reason_code	sql_variant	Reversal Reason Code
rev_remarks		Reversal Remarks
hld_date	datetime	Hold Date
hld_reason_code	sql_variant	Hold Reason Code
hld_remarks		Hold Remarks
auth_date	datetime	Authorized Date
posting_date		Posting Date
posting_status	sql_variant	Posting Status
disc_comp_basis		Discount Computation Basis
discount_proportional		Discount Proportional
comp_bp_code		Company Bank / PTT Code
bank_code		Bank Code
lsv_id		LSV Id
comp_acct_in		Company Account Information
comp_bp_ref		Company Bank / PTT Reference
comp_bp_acc_no		Company Bank / PTT Account Code
esr_id		ESR Id
partid_digits	int	Part Id Digits
refno_digits		Reference Number Digits
supp_acct_in	sql_variant	Supplier Account Information
supp_bp_ref		Supplier Bank / PTT Reference
supp_bp_acc_no		Supplier Bank / PTT Account Number
vat_applicable		Value Added Tax Applicable
vat_exchange_rate	bigint	Value Added Tax Exchange Rate
vat_charge		Value Added Tax Charge
non_vat_charge		Other Than Value Added Tax Charge
doc_level_disc		Document Level Discount
vat_incl	sql_variant	Value Added Tax Include
retain_init_distbn		Retain Initial Distribution
cap_non_ded_charge		Other Than Capitalization Deduction Charge
average_vat_rate	bigint	Average Value Added Tax Rate
vat_excl_amount		Value Added Tax Exclude Amount
vat_amount		Value Added Tax Amount
vat_incl_amount		Value Added Tax Include Amount
pre_round_off_amount		Pre-round Off Amount
rounded_off_amount		Rounded Off Amount
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
esrflag	sql_variant	ESR Flag
expense_category	sql_variant	Expense Category
sdin_wf_doc_key	sql_variant
sdin_wf_new_state	sql_variant
hldinv_flag	fin_designparamcode	Holdpay combo value

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number

Table Name sdin_invoice_hdr_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
tran_ou		Transaction Organization Unit
tran_type	sql_variant	Transaction Type
tran_no		Transaction Number
tran_status		Transaction Status.Values AUT - Authorized DEL - Deleted FSH - Fresh HLD - Hold RVD - Reversed
tran_date	datetime	Transaction Date
anchor_date		Anchor Date
fb_id	sql_variant	Finance Book Id
auto_adjust		Auto Adjust
tran_currency		Transaction Currency
exchange_rate	bigint	Exchange Rate
pay_term	sql_variant	Pay Term
elec_pay		Electronic Payment
pay_method		Pay Method
pay_to_supp		Pay To Supplier
pay_to_supp_name		Pay To Supplier Name
pay_mode		Pay Mode
pay_priority		Pay Priority
payment_ou	int	Payment Organization Unit
supp_code	sql_variant	Supplier Code
supp_name		Supplier Name
supp_invoice_no		Supplier Invoice Number
supp_invoice_date	datetime	Supplier Invoice Date
supp_invoice_amount	bigint	Supplier Invoice Amount
supp_ou	int	Supplier Organization Unit
comments	sql_variant	Comments
address1		Address 1
address2		Address 2
address3		Address 3
city		City
state		State
country		Country
zip		Zip
phone		Phone
telex		Telex
fax		Fax
pager		Pager
mobile		Mobile
mailstop		Mail Stop
email		Email
url		Universal Resource Locator
contact		Contact
tran_amount	bigint	Transaction Amount
par_exchange_rate		Parallel Exchange Rate
item_amount		Item Amount
tax_amount		Tax Amount
disc_amount		Discount Amount
base_amount		Base Amount
par_base_amount		Parallel Base Amount
rev_doc_no	sql_variant	Reversal Document Number
rev_doc_ou	int	Reversal Document Organization Unit
rev_date	datetime	Reversal Date
ref_doc_no	sql_variant	Reference Document Number
ref_doc_ou	int	Reference Document Organization Unit
rev_reason_code	sql_variant	Reversal Reason Code
rev_remarks		Reversal Remarks
hld_date	datetime	Hold Date
hld_reason_code	sql_variant	Hold Reason Code
hld_remarks		Hold Remarks
auth_date	datetime	Authorized Date
posting_date		Posting Date
posting_status	sql_variant	Posting Status
disc_comp_basis		Discount Component Basis
comp_bp_code		Company Bank / PTT Code
bank_code		Bank Code
lsv_id		LSV Id
comp_acct_in		Company Account Information
comp_bp_ref		Company Bank / PTT Reference
comp_bp_acc_no		Company Bank / PTT Account Number
esr_id		ESR Id
partid_digits	int	Part Id Digits
refno_digits		Reference Number Digits
supp_acct_in	sql_variant	Supplier Account Information
supp_bp_ref		Supplier Bank / PTT Reference
supp_bp_acc_no		Supplier Bank / PTT Account Number
vat_exchange_rate	bigint	Value Added Tax Exchange Rate
vat_charge		Value Added Tax Discount Charge
non_vat_charge		Other than Value Added Tax Discount Charge
doc_level_disc		Document Level Discount
vat_incl	sql_variant	Value Added Tax Included
retain_init_distbn		Retain Initial Distribution
cap_non_ded_charge		Other than Capitalization Deductible Charge
vat_excl_amount	bigint	Value Added Tax Exclude Amount
vat_amount		Value Added Tax Amount
vat_incl_amount		Value Added Tax Include Amount
avg_vat_rate		Average Value Added Tax Rate
disc_prop_flag	sql_variant	Discount Proposal Flag
guid		Guid
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name sdin_item_dtl
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number
timestamp		Time Stamp	No
base_value	bigint	Base Value
visible_line_no	int	Visible Line Number
gr_ou		Goods Receipt Organization Unit
gr_no	sql_variant	Goods Receipt Number
item_tcd_code		Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
uom		Unit Of Measurement
item_qty	bigint	Item Quantity
item_rate		Item Rate
rate_per		Rate Per
item_amount		Item Amount
tax_amount		Tax Amount
disc_amount		Discount Amount
line_amount		Line Amount
base_amount		Base Amount
par_base_amount		Parallel Base Amount
usage	sql_variant	Usage
proposal_no		Proposal Number
remarks		Remarks
cost_center		Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
rcpt_qty	bigint	Receipt Quantity
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number

Table Name sdin_item_dtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
tran_ou		Transaction Organization Unit
tran_type	sql_variant	Transaction Type
tran_no		Transaction Number
line_no	int	Line Number
visible_line_no		Visible Line Number
status	sql_variant	Status
gr_ou	int	Goods Receipt Organization Unit
gr_no	sql_variant	Goods Receipt Number
item_tcd_code		Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
item_tcd_desc		Item Tax Charge Discount Description
item_type		Item Type
tcd_level		Tax Charge Discount Level
tcd_on_lineno	int	Tax Charge Discount On Line Number
uom	sql_variant	Unit Of Measurement
item_qty	bigint	Item Quantity
item_rate		Item Rate
rate_per		Rate Per
item_amount		Item Amount
tax_amount		Tax Amount
disc_amount		Discount Amount
line_amount		Line Amount
base_amount		Base Amount
par_base_amount		Parallel Base Amount
usage	sql_variant	Usage
proposal_no		Proposal Number
remarks		Remarks
cost_center		Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
guid		Guid
flag	varchar(2)	Flag
base_value	bigint	Base Value
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
taxkey	varchar(18)	Tax key
taxkeydesc	sql_variant	Taxkey description
expense_class	sql_variant	Expense Classification
destn_fbid	sql_variant	Destination FB
destn_usage	sql_variant	Destination usage id
interfjvno	sql_variant	InterFBJVNO
ref_no	sql_variant	Reference Number

Table Name sdin_notes_dtl

Table Comment Table that containst the notes and comments details for the Document number
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
note_category		Note Category
category_value		Category Value
line_no	int	Line Number
timestamp		Time Stamp	No
note_text	sql_variant	Note Text
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
note_category		Note Category
category_value		Category Value
line_no	int	Line Number

Table Name sdin_payment_dtl

Table Comment Table contains the payterm and the due_amount for each document number
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
term_no		Term Number
timestamp	int	Time Stamp	No
posting_status	sql_variant	Posting Status
posting_date	datetime	Posting Date
due_date		Due Date
due_amount_type	sql_variant	Due Amount Type
due_percent	bigint	Due Percentage
due_amount		Due Amount
disc_comp_amount		Discount Computed Amount
disc_amount_type	sql_variant	Discount Amount Type
disc_date	datetime	Discount Date
disc_percent	bigint	Discount Percentage
disc_amount		Discount Amount
penalty_percent		Penalty Percentage
esr_ref_no	sql_variant	ESR Reference Number
esr_coding_line		ESR Coding Line
esr_amount	bigint	ESR Amount
base_due_amount		Base Due Amount
base_disc_amount		Base Discount Amount
base_esr_amount		Base ESR Amount
guid	sql_variant	Guid
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
term_no		Term Number

Table Name sdin_payment_dtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
tran_ou		Transaction Organization Unit
tran_type	sql_variant	Transaction Type
tran_no		Transaction Number
line_no	int	Line Number
term_no	sql_variant	Term Number
posting_status		Posting Status
posting_date	datetime	Posting Date
due_date		Due Date
due_amount_type	sql_variant	Due Amount Type
due_percent	bigint	Due Percentage
due_amount		Due Amount
disc_comp_amount		Discount Computed Amount
disc_amount_type	sql_variant	Discount Amount Type
disc_date	datetime	Discount Date
disc_percent	bigint	Discount Percentage
disc_amount		Discount Amount
penalty_percent		Penalty Percentage
esr_ref_no	sql_variant	ESR Reference Number
esr_coding_line		ESR Coding Line
esr_amount	bigint	ESR Amount
base_due_amount		Base Due Amount
base_disc_amount		Base Discount Amount
base_esr_amount		Base ESR Amount
guid	sql_variant	Guid
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name sdin_pt_intxn_paydtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
ouid	int	Organization Unit Id
pay_term	sql_variant	Pay Term
pay_term_no		Pay Term Number
due_days	int	Due Days
due_percentage	bigint	Due Percentage
discount_days	int	Discount Days
discount_percentage	bigint	Discount Percentage
penalty_percentage		Penalty Percentage
disc_proportional	sql_variant	Discount Proportional
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name sdin_tcd_dtl

Table Comment Table that contains the TCD info for each documents that has TCD attachments
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number
item_tcd_code	sql_variant	Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
tcd_version	int	Tax Charge Discount Version
timestamp		Time Stamp	No
item_type	sql_variant	Item Type
tcd_level		Tax Charge Discount Level
tcd_rate	bigint	Tax Charge Discount Rate
taxable_amount		Taxable Amount
tcd_amount		Tax Charge Discount Amount
tcd_currency	sql_variant	Tax Charge Discount Currency
usage		Usage
base_amount	bigint	Base Amount
par_base_amount		Parallel Base Amount
cost_center	sql_variant	Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
remarks		Remarks
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number
item_tcd_code	sql_variant	Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
tcd_version	int	Tax Charge Discount Version

Table Name sdin_tcd_dtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
tran_ou		Transaction Organization Unit
tran_type	sql_variant	Transaction Type
tran_no		Transaction Number
line_no	int	Line Number
item_tcd_code	sql_variant	Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
item_tcd_desc		Item Tax Charge Discount Description
item_type		Item Type
tcd_level		Tax Charge Discount Level
tcd_rate	bigint	Tax Charge Discount Rate
taxable_amount		Taxable Amount
tcd_amount		Tax Charge Discount Amount
tcd_currency	sql_variant	Tax Charge Discount Currency
usage		Usage
base_amount	bigint	Base Amount
par_base_amount		Parallel Base Amount
cost_center	sql_variant	Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
remarks		Remarks
guid		Guid
modeflag		Mode Flag
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
tax_type	sql_variant	Tax type


Table Name sdin_tcdcal_calcprocess_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
tcdcal_guid	sql_variant	Guid
tcdcal_tcdcode		Tax Charge Discount Code
tcdcal_tcddocumentlevel		Tax Charge Discount Document Level
tcdcal_tcdvariant		Tax Charge Discount Variant
tcdcal_line_no	int	Line Number
tcdcal_tcdvalue	bigint	Tax Charge Discount Value
tcdcal_bv_lineitem		Base Value Line Item
tcdcal_qty_lineitem		Quantity Line Item
tcdcal_tcd_amount		Tax Charge Discount Amount
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name sdin_updproposal_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
fb_id		Finance Book Id
asset_class		Asset Class
SrcOu	int	Source Organization Unit
SrcComponent	sql_variant	Source Component
Document_OU	int	Document Organization Unit
Document_Type	sql_variant	Document Type
Document_No		Document Number
Document_Task		Document Task
Document_Flag		Document Flag
Document_Date	datetime	Document Date
Document_Curr	sql_variant	Document Currency
Document_ProposalNo		Document Proposal Number
Document_Stage		Document Stage
Document_Status		Document Status
Document_LineNo	int	Document Line Number
Document_Amount	bigint	Document Amount
RefDoc_Ou	int	Reference Document Organization Unit
RefDoc_Type	sql_variant	Reference Document Type
RefDoc_Number		Reference Document Number
RefDoc_CompID		Reference Document Component Id
RefDoc_Task		Reference Document Task
RefDoc_Flag		Reference Document Flag
RefDoc_ProposalNo		Reference Document Proposal Number
RefDoc_Stage		Reference Document Stage
RefDoc_Curr		Reference Document Currency
Refoct_LineNo	int	Reference Document Line Number
RefDoc_Amount	bigint	Reference Document Amount
RefDoc_Status	sql_variant	Reference Document Status


Table Name sdin_vat_dtl

Table Comment Table contains the VAT details for each document number
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
vat_line_no	int	Value Added Tax Line Number
timestamp		Time Stamp	No
doc_line_no		Document Line Number
item_type	sql_variant	Item Type
account_code		Account Code
item_tcd_code		Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
vat_category		Value Added Tax Category
vat_class		Value Added Tax Class
tcd_var		Tax Charge Discount Variant
vat_rate	bigint	Value Added Tax Rate
inp_vat_deduct_per		Input Value Added Tax Deduct Per
item_amount		Item Amount
vat_item_charge		Value Added Tax Item Charge
non_vat_item_charge		Other Than Value Added Tax Item Charge
vat_dist_charge		Value Added Tax Distribution Charge
item_level_disc_amount		Item Level Discount Amount
dist_disc_amount		Distribution Discount Amount
vat_tran_amount		Value Added Tax Transaction Amount
corr_vat_tran_amount		Corrected Value Added Tax Transaction Amount
vat_base_amount		Value Added Tax Base Amount
corr_vat_base_amount		Corrected Value Added Tax Base Amount
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
vat_line_no	int	Value Added Tax Line Number

Table Name sdin_vat_dtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
tran_ou		Transaction Organization Unit
tran_type	sql_variant	Transaction Type
tran_no		Transaction Number
vat_line_no	int	Value Added Tax Line Number
doc_line_no		Document Line Number
item_type	sql_variant	Item Type
account_code		Account Code
item_tcd_code		Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
vat_category		Value Added Tax Category
vat_class		Value Added Tax Class
tcd_var		Tax Charge Discount Variant
vat_rate	bigint	Value Added Tax Rate
inp_vat_deduct_per		Input Value Added Tax Per
item_amount		Item Amount
vat_item_charge		Value Added Tax Item Charge
non_vat_item_charge		Other Than Value Added Tax Item Charge
vat_dist_charge		Value Added Tax Distribution Charge
item_level_disc_amount		Item Level Discount Amount
dist_disc_amount		Distribution Discount Amount
vat_tran_amount		Value Added Tax Transaction Amount
corr_vat_tran_amount		Corrected Value Added Tax Transaction Amount
vat_base_amount		Value Added Tax Base Amount
corr_vat_base_amount		Corrected Value Added Tax Base Amount
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
guid	sql_variant	Guid

sdin_automatch_wf_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	NO
invoiceno	sql_variant	InvoiceNo
tran_date	sql_variant	Tran Date
current_state	sql_variant	Current State