Customer Service Invoice

Customer Service Invoice

Table Name cbi_CO_StatusUpd_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	No	No
fb	sql_variant	Finance Book
guid		Guid
invoice_no		Invoice Number
ref_doc_no		Reference Document Number
ref_doc_ou	int	Reference Document Organization Unit
bill_to_cust	sql_variant	Bill To Customer
release_no	int	Release Number
Reason_Reprocess	sql_variant	Reason Reprocess


Table Name cbi_hdl_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
ou_id	int	Organization Unit Id
invoice_no	sql_variant	Invoice Number
invoice_date	datetime	Invoice Date
invoice_curr	sql_variant	Invoice Currency
invoice_amt	bigint	Invoice Amount
status	sql_variant	Status
invoice_stage		Invoice Stage
ref_doc_type		Reference Document Type
ref_doc_no		Reference Document Number
bill_to_cust		Bill To Customer
bill_to_cust_name		Bill To Customer Name
fb		Finance Book


Table Name Cbi_invoice_hdr

Table Comment Table that contains about the customer order based invoices transaction number and invoice level breakeup’s for Labour ,Material and Facility charges against customer orders
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	No	No
fb	sql_variant	Finance Book
tran_type		Transaction Type
invoice_no		Invoice Number
invoice_date	datetime	Invoice Date
no_type	sql_variant	Numbering Type
status		Status.Values FSH -Fresh,DFT -Draft,RTD -Returned,AUTH -Authorized,D -Deleted,REV -Reversed,HLD -Held,RPR -Re-Processed
invoice_stage		Invoice Stage
bill_to_cust		Bill To Customer
bill_to_cust_name		Bill To Customer Name
ship_to_cust		Ship To Customer
ship_to_cust_name		Ship To Customer Name
ship_to_id		Ship To Id
auto_adjust		Auto Adjustment
ref_doc_type		Reference Document Type
ref_doc_no		Reference Document Number
ref_doc_ou	int	Reference Document Organization Unit
ref_doc_date	datetime	Reference Document Date
amend_no	int	Amend Number
order_currency	sql_variant	Order Currency
order_applicability		Order Applicability
order_point		Order Point
invoice_proc_level		Invoice Processing Level
invoice_basis		Invoice Basis
order_desc		Order Description
invoice_curr		Invoice Currency
exchange_rate	bigint	Exchange Rate
cross_exchange_rate		Cross Exchange
payterm	sql_variant	Pay Term
receipt_met		Receipt Meta Data
receipt_mode		Receipt Mode
anchordate	datetime	Anchor Date
comments	sql_variant	Comments
draft_flag	int	Draft Flag
Inv_labr_amt	bigint	Invoice Labour Amount
Inv_matl_amt		Invoice Material Amount
Inv_facl_amt		Invoice Facility Amount
Inv_repr_chrg_amt		Invoice Repair Charge Amount
Inv_addl_chrg_amt		Invoice Additional Charge Amount
Inv_misc_chrg_amt		Invoice Miscellaneous Charge Amount
Inv_base_amt		Invoice Base Amount
Inv_tax_amt		Invoice Tax Amount
Inv_charges_amt		Invoice Charges Amount
Inv_disc_amt		Invoice Discount Amount
Inv_tot_invoice_amt		Invoice Total Invoice Amount
Ord_labr_amt		Order Labour Amount
Ord_matl_amt		Order Material Amount
Ord_facl_amt		Order Facility Amount
Ord_repr_chrg_amt		Order Report Charges Amount
Ord_addl_chrg_amt		Order Additional Amount
Ord_misc_chrg_amt		Miscellaneous Charges Amount
Ord_base_amt		Base Amount
Ord_tax_amt		Tax Amount
Ord_charges_amt		Charges Amount
Ord_disc_amt		Discount Amount
Ord_tot_invoice_amt		Total Invoice Amount
Bas_tot_invoice_amt		Base Total Invoice Amount
timestamp	int	Time Stamp
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
aircraft_reg_no	sql_variant	Aircraft Registration Number
aircraft_model		Aircraft Model
manuf_serial_no		Manufactorial Serial Number
primary_work_center		Primary Work Center
guid		Guid
base_curr		Base Currency
cap_non_ded_charge		Other Than Capital Deduction Charges
doc_level_disc	bigint	Document Level Discount
retain_init_distbn	sql_variant	Retain Initial Distribution
rounded_off_amt	bigint	Rounded Off Amount
pre_round_off_amt		Pre-rounded Off Amount
tcd_amt		Tax Charge Discount Amount
average_vat_rate		Average Value Added Tax Rate
vat_amt		Value Added Tax Amount
vat_incl	sql_variant	Value Added Tax Include
vat_incl_amt	bigint	Value Added Tax Include Amount
vat_excl_amt		Value Added Tax Exclude Amount
vat_exchange_rate		Value Added Tax Exchange Rate
vat_charge		Value Added Tax Charges
non_vat_charge		Other Than Value Added Tax Charges
vat_flag	sql_variant	Value Added Tax Flag
bank_code		Bank Code
esr_id		ESR Id
reversal_date	datetime	Reversal Date
reason_code	sql_variant	Reason Code
rev_remarks		Reversal Remarks
remarks		Remarks
reversaldoc_no		Reversal Document Number
payterm_version	int	Pay Term Version
disc_comp_basis	sql_variant	Discount Compute Basis
rev_reason_code		Reversal Reason Code
Forward_cover		Forward Cover
Forward_cov_flag		Forward Cover Flag
Forward_cov_rate	bigint	Forward Cover Rate
tcd_ordlvltx		Tax Charge Discount Order Level Tax
tcd_ordlvlchgs		Tax Charge Discount Order Level Charges
tcd_ordlvldisc		Tax Charge Discount Order Level Discount
tcd_invlvltax		Tax Charge Discount Invoice Level Tax
tcd_invlvlchg		Tax Charge Discount Invoice Level Charges
tcd_invlvldisc		Tax Charge Discount Invoice Level Discount
maint_base	sql_variant	Maintenance Base
order_cat		Order category
Inv_ext_serv_amt		Invoice External Service Amount
Ord_ext_serv_amt		Order External Service Amount


