Customer Debit Credit Note

Table Name cdcn_acc_dtl

Table Comment Table contains the debit and credit account code or item for each customer 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
tran_type	sql_variant	Transaction Type
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number

Table Name cdcn_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
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	numeric(9)	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	numeric(9)	Base Amount
par_base_amount		Parallel Base Amount
createdby	varchar(15)	Created By
createddate	datetime	Created Date
modifiedby	varchar(15)	Modified By
modifieddate	datetime	Modified Date
guid	varchar(128)	Guid

Table Name cdcn_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
tran_type	sql_variant	Transaction Type
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 cdcn_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
ref_doc_supp_ou	int	Reference Document Supplier Organization Unit
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
guid	sql_variant	Guid

Table Name cdcn_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
tran_type	sql_variant	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
tcd_version	int	Tax Charge Discount Version

Table Name cdcn_ar_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.Values P-Posted
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 Exchange 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
cust_code	sql_variant	Customer Code
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 Finance Book Id
reftran_no		Reference Transaction Number
reftran_ou	int	Reference Transaction Organization Unit
ref_tran_type	sql_variant	Reference Transaction Type
uom		Unit Of Measurement
org_vat_base_amt	bigint	Organization Value Added Tax Base Amount
vat_line_no	int	Value Added Tax Line Number

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment
tran_type	sql_variant	Transaction Type
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
posting_line_no	int	Posting Line Number

Table Name cdcn_autogen_note_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
sequence_no	int	Sequence Number
note_no	sql_variant	Note Number

Table Name cdcn_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	Public Organization Unit Instance Id
pubouinstname	sql_variant	Public Organization Unit Instance Name
pubcompname		Public Company Name
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Name cdcn_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
tran_type	sql_variant	Transaction Type
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number

Table Name cdcn_dcnote_hdr

Table Comment Table contains the Transaction number and the status of the each customer 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 DFT- Draft, FSH- Fresh,AUT -Authorized,HLD -Held,DEL -Deleted,RVD -Reversed,RTD -Returned,ADJ -Adjusted,PAD -Partly Adjusted,HAU -Held Authorised,HPP -Held Partly Paid
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 Pay
pay_mode		Pay Mode
pay_method		Payment Method
cust_ou	int	Customer Organization Unit
cust_code	sql_variant	Customer Code
cust_note_no		Customer Note Number
cust_note_date	datetime	Customer Note Date
cust_note_amount	bigint	Customer 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.Values P-Posted
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
cust_bank_acct		Customer Bank Account
cust_bank_id		Customer Bank Id
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
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
forward_cover	sql_variant	Forward Cover
Fw_cov_flag		Forward Cover Flag
Fw_cov_rate	bigint	Forward Cover Rate
usageid	sql_variant	Usage Id

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment
tran_type	sql_variant	Transaction Type
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number

Table Name cdcn_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
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		Payment Method
cust_ou	int	Customer Organization Unit
cust_code	sql_variant	Customer Code
cust_note_no		Customer Note Number
cust_note_date	datetime	Customer Note Date
cust_note_amount	bigint	Customer 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 Company 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 Base Parallel Reference
comp_bp_acc_no		Company Base Parallel Account Number
esr_id		ESR Id
cust_bank_acct		Customer Bank Account
cust_bank_id		Customer Bank Id
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
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
forward_cover	sql_variant	Forward Cover
Fw_cov_flag		Forward Cover Flag
Fw_cov_rate	bigint	Forward Cover Rate
usageid	sql_variant	Usage Id

Table Name cdcn_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
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
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
tran_type	sql_variant	Transaction Type
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number

Table Name cdcn_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
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
item_tcd_type	sql_variant	Item Tax Charge Discount Type
guid		Guid
tcd_level		Value Added Tax Level
ref_doc_line	int	Reference Document Line
base_value	bigint	Base Value
tran_currency	sql_variant	Transaction Currency
BASECUR_ERATE	bigint	Base Currency Exchange Rate
Fw_cov_flag	sql_variant	Forward Cover Flag
forward_cover		Forward Cover
taxkey	varchar(18)	Tax Key
taxkeydesc	sql_variant	Tax Key Description

