Data Dictionary -- Customer Service Order

Srl. No.	Table Name	Comment
1	cso_autoerror_met	Customer Service Order Error Details Metadata
2	cso_charge_rel_dtl	Commercial Charge Release details
3	cso_charge_rel_stage_dtl	Commercial Charge Release Stage details
4	cso_chklist_info	Customer Service Order Data Validation check details
5	cso_cogr_map	Customer Service Order CGR Mapping Details
6	cso_cust_order_mst	Customer Service Order Master
7	cso_cust_order_mst_hist	Customer Service Order Master History
8	cso_estimation_req_dtl	Commercial Estimation Requirement details
9	cso_estimation_req_part_dtl	Commercial Part Estimation Requirement details
10	cso_execdoc_hist	Execution Document History maintenance
11	cso_exec_commercial_info	Commercial Service Details
12	cso_fxtprice_rel_dtl	Commercial Fixed Price Release Details
13	cso_hr_holdrel_dtl	Customer Service Order Hold Release Details
14	cso_material_rel_dtl	Commercial Service Material Release Details
15	cso_material_rel_stage_dtl	Commercial Service Material Release Stage Details
16	cso_mo_billevent_info	Customer Service Order Billing Event
17	cso_mo_billevent_info_hist	Customer Service Order Billing Event History
18	cso_mo_custcorrs_dtl	Customer Service Oder Correspondent details
19	cso_mo_custcorrs_dtl_hist	Customer Service Oder Correspondent details History
20	cso_mo_pdd_dtl	Customer Service Order Promised Delivery Date Details
21	cso_od_object_dtl	Customer Service Order Execution Document Mapping
22	cso_od_object_dtl_hist	Customer Service Order Execution Document Mapping History
23	cso_other_docments_rel_dtl	Commercial Service Other Document Release details
24	cso_other_documents_rel_stage	Commercial Service Other Document stage breakup details
25	cso_other_doc_rel_brkup_dtl	Commercial Service Other Documents Breakup details
26	cso_other_doc_rel_stage_dtl	Commercial Service Other Document stage details
27	cso_part_serial_rel_dtl	Part Serial Detail table
28	cso_part_serial_rel_stage_dtl	Commercial Service Part Serial Release Stage Details
29	cso_qty_dtl	To Update the Quantities of given Customer Order
30	cso_rac_add_chrg_dtl	Customer Order additional Charge d
31	cso_resource_rel_dtl	Commercial Service Resource Release Details
32	cso_resource_rel_stage_dtl	Commercial Service Resource Release Stage Details
33	cso_routdoc_map	Customer Service Order - Execution Document mapping details
34	cso_sb_shipbill_dtl	Customer service Order Shipping/Billing Details
35	cso_sb_shipbill_dtl_hist	Customer service Order Shipping/Billing Details History
36	cso_task_rel_dtl	Customer Service order Task Release Details
37	cso_task_rel_stage_dtl	Customer Service order Task Release Stage Details
38	cso_tcd_ordtcd	Customer Service order TCD Details
39	cso_tcd_ordtcd_hist	Customer Service order TCD Details History
40	cso_tsk_cost_dtl	Customer Service Order Task Cost Details
41	cso_val_othdocinfo_dtl	offine line pricing other doc info table
42	cso_val_othdocinfo_dtl_hist	offine line pricing other doc info table history
43	cso_val_sum_info	offine line pricing main table
44	cso_val_sum_info_hist	offine line pricing main table history
45	cso_val_taskinfo_dtl	offine line pricing task info table
46	cso_val_taskinfo_dtl_hist	offine line pricing task info table history
47	cso_we_workexec_dtl	Customer Service Order Work Execution Details
48	cso_we_workexec_dtl_hist	Customer Service Order Work Execution Details History

Table Name :	cso_autoerror_met
Comment :	Customer Service Order Error Details Metadata

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_errorid	fin_errorid	int(4)	Yes	Error id	No
cso_errordesc	fin_notes	varchar(2000)	Yes	Error Description	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	cso_charge_rel_dtl
Comment :	Commercial Charge Release details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
process_id	fin_documentno	varchar(40)	Yes	Process id	No
sub_process_id	fin_seqno	int(4)	Yes	Sub Process id	No
charge_seq_no	fin_seqno	int(4)	Yes	Charge Sequence Number	No
est_remarks	fin_notes	varchar(2000)	Yes	Estimation Remarks	No
warranty_reco	fin_checkflag	int(4)	Yes	Warranty Reco	No
repair_class	fin_repairclassification	varchar(25)	Yes	Repair Classification	No
charge_code	fin_tcdcodes	varchar(25)	Yes	Charge Code	No
variant_code	fin_tcdcodes	varchar(25)	Yes	Variant Code	No
amount	fin_amount	numeric(13)	Yes	amount	No
account_usage	fin_usageid	varchar(20)	Yes	Account Usage	No
currency	fin_currencycode	varchar(5)	Yes	currency	No
pric_basis	fin_enum_cd	varchar(5)	Yes	Pricing Basis	No
coa	fin_designparamcode	varchar(5)	Yes	coa	No
cost_center	fin_maccost	varchar(32)	Yes	Cost Center	No
pricing_disposition	fin_Disposition	varchar(40)	Yes	Pricing Disposition	No
pricing_factor	fin_amount	numeric(13)	Yes	Pricing Factor	No
pricing_desc	fin_description	varchar(100)	Yes	Pricing Description	No
price_list_rev_no	fin_int	int(4)	Yes	Price List Revision Number	No
price_list	fin_documentnumber	varchar(18)	Yes	Price List	No
billable	fin_designparamcode	varchar(5)	Yes	billable	No
cap_flag	fin_designparamcode	varchar(5)	Yes	CAP Flag	No
updated_by	fin_ctxt_user	varchar(30)	Yes	Updated By	No
updated_date	fin_date	datetime(8)	Yes	Updated Date	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance ID	No
custorder_no	fin_documentno	varchar(40)	Yes	Customer Order Number	No
batch_id	fin_guid	varchar(40)	Yes	batch_id	No
proc_lineno	bigint	Bigint(8)	No	proc_lineno	Yes

Table Name :	cso_charge_rel_stage_dtl
Comment :	Commercial Charge Release Stage details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Ouinstance ID	No
process_id	fin_documentno	varchar(40)	No	Process ID	No
sub_process_id	fin_seqno	int(4)	No	Sub Process ID	No
charge_seq_no	fin_seqno	int(4)	No	Charge Sequence Number	No
estimation_remarks	fin_notes	varchar(2000)	Yes	Estimation Remarks	No
warranty_reco	fin_checkflag	int(4)	Yes	warranty_reco	No
repair_class	fin_repairclassification	varchar(25)	Yes	repair_class	No
charge_code	fin_tcdcodes	varchar(25)	Yes	charge_code	No
variant_code	fin_tcdcodes	varchar(25)	Yes	variant_code	No
amount	fin_amount	numeric(13)	Yes	amount	No
account_usage	fin_ccusage	varchar(20)	Yes	account_usage	No
currency	fin_currencycode	varchar(5)	Yes	currency	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	cso_chklist_info
Comment :	Customer Service Order Data Validation check details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_chk_ord_no	fin_documentno	varchar(40)	No	Customer Order Number	Yes
cso_tatflg	fin_flag	varchar(25)	Yes	TAT Tab Flag	No
cso_biflg	fin_flag	varchar(25)	Yes	Billing Tab Flag	No
cso_shflg	fin_flag	varchar(25)	Yes	Shipping Tab Flag	No
cso_weflg	fin_flag	varchar(25)	Yes	Work Execution Tab Flag	No
cso_odflg	fin_flag	varchar(25)	Yes	Order Details Tab Flag	No

Table Name :	cso_cogr_map
Comment :	Customer Service Order CGR Mapping Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_od_ord_no	fin_documentnumber	varchar(18)	No	Customer Order Number	Yes
cso_od_seqno	fin_seqno	int(4)	No	Customer Order Sequence Number	Yes
cso_od_objline_no	fin_lineno	int(4)	No	Object Details Line Number	Yes
cso_od_ou_id	fin_ctxt_ouinstance	int(4)	No	Ou Instance	Yes
cso_od_recddoc_type	fin_refdocutype	varchar(12)	No	Document type	No
cso_od_recddoc_no	fin_refdocno	varchar(40)	No	Document Number	No
cso_od_recd_qty	fin_quantity	numeric(17)	Yes	Received Quantity	No
cso_od_source	fin_designparamcode	varchar(5)	No	Primary Document or Receiving Document	Yes
cso_od_uom	fin_uom	varchar(15)	Yes	UOM	No
cso_od_crdt	fin_date	datetime(8)	Yes	Created Date	No
cso_od_crby	fin_ctxt_user	varchar(30)	Yes	Created By	No
cso_od_moddt	fin_date	datetime(8)	Yes	Modified Date	No
cso_od_modby	fin_ctxt_user	varchar(30)	Yes	Modified By	No

Table Name :	cso_cust_order_mst
Comment :	Customer Service Order Master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_od_ord_no	fin_documentnumber	varchar(18)	No	Customer Order Number	Yes
cso_od_ou_id	fin_ctxt_ouinstance	int(4)	No	Ou instance	Yes
cso_od_cust_no	fin_customer_id	varchar(18)	No	Customer Number	No
cso_od_rev_no	fin_rev_no	int(4)	Yes	Customer Order revision number	No
cso_od_ord_dt	fin_date	datetime(8)	Yes	Customer Order Date	No
cso_od_ord_desc	fin_notes	varchar(2000)	Yes	Customer Order Description	No
cso_od_ord_stage	fin_designparamcode	varchar(5)	Yes	Customer Order stage	No
cso_od_ord_appl	fin_designparamcode	varchar(5)	Yes	Order Applicability	No
cso_od_prt_app	fin_designparamcode	varchar(5)	Yes	Part Applicability	No
cso_od_shop_jobtyp	fin_designparamcode	varchar(5)	Yes	Shop Job Type	No
cso_od_ord_status	fin_designparamcode	varchar(5)	Yes	Customer Order Status	No
cso_od_user_status	fin_quickcodes	varchar(25)	Yes	User status	No
cso_od_main_core_exch	fin_designparamcode	varchar(5)	Yes	Main Core Exchange	No
cso_od_exch_typ	fin_designparamcode	varchar(5)	Yes	Exchange Type	No
cso_od_exch_init_by	fin_designparamcode	varchar(5)	Yes	Exchange Initiated By	No
cso_od_order_mode	fin_designparamcode	varchar(5)	Yes	Order generation Mode	No
cso_od_contper	fin_contactperson	varchar(80)	Yes	cso_od_contper	No
cso_od_cust_po	fin_documentno	varchar(40)	Yes	Customer PO#	No
cso_od_cust_po_dt	fin_date	datetime(8)	Yes	Customer PO date	No
cso_od_intcontper	fin_contactperson	varchar(80)	Yes	Internal Contact Person	No
cso_we_cust_req_dt	fin_date	datetime(8)	Yes	cso_we_cust_req_dt	No
cso_we_rep_prcd	fin_repairprocesscode	varchar(25)	Yes	Repair Process Code	No
cso_we_ord_priority	fin_quickcodes	varchar(25)	Yes	Order Priority	No
cso_we_wrrty_req	fin_checkflag	int(4)	Yes	Warranty Requested	No
cso_we_wrrty_notes	fin_comments	varchar(256)	Yes	Warranty Notes	No
cso_we_exe_fac	fin_designparamcode	varchar(5)	Yes	Execution Facility	No
cso_we_pri_wrk_ctr	fin_workcenter	varchar(80)	Yes	Primary Work Center	No
cso_we_rep_shop	fin_repairshop	varchar(45)	Yes	Repair Shop number	No
cso_we_event_ord_no	fin_documentno	varchar(40)	Yes	cso_we_event_ord_no	No
cso_we_ord_ctgry	fin_category	varchar(15)	Yes	Order Category	No
cso_we_work_enum	fin_notes	varchar(2000)	Yes	Work Enumeration	No
cso_tat_start_dt	fin_date	datetime(8)	Yes	TAT Start Date	No
cso_tat_prom_del_dt	fin_date	datetime(8)	Yes	TAT Promised Delivery Date	No
cso_tat_pen_not	fin_notes	varchar(2000)	Yes	TAT Penalty Notes	No
cso_tat_currency	fin_currencycode	varchar(5)	Yes	TAT Currency	No
cso_tat_inv_appl	fin_designparamcode	varchar(5)	Yes	Invoice Applicable	No
cso_tat_budget_ref	fin_macbudget	varchar(10)	Yes	TAT Budget Refg	No
cso_tat_pri_prt_grp	fin_partgroup	varchar(40)	Yes	Primary Part Group	No
cso_tat_nte_limit_typ	fin_designparamcode	varchar(5)	Yes	NTE Limit Type	No
cso_tat_nte_matpr	fin_amount	numeric(13)	Yes	NTE Material Price	No
cso_tat_labpr	fin_amount	numeric(13)	Yes	TAT Labour Price	No
cso_tat_oth_respr	fin_amount	numeric(13)	Yes	TAT Other Resource Price	No
cso_tat_tot_ntepr	fin_amount	numeric(13)	Yes	TAT Total NTE Price	No
cso_tat_serprlist	fin_documentno	varchar(40)	Yes	Serivce Price List	No
cso_tat_intsplrevno	fin_rev_no	int(4)	Yes	Service Price List Revision number	No
cso_tat_prtprlist	fin_documentno	varchar(40)	Yes	Part Price List	No
cso_tat_intpplrevno	fin_rev_no	int(4)	Yes	Part Price List Revision number	No
cso_tat_tatstatedin	fin_quickcodes	varchar(25)	Yes	TAT Stated In	No
cso_tat_tatdur_plan	fin_days	int(4)	Yes	TAT Duration Planning	No
cso_tat_tatdur_cust	fin_days	int(4)	Yes	TAT Duration Customer	No
cso_tat_endrefdt	fin_designparamcode	varchar(5)	Yes	End Ref.Date	No
cso_tat_strefdt	fin_designparamcode	varchar(5)	Yes	Start Reference Date	No
cso_tat_plenddt	fin_date	datetime(8)	Yes	Planned End Date	No
cso_st_inco_trm	fin_term	varchar(200)	Yes	INCO Terms	No
cso_stcarrier_agency	fin_carriercode	varchar(20)	Yes	Carrier Agency	No
cso_st_pkg_opt	fin_option	varchar(20)	Yes	Packaging Option	No
cso_st_trans_mde	fin_transportmode	varchar(20)	Yes	Shipping Transmittal mode	No
cso_st_frt_billable	fin_designparamcode	varchar(5)	Yes	Freight Billable	No
cso_st_frt_trm	fin_freight_terms	varchar(35)	Yes	Frieght Term	No
cso_st_shp_lbl	fin_shipinglabel	varchar(20)	Yes	Shipping Label	No
cso_st_pkg_notes	fin_comments	varchar(256)	Yes	Packaging Notes	No
cso_od_custcon_per	fin_contactperson	varchar(80)	Yes	Customer Contact Person	No
cso_bt_inv_trans_md	fin_designparamcode	varchar(5)	Yes	Invoice Transmittal Mode	No
cso_bt_inv_gen	fin_designparamcode	varchar(5)	Yes	Invoice Generation	No
cso_bt_rcpt_mthd	fin_method	varchar(30)	Yes	Receipt method	No
cso_bt_rcpt_mde	fin_receiptmode	varchar(25)	Yes	Receipt Mode	No
cso_bt_bank_code	fin_bankcode	varchar(32)	Yes	Bank code	No
cso_bt_pay_term	fin_paytermcode	varchar(15)	Yes	TAT Pay Term	No
cso_bt_fwd_appl	fin_designparamcode	varchar(5)	Yes	Forward Applicable	No
cso_bt_fwd_rate	fin_rate	numeric(13)	Yes	Forward Rate	No
cso_od_num_type	fin_designparamcode	varchar(5)	Yes	Numbering Type	No
cso_od_conf_by	fin_ctxt_user	varchar(30)	Yes	Confirmed By	No
cso_od_conf_dt	fin_date	datetime(8)	Yes	Confirmed Date	No
cso_od_app_by	fin_ctxt_user	varchar(30)	Yes	Approved By	No
cso_od_app_dt	fin_date	datetime(8)	Yes	Approved Date	No
cso_od_crby	fin_ctxt_user	varchar(30)	Yes	Created By	No
cso_od_crdt	fin_date	datetime(8)	Yes	Created Date	No
cso_od_modby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
cso_od_moddt	fin_date	datetime(8)	Yes	Modified Date	No
cso_ap_notes	fin_notes	varchar(2000)	Yes	Notes	No
cso_od_timestamp	fin_timestamp	int(4)	Yes	Timestamp	No
cso_hr_holdflag	fin_designparamcode	varchar(5)	Yes	Hold Release Flag	No
cso_od_cont_unit	fin_maccost	varchar(32)	Yes	Controlling Unit	No
cso_od_station	fin_station	varchar(40)	Yes	Station	No
cso_tat_anal_code	fin_analysiscode	varchar(5)	Yes	TAT Analysis Code	No
cso_tat_rev_com	fin_comments	varchar(256)	Yes	TAT Revision comments	No
cso_we_wrrty_res	fin_quickcodes	varchar(25)	Yes	Warranty Resolution	No
Cso_Exch_Part_Ident	fin_quickcodes	varchar(25)	Yes	Exchange Part Identification	No
Cso_Exchange_Reason	fin_quickcodes	varchar(25)	Yes	Reason for exchange	No
Cso_Core_Peg_Mapping	fin_quickcodes	varchar(25)	Yes	Core Pre mapping	No
cso_tat_plandenddt	fin_date	datetime(8)	Yes	TAT Planned End Date	No
cso_Tat_EndDate	fin_date	datetime(8)	Yes	TAT End Date	No
cso_Tat_AdjConReqDt	fin_date	datetime(8)	Yes	Adjusted Contract Req date	No
cso_Tat_OrgConReqDt	fin_date	datetime(8)	Yes	Orginal Contract Requested Date	No
cso_od_mul_oper	fin_airlineoperatorcode	Varchar(30)	Yes	operator number	No
CSO_TAT_DurAdjcom	fin_notes	varchar(2000)	Yes	Adjustment Duration Comments	No
CSO_TAT_adjcusdur	fin_quantity	numeric(17)	Yes	Adjustment Duration	No
CSO_TAT_allqtdur	fin_quantity	numeric(17)	Yes	Allowed Quote Duration	No