Table Name Cbi_invoice_hdr_val_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit	No	No
fb	sql_variant	Finance Book
tran_type		Transaction Type
invoice_no		Invoice Number
invoice_date	datetime	Invoice Date
no_type	sql_variant	Numbering Type
status		Status
bill_to_cust		Bill To Customer
auto_adjust		Auto Adjustment
ref_doc_type		Reference Document Type
ref_doc_no		Reference Document Number
ref_doc_date		Reference Document Date
amend_no	int	Amend Number
order_currency	sql_variant	Order Currency
invoice_curr		Invoice Currency
exchange_rate	bigint	Exchange Rate
cross_exchange_rate		Cross Exchange Rate
payterm	sql_variant	Pay Term
anchordate	datetime	Anchor Date
Inv_labr_amt	bigint	Invoice Labour Amount
Inv_matl_amt		Invoice Material Amount
Inv_facl_amt		Invoice Facilities Amount
Inv_repr_chrg_amt		Invoice Repair Charges
Inv_addl_chrg_amt		Invoice Additional Charge Amount
Inv_misc_chrg_amt		Invoice Miscellaneous Charges Amount
Inv_base_amt		Invoice Base Amount
Inv_tax_amt		Invoice Tax Amount
Inv_charges_amt		Invoice Charges Amount
Inv_disc_amt		Invoice Discount Amount
Inv_tot_invoice_amt		Total Invoice Amount
Ord_labr_amt		Labour Amount
Ord_matl_amt		Material Amount
Ord_facl_amt		Order Facilities Amount
Ord_repr_chrg_amt		Order Repair Charges Amount
Ord_addl_chrg_amt		Order Additional Charge Amount
Ord_misc_chrg_amt		Order Miscellaneous Charges Amount
Ord_base_amt		Order Base Amount
Ord_tax_amt		Order Tax Amount
Ord_charges_amt		Order Charges Amount
Ord_disc_amt		Order Discount Amount
Ord_tot_invoice_amt		Total Invoice Amount
Bas_tot_invoice_amt		Base Total Invoice Amount
guid	sql_variant	Guid
base_curr		Base Currency
Forward_cover		Forward Cover
Forward_cov_flag		Forward Cover Flag
Forward_cov_rate	bigint	Forward Cover Rate
tcd_ordlvltx		Tax Charge Discount Order Level Tax
tcd_ordlvlchgs		Tax Charge Discount Order Level Charges
tcd_ordlvldisc		Tax Charge Discount Order Level Discount
tcd_invlvltax		Tax Charge Discount Invoice Level Tax
tcd_invlvlchg		Tax Charge Discount Invoice Level Charges
tcd_invlvldisc		Tax Charge Discount Invoice Level Discount
onmat_taxkey	varchar(18)	Trn-Bsg-RCN-CBI-R62-1.0 OnMaterial Taxkey
onmat_taxkeydesc	sql_variant	Trn-Bsg-RCN-CBI-R62-1.0 OnMaterial Taxkey description
onlab_taxkey	varchar(18)	Trn-Bsg-RCN-CBI-R62-1.0 OnLabourTaxkey
onlab_taxkeydesc	sql_variant	Trn-Bsg-RCN-CBI-R62-1.0 OnLabourTaxkey description
ondoc_taxkey	varchar(18)	Trn-Bsg-RCN-CBI-R62-1.0 OnDocumentTaxkey
ondoc_taxkeydesc	sql_variant	Trn-Bsg-RCN-CBI-R62-1.0 OnDocumentTaxkey description


