Supplier Debit Credit Note

Table Name scdn_acc_dtl

Table Comment Table contains the debit and credit account code or item for each supplier notes

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
account_code	sql_variant	Account Code
drcr_id		Debit Credit Id
ref_doc_type		Reference Document Type
ref_doc_no		Reference Document Number
ref_doc_date	datetime	Reference Document Date
ref_doc_amount	bigint	Reference Document Amount
ordering_ou	int	Ordering Organization Unit
tran_amount	bigint	Transaction Amount
remarks	sql_variant	Remarks
cost_center		Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
base_amount	bigint	Base Amount
par_base_amount		Parallel 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
line_no	int	Line Number

Table Name scdn_acc_dtl_ref_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
account_code	varchar(32)	Account Code
analysis_code	varchar(5)	Analysis Code
ordering_ou	int	Ordering Organization Unit
billing_ou	varchar(16)	Billing Organization Unit
cost_center	varchar(10)	Cost Center
drcr_ind	varchar(40)	Debit Credit flag. Values Dr-Debit, Cr-Credit
ref_doc_type		Reference Document Type
ref_doc_amount	bigint	Reference Document Amount
ref_doc_date	datetime	Reference Document Date
ref_doc_no	varchar(18)	Reference Document Number
remarks	varchar(255)	Remarks
subanalysis_code	varchar(5)	Subanalysis Code
tran_amount	bigint	Transaction Amount

Table Name scdn_acc_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	varchar(18)	Transaction Number
line_no	int	Line Number
timestamp		Time Stamp
account_code	varchar(32)	Account Code
drcr_id	varchar(1)	Debit Credit Id
ref_doc_type	varchar(10)	Reference Document Type
ref_doc_no	varchar(18)	Reference Document Number
ref_doc_date	datetime	Reference Document Date
ref_doc_amount	bigint	Reference Document Amount
ordering_ou	int	Ordering Organization Unit
tran_amount	bigint	Transaction Amount
remarks	varchar(255)	Remarks
cost_center	varchar(10)	Cost Center
analysis_code	varchar(5)	Analysis Code
subanalysis_code		Subanalysis Code
base_amount	bigint	Base Amount
par_base_amount	numeric	Parallel Base Amount
createdby	varchar(15)	Created By
createddate	datetime	Created Date
modifiedby	varchar(15)	Modified By
modifieddate	datetime	Modified Date
guid	sql_variant	Guid

Table Name scdn_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 amount
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 scdn_adjustments_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
ref_doc_type		Reference Document Type
ref_doc_no		Reference Document Number
timestamp	int	Time Stamp
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 amount
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 Name scdn_ap_postings_dtl

Table Comment Table contains the info about the account posing for supplier against each Transaction

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
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
cust_code	sql_variant	Customer Code
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 scdn_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 scdn_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	Subscribed organization Unit Instance Id
subouinstname	sql_variant	Subscribed organization Unit Instance Name
subcompname		Subscribed company 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 scdn_dcnote_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 scdn_dcnote_hdr

