Customer Direct Invoice

Table Name cdi_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 cdi_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
guid	sql_variant	Guid
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Name cdi_alloc_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
alloc_line_no		Allocate Line Number
timestamp		Time Stamp
lot_no	sql_variant	Lot Number
sublot_no		Sublot Number
zone		Zone
bin		Bin
alloc_qty	bigint	Allocate Quantity
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
guid	sql_variant	Guid

Table Name cdi_alloc_item_detail_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
allc_guid	sql_variant	Guid	No	No
allc_ouinstid	int	Organization Unit Instance Id
allc_doc_no	sql_variant	Document Number
allc_doc_ou	int	Document Organization Unit
allc_doc_type	sql_variant	Document Type
allc_doc_date	datetime	Document Date
allc_doc_line_no	int	Document Line Number
allc_doc_sch_no1		Document Schedule Number 1
allc_doc_sch_no2		Document Schedule Number 2
allc_doc_sch_no3		Document Schedule Number 3
allc_alloc_line_no		Allocate Line Number
allc_wh_no	sql_variant	WH Number
allc_kitmodel_code		Kit Model Code
allc_item_code		Item Code
allc_variant_code		Variant Code
allc_refdoc_no		Reference Document Number
allc_refdoc_type		Reference Document Type
allc_refdoc_line_no	int	Reference Document Line Number
allc_refdoc_sch_no1		Reference Document Schedule Number 1
allc_refdoc_sch_no2		Reference Document Schedule Number 2
allc_refdoc_sch_no3		Reference Document Schedule Number 3
allc_need_date	datetime	Need Date
allc_zone_no	sql_variant	Zone Number
allc_bin_no		Bin Number
allc_lot_no		Lot Number
allc_sub_lot_no		Sublot Number
allc_serial_no		Serial Number
allc_req_stockstatus		Request Stock Status
allc_tran_uom		Transaction Unit Of Measurement
allc_allocated_qty	bigint	Allocated Quantity
allc_modkit_qty	varchar(1)	Modkit Quantity
allc_issued_qty		Issued Quantity
cost_center	sql_variant	Cost Center

Table Name cdi_alloc_itm_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
ouinstid	int	Organization Unit Instance Id
doc_no	sql_variant	Document Number
doc_ou	int	Document Organization Unit
doc_type	sql_variant	Document Type
doc_date	datetime	Document Date
doc_line_no	int	Document Line Number
doc_sch_no1		Document Schedule Number 1
doc_sch_no2		Document Schedule Number 2
doc_sch_no3		Document Schedule Number 3
wh_code	sql_variant	WH Code
item_code		Item Code
variant_code		Variant Code
refdoc_no		Reference Document Number
refdoc_type		Reference Document Type
refdoc_line_no	int	Reference Document Line Number 1
refdoc_sch_no1		Reference Document Schedule Number 1
refdoc_sch_no2		Reference Document Schedule Number 2
refdoc_sch_no3		Reference Document Schedule Number 3
need_date	datetime	Need Date
zone_no	sql_variant	Zone Number
bin_no		Bin Number
lot_no		Lot Number
sub_lot_no		Sublot Number
serial_no		Serial Number
stock_status		Stock Status
tran_uom		Transaction Unit Of Measurement
requested_qty	bigint	Requested Quantity
modkit_code	sql_variant	Modkit Code
partial_flag		Partial Flag
alloc_method		Allocated Method
attribute_alloc		Attribute Allocated
cost_center		Cost Center

Table Name cdi_alloc_quantity_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_code		Item Code
variant_code		Variant Code
from_stock_status		From Stock Status
to_stock_status		To Stock Status
wh_code		WH Code
zone		Zone
bin		Bin
lot		Lot
sublot		Sublot
serial_no		Serial Number
tran_no		Transaction Number
line_no	int	Line Number
tran_date	datetime	Transaction Date
tran_uom	sql_variant	Transaction Unit Of Measurement
tran_quantity	bigint	Transaction Quantity
tran_ou	int	Transaction Organization Unit

Table Name cdi_allocations_dtl

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number
alloc_line_no		Allocated Line Number
timestamp		Time Stamp	No
lot_no	sql_variant	Lot Number
sublot_no		Sublot Number
zone		Zone
bin		Bin
alloc_qty	bigint	Allocated Quantity
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

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

Table Name cdi_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 cdi_ar_postings_dtl