Table Name :	cso_cust_order_mst_hist
Comment :	Customer Service Order Master History

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_od_ord_no	fin_documentnumber	varchar(18)	No	Customer Order Number	Yes
cso_od_ou_id	fin_ctxt_ouinstance	int(4)	No	Ou instance	Yes
cso_od_cust_no	fin_customer_id	varchar(18)	No	Customer Number	No
cso_od_rev_no	fin_rev_no	int(4)	No	Customer Order revision number	Yes
cso_od_ord_dt	fin_date	datetime(8)	Yes	Customer Order Date	No
cso_od_ord_desc	fin_notes	varchar(2000)	Yes	Customer Order Description	No
cso_od_ord_stage	fin_designparamcode	varchar(5)	Yes	Customer Order stage	No
cso_od_ord_appl	fin_designparamcode	varchar(5)	Yes	Order Applicability	No
cso_od_prt_app	fin_designparamcode	varchar(5)	Yes	Part Applicability	No
cso_od_shop_jobtyp	fin_designparamcode	varchar(5)	Yes	Shop Job Type	No
cso_od_ord_status	fin_designparamcode	varchar(5)	Yes	Customer Order Status	No
cso_od_user_status	fin_quickcodes	varchar(25)	Yes	User status	No
cso_od_main_core_exch	fin_designparamcode	varchar(5)	Yes	Main Core Exchange	No
cso_od_exch_typ	fin_designparamcode	varchar(5)	Yes	Exchange Type	No
cso_od_exch_init_by	fin_designparamcode	varchar(5)	Yes	Exchange Initiated By	No
cso_od_order_mode	fin_designparamcode	varchar(5)	Yes	Order generation Mode	No
cso_od_contper	fin_contactperson	varchar(80)	Yes	cso_od_contper	No
cso_od_cust_po	fin_documentno	varchar(40)	Yes	Customer PO#	No
cso_od_cust_po_dt	fin_date	datetime(8)	Yes	Customer PO date	No
cso_od_intcontper	fin_contactperson	varchar(80)	Yes	Internal Contact Person	No
cso_we_cust_req_dt	fin_date	datetime(8)	Yes	cso_we_cust_req_dt	No
cso_we_rep_prcd	fin_repairprocesscode	varchar(25)	Yes	Repair Process Code	No
cso_we_ord_priority	fin_quickcodes	varchar(25)	Yes	Order Priority	No
cso_we_wrrty_req	fin_checkflag	int(4)	Yes	Warranty Requested	No
cso_we_wrrty_notes	fin_comments	varchar(256)	Yes	Warranty Notes	No
cso_we_exe_fac	fin_designparamcode	varchar(5)	Yes	Execution Facility	No
cso_we_pri_wrk_ctr	fin_workcenter	varchar(80)	Yes	Primary Work Center	No
cso_we_rep_shop	fin_repairshop	varchar(45)	Yes	Repair Shop number	No
cso_we_event_ord_no	fin_documentno	varchar(40)	Yes	cso_we_event_ord_no	No
cso_we_ord_ctgry	fin_category	varchar(15)	Yes	Order Category	No
cso_we_work_enum	fin_notes	varchar(2000)	Yes	Work Enumeration	No
cso_tat_start_dt	fin_date	datetime(8)	Yes	TAT Start Date	No
cso_tat_prom_del_dt	fin_date	datetime(8)	Yes	TAT Promised Delivery Date	No
cso_tat_pen_not	fin_notes	varchar(2000)	Yes	TAT Penalty Notes	No
cso_tat_currency	fin_currencycode	varchar(5)	Yes	TAT Currency	No
cso_tat_inv_appl	fin_designparamcode	varchar(5)	Yes	Invoice Applicable	No
cso_tat_budget_ref	fin_macbudget	varchar(10)	Yes	TAT Budget Refg	No
cso_tat_pri_prt_grp	fin_partgroup	varchar(40)	Yes	Primary Part Group	No
cso_tat_nte_limit_typ	fin_designparamcode	varchar(5)	Yes	NTE Limit Type	No
cso_tat_nte_matpr	fin_amount	numeric(13)	Yes	NTE Material Price	No
cso_tat_labpr	fin_amount	numeric(13)	Yes	TAT Labour Price	No
cso_tat_oth_respr	fin_amount	numeric(13)	Yes	TAT Other Resource Price	No
cso_tat_tot_ntepr	fin_amount	numeric(13)	Yes	TAT Total NTE Price	No
cso_tat_serprlist	fin_documentno	varchar(40)	Yes	Serivce Price List	No
cso_tat_intsplrevno	fin_rev_no	int(4)	Yes	Serivce Price List Revision number	No
cso_tat_prtprlist	fin_documentno	varchar(40)	Yes	Part Price List	No
cso_tat_intpplrevno	fin_rev_no	int(4)	Yes	Part Price List Revision number	No
cso_tat_tatstatedin	fin_quickcodes	varchar(25)	Yes	TAT Stated In	No
cso_tat_tatdur_plan	fin_days	int(4)	Yes	TAT Duration Planning	No
cso_tat_tatdur_cust	fin_days	int(4)	Yes	TAT Duration Customer	No
cso_tat_endrefdt	fin_designparamcode	varchar(5)	Yes	End Ref.Date	No
cso_tat_strefdt	fin_designparamcode	varchar(5)	Yes	Start Reference Date	No
cso_tat_plenddt	fin_date	datetime(8)	Yes	Planned End Date	No
cso_st_inco_trm	fin_term	varchar(200)	Yes	INCO Terms	No
cso_stcarrier_agency	fin_carriercode	varchar(20)	Yes	Carrier Agency	No
cso_st_pkg_opt	fin_option	varchar(20)	Yes	Packaging Option	No
cso_st_trans_mde	fin_transportmode	varchar(20)	Yes	Shipping Transmittal mode	No
cso_st_frt_billable	fin_designparamcode	varchar(5)	Yes	Freight Billable	No
cso_st_frt_trm	fin_freight_terms	varchar(35)	Yes	Frieght Term	No
cso_st_shp_lbl	fin_shipinglabel	varchar(20)	Yes	Shipping Label	No
cso_st_pkg_notes	fin_comments	varchar(256)	Yes	Packaging Notes	No
cso_od_custcon_per	fin_contactperson	varchar(80)	Yes	Customer Contact Person	No
cso_bt_inv_trans_md	fin_designparamcode	varchar(5)	Yes	Invoice Transmittal Mode	No
cso_bt_inv_gen	fin_designparamcode	varchar(5)	Yes	Invoice Generation	No
cso_bt_rcpt_mthd	fin_method	varchar(30)	Yes	Receipt method	No
cso_bt_rcpt_mde	fin_receiptmode	varchar(25)	Yes	Receipt Mode	No
cso_bt_bank_code	fin_bankcode	varchar(32)	Yes	Bank code	No
cso_bt_pay_term	fin_paytermcode	varchar(15)	Yes	TAT Pay Term	No
cso_bt_fwd_appl	fin_designparamcode	varchar(5)	Yes	Forward Applicable	No
cso_bt_fwd_rate	fin_rate	numeric(13)	Yes	Forward Rate	No
cso_od_num_type	fin_designparamcode	varchar(5)	Yes	Numbering Type	No
cso_od_conf_by	fin_ctxt_user	varchar(30)	Yes	Confirmed By	No
cso_od_conf_dt	fin_date	datetime(8)	Yes	Confirmed Date	No
cso_od_app_by	fin_ctxt_user	varchar(30)	Yes	Approved By	No
cso_od_app_dt	fin_date	datetime(8)	Yes	Approved Date	No
cso_od_crby	fin_ctxt_user	varchar(30)	Yes	Created By	No
cso_od_crdt	fin_date	datetime(8)	Yes	Created Date	No
cso_od_modby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
cso_od_moddt	fin_date	datetime(8)	Yes	Modified Date	No
cso_ap_notes	fin_notes	varchar(2000)	Yes	Notes	No
cso_od_timestamp	fin_timestamp	int(4)	Yes	Timestamp	No
cso_hr_holdflag	fin_designparamcode	varchar(5)	Yes	Hold Release Flag	No
cso_od_cont_unit	fin_maccost	varchar(32)	Yes	Controlling Unit	No
cso_od_station	fin_station	varchar(40)	Yes	Station	No
cso_tat_anal_code	fin_analysiscode	varchar(5)	Yes	TAT Analysis Code	No
cso_tat_rev_com	fin_comments	varchar(256)	Yes	TAT Revision comments	No
Cso_Exch_Part_Ident	fin_quickcodes	varchar(25)	Yes	Exchange Part Identification	No
Cso_Exchange_Reason	fin_quickcodes	varchar(25)	Yes	Reason for exchange	No
Cso_Core_Peg_Mapping	fin_quickcodes	varchar(25)	Yes	Core Pre mapping	No
cso_od_mul_oper	fin_airlineoperatorcode	Varchar(30)	Yes	fin_airlineoperatorcode	No
CSO_TAT_DurAdjcom	fin_notes	varchar(2000)	Yes	fin_notes	No
CSO_TAT_adjcusdur	fin_quantity	numeric(17)	Yes	fin_quantity	No
CSO_TAT_allqtdur	fin_quantity	numeric(17)	Yes	fin_quantity_	No

Table Name :	cso_estimation_req_dtl
Comment :	Commercial Estimation Requirement details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
est_inst_id	fin_tasktrackid	bigint(8)	No	Estimation Instance Id	No
exec_comm_id	fin_documentno	varchar(40)	No	Execution Commercial Id	No
ou_id	fin_ctxt_ouinstance	int(4)	No	OUInstance	No
timestamp	_int_0	int(4)	Yes	Time Stamp	No
est_type	fin_designparamcode	varchar(5)	Yes	Estimation Type	No
est_context	fin_ctxt_service	varchar(32)	Yes	Estimation context	No
ref_doc_no	fin_documentno	varchar(40)	Yes	Reference Document No	No
ref_doc_rev_no	fin_rev_no	int(4)	Yes	Reference Document Revision No	No
est_req_material	fin_checkflag	int(4)	Yes	Estimation Required Material	No
est_req_labour	fin_checkflag	int(4)	Yes	Estimation Required Labour	No
est_req_others	fin_checkflag	int(4)	Yes	Estimation Required Others	No
est_req_task	fin_checkflag	int(4)	Yes	Estimation Required Task	No
est_req_sp_parts	fin_checkflag	int(4)	Yes	Estimation Required Sp Parts	No
est_required	fin_checkflag	int(4)	Yes	Estimation Required	No
est_purpose	fin_comments	varchar(256)	Yes	Estimation Purpose	No
est_release_required	fin_checkflag	int(4)	Yes	Estimation Release Required	No
exec_release_id	fin_documentno	varchar(40)	Yes	Execution Release Id	No
task_no	fin_taskno	varchar(40)	Yes	Task No	No
task_track_id	fin_tasktrackid	bigint(8)	Yes	Task Track Id	No
ref_doc_type	fin_type	varchar(25)	Yes	Reference Document Type	No
holdcode	fin_quickcodes	varchar(25)	Yes	Hold Code	No
est_op_element	fin_designparamcode	varchar(5)	Yes	Estimation Operational element	No
est_op_value	fin_values	numeric(17)	Yes	Estimation Operational Value	No
hold_cmnts	fin_comments	varchar(256)	Yes	Hold Comments	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	cso_estimation_req_part_dtl
Comment :	Commercial Part Estimation Requirement details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
est_inst_id	fin_tasktrackid	bigint(8)	No	Estimation Instance Id	No
task_track_id	fin_tasktrackid	bigint(8)	No	Task Track ID	No
part_no	fin_partno	varchar(40)	No	Part Number	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Ou Instance	No
est_type	fin_designparamcode	varchar(5)	Yes	Estimation Type	No
est_context	fin_ctxt_service	varchar(32)	Yes	Estimation Context	No
est_purpose	fin_comments	varchar(256)	Yes	Estimation Purpose	No
mfr_no	fin_vendorcode	varchar(45)	Yes	Manufacture Number	No
mfr_part_no	fin_partno	varchar(40)	Yes	Manufacture Part Number	No
hold_code	fin_quickcodes	varchar(25)	Yes	Hold Code	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	cso_execdoc_hist
Comment :	Execution Document History maintenance

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_od_ord_no	fin_documentnumber	varchar(18)	No	Null	Yes
cso_od_seqno	fin_seqno	int(4)	Yes	Null	No
cso_od_recddoc_type	fin_refdocutype	varchar(12)	Yes	Null	No
cso_od_recddoc_no	fin_refdocno	varchar(40)	No	Null	Yes
cso_od_source	fin_designparamcode	varchar(5)	No	Null	Yes
cso_od_crdt	fin_date	datetime(8)	Yes	Null	No
cso_od_crby	fin_ctxt_user	varchar(30)	Yes	Null	No
cso_od_moddt	fin_date	datetime(8)	Yes	Null	No
cso_od_modby	fin_ctxt_user	varchar(30)	Yes	Null	No
cso_od_objline_no	fin_lineno	int(4)	No	Null	Yes

Table Name :	cso_exec_commercial_info
Comment :	Commercial Service Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Ou Instance	No
exec_comm_id	fin_documentno	varchar(40)	No	Execution Commercial Id	No
timestamp	_int_0	int(4)	Yes	Time Stamp	No
context	fin_ctxt_service	varchar(32)	Yes	Context	No
estimation_source	fin_quickcodes	varchar(25)	Yes	Estimation Source	No
pricing_cust_order_no	fin_documentno	varchar(40)	Yes	Pricing Customer Order Number	No
date	fin_date	datetime(8)	Yes	Date	No
task_flag	fin_checkflag	int(4)	Yes	Task Flag	No
document_type	fin_quickcodes	varchar(25)	Yes	Document Type	No
parent_work_order_no	fin_documentno	varchar(40)	Yes	Parent Work Order Number	No
document_no	fin_documentno	varchar(40)	Yes	Document Number	No
task_track_id	fin_tasktrackid	bigint(8)	Yes	Task Track Id	No
wbs_code	fin_quickcodes	varchar(25)	Yes	WBS Code	No
task_no	fin_taskno	varchar(40)	Yes	Task Number	No
task_seqno	fin_seqno	int(4)	Yes	Task Sequence Number	No
wbs_qutinv_level	fin_taskno	varchar(40)	Yes	WBS Quote or invoice flag Level	No
wbs_level	fin_quickcodes	varchar(25)	Yes	WBS Level	No
parent_task	fin_taskno	varchar(40)	Yes	Parent Task	No
root_task	fin_taskno	varchar(40)	Yes	Root Task	No
contract_no	fin_documentno	varchar(40)	Yes	Contract Number	No
contract_rev_no	fin_rev_no	int(4)	Yes	Contract Revision Number	No
applicability	fin_quickcodes	varchar(25)	Yes	Applicability	No
effectivity_code	fin_effectivitycode	varchar(40)	Yes	Effectivity Code	No
effectivity_line_no	fin_lineno	int(4)	Yes	Effectivity Line Number	No
work_scope_code	fin_quickcodes	varchar(25)	Yes	WorkScope Code	No
work_scope_line_no	fin_lineno	int(4)	Yes	WorkScope Code Line Number	No
material_pb	fin_quickcodes	varchar(25)	Yes	Material Pricing Basis	No
labour_pb	fin_quickcodes	varchar(25)	Yes	Labour Pricing Basis	No
other_pb	fin_quickcodes	varchar(25)	Yes	other Pricing Basis	No
task_pb	fin_quickcodes	varchar(25)	Yes	task Pricing Basis	No
taskpb_usage	fin_checkflag	int(4)	Yes	task Pricing Basis usage	No
taskpb_tm	fin_checkflag	int(4)	Yes	task Pricing Basis T & M	No
taskpb_fp	fin_checkflag	int(4)	Yes	task Pricing Basis Fixed Price	No
task_billable	fin_checkflag	int(4)	Yes	Task Billable	No
warranty_applicable	fin_checkflag	int(4)	Yes	Warranty Applicable	No
mt_warrantycoverage	fin_checkflag	int(4)	Yes	Material warranty coverage	No
lb_warrantycoverage	fin_checkflag	int(4)	Yes	Labour warranty coverage	No
ot_warrantycoverage	fin_checkflag	int(4)	Yes	Others warranty coverage	No
estimation_required	fin_checkflag	int(4)	Yes	Estimation Required	No
covered_fp_parent	fin_checkflag	int(4)	Yes	Covered Fixed Price parent	No
covered_task_no	fin_taskno	varchar(40)	Yes	Covered task Number	No
quotable_task_no	fin_checkflag	int(4)	Yes	Quotable task Number	No
cust_order_no	fin_documentno	varchar(40)	Yes	Customer order Number	No
cust_order_rev_no	fin_rev_no	int(4)	Yes	Customer order Revision Number	No
incl_excl_flag	fin_checkflag	int(4)	Yes	Inclusion Exclusion flag	No
inclusion_code	fin_effectivitycode	varchar(40)	Yes	Inclusion Code	No
exclusion_code	fin_effectivitycode	varchar(40)	Yes	Exclusion Code	No
inclusion_line_no	fin_lineno	int(4)	Yes	Inclusion Line Number	No
exclusion_line_no	fin_lineno	int(4)	Yes	Exclusion Line Number	No
material_pb_excl	fin_quickcodes	varchar(25)	Yes	Material Pricing Basis Excl	No
labour_pb_excl	fin_quickcodes	varchar(25)	Yes	Labour Pricing Basis Excl	No
others_pb_excl	fin_quickcodes	varchar(25)	Yes	Others Pricing Basis Excl	No
coverage	fin_checkflag	int(4)	Yes	Coverage	No
coverage_ttrackid	fin_tasktrackid	bigint(8)	Yes	Coverage Trackid	No
fixed_price_for	fin_quickcodes	varchar(25)	Yes	Fixed price for	No
priced_task_no	fin_taskno	varchar(40)	Yes	Priced task Number	No
part_no	fin_partno	varchar(40)	Yes	Part Number	No
part_serial_no	fin_partserialnumber	varchar(40)	Yes	Part serial Number	No
mfr_part_no	fin_partno	varchar(40)	Yes	Manufacture part Number	No
mfr_no	fin_vendorcode	varchar(45)	Yes	Manufacture Number	No
lot_no	fin_lotno	varchar(18)	Yes	Lot Number	No
mfr_lot_no	fin_lotno	varchar(18)	Yes	Manufacture lot Number	No
repair_classification	fin_repairclassification	varchar(25)	Yes	Repair classification	No
aircraft_reg_no	fin_acregno	varchar(30)	Yes	Aircraft Registation Number	No
document_line_no	fin_lineno	int(4)	Yes	Document line Number	No
cust_no	fin_customer_id	varchar(18)	Yes	Customer Number	No
eng_document_cost	fin_cost	numeric(13)	Yes	Engineering document cost	No
eng_document_date	fin_date	datetime(8)	Yes	Engineering document date	No
execution_phase	fin_quickcodes	varchar(25)	Yes	Execution phase	No
execution_category	fin_quickcodes	varchar(25)	Yes	Execution category	No
task_type	fin_tasktype	varchar(25)	Yes	Task type	No
est_req_processed	fin_checkflag	int(4)	Yes	Estimation Required Processed	No
curr_material_pb	fin_quickcodes	varchar(25)	Yes	Current Material Pricing Basis	No
curr_resource_pb	fin_quickcodes	varchar(25)	Yes	Current Resource Pricing Basis	No
curr_others_pb	fin_quickcodes	varchar(25)	Yes	Current Others Pricing Basis	No
curr_task_pb	fin_quickcodes	varchar(25)	Yes	Current Task Pricing Basis	No
task_release_status	fin_status	varchar(25)	Yes	Task Release Status	No
tsk_pb_excl	fin_quickcodes	varchar(25)	Yes	Task Pricing Basis Exclusion	No
coa_material	fin_checkflag	int(4)	Yes	Cost Over and Above material	No
coa_resource	fin_checkflag	int(4)	Yes	Cost Over and Above resource	No
coa_others	fin_checkflag	int(4)	Yes	Cost Over and Above others	No
coa_task	fin_checkflag	int(4)	Yes	Cost Over and Above task	No
coa_direct	fin_checkflag	int(4)	Yes	Cost Over and Above direct	No
tsk_obj_pb	fin_enum_cd	varchar(5)	Yes	Task object Pricing Basis	No
tsk_obj_fx_dfn_for	fin_enum_cd	varchar(5)	Yes	Task object fixed definition for	No
createddate	fin_date	datetime(8)	Yes	Created Date	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
tsk_exec_cnt_rev_no	fin_rev_no	int(4)	Yes	Task exec cnt rev Number	No
tsk_category	fin_tasktype	varchar(25)	Yes	Task category	No
inc_excl_ref	fin_quickcodes	varchar(25)	Yes	Inclusion Exclusion reference	No
exch_reason_cd	fin_quickcodes	varchar(25)	Yes	Exchange Reason Code	No
exch_type	fin_designparamcode	varchar(5)	Yes	Exchange Type	No
initated_as	fin_designparamcode	varchar(5)	Yes	Initated As	No
exch_entity	fin_desc40	varchar(40)	Yes	Exchange Entity	No
exch_cat	fin_designparamcode	varchar(5)	Yes	Exchange Category	No
exch_chargabl	fin_quickcodes	varchar(25)	Yes	Exchange chargable	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION KEY	Yes
quotable	fin_checkflag	int(4)	Yes	quotable	No
work_center	fin_workcenter	varchar(80)	Yes	Workcenter	No
repairprocess_code	fin_repairprocesscode	varchar(25)	Yes	repair process code	No
ref_work_center	fin_workcenter	varchar(80)	Yes	Reference Work center	No
tsk_discrepancy_type	fin_designparamcode	varchar(5)	Yes	Discrepency type	No
tsk_discrepancy_category	fin_quickcodes	varchar(25)	Yes	discrepency Category	No
tsk_custorder_efft_code	fin_effectivitycode	varchar(40)	Yes	Cust. Order effectivity code	No
tsk_custorder_efft_lin_no	fin_lineno	int(4)	Yes	Cust. Order effectivity line no	No
tsk_discrepancy_Rep_class	fin_repairclassification	varchar(25)	Yes	Discrepency Repair classification	No
tsk_disctsk_flag	fin_flag	varchar(25)	Yes	discrepancy task Flag	No
tsk_parent_tsk_trackid	fin_tasktrackid	bigint(8)	Yes	Parent task track id	No
tsk_root_tsk_trackid	fin_tasktrackid	bigint(8)	Yes	Root task track id	No
tsk_status	fin_status	varchar(25)	Yes	Task status	No
tsk_active_flag	fin_flag	varchar(25)	Yes	Task active flag	No
tsk_ws_notes	fin_notes	varchar(2000)	Yes	Task Work scope notes	No
tsk_pricingtsk_trackid	fin_tasktrackid	bigint(8)	Yes	Pricing task track id	No
incl_excl_notes	fin_notes	varchar(2000)	Yes	Inclusion exclusion notes	No
tsk_parent_wo_type	fin_types	varchar(30)	Yes	Parent Work order Type	No
tsk_hierarchy_id	hierarchyid	varchar(892)	Yes	Task Hierarchy id	No
est_req_flag	fin_int	int(4)	Yes	Estimated required flag	No

