Supplier Order Based Invoice

Supplier Order Based Invoice

Table Name sin_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 Organization Unit
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 sin_adjustments_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_ou	int	Transaction Organization Unit
tran_type	sql_variant	Transaction Type
tran_no		Transaction Number
line_no	int	Line Number
ref_doc_type	sql_variant	Reference Document Type
ref_doc_no		Reference Document Number
ref_doc_date	datetime	Reference Document Date
ref_doc_amount	bigint	Reference Document Amount
ref_doc_current_os		Reference Document Current Outstanding
ref_doc_fb_id	sql_variant	Reference Document Finance Book Id
ref_doc_supp_ou	int	Reference Document Supplier Organization Unit


Table Name sin_ap_postings_dtl

Table Comment Table that maintains the posting level info and Amounts for each Transaction numbers
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
posting_line_no	int	Posting Line Number
timestamp		Time Stamp	No
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
entry_date	datetime	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 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
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
vat_line_no	int	Value Added Tax Line 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
posting_line_no	int	Posting Line Number

Table Name sin_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 SIN_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	No
invoiceno		Invoice Number
tran_date	datetime	Transaction Date
current_state	sql_variant	Current State


Table Name sin_delivery_charge_dtl

Table Comment Table that contains the info about the delivary charges 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
tran_line_no	int	Transaction Line Number
timestamp		Time Stamp	No
ref_doc_no	sql_variant	Reference Document Number
ref_doc_type		Reference Document Type
ref_doc_ou	int	Reference Document Organization Unit
po_no	sql_variant	Purchase Order Number
tcd_code		Tax Charge Discount Code
tcd_variant		Tax Charge Discount Variant
tran_amount	bigint	Transaction Amount
proposed_amount		Proposed Amount
remarks	sql_variant	Remarks
tcd_type		Tax Charge Discount Type
ref_doc_line_no	int	Reference Document Line Number
tcdversionno		Tax Charge Discount Version Number
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
costcenter	sql_variant	Cost Center
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
tran_line_no	int	Transaction Line Number

Table Name sin_emod_intxn_curr_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
companycode		Company Code
currencycode		Currency Code


Table Name sin_emod_intxn_fb_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
company_code		Company Code
finance_bookid		Finance Book Id
fb_type		Finance Book Type
fb_desc		Finance Book Description
fb_status		Finance Book Status. Values 1-active,0-inactive


Table Name sin_gr_dtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
gr_no	sql_variant	Good Receipt Number	No	No
gr_ou	int	Good Receipt Organization Unit
gr_line_no		Good Receipt Line Number
tran_type	sql_variant	Transaction Type
po_no		Purchase Order Number
po_ou	int	Purchase Order Organization Unit
po_line_no		Purchase Order Line Number
po_amendment_no	sql_variant	Purchase Order Amendment Number
itemtcd_code		Item Tax Charge Discount Code
itemtcd_variant		Item Tax Charge Discount Variant
received_qty	bigint	Received Quantity
gr_doc_status	sql_variant	Goods Receipt Document Status. Values C-Cancelled ,I-Inspected,M-Moved, PI-Partial Inspect, PM-Partially Moved, R-Received, RA-Receipt Acknowledged,RE-Returned, RF-Receipt Frozen, RJ-Rejected
accepted_qty	bigint	Accepted Quantity
gr_line_status	sql_variant	Goods Receipt Line Status. Values C-Cancelled, I-Inspected,M-Moved, PI-Partial Inspect,PM-Partially Moved,R-Received, RA-Receipt Acknowledged,RE-Returned, RF-Receipt Frozen, RJ-Rejected
tcd_on_line_no	int	Tax Charge Discount On Line Number
taxable_amt	bigint	Taxable Amount
tcd_rate		Tax Charge Discount Rate
tcd_amt		Tax Charge Discount Amount
tcd_level	sql_variant	Tax Charge Discount Level
tcd_type		Tax Charge Discount Type
ref_doc_date	datetime	Reference Document Date
received_amt	bigint	Received Amount
accepted_amt		Accepted Amount
item_type	sql_variant	Item Type
gr_date	datetime	Goods Receipt Date
gr_exchange_rate	bigint	Goods Receipt Exchange Rate
timestamp	int	Time Stamp
gr_fbid	sql_variant	Goods Receipt Finance Book Id
guid		Guid
tcd_currency		Tax Charge Discount Currency
tcdanalysiscode		Tax Charge Discount Analysis Code
tcdsubanalysiscode		Tax Charge Discount Subanalysis Code
tcdclass		Tax Charge Discount Class
tcdccusage		Tax Charge Discount Cost Center Usage
inv_amount	bigint	Invoice Amount
item_tcd	sql_variant	Item Tax Charge Discount
tcdversion	int	Tax Charge Discount Version
supp_code	sql_variant	Supplier Code
ref_doc_type		Reference Document Type