Table Comment Table contains the info about the account posing for customer against each Transactions

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	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 Finance Book Id
reftran_no		Reference Transaction Number
reftran_ou	int	Reference Transaction Organization Unit
reftran_type	sql_variant	Reference Transaction Type
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
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 cdi_asset_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_date	datetime	Transaction Date
tran_no	sql_variant	Transaction Number
tran_ou	int	Transaction Organization Unit
supp_code	sql_variant	Supplier Code
supp_name		Supplier Name
fb_id		Finance Book Id
line_no	int	Line Number
item_tcd_code	sql_variant	Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
proposal_no		Proposal Number
item_amount	bigint	Item Amount
account_code	sql_variant	Account Code

Table Name cdi_attributes_dtl

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number
attr_code	varchar(10)	Attribute Code
timestamp	int	Time Stamp	No
attr_desc	sql_variant	Attribute Description
attr_type		Attribute Type
qual_value		Quality Value
min_qty_value	bigint	Minimum Quantity Value
max_qty_value		Maximum Quantity Value
std_qty_value		Standard Quantity Value
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
attr_code	varchar(10)	Attribute Code

Table Name cdi_attributes_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
attr_code	sql_variant	Attribute Code
timestamp	int	Time Stamp
attr_desc	sql_variant	Attribute Description
attr_type		Attribute Type
qual_value		Quality Value
min_qty_value	bigint	Minimum Quantity Value
max_qty_value		Maximum Quantity Value
std_qty_value		Standard Quantity Value
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
guid	sql_variant	Guid

Table Name cdi_cim_intxn_ou_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
subouinstid	int	Suborganization Unit Instance Id
subouinstname	sql_variant	Suborganization Unit Instance Name
subcompname		Subcompany Name
pubouinstid	int	Published Organization Unit Instance Id
pubouinstname	sql_variant	Published Organization Unit Instance Name
pubcompname		Published Company Name

Table Name cdi_compute_tot_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
alloc_method		Allocated Method
amount	bigint	Amount
analysiscode	sql_variant	Analysis Code
attribute_alloc		Attribute Allocate
costcenter		Cost Center
item_codeml		Item Code Multiline
item_type		Item Type
itemdesc		Item Description
itm_var		Item Variant
linenumber	int	Line Number
modeflag	sql_variant	Mode Flag
proposalnumber		Proposal Number
quantity	bigint	Quantity
remarks	sql_variant	Remarks
sale_purposeml		Sale Purpose Multiline
subanalysiscode		Subanalysis Code
unitofmeasure		Unit Of Measure
unitprice	bigint	Unit Price
warehouse_code_mul	sql_variant	Ware House Code Multiple
amtinvcurr	bigint	Amount Invoice Currency
currency_code	sql_variant	Currency Code
exchangerate	bigint	Exchange Rate
freight_term	sql_variant	Freight Term
pslipno		Pay Slip Number
shippingpoint		Shipping Point
shiptocode		Ship To Code
shiptoid		Ship To Id

Table Name cdi_dealloc_itm_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
ouinstid	int	Organization Unit Instance Id
doc_no	sql_variant	Document Number
doc_ou	int	Document Organization Unit
doc_type	sql_variant	Document Type
doc_date	datetime	Document Date
doc_line_no	int	Document Line Number
doc_sch_no1		Document Schedule Number 1
doc_sch_no2		Document Schedule Number 2
doc_sch_no3		Document Schedule Number 3
doc_alloc_no		Document Allocation Number
wh_code	sql_variant	WH Code
item_code		Item Code
variant_code		Variant Code
refdoc_no		Reference Document Number
refdoc_type		Reference Document Type
refdoc_line_no	int	Reference Document Line Number 1
refdoc_sch_no1		Reference Document Schedule Number 1
refdoc_sch_no2		Reference Document Schedule Number 2
refdoc_sch_no3		Reference Document Schedule Number 3
zone_no	sql_variant	Zone Number
bin_no		Bin Number
lot_no		Lot Number
sub_lot_no		Sublot Number
serial_no		Serial Number
stock_status		Stock Status
tran_uom		Transaction Unit Of Measurement
requested_qty	bigint	Requested Quantity
modkit_code	sql_variant	Modkit Code
partial_flag		Partial Flag
alloc_method		Allocated Method
attribute_alloc		Attribute Allocation