Table Name :	cso_fxtprice_rel_dtl
Comment :	Commercial Fixed Price Release Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
process_id	fin_lineno	int(4)	Yes	process_id	No
sub_process_id	fin_lineno	int(4)	Yes	sub_process_id	No
custorder_no	fin_documentno	varchar(40)	Yes	custorder_no	No
pricing_date	fin_date	datetime(8)	Yes	pricing_date	No
custorder_curr	fin_currencycode	varchar(5)	Yes	custorder_curr	No
task_no	fin_taskno	varchar(40)	Yes	task_no	No
part_no	fin_partno	varchar(40)	Yes	part_no	No
cnt_no	fin_documentno	varchar(40)	Yes	cnt_no	No
cnt_currency	fin_currencycode	varchar(5)	Yes	cnt_currency	No
eff_ref	fin_reference	varchar(18)	Yes	eff_ref	No
eff_refcode	fin_effectivitycode	varchar(40)	Yes	eff_refcode	No
cont_lineno	fin_lineno	int(4)	Yes	cont_lineno	No
wbs_code	fin_quickcodes	varchar(25)	Yes	wbs_code	No
mfr_partno	fin_partno	varchar(40)	Yes	mfr_partno	No
mfr_no	fin_vendorcode	varchar(45)	Yes	mfr_no	No
covers_alt	fin_enum_cd	varchar(5)	Yes	covers_alt	No
mat_price	fin_price	numeric(13)	Yes	mat_price	No
lab_price	fin_price	numeric(13)	Yes	lab_price	No
oth_resprice	fin_price	numeric(13)	Yes	oth_resprice	No
tot_fixprice	fin_price	numeric(13)	Yes	tot_fixprice	No
pricing_notes	fin_notes	varchar(2000)	Yes	pricing_notes	No
pricing_disposition	fin_notes	varchar(2000)	Yes	pricing_disposition	No
fixprice_defnfor	fin_enum	varchar(40)	Yes	fixprice_defnfor	No
erate_cnt_co_curr	fin_exchangerate	numeric(9)	Yes	erate_cnt_co_curr	No
mat_price_cocurr	fin_price	numeric(13)	Yes	mat_price_cocurr	No
lab_price_cocurr	fin_price	numeric(13)	Yes	lab_price_cocurr	No
oth_resprice_cocurr	fin_price	numeric(13)	Yes	oth_resprice_cocurr	No
tot_fixprice_cocurr	fin_price	numeric(13)	Yes	tot_fixprice_cocurr	No
ou_id	fin_effectivitycode	varchar(40)	Yes	ou_id	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	cso_hr_holdrel_dtl
Comment :	Customer Service Order Hold Release Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_hr_ord_no	fin_documentnumber	varchar(18)	No	Customer Order Number	Yes
cso_hr_line_no	fin_lineno	int(4)	No	Hold Release Line Number	Yes
cso_hr_holdcode	fin_quickcodes	varchar(25)	No	Hold Code	Yes
cso_hr_ou_id	fin_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
cso_hr_hldreason	fin_comments	varchar(256)	Yes	Hold Reason	No
cso_hr_reldt	fin_datetime	datetime(8)	Yes	Release Date	No
cso_hr_relreason	fin_comments	varchar(256)	Yes	Release Reason	No
cso_hr_hlddt	fin_datetime	datetime(8)	Yes	Hold Date	No
cso_hr_heldby	fin_ctxt_user	varchar(30)	Yes	Held By	No
cso_hr_relby	fin_ctxt_user	varchar(30)	Yes	Released By	No
cso_hr_relresp	fin_quickcodes	varchar(25)	Yes	Release Responsibility	No
cso_hr_approval_no	fin_documentno	varchar(40)	Yes	cso_hr_approval_no	No
cso_hr_approval_dt	fin_date	datetime(8)	Yes	cso_hr_approval_dt	No
cso_hr_intiatedby	fin_quickcodes	varchar(25)	Yes	Initiated By	No
cso_hr_causedby	fin_quickcodes	varchar(25)	Yes	Hold/Release Caused By	No
cso_hr_holdlevel	fin_quickcodes	varchar(25)	Yes	Hold Level	No
cso_hr_hold_instid	fin_tasktrackid	bigint(8)	No	Hold Instance Id	Yes
cso_hr_source	fin_quickcodes	varchar(25)	Yes	Hold Source	No
cso_hr_ref_docno	fin_documentno	varchar(40)	Yes	Document Number	No
cso_hr_ref_doctype	fin_doctype	varchar(40)	Yes	Null	No
cso_hr_taskno	fin_documentno	varchar(40)	Yes	Task number	No
cso_hr_taskseqno	fin_seqno	int(4)	Yes	Task Sequence Number	No
cso_hr_holddesc	fin_remarks	varchar(100)	Yes	Hold Description	No
cso_hr_tasktrackid	fin_tasktrackid	bigint(8)	Yes	Task Track Id	No
cso_hr_trigdoc_no	fin_documentno	varchar(40)	Yes	Triggering Document Number	No
cso_hr_trigdoc_type	fin_doctype	varchar(40)	Yes	Triggering Document Type	No
cso_hr_trigdoc_lineno	fin_lineno	int(4)	Yes	Triggering Document Line no	No
cso_hr_hold_type	fin_designparamcode	varchar(5)	Yes	Hold Type	No
cso_hr_exec_docno	fin_documentno	varchar(40)	Yes	Execution Document Number	No
cso_hr_exec_doctype	fin_doctype	varchar(40)	Yes	Execution Document Type	No
CSO_HR_Hldclassi	fin_flag50	varchar(50)	Yes	CSO_HR_Hldclassi	No
cso_hr_sourceflag	fin_flag	varchar(25)	Yes	cso_hr_sourceflag	No

Table Name :	cso_material_rel_dtl
Comment :	Commercial Service Material Release Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
process_id	fin_documentno	varchar(40)	Yes	process_id	No
sub_process_id	fin_seqno	int(4)	Yes	sub_process_id	No
part_seq_no	fin_seqno	int(4)	Yes	part_seq_no	No
part_no	fin_partno	varchar(40)	Yes	part_no	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	ou_id	No
est_remarks	fin_notes	varchar(2000)	Yes	est_remarks	No
mfr_no	fin_vendorcode	varchar(45)	Yes	mfr_no	No
mfr_part_no	fin_partno	varchar(40)	Yes	mfr_part_no	No
Repair_Class	fin_repairclassification	varchar(25)	Yes	Repair_Class	No
uom	fin_uom	varchar(15)	Yes	uom	No
est_qty	fin_quantity	numeric(17)	Yes	est_qty	No
stock_status	fin_status	varchar(25)	Yes	stock_status	No
part_condition	fin_quickcodes	varchar(25)	Yes	part_condition	No
confirmed_qty	fin_quantity	numeric(17)	Yes	confirmed_qty	No
pric_basis	fin_enum_cd	varchar(5)	Yes	pric_basis	No
cost	fin_amount	numeric(13)	Yes	cost	No
custorder_no	fin_documentnumber	varchar(18)	Yes	custorder_no	No
custord_curr	fin_currencycode	varchar(5)	Yes	custord_curr	No
ppl_no	fin_documentno	varchar(40)	Yes	ppl_no	No
ppl_ou	fin_ctxt_ouinstance	int(4)	Yes	ppl_ou	No
ppl_revision	fin_int	int(4)	Yes	ppl_revision	No
pricing_element	fin_desc20	varchar(20)	Yes	pricing_element	No
pricing_date	fin_date	datetime(8)	Yes	pricing_date	No
llp	fin_designparamcode	varchar(5)	Yes	llp	No
Repl_type	fin_designparamcode	varchar(5)	Yes	Repl_type	No
part_type	fin_designparamcode	varchar(5)	Yes	part_type	No
part_group	fin_desc40	varchar(40)	Yes	part_group	No
part_class	fin_designparamcode	varchar(5)	Yes	part_class	No
mfg_no	fin_vendorcode	varchar(45)	Yes	mfg_no	No
mfg_partno	fin_partno	varchar(40)	Yes	mfg_partno	No
part_uom	fin_uom	varchar(15)	Yes	part_uom	No
factored_on	fin_designparamcode	varchar(5)	Yes	factored_on	No
Ref_catalog_id	fin_designparamcode	varchar(5)	Yes	Ref_catalog_id	No
ref_ppl_no	fin_documentno	varchar(40)	Yes	ref_ppl_no	No
ref_ppl_revision	fin_int	int(4)	Yes	ref_ppl_revision	No
ref_ppl_curr	fin_currencycode	varchar(5)	Yes	ref_ppl_curr	No
base_adj_fact	fin_amount	numeric(13)	Yes	base_adj_fact	No
price_fact	fin_amount	numeric(13)	Yes	price_fact	No
price_facton	fin_designparamcode	varchar(5)	Yes	price_facton	No
process_seq	fin_int	int(4)	Yes	process_seq	No
dir_ppl_curr	fin_currencycode	varchar(5)	Yes	dir_ppl_curr	No
std_cost	fin_amount	numeric(13)	Yes	std_cost	No
price	fin_amount	numeric(13)	Yes	price	No
baseunit_rate	fin_amount	numeric(13)	Yes	baseunit_rate	No
adjunit_rate	fin_amount	numeric(13)	Yes	adjunit_rate	No
ext_amt_baseval	fin_amount	numeric(13)	Yes	ext_amt_baseval	No
markup	fin_amount	numeric(13)	Yes	markup	No
markup_val	fin_amount	numeric(13)	Yes	markup_val	No
total_price	fin_amount	numeric(13)	Yes	total_price	No
erate_co_curr	fin_exchangerate	numeric(9)	Yes	erate_co_curr	No
adjunit_rate_cocurr	fin_amount	numeric(13)	Yes	adjunit_rate_cocurr	No
ext_amt_coval	fin_amount	numeric(13)	Yes	ext_amt_coval	No
markup_cocurr	fin_amount	numeric(13)	Yes	markup_cocurr	No
markup_val_cocurr	fin_amount	numeric(13)	Yes	markup_val_cocurr	No
total_price_cocurr	fin_amount	numeric(13)	Yes	total_price_cocurr	No
final_value	fin_amount	numeric(13)	Yes	final_value	No
price_criteria	fin_flag	varchar(25)	Yes	price_criteria	No
mult_criteria_match	fin_flag	varchar(25)	Yes	mult_criteria_match	No
matcount	fin_int	int(4)	Yes	matcount	No
Price_desc	fin_notes	varchar(2000)	Yes	Price_desc	No
price_notes	fin_notes	varchar(2000)	Yes	price_notes	No
sourceflag	fin_flag	varchar(25)	Yes	sourceflag	No
pricing_disposition	fin_notes	varchar(2000)	Yes	pricing_disposition	No
contract_no	fin_documentno	varchar(40)	Yes	contract_no	No
billable	fin_designparamcode	varchar(5)	Yes	billable	No
coa	fin_designparamcode	varchar(5)	Yes	coa	No
cap_flag	fin_designparamcode	varchar(5)	Yes	cap_flag	No
cap_max_limit	fin_designparamcode	varchar(5)	Yes	cap_max_limit	No
cap_max_limitcapcode	fin_enum	varchar(40)	Yes	cap_max_limitcapcode	No
cap_max_partgroup	fin_partgroup	varchar(40)	Yes	cap_max_partgroup	No
cap_cov_limit	fin_designparamcode	varchar(5)	Yes	cap_cov_limit	No
cap_cov_limitcapcode	fin_enum	varchar(40)	Yes	cap_cov_limitcapcode	No
cap_cov_partgroup	fin_partgroup	varchar(40)	Yes	cap_cov_partgroup	No
cap_ext_limit	fin_designparamcode	varchar(5)	Yes	cap_ext_limit	No
cap_ext_limitcapcode	fin_enum	varchar(40)	Yes	cap_ext_limitcapcode	No
cap_ext_partgroup	fin_partgroup	varchar(40)	Yes	cap_ext_partgroup	No
capped_mark_up	fin_amount	numeric(13)	Yes	capped_mark_up	No
capped_ext_price	fin_amount	numeric(13)	Yes	capped_ext_price	No
inc_exc_ref_cod	fin_effectivitycode	varchar(40)	Yes	inc_exc_ref_cod	No
warranty_reco	fin_checkflag	int(4)	Yes	warranty_reco	No
updated_by	fin_ctxt_user	varchar(30)	Yes	updated_by	No
updated_date	fin_date	datetime(8)	Yes	updated_date	No
prime_part	fin_partno	varchar(40)	Yes	prime_part	No
part_desc	fin_txt150	varchar(150)	Yes	part_desc	No
batch_id	fin_guid	varchar(40)	Yes	batch_id	No
proc_lineno	bigint	Bigint(8)	No	proc_lineno	Yes
orginal_pric_basis	fin_enum_cd	varchar(5)	Yes	orginal_pric_basis	No

Table Name :	cso_material_rel_stage_dtl
Comment :	Commercial Service Material Release Stage Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ouinstanceid	fin_ctxt_ouinstance	int(4)	No	ouinstanceid	No
process_id	fin_documentno	varchar(40)	No	process_id	No
sub_process_id	fin_seqno	int(4)	No	sub_process_id	No
part_seq_no	fin_seqno	int(4)	No	part_seq_no	No
part_no	fin_partno	varchar(40)	No	part_no	No
estimation_remarks	fin_notes	varchar(2000)	Yes	estimation_remarks	No
mfr_no	fin_vendorcode	varchar(45)	Yes	mfr_no	No
mfr_part_no	fin_partno	varchar(40)	Yes	mfr_part_no	No
Repair_Class	fin_repairclassification	varchar(25)	Yes	Repair_Class	No
warranyt_reco	fin_checkflag	int(4)	Yes	warranyt_reco	No
uom	fin_uom	varchar(15)	Yes	uom	No
est_qty	fin_quantity	numeric(17)	Yes	est_qty	No
stock_status	fin_status	varchar(25)	Yes	stock_status	No
part_condition	fin_quickcodes	varchar(25)	Yes	part_condition	No
confirmed_qty	fin_quantity	numeric(17)	Yes	confirmed_qty	No
material_cost	fin_amount	numeric(13)	Yes	material_cost	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	cso_mo_billevent_info
Comment :	Customer Service Order Billing Event

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_bw_order_no	fin_documentnumber	varchar(18)	No	Customer Order Number	Yes
cso_bw_line_no	fin_lineno	int(4)	No	Line Number	Yes
cso_bw_ou_id	fin_ctxt_ouinstance	int(4)	No	Ou Instance	Yes
cso_bw_inv_cat	fin_invoicecategory	varchar(40)	Yes	Invoice Category	No
cso_bw_inv_event	fin_event	varchar(40)	Yes	Invoicing Event	No
cso_bw_inv_type	fin_invoicetypes	varchar(25)	Yes	Invoice Type	No
cso_bw_event_desc	fin_description	varchar(100)	Yes	Event Description	No
cso_bw_triggr_task	fin_taskno	varchar(40)	Yes	Triggering Task	No
cso_bw_event_dt	fin_date	datetime(8)	Yes	Invoicing Event Date	No
cso_bw_int_invoice	fin_designparamcode	varchar(5)	Yes	Initiate Invoice	No
cso_bw_basis	fin_basis	varchar(8)	Yes	Invoice Basis	No
cso_bw_notes	fin_comments	varchar(256)	Yes	Notes	No
cso_bw_modby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
cso_bw_moddt	fin_date	datetime(8)	Yes	Modified Date	No
cso_bw_rel_no	fin_releaseno	int(4)	Yes	Release Number	No
cso_bw_wo_compdt	fin_date	datetime(8)	Yes	workOrder Completion Date	No
cso_bw_wo_closdt	fin_date	datetime(8)	Yes	WorkOrder Closed Date	No
cso_bw_resbasis	fin_basis	varchar(8)	Yes	Resolution Basis	No
cso_bw_invoiced	fin_designparamcode	varchar(5)	Yes	Invoice Flag	No
cso_bw_invline_no	fin_rowno	int(4)	No	Invoice Line Number	Yes
cso_bw_linestatus	fin_status	varchar(25)	Yes	Line Status	No
cso_bw_cumm	fin_enum_cd	varchar(5)	Yes	Cummulative	No
cso_bw_payterm	fin_payterm	Char(30)	Yes	Pat Term	No
cso_bw_billpriordays	fin_quantity	numeric(17)	Yes	Bill Prior Days	No
cso_bw_prepayval	fin_quantity	numeric(17)	Yes	Pre payment value	No
cso_bw_con_no	fin_documentno	varchar(40)	Yes	Contract Number	No
cso_bw_conrev_no	fin_revno	varchar(3)	Yes	Contract Revision Number	No
cso_upd_doc_no	fin_documentno	varchar(40)	Yes	Document Number	No
cso_upd_doc_type	fin_doctype	varchar(40)	Yes	Document Tyoe	No
cso_bw_relbfevent	fin_enum_cd	varchar(5)	Yes	Release Event	No
cso_bw_auto_rel	fin_enum_cd	varchar(5)	Yes	Auto Release	No
cso_bw_rtb_rel	fin_enum_cd	varchar(5)	Yes	Rtb Release	No
cso_bw_auto_status	fin_designparamcode	varchar(5)	Yes	Auto Status	No
cso_bw_warcoverage	fin_enum_cd	varchar(5)	Yes	War Coverage	No
cso_src_bw_line_no	fin_lineno	int(4)	Yes	SRC Line Number	No
cso_bw_qt_revno	fin_rev_no	int(4)	Yes	Revision Number	No
cso_bw_inv_for	fin_designparamcode	varchar(5)	Yes	Invoice For	No