Table Name sin_gr_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
gr_no		Good Receipt Number


Table Name sin_inv_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
po_no		Purchase Order Number
po_ou	int	Purchase Order Organization Unit
po_category	sql_variant	Purchase Order Category
tran_type		Transaction Type
po_line_no	int	Purchase Order Line Number
po_amendment_no		Purchase Order Amendment Number
match_type	sql_variant	Match Type
po_quantity	bigint	Purchase Order Quantity
gr_no	sql_variant	Goods Receipt Number
gr_ou	int	Goods Receipt Organization Unit
gr_line_no		Goods Receipt Line Number. Values C-Cancelled, I-Inspected, M-Moved, PI-Partial Inspect, PM-Partially Moved, R-Received, RA-Receipt Acknowledged, RE-Returned, RF-Receipt Frozen, RJ-Rejected
itemtcd_code	sql_variant	Item Tax Charge Discount Code
itemtcd_variant		Item Tax Charge Discount Variant
tcd_amt	bigint	Tax Charge Discount Amount
tcd_received_amt		Tax Charge Discount Receive Amount
tcd_accepted_amt		Tax Charge Discount Accepted Amount
tcd_type	sql_variant	Tax Charge Discount Type
taxable_amt	bigint	Taxable Amount
tcd_rate		Tax Charge Discount Rate
tcd_on_line_no	int	Tax Charge Discount On Line Number
received_qty	bigint	Received Quantity
gr_doc_status	sql_variant	Goods Document Status. Values C-Cancelled,I-Inspected, M-Moved, PI-Partial Inspect,PM-Partially Moved,R-Received, RA-Receipt Acknowledged, RE-Returned, RF-Receipt Frozen, RJ-Rejected
accepted_qty	bigint	Accepted Quantity
gr_line_status	sql_variant	Goods Line Status. Values C-Cancelled, I-Inspected,M-Moved, PI-Partial Inspect,PM-Partially Moved,R-Received, RA-Receipt Acknowledged,RE-Returned, RF-Receipt Frozen, RJ-Rejected
proposed_qty	bigint	Proposed Quantity
proposed_amt		Proposed Amount
itm_desc	sql_variant	Item Description
cost	bigint	Cost
cost_per		Cost Percentage
proposed_rate		Proposed Rate
item_type	sql_variant	Item Type
line_no	int	Line Number
delete_flag	sql_variant	Delete Flag
check_flag		Check Flag
invoice_no		Invoice Number
tran_qty	bigint	Transaction Quantity
reconciled_qty		Reconciled Quantity
invoice_qty		Invoice Quantity
balance_qty		Balance Quantity
tran_rate		Transaction Date
tran_amount		Transaction Amount
tran_currency	sql_variant	Transaction Currency
tran_exchange_rate	bigint	Transaction Exchange Rate
supp_code	sql_variant	Supplier Code
supp_name		Supplier Name
fb_id		Finance Book Id
po_status		Purchase Order Status. Values D-Draft, F-Fresh, O-Open, A-Amended, P-Under Amendment, CA-Cancelled,H-Held,S-Short Closed, Cl-Closed,NT-NTclosed, U-Under Authorization,R-Revised,RET-Return,O-Open, CRDUE-Core Due,RCDUE-Receipt Due,CL-Closed
tran_date	datetime	Transaction Date
hdn_line_no	int	Hidden Line Number
ref_doc_date	datetime	Reference Document Date
ref_doc_type	sql_variant	Reference Document Type
timestamp	int	Time Stamp
remarks	sql_variant	Remarks
pors_flag		Purchase Order / Release / Slip Flag
pay_to_supp		Pay To Supplier
pay_mode		Pay Mode
pay_term		Pay Term
tcd_applicable_amt	bigint	Tax Charge Discount Applicable Amount
tcd_level	sql_variant	Tax Charge Discount Level
ouinstname		Organization Unit Instance
po_currency		Purchase Order Currency
costcenter		Cost Center
analysiscode		Analysis Code
subanalysis_code		Subanalysis Code
invoice_category		Invoice Category
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
ref_doc_no		Reference Document Number
ref_doc_ou	int	Reference Document Organization Unit
po_exch_rate	bigint	Purchase Order Exchange Rate
serial_no	int	Serial Number
po_auth_date	datetime	Purchase Order Authorized Date
gr_ouinstname	sql_variant	Goods Receipt Organization Unit Instance Name
modeflag		Mode Flag
base_amount	bigint	Base Amount
net_line_amount		Net Line Amount
line_tax_amount		Line Tax Amount
line_disc_amount		Line Discount Amount
visible_line_no	int	Visible Line Number
reconcile_no	sql_variant	Reconcile Number
puom		Purchase Unit Of Measurement
invoice_rate	bigint	Invoice Rate
tcdversionno	int	Tax Charge Discount Version Number
tolerancetype	sql_variant	Tolerance Type
tolerancepositive	bigint	Tolerance Positive
tolerancenegative		Tolerance Negative
par_base_amount		Parallel Base Amount
matched_qty		Matched Quantity
match_status	sql_variant	Matched Status. Values Mat- Matched, Amf- Auto match failed
matched_amount	bigint	Matched Amount
original_proposed_qty		Original Proposed Quantity
original_proposed_amt		Original Proposed Amount
positivematch_status	sql_variant	Positive Match Status. Values Mat- matched, Amf-Auto match failed
negativematch_status		Negative Match Status. Values Mat- matched, Amf-Auto match failed
proposed_value	bigint	Proposed Value