Table Name cdi_flightticket_met

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
component_id	sql_variant	Component Id	No	No
parameter_category		Parameter Category
parameter_code		Parameter Code
parameter_text		Parameter Text
language_id	int	Language Id
createdby	sql_variant	Created By
createddate	datetime	Created Date

Table Name cdi_frt_dtl

Table Comment Table that containst the Freight amount’s for the packslip invoices

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number
timestamp		Time Stamp	No
so_no	sql_variant	Supplier Order Number
packslip_no		Pack Slip Number
frt_term		Freight Term
frt_amount	bigint	Freight Amount
frt_currency	sql_variant	Freight Currency
exchange_rate	bigint	Exchange Rate
frt_inv_cur_amount		Freight Invoice Currency 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 cdi_invoice_hdr

Table Comment Table contains the invoice number and the invoices status info for each documents

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
timestamp	int	Time Stamp	No
tran_status	sql_variant	Transaction Status. Values DFT- Draft, FSH -Fresh, RTD -Returned, DEL -Deleted, AUT -Authorized, HLD -Held, HAU -Held Authorised, PAD -Partly Adjusted, HPA -Held Partly Adjusted PPD -Partly Paid, HPP -Held Partly Paid, FPD -Paid, ADJ -Adjusted, RVD -Reversed, SHP -Shipped, NSH -Not Shipped
tran_date	datetime	Transaction Date
anchor_date		Anchor Date
fb_id	sql_variant	Finance Book Id
bill_to_cust		Bill To Customer
auto_adjust		Auto Adjust
tran_currency		Transaction Currency
exchange_rate	bigint	Exchange Rate
pay_term	sql_variant	Pay Term
payterm_version	int	Pay Term Version
receipt_method	sql_variant	Receipt Method
comments		Comments
tran_amount	bigint	Transaction Amount
receipt_type	sql_variant	Receipt Type
sales_channel		Sales Channel
sales_type		Sales Type
ship_to_cust		Ship To Customer
ship_to_id		Ship To Id
price_list_code		Price List Code
sales_person		Sales Person
par_exchange_rate	bigint	Parallel Exchange Rate
item_amount		Item Amount
tax_amount		Tax Amount
disc_amount		Discount Amount
gross_frt_amount		Gross Freight Amount
net_frt_amount		Net Freight 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
disc_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 Charge 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
frt_cost_center	sql_variant	Freight Cost Center
frt_analysis_code		Freight Analysis Code
frt_subanalysis_code		Freight Subanalysis Code
pre_round_off_amount	bigint	Pre-round Off Amount
rounded_off_amount		Rounded Off Amount
batch_id	sql_variant	Batch Id
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
draft_flag	sql_variant	Draft Flag

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 cdi_invoice_hdr_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
timestamp	int	Time Stamp
tran_status	sql_variant	Transaction Status
tran_date	datetime	Transaction Date
anchor_date		Anchor Date
fb_id	sql_variant	Finance Book Id
bill_to_cust		Bill To Customer
bill_to_cust_name		Bill To Customer Name
auto_adjust		Auto Adjust
tran_currency		Transaction Currency
exchange_rate	bigint	Exchange Rate
pay_term	sql_variant	Pay Term
receipt_method		Receipt Method
comments		Comments
tran_amount	bigint	Transaction Amount
receipt_type	sql_variant	Receipt Type
sales_channel		Sales Channel
sales_type		Sales Type
ship_to_cust		Ship To Customer
ship_to_cust_name		Ship To Customer Name
ship_to_id		Ship To Id
price_list_code		Price List Code
sales_person		Sales Person
par_exchange_rate	bigint	Parallel Exchange Rate
item_amount		Item Amount
tax_amount		Tax Amount
disc_amount		Discount Amount
gross_frt_amount		Gross Freight Amount
net_frt_amount		Net Freight Amount
base_amount		Base Amount
par_base_amount		Parallel Base Amount
rev_doc_no	sql_variant	Reversal Document Number
rev_doc_ou	int	Reversal Document Organization Unit
rev_date	datetime	Reversal Date
ref_doc_no	sql_variant	Reference Document Number
ref_doc_ou	int	Reference Document Organization Unit
rev_reason_code	sql_variant	Reversal Reason Code
rev_remarks		Reversal Remarks
hld_date	datetime	Hold Date
hld_reason_code	sql_variant	Hold Reason Code
hld_remarks		Hold Remarks
auth_date	datetime	Authorized Date
posting_date		Posting Date
posting_status	sql_variant	Posting Status
disc_comp_basis		Discount Component Basis
comp_bp_code		Company Bank / PTT Code
bank_code		Bank Code
lsv_id		LSV Id
comp_acct_in		Company Account Information
comp_bp_ref		Company Bank / PTT Reference
comp_bp_acc_no		Company Bank / PTT Account Code
esr_id		ESR Id
cust_bank_acct		Customer Bank Account
cust_bank_id		Customer Bank Id
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 Charges
vat_excl_amount	bigint	Value Added Tax Exclude Amount
vat_amount		Value Added Tax Amount
vat_incl_amount		Value Added Tax Include Amount
frt_cost_center	sql_variant	Freight Cost Center
frt_analysis_code		Freight Analysis Code
frt_subanalysis_code		Freight Subanalysis Code
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
guid	sql_variant	Guid