Table Name :	cso_mo_billevent_info_hist
Comment :	Customer Service Order Billing Event History

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_bw_order_no	fin_documentnumber	varchar(18)	No	Customer Order Number	Yes
cso_bw_line_no	fin_lineno	int(4)	No	Line Number	Yes
cso_bw_ou_id	fin_ctxt_ouinstance	int(4)	No	Ou Instance	Yes
cso_bw_inv_cat	fin_invoicecategory	varchar(40)	Yes	Invoice Category	No
cso_bw_inv_event	fin_event	varchar(40)	Yes	Invoicing Event	No
cso_bw_inv_type	fin_invoicetypes	varchar(25)	Yes	Invoice Type	No
cso_bw_event_desc	fin_description	varchar(100)	Yes	Event Description	No
cso_bw_triggr_task	fin_taskno	varchar(40)	Yes	Triggering Task	No
cso_bw_event_dt	fin_date	datetime(8)	Yes	Invoicing Event Date	No
cso_bw_int_invoice	fin_designparamcode	varchar(5)	Yes	Initiate Invoice	No
cso_bw_basis	fin_basis	varchar(8)	Yes	Invoice Basis	No
cso_bw_notes	fin_comments	varchar(256)	Yes	Notes	No
cso_bw_modby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
cso_bw_moddt	fin_date	datetime(8)	Yes	Modified Date	No
cso_bw_rev_no	fin_rev_no	int(4)	No	Customer Order Revision Number	Yes
cso_bw_rel_no	fin_rev_no	int(4)	Yes	Release #	No
cso_bw_qt_revno	fin_rev_no	int(4)	Yes	Revision #	No
cso_bw_inv_for	fin_designparamcode	varchar(5)	Yes	Invoice For	No

Table Name :	cso_mo_custcorrs_dtl
Comment :	Customer Service Oder Correspondent details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_cc_order_no	fin_documentnumber	varchar(18)	No	Customer Order Number	Yes
cso_cc_seq_no	fin_lineno	int(4)	No	Sequence number	Yes
cso_cc_date	fin_date	datetime(8)	No	Date	Yes
cso_cc_ou_id	fin_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
cso_cc_custremarks	fin_notes	varchar(2000)	Yes	Customer Remarks	No
cso_cc_our_remarks	fin_notes	varchar(2000)	Yes	Our Remarks	No
cso_cc_cust_splinst	fin_comments	varchar(256)	Yes	Special instructions	No
cso_cc_ct_person	fin_contactperson	varchar(80)	Yes	Contact Person	No
cso_cc_phone	fin_phone	varchar(18)	Yes	Phone	No
cso_cc_ccat	fin_designparamcode	varchar(5)	Yes	Correspondence Category	No
cso_cc_ref	fin_comments	varchar(256)	Yes	References	No
cso_cc_attby	fin_ctxt_user	varchar(30)	Yes	Attended By	No
cso_cc_attdt	fin_date	datetime(8)	Yes	Attended Date	No
cso_cc_crby	fin_ctxt_user	varchar(30)	Yes	Created By	No
cso_cc_crdt	fin_date	datetime(8)	Yes	Created Date	No
cso_cc_modby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
cso_cc_moddt	fin_date	datetime(8)	Yes	Modified Date	No
cso_cc_filename	fin_file	varchar(80)	Yes	FileName	No

Table Name :	cso_mo_custcorrs_dtl_hist
Comment :	Customer Service Oder Correspondent details History

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_cc_order_no	fin_documentnumber	varchar(18)	No	Customer Order Number	Yes
cso_cc_seq_no	fin_lineno	int(4)	No	Sequence number	Yes
cso_cc_date	fin_date	datetime(8)	No	Date	Yes
cso_cc_ou_id	fin_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
cso_cc_custremarks	fin_notes	varchar(2000)	Yes	Customer Remarks	No
cso_cc_our_remarks	fin_notes	varchar(2000)	Yes	Our Remarks	No
cso_cc_cust_splinst	fin_comments	varchar(256)	Yes	Special instructions	No
cso_cc_ct_person	fin_contactperson	varchar(80)	Yes	Contact Person	No
cso_cc_phone	fin_phone	varchar(18)	Yes	Phone	No
cso_cc_ccat	fin_designparamcode	varchar(5)	Yes	Correspondence Category	No
cso_cc_ref	fin_comments	varchar(256)	Yes	References	No
cso_cc_attby	fin_ctxt_user	varchar(30)	Yes	Attended By	No
cso_cc_attdt	fin_date	datetime(8)	Yes	Attended Date	No
cso_cc_crby	fin_ctxt_user	varchar(30)	Yes	Created By	No
cso_cc_crdt	fin_date	datetime(8)	Yes	Created Date	No
cso_cc_modby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
cso_cc_moddt	fin_date	datetime(8)	Yes	Modified Date	No
cso_cc_rev_no	fin_rev_no	int(4)	No	Revision number	Yes
cso_cc_filename	fin_file	varchar(80)	Yes	Filename	No

Table Name :	cso_mo_pdd_dtl
Comment :	Customer Service Order Promised Delivery Date Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_pdd_order_no	fin_documentnumber	varchar(18)	No	Customer Order Number	Yes
cso_pdd_seqno	fin_lineno	int(4)	No	Sequence Number	Yes
cso_pdd_ou_id	fin_ctxt_ouinstance	int(4)	No	Ou Instance	Yes
cso_pdd_revno	fin_rev_no	int(4)	Yes	Customer Order Revision Number	No
cso_pdd_start_date	fin_date	datetime(8)	Yes	Start Date	No
cso_pdd_promd_ddate	fin_date	datetime(8)	Yes	Promised Delivery Date	No
cso_pdd_penaly_notes	fin_comments	varchar(256)	Yes	Penalty Notes	No
cso_pdd_rn_comments	fin_comments	varchar(256)	Yes	Revision comments	No
cso_pdd_ordermode	fin_designparamcode	varchar(5)	Yes	Order Mode	No
cso_pdd_modby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
cso_pdd_moddt	fin_date	datetime(8)	Yes	Modified Date	No
cso_pdd_plan_enddt	fin_date	datetime(8)	Yes	Planned End Date	No
cso_pdd_excwrk_delay	fin_int	int(4)	Yes	Exclusion Work Delays	No
cso_proppro_deldt	fin_date	datetime(8)	Yes	Delivery Date	No
cso_pdd_enddate	fin_date	datetime(8)	Yes	EndDate	No
cso_pdd_AdjConReqDt	fin_date	datetime(8)	Yes	Adjusted contracted Requested Date	No
CSO_PDD_adjcusdur	fin_quantity	numeric(17)	Yes	Adjusted Coustomer Duration	No
CSO_PDD_DurAdjcom	fin_notes	varchar(2000)	Yes	Adjusted Duration Comments	No

Table Name :	cso_od_object_dtl
Comment :	Customer Service Order Execution Document Mapping

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_od_ord_no	fin_documentnumber	varchar(18)	No	Customet Order Number	Yes
cso_od_objline_no	fin_lineno	int(4)	No	Object Details Line Number	Yes
cso_od_ou_id	fin_ctxt_ouinstance	int(4)	No	Ou Instance	Yes
cso_od_con_no	fin_documentno	varchar(40)	No	Contract Number	No
cso_od_objeffcd	fin_quickcodes	varchar(25)	Yes	Object Effectivity Code	No
cso_od_conline_no	fin_lineno	int(4)	Yes	Contract Line Number	No
cso_od_ac_regno	fin_acregno	varchar(30)	Yes	Aircraft Registration Number	No
cso_od_acmsn	fin_msnno	varchar(40)	Yes	Aircraft Manufacturer Serial Number	No
cso_od_ordrevision_no	fin_revno	varchar(3)	Yes	Order Revision Number	No
cso_od_part_no	fin_partno	varchar(40)	Yes	Part Number	No
cso_od_mfr_part_no	fin_partno	varchar(40)	Yes	Manufacturer Part Number	No
cso_od_mfr_no	fin_vendorcode	varchar(45)	Yes	Manufacturer Number	No
cso_od_prtsl_no	fin_partserialnumber	varchar(40)	Yes	Part Serial Number	No
cso_od_prt_msnno	fin_msnno	varchar(40)	Yes	Part Manufacturer Serial Number	No
cso_od_con_revno	fin_revno	varchar(3)	Yes	Contract Revision Number	No
cso_od_lotno	fin_lotno	varchar(18)	Yes	Lot Number	No
cso_od_qty	fin_quantity	numeric(17)	Yes	Quantity	No
cso_od_rac_msn	fin_msnno	varchar(40)	Yes	Removed from Aircraft Manufacturer Serial Number	No
cso_od_rf_mfr_part_no	fin_partno	varchar(40)	Yes	Removed from Manufacturer Part Number	No
cso_od_rm_slno	fin_partserialnumber	varchar(40)	Yes	Removed from Serial Number	No
cso_od_rem_dtetime	fin_datetime	datetime(8)	Yes	Removed Date and Time	No
cso_od_resrem	fin_comments	varchar(256)	Yes	Reason for Removal	No
cso_od_mod_inst	fin_notes	varchar(2000)	Yes	Mod Instructions	No
cso_od_cust_maint_ref	fin_notes	varchar(2000)	Yes	Customet Maintenance References	No
cso_od_job_card_ref	fin_notes	varchar(2000)	Yes	Job Card References	No
cso_od_disc_ref	fin_notes	varchar(2000)	Yes	Discrepancy References	No
cso_od_rcpt_cmts	fin_notes	varchar(2000)	Yes	Receipt Comments	No
cso_od_remarks	fin_notes	varchar(2000)	Yes	Remarks	No
cso_od_rac_reg_no	fin_acregno	varchar(30)	Yes	Removed from Aircraft Registration Number	No
cso_od_ercpt_dt	fin_date	datetime(8)	Yes	Expected Receipt Date	No
cso_od_pricbas	fin_designparamcode	varchar(5)	Yes	Pricing Basis	No
cso_od_saltype	fin_quickcodes	varchar(25)	Yes	Sale Type	No
cso_od_cust_no	fin_customer_id	varchar(18)	Yes	Customer Number	No
cso_od_findesti	fin_destination	varchar(40)	Yes	Final Destination	No
cso_od_rout_qty	fin_quantity	numeric(17)	Yes	Routing Quantity	No
cso_od_uom	fin_uom	varchar(15)	Yes	UOM	No
cso_od_intlotno	fin_lotno	varchar(18)	Yes	LotNumber	No
cso_od_recd_qty	fin_quantity	numeric(17)	Yes	Received Quantity	No
CSO_OD_AC_ERcpt_Dt	fin_date	datetime(8)	Yes	Aircraft Expected Receipt Date	No
CSO_OD_AC_FinalDst	fin_destination	varchar(40)	Yes	Aircraft Final Destination	No
cso_od_rf_mfr_no	fin_partno	varchar(40)	Yes	Removed from Manufacturer Number	No
cso_od_revindicator	fin_description	varchar(100)	Yes	Revision Indicator	No
cso_od_pckage_typ	fin_quickcodes	varchar(25)	Yes	Package Type for Aircraft	No
cso_od_acft_grp	fin_partgroup	varchar(40)	Yes	Aircraft Group	No
cso_od_cust_grp	fin_group	varchar(25)	Yes	Customer Group no	No
cso_od_stck_sts	fin_stockstatus	varchar(40)	Yes	stock status	No
cso_od_peg_qty	fin_quantity	numeric(17)	Yes	Pegged Qty	No

Table Name :	cso_od_object_dtl_hist
Comment :	Customer Service Order Execution Document Mapping History

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_od_ord_no	fin_documentnumber	varchar(18)	No	Customet Order Number	Yes
cso_od_objline_no	fin_lineno	int(4)	No	Object Details Line Number	Yes
cso_od_ou_id	fin_ctxt_ouinstance	int(4)	No	Ou Instance	Yes
cso_od_con_no	fin_documentno	varchar(40)	No	Contract Number	No
cso_od_objeffcd	fin_quickcodes	varchar(25)	Yes	Object Effectivity Code	No
cso_od_conline_no	fin_lineno	int(4)	Yes	Contract Line Number	No
cso_od_ac_regno	fin_acregno	varchar(30)	Yes	Aircraft Registration Number	No
cso_od_acmsn	fin_msnno	varchar(40)	Yes	Aircraft Manufacturer Serial Number	No
cso_od_ordrevision_no	fin_rev_no	int(4)	No	Order Revision Number	Yes
cso_od_part_no	fin_partno	varchar(40)	Yes	Part Number	No
cso_od_mfr_part_no	fin_partno	varchar(40)	Yes	Manufacturer Part Number	No
cso_od_mfr_no	fin_vendorcode	varchar(45)	Yes	Manufacturer Number	No
cso_od_prtsl_no	fin_partserialnumber	varchar(40)	Yes	Part Serial Number	No
cso_od_prt_msnno	fin_msnno	varchar(40)	Yes	Part Manufacturer Serial Number	No
cso_od_con_revno	fin_revno	varchar(3)	Yes	Contract Revision Number	No
cso_od_lotno	fin_lotno	varchar(18)	Yes	Lot Number	No
cso_od_qty	fin_quantity	numeric(17)	Yes	Quantity	No
cso_od_rac_msn	fin_msnno	varchar(40)	Yes	Removed from Aircraft Manufacturer Serial Number	No
cso_od_rf_mfr_part_no	fin_partno	varchar(40)	Yes	Removed from Manufacturer Part Number	No
cso_od_rm_slno	fin_partserialnumber	varchar(40)	Yes	Removed from Serial Number	No
cso_od_rem_dtetime	fin_datetime	datetime(8)	Yes	Removed Date and Time	No
cso_od_resrem	fin_comments	varchar(256)	Yes	Reason for Removal	No
cso_od_mod_inst	fin_notes	varchar(2000)	Yes	Mod Instructions	No
cso_od_cust_maint_ref	fin_notes	varchar(2000)	Yes	Customet Maintenance References	No
cso_od_job_card_ref	fin_notes	varchar(2000)	Yes	Job Card References	No
cso_od_disc_ref	fin_notes	varchar(2000)	Yes	Discrepancy References	No
cso_od_rcpt_cmts	fin_notes	varchar(2000)	Yes	Receipt Comments	No
cso_od_remarks	fin_notes	varchar(2000)	Yes	Remarks	No
cso_od_rac_reg_no	fin_acregno	varchar(30)	Yes	Removed from Aircraft Registration Number	No
cso_od_ercpt_dt	fin_date	datetime(8)	Yes	Expected Receipt Date	No
cso_od_pricbas	fin_designparamcode	varchar(5)	Yes	Pricing Basis	No
cso_od_saltype	fin_quickcodes	varchar(25)	Yes	Sale Type	No
cso_od_cust_no	fin_customer_id	varchar(18)	Yes	Customer Number	No
cso_od_findesti	fin_destination	varchar(40)	Yes	Final Destination	No
cso_od_rout_qty	fin_quantity	numeric(17)	Yes	Routing Quantity	No
cso_od_uom	fin_uom	varchar(15)	Yes	UOM	No
cso_od_intlotno	fin_lotno	varchar(18)	Yes	LotNumber	No
cso_od_recd_qty	fin_quantity	numeric(17)	Yes	Received Quantity	No
CSO_OD_AC_ERcpt_Dt	fin_date	datetime(8)	Yes	Aircraft Expected Receipt Date	No
CSO_OD_AC_FinalDst	fin_destination	varchar(40)	Yes	Aircraft Final Destination	No
cso_od_rf_mfr_no	fin_partno	varchar(40)	Yes	Removed from Manufacturer Number	No
cso_od_revindicator	fin_description	varchar(100)	Yes	Revision Indicator	No
cso_od_pckage_typ	fin_quickcodes	varchar(25)	Yes	Package Type for Aircraft	No
cso_od_acft_grp	fin_partgroup	varchar(40)	Yes	Aircarft Group	No
cso_od_cust_grp	fin_group	varchar(25)	Yes	Customer Group no	No
cso_od_stck_sts	fin_stockstatus	varchar(40)	Yes	stock status	No
cso_od_peg_qty	fin_quantity	numeric(17)	Yes	Pegged Qty	No

Table Name :	cso_other_docments_rel_dtl
Comment :	Commercial Service Other Document Release details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
process_id	fin_seqno	int(4)	Yes	process_id	No
sub_process_id	fin_seqno	int(4)	Yes	sub_process_id	No
est_release_id	fin_seqno	int(4)	Yes	est_release_id	No
est_inst_id	fin_seqno	int(4)	Yes	est_inst_id	No
exec_comm_id	fin_seqno	int(4)	Yes	exec_comm_id	No
exec_doc_type	fin_type	varchar(25)	Yes	exec_doc_type	No
exec_doc_no	fin_documentno	varchar(40)	Yes	exec_doc_no	No
exec_doc_line_no	fin_lineno	int(4)	Yes	exec_doc_line_no	No
exec_doc_status	fin_status	varchar(25)	Yes	exec_doc_status	No
parent_wo_no	fin_documentno	varchar(40)	Yes	parent_wo_no	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	ou_id	No
est_remarks	fin_notes	varchar(2000)	Yes	est_remarks	No
aircraft_reg_no	fin_acregno	varchar(30)	Yes	aircraft_reg_no	No
release_event	fin_event	varchar(40)	Yes	release_event	No
release_type	fin_type	varchar(25)	Yes	release_type	No
contract_no	fin_documentno	varchar(40)	Yes	contract_no	No
contract_rev_no	fin_seqno	int(4)	Yes	contract_rev_no	No
custorder_no	fin_documentno	varchar(40)	Yes	custorder_no	No
custorder_rev_no	fin_seqno	int(4)	Yes	custorder_rev_no	No
custorder_curr	fin_currencycode	varchar(5)	Yes	custorder_curr	No
eff_ref_cd	fin_quickcodes	varchar(25)	Yes	eff_ref_cd	No
doc_type	fin_type	varchar(25)	Yes	doc_type	No
doc_no	fin_documentno	varchar(40)	Yes	doc_no	No
doc_pric_basis	fin_enum_cd	varchar(5)	Yes	doc_pric_basis	No
doc_curr	fin_currencycode	varchar(5)	Yes	doc_curr	No
doc_amount	fin_amount	numeric(13)	Yes	doc_amount	No
doc_status	fin_status	varchar(25)	Yes	doc_status	No
doc_sub_type	fin_type	varchar(25)	Yes	doc_sub_type	No
exch_type	fin_type	varchar(25)	Yes	exch_type	No
entity	fin_enum_cd	varchar(5)	Yes	entity	No
exch_init_refdoc_type	fin_type	varchar(25)	Yes	exch_init_refdoc_type	No
exch_init_refdoc_no	fin_documentno	varchar(40)	Yes	exch_init_refdoc_no	No
exch_init_as	fin_enum_cd	varchar(5)	Yes	exch_init_as	No
reason_exch	fin_quickcodes	varchar(25)	Yes	reason_exch	No
exch_mr_no	fin_documentno	varchar(40)	Yes	exch_mr_no	No
remarks	fin_notes	varchar(2000)	Yes	remarks	No
supplier_no	fin_vendorcode	varchar(45)	Yes	supplier_no	No
supplier_name	fin_txt150	varchar(150)	Yes	supplier_name	No
billable	fin_enum_cd	varchar(5)	Yes	billable	No
coa	fin_enum_cd	varchar(5)	Yes	coa	No
exch_source_inv_qty	fin_quantity	numeric(17)	Yes	exch_source_inv_qty	No
exch_source_rep_qty	fin_quantity	numeric(17)	Yes	exch_source_rep_qty	No
exch_source_pur_qty	fin_quantity	numeric(17)	Yes	exch_source_pur_qty	No
rep_quote_no	fin_documentno	varchar(40)	Yes	rep_quote_no	No
rep_quote_date	fin_date	datetime(8)	Yes	rep_quote_date	No
refdoc_amend_no	fin_seqno	int(4)	Yes	refdoc_amend_no	No
workcenter	fin_workcenter	varchar(80)	Yes	workcenter	No
quote_status	fin_status	varchar(25)	Yes	quote_status	No
warranty_reco	fin_checkflag	int(4)	Yes	warranty_reco	No
repair_class	fin_repairclassification	varchar(25)	Yes	repair_class	No
repair_process_code	fin_repairprocesscode	varchar(25)	Yes	repair_process_code	No
incl_excl_flag	fin_checkflag	int(4)	Yes	incl_excl_flag	No
exclusion_code	fin_effectivitycode	varchar(40)	Yes	exclusion_code	No
exclusion_line_no	fin_lineno	int(4)	Yes	exclusion_line_no	No
excl_notes	fin_notes	varchar(2000)	Yes	excl_notes	No
ata_no	fin_documentno	varchar(40)	Yes	ata_no	No
ata_desc	fin_txt150	varchar(150)	Yes	ata_desc	No
updated_by	fin_ctxt_user	varchar(30)	Yes	updated_by	No
updated_date	fin_date	datetime(8)	Yes	updated_date	No
quoted_flag	fin_status	varchar(25)	Yes	quoted_flag	No
quote_appr_flag	fin_enum_cd	varchar(5)	Yes	quote_appr_flag	No
invoiced_flag	fin_enum_cd	varchar(5)	Yes	invoiced_flag	No
quoted_status	fin_enum_cd	varchar(5)	Yes	quoted_status	No
invoiced_status	fin_enum_cd	varchar(5)	Yes	invoiced_status	No
Price_flag	fin_flag	varchar(25)	Yes	Price_flag	No
rel_status	fin_status	varchar(25)	Yes	rel_status	No
doc_exrate	fin_exchangerate	numeric(9)	Yes	doc_exrate	No
batch_id	fin_guid	varchar(40)	Yes	batch_id	No
doc_amt_basecurr	fin_amount	numeric(13)	Yes	doc_amt_basecurr	No
ref_doc_type	fin_documenttype	varchar(40)	Yes	ref_doc_type	No
ref_doc_no	fin_documentno	varchar(40)	Yes	ref_doc_no	No
ref_doc_curr	fin_currencycode	varchar(5)	Yes	ref_doc_curr	No
quote_type	fin_designparamcode	varchar(5)	Yes	quote_type	No
proc_lineno	bigint	Bigint(8)	No	proc_lineno	Yes