Table Name sin_invoice_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
po_no		Purchase Order Number
po_ou	int	Purchase Order Organization Unit
po_category	sql_variant	Purchase Order Category
tran_type		Transaction Type
po_line_no	int	Purchase Order Line Number
po_amendment_no		Purchase Order Amendment Number
match_type	sql_variant	Match Type
po_quantity	bigint	Purchase Order Quantity
gr_no	sql_variant	Goods Receipt Number
gr_ou	int	Goods Receipt Organization Unit
gr_line_no		Goods Line Number.
itemtcd_code	sql_variant	Item Tax Charge Discount Code
itemtcd_variant		Item Tax Charge Discount Variant
tcd_amt	bigint	Tax Charge Discount Amount
tcd_received_amt		Tax Charge Discount Received Amount
tcd_accepted_amt		Tax Charge Discount Accepted Amount
tcd_type	sql_variant	Tax Charge Discount Type
taxable_amt	bigint	Taxable Amount
tcd_rate		Tax Charge Discount Rate
tcd_on_line_no	int	Tax Charge Discount On Line Number
received_qty	bigint	Received Quantity
gr_doc_status	sql_variant	Goods Receipt Document Status. Values C-Cancelled,I-Inspected,M-Moved,PI-Partial Inspect,PM-Partially Moved,R-Received, RA-Receipt Acknowledged,RE-Returned, RF-Receipt Frozen,RJ-Rejected
accepted_qty	bigint	Accepted Quantity
gr_line_status	sql_variant	Goods Receipt Line Status. Values C-Cancelled,I-Inspected,M-Moved,PI-Partial Inspect,PM-Partially Moved,R-Received, RA-Receipt Acknowledged,RE-Returned, RF-Receipt Frozen,RJ-Rejected
proposed_qty	bigint	Proposed Quantity
proposed_amt		Proposed Amount
itm_desc	sql_variant	Item Description
cost	bigint	Cost
cost_per		Cost Per
proposed_rate		Proposed Rate
item_type	sql_variant	Item Type
line_no	int	Line Number
delete_flag	sql_variant	Delete Flag
check_flag		Check Flag
invoice_no		Invoice Number
tran_qty	bigint	Transaction Quantity
reconciled_qty		Reconciled Quantity
invoice_qty		Invoice Quantity
balance_qty		Balance Quantity
tran_rate		Tansaction Rate
tran_amount		Tansaction Amount
tran_currency	sql_variant	Tansaction Currency
tran_exchange_rate	bigint	Tansaction Exchange Rate
supp_code	sql_variant	Supplier Code
supp_name		Supplier Name
fb_id		Finance Book Id
po_status		Purchase Order Status. Values D-Draft,F-Fresh,O-Open,A-Amended,P-Under Amendment,CA-Cancelled,H-Held,S-Short Closed, Cl-Closed,NT-NTclosed,U-Under Authorization,R-Revised,RET-Return,O-Open,CRDUE-Core Due,RCDUE-Receipt Due,CL-Closed
tran_date	datetime	Transaction Date
hdn_line_no	int	Hidden Line Number
ref_doc_date	datetime	Reference Document Date
ref_doc_type	sql_variant	Reference Document Type
timestamp	int	Time Stamp
remarks	sql_variant	Remarks
pors_flag		Purchase Order / Release/ Slip Flag
pay_to_supp		Pay To Supplier
pay_mode		Pay Mode
pay_term		Pay Term
tcd_applicable_amt	bigint	Tax Charge Discount Applicable Amount
tcd_level	sql_variant	Tax Charge Discount Level
ouinstname		Organization Unit Instance Name
po_currency		Purchase Order Currency
costcenter		Cost Center
analysiscode		Analysis Code
subanalysis_code		Subanalysis Code
invoice_category		Invoice Category
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
ref_doc_no		Reference Document Number
ref_doc_ou	int	Reference Document Organization Unit
po_exch_rate	bigint	Purchase Order Exchange Rate
serial_no	int	Serial Number
po_auth_date	datetime	Purchase Order Authorized Date
gr_ouinstname	sql_variant	Goods Receipt Organization Unit Instance Name
modeflag		Mode Flag
base_amount	bigint	Base Amount
net_line_amount		Net Line Amount
line_tax_amount		Line Tax Amount
line_disc_amount		Line Discount Amount
visible_line_no	int	Line Visible Number
reconcile_no	sql_variant	Reconcile Number
puom		Purchase Unit Of Measurement
invoice_rate	bigint	Invoice Rate
tcdversionno	int	Tax Charge Discount Version Number
tolerancetype	sql_variant	Tolerance Type
tolerancepositive	bigint	Tolerance Positive
tolerancenegative		Tolerance Negative
par_base_amount		Parallel Base Amount
matched_qty		Matched Quantity
match_status	sql_variant	Matched Status. Values Mat- Matched, Amf- Auto match failed
matched_amount	bigint	Matched Amount
original_proposed_qty		Original Proposed Quantity
original_proposed_amt		Original Proposed Amount
positivematch_status	sql_variant	Positive Match Status.Values Mat- matched, Amf-Auto match failed
negativematch_status		Negative Match Status. Values Mat- matched, Amf-Auto match failed
proposed_value	bigint	Proposed Value
po_expense_type	sql_variant	Purchase Order Expense Type
unmatched_amount	bigint	Unmatched Amount
unmatched_perc		Unmatched Percentage
fwd_cover_flag	sql_variant	Forward Cover Flag
tax_key	varchar(15)	Trn-BSg-Rcn-SIN-R62-1.0 Tax Key
taxkey_desc	sql_variant	Trn-BSg-Rcn-SIN-R62-1.0 Taxkey description
row_no	int	Trn-BSg-Rcn-SIN-R62-1.0 Row No
min_allowed_rate	bigint	min_allowed_rate
max_allowed_rate	bigint	max_allowed_rate
min_allowed_amt	bigint	min_allowed_amt
max_allowed_amt	bigint	max_allowed_amt
utilized_invtol_per	bigint	utilized_invtol_per
PartType	sql_variant	PartType
FacObjectNo	sql_variant	FacObjectNo
FacObjectType	sql_variant	FacObjectType
SerialNo	sql_variant	SerialNo
LotNo	sql_variant	LotNo
PartStatus	sql_variant	PartStatus
SalvageAmount	bigint	SalvageAmount
ReceiptStatus	sql_variant	ReceiptStatus
ro_quotation	sql_variant	ro_quotation
Ref_doc_pay_mode	sql_variant	Ref_doc_pay_mode
Service_charge	bigint	Service_charge
Ber_Flag	sql_variant	Ber_Flag
org_salvage_amount	sql_variant	org_salvage_amount
pregrinv_exists	fin_desc5	pregrinv_exists	No	No