Table Name cdi_issue_dtl_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
warehouse_ou	int	Ware House Organization Unit	No	No
warehouse_id	sql_variant	Ware House Id
receiving_ou	int	Receiving Organization Unit
ref_doc_no	sql_variant	Reference Document Number
cust_crt_ou	int	Customer Credit Organization Unit
cust_code	sql_variant	Customer Code
actusage_flag		Actual Usage Flag
task_ou	int	Task Organization Unit
task_no		Task Number
task_seq_no		Task Sequence Number
task_key_seqno		Task Key Sequence Number
iss_part_pln_ou		Issue Part Planning Organization Unit
iss_part_crt_ou		Issue Part Credit Organization Unit
iss_part_no	sql_variant	Issue Part Number
iss_qty	bigint	Issue Quantity
iss_qty_uom	sql_variant	Issue Quantity Unit Of Measurement
iss_part_status		Issue Part Status
exp_rtn_date	datetime	Expiry Return Date
remarks	sql_variant	Remarks
stktrnsfer_lineno	int	Stock Transfer Line Number
zone_id	sql_variant	Zone Id
bin_id		Bin Number
lot_no		Lot Number
serial_no		Serial Number
part_condtion		Part Condition
stock_acc_code		Stock Account Code
cogs_acc_code		Account Code
cogs_analysis_code		Analysis Code
cogs_subanalysis_code		Subnalysis Code
guid		Guid
cogs_acc_usage		Analysis Usages
cogs_fin_book		Finance Book
cdi_storagelvl_qty	bigint	Storage Level Quantity
storage_lvl_line_no	int	Storage Level Line Number
cost_center	sql_variant	Cost Center

Table Name cdi_item_dtl

Table Comment Table contains the item number,Quantity and rate & uom for each Item invoices

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number
timestamp		Time Stamp	No
visible_line_no		Visible Line Number
item_tcd_code	sql_variant	Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
usage_id		Usage Id
item_type		Item Type
uom		Unit Of Measurement
item_qty	bigint	Item Quantity
unit_price		Unit Price
base_value		Base Value
item_amount		Item Amount
tax_amount		Tax Amount
disc_amount		Discount Amount
line_amount		Line Amount
base_amount		Base Amount
par_base_amount		Parallel Base Amount
sale_purpose	sql_variant	Sales Purpose
warehouse_code		Ware House Code
alloc_method		Allocation Method
attr_alloc		Attribute Allocation
proposal_no		Proposal Number
shipping_ou	int	Shipping Organization Unit
ship_to_cust	sql_variant	Ship To Customer
ship_to_id		Ship To Id
packslip_no		Pack Slip Number
packslip_ou	int	Pack Slip Organization Unit
packslip_line_no		Pack Slip Line Number
remarks	sql_variant	Remarks
cost_center		Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

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 cdi_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
item_tcd_code	sql_variant	Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
item_tcd_desc		Item Tax Charge Discount Description
item_type		Item Type
uom		Unit Of Measurement
item_qty	bigint	Item Quantity
unit_price		Unit Price
item_amount		Item Amount
tax_amount		Tax Amount
disc_amount		Discount Amount
line_amount		Line Amount
base_amount		Base Amount
par_base_amount		Parallel Base Amount
sale_purpose	sql_variant	Sale Purpose
warehouse_code		Ware House Code
alloc_method		Allocation Method
attr_alloc		Attribute Allocation
proposal_no		Proposal Number
shipping_ou	int	Shipping Organization Unit
ship_to_cust	sql_variant	Ship To Customer
ship_to_cust_name		Ship To Customer Name
ship_to_id		Ship To Id
packslip_no		Pack Slip Number
remarks		Remarks
cost_center		Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
guid	sql_variant	Guid
item_tcd_type		Item Tax Charge Discount Type
status		Status
fin_usage_id		Finance Usage Id
shipping_ou_name		Shipping Organization Unit Name
packslip_lineno	int	Pack Slip Line Number
packslip_ou		Pack Slip Organization Unit
packslip_date	datetime	Pack Slip Date
ps_flag	sql_variant	Pack Slip Flag
allocmet_desc		Allocation Material Description
base_value	bigint	Base Value
cont_id	sql_variant	Conduct Id
jlog_no		Log Number
invgen_type		Invoice Generation Type
ft_reference		Freight Reference
flag		Flag
hinv_line_no	int	Header Invoice Line Number
billing_date	datetime	Billing Date
taxkey	varchar(18)	Trn-Bsg-RCN-CDI-R62-3.0 Taxkey
taxkeydesc	sql_variant	Trn-Bsg-RCN-CDI-R62-3.0 Taxkey description