Table Name :	cso_other_documents_rel_stage
Comment :	Commercial Service Other Document stage breakup details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
process_id	fin_seqno	int(4)	Yes	process_id	No
sub_process_id	fin_seqno	int(4)	Yes	sub_process_id	No
est_release_id	fin_seqno	int(4)	Yes	est_release_id	No
est_inst_id	fin_seqno	int(4)	Yes	est_inst_id	No
exec_comm_id	fin_seqno	int(4)	Yes	exec_comm_id	No
exec_doc_type	fin_type	varchar(25)	Yes	exec_doc_type	No
exec_doc_no	fin_documentno	varchar(40)	Yes	exec_doc_no	No
exec_doc_line_no	fin_lineno	int(4)	Yes	exec_doc_line_no	No
exec_doc_status	fin_status	varchar(25)	Yes	exec_doc_status	No
parent_wo_no	fin_documentno	varchar(40)	Yes	parent_wo_no	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	ou_id	No
est_remarks	fin_notes	varchar(2000)	Yes	est_remarks	No
aircraft_reg_no	fin_acregno	varchar(30)	Yes	aircraft_reg_no	No
release_event	fin_event	varchar(40)	Yes	release_event	No
release_type	fin_type	varchar(25)	Yes	release_type	No
contract_no	fin_documentno	varchar(40)	Yes	contract_no	No
contract_rev_no	fin_seqno	int(4)	Yes	contract_rev_no	No
custorder_no	fin_documentno	varchar(40)	Yes	custorder_no	No
custorder_rev_no	fin_seqno	int(4)	Yes	custorder_rev_no	No
custorder_curr	fin_currencycode	varchar(5)	Yes	custorder_curr	No
eff_ref_cd	fin_quickcodes	varchar(25)	Yes	eff_ref_cd	No
doc_type	fin_type	varchar(25)	Yes	doc_type	No
doc_no	fin_documentno	varchar(40)	Yes	doc_no	No
doc_pric_basis	fin_enum_cd	varchar(5)	Yes	doc_pric_basis	No
doc_curr	fin_currencycode	varchar(5)	Yes	doc_curr	No
doc_amount	fin_amount	numeric(13)	Yes	doc_amount	No
doc_status	fin_status	varchar(25)	Yes	doc_status	No
doc_sub_type	fin_type	varchar(25)	Yes	doc_sub_type	No
exch_type	fin_type	varchar(25)	Yes	exch_type	No
entity	fin_enum_cd	varchar(5)	Yes	entity	No
exch_init_refdoc_type	fin_type	varchar(25)	Yes	exch_init_refdoc_type	No
exch_init_refdoc_no	fin_documentno	varchar(40)	Yes	exch_init_refdoc_no	No
exch_init_as	fin_enum_cd	varchar(5)	Yes	exch_init_as	No
reason_exch	fin_quickcodes	varchar(25)	Yes	reason_exch	No
exch_mr_no	fin_documentno	varchar(40)	Yes	exch_mr_no	No
remarks	fin_notes	varchar(2000)	Yes	remarks	No
supplier_no	fin_vendorcode	varchar(45)	Yes	supplier_no	No
supplier_name	fin_txt150	varchar(150)	Yes	supplier_name	No
billable	fin_enum_cd	varchar(5)	Yes	billable	No
coa	fin_enum_cd	varchar(5)	Yes	coa	No
exch_source_inv_qty	fin_quantity	numeric(17)	Yes	exch_source_inv_qty	No
exch_source_rep_qty	fin_quantity	numeric(17)	Yes	exch_source_rep_qty	No
exch_source_pur_qty	fin_quantity	numeric(17)	Yes	exch_source_pur_qty	No
rep_quote_no	fin_documentno	varchar(40)	Yes	rep_quote_no	No
rep_quote_date	fin_date	datetime(8)	Yes	rep_quote_date	No
refdoc_amend_no	fin_seqno	int(4)	Yes	refdoc_amend_no	No
workcenter	fin_workcenter	varchar(80)	Yes	workcenter	No
quote_status	fin_status	varchar(25)	Yes	quote_status	No
warranty_reco	fin_checkflag	int(4)	Yes	warranty_reco	No
repair_class	fin_repairclassification	varchar(25)	Yes	repair_class	No
repair_process_code	fin_repairprocesscode	varchar(25)	Yes	repair_process_code	No
incl_excl_flag	fin_checkflag	int(4)	Yes	incl_excl_flag	No
exclusion_code	fin_effectivitycode	varchar(40)	Yes	exclusion_code	No
exclusion_line_no	fin_lineno	int(4)	Yes	exclusion_line_no	No
excl_notes	fin_notes	varchar(2000)	Yes	excl_notes	No
ata_no	fin_documentno	varchar(40)	Yes	ata_no	No
ata_desc	fin_txt150	varchar(150)	Yes	ata_desc	No
quoted_flag	fin_enum_cd	varchar(5)	Yes	quoted_flag	No
quote_appr_flag	fin_enum_cd	varchar(5)	Yes	quote_appr_flag	No
invoiced_flag	fin_enum_cd	varchar(5)	Yes	invoiced_flag	No
quoted_status	fin_enum_cd	varchar(5)	Yes	quoted_status	No
invoiced_status	fin_enum_cd	varchar(5)	Yes	invoiced_status	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION_KEY	Yes
rel_status	fin_status	varchar(25)	Yes	Null	No
doc_exrate	fin_exchangerate	numeric(9)	Yes	Null	No
doc_amt_basecurr	fin_amount	numeric(13)	Yes	Null	No
ref_doc_type	fin_documenttype	varchar(40)	Yes	Null	No
ref_doc_no	fin_documentno	varchar(40)	Yes	Null	No
ref_doc_curr	fin_currencycode	varchar(5)	Yes	Null	No
quote_type	fin_designparamcode	varchar(5)	Yes	Null	No

Table Name :	cso_other_doc_rel_brkup_dtl
Comment :	Commercial Service Other Documents Breakup details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
process_id	fin_seqno	int(4)	Yes	process_id	No
sub_process_id	fin_seqno	int(4)	Yes	sub_process_id	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	ou_id	No
Doc_no	fin_documentno	varchar(40)	Yes	Doc_no	No
Doc_line_no	fin_lineno	int(4)	Yes	Doc_line_no	No
part_no	fin_partno	varchar(40)	Yes	part_no	No
mfr_part_no	fin_partno	varchar(40)	Yes	mfr_part_no	No
mfr_no	fin_vendorcode	varchar(45)	Yes	mfr_no	No
part_condition	fin_condition	varchar(15)	Yes	part_condition	No
Part_stk_status	fin_status	varchar(25)	Yes	Part_stk_status	No
Exch_class	fin_type	varchar(25)	Yes	Exch_class	No
Exch_type	fin_type	varchar(25)	Yes	Exch_type	No
Exch_reason	fin_reasoncode	varchar(10)	Yes	Exch_reason	No
Billable	fin_enum_cd	varchar(5)	Yes	Billable	No
Doc_line_status	fin_status	varchar(25)	Yes	Doc_line_status	No
Doc_line_remarks	fin_notes	varchar(2000)	Yes	Doc_line_remarks	No
Element	fin_designparamcode	varchar(5)	Yes	Element	No
Quantity	fin_quantity	numeric(17)	Yes	Quantity	No
UOM	fin_uom	varchar(15)	Yes	UOM	No
Cost	fin_amount	numeric(13)	Yes	Cost	No
Rep_BER_Cost	fin_amount	numeric(13)	Yes	Rep_BER_Cost	No
Exch_fee	fin_amount	numeric(13)	Yes	Exch_fee	No
Non_Rtn_Cost	fin_amount	numeric(13)	Yes	Non_Rtn_Cost	No
Total_cost	fin_amount	numeric(13)	Yes	Total_cost	No
org_Rep_BER_Cost	fin_amount	numeric(13)	Yes	org_Rep_BER_Cost	No
org_Exch_fee	fin_amount	numeric(13)	Yes	org_Exch_fee	No
org_Non_Rtn_Cost	fin_amount	numeric(13)	Yes	org_Non_Rtn_Cost	No
Exch_part_no	fin_partno	varchar(40)	Yes	Exch_part_no	No
Exch_mfr_part_no	fin_partno	varchar(40)	Yes	Exch_mfr_part_no	No
Exchpart_mfr_no	fin_vendorcode	varchar(45)	Yes	Exchpart_mfr_no	No
Exch_part_condition	fin_condition	varchar(15)	Yes	Exch_part_condition	No
Exch_Part_stk_status	fin_status	varchar(25)	Yes	Exch_Part_stk_status	No
Exch_Part_Ownership	fin_status	varchar(25)	Yes	Exch_Part_Ownership	No
Exch_Source_CO_no	fin_documentno	varchar(40)	Yes	Exch_Source_CO_no	No
ppl_no	fin_documentno	varchar(40)	Yes	ppl_no	No
ppl_ou	fin_ctxt_ouinstance	int(4)	Yes	ppl_ou	No
ppl_revision	fin_int	int(4)	Yes	ppl_revision	No
pricing_element	fin_desc20	varchar(20)	Yes	pricing_element	No
pricing_date	fin_date	datetime(8)	Yes	pricing_date	No
llp	fin_designparamcode	varchar(5)	Yes	llp	No
Repl_type	fin_designparamcode	varchar(5)	Yes	Repl_type	No
part_type	fin_designparamcode	varchar(5)	Yes	part_type	No
part_group	fin_desc40	varchar(40)	Yes	part_group	No
part_class	fin_designparamcode	varchar(5)	Yes	part_class	No
factored_on	fin_designparamcode	varchar(5)	Yes	factored_on	No
ref_catalogue_id	fin_designparamcode	varchar(5)	Yes	ref_catalogue_id	No
ref_ppl_no	fin_documentno	varchar(40)	Yes	ref_ppl_no	No
ref_ppl_revision	fin_int	int(4)	Yes	ref_ppl_revision	No
ref_ppl_curr	fin_currencycode	varchar(5)	Yes	ref_ppl_curr	No
base_adj_fact	fin_amount	numeric(13)	Yes	base_adj_fact	No
price_fact	fin_amount	numeric(13)	Yes	price_fact	No
price_facton	fin_designparamcode	varchar(5)	Yes	price_facton	No
process_seq	fin_int	int(4)	Yes	process_seq	No
dir_ppl_curr	fin_currencycode	varchar(5)	Yes	dir_ppl_curr	No
std_cost	fin_amount	numeric(13)	Yes	std_cost	No
price	fin_amount	numeric(13)	Yes	price	No
baseunit_rate	fin_amount	numeric(13)	Yes	baseunit_rate	No
adjunit_rate	fin_amount	numeric(13)	Yes	adjunit_rate	No
ext_amt_baseval	fin_amount	numeric(13)	Yes	ext_amt_baseval	No
markup	fin_amount	numeric(13)	Yes	markup	No
markup_val	fin_amount	numeric(13)	Yes	markup_val	No
total_price	fin_amount	numeric(13)	Yes	total_price	No
erate_co_curr	fin_exchangerate	numeric(9)	Yes	erate_co_curr	No
adjunit_rate_cocurr	fin_amount	numeric(13)	Yes	adjunit_rate_cocurr	No
ext_amt_coval	fin_amount	numeric(13)	Yes	ext_amt_coval	No
markup_cocurr	fin_amount	numeric(13)	Yes	markup_cocurr	No
markup_val_cocurr	fin_amount	numeric(13)	Yes	markup_val_cocurr	No
total_price_cocurr	fin_amount	numeric(13)	Yes	total_price_cocurr	No
final_value	fin_amount	numeric(13)	Yes	final_value	No
price_criteria	fin_flag	varchar(25)	Yes	price_criteria	No
mult_criteria_match	fin_flag	varchar(25)	Yes	mult_criteria_match	No
matcount	fin_int	int(4)	Yes	matcount	No
Price_desc	fin_notes	varchar(2000)	Yes	Price_desc	No
price_notes	fin_notes	varchar(2000)	Yes	price_notes	No
sourceflag	fin_flag	varchar(25)	Yes	sourceflag	No
pricing_disposition	fin_notes	varchar(2000)	Yes	pricing_disposition	No
cap_flag	fin_designparamcode	varchar(5)	Yes	cap_flag	No
cap_max_limit	fin_designparamcode	varchar(5)	Yes	cap_max_limit	No
cap_max_limitcapcode	fin_enum	varchar(40)	Yes	cap_max_limitcapcode	No
cap_cov_limit	fin_designparamcode	varchar(5)	Yes	cap_cov_limit	No
cap_cov_limitcapcode	fin_enum	varchar(40)	Yes	cap_cov_limitcapcode	No
cap_ext_limit	fin_designparamcode	varchar(5)	Yes	cap_ext_limit	No
cap_ext_limitcapcode	fin_enum	varchar(40)	Yes	cap_ext_limitcapcode	No
capped_mark_up	fin_amount	numeric(13)	Yes	capped_mark_up	No
capped_ext_price	fin_amount	numeric(13)	Yes	capped_ext_price	No
cap_notes	fin_notes	varchar(2000)	Yes	cap_notes	No
excl_ref_cod	fin_flag	varchar(25)	Yes	excl_ref_cod	No
warranty_reco	fin_flag	varchar(25)	Yes	warranty_reco	No
updated_by	fin_ctxt_user	varchar(30)	Yes	updated_by	No
updated_date	fin_date	datetime(8)	Yes	updated_date	No
doc_type	fin_type	varchar(25)	Yes	doc_type	No
spl_no	fin_documentno	varchar(40)	Yes	spl_no	No
spl_ou	fin_ctxt_ouinstance	int(4)	Yes	spl_ou	No
spl_revision	fin_int	int(4)	Yes	spl_revision	No
spl_curr	fin_currencycode	varchar(5)	Yes	spl_curr	No
final_markup	fin_amount	numeric(13)	Yes	final_markup	No
unitprice	fin_amount	numeric(13)	Yes	unitprice	No
cov_unitprice	fin_amount	numeric(13)	Yes	cov_unitprice	No
capped_unitprice	fin_amount	numeric(13)	Yes	capped_unitprice	No
final_unitprice	fin_amount	numeric(13)	Yes	final_unitprice	No
ext_basicprice	fin_amount	numeric(13)	Yes	ext_basicprice	No
ext_markup	fin_amount	numeric(13)	Yes	ext_markup	No
capped_ext_markup	fin_amount	numeric(13)	Yes	capped_ext_markup	No
final_ext_markup	fin_amount	numeric(13)	Yes	final_ext_markup	No
tcd_amt	fin_amount	numeric(13)	Yes	tcd_amt	No
ext_price	fin_amount	numeric(13)	Yes	ext_price	No
cov_price	fin_amount	numeric(13)	Yes	cov_price	No
capped_cov_price	fin_amount	numeric(13)	Yes	capped_cov_price	No
final_price	fin_amount	numeric(13)	Yes	final_price	No
batch_id	fin_guid	varchar(40)	Yes	batch_id	No
doc_erate	fin_exchangerate	numeric(9)	Yes	doc_erate	No
doc_amt_basecurr	fin_amount	numeric(13)	Yes	doc_amt_basecurr	No
proc_lineno	bigint	Bigint(8)	No	proc_lineno	No

Table Name :	cso_other_doc_rel_stage_dtl
Comment :	Commercial Service Other Document stage details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
process_id	fin_seqno	int(4)	Yes	process_id	No
sub_process_id	fin_seqno	int(4)	Yes	sub_process_id	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	ou_id	No
Doc_no	fin_documentno	varchar(40)	Yes	Doc_no	No
Doc_line_no	fin_lineno	int(4)	Yes	Doc_line_no	No
part_no	fin_partno	varchar(40)	Yes	part_no	No
mfr_part_no	fin_partno	varchar(40)	Yes	mfr_part_no	No
mfr_no	fin_vendorcode	varchar(45)	Yes	mfr_no	No
part_condition	fin_condition	varchar(15)	Yes	part_condition	No
Part_stk_status	fin_status	varchar(25)	Yes	Part_stk_status	No
Exch_class	fin_type	varchar(25)	Yes	Exch_class	No
Exch_type	fin_type	varchar(25)	Yes	Exch_type	No
Exch_reason	fin_reasoncode	varchar(10)	Yes	Exch_reason	No
Billable	fin_enum_cd	varchar(5)	Yes	Billable	No
Doc_line_status	fin_status	varchar(25)	Yes	Doc_line_status	No
Doc_line_remarks	fin_notes	varchar(2000)	Yes	Doc_line_remarks	No
Element	fin_designparamcode	varchar(5)	Yes	Element	No
Quantity	fin_quantity	numeric(17)	Yes	Quantity	No
UOM	fin_uom	varchar(15)	Yes	UOM	No
Cost	fin_amount	numeric(13)	Yes	Cost	No
Rep_BER_Cost	fin_amount	numeric(13)	Yes	Rep_BER_Cost	No
Exch_fee	fin_amount	numeric(13)	Yes	Exch_fee	No
Non_Rtn_Cost	fin_amount	numeric(13)	Yes	Non_Rtn_Cost	No
Total_cost	fin_amount	numeric(13)	Yes	Total_cost	No
org_Rep_BER_Cost	fin_amount	numeric(13)	Yes	org_Rep_BER_Cost	No
org_Exch_fee	fin_amount	numeric(13)	Yes	org_Exch_fee	No
org_Non_Rtn_Cost	fin_amount	numeric(13)	Yes	org_Non_Rtn_Cost	No
Exch_part_no	fin_partno	varchar(40)	Yes	Exch_part_no	No
Exch_mfr_part_no	fin_partno	varchar(40)	Yes	Exch_mfr_part_no	No
Exchpart_mfr_no	fin_vendorcode	varchar(45)	Yes	Exchpart_mfr_no	No
Exch_part_condition	fin_condition	varchar(15)	Yes	Exch_part_condition	No
Exch_Part_stk_status	fin_status	varchar(25)	Yes	Exch_Part_stk_status	No
Exch_Part_Ownership	fin_status	varchar(25)	Yes	Exch_Part_Ownership	No
Exch_Source_CO_no	fin_documentno	varchar(40)	Yes	Exch_Source_CO_no	No
excl_ref_cod	fin_flag	varchar(25)	Yes	excl_ref_cod	No
warranty_reco	fin_flag	varchar(25)	Yes	warranty_reco	No
doc_type	fin_type	varchar(25)	Yes	doc_type	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION_KEY	Yes
doc_erate	fin_exchangerate	numeric(9)	Yes	doc_erate	No
doc_amt_basecurr	fin_amount	numeric(13)	Yes	doc_amt_basecurr	No
custorder_no	fin_documentno	varchar(40)	Yes	custorder_no	No
refdoc_type	fin_documenttype	varchar(40)	Yes	refdoc_type	No
refdoc_no	fin_documentno	varchar(40)	Yes	refdoc_no	No
refdoc_lineno	fin_seqno	int(4)	Yes	refdoc_lineno	No