Table Name sin_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 sin_invoice_hdr

Table Comment Table that contains the info about the document number and document status and the supplier information 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	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
timestamp	int	Time Stamp	No
tran_status	sql_variant	Transaction Status. Values ADJ-Adjusted,AMF-AutoMatch Failed,AUT-Authorized,DEL-Deleted,FSH-Fresh,MAT-Matched,RVD-Reversed
invoce_cat		Invoice Category
num_type		Numbering Type
tran_date	datetime	Transaction Date
anchor_date		Anchor Date
fb_id	sql_variant	Finance Book Id
auto_adjust		Auto Adjust
auto_match		Auto Match
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_priority		Pay Priority
payment_ou	int	Payment Organization Unit
pay_mode	sql_variant	Pay Mode
supp_code		Supplier Code
pay_to_supp		Pay To Supplier
supp_invoice_no		Supplier Invoice Number
supp_invoice_date	datetime	Supplier Invoice Date
supp_invoice_amount	bigint	Supplier Invoice Amount
comments	sql_variant	Comments
proposed_amount	bigint	Proposed Amount
tran_amount		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
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 Number
esr_id		ESR Id
partid_digits	int	Part Id Digits
refno_digits		Reference Number Digits
supp_acct_in	sql_variant	Supplier Account In formation
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 Capital 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		Round Off Amount
utilized_invtol_per		Utilized Invoice Total Percentage
unmatched_per		Unmathed Percentage
forcemth_tolper_applied		Force match tolerance applied
batch_id	sql_variant	Batch Id
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
auto_match_tolper	bigint	Auto match tolerance
esr_flag	sql_variant	ESR Flag
Foward_Cover_Appl		Forward Cover Application
dc_invoice_type		Delivery Charges Type
SIN_WF_DOC_KEY		Work Flow Document Key
SIN_WF_NEW_STATE		Work Flow New State
automth_failed_on	sql_variant	automth_failed_on
pregrinv_exists	fin_desc5	pregrinv_exists	No	No
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 sin_invoice_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
tran_no		Transaction Number
tran_type		Transaction Type
tran_ou	int	Transaction Organization Unit
tran_status	sql_variant	Transaction Status. Values ADJ-Adjusted,AMF-AutoMatch Failed,AUT-Authorized,DEL-Deleted,FSH-Fresh,MAT-Matched,RVD-Reversed
status_desc		Status Description
tran_date	datetime	Transaction Date
tran_currency	sql_variant	Transaction Currency
tran_amount	bigint	Transaction Amount
supp_code	sql_variant	Supplier Code
suppliername		Supplier Name
supp_invoice_no		Supplier Invoice Number
fb_id		Finance Book Id
pay_priority		Payment Priority
priority_desc		Priority Description
timestamp	int	Time Stamp
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_amount		Value Added Tax Include Amount
vat_excl_amount		Value Added Tax Exclude Amount
vat_amount		Value Added Tax Amount
retain_init_distbn	sql_variant	Retain Initial Distribution
cap_non_ded_charge		Other Than Capital Deduction Charge
vat_incl		Value Added Tax Include