Table Name cdi_jlog_backupd_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
ftno	sql_variant	Freight Number
invno		Invoice Number
invstatus		Invoice Status

Table Name cdi_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 cdi_packslip_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
pkslipno		Pack Slip Number
pkslipdate	datetime	Pack Slip Date
shippingou	int	Shipping Organization Unit
shippingouname	sql_variant	Shipping Organization Unit Name
billtocust		Bill To Customer
billtocustname		Bill To Customer Name
shiptocust		Ship To Customer
shiptocustname		Ship To Customer Name
shiptoid		Ship To Id
pkslipou	int	Pack Slip Organization Unit
packsliplineno		Pack Slip Line Number
invoicedqty	bigint	Invoiced Quantity

Table Name cdi_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	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. 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 Component 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
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 Name cdi_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 Component 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
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
line_no	int	Line Number
esr_amount	bigint	ESR Amount
base_esr_amount		Base ESR Amount

Table Name cdi_price_disc_in_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
disc_guid	sql_variant	Guid	No	No
disc_login_ou	int	Login Organization Unit
disc_info_level	sql_variant	Information Level
disc_doc_line_no	int	Document Line Number
disc_item_ou		Item Organization Unit
disc_item_type	sql_variant	Item Type
disc_item_code		Item Code
disc_item_group		Item Group
disc_item_variant		Item Variant
disc_uom		Unit Of Measurement
disc_qty	bigint	Quantity
disc_rate		Rate
disc_pricing_date	datetime	Pricing Date
disc_ordcustomer_ou	int	Order Customer Organization Unit
disc_billcustomer_ou		Bill Customer Organization Unit
disc_shipcustomer_ou		Ship Customer Organization Unit
disc_ordcustomer_code	sql_variant	Order Customer Code
disc_billcustomer_code		Bill Customer Code
disc_shipcustomer_code		Ship Customer Code
disc_shipping_point	int	Shipping Point
disc_shipping_wh	sql_variant
disc_delivery_area		Delivery Area
disc_sales_channel		Sales Channel
disc_currency		Currency
disc_doc_amount	bigint	Document Amount
disc_op_param1	sql_variant	Optional Parameter 1
disc_op_param2		Optional Parameter 2
disc_op_param3		Optional Parameter 3
disc_op_param4	datetime	Optional Parameter 4

Table Name cdi_price_engine_in_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
price_guid	sql_variant	Guid	No	No
price_login_ou	int	Login Organization Unit
price_info_level	sql_variant	Information Level
price_doc_line_no	int	Document Line Number
price_item_ou		Item Organization Unit
price_item_type	sql_variant	Item Type
price_item_code		Item Code
price_item_group		Item Group
price_item_variant		Item Variant
price_uom		Unit Of Measurement
price_qty	bigint	Quantity
price_unit_rate		Unit Rate
price_default_price	sql_variant	Default Price
price_default_promotion		Default Promotion
price_pricing_date	datetime	Pricing Date
price_ordcustomer_ou	int	Order Customer Organization Unit
price_billcustomer_ou		Bill Customer Organization Unit
price_shipcustomer_ou		Ship Customer Organization Unit
price_ordcustomer_code	sql_variant	Order Customer Code
price_billcustomer_code		Bill Customer Code
price_shipcustomer_code		Ship Customer Code
price_shipping_point	int	Shipping Point
price_shipping_wh	sql_variant
price_delivery_area		Delivery Area
price_sales_channel		Sales Channel
price_currency		Currency
price_pricelist_code		Price List Code
price_ref_doc_type		Reference Document Type
price_ref_doc_no		Reference Document Number
price_ref_doc_ou	int	Reference Document Organization Unit
price_ref_doc_lineno		Reference Document Line Number
price_op_param1	sql_variant	Optional Parameter 1
price_op_param2		Optional Parameter 2
price_op_param3		Optional Parameter 3
price_op_param4	datetime	Optional Parameter 4