Table Name Cbi_invoice_Object_Dtl

Table Comment Table that contains the info about the primary work centers and part number and serial number of the customer orders that is captured in a invoice.
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	No	No
invoice_no	sql_variant	Invoice Number
invoice_date	datetime	Invoice Date
aircraft_reg_no	sql_variant	Aircraft Registration Number
aircraft_model		Aircraft Model
serial_no	int	Serial Number
primary_work_center	sql_variant	Primary Work Center
line_no	int	Line Number
part_no	sql_variant	Part Number
part_desc		Part Description
part_qty	bigint	Part Quantity
shop_job_type	sql_variant	Shop Job Type


Table Name cbi_invoice_release_dtl

Table Comment Table that contains the release details of the customer order’s
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	No	No
fb	sql_variant	Finance Book
invoice_no		Invoice Number
invoice_date	datetime	Invoice Date
ref_doc_no	sql_variant	Reference Document Number
ref_doc_date	datetime	Reference Document Date
ref_doc_ou	int	Reference Document Organization Unit
release_no		Release Number
release_date	datetime	Release Date
invoice_comment	sql_variant	Invoice Comment


Table Name cbi_invoice_release_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	No	No
fb	sql_variant	Finance Book
guid		Guid
ref_doc_no		Reference Document Number
ref_doc_date	datetime	Reference Document Date
ref_doc_ou	int	Reference Document Organization Unit
bill_to_cust	sql_variant	Bill To Customer
release_no	int	Release Number
release_date	datetime	Release Date
invoice_comment	sql_variant	Invoice Comment


Table Name Cbi_invoice_WU_Dtl

Table Comment Table that contains the info about the workunit’s and Labour amount and facility and material amount breakups for the customers order’s
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	No	No
invoice_no	sql_variant	Invoice Number
invoice_date	datetime	Invoice Date
CO_line_no	int	Customer Order Line Number
work_unit_no	sql_variant	Work Unit Number
work_unit_type		Work Unit Type
Inv_labour_amt	bigint	Invoice Labour Amount
Inv_material_amt		Invoice Material Amount
Inv_facility_amt		Invoice Facility Amount
Inv_repr_chrg_amt		Invoice Repair Charges Amount
Inv_misc_chrg_amt		Invoice Miscellaneous Charges Amount
Ord_labour_amt		Order Labour Amount
Ord_material_amt		Material Amount
Ord_facility_amt		Facility Amount
Ord_repr_chrg_amt		Order Repair Charges Amount
Ord_misc_chrg_amt		Order Miscellaneous Charge Amount
ref_doc_type	sql_variant	Reference Document Type
ref_doc_no		Reference Document Number
invoice_comment		Invoice Comment


Table Name cbi_rel_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
ou_id	int	Organization Unit Id
invoice_no	sql_variant	Invoice Number
invoice_date	datetime	Invoice Date
invoice_curr	sql_variant	Invoice Currency
invoice_amt	bigint	Invoice Amount
status	sql_variant	Status
invoice_stage		Invoice Stage
ref_doc_type		Reference Document Type
ref_doc_no		Reference Document Number
bill_to_cust		Bill To Customer
bill_to_cust_name		Bill To Customer Name
fb		Finance Book


Table Name Cbi_TCD_calc_dtl