Table Name sin_item_dtl

Table Comment Table that contains the info about the Purchase orders and GR’s and billed quantity for each document numbers
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
po_amendment_no		Purchase Order Amendment Number
visible_line_no		Visible Line Number
ref_doc_type	sql_variant	Reference Document Type
ref_doc_no		Reference Document Number
ref_doc_date	datetime	Reference Document Date
pors_type	sql_variant	Purchase Order / Slip Type
po_no		Purchase Order Number
po_ou	int	Purchase Order Organization Unit
item_tcd_code	sql_variant	Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
uom		Unit Of Measurement
rate_per	bigint	Rate Per
invoice_qty		Invoice Quantity
invoice_rate		Invoice Rate
invoice_amount		Invoice Amount
proposed_qty		Proposed Quantity
proposed_rate		Proposed Rate
proposed_amount		Proposed Amount
tran_amount		Transaction Amount
remarks	sql_variant	Remarks
cost_center		Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
ref_doc_ou	int	Reference Document Organization Unit
unmatched_amount	bigint	Unmatched Amount
unmatched_perc		Unmatched Percentage
tax_amount		Tax Amount
disc_amount		Discount Amount
line_amount		Line Amount
item_amount		Item Amount
base_amount		Base Amount
original_proposed_amt		Original Propose Amount
original_proposed_qty		Original Propose Quantity
po_line_no	int	Purchase Order Line Number
ref_doc_line_no		Reference Document Line Number
par_base_amount	bigint	Parallel Base Amount
base_value		Base Value
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
item_desc	sql_variant	Item Description
po_expense_type		Purchase Order Expense Type
po_exchange_rate	int	Exchange rate for PO
min_allowed_rate	bigint	Minimum Allowed rate
max_allowed_rate	bigint	Maximum Allowed rate
min_allowed_amt	bigint	Minimum Allowed amount
max_allowed_amt	bigint	Maximum Allowed amount
positivematch_status	sql_variant	positivematch_status
negativematch_status	sql_variant	negativematch_status
PartType	sql_variant	PartType
FacObjectNo	sql_variant	FacObjectNo
FacObjectType	sql_variant	FacObjectType
SerialNo	sql_variant	SerialNo
LotNo	sql_variant	LotNo
PartStatus	sql_variant	PartStatus
SalvageAmount		SalvageAmount
ReceiptStatus	sql_variant	ReceiptStatus
ro_quotation	sql_variant	ro_quotation
Ref_doc_pay_mode	sql_variant	Ref_doc_pay_mode
Service_charge	sql_variant	Service_charge
Ber_Flag	sql_variant	Ber_Flag
org_salvage_amount	sql_variant	org_salvage_amount
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 sin_item_iteminfo_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
itemcode	sql_variant	Item Code	No	No
itemvar		Item Variant
itemdesc		Item Description
itemtype		Item Type
uom		Unit Of Measurement