Table Name :	cso_part_serial_rel_dtl
Comment :	Part Serial Detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
process_id	fin_documentno	varchar(40)	Yes	Null	No
sub_process_id	fin_seqno	int(4)	Yes	Null	No
est_release_id	fin_documentno	varchar(40)	Yes	Null	No
exec_comm_id	fin_tasktrackid	bigint(8)	Yes	Null	No
task_track_id	fin_tasktrackid	bigint(8)	Yes	Null	No
exec_doc_no	fin_documentno	varchar(40)	Yes	Null	No
exec_doc_line_no	fin_lineno	int(4)	Yes	Null	No
exec_doc_type	fin_type	varchar(25)	Yes	Null	No
typeofsale	fin_quickcodes	varchar(25)	Yes	Null	No
part_no	fin_partno	varchar(40)	Yes	Null	No
part_serial_no	fin_partno	varchar(40)	Yes	Null	No
quantity	fin_quantity	numeric(17)	Yes	Null	No
part_condn	fin_quickcodes	varchar(25)	Yes	Null	No
part_status	fin_status	varchar(25)	Yes	Null	No
cost	fin_amount	numeric(13)	Yes	Null	No
custorder_curr	fin_currencycode	varchar(5)	Yes	Null	No
llp	fin_designparamcode	varchar(5)	Yes	Null	No
Repl_type	fin_designparamcode	varchar(5)	Yes	Null	No
part_type	fin_designparamcode	varchar(5)	Yes	Null	No
part_group	fin_desc40	varchar(40)	Yes	Null	No
part_class	fin_designparamcode	varchar(5)	Yes	Null	No
mfg_no	fin_vendorcode	varchar(45)	Yes	Null	No
mfg_partno	fin_partno	varchar(40)	Yes	Null	No
part_uom	fin_uom	varchar(15)	Yes	Null	No
factored_on	fin_designparamcode	varchar(5)	Yes	Null	No
Ref_catalog_id	fin_designparamcode	varchar(5)	Yes	Null	No
ref_ppl_no	fin_documentno	varchar(40)	Yes	Null	No
ref_ppl_revision	fin_int	int(4)	Yes	Null	No
ref_ppl_curr	fin_currencycode	varchar(5)	Yes	Null	No
base_adj_fact	fin_amount	numeric(13)	Yes	Null	No
price_fact	fin_amount	numeric(13)	Yes	Null	No
price_facton	fin_designparamcode	varchar(5)	Yes	Null	No
process_seq	fin_int	int(4)	Yes	Null	No
dir_ppl_curr	fin_currencycode	varchar(5)	Yes	Null	No
pric_basis	fin_basis	varchar(8)	Yes	Null	No
std_cost	fin_amount	numeric(13)	Yes	Null	No
billable_flag	fin_designparamcode	varchar(5)	Yes	Null	No
price	fin_amount	numeric(13)	Yes	Null	No
baseunit_rate	fin_amount	numeric(13)	Yes	Null	No
adjunit_rate	fin_amount	numeric(13)	Yes	Null	No
ext_amt_baseval	fin_amount	numeric(13)	Yes	Null	No
markup	fin_amount	numeric(13)	Yes	Null	No
markup_val	fin_amount	numeric(13)	Yes	Null	No
total_price	fin_amount	numeric(13)	Yes	Null	No
erate_co_curr	fin_exchangerate	numeric(9)	Yes	Null	No
adjunit_rate_cocurr	fin_amount	numeric(13)	Yes	Null	No
ext_amt_coval	fin_amount	numeric(13)	Yes	Null	No
markup_cocurr	fin_amount	numeric(13)	Yes	Null	No
markup_val_cocurr	fin_amount	numeric(13)	Yes	Null	No
total_price_cocurr	fin_amount	numeric(13)	Yes	Null	No
final_value	fin_amount	numeric(13)	Yes	Null	No
price_criteria	fin_flag	varchar(25)	Yes	Null	No
mult_criteria_match	fin_flag	varchar(25)	Yes	Null	No
matcount	fin_int	int(4)	Yes	Null	No
Price_desc	fin_notes	varchar(2000)	Yes	Null	No
price_notes	fin_notes	varchar(2000)	Yes	Null	No
sourceflag	fin_flag	varchar(25)	Yes	Null	No
pricing_disposition	fin_notes	varchar(2000)	Yes	Null	No
prorated	fin_quickcodes	varchar(25)	Yes	Null	No
serial_no	fin_partserialnumber	varchar(40)	Yes	Null	No
remaining_life	fin_conlimit	numeric(13)	Yes	Null	No
ultimate_life	fin_conlimit	numeric(13)	Yes	Null	No
exch_date	fin_date	datetime(8)	Yes	Null	No
component_id	fin_quickcodes	varchar(25)	Yes	Null	No
fact_price_notes	fin_notes	varchar(2000)	Yes	Null	No
ppl_dir_curr	fin_currencycode	varchar(5)	Yes	Null	No
updated_by	fin_ctxt_user	varchar(30)	Yes	Null	No
updated_date	fin_date	datetime(8)	Yes	Null	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Null	No
batch_id	fin_guid	varchar(40)	Yes	Null	No
proc_lineno	_bigint_8	Bigint(8)	No	Null	Yes
custorder_no	fin_documentno	varchar(40)	Yes	Null	No

Table Name :	cso_part_serial_rel_stage_dtl
Comment :	Commercial Service Part Serial Release Stage Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
process_id	fin_documentno	varchar(40)	No	process_id	No
sub_process_id	fin_seqno	int(4)	No	sub_process_id	No
ou_id	fin_ctxt_ouinstance	int(4)	No	ou_id	No
part_seq_no	fin_seqno	int(4)	No	part_seq_no	No
part_no	fin_partno	varchar(40)	No	part_no	No
serial_no	fin_partserialnumber	varchar(40)	Yes	serial_no	No
mfr_no	fin_vendorcode	varchar(45)	Yes	mfr_no	No
lot_no	fin_lotno	varchar(18)	Yes	lot_no	No
mfr_part_no	fin_partno	varchar(40)	Yes	mfr_part_no	No
mfr_lot_no	fin_lotno	varchar(18)	Yes	mfr_lot_no	No
uom	fin_uom	varchar(15)	Yes	uom	No
total_life	fin_conlimit	numeric(13)	Yes	total_life	No
remaining_life	fin_conlimit	numeric(13)	Yes	remaining_life	No
part_amount	fin_amount	numeric(13)	Yes	part_amount	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION_KEY	Yes
est_release_id	fin_documentno	varchar(40)	Yes	Null	No
exec_comm_id	fin_tasktrackid	bigint(8)	Yes	Null	No
task_track_id	fin_tasktrackid	bigint(8)	Yes	Null	No
exec_doc_no	fin_documentno	varchar(40)	Yes	Null	No
exec_doc_line_no	fin_lineno	int(4)	Yes	Null	No
exec_doc_type	fin_type	varchar(25)	Yes	Null	No
typeofsale	fin_quickcodes	varchar(25)	Yes	Null	No
part_serial_no	fin_partno	varchar(40)	Yes	Null	No
quantity	fin_quantity	numeric(17)	Yes	Null	No
part_condn	fin_quickcodes	varchar(25)	Yes	Null	No
part_status	fin_status	varchar(25)	Yes	Null	No
cost	fin_amount	numeric(13)	Yes	Null	No

Table Name :	cso_qty_dtl
Comment :	To Update the Quantities of given Customer Order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_ord_no	fin_documentnumber	varchar(18)	No	Customer Order #	Yes
cso_od_seqno	fin_seqno	int(4)	No	Customer Order Seqno	Yes
cso_doc_no	fin_refdocno	varchar(40)	No	Execution Document #	Yes
cso_doc_type	fin_refdocutype	varchar(12)	Yes	Execution Document Type	No
cso_co_lineno	fin_lineno	int(4)	Yes	Objlineno	No
cso_partno	fin_partno	varchar(40)	Yes	Part #	No
cso_msnslno	fin_partserialnumber	varchar(40)	Yes	Mfr Serial #	No
cso_mlotno	fin_partserialnumber	varchar(40)	Yes	Mfr Lot #	No
cso_qty	fin_quantity	numeric(17)	Yes	Quantity	No
cso_source	fin_designparamcode	varchar(5)	No	Source Flag	Yes
cso_flag	fin_flag	varchar(25)	Yes	Quantity Flag	No
cso_crddt	fin_datetime	datetime(8)	Yes	Created Date	No
cso_crby	fin_ctxt_user	varchar(30)	Yes	Created By	No
cso_modby	fin_ctxt_user	varchar(30)	Yes	Modified Date	No
cso_moddt	fin_datetime	datetime(8)	Yes	Modified By	No
cso_ou	fin_ctxt_ouinstance	int(4)	Yes	OuInstance	No
cso_remarks	fin_remarks	varchar(100)	Yes	Remarks	No

Table Name :	cso_rac_add_chrg_dtl
Comment :	Customer Order additional Charge d

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_rac_order_no	fin_documentnumber	varchar(18)	No	Customer Order Number	Yes
cso_rac_tcd_code	fin_tcdcodes	varchar(25)	No	Tcd Number	Yes
cso_rac_variant	fin_itemtcd	varchar(40)	No	Varaint Number	Yes
cso_rac_ou_id	fin_ctxt_ouinstance	int(4)	No	Ou id	Yes
cso_rac_ref_doc_type	fin_refdocutype	varchar(12)	Yes	DocumentType	No
cso_rac_ref_doc_no	fin_documentno	varchar(40)	Yes	DocumentNumber	No
cso_rac_taskseq_no	fin_lineno	int(4)	Yes	Task Sequence Number	No
cso_rac_task_no	fin_taskno	varchar(40)	Yes	TaskNumber	No
cso_rac_billable	fin_designparamcode	varchar(5)	Yes	Billable Flag	No
cso_rac_tcd_amount	fin_amount	numeric(13)	Yes	Amount	No
cso_rac_tcd_curr	fin_currencycode	varchar(5)	Yes	Currency	No
cso_rac_accusg	fin_usageid	varchar(20)	Yes	Account Usage	No
cso_rac_cost_center	fin_maccost	varchar(32)	Yes	Costcenter	No
cso_rac_remarks	fin_comments	varchar(256)	Yes	Remarks	No
cso_rac_crby	fin_ctxt_user	varchar(30)	Yes	CreatedBy	No
cso_rac_crdt	fin_date	datetime(8)	Yes	CreatedDate	No
cso_rac_modby	fin_ctxt_user	varchar(30)	Yes	ModifiedBy	No
cso_rac_moddt	fin_date	datetime(8)	Yes	ModifiedDate	No
cso_rac_charglevel	fin_designparamcode	varchar(5)	Yes	ChargeLevel	No
cso_rac_desc	fin_comments	varchar(256)	Yes	Description	No
cso_rac_tsktrack_id	fin_tasktrackid	bigint(8)	No	Tasktrackid	Yes
cso_rac_invoiced	fin_designparamcode	varchar(5)	Yes	Invoiced flag	No
cso_rac_quoted	fin_designparamcode	varchar(5)	Yes	Quoted	No
CSO_RAC_Rate	fin_amount	numeric(13)	Yes	Rate	No
CSO_RAC_Markup	fin_amount	numeric(13)	Yes	Markup	No
CSO_RAC_Pricefactor	fin_amount	numeric(13)	Yes	Pricefactor	No

Table Name :	cso_resource_rel_dtl
Comment :	Commercial Service Resource Release Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
process_id	fin_documentno	varchar(40)	Yes	process_id	No
sub_process_id	fin_seqno	int(4)	Yes	sub_process_id	No
resource_seq_no	fin_seqno	int(4)	Yes	resource_seq_no	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	ou_id	No
resource_code	fin_resourcecode	varchar(40)	Yes	resource_code	No
resource_type	fin_resourcetype	varchar(25)	Yes	resource_type	No
est_remarks	fin_notes	varchar(2000)	Yes	est_remarks	No
warranty_reco	fin_checkflag	int(4)	Yes	warranty_reco	No
estimated_qty	fin_quantity	numeric(17)	Yes	estimated_qty	No
estimated_uom	fin_uom	varchar(15)	Yes	estimated_uom	No
repair_class	fin_repairclassification	varchar(25)	Yes	repair_class	No
confirmed_qty	fin_quantity	numeric(17)	Yes	confirmed_qty	No
pric_basis	fin_enum_cd	varchar(5)	Yes	pric_basis	No
custorder_no	fin_documentnumber	varchar(18)	Yes	custorder_no	No
custord_curr	fin_currencycode	varchar(5)	Yes	custord_curr	No
spl_no	fin_documentno	varchar(40)	Yes	spl_no	No
spl_revno	fin_int	int(4)	Yes	spl_revno	No
spl_ou	fin_ctxt_ouinstance	int(4)	Yes	spl_ou	No
aircraft_model	fin_model	varchar(20)	Yes	aircraft_model	No
work_center	fin_workcenter	varchar(80)	Yes	work_center	No
pric_method	fin_designparamcode	varchar(5)	Yes	pric_method	No
spl_lineno	fin_int	int(4)	Yes	spl_lineno	No
rate_uom	fin_uom	varchar(15)	Yes	rate_uom	No
priceperhr_splcurr	fin_currencycode	varchar(5)	Yes	priceperhr_splcurr	No
price_splcurr	fin_amount	numeric(13)	Yes	price_splcurr	No
erate_spl_co_curr	fin_exchangerate	numeric(9)	Yes	erate_spl_co_curr	No
price_cocurr	fin_amount	numeric(13)	Yes	price_cocurr	No
pricing_notes	fin_notes	varchar(2000)	Yes	pricing_notes	No
coa	fin_designparamcode	varchar(5)	Yes	coa	No
res_desc	fin_description	varchar(100)	Yes	res_desc	No
cap_flag	fin_checkflag	int(4)	Yes	cap_flag	No
resource_cost	fin_amount	numeric(13)	Yes	resource_cost	No
billable	fin_designparamcode	varchar(5)	Yes	billable	No
inc_exc_ref_cod	fin_effectivitycode	varchar(40)	Yes	inc_exc_ref_cod	No
res_hrs_source	fin_designparamcode	varchar(5)	Yes	res_hrs_source	No
res_hrs	fin_quantity	numeric(17)	Yes	res_hrs	No
rate_perhr	fin_amount	numeric(13)	Yes	rate_perhr	No
pricing_disposition	fin_notes	varchar(2000)	Yes	pricing_disposition	No
updated_by	fin_ctxt_user	varchar(30)	Yes	updated_by	No
updated_date	fin_date	datetime(8)	Yes	updated_date	No
proc_lineno	_bigint_8	Bigint(8)	Yes	proc_lineno	No
spl_nmrate_perhr	fin_amount	numeric(13)	Yes	spl_nmrate_perhr	No
spl_ovrate_perhr	fin_amount	numeric(13)	Yes	spl_ovrate_perhr	No
ref_att_type	fin_type	varchar(25)	Yes	ref_att_type	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION_KEY	Yes
orginal_pric_basis	fin_enum_cd	varchar(5)	Yes	orginal pricing basis	No
batch_id	fin_guid	varchar(40)	Yes	batchid	No

Table Name :	cso_resource_rel_stage_dtl
Comment :	Commercial Service Resource Release Stage Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ouinstanceid	fin_ctxt_ouinstance	int(4)	No	ouinstanceid	No
process_id	fin_documentno	varchar(40)	No	process_id	No
sub_process_id	fin_seqno	int(4)	No	sub_process_id	No
resource_seq_no	fin_seqno	int(4)	No	resource_seq_no	No
resource_code	fin_resourcecode	varchar(40)	Yes	resource_code	No
resource_type	fin_resourcetype	varchar(25)	Yes	resource_type	No
estimation_remarks	fin_notes	varchar(2000)	Yes	estimation_remarks	No
warranty_reco	fin_checkflag	int(4)	Yes	warranty_reco	No
estimated_qty	fin_quantity	numeric(17)	Yes	estimated_qty	No
estimated_uom	fin_uom	varchar(15)	Yes	estimated_uom	No
repair_class	fin_repairclassification	varchar(25)	Yes	repair_class	No
confirmed_qty	fin_quantity	numeric(17)	Yes	confirmed_qty	No
resource_cost	fin_amount	numeric(13)	Yes	resource_cost	No
ref_att_type	fin_type	varchar(25)	Yes	ref_att_type	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	cso_routdoc_map
Comment :	Customer Service Order - Execution Document mapping details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_od_ord_no	fin_documentnumber	varchar(18)	No	Customer Order Number	Yes
cso_od_routdoc_type	fin_refdocutype	varchar(12)	No	Route Document Type	No
cso_od_routdoc_no	fin_refdocno	varchar(40)	No	Route Document Number	No
cso_od_objline_no	fin_lineno	int(4)	No	Object Eff.Line number	Yes
cso_od_ou_id	fin_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
cso_od_rout_qty	fin_quantity	numeric(17)	Yes	Routing Quantity	No
cso_od_uom	fin_uom	varchar(15)	Yes	UOM	No
cso_od_crdt	fin_date	datetime(8)	Yes	Craeted Date	No
cso_od_crby	fin_ctxt_user	varchar(30)	Yes	Created By	No
cso_od_moddt	fin_date	datetime(8)	Yes	Modified Date	No
cso_od_modby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
cso_od_seqno	fin_seqno	int(4)	No	Sequence number	Yes