Table Comment Maintains the TCD data’s for the invoices
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
Ou_id	int	Organization Unit Id	No	No
Component_id	sql_variant	Component Id
Order_no		Order Number
Invoice_no		Invoice Number
invoice_date	datetime	Invoice Date
taxable_amt	bigint	Taxable Amount
tax_code	sql_variant	Tax Code
variant_code		Variant Code
tax_amt	bigint	Tax Amount
tcd_currency	sql_variant	Tax Charge Discount Currency


Table Name Cbi_TCD_calc_dtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
Order_no	sql_variant	Order Number	No	No
tax_code		Tax Code
variant_code		Variant Code
taxable_amt	bigint	Taxable Amount
tcd_rate		Tax Charge Discount Rate
tax_amt		Tax Amount
tcd_type	sql_variant	Tax Charge Discount Type
guid		Guid


Table Name Cbi_tcd_dtl

Table Comment Maintain the invoice level TCD’s data’s
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
item_tcd_code	sql_variant	Item Tax Charge Discount Code
tcd_on		Tax Charge Discount On
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
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
base_value	bigint	Base Value


Table Name cbi_tcd_dtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	No	No
fb	sql_variant	Finance Book
tran_no		Transaction Number
guid		Guid
tcd_type		Tax Charge Discount Type
tcd_on		Tax Charge Discount On
tcd_hash		Tax Charge Discount Hash
variant		Variant
tcd_desc		Tax Charge Discount Description
taxable_amount	bigint	Taxable Amount
tcd_rate		Tax Charge Discount Rate
tcd_level	sql_variant	Tax Charge Discount Level
tcd_amount	bigint	Tax Charge Discount Amount
tcd_currency	sql_variant	Tax Charge Discount Currency
cost_center		Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
rownum	int	Row Number
base_amount	bigint	Base Amount
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
item_type	sql_variant	Trn-Bsg-RCN-CBI-R62-1.0 Item type


Table Name Cbi_TCD_tax_calc_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_ou	int	Transaction Organization Unit	No	No
tran_no	sql_variant	Transaction Number
Component_id		Component Id
ref_doc_no		Reference Document Number
ref_docou	int	Reference Document Organization Unit
tax_code	sql_variant	Tax Code
variant_code		Variant Code
taxable_amt	bigint	Taxable Amount
tcd_APPLNON	sql_variant	Tax Charge Discount Application On
tax_amt	bigint	Tax Amount
flag	sql_variant	Flag
Cum_eligible_amt	bigint	Cumulative Eligible Amount
Prev_raised_amt		Previously Raised Amount
Adj_Taxable_Amt		Adjustment Taxable Amount
Orig_tax_amt		Originating Tax Amount


Table Name rm_cbi_adjustment_dtl
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	No	No
invoiceno	sql_variant	Invoice Number
customer_code		Customer Code
tot_inv_amt	bigint	Total Invoice Amount
currency	sql_variant	Currency
fb		Finance Book
doc_ou	int	Document Organization Unit
doc_type	sql_variant	Document Type
doc_no		Document Number
doc_date	datetime	Document Date
doc_outstanding_amt	bigint	Document Outstanding Amount
doc_fb	sql_variant	Document Finance Book
created_by		Created By
created_date	datetime	Created Date
modified_by	sql_variant	Modified By
modified_date	datetime	Modified Date


Table Name rm_cbi_adjustment_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
doc_ou	int	Document Organization Unit
doc_type	sql_variant	Document Type
doc_no		Document Number
doc_date	datetime	Document Date
outstanding_amt	bigint	Outstanding Amount
doc_fb	sql_variant	Document Finance Book
exchangerate	bigint	Exchange Rate


Table Name rm_cbi_apportioned_tcd_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
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_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 Name rm_cbi_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
ou_id	int	Organization Unit Id	No	No
bu_id	sql_variant	Business Unit Id
component_name		Component Name
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number
tran_type		Transaction Type
posting_line_no	int	Posting Line Number
line_no		Line Number
company_code	sql_variant	Company Code
fb_id		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
org_vat_base_amt		Originating Value Added Tax Base Amount
para_exchange_rate		Parallel Exchange Rate
para_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_ou	int	Reference Transaction Organization Unit
reftran_no	sql_variant	Reference Transaction Number
reftran_type		Reference Transaction Type
reftran_fbid		Reference Transaction Finance Book Id
cust_code		Customer Code
posting_date	datetime	Posting Date
posting_status	sql_variant	Posting Status
timestamp	int	Time Stamp
uom	sql_variant	Unit Of Measurement
mac_post_flag		Management Account Posting Flag
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
vat_line_no	int	Value Added Tax