Table Comment Table contains the Transaction number and the status of the each Supplier note.

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 AUT - Authorized, DEL - Deleted, FSH - Fresh HLD - Hold, RVD - Reversed
note_type		Note Type
note_cat		Note Category
num_type		Numbering Type
tran_date	datetime	Transaction Date
anchor_date		Anchor Date
fb_id	sql_variant	Finance Book
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_mode		Pay Mode
pay_method		Pay Method
pay_priority		Pay Priority
payment_ou	int	Payment Organization Unit
supp_ou		Supplier Organization Unit
supp_code	sql_variant	Supplier Code
supp_note_no		Supplier Note Number
supp_note_date	datetime	Supplier Note Date
supp_note_amount	bigint	Supplier Note Amount
comments	sql_variant	Comments
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
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 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 Exclusive Amount
vat_amount		Value Added Tax Amount
vat_incl_amount		Value Added Tax Inclusive Amount
pre_round_off_amount		Pre-round Off Amount
rounded_off_amount		Round Off Amount
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
batch_id	sql_variant	Batch Id
usage_id		Usage Id
esrflag		ESR Flag
forward_cover		Forward Cover
Fw_cov_flag		Forward Cover Flag
Fw_cov_rate	bigint	Forward Cover Rate

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 scdn_dcnote_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_type		Transaction Type
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
timestamp	int	Time Stamp
tran_status	sql_variant	Transaction Status. Values AUT - Authorized, DEL - Deleted, FSH - Fresh, HLD - Hold, RVD - Reversed
note_type		Note Type
note_cat		Note Category
num_type		Numbering Type
tran_date	datetime	Transaction Date
anchor_date		Anchor Date
fb_id	sql_variant	Finance Book Id
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_mode		Pay Mode
pay_method		Pay Method
pay_priority		Pay Priority
payment_ou	int	Payment Organization Unit
supp_ou		Supplier Organization Unit
supp_code	sql_variant	Supplier Code
supp_note_no		Supplier Note Number
supp_note_date	datetime	Supplier Note Date
supp_note_amount	bigint	Supplier Note Amount
comments	sql_variant	Comments
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 Computed 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 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 Exclusive Amount
vat_amount		Value Added Tax Amount
vat_incl_amount		Value Added Tax Inclusive Amount
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
usage_id	sql_variant	Usage Id

Table Name scdn_item_dtl

Table Comment Table contains the debit or credit documents for each item based notes.

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
visible_line_no		Visible Line Number
ref_doc_type	sql_variant	Reference Document Type
ref_doc_no		Reference Document Number
pors_type		Purchase Order Receipt /Slip Type
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
item_qty	bigint	Item Quantity
unit_price		Unit Price
item_amount		Item Amount
remarks	sql_variant	Remarks
tax_amount	bigint	Tax Amount
disc_amount		Discount Amount
line_amount		Line Amount
base_amount		Base Amount
par_base_amount		Parallel Base Amount
cost_center	sql_variant	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
pors_no	sql_variant	Purchase Order Slip Number
proposal_no		Proposal Number
cap_type_ind		Document Type
ref_doc_line	int	Reference Document Line
base_value	bigint	Base 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
line_no	int	Line Number

Table Name scdn_item_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
line_no	int	Line Number
timestamp		Time Stamp
visible_line_no		Visible Line Number
ref_doc_type	sql_variant	Reference Document Type
ref_doc_no		Reference Document Number
pors_type		Purchase Order Receipt/Slip Type
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
item_tcd_desc		Item Tax Charge Discount Description
item_qty	bigint	Item Quantity
unit_price		Unit Price
item_amount		Item Amount
remarks	sql_variant	Remarks
tax_amount	bigint	Tax Amount
disc_amount		Discount Amount
line_amount		Line Amount
base_amount		Base Amount
par_base_amount		Parallel Base Amount
cost_center	sql_variant	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
guid	sql_variant	Guid
item_type		Item Type
tcd_level		Tax Charge Discount Level
tcd_on_line_no		Tax Charge Discount On Line Number
pors_no		Purchase Order Receipt / Slip Number
tcd_version	int	Tax Charge Discount Version
tcd_currency	sql_variant	Tax Charge Discount Currency
compute_flag		Compute Flag
proposal_no		Proposal Number
cap_type_ind		Document Type
tcd_basis		Tax Charge Discount Basis
taxable_amount	bigint	Taxable Amount
Fw_cov_rate		Forward Cover Rate
Fw_cov_flag	sql_variant	Forward Cover Flag
tran_currency		Transaction Currency
exchange_rate	bigint	Exchange Rate
taxkey	varchar(18)	Tax Key
taxkeydesc	sql_variant	Tax Key Description

Table Name scdn_notes_dtl

Table Comment Table that contains 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
timestamp	int	Time Stamp	No
note_text	sql_variant	Note Text
line_no	int	Line Number
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
note_category		Note Category
category_value		Category Value