Table Name sin_nc_intxn_numtypes_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
num_type		Numbering Type


Table Name sin_nc_numtypes_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
num_type		Numbering Type
last_no	int	Last Number


Table Name sin_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 sin_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
due_percent	bigint	Due Percent
due_amount		Due Amount
disc_comp_amount		Discount Company 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 sin_payment_dtl_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
term_no		Term Number
timestamp	int	Time Stamp
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 Percent
due_amount		Due Amount
disc_comp_amount		Discount Company 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
line_no	int	Line Number


Table Name sin_po_dtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
po_number	sql_variant	Purchase Order Number	No	No
po_ou	int	Purchase Order Organization Unit
tran_type	sql_variant	Transaction Type
po_line_no	int	Purchase Order Line Number
po_amendment_no	sql_variant	Purchase Order Amendment Number
match_type		Match Type
itemtcd_code		Item Tax Charge Discount Code
itemtcd_variant		Item Tax Charge Discount Variant
po_qty	bigint	Purchase Order Quantity
tcd_on_line_no	int	Tax Charge Discount On Line Number
taxable_amt	bigint	Taxable Amount
tcd_rate		Tax Charge Discount Rate
tcd_amt		Tax Charge Discount Amount
tcd_level	sql_variant	Tax Charge Discount Level
tcd_type		Tax Charge Discount Type
ref_doc_date	datetime	Reference Document Date
puom	sql_variant	Purchase Unit Of Measurement
cost	bigint	Cost
cost_per		Cost Percentage
tcd_currency	sql_variant	Tax Charge Discount
tcdbasis		Tax Charge Discount Basis
tolerancetype		Tolerance Type
tolerancepositive	bigint	Tolerance Positive
tolerancenegative		Tolerance Negative
guid	sql_variant	Guid
item_tcd		Item Tax Charge Discount
inv_amount	bigint	Invoice Amount
tcdversion	int	Tax Charge Discount Version
supplier	sql_variant	Supplier
pay_to_supplier		Pay To Supplier
paymode		Pay Mode
payterm		Pay Term


Table Name sin_po_gr_map

Table Comment Table that contains the actual billed quantity 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	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number
ref_doc_ou		Reference Document Organization Unit
ref_doc_no	sql_variant	Reference Document Organization Number
ref_doc_line_no	int	Reference Document Line Number
po_ou		Purchase Order Organization Unit
po_no	sql_variant	Purchase Order Number
po_line_no	int	Purchase Order Line Number
po_amendment_no		Purchase Order Amendment Number
item_tcd_code	sql_variant	Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
timestamp	int	Time Stamp	No
pors_type	sql_variant	Purchase Order /Slip Type
item_type		Item Type
recd_qty	bigint	Received Quantity
recd_amount		Received Amount
acc_qty		Account Quantity
acc_amount		Account Amount
billed_qty		Billed Quantity
billed_amount		Billed Amount
matching_type	sql_variant	Matching Type
tolerance_type		Tolerance Type
tolreance_perc	int	Tolerance Percentage
proposed_qty	bigint	Proposed Quantity
proposed_rate		Proposed Rate
proposed_amount		Proposed Amount
matched_qty		Matched Quantity
matched_amount		Matched Amount
match_status	sql_variant	Match Status. Values H-High,L-Low,M-Medium
positivematch_status		Positive Match Status. Values Mat- matched ,Amf-Auto match failed
negativematch_status		Negative Match Status. Values Mat- matched ,Amf-Auto match failed
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
ref_doc_ou		Reference Document Organization Unit
ref_doc_no	sql_variant	Reference Document Organization Number
ref_doc_line_no	int	Reference Document Line Number
po_ou		Purchase Order Organization Unit
po_no	sql_variant	Purchase Order Number
po_line_no	int	Purchase Order Line Number
po_amendment_no		Purchase Order Amendment Number
item_tcd_code	sql_variant	Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant

Table Name sin_po_hdr_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
po_number	sql_variant	Purchase Order Number	No	No
po_ou	int	Purchase Order Organization Unit
po_category	sql_variant	Purchase Order Category
po_before_flag		Purchase Order Before Flag
supplier		Supplier
pay_to_supplier		Pay To Supplier
currency		Currency
exchange_rate	bigint	Exchange Rate
paymode	sql_variant	Pay Mode
payterm		Pay Term
auth_date	datetime	Authorized Date
status	sql_variant	Status. Values D-Draft,F-Fresh,O-Open,A-Amended,P-Under Amendment,CA-Cancelled,H-Held,S-Short Closed, Cl-Closed,NT-NTclosed,U-Under Authorization,R-Revised,RET-Return,O-Open,CRDUE-Core Due, RCDUE-Receipt Due,CL-Closed
fb_id		Finance Book Id