Table Name rm_cbi_ar_postings_dtl_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
tran_ou	int	Transaction Organization Unit
tran_no	sql_variant	Transaction Number


Table Name rm_cbi_invoice_del_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
ou_id	int	Organization Unit Id
invoiceno	sql_variant	Invoice Number
status		Status


Table Name rm_cbi_invoice_hdr
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	No	No
fb	sql_variant	Finance Book
tran_type		Transaction Type
invoiceno		Invoice Number
invoicedate	datetime	Invoice Date
no_type	sql_variant	Numbering Type
tran_curr		Transaction Currency
base_curr		Base Currency
base_amount	bigint	Base Amount
cap_non_ded_charge	sql_variant	Other Than Capital Deduction Charges
exchangerate	bigint	Exchange Rate
tot_invoice_amt		Total Invoice Amount
tot_mat_amt		Total Material Amount
tot_res_amt		Total Resource Amount
tot_misc_amt		Total Miscellaneous Amount
doc_level_disc		Document Level Discount
embodi_fee		Embodiment Fee
retain_init_distbn	sql_variant	Retain Initial Distribution
rounded_off_amount	bigint	Rounded Off Amount
pre_round_off_amount		Pre-Rounded Off Amount
repair_order_amt		Repair Order Amount
freight_amt		Freight Amount
tcd_amt		Tax Charge Discount Amount
average_vat_rate		Average Value Added Tax Rate
vat_amt		Value Added Tax Amount
vat_incl	sql_variant	Value Added Tax Include
vat_incl_amount	bigint	Value Added Tax Include Amount
vat_excl_amount		Value Added Tax Exclude Amount
vat_exchange_rate		Value Added Tax Exchange Rate
vat_charge		Value Added Tax Charge
non_vat_charge		Other Than Value Added Tax Charge
payterm	sql_variant	Pay Term
anchordate	datetime	Anchor Date
bill_to_cust	sql_variant	Bill To Customer
bill_to_cust_name		Bill To Customer Name
ship_to_cust		Ship To Customer
ship_to_cust_name		Ship To Customer Name
ship_to_id		Ship To Id
auto_adjust		Auto Adjustment
receipt_met		Receipt Meta Data
receipt_mode		Receipt Mode
orderno		Order Number
orderdate	datetime	Order Date
order_ou	int	Order Organization Unit
order_currency	sql_variant	Order Currency
part_aircraft		Part Aircraft
partserialno		Part Serial Number
status		Status.Values FSH -Fresh,DFT -Draft,RTD -Returned,AUTH -Authorized,D -Deleted,REV -Reversed,HLD -Held,RPR -Re-Processed
tax_amount	bigint	Tax Amount
disc_amount		Discount Amount
vat_flag	sql_variant	Value Added Tax Flag
draft_flag		Draft Flag
bank_code		Bank Code
esr_id		ESR Id
comments		Comments
reversal_date	datetime	Reversal Date
reason_code	sql_variant	Reason Code
rev_remarks		Reversal Remarks
remarks		Remarks
reversaldoc_no		Reversal Document Number
timestamp	int	Time Stamp
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
guid	sql_variant	Guid
payterm_version	int	Pay Term Version
disc_comp_basis	sql_variant	Discount Computation Basis
rev_reason_code		Reversal Reason Code