Table Name cdcn_note_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	sql_variant	Company Code	No	No
company_name		Company Name
supplier_code		Supplier Code
supplier_name		Supplier Name
account_code		Account Code
account_desc		Account Description
item_tcd_code		Item Tax Charge Discount Code
item_desc		Item Description
UOM		Unit Of Measurement
item_tcd_var		Item Tax Charge Discount Variant
line_no	int	Line Number
tcd_level	sql_variant	Tax Charge Discount Level
tcd_amount	bigint	Tax Charge Discount Amount
analysis_code	sql_variant	Analysis Code
cost_center		Cost Center
debitcredit		Debit / Credit
refdoc_type		Reference Document Type
refdocamount	bigint	Reference Document Amount
refdocdate	datetime	Reference Document Date
refdocno	sql_variant	Reference Document Number
refdocumentou	int	Reference Document Organization Unit
remarks	sql_variant	Remarks
subanalysiscode		Subanalysis Code
transactionamountml	bigint	Transaction Amount in Multi-Line
anchor_date	datetime	Anchor Date
bill_to_id	sql_variant	Bill To Id
comments		Comments
createdby		Created By
createddate	datetime	Created Date
tran_currency	sql_variant	Transaction Currency
cust_code		Customer Code
customerarea		Customer Area
customername		Customer Name
customernoteamount	bigint	Customer Note Amount
customernotedate	datetime	Customer Note Date
customernoteno	sql_variant	Customer Note Number
documenttype		Document Type
drcrnotetype		Debit Credit Note Type
exchangerate	bigint	Exchange Rate
fbid	sql_variant	Finance Book Id
hldremarks		Hold Remarks
holdreasoncode		Hold Reason Code
lastmodificationby		Last Modification By
lastmodifieddate	datetime	Last Modified By
noteamtaftgst	bigint	Note Amount After
noteamtbefgst		Note Amount Before
tran_date	datetime	Transaction Date
notenumber	sql_variant	Note Number
ouinstid	int	Organization Unit Instance Id
paymode	sql_variant	Payment Mode
payschedule		Payment Schedule
payterm		Pay Term
receiptmethod		Receipt Method
reversaldate	datetime	Reversal Date
reversaldocumentnumber	sql_variant	Reversal Document Number
revreasoncode		Reversal Reason Code
rev_remarks		Reversal Remarks
status		Status
status_desc		Status Description
tran_amount	bigint	Transaction Amount
company_address1	sql_variant	Company Address 1
company_address2		Company Address 2
company_address3		Company Address 3
company_address4		Company Address 4
company_address5		Company Address 5
company_address6		Company Address 6
company_address7		Company Address 7
customer_address1		Customer Address 1
customer_address2		Customer Address 2
customer_address3		Customer Address 3
customer_address4		Customer Address 4
customer_address5		Customer Address 5
customer_address6		Customer Address 6
customer_address7		Customer Address 7
customer_address8		Customer Address 8
customer_address9		Customer Address 9
customer_address10		Customer Address 10
quantity	bigint	Quantity
rate		Rate
tax_amount		Tax Amount
duedate	datetime	Due Date
dueamount	bigint	Due Amount
discountdate	datetime	Discount Date
discountamount	bigint	Discount Amount
penaltypercent		Penalty Percent
chargeamount		Charge Amount
place	sql_variant	Place
guid		Guid

Table Name cdcn_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
tran_type	sql_variant	Transaction Type
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 cdcn_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.Values P-Posted
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 Percent
disc_amount		Discount Amount
penalty_percent		Penalty Percent
esr_ref_no	sql_variant	ESR Reference Number
esr_coding_line		ESR Coding Line
base_due_amount	bigint	Base Due Amount
base_disc_amount		Base Discount 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
tran_type	sql_variant	Transaction Type
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
term_no		Term Number

Table Name cdcn_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 Variance
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	Item Tax Charge 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
tran_type	sql_variant	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 Variance
tcd_version	int	Tax Charge Discount Version

Table Name cdcn_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
tcd_version	int	Tax Charge Discount Version
timestamp		Time Stamp
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
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 (Types of Vat)

Table Name cdcn_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 Percentage
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 Discount Charge
item_level_disc_amount		Item Level Discount Amount
dist_disc_amount		Distributed 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
tran_type	sql_variant	Transaction Type
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
vat_line_no	int	Value Added Tax Line Number

Table Name cdcn_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	Value Added Tax Line Number
timestamp		Time Stamp
doc_line_no		Document Line Number
item_type	sql_variant	Item Type
item_tcd_code		Item Tax Charge Discount
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 Deduction 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 Distributed Charge
item_level_disc_amount		Item Level Discount Amount
dist_disc_amount		Distributed 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