Table Name sin_po_order_no_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
po_number	sql_variant	Purchase Order Number	No	No
po_ou	int	Purchase Order Organization Unit
po_category	sql_variant	Purchase Order Category
po_before_flag		Purchase Order Before Flag
supplier		Supplier
pay_to_supplier		Pay To Supplier
currency		Currency
exchange_rate	bigint	Exchange Rate
paymode	sql_variant	Pay Mode
payterm		Pay Term
auth_date	datetime	Authorized Date
status	sql_variant	Status. Values D-Draft,F-Fresh,O-Open,A-Amended,P-Under Amendment,CA-Cancelled,H-Held,S-Short Closed, Cl-Closed,NT-NTclosed,U-Under Authorization,R-Revised,RET-Return,O-Open,CRDUE-Core Due,RCDUE-Receipt Due,CL-Closed
guid		Guid
invoice_cat		Invoice Category
po_type		Purchase Order Type
po_expense_type		Purchase Order Expense Type
fwd_cover_flag		Forward Cover Flag


Table Name sin_pt_intxn_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
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


Table Name sin_qcd_intxn_codes_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
reason_code		Reason Code
reason_desc		Reason Description


Table Name sin_reconcile_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
po_ou	int	Purchase Order Organization Unit
po_no	sql_variant	Purchase Order Number
po_line_no	int	Purchase Order Line Number
invoice_ou		Invoice Organization Unit
invoice_no	sql_variant	Invoice Number
invoice_line_no	int	Invoice Line Number
timestamp		Time Stamp	No
gr_ou		Goods Receipt Organization Unit
gr_no	sql_variant	Goods Receipt Number
gr_line_no	int	Goods Receipt Line Number
reconcile_qty	bigint	Reconcile Quantity
inv_tran_type	sql_variant	Invoice Transaction Type
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
po_ou	int	Purchase Order Organization Unit
po_no	sql_variant	Purchase Order Number
po_line_no	int	Purchase Order Line Number
invoice_ou		Invoice Organization Unit
invoice_no	sql_variant	Invoice Number
invoice_line_no	int	Invoice Line Number

Table Name sin_reconcile_hdr
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
tran_date	datetime	Transaction Date
num_type	sql_variant	Numbering Type
fb_id		Finance Book Id
tran_currency		Transaction Currency
ref_doc_no		Reference Document Number
ref_doc_ou	int	Reference Document Organization Unit
rev_doc_no	sql_variant	Reversal Document Number
rev_doc_ou	int	Reversal Document Organization Unit
rev_date	datetime	Reversal Date
rev_reason_code	sql_variant	Reversal Reason Code
rev_remarks		Reversal Remarks
tran_status		Transaction Status. R-reconciled,U-unreconciled
qty_variance_amount	bigint	Quantity Variance Amount
rate_variance_amount		Rate Variance Amount
exchange_variance_amount		Exchange Variance Amount
total_variance_amount		Total Variance 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

Table Name sin_tcd_dtl

Table Comment Table that containt 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
tcd_version	int	Tax Charge Discount Version
item_tcd_var	sql_variant	Item Tax Charge Discount Variance
timestamp	int	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
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
proposed_amount	bigint	Proposed Amount
original_proposed_amt		Original Proposed Amount
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
enflg	sql_variant	A flag to identify if the user has entered any TCD's in the TCD tab page.
tcd_exrate	int	Exchange rate between tcd and po currency
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
tcd_version	int	Tax Charge Discount Version
item_tcd_var	sql_variant	Item Tax Charge Discount Variance

Table Name sin_tcd_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
line_no	int	Line Number
item_tcd_code	sql_variant	Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
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
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
enflg	sql_variant	flag
tax_key	sql_variant	tax_key