Table Name rm_cbi_invoice_hdr_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	No	No
fb	sql_variant	Finance Book
tran_type		Transaction Type
invoiceno		Invoice Number
invoicedate	datetime	Invoice Date
no_type	sql_variant	numbering Type
tran_curr		Transaction Currency
base_curr		Base Currency
exchangerate	bigint	Exchange Rate
tot_invoice_amt		Total Invoice Amount
tot_mat_amt		Total Material Amount
tot_res_amt		Total Resource Temporary
tot_misc_amt		Total Miscellaneous Amount
doc_level_disc		Document Level Discount
embodi_fee		Embodiment Fee
repair_order_amt		Repair Order Amount
freight_amt		Freight Amount
tcd_amt		Tax Charge Discount Amount
vat_amt		Value Added Tax Amount
vat_incl	sql_variant	Value Added Tax Include
vat_incl_amount	bigint	Value Added Tax Include Amount
vat_excl_amount		Value Added Tax Exclude Amount
non_vat_charge		Other Than Value Added Tax Charge
payterm	sql_variant	Pay Term
anchordate	datetime	Anchor Date
bill_to_cust	sql_variant	Bill To Customer
bill_to_cust_name		Bill To Customer Name
ship_to_cust		Ship To Customer
ship_to_cust_name		Ship To Customer Name
ship_to_id		Ship To Id
auto_adjust		Auto Adjust
receipt_met		Receipt Meta Data
receipt_mode		Receipt Mode
orderno		Order Number
orderdate	datetime	Order Date
status	sql_variant	Status
vat_flag		Value Added Tax Flag
draft_flag		Draft Flag
comments		Comments
reversal_date	datetime	Reversal Date
reason_code	sql_variant	Reason Code
rev_remarks		Reversal Remarks
remarks		Remarks
reversaldoc_no		Reversal Document Number
timestamp	int	Time Stamp
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
guid	sql_variant	Guid
order_ou	int	Order Organization Unit
order_currency	sql_variant	Order Currency
part_aircraft		Part Aircraft
partserialno		Part Serial Number
bank_code		Bank Code
esr_id		ESR Id
vat_exchange_rate	bigint	Value Added Tax Exchange Rate
pre_round_off_amount		Pre-rounded Off Amount
base_amount		Base Amount
vat_charge		Value Added Tax Charge
retain_init_distbn	sql_variant	Retain Initial Distribution
cap_non_ded_charge		Other Than Capital Deduction Charge
rounded_off_amount	bigint	Rounded Off Amount
average_vat_rate		Average Value Added Tax
payterm_version	int	Pay Term Version
disc_comp_basis	sql_variant	Discount Computation Basis


Table Name rm_cbi_notes_master
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	No	No
invoiceno	sql_variant	Invoice Number
notesfor		Notes For
stdnotesid		Standard Notes Id
stdnotesdesc		Standard Notes Description
notes_desc		Notes Description
status		Status
timestamp	int	Time Stamp
created_by	sql_variant	Created By
created_date	datetime	Created Date
modified_by	sql_variant	Modified By
modified_date	datetime	Modified Date


Table Name rm_cbi_order_dtl
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
invoiceno	sql_variant	Invoice Number	No	No
order_ou	int	Order Organization Unit
tran_type	sql_variant	Transaction Type
status		Status
base_value	bigint	Base Value
line_no	int	Line Number
visible_line_no		Visible Line Number
orderno	sql_variant	Order Number
orderdate	datetime	Order Date
order_curr	sql_variant	Order Currency
tran_curr		Transaction Currency
payterm		Pay Term
bill_to_cust		Bill To Customer
part_type		Part Type
part_code		Part Code
part_desc		Part Description
est_qty	bigint	EST Quantity
act_qty		Actual Quantity
uom	sql_variant	Unit Of Measurement
est_hours	bigint	Estimated Hours
act_hours		Actual Hours
res_rate		Resource Rate
res_code	sql_variant	Resource Code
res_desc		Resource Description
res_type		Resource Type
tcdcode		Tax Charge Discount Code
tcd_variant		Tax Charge Discount Variant
tcdrate	bigint	Tax Charge Discount Rate
taxableamount		Taxable Amount
disc_amount		Discount Amount
line_amount		Line Amount
tcdamount		Tax Charge Discount 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
order_flat_value	bigint	Order Flat Value
order_unit_price		Order Unit Price
order_embodi_fee		Order Embodiment Fee
order_total_value		Order Total Value
order_freight_amt		Order Freight Amount
mat_res_flag	sql_variant	Material Resource Flag
inv_unit_price	bigint	Invoice Unit Price
inv_flat_value		Invoice Flat Price
inv_embodi_fee		Invoice Embodiment Fee
inv_tcd_amt		Invoice Tax Charge Discount Amount
inv_total_value		Invoice Total Value
inv_freight_amt		Invoice Freight Amount
freight_borne_by	sql_variant	Freight Borne By
tcd_compute		Tax Charge Discount Compute
tcd_level		Tax Charge Discount Level
cross_curr_exrate	bigint	Cross Currency Exchange Rate
servsaleaccount	sql_variant	Service Sales Account
timestamp	int	Time Stamp
createdby	sql_variant	Crated By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name rm_cbi_order_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
invoiceno		Invoice Number
order_ou	int	Order Organization Unit
status	sql_variant	Status
line_no	int	Line Number
orderno	sql_variant	Order Number
orderdate	datetime	Order Date
order_curr	sql_variant	Order Currency
tran_curr		Transaction Currency
payterm		Pay Term
bill_to_cust		Bill To Customer
part_type		Part Type
part_code		Part Code
part_desc		Part Description
est_qty	bigint	Estimated Quantity
act_qty		Actual Quantity
uom	sql_variant	Unit Of Measurement
est_hours	bigint	Estimated Hours
act_hours		Actual Hours
res_rate		Resource Rate
res_code	sql_variant	Resource Code
res_desc		Resource Description
res_type		Resource Type
tcdcode		Tax Charge Discount Code
tcd_variant		Tax Charge Discount Variant
tcdrate	bigint	Tax Charge Discount Rate
taxableamount		Taxable Amount
tcdamount		Tax Charge Discount Amount
order_flat_value		Order Flat Value
order_unit_price		Order Unit Price
order_embodi_fee		Order Embodiment Fee
order_total_value		Order Total Value
order_freight_amt		Order Freight Amount
mat_res_flag	sql_variant	Material Resource Flag
inv_unit_price	bigint	Invoice Unit Price
inv_flat_value		Invoice Flat Value
inv_embodi_fee		Invoice Embodiment Fee
inv_tcd_amt		Invoice Tax Charge Discount Amount
inv_total_value		Invoice Total Value
inv_freight_amt		Invoice Freight Amount
freight_borne_by	sql_variant	Freight Borne By
tcd_compute		Tax Charge Discount Compute
tcd_level		Tax Charge Discount Level
cross_curr_exrate	bigint	Cross Currency
servsaleaccount	sql_variant	Service Sale Account
CustSer_guid		Customer Service Guid