Table Name cdi_price_fet_attr_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
price_guid	sql_variant	Guid	No	No
price_login_ou	int	Login Organization Unit
price_doc_line_no		Document Line Number
price_attrib_line_no		Attribute Line Number
price_attribute_code	sql_variant	Attribute Code
price_qualitative_value		Qualitative Value
price_min_value	bigint	Minimum Value
price_max_value		Maximum Value

Table Name cdi_price_fetch_in_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
price_guid	sql_variant	Guid	No	No
price_login_ou	int	Login Organization Unit
price_doc_line_no		Document Line Number
price_ordcustomer_ou		Order Customer Organization Unit
price_billcustomer_ou		Bill Customer Organization Unit
price_shipcustomer_ou		Ship Customer Organization Unit
price_ordcustomer_code	sql_variant	Order Customer Code
price_billcustomer_code		Bill Customer Code
price_shipcustomer_code		Ship Customer Code
price_pricelist_code		Price List Code
price_currency		Currency
price_tran_date	datetime	Transaction Date
price_item_ou	int	Item Organization Unit
price_item_type	sql_variant	Item Type
price_item_code		Item Code
price_item_group		Item Group
price_item_variant		Item Variant
price_uom		Unit Of Measurement
price_qty	bigint	Quantity

Table Name cdi_price_tc_in_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tc_guid	sql_variant	Guid	No	No
tc_login_ou	int	Login Organization Unit
tc_info_level	sql_variant	Information Level
tc_doc_line_no	int	Document Line Number
tc_ref_doc_type	sql_variant	Reference Document Type
tc_item_ou	int	Item Organization Unit
tc_item_type	sql_variant	Item Type
tc_item_code		Item Code
tc_item_group		Item Group
tc_item_variant		Item Variant
tc_uom		Unit Of Measurement
tc_qty	bigint	Quantity
tc_default_tax_flag	sql_variant	Default Tax Flag
tc_default_chrg_flag		Default Charge Flag
tc_tran_date	datetime	Transaction Date
tc_ordcustomer_ou	int	Order Customer Organization Unit
tc_billcustomer_ou		Bill Customer Organization Unit
tc_shipcustomer_ou		Ship Customer Organization Unit
tc_ordcustomer_code	sql_variant	Order Customer Code
tc_billcustomer_code		Bill Customer Code
tc_shipcustomer_code		Ship Customer Code
tc_shipping_point	int	Shipping Point
tc_shipping_wh	sql_variant
tc_delivery_area		Delivery Area
tc_sales_channel		Sales Channel
tc_site_id		Site Id
tc_recv_ou	int	Received Organization Unit
tc_currency	sql_variant	Currency
tc_doc_amount	bigint	Document Amount
tc_op_param1	sql_variant	Optional Parameter 1
tc_op_param2		Optional Parameter 2
tc_op_param3		Optional Parameter 3
tc_op_param4	datetime	Optional Parameter 4

Table Name cdi_ps_updinv_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
langid	int	Language Id
ou		Organization Unit
callingservice	sql_variant	Calling Service
ctxtuser		Context User
ref_doc_type		Reference Document Type
doc_ou	int	Document Organization Unit
doc_number	sql_variant	Document Number
doc_date	datetime	Document Date
packslipou	int	Pack Slip Organization Unit
packslipno	sql_variant	Pack Slip Number
packsliplineno	int	Pack Slip Line Number
item	sql_variant	Item
variant		Variant
tranuom		Transaction Unit Of Measurement
oldqty	bigint	Old Quantity
newqty		New Quantity