Table Name scdn_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 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 Percent
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 scdn_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 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
line_no	int	Line Number

Table Name scdn_rpt_account_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
notenumber	sql_variant	Note Number	No	No
notedate	datetime	Note Date
notetype	sql_variant	Note Type
status		Status
currency		Currency
amount	bigint	Amount
companyname	sql_variant	Company Name
companyaddress1		Company Address 1
companyaddress2		Company Address 2
companyaddress3		Company Address 3
companyaddress4		Company Address 4
companyaddress5		Company Address 5
companyaddress6		Company Address 6
companyaddress7		Company Address 7
suppliername		Supplier Name
supplieraddress1		Supplier Address 1
supplieraddress2		Supplier Address 2
supplieraddress3		Supplier Address 3
supplieraddress4		Supplier Address 4
supplieraddress5		Supplier Address 5
supplieraddress6		Supplier Address 6
supplieraddress7		Supplier Address 7
supplieraddress8		Supplier Address 8
supplieraddress9		Supplier Address 9
noteamount	bigint	Note Amount
accountcode	sql_variant	Account Code
accountdesc		Account Description
discount	bigint	Discount
refdocno	sql_variant	Reference Document Number
refdocdate	datetime	Reference Document Date
duedate		Due Date
dueamount	bigint	Due Amount
discountdate	datetime	Discount Date
discountamount	bigint	Discount Amount
penaltypercent		Penalty Percentage
comments	sql_variant	Comments
order_flag		Order Flag
drcr_flag		Debit Credit Flag
term_no		Term Number
remarks		Remarks
costcenter		Cost Center
guid		Guid

Table Name scdn_rpt_item_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
notenumber	sql_variant	Note Number	No	No
notedate	datetime	Note Date
notetype	sql_variant	Note Type
status		Status
currency		Currency
amount	bigint	Amount
companyname	sql_variant	Company Name
companyaddress1		Company Address 1
companyaddress2		Company Address 2
companyaddress3		Company Address 3
companyaddress4		Company Address 4
companyaddress5		Company Address 5
companyaddress6		Company Address 6
companyaddress7		Company Address 7
suppliername		Supplier Name
supplieraddress1		Supplier Address 1
supplieraddress2		Supplier Address 2
supplieraddress3		Supplier Address 3
supplieraddress4		Supplier Address 4
supplieraddress5		Supplier Address 5
supplieraddress6		Supplier Address 6
supplieraddress7		Supplier Address 7
supplieraddress8		Supplier Address 8
supplieraddress9		Supplier Address 9
noteamount	bigint	Note Amount
tax		Tax
charge		Charge
discount		Discount
itemdescription	sql_variant	Item Description
uom		Unit Of Measurement
quantity	bigint	Quantity
rate		Rate
baseamount		Base Amount
refdocno	sql_variant	Reference Document Number
refdocdate	datetime	Reference Document Date
duedate		Due Date
dueamount	bigint	Due Amount
discountdate	datetime	Discount Date
discountamount	bigint	Discount Amount
penaltypercent		Penalty Percentage
line_no	int	Line Number
remarks	sql_variant	Remarks
Item_code		Item Flag
order_flag		Order Flag
guid		Guid

Table Name scdn_tcd_dtl

Table Comment Table contain the document and line level TCD 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
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
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 scdn_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
timestamp	int	Time Stamp
item_tcd_desc	sql_variant	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
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
modeflag	sql_variant	Mode Flag
tax_type		Tax Type (Types of Taxes)

Table Name scdn_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
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 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
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 scdn_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
doc_line_no	int	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	Tax Charge Discount Rate
inp_vat_deduct_per		Input Tax Charge Discount Deduct Per
item_amount		Item Amount
vat_item_charge		Value Added Tax Charge
non_vat_item_charge		Other Than Value Added Tax 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
vat_line_no	int	Value Added Tax Line Number
guid	sql_variant	Guid