Table Name rm_cbi_parameters
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
ou_id	int	Organization Unit Id
bu_id	sql_variant	Business Unit Id
lo_id		Logistics Organization Id
component_id		Component Id
param_group		Parameter Group
param_value		Parameter Value
param_desc		Parameter Description
language_id	int	Language Id
created_by	sql_variant	Created By
created_date	datetime	Created Date
modified_by	sql_variant	Modified By
modified_date	datetime	Modified Date


Table Name rm_cbi_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
ou_id	int	Organization Unit Id	No	No
invoiceno	sql_variant	Invoice Number
tran_type		Transaction Type
invoicedate	datetime	Invoice Date
term_no	sql_variant	Term Number
pt_version_no	int	Payment Version Number
line_no		Line Number
due_amount_type	sql_variant	Due Amount Type
due_date	datetime	Due Date
due_percent	bigint	Due Percentage
due_amount		Due Amount
disc_amount_type	sql_variant	Discount Amount Type
disc_comp_amount	bigint	Discount Computation Amount
disc_comp	sql_variant	Discount Computed
disc_date	datetime	Discount Date
disc_percent	bigint	Discount Percentage
disc_amount		Discount Amount
penalty_percent		Penalty Percentage
base_due_amount		Base Due Amount
base_disc_amount		Base Discount Amount
esr_coding_line	sql_variant	ESR Coding Line
esr_ref_no		ESR Reference Number
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name rm_cbi_payment_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
ou_id	int	Organization Unit Id
tran_type	sql_variant	Transaction Type
invoiceno		Invoice Number
invoicedate	datetime	Invoice Date
term_no	sql_variant	Term Number
pt_version_no	int	Payment Version Number
due_amount_type	sql_variant	Due Amount Type
due_date	datetime	Due Date
due_percent	bigint	Due Percentage
due_amount		Due Amount
disc_amount_type	sql_variant	Discount Amount Type
disc_comp_amount	bigint	Discount Computation Amount
disc_comp	sql_variant	Discount Computation
disc_date	datetime	Discount Date
disc_percent	bigint	Discount Percentage
disc_amount		Discount Amount
penalty_percent		Penalty Percentage
base_due_amount		Base Due Amount
base_disc_amount		Base Discount Amount


Table Name rm_cbi_payterm_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
ou_id	int	Organization Unit
tran_type	sql_variant	Transaction Type
invoiceno		Invoice Number
payterm		Pay Term
term_no		Term Number
pt_version_no	int	Payment Version Number
due_amount_type	sql_variant	Due Amount Type
due_date	datetime	Due Date
due_percent	bigint	Due Percentage
due_amount		Due Amount
disc_amount_type	sql_variant	Discount Amount Type
disc_comp_amount	bigint	Discount Computation Amount
disc_date	datetime	Discount Date
disc_percent	bigint	Discount Percentage
disc_amount		Discount Amount
penalty_percent		Penalty Percentage
base_due_amount		Base Due Amount
base_disc_amount		Base Discount Amount