Table Name :	cso_sb_shipbill_dtl
Comment :	Customer service Order Shipping/Billing Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_sb_order_no	fin_documentnumber	varchar(18)	No	Customer Order Number	Yes
cso_sb_ou_id	fin_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
cso_sb_addr_type	fin_designparamcode	varchar(5)	No	Address Type	Yes
cso_sb_cust_id	fin_customer_id	varchar(18)	Yes	Customer ID	No
cso_sb_add_id	fin_addressid	varchar(12)	Yes	AddressID	No
cso_sb_add1	fin_address	varchar(40)	Yes	Address 1	No
cso_sb_add2	fin_address	varchar(40)	Yes	Address 2	No
cso_sb_add3	fin_address	varchar(40)	Yes	Address 3	No
cso_sb_city	fin_city	varchar(40)	Yes	City	No
cso_sb_zip	fin_zip	varchar(20)	Yes	Zip Code	No
cso_sb_state	fin_state	varchar(40)	Yes	State	No
cso_sb_country	fin_country	varchar(40)	Yes	Country	No
cso_sb_phone_no	fin_phone	varchar(18)	Yes	Phone number	No
cso_sb_email	fin_email	varchar(60)	Yes	E-mail	No
cso_sb_fax	fin_fax	varchar(40)	Yes	Fax	No
cso_sb_delarea	fin_delareadesc	varchar(25)	Yes	Delivery Area	No
cso_sb_custcon_per	fin_contactperson	varchar(80)	Yes	Customer Contact Person	No

Table Name :	cso_sb_shipbill_dtl_hist
Comment :	Customer service Order Shipping/Billing Details History

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_sb_order_no	fin_documentnumber	varchar(18)	No	Customer Order Number	Yes
cso_sb_ou_id	fin_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
cso_sb_addr_type	fin_designparamcode	varchar(5)	No	Address Type	Yes
cso_sb_cust_id	fin_customer_id	varchar(18)	Yes	Customer ID	No
cso_sb_add_id	fin_addressid	varchar(12)	Yes	AddressID	No
cso_sb_add1	fin_address	varchar(40)	Yes	Address 1	No
cso_sb_add2	fin_address	varchar(40)	Yes	Address 2	No
cso_sb_add3	fin_address	varchar(40)	Yes	Address 3	No
cso_sb_city	fin_city	varchar(40)	Yes	City	No
cso_sb_zip	fin_zip	varchar(20)	Yes	Zip Code	No
cso_sb_state	fin_state	varchar(40)	Yes	State	No
cso_sb_country	fin_country	varchar(40)	Yes	Country	No
cso_sb_phone_no	fin_phone	varchar(18)	Yes	Phone number	No
cso_sb_email	fin_email	varchar(60)	Yes	E-mail	No
cso_sb_fax	fin_fax	varchar(40)	Yes	Fax	No
cso_sb_delarea	fin_delareadesc	varchar(25)	Yes	Delivery Area	No
cso_sb_rev_no	fin_rev_no	int(4)	No	Customer Order Revision Number	Yes
cso_sb_custcon_per	fin_contactperson	varchar(80)	Yes	Customer Contact Person	No

Table Name :	cso_task_rel_dtl
Comment :	Customer Service order Task Release Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
process_id	fin_documentno	varchar(40)	Yes	process_id	No
sub_process_id	fin_seqno	int(4)	Yes	sub_process_id	No
est_release_id	fin_documentno	varchar(40)	Yes	est_release_id	No
exec_comm_id	fin_documentno	varchar(40)	Yes	exec_comm_id	No
task_track_id	fin_tasktrackid	bigint(8)	Yes	task_track_id	No
exec_doc_no	fin_documentno	varchar(40)	Yes	exec_doc_no	No
exec_doc_line_no	fin_lineno	int(4)	Yes	exec_doc_line_no	No
exec_doc_type	fin_type	varchar(25)	Yes	exec_doc_type	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	ou_id	No
task_flag	fin_checkflag	int(4)	Yes	task_flag	No
est_remarks	fin_notes	varchar(2000)	Yes	est_remarks	No
exec_doc_status	fin_status	varchar(25)	Yes	exec_doc_status	No
wbs_code	fin_quickcodes	varchar(25)	Yes	wbs_code	No
primary_task_no	fin_taskno	varchar(40)	Yes	primary_task_no	No
root_task_no	fin_taskno	varchar(40)	Yes	root_task_no	No
task_type	fin_tasktype	varchar(25)	Yes	task_type	No
task_status	fin_status	varchar(25)	Yes	task_status	No
wbs_level	fin_checkflag	int(4)	Yes	wbs_level	No
mfr_no	fin_vendorcode	varchar(45)	Yes	mfr_no	No
mfr_part_no	fin_partno	varchar(40)	Yes	mfr_part_no	No
parent_wo_no	fin_documentno	varchar(40)	Yes	parent_wo_no	No
part_no	fin_partno	varchar(40)	Yes	part_no	No
part_serial_no	fin_partserialnumber	varchar(40)	Yes	part_serial_no	No
repair_class	fin_repairclassification	varchar(25)	Yes	repair_class	No
repair_process_code	fin_repairprocesscode	varchar(25)	Yes	repair_process_code	No
warranty_reco	fin_checkflag	int(4)	Yes	warranty_reco	No
task_desc	fin_item_desc	varchar(150)	Yes	task_desc	No
root_task_desc	fin_item_desc	varchar(150)	Yes	root_task_desc	No
part_desc	fin_item_desc	varchar(150)	Yes	part_desc	No
parent_task_desc	fin_item_desc	varchar(150)	Yes	parent_task_desc	No
task_release_status	fin_status	varchar(25)	Yes	task_release_status	No
release_event	fin_event	varchar(40)	Yes	release_event	No
release_type	fin_type	varchar(25)	Yes	release_type	No
mat_pric_basis	fin_enum_cd	varchar(5)	Yes	mat_pric_basis	No
res_pric_basis	fin_enum_cd	varchar(5)	Yes	res_pric_basis	No
othres_pric_basis	fin_enum_cd	varchar(5)	Yes	othres_pric_basis	No
tsk_pric_basis	fin_enum_cd	varchar(5)	Yes	tsk_pric_basis	No
priced_flag	fin_enum_cd	varchar(5)	Yes	priced_flag	No
custorder_no	fin_documentno	varchar(40)	Yes	custorder_no	No
custorder_curr	fin_currencycode	varchar(5)	Yes	custorder_curr	No
eff_ref_cd	fin_quickcodes	varchar(25)	Yes	eff_ref_cd	No
quotable_status	fin_status	varchar(25)	Yes	quotable_status	No
lot_no	fin_lotno	varchar(18)	Yes	lot_no	No
billable	fin_enum_cd	varchar(5)	Yes	billable	No
priced_task_no	fin_taskno	varchar(40)	Yes	priced_task_no	No
mat_excl_pric_basis	fin_enum_cd	varchar(5)	Yes	mat_excl_pric_basis	No
res_excl_pric_basis	fin_enum_cd	varchar(5)	Yes	res_excl_pric_basis	No
othres_excl_pric_basis	fin_enum_cd	varchar(5)	Yes	othres_excl_pric_basis	No
mfr_lot_no	fin_lotno	varchar(18)	Yes	mfr_lot_no	No
task_seqno	fin_seqno	int(4)	Yes	task_seqno	No
aircraft_reg_no	fin_acregno	varchar(30)	Yes	aircraft_reg_no	No
task_no	fin_taskno	varchar(40)	Yes	task_no	No
invoice_status	fin_designparamcode	varchar(5)	Yes	invoice_status	No
coa	fin_designparamcode	varchar(5)	Yes	coa	No
coverage	fin_checkflag	int(4)	Yes	coverage	No
coverage_ttrackid	fin_tasktrackid	bigint(8)	Yes	coverage_ttrackid	No
est_inst_id	fin_seqno	int(4)	Yes	est_inst_id	No
incl_excl_flag	fin_checkflag	int(4)	Yes	incl_excl_flag	No
inclusion_code	fin_effectivitycode	varchar(40)	Yes	inclusion_code	No
exclusion_code	fin_effectivitycode	varchar(40)	Yes	exclusion_code	No
inclusion_line_no	fin_lineno	int(4)	Yes	inclusion_line_no	No
exclusion_line_no	fin_lineno	int(4)	Yes	exclusion_line_no	No
incl_notes	fin_notes	varchar(2000)	Yes	incl_notes	No
excl_notes	fin_notes	varchar(2000)	Yes	excl_notes	No
workcenter	fin_workcenter	varchar(80)	Yes	workcenter	No
updated_by	fin_ctxt_user	varchar(30)	Yes	updated_by	No
updated_date	fin_date	datetime(8)	Yes	updated_date	No
tsk_org_pric_basis	fin_enum_cd	varchar(5)	Yes	tsk_org_pric_basis	No
tsk_obj_pb	fin_enum_cd	varchar(5)	Yes	tsk_obj_pb	No
tsk_obj_fx_dfn_fr	fin_enum_cd	varchar(5)	Yes	tsk_obj_fx_dfn_fr	No
exec_cat	fin_quickcodes	varchar(25)	Yes	exec_cat	No
effectivity_code	fin_effectivitycode	varchar(40)	Yes	effectivity_code	No
work_scope_code	fin_effectivitycode	varchar(40)	Yes	work_scope_code	No
proc_lineno	_bigint_8	Bigint(8)	Yes	proc_lineno	No
material_price	fin_amount	numeric(13)	Yes	material_price	No
resource_price	fin_amount	numeric(13)	Yes	resource_price	No
other_price	fin_amount	numeric(13)	Yes	other_price	No
fixed_price	fin_amount	numeric(13)	Yes	fixed_price	No
total_task_price	fin_amount	numeric(13)	Yes	total_task_price	No
quot_thresh_detr_flag	fin_flag	varchar(25)	Yes	quot_thresh_detr_flag	No
hierarchy_id	_hierarchyid_0	Int(4)	Yes	hierarchy_id	No
nonbill_pricing_notes	fin_notes	varchar(2000)	Yes	nonbill_pricing_notes	No
fixed_price_for	fin_quickcodes	varchar(25)	Yes	fixed_price_for	No
tsk_ref_date	fin_date	datetime(8)	Yes	tsk_ref_date	No
tsk_src_docno	fin_documentno	varchar(40)	Yes	tsk_src_docno	No
batch_id	fin_guid	varchar(40)	Yes	batch_id	No
serprlist	fin_documentno	varchar(40)	Yes	serprlist	No
exch_type	fin_type	varchar(25)	Yes	exch_type	No
entity	fin_enum_cd	varchar(5)	Yes	entity	No
exch_init_refdoc_type	fin_type	varchar(25)	Yes	exch_init_refdoc_type	No
exch_init_refdoc_no	fin_documentno	varchar(40)	Yes	exch_init_refdoc_no	No
exch_init_as	fin_enum_cd	varchar(5)	Yes	exch_init_as	No
reason_exch	fin_quickcodes	varchar(25)	Yes	reason_exch	No
exch_mr_no	fin_documentno	varchar(40)	Yes	exch_mr_no	No
exch_chargabl	fin_quickcodes	varchar(25)	Yes	exch_chargabl	No
work_scope_notes	fin_notes	varchar(2000)	Yes	work_scope_notes	No
custorder_eff_ref_cd	fin_effectivitycode	varchar(40)	Yes	custorder_eff_ref_cd	No
custorder_eff_ref_lineno	fin_lineno	int(4)	Yes	custorder_eff_ref_lineno	No
discrepancy_type	fin_designparamcode	varchar(5)	Yes	discrepancy_type	No
discrepancy_category	fin_quickcodes	varchar(25)	Yes	discrepancy_category	No
discrepancy_Rep_class	fin_repairclassification	varchar(25)	Yes	discrepancy_Rep_class	No
disctsk_flag	fin_flag	varchar(25)	Yes	disctsk_flag	No
parent_tsk_trackid	fin_tasktrackid	bigint(8)	Yes	parent_tsk_trackid	No
root_tsk_trackid	fin_tasktrackid	bigint(8)	Yes	root_tsk_trackid	No
pricingtsk_trackid	fin_tasktrackid	bigint(8)	Yes	pricingtsk_trackid	No
prim_workcenter	fin_workcenter	varchar(80)	Yes	prim_workcenter	No
pricdtask_flg	fin_flag	varchar(25)	Yes	Pricicng task	No

Table Name :	cso_task_rel_stage_dtl
Comment :	Customer Service order Task Release Stage Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ouinstanceid	fin_ctxt_ouinstance	int(4)	No	ouinstanceid	No
process_id	fin_documentno	varchar(40)	No	process_id	No
sub_process_id	fin_seqno	int(4)	No	sub_process_id	No
exec_comm_id	fin_documentno	varchar(40)	No	exec_comm_id	No
est_release_id	fin_documentno	varchar(40)	Yes	est_release_id	No
task_track_id	fin_tasktrackid	bigint(8)	Yes	task_track_id	No
est_instance_id	fin_seqno	int(4)	Yes	est_instance_id	No
exec_doc_no	fin_documentno	varchar(40)	Yes	exec_doc_no	No
exec_doc_line_no	fin_lineno	int(4)	Yes	exec_doc_line_no	No
exec_doc_type	fin_type	varchar(25)	Yes	exec_doc_type	No
task_flag	fin_checkflag	int(4)	Yes	task_flag	No
estmation_remarks	fin_notes	varchar(2000)	Yes	estmation_remarks	No
exec_doc_status	fin_status	varchar(25)	Yes	exec_doc_status	No
wbs_code	fin_quickcodes	varchar(25)	Yes	wbs_code	No
primary_task_no	fin_taskno	varchar(40)	Yes	primary_task_no	No
root_task_no	fin_taskno	varchar(40)	Yes	root_task_no	No
task_type	fin_tasktype	varchar(25)	Yes	task_type	No
task_status	fin_status	varchar(25)	Yes	task_status	No
wbs_level	fin_checkflag	int(4)	Yes	wbs_level	No
mfr_no	fin_vendorcode	varchar(45)	Yes	mfr_no	No
mfr_part_no	fin_partno	varchar(40)	Yes	mfr_part_no	No
parent_wo_no	fin_documentno	varchar(40)	Yes	parent_wo_no	No
part_no	fin_partno	varchar(40)	Yes	part_no	No
part_serial_no	fin_partserialnumber	varchar(40)	Yes	part_serial_no	No
repari_class	fin_repairclassification	varchar(25)	Yes	repari_class	No
repair_process_code	fin_repairprocesscode	varchar(25)	Yes	repair_process_code	No
warranty_reco	fin_checkflag	int(4)	Yes	warranty_reco	No
task_desc	fin_item_desc	varchar(150)	Yes	task_desc	No
root_task_desc	fin_item_desc	varchar(150)	Yes	root_task_desc	No
part_desc	fin_item_desc	varchar(150)	Yes	part_desc	No
parent_task_desc	fin_item_desc	varchar(150)	Yes	parent_task_desc	No
task_release_status	fin_status	varchar(25)	Yes	task_release_status	No
release_event	fin_event	varchar(40)	Yes	release_event	No
release_type	fin_type	varchar(25)	Yes	release_type	No
task_no	fin_taskno	varchar(40)	Yes	task_no	No
parent_task_no	fin_taskno	varchar(40)	Yes	parent_task_no	No
hierarchy_id	_hierarchyid_0	Int(4)	Yes	hierarchy_id	No
createdby	fin_ctxt_user	varchar(30)	Yes	createdby	No
createddate	fin_date	datetime(8)	Yes	createddate	No
workcenter	fin_workcenter	varchar(80)	Yes	workcenter	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION_KEY	Yes
tsk_ref_date	fin_date	datetime(8)	Yes	tsk_ref_date	No
tsk_src_docno	fin_documentno	varchar(40)	Yes	tsk_src_docno	No
exch_type	fin_type	varchar(25)	Yes	exch_type	No
entity	fin_enum_cd	varchar(5)	Yes	entity	No
exch_init_refdoc_type	fin_type	varchar(25)	Yes	exch_init_refdoc_type	No
exch_init_refdoc_no	fin_documentno	varchar(40)	Yes	exch_init_refdoc_no	No
exch_init_as	fin_enum_cd	varchar(5)	Yes	exch_init_as	No
reason_exch	fin_quickcodes	varchar(25)	Yes	reason_exch	No
exch_mr_no	fin_documentno	varchar(40)	Yes	exch_mr_no	No
prim_workcenter	fin_workcenter	varchar(80)	Yes	prim_workcenter	No

Table Name :	cso_tcd_ordtcd
Comment :	Customer Service order TCD Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_tcd_ord_no	fin_documentnumber	varchar(18)	No	Customer Order Number	Yes
cso_tcd_efffr	fin_date	datetime(8)	Yes	Effective From Date	No
cso_tcd_tcd_code	fin_tcdcodes	varchar(25)	No	Tcd Number	Yes
cso_tcd_variant	fin_itemtcd	varchar(40)	No	Variant Number	Yes
cso_tcd_ou_id	fin_flag	varchar(25)	No	Ou Instance	Yes
cso_tcd_rate	fin_rate	numeric(13)	Yes	TCD Rate	No
cso_tcd_curr	fin_currencycode	varchar(5)	Yes	Currency	No
cso_tcd_appon	fin_designparamcode	varchar(5)	Yes	AppliedOn	No
cso_tcd_cc_app	fin_designparamcode	varchar(5)	Yes	CostCenter Applicablity	No
cso_tcd_cost_center	fin_maccost	varchar(32)	Yes	CostCenter	No
cso_tcd_billable	fin_designparamcode	varchar(5)	Yes	Billable Flag	No
cso_tcd_pay_to_supp	fin_vendorcode	varchar(45)	Yes	Payto supplier Number	No
cso_tcd_effto	fin_date	datetime(8)	Yes	Effective To Date	No
cso_tcd_source	fin_designparamcode	varchar(5)	Yes	TCD Source	No
cso_tcd_lineno	fin_rowno	int(4)	Yes	Line Number	No
cso_tcd_quoted	fin_flag	varchar(25)	Yes	Tcd Quote exists flag	No
cso_tcd_invoiced	fin_flag	varchar(25)	Yes	Tcd invoice exists flag	No

Table Name :	cso_tcd_ordtcd_hist
Comment :	Customer Service order TCD Details History

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_tcd_ord_no	fin_documentnumber	varchar(18)	No	Customer Order Number	Yes
cso_tcd_efffr	fin_date	datetime(8)	Yes	Effective From Date	No
cso_tcd_tcd_code	fin_tcdcodes	varchar(25)	No	Tcd Number	Yes
cso_tcd_variant	fin_itemtcd	varchar(40)	No	Variant Number	Yes
cso_tcd_ou_id	fin_ctxt_ouinstance	int(4)	No	Ou Instance	Yes
cso_tcd_rate	fin_rate	numeric(13)	Yes	TCD Rate	No
cso_tcd_curr	fin_currencycode	varchar(5)	Yes	Currency	No
cso_tcd_appon	fin_designparamcode	varchar(5)	Yes	AppliedOn	No
cso_tcd_cc_app	fin_designparamcode	varchar(5)	Yes	CostCenter Applicablity	No
cso_tcd_cost_center	fin_maccost	varchar(32)	Yes	CostCenter	No
cso_tcd_billable	fin_designparamcode	varchar(5)	Yes	Billable Flag	No
cso_tcd_pay_to_supp	fin_vendorcode	varchar(45)	Yes	Payto supplier Number	No
cso_tcd_effto	fin_date	datetime(8)	Yes	Effective To Date	No
cso_tcd_source	fin_designparamcode	varchar(5)	Yes	TCD Source	No
cso_tcd_rev_no	fin_rev_no	int(4)	No	Customer Order Revision Number	Yes
cso_tcd_lineno	fin_rowno	int(4)	Yes	Line Number	No
cso_tcd_invoiced	fin_flag	varchar(25)	Yes	Quote exists flag	No
cso_tcd_quoted	fin_flag	varchar(25)	Yes	invoice exists flag	No