Table Name SIN_TCD_PO_GR_MAP
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
LINE_NO	int	Line Number
REF_DOC_OU		Reference Document Organization Unit
REF_DOC_NO	sql_variant	Reference Document Number
REF_DOC_LINE_NO	int	Reference Document Line Number
PO_OU		Purchase Order Organization Unit
PO_NO	sql_variant	Purchase Order Number
PO_LINE_NO	int	Purchase Order Line Number
PO_AMENDMENT_NO		Purchase Order Amendment Number
ITEM_TCD_CODE	sql_variant	Item Tax Charge Discount Code
ITEM_TCD_VAR		Item Tax Charge Discount Variant
TIMESTAMP	int	Time Stamp
PORS_TYPE	sql_variant	Purchase Order /Slip Type
ITEM_TYPE		Item Type
RECD_QTY	bigint	Received Quantity
RECD_AMOUNT		Received Amount
ACC_QTY		Account Quantity
ACC_AMOUNT		Account Amount
BILLED_QTY		Billed Quantity
BILLED_AMOUNT		Billed Amount
MATCHING_TYPE	sql_variant	Matching Type
TOLERANCE_TYPE		Tolerance Type
TOLREANCE_PERC	int	Tolerance Percentage
PROPOSED_QTY	bigint	Proposed Quantity
PROPOSED_RATE		Proposed Rate
PROPOSED_AMOUNT		Proposed Amount
MATCHED_QTY		Matched Quantity
MATCHED_AMOUNT		Matched Amount
MATCH_STATUS	sql_variant	Match Status. Values H-High,L-Low,M-Medium
POSITIVEMATCH_STATUS		Positive Match Status. Values Mat- matched, Amf-Auto match failed
NEGATIVEMATCH_STATUS		Negative Match Status. Values Mat- matched, Amf-Auto match failed
CREATEDBY		Created By
CREATEDDATE	datetime	Created Date
MODIFIEDBY	sql_variant	Modified By
MODIFIEDDATE	datetime	Modified Date


Table Name sin_tcd_tcdinfo_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
item_tcd_code		Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
cost_center		Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
item_type		Item Type
tcd_level		Tax Charge Discount Level
tcd_currency		Tax Charge Discount Currency
tcd_rate	bigint	Tax Charge Discount Rate
tcd_amount		Tax Charge Discount Amount
taxable_amount		Taxable Amount
tcd_amt_type	sql_variant	Tax Charge Discount Amount Type


Table Name sin_tcdcal_calcprocess_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tcdcal_guid	sql_variant	Tax Charge Discount Calculation Guid	No	No
tcdcal_tcdcode		Tax Charge Discount Calculation Tax Charge Discount Code
tcdcal_tcddocumentlevel		Tax Charge Discount Calculation Tax Charge Discount Document Level
tcdcal_tcdvariant		Tax Charge Discount Calculation Tax Charge Discount Variant
tcdcal_line_no	int	Tax Charge Discount Calculation Line Number
tcdcal_tcdvalue	bigint	Tax Charge Discount Calculation Tax Charge Discount Value
tcdcal_bv_lineitem		Tax Charge Discount Calculation Base Value Line Item
tcdcal_qty_lineitem		Tax Charge Discount Calculation Quantity Line Item
tcdcal_tcd_amount		Tax Charge Discount Calculation Quantity Line Amount


Table Name sin_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 Organization Type
Document_No		Document Organization 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. Values ADJ-Adjusted,AMF-AutoMatch Failed,AUT-Authorized,DEL-Deleted,FSH-Fresh,MAT-Matched,RVD-Reversed
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 Company 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. Values D-Draft,F-Fresh,O-Open,A-Amended,P-Under Amendment,CA-Cancelled,H-Held,S-Short Closed, Cl-Closed,NT-NTclosed,U-Under Authorization,R-Revised,RET-Return,O-Open,CRDUE-Core Due, RCDUE-Receipt Due,CL-Closed


Table Name sin_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
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 Deducted 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
account_code	sql_variant	Account Code
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
vat_line_no	int	Value Added Tax Line Number

Table Name sin_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 Deducted Percentage
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


Table Name sin_susp_upd_dtl
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
order_ou	fin_ouinstid	order ou	NO	NO
order_no	fin_documentnumber	order no	NO	NO
refdoc_no	fin_documentnumber	refdoc no	NO	NO
refdoc_lineno	fin_lineno	refdoc lineno	NO	NO
order_amendno	fin_poamendmentno	order amendno	NO	NO
tran_line_no	fin_lineno	tran lineno	NO	NO
tran_ou	fin_ouinstid	tran ou	NO	NO
fb_id	fin_financebookid	fbid	NO	NO
tran_no	fin_documentnumber	tran no	NO	NO
tran_type	fin_cmntrantype	tran type	NO	NO
tran_date	fin_date	tran date	NO	NO
tran_status	fin_status	tran status	NO	NO
tran_currency	fin_currency	tran currency	NO	NO
exch_rate	fin_exchangerate	exchange rate	NO	NO
tran_amount	fin_amount	tran amount	NO	NO
base_amount	fin_amount	base amount	NO	NO
suspbal_amount	fin_amount	suspbal amount	NO	NO
updated_date	fin_date	updated date	NO