Table Name rm_cbi_salevat_dtl
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	No	No
invoiceno	sql_variant	Invoice Number
tran_type		Transaction Type
trandate	datetime	Transaction Date
vat_line_no	int	Value Added Tax Line Number
ref_doc_line_no		Reference Document Line Number
part_tcd	sql_variant	Part Tax Charge Discount
item_code		Item Code
variant		Variant
vat_category		Value Added Tax Category
vat_class		Value Added Tax Class
vat_code		Value Added Tax Code
vat_rate	bigint	Value Added Tax Rate
part_amount		Part Amount
vat_part_charge		Value Added Tax Part Type
nonvat_part_char		Other Than Value Added Tax Part Charge
vat_dist_charge		Value Added Tax Distribution Charge
part_level_disc		Part Level Discount
item_level_disc_amount		Item Level Discount Amount
dist_disc		Distribution Discount
vat_tran_amt		Value Added Tax Transaction Amount
drcr_id	sql_variant	Debit Credit Id
vat_acct_type		Value Added Tax Account Type
account_code		Account Code
cost_center		Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
total_corr_vat_amt	bigint	Total Corrected Value Added Tax Amount
total_calc_vat_amt		Total Calculation Value Added Tax Amount
corr_vat_tran_amt		Corrected Value Added Tax Transaction Amount
vat_base_amt		Value Added Tax Base Amount
corr_vat_base_amt		Corrected Value Added Base Amount
item_type	sql_variant	Item Type
item_desc		Item Description
createddate	datetime	Created Date
createdby	sql_variant	Created By
modifieddate	datetime	Modified Date
modifiedby	sql_variant	Modified By


Table Name rm_cbi_salevat_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
ou_id	int	Organization Unit Id
invoiceno	sql_variant	Invoice Number
tran_type		Transaction Type
trandate	datetime	Transaction Date
vat_line_no	int	Value Added Tax Line Number
ref_doc_line_no		Reference Document Line Number
part_tcd	sql_variant	Part Tax Charge Discount
item_code		Item Code
variant		Variant
vat_category		Value Added Tax Category
vat_class		Value Added Tax Class
vat_code		Value Added Tax Code
vat_rate	bigint	Value Added Tax Rate
part_amount		Part Amount
vat_part_charge		Value Added Tax Part Charge
nonvat_part_char		Other Than Value Added Tax Part Charge
vat_dist_charge		Value Added Tax Distribution Charge
part_level_disc		Part Level Discount
dist_disc		Distribution Discount
vat_tran_amt		Value Added Tax Transaction Amount
corr_vat_tran_amt		Corrected Value Added Tax Transaction Amount
vat_base_amt		Value Added Tax Base Amount
corr_vat_base_amt		Corrected Value Added Tax Base Amount
item_desc	sql_variant	Item Description
createddate	datetime	Created Date
createdby	sql_variant	Created By
modifieddate	datetime	Modified Date
modifiedby	sql_variant	Modified By


Table Name rm_cbi_tcd_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
item_tcd_code	sql_variant	Item Tax Charge Discount
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
mat_res_flag	sql_variant	Material Resource 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
line_no	int	Line Number
item_tcd_code	sql_variant	Item Tax Charge Discount
item_tcd_var		Item Tax Charge Discount Variant
tcd_version	int	Tax Charge Discount Version

Table Name rm_cbi_tcd_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
ou_id	int	Organization Unit Id
guid	sql_variant	Guid
invoice_no		Invoice Number
line_no	int	Line Number
line_amount	bigint	Line Amount
base_amount		Base Amount
item_tcd_code	sql_variant	Item Tax Charge Discount Code
item_tcd_desc		Item Tax Charge Discount Description
item_tcd_var		Item Tax Charge Discount Variant
tcd_version	int	Tax Charge Discount Version
timestamp		Time Stamp
tcd_type	sql_variant	Tax Charge Discount 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
cost_center		Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
status		Status
remarks		Remarks
modeflag		Mode Flag
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
mat_res_flag	sql_variant	Material Resource Flag