|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Cnt_Cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| Cnt_Cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| Cnt_Ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| Cnt_Rev_no | fin_rev_no | int(4) | No | Contract Revision Number | No |
| Cnt_Cnt_type | fin_enum_cd | varchar(5) | Yes | Contract Type | No |
| Cnt_Obj_Eff | fin_enum_cd | varchar(5) | Yes | Object Effectivity | No |
| Cnt_Status | fin_status | varchar(25) | Yes | Contract Status | No |
| Cnt_Date | fin_date | datetime(8) | Yes | Contract Date | No |
| Cnt_start_date | fin_date | datetime(8) | Yes | Contract Start Date | No |
| Cnt_End_date | fin_date | datetime(8) | Yes | Contract End Date | No |
| Cnt_effect_from | fin_date | datetime(8) | Yes | Effectivity From | No |
| Cnt_effect_to | fin_date | datetime(8) | Yes | Effectivity To | No |
| cnt_rev_comments | fin_comments | varchar(256) | Yes | Contract Revision Comments | No |
| Cnt_Stage | fin_stage | varchar(12) | Yes | Contract Stage | No |
| Cnt_User_Status | fin_quickcodes | varchar(25) | Yes | Contract User Status | No |
| Cnt_Int_Cnt_person | fin_contactperson | varchar(80) | Yes | Internal Contact Person | No |
| Cnt_Sale_type | fin_quickcodes | varchar(25) | Yes | Sales Type | No |
| Cnt_Cnt_cgty | fin_category | varchar(15) | Yes | Contract Category | No |
| cnt_currency | fin_currency | varchar(5) | Yes | Contract Currency | No |
| cnt_Enag_Type | fin_enum | varchar(40) | Yes | Engagement Type | No |
| cnt_cntrl_unit | fin_hrcostcentercode | varchar(40) | Yes | Control Unit | No |
| cnt_analy_code | fin_analysiscode | varchar(5) | Yes | Analysis CODE | No |
| Cnt_Cnt_Cvge | fin_txt255 | varchar(255) | Yes | Contract Coverage | No |
| Cnt_Remarks | fin_remarks | varchar(100) | Yes | Remarks | No |
| Cnt_Cntct_person | fin_contactperson | varchar(80) | Yes | Contact Person | No |
| Cnt_Email | fin_email | varchar(60) | Yes | Email Id | No |
| Cnt_Phone | fin_phone | varchar(18) | Yes | Phone Number | No |
| Cnt_Cust_cnt_no | fin_documentno | varchar(40) | Yes | Customer Contract Number | No |
| Cnt_cus_Rev_no | fin_rev_no | int(4) | Yes | Customer Contract Revision Number | No |
| Cnt_Cust_cnt_date | fin_date | datetime(8) | Yes | Customer Contract Date | No |
| Cnt_Rev_notes | fin_notes | varchar(2000) | Yes | Contract Revision Notes | No |
| cnt_sws_wrkenum | fin_contextinfo | varchar(1024) | Yes | Work Enumeration | No |
| cnt_ie_In_enum | fin_comments | varchar(256) | Yes | Inclusion Enumeration | No |
| cnt_ie_Ex_enum | fin_comments | varchar(256) | Yes | Exclusion Enumeration | No |
| Cnt_Std_Limit_type | fin_designparamcode | varchar(5) | Yes | Limit Type | No |
| Cnt_Std_Mat_Price | fin_price | numeric(13) | Yes | Material Price | No |
| Cnt_Std_Lab_Price | fin_price | numeric(13) | Yes | Labor Price | No |
| Cnt_Std_Oth_Res_Price | fin_price | numeric(13) | Yes | Other Resource Price | No |
| Cnt_Std_Tot_NTE_Price | fin_price | numeric(13) | Yes | Total NTE Price | No |
| Cnt_Std_effect_from | fin_date | datetime(8) | Yes | TM Effectivity From | No |
| Cnt_Std_effect_to | fin_date | datetime(8) | Yes | TM Effectivity To | No |
| Cnt_Std_Inv_Price_ref_Date | fin_enum_cd | varchar(5) | Yes | Invoice Price Reference Date | No |
| Cnt_Std_Exch_Rate_Conv | fin_enum_cd | varchar(5) | Yes | Exchange Rate Conversion | No |
| Cnt_Std_Prtprice_Ref | fin_enum_cd | varchar(5) | Yes | Part Price Reference | No |
| Cnt_Std_Remarks | fin_remarks | varchar(100) | Yes | TM Remarks | No |
| Cnt_Std_Esc_Freq | fin_quantity | numeric(17) | Yes | Frequency | No |
| Cnt_Std_Esc_Freqterms | fin_designparamcode | varchar(5) | Yes | Frequency Terms | No |
| Cnt_Std_Esc_Notes | fin_notes | varchar(2000) | Yes | TM Notes | No |
| Cnt_USB_Bill_once | fin_value | numeric(9) | Yes | Billing Once In | No |
| Cnt_USB_Prov_Bill | fin_enum_cd | varchar(5) | Yes | Provisional Billing | No |
| Cnt_USB_Prov_Bill_Aft | fin_days | int(4) | Yes | Provisional Billing After | No |
| Cnt_USB_Reg_Bill_Aft | fin_days | int(4) | Yes | Process Reg.Billing After | No |
| Cnt_USB_Min_Gua_usage | fin_values | numeric(17) | Yes | Minimum Guaranteed Usage | No |
| Cnt_USB_Track_Param | fin_quickcodes | varchar(25) | Yes | Tracking Parameter | No |
| Cnt_USB_Notes_Min_usage | fin_notes | varchar(2000) | Yes | Notes | No |
| Cnt_USB_Remarks | fin_remarks | varchar(100) | Yes | USB Remarks | No |
| Cnt_Ship_Cust_no | fin_customer_id | varchar(18) | Yes | Ship Customer Number | No |
| Cnt_Ship_Addr_ID | fin_addressid | varchar(12) | Yes | Shipping Address ID | No |
| Cnt_Ship_Alt_prmt | fin_int | int(4) | Yes | Alternate Shipping Address Permitted? | No |
| Cnt_Ship_INCO_term | fin_incoterm | varchar(150) | Yes | INCO Term | No |
| Cnt_Ship_Carr_agny | fin_agency | varchar(20) | Yes | Carrier Agency | No |
| Cnt_Ship_Pack_opt | fin_quickcodes | varchar(25) | Yes | Packaging Option | No |
| cnt_ship_met | fin_shipmet | varchar(25) | Yes | Shipping Method | No |
| Cnt_Ship_Frght_bill | fin_enum_cd | varchar(5) | Yes | Fright Billable | No |
| Cnt_Ship_Frght_term | fin_category | varchar(15) | Yes | Fright Term | No |
| Cnt_Ship_ship_lable | fin_quickcodes | varchar(25) | Yes | Shipping Label | No |
| Cnt_Ship_Pack_notes | fin_notes | varchar(2000) | Yes | Ship Pack Notes | No |
| Cnt_Bill_Cust_no | fin_customer_id | varchar(18) | Yes | Bill Customer Number | No |
| Cnt_Bill_Address | fin_address | varchar(40) | Yes | Billing Address ID | No |
| Cnt_Bill_Alt_prmt | fin_int | int(4) | Yes | Alternate Address Permitted? | No |
| Cnt_Bill_Inv_Tran_Mode | fin_enum_cd | varchar(5) | Yes | Invoice Transmittal Mode | No |
| Cnt_Bill_Inv_Gen | fin_enum_cd | varchar(5) | Yes | Invoice Generation | No |
| Cnt_Bill_Pay_term | fin_payterm | varchar(30) | Yes | Pay Term | No |
| Cnt_Bill_Rcp_Met | fin_enum_cd | varchar(5) | Yes | Receipt Method | No |
| Cnt_Bill_Rcp_Mode | fin_quickcodes | varchar(25) | Yes | Receipt Mode | No |
| Cnt_Bill_Bank_code | fin_bankcode | varchar(32) | Yes | Billable Bank Code | No |
| Cnt_Bill_Fwd_cvr_App | fin_enum_cd | varchar(5) | Yes | Forward Cover Applicable? | No |
| Cnt_Bill_Fwd_Rate | fin_rate | numeric(13) | Yes | Forward Rate | No |
| Cnt_Warr_Remarks | fin_notes | varchar(2000) | Yes | Warranty Remarks | No |
| Cnt_PHD_PStk_Status_cust | fin_desc40 | varchar(40) | Yes | Default Part Stock Status for Customer | No |
| Cnt_PHD_PStk_Status_Int | fin_desc40 | varchar(40) | Yes | Default Part Stock Status for Internal | No |
| Cnt_timestamp | fin_timestamp | int(4) | Yes | Timestamp | No |
| Cnt_Created_by | fin_ctxt_user | varchar(30) | Yes | Created By | No |
| Cnt_Created_Date | fin_date | datetime(8) | Yes | Creation Date | No |
| Cnt_Modified_by | fin_ctxt_user | varchar(30) | Yes | Modified By | No |
| Cnt_Modified_Date | fin_date | datetime(8) | Yes | Modified Date | No |
| Cnt_Confirmed_by | fin_ctxt_user | varchar(30) | Yes | Confirmed By | No |
| Cnt_Confirmed_Date | fin_date | datetime(8) | Yes | Confirmed Date | No |
| Cnt_Cancelled_by | fin_ctxt_user | varchar(30) | Yes | Cancelled By | No |
| Cnt_Cancelled_Date | fin_date | datetime(8) | Yes | Cancelled Date | No |
| Cnt_Approved_by | fin_ctxt_user | varchar(30) | Yes | Approved By | No |
| Cnt_Approved_Date | fin_date | datetime(8) | Yes | Approved Date | No |
| Cnt_Returned_by | fin_ctxt_user | varchar(30) | Yes | Returned By | No |
| Cnt_Returned_Date | fin_date | datetime(8) | Yes | Returned Date | No |
| Cnt_Closed_by | fin_ctxt_user | varchar(30) | Yes | Closed By | No |
| Cnt_Closed_Date | fin_date | datetime(8) | Yes | Closed Date | No |
| cnt_terminated_by | fin_ctxt_user | varchar(30) | Yes | Terminated By | No |
| Cnt_Termination_Date | fin_date | datetime(8) | Yes | Termination Date | No |
| Cnt_Reason | fin_text2500 | varchar(2500) | Yes | Reason | No |
| Cnt_cov_base_rate | fin_int | int(4) | Yes | Covered BaseRate | No |
| Cnt_max_markup | fin_int | int(4) | Yes | Maximum Markup | No |
| Cnt_cov_price | fin_int | int(4) | Yes | Covered Price | No |
| Cnt_max_ext_price | fin_int | int(4) | Yes | Maximum Extended Price | No |
| Cnt_res_cov_price | fin_int | int(4) | Yes | Resource Covered Price | No |
| Cnt_res_max_ext_price | fin_int | int(4) | Yes | Resource Maximum Extended Price | No |
| Cnt_cov_base_rate_EXT | fin_int | int(4) | Yes | Covered Base Rate EXT | No |
| Cnt_max_markup_EXT | fin_int | int(4) | Yes | MAx markup EXT | No |
| Cnt_cov_price_EXT | fin_int | int(4) | Yes | Covered Price EXT | No |
| Cnt_max_ext_price_EXT | fin_int | int(4) | Yes | Maximum Extented Price EXT | No | |
| Table Name : | sal_cnt_ac_dtl |
| Comment : | Sales Contract Aircraft Effectivity Details |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ac_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| ac_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| ac_revno | fin_rev_no | int(4) | No | Revision Number | No |
| ac_lineno | fin_lineno | int(4) | No | Line Number | No |
| ac_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| ac_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| ac_appl | fin_enum_cd | varchar(5) | Yes | Aircraft Applicability | No |
| ac_effect_code | fin_effectivitycode | varchar(40) | Yes | Effectivity Code | No |
| ac_qty | fin_quantity | numeric(17) | Yes | Quantity | No |
| ac_exe_wrkctr | fin_workcenter | varchar(80) | Yes | Execution Work Center | No |
| ac_vst_cnt | fin_designparamcode | varchar(5) | Yes | Visit Count | No |
| ac_exp_vst_cnt | fin_quantity | numeric(17) | Yes | Expect Visit Count | No |
| ac_inser_dat | fin_date | datetime(8) | Yes | Aircraft Initial Service Date | No |
| ac_sale_type | fin_quickcodes | varchar(25) | Yes | Sale Type | No |
| ac_fxd_price_for | fin_designparamcode | varchar(5) | Yes | Fixed Price For | No |
| ac_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| ac_effect_to | fin_date | datetime(8) | Yes | Effectivity To | No |
| ac_effect_from | fin_date | datetime(8) | Yes | Effectivity From | No |
| ac_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No |
| ac_cov_child_prt | fin_enum_cd | varchar(5) | Yes | Coverage of child parts | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| adln_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| adln_rev_no | fin_rev_no | int(4) | No | Contract Revision Number | No |
| adln_cust_no | fin_documentno | varchar(40) | Yes | Customer Number | No |
| adln_cat | fin_quickcodes | varchar(25) | Yes | Category | No |
| adln_attr | fin_quickcodes | varchar(25) | Yes | Attribute | No |
| adln_cat_val | fin_quantity | numeric(17) | Yes | Category Value | No |
| adln_lineno | fin_lineno | int(4) | No | Line Number | No |
| adln_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| adln_up_revno | fin_revno | varchar(3) | Yes | Revision Number | No |
| adln_notes | fin_notes | varchar(2000) | Yes | Notes | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ber_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| BER_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| BER_Rev_no | fin_rev_no | int(4) | No | Contract Revision Number | No |
| BER_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| BER_Pric_basis | fin_enum_cd | varchar(5) | No | BER Pricing Basis | No |
| ber_respons | fin_enum_cd | varchar(5) | Yes | BER Responsibility | No |
| BER_Rpr_thsold | fin_values | numeric(17) | Yes | BER Repair Threshold | No |
| BER_Based_on | fin_enum_cd | varchar(5) | Yes | BER % Based On | No |
| BER_Eval_basis | fin_enum_cd | varchar(5) | Yes | BER Evaluation Basis | No |
| BER_Pricing | fin_enum_cd | varchar(5) | Yes | BER Pricing | No |
| ber_up_revno | fin_rev_no | int(4) | Yes | Revision Number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| cert_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| cert_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| cert_revno | fin_rev_no | int(4) | No | Revision Number | No |
| cert_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| cert_lineno | fin_lineno | int(4) | No | Line Number | No |
| cert_seq_no | fin_seqno | int(4) | Yes | Sequence Number | No |
| cert_for | fin_quickcodes | varchar(25) | Yes | Certification For | No |
| cert_type | fin_quickcodes | varchar(25) | Yes | Certification Type | No |
| cert_agency | fin_agency | varchar(20) | Yes | Certification Agency | No |
| cert_temp | fin_desc40 | varchar(40) | Yes | Certification Remarks | No |
| cert_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| cert_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| chg_ou | fin_ctxt_ouinstance | int(4) | Yes | Ouinstance ID | No |
| chg_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| chg_cnt_no | fin_documentno | varchar(40) | Yes | Contract Number | No |
| chg_revno | fin_rev_no | int(4) | Yes | Revision Number | No |
| chg_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| chg_lineno | fin_lineno | int(4) | Yes | Line Number | No |
| chg_eff_ref | fin_reference | varchar(18) | Yes | Effectivity Reference Type | No |
| chg_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | Effectivity Code | No |
| chg_chg_cat | fin_category | varchar(15) | Yes | Charge Category | No |
| chg_chg_no | fin_tcdcodes | varchar(25) | Yes | Charge Number | No |
| chg_var_no | fin_tcdvariant | varchar(25) | Yes | Variant Number | No |
| chg_valu_at | fin_enum_cd | varchar(5) | Yes | Evaluation Basis | No |
| chg_lmt | fin_values | numeric(17) | Yes | Charge Limit | No |
| chg_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| chg_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No | |
| Table Name : | sal_cnt_chk_lst |
| Comment : | Sales Contract - Validation Check List Details |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| chk_cnt_no | fin_documentno | varchar(40) | Yes | Contract Number | No |
| chk_revno | fin_int | int(4) | Yes | Revision Number | No |
| chk_seqno | fin_int | int(4) | Yes | Sequence Number | No |
| chk_sale_type | fin_flag | varchar(25) | Yes | Sale Type | No |
| chk_rowid | fin_desc40 | varchar(40) | Yes | Row ID | No |
| chk_eff_code | fin_desc40 | varchar(40) | Yes | Effectivity Code | No |
| chk_mand | fin_designparamcode | varchar(5) | Yes | Mandatory Field Name | No |
| chk_spec | fin_designparamcode | varchar(5) | Yes | Specific Field Name | No |
| chk_ou | fin_ctxt_ouinstance | int(4) | Yes | Ouinstance ID | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| cons_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| cons_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| cons_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| cons_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| cons_lineno | fin_lineno | int(4) | No | Line Number | No |
| cons_revno | fin_rev_no | int(4) | No | Revision Number | No |
| cons_effref | fin_reference | varchar(18) | Yes | Effectivity Reference Type | No |
| cons_effrefcd | fin_effectivitycode | varchar(40) | Yes | Effectivity Code | No |
| cons_prt_exclrefcd | fin_effectivitycode | varchar(40) | Yes | Part Exclusion Reference Code | No |
| cons_prtno | fin_partno | varchar(40) | Yes | Part Number | No |
| cons_mfrprtno | fin_partno | varchar(40) | Yes | Manufacture Part Number | No |
| cons_mfrno | fin_vendorcode | varchar(45) | Yes | Manufacture Number | No |
| cons_coveralter | fin_enum_cd | varchar(5) | Yes | Cover Alternative ? | No |
| cons_prttype | fin_types | varchar(30) | Yes | Part Type | No |
| cons_prtclasf | fin_partclassification | varchar(25) | Yes | Part Classification | No |
| cons_prtgrp | fin_partgroup | varchar(40) | Yes | Part Group | No |
| cons_Rpltype | fin_types | varchar(30) | Yes | Replacement Type | No |
| cons_llp | fin_enum_cd | varchar(5) | Yes | LLP ? | No |
| cons_pricinbasis | fin_enum_cd | varchar(5) | Yes | Pricing Basis | No |
| cons_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| cons_efffrom | fin_date | datetime(8) | Yes | Effectivity From | No |
| cons_effto | fin_date | datetime(8) | Yes | Effectivity To | No |
| cons_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| cust_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| cust_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| cust_revno | fin_rev_no | int(4) | No | Revision Number | No |
| cust_lineno | fin_lineno | int(4) | No | Line Number | No |
| cust_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| cust_inc_exc | fin_option | varchar(20) | Yes | Inclusion/Exclusion Code | No |
| cust_supp_prts | fin_desc40 | varchar(40) | Yes | Supplier Parts | No |
| cust_prt_type | fin_types | varchar(30) | Yes | Part Type | No |
| cust_prt_clasf | fin_partclassification | varchar(25) | Yes | Part Classification | No |
| cust_prt_grp | fin_partgroup | varchar(40) | Yes | Part Group | No |
| cust_rpl_type | fin_types | varchar(30) | Yes | Replacement Type | No |
| cust_llp | fin_enum_cd | varchar(5) | Yes | LLP? | No |
| cust_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Ext_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| Ext_cnt_no | fin_documentno | varchar(40) | No | Contract Number | Yes |
| Ext_revno | fin_rev_no | int(4) | No | Revision Number | Yes |
| Ext_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | Yes |
| Ext_lineno | fin_lineno | int(4) | No | Line Number | Yes |
| Ext_eff_ref | fin_reference | varchar(18) | Yes | Effectivity Reference Type | No |
| Ext_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | Effectivity Code | No |
| Ext_sercap_cd | fin_effectivitycode | varchar(40) | Yes | External Service Cap Code | No |
| Ext_Pri_elem | fin_enum_cd | varchar(5) | Yes | Pricing Element | No |
| Ext_cap_type | fin_enum_cd | varchar(5) | Yes | Cap Type | No |
| Ext_eval_basis | fin_enum_cd | varchar(5) | Yes | Evaluation Basis | No |
| Ext_prt_lmt | fin_values | numeric(17) | Yes | Part Limit | No |
| Ext_line_lmt | fin_values | numeric(17) | Yes | Line Limit | No |
| Ext_prm_prt_lmt | fin_values | numeric(17) | Yes | Prime Part Limit | No |
| Ext_prt_grp_lmt | fin_values | numeric(17) | Yes | Prime Part Group Limit | No |
| Ext_appl_prt_grp | fin_partgroup | varchar(40) | Yes | Applicable Part Group | No |
| Ext_est_req | fin_enum_cd | varchar(5) | Yes | Estimation Req? | No |
| Ext_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| Ext_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| fxd_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| fxd_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| fxd_revno | fin_rev_no | int(4) | No | Revision Number | No |
| fxd_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| fxd_lineno | fin_lineno | int(4) | No | Line Number | No |
| fxd_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| fxd_eff_ref | fin_reference | varchar(18) | Yes | Effectivity Reference Type | No |
| fxd_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | Effectivity Reference Code | No |
| fxd_taskno | fin_taskno | varchar(40) | Yes | Task Number | No |
| fxd_WBScd | fin_quickcodes | varchar(25) | Yes | WBS Code | No |
| fxd_prt_no | fin_partno | varchar(40) | Yes | Part Numb | No |
| fxd_mfr_prt_no | fin_partno | varchar(40) | Yes | Manufacture Part Number | No |
| fxd_mfr_no | fin_vendorcode | varchar(45) | Yes | Manufacture Number | No |
| fxd_cover_alter | fin_enum_cd | varchar(5) | Yes | Cover Alternate? | No |
| fxd_mat_price | fin_price | numeric(13) | Yes | Material Price | No |
| fxd_lab_price | fin_price | numeric(13) | Yes | Labor Price | No |
| fxd_othres_price | fin_price | numeric(13) | Yes | Other Price | No |
| fxd_tot_price | fin_price | numeric(13) | Yes | Total Price | No |
| fxd_pricin_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| fxd_pricin_def | fin_enum | varchar(40) | Yes | Pricing Definition | No |
| fxd_effect_from | fin_date | datetime(8) | Yes | Effectivity From | No |
| fxd_effect_to | fin_date | datetime(8) | Yes | Effectivity To | No |
| fxd_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No |
| fxd_pri_wrk_cntr | fin_workcenter | varchar(80) | Yes | Primary Workcenter | No |
| fxd_exe_wrk_cntr | fin_workcenter | varchar(80) | Yes | Exec.workcenter | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| inc_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| inc_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| inc_revno | fin_rev_no | int(4) | No | Revision Number | No |
| inc_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| inc_seq_no | fin_seqno | int(4) | Yes | Sequence Number | No |
| inc_lineno | fin_lineno | int(4) | No | Line Number | No |
| inc_ref | fin_reference | varchar(18) | Yes | Inclusion Reference Type | No |
| inc_ref_cd | fin_effectivitycode | varchar(40) | Yes | Inclusion Reference Code | No |
| inc_cd | fin_effectivitycode | varchar(40) | Yes | Inclusion Code | No |
| inc_basis | fin_enum_cd | varchar(5) | Yes | Inclusion Basis | No |
| inc_rep_cls | fin_repairclassification | varchar(25) | Yes | Inclusion Repair Class | No |
| inc_eng_doc_dat | fin_date | datetime(8) | Yes | Inclusion Engineering Doc Date | No |
| inc_eng_doc_cost | fin_amount | numeric(13) | Yes | Inclusion Engineering Doc Cost | No |
| inc_task_cat | fin_tasktype | varchar(25) | Yes | Task Category | No |
| inc_task_type | fin_types | varchar(30) | Yes | Task Type | No |
| inc_task_no | fin_desc40 | varchar(40) | Yes | Task Number | No |
| inc_WBS_code | fin_paramcode | varchar(30) | Yes | WBS Code | No |
| inc_exe_phase | fin_paramcode | varchar(30) | Yes | Execution Phase | No |
| inc_exe_cat | fin_tasktype | varchar(25) | Yes | Execution Category | No |
| inc_rpcode | fin_quickcode | varchar(20) | Yes | Repair Process Code | No |
| inc_exe_WC | fin_workcenter | varchar(80) | Yes | Execution Work center | No |
| inc_ref_WC | fin_workcenter | varchar(80) | Yes | Reference Work center | No |
| inc_excl_pri_basis | fin_enum_cd | varchar(5) | Yes | Exclusion Pricing Basis | No |
| inc_fxd_price_defn | fin_enum_cd | varchar(5) | Yes | Fixed Price Definition For | No |
| inc_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| inc_lmt_effect_from | fin_date | datetime(8) | Yes | Effectivity From | No |
| inc_lmt_effect_to | fin_date | datetime(8) | Yes | Effectivity To | No |
| inc_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No |
| inc_date_ind | fin_enum_cd | varchar(5) | Yes | Inclusion Date | No |
| inc_Val_ind | fin_enum_cd | varchar(5) | Yes | Inclusion Code Value | No |
| inc_Tsk_class | fin_designparamcode | varchar(5) | Yes | Work Type | No |
| inc_disc_cat | fin_type | varchar(25) | Yes | Discrepancy Category | No |
| inc_disc_typ | fin_designparamcode | varchar(5) | Yes | Discrepancy Type | No |
| inc_disc_rep_cls | fin_repairclassification | varchar(25) | Yes | Disc. Repair Classification | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| insp_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| insp_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| insp_revno | fin_rev_no | int(4) | No | Revision Number | No |
| insp_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| insp_lineno | fin_lineno | int(4) | No | Line Number | No |
| insp_seq_no | fin_seqno | int(4) | Yes | Sequence Number | No |
| insp_req | fin_enum_cd | varchar(5) | Yes | Inspection Required? | No |
| insp_eff_ref | fin_reference | varchar(18) | Yes | Effectivity Reference Type | No |
| insp_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | Effectivity Reference Code | No |
| insp_chklst_cd | fin_parameter | varchar(40) | Yes | Check List / Attribute Code | No |
| insp_typ | fin_enum_cd | varchar(5) | Yes | Inspection Type | No |
| insp_attr_typ | fin_attribute | varchar(10) | Yes | Inspection Attribute Type | No |
| insp_uom | fin_uom | varchar(15) | Yes | UOM | No |
| insp_minval_exp | fin_values | numeric(17) | Yes | Minimum Value Exception | No |
| insp_maxval_exp | fin_values | numeric(17) | Yes | Maximum Value Exception | No |
| insp_stdval_exp | fin_values | numeric(17) | Yes | Standard Value Exception | No |
| insp_exp_qual_val | fin_values | numeric(17) | Yes | Exception Quantity Value | No |
| insp_mand | fin_enum_cd | varchar(5) | Yes | Mandatory | No |
| insp_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| insp_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| inv_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| inv_cnt_no | fin_documentno | varchar(40) | No | Contract Number | Yes |
| inv_revno | fin_rev_no | int(4) | No | Revision Number | Yes |
| inv_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | Yes |
| inv_lineno | fin_lineno | int(4) | No | Line Number | Yes |
| inv_sale_type | fin_type | varchar(25) | Yes | Sale Type | No |
| inv_price_basis | fin_enum_cd | varchar(5) | Yes | Pricing Basis | No |
| inv_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| inv_type | fin_types | varchar(30) | Yes | Invoice Type | No |
| inv_cat | fin_category | varchar(15) | Yes | Invoice Category | No |
| inv_event | fin_enum_cd | varchar(5) | Yes | Event | No |
| inv_eventdesc | fin_txt255 | varchar(255) | Yes | Event Description | No |
| inv_bill_prior | fin_quantity | numeric(17) | Yes | Bill Prior To | No |
| inv_trig_task | fin_taskno | varchar(40) | Yes | Triggering Task | No |
| inv_basis | fin_enum_cd | varchar(5) | Yes | Invoice Basis | No |
| inv_value | fin_values | numeric(17) | Yes | Invoice Value | No |
| inv_payterm | fin_payterm | varchar(30) | Yes | Pay term | No |
| inv_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| inv_remarks | fin_remarks | varchar(100) | Yes | Remarks | No |
| inv_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No |
| inv_regular_basis | fin_enum_cd | varchar(5) | Yes | Regular Basis | No |
| inv_prepayment_basis | fin_enum_cd | varchar(5) | Yes | Prepayment Basis | No |
| inv_cummulative | fin_enum_cd | varchar(5) | Yes | Cumulative Value | No |
| inv_invfr | Fin_designparamcode | varchar(5) | Yes | Invoice For | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| inv_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| inv_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| inv_rev_no | fin_rev_no | int(4) | No | Contract Revision Number | No |
| inv_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| inv_sale_type | fin_type | varchar(25) | Yes | Sale Type | No |
| inv_pricing_basis | fin_enum_cd | varchar(5) | Yes | Pricing Basis | No |
| inv_rel_before_event | fin_enum_cd | varchar(5) | Yes | Release Before Event | No |
| inv_auto_rel | fin_enum_cd | varchar(5) | Yes | Auto Release | No |
| inv_rtb_rel | fin_enum_cd | varchar(5) | Yes | RTB Release | No |
| inv_auto_status | fin_designparamcode | varchar(5) | Yes | Auto Release Status | No |
| inv_remarks | fin_remarks | varchar(100) | Yes | Remarks | No |
| inv_hdr_up_revno | fin_rev_no | int(4) | Yes | Revision Number | No |
| inv_invfr | Fin_designparamcode | varchar(5) | Yes | Invoice For | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| mat_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| mat_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| mat_revno | fin_rev_no | int(4) | No | Revision Number | No |
| mat_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| mat_lineno | fin_lineno | int(4) | No | Line Number | No |
| mat_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| mat_eff_ref | fin_reference | varchar(18) | Yes | Effectivity Reference Type | No |
| mat_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | Effectivity Reference Code | No |
| mat_cap_elem | fin_enum_cd | varchar(5) | Yes | Cap Element | No |
| mat_cap_type | fin_enum_cd | varchar(5) | Yes | Cap Type | No |
| mat_eval_at | fin_enum_cd | varchar(5) | Yes | Evolution At | No |
| mat_prt_type | fin_quickcodes | varchar(25) | Yes | Part Type | No |
| mat_prt_cls | fin_quickcodes | varchar(25) | Yes | Part Class | No |
| mat_prt_cnd | fin_quickcodes | varchar(25) | Yes | Part Condition | No |
| mat_stk_sts | fin_quickcodes | varchar(25) | Yes | Stock Status | No |
| mat_llp | fin_enum_cd | varchar(5) | Yes | LLP? | No |
| mat_rpl_typ | fin_enum_cd | varchar(5) | Yes | Replacement Type | No |
| mat_prt_lmt | fin_values | numeric(17) | Yes | Part Limit | No |
| mat_line_lmt | fin_values | numeric(17) | Yes | Line Limit | No |
| mat_prm_prt_lmt | fin_values | numeric(17) | Yes | Prime Part Limit | No |
| mat_prt_grp_lmt | fin_values | numeric(17) | Yes | Pirme Part Group Limit | No |
| mat_appl_prt_grp | fin_partgroup | varchar(40) | Yes | Applicable Part Group | No |
| mat_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| mat_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No |
| mat_cap_cd | fin_documentno | varchar(40) | Yes | Cap Code | No |
| mat_est_req | fin_enum_cd | varchar(5) | Yes | Estimation Req? | No |
| mat_hold_cd | fin_quickcodes | varchar(25) | Yes | Hold Code | No |
| mat_hold_limit | fin_enum_cd | varchar(5) | Yes | Hold limit | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| cnt_rowid | fin_flag | varchar(25) | Yes | Row Id - Sequence Number | No |
| cnt_srctab_cd | fin_flag | varchar(25) | Yes | Tab Code | No |
| cnt_ctrl | fin_txt255 | varchar(255) | Yes | Control Name | No |
| cnt_ctrlval_cd | fin_flag | varchar(25) | Yes | Control Value | No |
| cnt_reftab_cd | fin_flag | varchar(25) | Yes | Reference Tab | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| prm_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| prm_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| prm_revno | fin_rev_no | int(4) | No | Revision Number | No |
| prm_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| prm_line_no | fin_lineno | int(4) | No | Line Number | No |
| prm_prt_opr_flag | fin_designparamcode | varchar(5) | No | Part Operation Parameter Flag | No |
| prm_category | fin_category | varchar(15) | Yes | Category | No |
| prm_element | fin_designparamcode | varchar(5) | Yes | Element | No |
| prm_value | fin_values | numeric(17) | Yes | Value | No |
| prm_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| prm_auto_hld | fin_designparamcode | varchar(5) | Yes | Auto Hold ? | No |
| prm_hld_cd | fin_quickcodes | varchar(25) | Yes | Customer Hold Code | No |
| prm_int_hld | fin_quickcodes | varchar(25) | Yes | Internal Hold Code | No |
| prm_com_hld_cmnt | fin_comments | varchar(256) | Yes | Customer Hold Comments | No |
| prm_int_hld_cmnt | fin_comments | varchar(256) | Yes | Internal Hold Comments | No | |
| Table Name : | sal_cnt_prt_dtl |
| Comment : | Sales Contract Part Effectivity Details |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Prt_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| prt_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| prt_revno | fin_rev_no | int(4) | No | Revision Number | No |
| prt_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| prt_lineno | fin_seqno | int(4) | No | Line Number | No |
| prt_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| prt_effect_code | fin_documentno | varchar(40) | Yes | Effectivity Code | No |
| prt_applicability | fin_enum | varchar(40) | Yes | Applicability? | No |
| prt_effect_from | fin_date | datetime(8) | Yes | Effectivity From | No |
| prt_effect_to | fin_date | datetime(8) | Yes | Effectivity To | No |
| prt_ref_wkcenter | fin_quickcodes | varchar(25) | Yes | Reference Work Center | No |
| prt_ref_wrkctr_cat | fin_quickcodes | varchar(25) | Yes | Reference Work Center Category | No |
| prt_qty | fin_quantity | numeric(17) | Yes | Part Quantity | No |
| prt_inc_child_prt | fin_designparamcode | varchar(5) | Yes | Include Child Part ? | No |
| prt_cov_alt | fin_designparamcode | varchar(5) | Yes | Cover Alternate Part? | No |
| prt_effect_type | fin_designparamcode | varchar(5) | Yes | Effectivity Type | No |
| prt_vstcnt | fin_designparamcode | varchar(5) | Yes | Visit Count | No |
| prt_exp_vstcnt | fin_quantity | numeric(17) | Yes | Exception Visit Count | No |
| prt_int_rcpt_dat | fin_date | datetime(8) | Yes | Internal Receipt Date | No |
| prt_sale_type | fin_quickcodes | varchar(25) | Yes | Sale Type | No |
| prt_fxd_pric_defn | fin_enum_cd | varchar(5) | Yes | Fixed Price Definition For | No |
| prt_exec_at | fin_enum_cd | varchar(5) | Yes | Executed At | No |
| prt_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| prt_egt_guaranty_nts | fin_notes | varchar(2000) | Yes | Guaranty Notes | No |
| prt_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No |
| prt_covAcCont | fin_enum_cd | varchar(5) | Yes | Coverage of Parts Removed | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| inc_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| inc_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| inc_rev_no | fin_rev_no | int(4) | No | Contract Revision Number | No |
| inc_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| inc_line_no | fin_lineno | int(4) | No | Line Number | No |
| inc_inc_exc_flag | fin_enum_cd | varchar(5) | No | Inclusion / Exclusion Flag | No |
| inc_part_no | fin_partno | varchar(40) | Yes | Part Number | No |
| inc_mfr_prt_no | fin_partno | varchar(40) | Yes | Manufacture Part Number | No |
| inc_mfr_no | fin_vendorcode | varchar(45) | Yes | Manufacture Number | No |
| inc_cover_alter | fin_enum_cd | varchar(5) | Yes | Cover Alternate ? | No |
| inc_up_revno | fin_rev_no | int(4) | Yes | Revision Number | No | |
| Table Name : | sal_cnt_prt_map |
| Comment : | Sales Contract Part / Aircraft Mapping details |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| map_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| map_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| map_revno | fin_rev_no | int(4) | No | Revision Number | No |
| map_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| map_seq_no | fin_seqno | int(4) | No | Sequence Number | No |
| map_flag | fin_flag | varchar(25) | No | Map Flag | No |
| map_effect_code | fin_effectivitycode | varchar(40) | Yes | Effectivity Code | No |
| map_effect_from | fin_date | datetime(8) | Yes | Effectivity From | No |
| map_effect_to | fin_date | datetime(8) | Yes | Effectivity To | No |
| map_prt_no | fin_partno | varchar(40) | Yes | Part Number | No |
| map_mfr_prt_no | fin_partno | varchar(40) | Yes | Manufacture Part Number | No |
| map_mfr_no | fin_vendorcode | varchar(45) | Yes | Manufacture Number | No |
| map_prt_grp | fin_partgroup | varchar(40) | Yes | Part Group | No |
| map_prt_cls | fin_partclassification | varchar(25) | Yes | Part Class | No |
| map_prt_cmp_typ | fin_componenttype | varchar(30) | Yes | Part Component Type | No |
| map_prt_mdl | fin_partno | varchar(40) | Yes | Part Model Number | No |
| map_prt_repl_typ | fin_types | varchar(30) | Yes | Replacement Type | No |
| map_Maj_prt_no | fin_partno | varchar(40) | Yes | Removed Part Number | No |
| map_Maj_mfr_prt_no | fin_partno | varchar(40) | Yes | Removed Manufacture Part Number | No |
| map_Maj_mfr_no | fin_vendorcode | varchar(45) | Yes | Removed Manufacture Number | No |
| map_Maj_prt_srl_no | fin_partserialnumber | varchar(40) | Yes | Removed Part Serial Number | No |
| map_ac_mdl | fin_aircraftmodel | varchar(20) | Yes | Aircraft Model Number | No |
| map_ac_reg | fin_acregno | varchar(30) | Yes | Aircraft Registration Number | No |
| map_ac_msn | fin_partserialnumber | varchar(40) | Yes | Aircraft MSN Number | No |
| map_pric_basis | fin_enum_cd | varchar(5) | Yes | Pricing Basis | No |
| map_Ac_grp | fin_partgroup | varchar(40) | Yes | Aircraft Group | No |
| map_acft_grp | fin_partgroup | varchar(40) | Yes | Aircraft Group no | No |
| map_ref_aceffcd | fin_effectivitycode | varchar(40) | Yes | Aircraft Effectivity code | No |
| map_pckage_typ | fin_quickcodes | varchar(25) | Yes | Package Type | No |
| map_cust_grp | fin_group | varchar(25) | Yes | Customer Group no | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| srl_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| srl_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| srl_revno | fin_rev_no | int(4) | No | Revision Number | No |
| srl_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| srl_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| srl_lineno | fin_lineno | int(4) | No | Line Number | No |
| srl_effect_code | fin_partno | varchar(40) | Yes | Effectivity Code | No |
| srl_prt_no | fin_partno | varchar(40) | Yes | Part Number | No |
| srl_mfr_no | fin_vendorcode | varchar(45) | Yes | Manufacture Number | No |
| srl_mfr_prtno | fin_partno | varchar(40) | Yes | Manufacture Part Number | No |
| srl_msn_no | fin_partserialnumber | varchar(40) | Yes | MSN Number | No |
| srl_srlno | fin_partserialnumber | varchar(40) | Yes | Part Serial Number | No |
| srl_notes | fin_txt255 | varchar(255) | Yes | Notes | No |
| srl_effect_from | fin_date | datetime(8) | Yes | Effectivity From | No |
| srl_effect_to | fin_date | datetime(8) | Yes | Effectivity To | No |
| srl_prt_Up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| repsup_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| repsup_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| repsup_revno | fin_rev_no | int(4) | No | Revision Number | No |
| repsup_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| repsup_lineno | fin_lineno | int(4) | No | Line Number | No |
| repsup_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| repsup_prtno | fin_partno | varchar(40) | Yes | Supplier Part Number | No |
| repsup_mfrprtno | fin_partno | varchar(40) | Yes | Supplier Manufacture Part Number | No |
| repsup_mfrno | fin_vendorcode | varchar(45) | Yes | Supplier Manufacture Number | No |
| repsup_covalt | fin_enum_cd | varchar(5) | Yes | Cover Alternate Part ? | No |
| repsup_repsupno | fin_vendorcode | varchar(45) | Yes | Supplier Number | No |
| repsup_prisup | fin_vendorcode | varchar(45) | Yes | Pricing Supplier | No |
| repsup_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| res_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| res_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| res_revno | fin_rev_no | int(4) | No | Revision Number | No |
| res_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| res_lineno | fin_lineno | int(4) | No | Line Number | No |
| res_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| res_eff_ref | fin_reference | varchar(18) | Yes | Effectivity Reference Type | No |
| res_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | Effectivity Reference Code | No |
| res_pric_ele | fin_designparamcode | varchar(5) | Yes | Pricing Element | No |
| res_res_typ | fin_types | varchar(30) | Yes | Resource Type | No |
| res_res_no | fin_resourcecode | varchar(40) | Yes | Resource Number | No |
| res_eval_at | fin_enum_cd | varchar(5) | Yes | Evaluation At | No |
| res_lmt_typ | fin_enum_cd | varchar(5) | Yes | Limit Type | No |
| res_res_lmt | fin_enum_cd | varchar(5) | Yes | Resource Limit | No |
| res_cons_UOM | fin_enum_cd | varchar(5) | Yes | UOM | No |
| res_reslmt_val | fin_values | numeric(17) | Yes | Resource Limit Value | No |
| res_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| res_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No |
| res_cap_cd | fin_documentno | varchar(40) | Yes | Resource Cap Code | No |
| res_est_req | fin_enum_cd | varchar(5) | Yes | Estimation Req? | No |
| res_hold_cd | fin_quickcodes | varchar(25) | Yes | Hold Code | No |
| res_hold_limit | fin_enum_cd | varchar(5) | Yes | Hold Limit | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tm_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| tm_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| tm_revno | fin_rev_no | int(4) | No | Revision Number | No |
| tm_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| tm_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| tm_lineno | fin_lineno | int(4) | No | Line Number | No |
| tm_eff_ref | fin_reference | varchar(18) | Yes | Effectivity Reference Type | No |
| tm_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | Effectivity Reference Code | No |
| tm_spl | fin_documentno | varchar(40) | Yes | Service Price List Number | No |
| tm_ppl | fin_documentno | varchar(40) | Yes | Part Price List Number | No |
| tm_effect_to | fin_date | datetime(8) | Yes | Effectivity To | No |
| tm_effect_from | fin_date | datetime(8) | Yes | Effectivity From | No |
| tm_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| tm_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tab_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| tab_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| tab_revno | fin_rev_no | int(4) | No | Revision Number | No |
| tab_prt_revno | fin_rev_no | int(4) | Yes | Part Effectivity Revision Number | No |
| tab_ac_revno | fin_rev_no | int(4) | Yes | Aircarft EffectivityRevision Number | No |
| tab_ws_revno | fin_rev_no | int(4) | Yes | Workscope Revision Number | No |
| tab_psrl_revno | fin_rev_no | int(4) | Yes | Part Serial Effectivity Revision Number | No |
| tab_tat_revno | fin_rev_no | int(4) | Yes | TAT Tab Revision Number | No |
| tab_inex_tsk_revno | fin_rev_no | int(4) | Yes | Inclusion / Exclusion Revision Number | No |
| tab_exc_prt_revno | fin_rev_no | int(4) | Yes | Exclusion Part Revision Number | No |
| tab_TM_revno | fin_rev_no | int(4) | Yes | TM Tab Revision Number | No |
| tab_FP_revno | fin_rev_no | int(4) | Yes | Fixed Price TabRevision Number | No |
| tab_USB_revno | fin_rev_no | int(4) | Yes | Usage Based PricingRevision Number | No |
| tab_MAT_revno | fin_rev_no | int(4) | Yes | Material Pricing Revision Number | No |
| tab_RES_revno | fin_rev_no | int(4) | Yes | Resrouce Pricing Revision Number | No |
| tab_CHG_revno | fin_rev_no | int(4) | Yes | Charge Pricing Revision Number | No |
| tab_INV_revno | fin_rev_no | int(4) | Yes | Invoice Tab Revision Number | No |
| tab_TCD_revno | fin_rev_no | int(4) | Yes | TCD Tab Revision Number | No |
| tab_op_revno | fin_rev_no | int(4) | Yes | Operational Tab Revision Number | No |
| tab_PH_revno | fin_rev_no | int(4) | Yes | Part Revision Number | No |
| tab_Cust_sup_revno | fin_rev_no | int(4) | Yes | Customer Supplier Tabe Revision Number | No |
| tab_PWrkdly_revno | fin_rev_no | int(4) | Yes | Work Delay Tab Revision Number | No |
| tab_insp_revno | fin_rev_no | int(4) | Yes | Inspection Tab Revision Number | No |
| tab_cert_revno | fin_rev_no | int(4) | Yes | Certification tab Revision Number | No |
| tab_war_revno | fin_rev_no | int(4) | Yes | Warranty Tab Revision Number | No |
| tab_ber_revno | fin_rev_no | int(4) | Yes | BER Details Revision Number | No |
| tab_repsup_revno | fin_rev_no | int(4) | Yes | Rep Supplier Revision Number | No |
| tab_adln_revno | fin_rev_no | int(4) | Yes | Additional detail Tab Revision Number | No |
| tab_UBRR_revno | fin_rev_no | int(4) | Yes | Usage Based Tab Revision Number | No |
| tab_INV_hdr_revno | fin_rev_no | int(4) | Yes | Invoice Tab Header Revision Number | No |
| tab_ext_ser_cap_rev | fin_rev_no | int(4) | Yes | Tab Service Cap Revision Number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tat_ac_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | Yes |
| tat_ac_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| tat_ac_cnt_no | fin_documentno | varchar(40) | No | Contract Number | Yes |
| tat_ac_revno | fin_rev_no | int(4) | No | Revision Number | Yes |
| tat_ac_lineno | fin_lineno | int(4) | No | Line Number | Yes |
| tat_ac_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| tat_ac_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | TAT Aircraft Effectivity Reference code | No |
| tat_ac_Pkg_typ | fin_quickcodes | varchar(25) | Yes | Package Type | No |
| tat_ac_group | fin_quickcodes | varchar(25) | Yes | Aircraft Group no | No |
| tat_ac_model | fin_airmodel | varchar(30) | Yes | Aircraft Model no | No |
| tat_ac_exe_wrkcntr | fin_workcenter | varchar(80) | Yes | Execution Work Center | No |
| tat_ac_strt_ref_dt | fin_enum_cd | varchar(5) | Yes | Aircraft started ref date | No |
| tat_ac_end_ref_dt | fin_enum_cd | varchar(5) | Yes | Aircraft End Ref date | No |
| tat_ac_day_cust | fin_values | numeric(17) | Yes | TAT Customer Days | No |
| tat_ac_day_plan | fin_values | numeric(17) | Yes | TAT Plan Days | No |
| tat_ac_stat | fin_enum_cd | varchar(5) | Yes | TAT Stated in | No |
| tat_ac_notes | fin_notes | varchar(2000) | Yes | TAT Aircraft Notes | No |
| tat_ac_up_rev | fin_rev_no | int(4) | Yes | Update Revision number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tat_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| tat_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| tat_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| tat_revno | fin_rev_no | int(4) | No | Revision Number | No |
| tat_lineno | fin_lineno | int(4) | No | Line Number | No |
| tat_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| tat_eff_ref | fin_reference | varchar(18) | Yes | TAT Effectivity Reference Type | No |
| tat_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | TAT Effectivity Reference Code | No |
| tat_rpcode | fin_quickcode | varchar(20) | Yes | Repair Process Code | No |
| tat_strt_ref_dt | fin_enum_cd | varchar(5) | Yes | TAT Start Reference Date | No |
| tat_end_ref_dt | fin_enum_cd | varchar(5) | Yes | TAT End Reference Date | No |
| tat_day_cust | fin_values | numeric(17) | Yes | TAT Customer Days | No |
| tat_day_plan | fin_values | numeric(17) | Yes | TAT Plan Days | No |
| tat_stat | fin_enum_cd | varchar(5) | Yes | TAT Stated In | No |
| tat_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| tat_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No |
| tat_prtgrp | fin_partgroup | varchar(40) | Yes | Part Group | No |
| tat_Ov | fin_days | int(4) | Yes | TAT For OV | No |
| tat_prtno | fin_partno | varchar(40) | Yes | Part number | No |
| tat_mfrprtno | fin_partno | varchar(40) | Yes | Manufacture Part Number | No |
| tat_mfrno | fin_vendorcode | varchar(45) | Yes | Manufacture Number | No |
| tat_coveralt | fin_enum_cd | varchar(5) | Yes | Cover Alternate Part ? | No |
| tat_exe_wrkcntr | fin_workcenter | varchar(80) | Yes | Execution Work Center | No |
| tat_ref_wrkcntr | fin_workcenter | varchar(80) | Yes | Reference Work Center | No |
| tat_all_qtapp_dur | fin_quantity | numeric(17) | Yes | Allowed Quote Duration | No |
| tat_std_qtprp_time | fin_quantity | numeric(17) | Yes | Quote Preaparation Time | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tcd_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| tcd_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| tcd_revno | fin_rev_no | int(4) | No | Revision Number | No |
| tcd_OU | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| tcd_line_no | fin_lineno | int(4) | No | Line Number | No |
| tcd_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| tcd_no | fin_tcdcodes | varchar(25) | Yes | TCD Code | No |
| tcd_var_no | fin_tcdvariant | varchar(25) | Yes | Variant Number | No |
| tcd_rate | fin_rate | numeric(13) | Yes | TCD Rate | No |
| tcd_cur | fin_currency | varchar(5) | Yes | Currency Code | No |
| tcd_appl | fin_enum_cd | varchar(5) | Yes | TCD Applicability | No |
| tcd_devarea | fin_deliveryarea | varchar(18) | Yes | Delivery Area | No |
| tcd_station | fin_station | varchar(40) | Yes | Station | No |
| tcd_cc_appl | fin_enum_cd | varchar(5) | Yes | Cost Center Applicability | No |
| tcd_cost_center | fin_hrcostcentercode | varchar(40) | Yes | Cost Center | No |
| tcd_billable | fin_enum_cd | varchar(5) | Yes | Billable | No |
| tcd_pay_sup | fin_vendorcode | varchar(45) | Yes | Pat To Supplier | No |
| tcd_effect_from | fin_date | datetime(8) | Yes | Effectivity From | No |
| tcd_effect_to | fin_date | datetime(8) | Yes | Effectivity To | No |
| tcd_up_revno | fin_rev_no | int(4) | Yes | Previouse Revision Number | No |
| tcd_remarks | fin_notes | varchar(2000) | Yes | Remarks | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| usg_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| usg_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| usg_revno | fin_rev_no | int(4) | No | Revision Number | No |
| usg_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| usg_lineno | fin_lineno | int(4) | No | Line Number | No |
| usg_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| usg_eff_ref | fin_reference | varchar(18) | Yes | Effectivity Reference Type | No |
| usg_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | Effectivity Code | No |
| usg_ac_reg | fin_acregno | varchar(30) | Yes | Aircraft Registration Number | No |
| usg_ac_msn | fin_partserialnumber | varchar(40) | Yes | Aircraft MSN Number | No |
| usg_prt_no | fin_partno | varchar(40) | Yes | Part number | No |
| usg_mfr_prt_no | fin_partno | varchar(40) | Yes | Manufacture Part Number | No |
| usg_mfr_no | fin_vendorcode | varchar(45) | Yes | Manufacture Number | No |
| usg_srl_no | fin_partserialnumber | varchar(40) | Yes | Part Serial Number | No |
| usg_age_frm | fin_values | numeric(17) | Yes | Age From | No |
| usg_age_to | fin_values | numeric(17) | Yes | Age To | No |
| usg_age_basedon | fin_enum_cd | varchar(5) | Yes | Age Based on | No |
| usg_effect_from | fin_date | datetime(8) | Yes | Effectivity From | No |
| usg_effect_to | fin_date | datetime(8) | Yes | Effectivity To | No |
| usg_usg_from | fin_values | numeric(17) | Yes | Usage From | No |
| usg_usg_to | fin_values | numeric(17) | Yes | Usage To | No |
| usg_param | fin_parameter | varchar(40) | Yes | Usage Parameter | No |
| usg_bill_ele | fin_quickcodes | varchar(25) | Yes | Billable Element | No |
| usg_rate | fin_rate | numeric(13) | Yes | Usage Rate | No |
| usg_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| usg_up_revno | fin_rev_no | int(4) | Yes | Previouse Revision Number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ubrr_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| ubrr_cnt_no | fin_documentno | varchar(40) | No | Contract Number | Yes |
| ubrr_rev_no | fin_rev_no | int(4) | No | Contract Revision Number | Yes |
| ubrr_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | Yes |
| ubrr_lineno | fin_lineno | int(4) | No | Line Number | Yes |
| ubrr_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| ubrr_eff_ref | fin_reference | varchar(18) | Yes | Effectivity Reference Type | No |
| ubrr_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | Effectivity Reference Code | No |
| ubrr_rev_reg_per | fin_percentage | numeric(9) | Yes | Usage margin(%) | No |
| ubrr_effective_from | fin_date | datetime(8) | Yes | Effectivity From | No |
| ubrr_effective_to | fin_date | datetime(8) | Yes | Effectivity To | No |
| ubrr_up_revno | fin_rev_no | int(4) | Yes | Revision Number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| war_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| war_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| war_revno | fin_rev_no | int(4) | No | Revision Number | No |
| War_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| war_lineno | fin_lineno | int(4) | No | Line Number | No |
| war_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| war_appl | fin_enum_cd | varchar(5) | Yes | Warranty Applicability? | No |
| war_eff_ref | fin_reference | varchar(18) | Yes | Effectivity Reference Type | No |
| war_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | Effectivity Reference Code | No |
| war_startref_date | fin_quickcodes | varchar(25) | Yes | Warranty Start Reference Date | No |
| war_coverage | fin_enum_cd | varchar(5) | Yes | Warranty Coverage | No |
| war_lmttype | fin_quickcodes | varchar(25) | Yes | Warranty Limit Type | No |
| war_value | fin_values | numeric(17) | Yes | Warranty Value | No |
| war_trackparam | fin_quickcodes | varchar(25) | Yes | Warranty Track Parameter | No |
| war_eff_fm | fin_date | datetime(8) | Yes | Warranty Effectivity From | No |
| war_eff_to | fin_date | datetime(8) | Yes | Effectivity To | No |
| war_lmt_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| war_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| wrk_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| wrk_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| wrk_revno | fin_rev_no | int(4) | No | Revision Number | No |
| wrk_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| wrk_lineno | fin_lineno | int(4) | No | Line Number | No |
| wrk_seq_no | fin_seqno | int(4) | Yes | Sequence Number | No |
| wrk_holdcode | fin_quickcodes | varchar(25) | Yes | Hold Code | No |
| wrk_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| wrk_caused_by | fin_ctxt_user | varchar(30) | Yes | Work Delay Caused By | No |
| wrk_initiated_by | fin_ctxt_user | varchar(30) | Yes | Work Delay Initiated By | No |
| wrk_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No | |
| Table Name : | sal_cnt_ws_dtl |
| Comment : | Sales Contract Work Scope Definition details |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ws_cust_no | fin_customer_id | varchar(18) | Yes | Customer Number | No |
| ws_cnt_no | fin_documentno | varchar(40) | No | Contract Number | No |
| ws_revno | fin_rev_no | int(4) | No | Revision Number | No |
| ws_lineno | fin_lineno | int(4) | No | Line Number | No |
| ws_seqno | fin_seqno | int(4) | Yes | Sequence Number | No |
| ws_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance ID | No |
| ws_obj_ref | fin_reference | varchar(18) | Yes | Object Reference Type | No |
| ws_obj_ref_code | fin_effectivitycode | varchar(40) | Yes | Object Reference Code | No |
| ws_eff_cd | fin_effectivitycode | varchar(40) | Yes | Effectivity Code | No |
| ws_appl | fin_enum_cd | varchar(5) | Yes | Applicability Flag? | No |
| ws_task | fin_taskno | varchar(40) | Yes | Task Number | No |
| ws_WBS_cd | fin_quickcodes | varchar(25) | Yes | WBS Code | No |
| ws_pric_basis | fin_enum_cd | varchar(5) | Yes | Pricing Basis | No |
| ws_fxd_price_for | fin_enum_cd | varchar(5) | Yes | Fixed Price For | No |
| ws_notes | fin_notes | varchar(2000) | Yes | Notes | No |
| wS_up_revno | fin_rev_no | int(4) | Yes | Previous Revision Number | No |