Table Name :	cso_tsk_cost_dtl
Comment :	Customer Service Order Task Cost Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_quot_no	fin_documentno	varchar(40)	Yes	Quotation Number	No
cso_quot_rev_no	fin_int	int(4)	Yes	Quotation Revision Number	No
cso_quote_line_no	fin_int	int(4)	Yes	Quotation Line Number	No
cso_ouinst_id	fin_int	int(4)	Yes	Organisational Unit	No
cso_timestamp	fin_int	int(4)	Yes	TimeStamp	No
cso_quote_indicator	fin_documentno	varchar(40)	Yes	Quotation Indicator	No
cso_rev_reference	fin_documentno	varchar(40)	Yes	Revision Reference	No
cso_task_no	fin_documentno	varchar(40)	Yes	Task Number	No
cso_task_seq_no	fin_seqno	int(4)	Yes	Task Sequence Number	No
cso_task_track_id	fin_documentno	varchar(40)	Yes	Task Track Id	No
cso_exec_doc_no	fin_documentno	varchar(40)	Yes	Execution Document	No
cso_exec_doc_line_no	fin_lineno	int(4)	Yes	Execution Document Line Number	No
cso_exec_doc_type	fin_doctype	varchar(40)	Yes	Execution Document Type	No
cso_part_no	fin_partno	varchar(40)	Yes	Part Number	No
cso_mfr_no	fin_partno	varchar(40)	Yes	Manufacturer Number	No
cso_mfr_part_no	fin_partno	varchar(40)	Yes	Manufacturer Part Number	No
cso_pricing_element	fin_description	varchar(100)	Yes	Pricing Element	No
cso_entity	fin_description	varchar(100)	Yes	Entity	No
cso_entityno	fin_description	varchar(100)	Yes	Entity Number	No
cso_mat_est_qty	fin_quantity	numeric(17)	Yes	Material Estimaes Quantity	No
cso_mat_uom	fin_uom	varchar(15)	Yes	Material Unit of Measurement	No
cso_mat_unit_rate	fin_rate	numeric(13)	Yes	Material Unit Rate	No
cso_mat_cost	fin_amount	numeric(13)	Yes	Material Cost	No
cso_tsk_attrib	fin_description	varchar(100)	Yes	Task Attribute	No
cso_cst_rematks	fin_remarks	varchar(100)	Yes	Customer Remarks	No
cso_pplno	fin_documentno	varchar(40)	Yes	Part Price List Number	No
replication_key	uniqueidentifier	Varchar(160)	No	Replication Key	Yes

Table Name :	cso_val_othdocinfo_dtl
Comment :	offine line pricing other doc info table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_guid	fin_guid	varchar(40)	Yes	guid	No
cso_ou	fin_ctxt_ouinstance	int(4)	Yes	ou instance	No
cso_ordno	fin_documentno	varchar(40)	Yes	customer order #	No
cso_seqno	fin_seqno	int(4)	Yes	sequence #	No
cso_ordrevno	fin_rev_no	int(4)	Yes	customer order revision #	No
cso_execdocno	fin_documentno	varchar(40)	Yes	Execution Doc #	No
cso_execdoctype	fin_type	varchar(25)	Yes	Execution Doc type	No
cso_execdoclineno	fin_lineno	int(4)	Yes	Execution Doc Line #	No
cso_eststatus	fin_status	varchar(25)	Yes	estimation status	No
cso_relno	fin_seqno	int(4)	Yes	release #	No
cso_quotno	fin_documentno	varchar(40)	Yes	quotation #	No
cso_quotamendno	fin_rev_no	int(4)	Yes	quotation rev #	No
cso_doc_status	fin_status	varchar(25)	Yes	document status	No
cso_supplier_no	fin_vendorcode	varchar(45)	Yes	supplier #	No
cso_supplier_name	fin_name	varchar(60)	Yes	supplier Name	No
cso_doc_curr	fin_currency	varchar(5)	Yes	document currency	No
cso_doc_amount	fin_amount	numeric(13)	Yes	document amount	No
cso_workcenter	fin_workcenter	varchar(80)	Yes	work center #	No
cso_repair_class	fin_repairclassification	varchar(25)	Yes	repairclassification	No
cso_warranty_reco	fin_checkflag	int(4)	Yes	warrenty	No
cso_repair_process_code	fin_repairprocesscode	varchar(25)	Yes	repair process code	No
cso_revrec_oth_amt	fin_amount	numeric(13)	Yes	recon. Other doc amount	No
cso_revrec_tot_amt	fin_amount	numeric(13)	Yes	recon. Other doc total amount	No
cso_doc_amt_basecurr	fin_amount	numeric(13)	Yes	document base amount	No
cso_othdoccur_amt	fin_amount	numeric(13)	Yes	document oth currency	No
cso_source	fin_flag	varchar(25)	Yes	source	No
cso_execdoc_status	fin_status	varchar(25)	Yes	execdocument stauts	No
cso_aircraft_reg_no	fin_acregno	varchar(30)	Yes	aircraft reg. #	No
cso_contract_no	fin_documentno	varchar(40)	Yes	contract #	No
cso_contract_rev_no	fin_rev_no	int(4)	Yes	contract rev#	No
cso_custorder_curr	fin_currency	varchar(5)	Yes	customer order currency	No
cso_doc_type	fin_type	varchar(25)	Yes	document type	No
cso_doc_no	fin_documentno	varchar(40)	Yes	document #	No
cso_amend_no	fin_seqno	int(4)	Yes	amend #	No
cso_category	fin_category	varchar(15)	Yes	category	No
cso_custno	fin_customer_id	varchar(18)	Yes	customer #	No
cso_invbasis	fin_basis	varchar(8)	Yes	invoice basis	No

Table Name :	cso_val_othdocinfo_dtl_hist
Comment :	offine line pricing other doc info table history

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_guid	fin_guid	varchar(40)	Yes	guid	No
cso_ou	fin_ctxt_ouinstance	int(4)	Yes	ou instance	No
cso_ordno	fin_documentno	varchar(40)	Yes	customer order #	No
cso_seqno	fin_seqno	int(4)	Yes	sequence #	No
cso_ordrevno	fin_rev_no	int(4)	Yes	customer order revision #	No
cso_execdocno	fin_documentno	varchar(40)	Yes	Execution Doc #	No
cso_execdoctype	fin_type	varchar(25)	Yes	Execution Doc type	No
cso_execdoclineno	fin_lineno	int(4)	Yes	Execution Doc Line #	No
cso_eststatus	fin_status	varchar(25)	Yes	estimation status	No
cso_relno	fin_seqno	int(4)	Yes	release #	No
cso_quotno	fin_documentno	varchar(40)	Yes	quotation #	No
cso_quotamendno	fin_rev_no	int(4)	Yes	quotation rev #	No
cso_doc_status	fin_status	varchar(25)	Yes	document status	No
cso_supplier_no	fin_vendorcode	varchar(45)	Yes	supplier #	No
cso_supplier_name	fin_name	varchar(60)	Yes	supplier Name	No
cso_doc_curr	fin_currency	varchar(5)	Yes	document currency	No
cso_doc_amount	fin_amount	numeric(13)	Yes	document amount	No
cso_workcenter	fin_workcenter	varchar(80)	Yes	work center #	No
cso_repair_class	fin_repairclassification	varchar(25)	Yes	repairclassification	No
cso_warranty_reco	fin_checkflag	int(4)	Yes	warrenty	No
cso_repair_process_code	fin_repairprocesscode	varchar(25)	Yes	repair process code	No
cso_revrec_oth_amt	fin_amount	numeric(13)	Yes	recon. Other doc amount	No
cso_revrec_tot_amt	fin_amount	numeric(13)	Yes	recon. Other doc total amount	No
cso_doc_amt_basecurr	fin_amount	numeric(13)	Yes	document base amount	No
cso_othdoccur_amt	fin_amount	numeric(13)	Yes	document oth currency	No
cso_source	fin_flag	varchar(25)	Yes	source	No
cso_execdoc_status	fin_status	varchar(25)	Yes	execdocument stauts	No
cso_aircraft_reg_no	fin_acregno	varchar(30)	Yes	aircraft reg. #	No
cso_contract_no	fin_documentno	varchar(40)	Yes	contract #	No
cso_contract_rev_no	fin_rev_no	int(4)	Yes	contract rev#	No
cso_custorder_curr	fin_currency	varchar(5)	Yes	customer order currency	No
cso_doc_type	fin_type	varchar(25)	Yes	document type	No
cso_doc_no	fin_documentno	varchar(40)	Yes	document #	No
cso_amend_no	fin_seqno	int(4)	Yes	amend #	No
cso_category	fin_category	varchar(15)	Yes	category	No
cso_custno	fin_customer_id	varchar(18)	Yes	customer #	No
cso_invbasis	fin_basis	varchar(8)	Yes	invoice basis	No

Table Name :	cso_val_sum_info
Comment :	offine line pricing main table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_guid	fin_guid	varchar(40)	Yes	guid	No
Cso_ou	fin_ctxt_ouinstance	int(4)	Yes	ou instance	No
cso_ordno	fin_documentno	varchar(40)	Yes	customer order #	No
cso_seqno	fin_seqno	int(4)	Yes	sequence #	No
cso_ordrevno	fin_rev_no	int(4)	Yes	customer order revision #	No
cso_execdocno	fin_documentno	varchar(40)	Yes	Execution Doc #	No
cso_execdoctype	fin_type	varchar(25)	Yes	Execution Doc type	No
cso_execdoclineno	fin_lineno	int(4)	Yes	Execution Doc Line #	No
cso_currency	fin_currency	varchar(5)	Yes	currency	No
cso_invbasis	fin_basis	varchar(8)	Yes	invoice basis	No
cso_custno	fin_customer_id	varchar(18)	Yes	customer #	No
cso_res_price	fin_amount	numeric(13)	Yes	Resource Price	No
cso_mat_price	fin_amount	numeric(13)	Yes	Material Price	No
cso_othser_price	fin_amount	numeric(13)	Yes	other services Price	No
cso_tcd_price	fin_amount	numeric(13)	Yes	charge Price	No
cso_totinv_price	fin_amount	numeric(13)	Yes	total Price	No
cso_totinv_pri_basecurr	fin_amount	numeric(13)	Yes	base currency Price	No
cso_source	fin_flag	varchar(25)	Yes	source	No
cso_category	fin_flag	varchar(25)	Yes	category	No
cso_process_run_datetime	fin_date	datetime(8)	Yes	run time date	No
cso_scherror	fin_errorid	int(4)	Yes	error flag	No
cso_schstatus	fin_status	varchar(25)	Yes	status	No
cso_createdby	fin_ctxt_user	varchar(30)	Yes	created by	No
cso_createddt	fin_date	datetime(8)	Yes	created date	No

Table Name :	cso_val_sum_info_hist
Comment :	offine line pricing main table history

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_guid	fin_guid	varchar(40)	Yes	guid	No
Cso_ou	fin_ctxt_ouinstance	int(4)	Yes	ou instance	No
cso_ordno	fin_documentno	varchar(40)	Yes	customer order #	No
cso_seqno	fin_seqno	int(4)	Yes	sequence #	No
cso_ordrevno	fin_rev_no	int(4)	Yes	customer order revision #	No
cso_execdocno	fin_documentno	varchar(40)	Yes	Execution Doc #	No
cso_execdoctype	fin_type	varchar(25)	Yes	Execution Doc type	No
cso_execdoclineno	fin_lineno	int(4)	Yes	Execution Doc Line #	No
cso_currency	fin_currency	varchar(5)	Yes	currency	No
cso_invbasis	fin_basis	varchar(8)	Yes	invoice basis	No
cso_custno	fin_customer_id	varchar(18)	Yes	customer #	No
cso_res_price	fin_amount	numeric(13)	Yes	Resource Price	No
cso_mat_price	fin_amount	numeric(13)	Yes	Material Price	No
cso_othser_price	fin_amount	numeric(13)	Yes	other services Price	No
cso_tcd_price	fin_amount	numeric(13)	Yes	charge Price	No
cso_totinv_price	fin_amount	numeric(13)	Yes	total Price	No
cso_totinv_pri_basecurr	fin_amount	numeric(13)	Yes	base currency Price	No
cso_source	fin_flag	varchar(25)	Yes	source	No
cso_category	fin_flag	varchar(25)	Yes	category	No
cso_process_run_datetime	fin_date	datetime(8)	Yes	run time date	No
cso_scherror	fin_errorid	int(4)	Yes	error flag	No
cso_schstatus	fin_status	varchar(25)	Yes	status	No
cso_createdby	fin_ctxt_user	varchar(30)	Yes	created by	No
cso_createddt	fin_date	datetime(8)	Yes	created date	No

Table Name :	cso_val_taskinfo_dtl
Comment :	offine line pricing task info table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_guid	fin_guid	varchar(40)	Yes	guid	No
cso_ou	fin_ctxt_ouinstance	int(4)	Yes	ou instance	No
cso_ordno	fin_documentno	varchar(40)	Yes	customer order #	No
cso_seqno	fin_seqno	int(4)	Yes	sequence #	No
cso_ordrevno	fin_rev_no	int(4)	Yes	customer order revision #	No
cso_execdocno	fin_documentno	varchar(40)	Yes	Execution Doc #	No
cso_execdoctype	fin_type	varchar(25)	Yes	Execution Doc type	No
cso_execdoclineno	fin_lineno	int(4)	Yes	Execution Doc Line #	No
cso_tasktrackid	fin_tasktrackid	bigint(8)	Yes	task track id	No
cso_taskno	fin_documentno	varchar(40)	Yes	task #	No
cso_task_lineno	fin_lineno	int(4)	Yes	task line#	No
cso_task_seqno	fin_lineno	int(4)	Yes	task sequence #	No
cso_taskstatus	fin_status	varchar(25)	Yes	task status	No
cso_eststatus	fin_status	varchar(25)	Yes	estimation status	No
cso_relno	fin_seqno	int(4)	Yes	release #	No
cso_quotno	fin_documentno	varchar(40)	Yes	quotation #	No
cso_quotamendno	fin_rev_no	int(4)	Yes	quotation rev #	No
cso_partno	fin_partno	varchar(40)	Yes	Part #	No
cso_mfrpartno	fin_partno	varchar(40)	Yes	Manufacture Part #	No
cso_mfrno	fin_vendorcode	varchar(45)	Yes	Manufacture #	No
cso_partserialno	fin_partno	varchar(40)	Yes	Part serial #	No
cso_currency	fin_currency	varchar(5)	Yes	currency	No
cso_wcdatate	fin_date	datetime(8)	Yes	workcenter Date	No
cso_relstatus	fin_status	varchar(25)	Yes	release status	No
cso_invbasis	fin_basis	varchar(8)	Yes	invoice basis	No
cso_custno	fin_customer_id	varchar(18)	Yes	customer #	No
cso_res_price	fin_amount	numeric(13)	Yes	Resource Price	No
cso_mat_price	fin_amount	numeric(13)	Yes	Material Price	No
cso_tcd_price	fin_amount	numeric(13)	Yes	charge Price	No
cso_totinv_price	fin_amount	numeric(13)	Yes	total Price	No
cso_totinv_pri_basecurr	fin_amount	numeric(13)	Yes	base currency Price	No
cso_source	fin_flag	varchar(25)	Yes	source	No
cso_ac_reg	fin_acregno	varchar(30)	Yes	aircraft reg #	No
cso_wrk_center	fin_wccode	varchar(30)	Yes	workcenter #	No
cso_prim_wrk_center	fin_workcenter	varchar(80)	Yes	Primary work center #	No
cso_category	fin_category	varchar(15)	Yes	category	No

Table Name :	cso_val_taskinfo_dtl_hist
Comment :	offine line pricing task info table history

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_guid	fin_guid	varchar(40)	Yes	guid	No
cso_ou	fin_ctxt_ouinstance	int(4)	Yes	ou instance	No
cso_ordno	fin_documentno	varchar(40)	Yes	customer order #	No
cso_seqno	fin_seqno	int(4)	Yes	sequence #	No
cso_ordrevno	fin_rev_no	int(4)	Yes	customer order revision #	No
cso_execdocno	fin_documentno	varchar(40)	Yes	Execution Doc #	No
cso_execdoctype	fin_type	varchar(25)	Yes	Execution Doc type	No
cso_execdoclineno	fin_lineno	int(4)	Yes	Execution Doc Line #	No
cso_tasktrackid	fin_tasktrackid	bigint(8)	Yes	task track id	No
cso_taskno	fin_documentno	varchar(40)	Yes	task #	No
cso_task_lineno	fin_lineno	int(4)	Yes	task line#	No
cso_task_seqno	fin_lineno	int(4)	Yes	task sequence #	No
cso_taskstatus	fin_status	varchar(25)	Yes	task status	No
cso_eststatus	fin_status	varchar(25)	Yes	estimation status	No
cso_relno	fin_seqno	int(4)	Yes	release #	No
cso_quotno	fin_documentno	varchar(40)	Yes	quotation #	No
cso_quotamendno	fin_rev_no	int(4)	Yes	quotation rev #	No
cso_partno	fin_partno	varchar(40)	Yes	Part #	No
cso_mfrpartno	fin_partno	varchar(40)	Yes	Manufacture Part #	No
cso_mfrno	fin_vendorcode	varchar(45)	Yes	Manufacture #	No
cso_partserialno	fin_partno	varchar(40)	Yes	Part serial #	No
cso_currency	fin_currency	varchar(5)	Yes	currency	No
cso_wcdatate	fin_date	datetime(8)	Yes	workcenter Date	No
cso_relstatus	fin_status	varchar(25)	Yes	release status	No
cso_invbasis	fin_basis	varchar(8)	Yes	invoice basis	No
cso_custno	fin_customer_id	varchar(18)	Yes	customer #	No
cso_res_price	fin_amount	numeric(13)	Yes	Resource Price	No
cso_mat_price	fin_amount	numeric(13)	Yes	Material Price	No
cso_tcd_price	fin_amount	numeric(13)	Yes	charge Price	No
cso_totinv_price	fin_amount	numeric(13)	Yes	total Price	No
cso_totinv_pri_basecurr	fin_amount	numeric(13)	Yes	base currency Price	No
cso_source	fin_flag	varchar(25)	Yes	source	No
cso_ac_reg	fin_acregno	varchar(30)	Yes	aircraft reg #	No
cso_wrk_center	fin_wccode	varchar(30)	Yes	workcenter #	No
cso_prim_wrk_center	fin_workcenter	varchar(80)	Yes	Primary work center #	No
cso_category	fin_category	varchar(15)	Yes	category	No

Table Name :	cso_we_workexec_dtl
Comment :	Customer Service Order Work Execution Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_we_ord_no	fin_documentnumber	varchar(18)	No	cso_we_ord_no	Yes
cso_we_tasklineno	fin_lineno	int(4)	No	cso_we_tasklineno	Yes
cso_we_task_no	fin_taskno	varchar(40)	No	cso_we_task_no	Yes
cso_we_ou_id	fin_ctxt_ouinstance	int(4)	No	cso_we_ou_id	Yes
cso_we_notes	fin_comments	varchar(256)	Yes	cso_we_notes	No
cso_we_pricbas	fin_designparamcode	varchar(5)	Yes	cso_we_pricbas	No
cso_we_taskrevno	fin_revisionno	varchar(40)	Yes	cso_we_taskrevno	No

Table Name :	cso_we_workexec_dtl_hist
Comment :	Customer Service Order Work Execution Details History

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cso_we_ord_no	fin_documentnumber	varchar(18)	No	cso_we_ord_no	Yes
cso_we_tasklineno	fin_lineno	int(4)	No	cso_we_tasklineno	Yes
cso_we_task_no	fin_taskno	varchar(40)	No	cso_we_task_no	Yes
cso_we_ou_id	fin_ctxt_ouinstance	int(4)	No	cso_we_ou_id	Yes
cso_we_notes	fin_comments	varchar(256)	Yes	cso_we_notes	No
cso_we_rev_no	fin_rev_no	int(4)	No	cso_we_rev_no	Yes
cso_we_pricbas	fin_designparamcode	varchar(5)	Yes	cso_we_pricbas	No