Table Name cdi_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 cdi_rpt_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_no		Transaction Number
line_no	int	Line Number
item_code	sql_variant	Item Code
item_desc		Item Description
remarks		Remarks
pack_slip		Pack Slip
uom		Unit Of Measurement
quantity	bigint	Quantity
unit_price		Unit Price
amount		Amount
charges		Charges
tax		Tax
duedate	datetime	Due Date
dueamount	bigint	Due Amount
discountdate	datetime	Discount Date
discountamount	bigint	Discount Amount
penaltypercent		Penalty Percent
place	sql_variant	Place

Table Name cdi_serialno_dtl

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
alloc_line_no		Allocation Line Number
item_serial_no	sql_variant	Item Serial Number
timestamp	int	Time Stamp
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Name cdi_shipping_dtl

Table Comment contains the shipping details for Miscellaneous Invoice

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
timestamp	int	Time Stamp
freight_term	sql_variant	Freight Term
insurance_comp		Insurance Company
ship_mode		Ship Mode
ship_label		Ship Model
trans_doc_no		Transaction Document Number
carrier_code		Carrier Code
carrier_name		Carrier Name
delivery_area		Delivery Area
frt_amount	bigint	Freight Amount
frt_bill_no	sql_variant	Freight Bill Number
remarks		Remarks
shelf_life		Shelf Life
ship_to_address		Ship To Address
ship_time	datetime	Ship Time
ship_status	sql_variant	Ship Status. Values N -No,Y -Yes
tracking_no		Tracking Number
vehicle_no		Vehicle Number
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Name cdi_tcd_dtl

Table Comment Table that contains the TCD info for each documents that has TCD attachments

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
line_no	int	Line Number
item_tcd_code	sql_variant	Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
tcd_version	int	Tax Charge Discount Version
timestamp		Time Stamp	No
item_type	sql_variant	Item Type
tcd_level		Tax Charge Discount Level
tcd_rate	bigint	Tax Charge Discount Rate
taxable_amount		Taxable Amount
tcd_amount		Tax Charge Discount Amount
tcd_currency	sql_variant	Tax Charge Discount Currency
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
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
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 cdi_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		Trn-Bsg-RCN-CDI-R62-3.0 Tax type

Table Name cdi_tcdcal_calcprocess_tmp

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

Table Name cdi_vat_dtl

Table Comment Table contains the VAT details for each document number

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	sql_variant	Transaction Type	Yes	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
vat_line_no	int	Value Added Tax Line Number
timestamp		Time Stamp	No
doc_line_no		Document Line Number
item_type	sql_variant	Item Type
account_code		Account Code
item_tcd_code		Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
vat_category		Value Added Tax Category
vat_class		Value Added Tax Class
tcd_var		Tax Charge Discount Variant
vat_rate	bigint	Value Added Tax Rate
inp_vat_deduct_per		Input Value Added Tax Deduction Per
item_amount		Item Amount
vat_item_charge		Value Added Tax Item Charge
non_vat_item_charge		Other Than Value Added Tax Item Charge
vat_dist_charge		Value Added Tax 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

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 cdi_vat_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
vat_line_no	int	Value Added Tax Line Number
timestamp		Time Stamp
doc_line_no		Document Line Number
item_type	sql_variant	Item Type
account_code		Account Code
item_tcd_code		Item Tax Charge Discount Code
item_tcd_var		Item Tax Charge Discount Variant
item_tcd_desc		Item Tax Charge Discount Description
vat_category		Value Added Tax Category
vat_class		Value Added Tax Class
tcd_var		Tax Charge Discount Variant
vat_rate	bigint	Value Added Tax Rate
inp_vat_deduct_per		Input Value Added Tax Deduct Per
item_amount		Item Amount
vat_item_charge		Value Added Tax Item Charge
non_vat_item_charge		Other Than Value Added Tax Item Charge
vat_dist_charge		Value Added Tax Item 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
guid	sql_variant	Guid

Table Name fin_inv_invsumm_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
tranno		Transaction Number
tranou	int	Transaction Organization Unit
trantype	sql_variant	Transaction Type
trancurr		Transaction Currency
basecurr		Base Currency
itemtcdcode		Item Tax Charge Discount Code
itemtcdvar		Item Tax Charge Discount Variant
itemtype		Item Type
tcdlevel		Tax Charge Discount Level
tcdamount	bigint	Tax Charge Discount Amount
vatamount		Value Added Tax Amount
basetcdamount		Base Tax Charge Discount Amount
basevatamount		Base Value Added Tax Amount
exchrate		Exchange Rate