|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| bill_ou | fin_ctxt_ouinstance | int(4) | No | OU instance | Yes |
| bill_cso_no | fin_documentno | varchar(40) | No | Customer no | Yes |
| bill_inv_rel_no | fin_rev_no | int(4) | No | Release no | Yes |
| bill_tsk_lineno | fin_lineno | int(4) | No | Task line no | Yes |
| bill_tsk_seqno | fin_lineno | int(4) | Yes | Task sequence no | No |
| bill_tsk_track_id | fin_tasktrackid | bigint(8) | Yes | Task track id | No |
| bill_tsk_no | fin_taskno | varchar(40) | Yes | Task no | No |
| bill_wbs_code | fin_quickcodes | varchar(25) | Yes | WBS code | No |
| bill_wbs_level | fin_int | int(4) | Yes | WBS level | No |
| bill_tot_cost | fin_amount | numeric(13) | Yes | Total cost | No |
| bill_rev_rec_amt | fin_amount | numeric(13) | Yes | Rev rec amount | No |
| bill_cso_currency | fin_currency | varchar(5) | Yes | Customer order currency | No |
| bill_price_basis | fin_enum_cd | varchar(5) | Yes | Price basis | No |
| bill_tm_mat_price | fin_price | numeric(13) | Yes | TM material price | No |
| bill_tm_lab_price | fin_price | numeric(13) | Yes | TM labour price | No |
| bill_tm_chg_price | fin_price | numeric(13) | Yes | TM charge price | No |
| bill_tm_tot_price | fin_price | numeric(13) | Yes | TM total price | No |
| bill_fp_mat_price | fin_price | numeric(13) | Yes | FP material price | No |
| bill_fp_lab_price | fin_price | numeric(13) | Yes | FP labour price | No |
| bill_fp_chg_price | fin_price | numeric(13) | Yes | FP charge price | No |
| bill_fp_tot_price | fin_price | numeric(13) | Yes | FP total price | No |
| bill_tm_org_mat_price | fin_price | numeric(13) | Yes | TM org material price | No |
| bill_tm_org_lab_price | fin_price | numeric(13) | Yes | TM org labour price | No |
| bill_tm_org_othser_price | fin_price | numeric(13) | Yes | TM org other service price | No |
| bill_tm_org_chg_price | fin_price | numeric(13) | Yes | TM org Charge price | No |
| bill_tm_org_tot_price | fin_price | numeric(13) | Yes | TM org Total price | No |
| bill_fp_org_mat_price | fin_price | numeric(13) | Yes | FP org material price | No |
| bill_fp_org_lab_price | fin_price | numeric(13) | Yes | FP org labour price | No |
| bill_fp_org_chg_price | fin_price | numeric(13) | Yes | FP org other service price | No |
| bill_fp_org_othser_price | fin_price | numeric(13) | Yes | FP org Charge price | No |
| bill_fp_org_tot_price | fin_price | numeric(13) | Yes | FP org Total price | No |
| bill_final_price | fin_price | numeric(13) | Yes | final price | No |
| bill_price_disposition | fin_Disposition | varchar(40) | Yes | Price disposition | No |
| bill_prim_task | fin_taskno | varchar(40) | Yes | Parent task no | No |
| bill_quoted | fin_enum_cd | varchar(5) | Yes | Quoted | No |
| bill_verified | fin_enum_cd | varchar(5) | Yes | Verified | No |
| bill_inv_rem | fin_remarks | varchar(100) | Yes | Invoice remarks | No |
| bill_sys_billable | fin_enum_cd | varchar(5) | Yes | Sys billable | No |
| bill_billable | fin_enum_cd | varchar(5) | Yes | Billable | No |
| bill_org_billable | fin_enum_cd | varchar(5) | Yes | Orginal billable | No |
| bill_coa | fin_enum_cd | varchar(5) | Yes | Coa | No |
| bill_org_coa | fin_enum_cd | varchar(5) | Yes | Orginal coa | No |
| bill_waranty_reco | fin_enum_cd | varchar(5) | Yes | Warranty reco | No |
| bill_org_waranty_reco | fin_enum_cd | varchar(5) | Yes | Orginal warranty reco | No |
| bill_price_naration | fin_Narration | varchar(500) | Yes | Price narration | No |
| bill_int_notes | fin_notes | varchar(2000) | Yes | Interanal notes | No |
| bill_rep_cls | fin_quickcodes | varchar(25) | Yes | Repair classification | No |
| bill_pricing_notes | fin_notes | varchar(2000) | Yes | Pricing notes | No |
| bill_pricing_tsk_no | fin_taskno | varchar(40) | Yes | Pricing task no | No |
| bill_coverage | fin_enum_cd | varchar(5) | Yes | coverage | No |
| bill_inc_exc_cd | fin_effectivitycode | varchar(40) | Yes | Incl Excl code | No |
| bill_inc_exc_notes | fin_notes | varchar(2000) | Yes | Incl Excl notes | No |
| bill_tsk_typ | fin_type | varchar(25) | Yes | Task type | No |
| bill_prt_no | fin_partno | varchar(40) | Yes | Part no | No |
| bill_mfr_prt_no | fin_partno | varchar(40) | Yes | MFR part no | No |
| bill_mfr_no | fin_partno | varchar(40) | Yes | MFR no | No |
| bill_srl_lot_no | fin_partserialnumber | varchar(40) | Yes | Serial lot no | No |
| bill_ac_reg | fin_acregno | varchar(30) | Yes | Aircraft reg no | No |
| bill_ata_no | fin_atanumber | varchar(16) | Yes | ATA no | No |
| bill_rep_proce_cd | fin_quickcodes | varchar(25) | Yes | Rep process code | No |
| bill_exec_doc_line_no | fin_lineno | int(4) | Yes | Execution document line no | No |
| bill_exec_doc_no | fin_documentno | varchar(40) | Yes | Execution document no | No |
| bill_parent_WO | fin_documentno | varchar(40) | Yes | Parent WO No | No |
| bill_wrk_center | fin_workcenter | varchar(80) | Yes | Work center | No |
| bill_indicator | fin_enum_cd | varchar(5) | Yes | Indicator | No |
| bill_process_id | fin_documentno | varchar(40) | Yes | Process id | No |
| bill_sub_process_id | fin_seqno | int(4) | Yes | Sub process id | No |
| bill_work_enum | fin_notes | varchar(2000) | Yes | Work enum | No |
| bill_tm_materials_flag | fin_flag | varchar(25) | Yes | TM material flag | No |
| bill_tm_labours_flag | fin_flag | varchar(25) | Yes | Tm labours flag | No |
| bill_tm_others_flag | fin_flag | varchar(25) | Yes | TM other resource flag | No |
| bill_fp_materials_flag | fin_flag | varchar(25) | Yes | FP material flag | No |
| bill_fp_labours_flag | fin_flag | varchar(25) | Yes | FP labours flag | No |
| bill_fp_others_flag | fin_flag | varchar(25) | Yes | FP other resource flag | No |
| bill_usage_flag | fin_flag | varchar(25) | Yes | Usage flag | No |
| bill_org_mat_pricingbasis | fin_enum_cd | varchar(5) | Yes | Orginal material pricing basis | No |
| bill_org_lab_pricingbasis | fin_enum_cd | varchar(5) | Yes | Orginal labour pricing basis | No |
| bill_org_oth_pricingbasis | fin_enum_cd | varchar(5) | Yes | Orginal other res pricing basis | No |
| bill_org_mat_excl_pricingbasis | fin_enum_cd | varchar(5) | Yes | Original material Excl pricing basis | No |
| bill_org_lab_excl_pricingbasis | fin_enum_cd | varchar(5) | Yes | Orginal labour Excl pricing basis | No |
| bill_org_oth_excl_pricingbasis | fin_enum_cd | varchar(5) | Yes | Orginal other res excl pricing basis | No |
| bill_fp_defnfor | fin_enum_cd | varchar(5) | Yes | Fp defnfor | No |
| bill_created_by | fin_ctxt_user | varchar(30) | Yes | created by | No |
| bill_created_date | fin_date | datetime(8) | Yes | created date | No |
| bill_modified_by | fin_ctxt_user | varchar(30) | Yes | modified by | No |
| bill_modified_date | fin_date | datetime(8) | Yes | modified date | No |
| bill_priced_flag | fin_flag | varchar(25) | Yes | priced falg | No |
| bill_mat_cost | fin_cost | numeric(13) | Yes | Material cost | No |
| bill_res_cost | fin_cost | numeric(13) | Yes | Resorce cost | No |
| bill_chg_cost | fin_cost | numeric(13) | Yes | Charges cost | No |
| bill_oth_cost | fin_cost | numeric(13) | Yes | Other resource cost | No |
| bill_revrec_mat_cost | fin_cost | numeric(13) | Yes | Rev rec material cost | No |
| bill_revrec_res_cost | fin_cost | numeric(13) | Yes | Rev rec resource cost | No |
| bill_revrec_chg_cost | fin_cost | numeric(13) | Yes | Rev rec chrges cost | No |
| bill_revrec_oth_cost | fin_cost | numeric(13) | Yes | rev rec other resource cost | No |
| bill_revrec_tot_cost | fin_cost | numeric(13) | Yes | Erv rec total cost | No |
| bill_revrec_mat_amt | fin_amount | numeric(13) | Yes | rev rec materialamount | No |
| bill_revrec_res_amt | fin_amount | numeric(13) | Yes | rev rec resource amount | No |
| bill_revrec_chg_amt | fin_amount | numeric(13) | Yes | rev rec charges amount | No |
| bill_revrec_oth_amt | fin_amount | numeric(13) | Yes | rev rec other resource amount | No |
| bill_revrec_tot_amt | fin_amount | numeric(13) | Yes | rev rec total amount | No |
| bill_exec_doc_type | fin_doctype | varchar(40) | Yes | Execution document type | No |
| bill_mod_notes | fin_notes | varchar(2000) | Yes | Modification notes | No |
| bill_ws_ref_code | fin_price | numeric(13) | Yes | Workscope ref code | No |
| bill_coa_exists | fin_effectivitycode | varchar(40) | Yes | COA exists | No |
| bill_tm_othres_price | fin_flag | varchar(25) | Yes | TM other resource price | No |
| bill_fp_othres_price | fin_price | numeric(13) | Yes | FP other resource price | No |
| bill_qt_app_sts | fin_status | varchar(25) | Yes | Quote approved status | No |
| bill_ws_ref_notes | fin_notes | varchar(2000) | Yes | Workscope ref notes | No |
| bill_processed | fin_yesnoflag | varchar(5) | Yes | Processed | No |
| bill_rev_indicator | fin_flag | varchar(25) | Yes | Revision indicator | No |
| bill_fp_pricesource | fin_flag | varchar(25) | Yes | FP price source | No |
| bill_tsk_status | fin_status | varchar(25) | Yes | Task status | No |
| bill_mat_cost_cocurr | fin_amount | numeric(13) | Yes | Material cost CO currency | No |
| bill_res_cost_cocurr | fin_amount | numeric(13) | Yes | Resource cost CO currency | No |
| bill_tot_cost_cocurr | fin_amount | numeric(13) | Yes | Total cost CO currency | No |
| bill_exchordeno | fin_documentno | varchar(40) | Yes | Exchange order no | No |
| bill_exchange_type | fin_doctype | varchar(40) | Yes | Exchange type | No |
| bill_exch_initiatedas | fin_enum | varchar(40) | Yes | Exchange initiated as | No |
| bill_exch_indicator | fin_indicator | Char(25) | Yes | Exchange indicator | No |
| bill_reason_forexch | fin_reason | varchar(256) | Yes | Reason for exchange | No |
| bill_billingdocno | fin_documentno | varchar(40) | Yes | Billing document no | No |
| bill_billingfor | fin_doctype | varchar(40) | Yes | Billing for | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes |
| bill_tsk_desc | fin_item_desc | varchar(150) | Yes | Task description | No |
| bill_prim_tsk_desc | fin_item_desc | varchar(150) | Yes | Primary task description | No |
| bill_price_tsk_desc | fin_item_desc | varchar(150) | Yes | Price task description | No |
| bill_marginpercent | fin_percent | Numeric(17) | Yes | Margin percent | No |
| bill_tsk_ref_date | fin_date | datetime(8) | Yes | Task ref date | No |
| bill_exch_core_sts | fin_status | varchar(25) | Yes | Exchange core status | No |
| bill_FP_ConRev_no | fin_rev_no | int(4) | Yes | FP Con Revision no | No |
| bill_tsk_src_doc_no | fin_documentno | varchar(40) | Yes | bill_tsk_src_doc_no | No |
| bill_fp_ref | fin_rev_no | int(4) | Yes | bill_fp_ref | No |
| bill_log | fin_notes | varchar(2000) | Yes | bill_log | No |
| bill_incl_cd | fin_effectivitycode | varchar(40) | Yes | bill_incl_cd | No |
| bill_tm_ext_price | fin_amount | numeric(13) | Yes | bill_tm_ext_price | No |
| bill_log_coa | fin_designparamcode | varchar(5) | Yes | bill_log_coa | No |
| bill_log_warr_res | fin_designparamcode | varchar(5) | Yes | bill_log_warr_res | No |
| bill_log_billable | fin_designparamcode | varchar(5) | Yes | bill_log_billable | No |
| bill_log_fp_mat | fin_price | numeric(13) | Yes | bill_log_fp_mat | No |
| bill_log_fp_res | fin_price | numeric(13) | Yes | bill_log_fp_res | No |
| bill_log_fp_othres | fin_price | numeric(13) | Yes | bill_log_fp_othres | No |
| bill_log_fp_tot | fin_price | numeric(13) | Yes | bill_log_fp_tot | No |
| bill_co_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | bill_co_eff_ref_cd | No |
| bill_tsk_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | bill_tsk_eff_ref_cd | No |
| bill_co_eff_ref_lineno | fin_lineno | int(4) | Yes | bill_co_eff_ref_lineno | No |
| bill_discrepancy_type | fin_designparamcode | varchar(5) | Yes | bill_discrepancy_type | No |
| bill_discrepancy_cat | fin_quickcodes | varchar(25) | Yes | bill_discrepancy_cat | No |
| bill_discrepancy_Rep_class | fin_repairclassification | varchar(25) | Yes | bill_discrepancy_Rep_class | No |
| bill_disctsk_flag | fin_flag | varchar(25) | Yes | bill_disctsk_flag | No |
| bill_parent_tsk_trackid | fin_tasktrackid | bigint(8) | Yes | bill_parent_tsk_trackid | No |
| bill_root_tsk_trackid | fin_tasktrackid | bigint(8) | Yes | bill_root_tsk_trackid | No |
| bill_pricingtsk_trackid | fin_tasktrackid | bigint(8) | Yes | bill_pricingtsk_trackid | No |
| bill_prim_wrk_center | fin_workcenter | varchar(80) | Yes | bill_prim_wrk_center | No |
| bill_rtb_analysis | fin_description | varchar(100) | Yes | rtb analysis task level | No |
| bill_root_prt_no | fin_partno | varchar(40) | Yes | bill_root_prt_no | No |
| bill_root_prt_qty | fin_quantity | numeric(17) | Yes | bill_root_prt_qty | No |
| bill_prt_qty | fin_quantity | numeric(17) | Yes | bill_prt_qty | No |
| bill_mat_unit_price | fin_amount | numeric(13) | Yes | bill_mat_unit_price | No |
| bill_res_unit_price | fin_amount | numeric(13) | Yes | bill_res_unit_price | No |
| bill_oth_unit_price | fin_amount | numeric(13) | Yes | bill_oth_unit_price | No |
| bill_tot_unit_price | fin_amount | numeric(13) | Yes | bill_tot_unit_price | No |
| bill_scrap_qty | fin_quantity | numeric(17) | Yes | bill_scrap_qty | No |
| bill_mod_qty | fin_quantity | numeric(17) | Yes | bill_mod_qty | No |
| bill_sys_qty | fin_quantity | numeric(17) | Yes | bill_sys_qty | No |
| bill_qty_ref | fin_description | varchar(100) | Yes | bill_qty_ref | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| chg_ou | fin_ctxt_ouinstance | int(4) | No | OU insatance | Yes |
| chg_cso_no | fin_documentno | varchar(40) | No | Customer number | Yes |
| chg_inv_rel_no | fin_rev_no | int(4) | No | Release number | Yes |
| chg_tsk_lineno | fin_lineno | int(4) | No | Task line number | Yes |
| chg_lineno | fin_lineno | int(4) | No | Line no | Yes |
| chg_tsk_seqno | fin_seqno | int(4) | Yes | Task sequence no | No |
| chg_indicator | fin_enum_cd | varchar(5) | Yes | Indicator | No |
| chg_cap | fin_enum_cd | varchar(5) | Yes | Cap | No |
| chg_charge_source | fin_enum_cd | varchar(5) | Yes | Charge source | No |
| chg_chargecode | fin_itemtcd | varchar(40) | Yes | Charge code | No |
| chg_variant | fin_tcdvariant | varchar(25) | Yes | Variant | No |
| chg_amount | fin_amount | numeric(13) | Yes | Amount | No |
| chg_currency | fin_currency | varchar(5) | Yes | Currency | No |
| chg_pricing_factor | fin_factor | numeric(13) | Yes | Pricing factor | No |
| chg_markup | fin_markup | numeric(9) | Yes | Markup | No |
| chg_capped_markup | fin_markup | numeric(9) | Yes | Capped markup | No |
| chg_accountusage | fin_usageid | varchar(20) | Yes | accountusage | No |
| chg_costcenter | fin_costcentercode | varchar(10) | Yes | Cost center | No |
| chg_final_charge | fin_amount | numeric(13) | Yes | Final charge | No |
| chg_ext_price | fin_price | numeric(13) | Yes | Ext price | No |
| chg_coa | fin_enum_cd | varchar(5) | Yes | Coa | No |
| chg_org_coa | fin_enum_cd | varchar(5) | Yes | Org Coa | No |
| chg_org_billable | fin_enum_cd | varchar(5) | Yes | Org billable | No |
| chg_billable | fin_enum_cd | varchar(5) | Yes | Billable | No |
| chg_pricenarration | fin_Narration | varchar(500) | Yes | Price narration | No |
| chg_internalnotes | fin_notes | varchar(2000) | Yes | Internal notes | No |
| chg_remarks | fin_remarks | varchar(100) | Yes | Remarks | No |
| chg_last_updated_log | fin_Log | varchar(1000) | Yes | Last updated log | No |
| chg_pricing_notes | fin_notes | varchar(2000) | Yes | Pricing notes | No |
| chg_pricing_basis | fin_enum_cd | varchar(5) | Yes | Pricing basis | No |
| chg_price_disposition | fin_Disposition | varchar(40) | Yes | Price disposition | No |
| chg_estimated_remarks | fin_remarks | varchar(100) | Yes | Estimated remarks | No |
| chg_pricing_description | fin_notes | varchar(2000) | Yes | Pricing description | No |
| chg_spl | fin_documentno | varchar(40) | Yes | Servicepricelistno | No |
| chg_spl_revno | fin_rev_no | int(4) | Yes | Servicepricelist rev no | No |
| chg_created_by | fin_ctxt_user | varchar(30) | Yes | Created by | No |
| chg_created_date | fin_date | datetime(8) | Yes | Created date | No |
| chg_modified_by | fin_ctxt_user | varchar(30) | Yes | Modified by | No |
| chg_modified_date | fin_date | datetime(8) | Yes | Modified date | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ext_cso_no | fin_documentno | varchar(40) | No | ext_cso_no | Yes |
| ext_inv_rel_no | fin_releaseno | int(4) | No | ext_inv_rel_no | Yes |
| ext_lineno | fin_lineno | int(4) | No | ext_lineno | Yes |
| ext_ou | fin_ctxt_ouinstance | int(4) | No | ext_ou | Yes |
| ext_indicator | fin_indicator | Char(25) | Yes | ext_indicator | No |
| ext_rev_indicator | fin_indicator | Char(25) | Yes | ext_rev_indicator | No |
| ext_price_disposition | fin_Disposition | varchar(40) | Yes | ext_price_disposition | No |
| ext_exec_doc_type | fin_doctype | varchar(40) | Yes | ext_exec_doc_type | No |
| ext_exec_doc_no | fin_documentno | varchar(40) | Yes | ext_exec_doc_no | No |
| ext_parent_wo_no | fin_documentno | varchar(40) | Yes | ext_parent_wo_no | No |
| ext_doc_type | fin_doctype | varchar(40) | Yes | ext_doc_type | No |
| ext_doc_no | fin_documentno | varchar(40) | Yes | ext_doc_no | No |
| ext_doc_status | fin_status | varchar(25) | Yes | ext_doc_status | No |
| ext_exch_indicator | fin_indicator | Char(25) | Yes | ext_exch_indicator | No |
| ext_supplier_no | fin_vendorcode | varchar(45) | Yes | ext_supplier_no | No |
| ext_supplier_name | fin_txt150 | varchar(150) | Yes | ext_supplier_name | No |
| ext_pricing_basis | fin_basis | varchar(8) | Yes | ext_pricing_basis | No |
| ext_billing_element | fin_designparamcode | varchar(5) | Yes | ext_billing_element | No |
| ext_part_doc_no | fin_partno | varchar(40) | Yes | ext_part_doc_no | No |
| ext_part_doc_desc | fin_description | varchar(100) | Yes | ext_part_doc_desc | No |
| ext_part_attribute | fin_Narration | varchar(500) | Yes | ext_part_attribute | No |
| ext_prime_part_no | fin_partno | varchar(40) | Yes | ext_prime_part_no | No |
| ext_part_group | fin_partgroup | varchar(40) | Yes | ext_part_group | No |
| ext_quantity | fin_quantity | numeric(17) | Yes | ext_quantity | No |
| ext_uom | fin_uom | varchar(15) | Yes | ext_uom | No |
| ext_fact_applied_on | fin_designparamcode | varchar(5) | Yes | ext_fact_applied_on | No |
| ext_basic_rate_cocurr | fin_rate | numeric(13) | Yes | ext_basic_rate_cocurr | No |
| ext_unit_tax_cocurr | fin_rate | numeric(13) | Yes | ext_unit_tax_cocurr | No |
| ext_unit_charge_cocurr | fin_rate | numeric(13) | Yes | ext_unit_charge_cocurr | No |
| ext_unit_discount_cocurr | fin_rate | numeric(13) | Yes | ext_unit_discount_cocurr | No |
| ext_ref_rate_cocurr | fin_rate | numeric(13) | Yes | ext_ref_rate_cocurr | No |
| ext_basic_amt_cocurr | fin_amount | numeric(13) | Yes | ext_basic_amt_cocurr | No |
| ext_covered_base_rate | fin_rate | numeric(13) | Yes | ext_covered_base_rate | No |
| ext_adj_base_rate | fin_rate | numeric(13) | Yes | ext_adj_base_rate | No |
| ext_final_base_rate | fin_rate | numeric(13) | Yes | ext_final_base_rate | No |
| ext_price_factor | fin_amount | numeric(13) | Yes | ext_price_factor | No |
| ext_unit_markup | fin_amount | numeric(13) | Yes | ext_unit_markup | No |
| ext_capon_unit_markup | fin_amount | numeric(13) | Yes | ext_capon_unit_markup | No |
| ext_adj_unit_markup | fin_amount | numeric(13) | Yes | ext_adj_unit_markup | No |
| ext_final_unit_markup | fin_amount | numeric(13) | Yes | ext_final_unit_markup | No |
| ext_unit_price | fin_price | numeric(13) | Yes | ext_unit_price | No |
| ext_cov_unit_price | fin_price | numeric(13) | Yes | ext_cov_unit_price | No |
| ext_adj_unit_price | fin_price | numeric(13) | Yes | ext_adj_unit_price | No |
| ext_final_unit_price | fin_price | numeric(13) | Yes | ext_final_unit_price | No |
| ext_extnd_basic_price | fin_price | numeric(13) | Yes | ext_extnd_basic_price | No |
| ext_extnd_markup | fin_amount | numeric(13) | Yes | ext_extnd_markup | No |
| ext_capon_extnd_markup | fin_amount | numeric(13) | Yes | ext_capon_extnd_markup | No |
| ext_adj_extnd_markup | fin_amount | numeric(13) | Yes | ext_adj_extnd_markup | No |
| ext_fin_extnd_markup | fin_amount | numeric(13) | Yes | ext_fin_extnd_markup | No |
| ext_price | fin_price | numeric(13) | Yes | ext_price | No |
| ext_cov_extnd_price | fin_price | numeric(13) | Yes | ext_cov_extnd_price | No |
| ext_adj_extnd_price | fin_price | numeric(13) | Yes | ext_adj_extnd_price | No |
| ext_fin_extnd_price | fin_price | numeric(13) | Yes | ext_fin_extnd_price | No |
| ext_max_extnd_price | fin_price | numeric(13) | Yes | ext_max_extnd_price | No |
| ext_final_price | fin_price | numeric(13) | Yes | ext_final_price | No |
| ext_cap_notes | fin_notes | varchar(2000) | Yes | ext_cap_notes | No |
| ext_wrk_center_no | fin_workcenter | varchar(80) | Yes | ext_wrk_center_no | No |
| ext_tsk_status | fin_status | varchar(25) | Yes | ext_tsk_status | No |
| ext_quoted | fin_flag | varchar(25) | Yes | ext_quoted | No |
| ext_quot_app_status | fin_status | varchar(25) | Yes | ext_quot_app_status | No |
| ext_processed | fin_flag | varchar(25) | Yes | ext_processed | No |
| ext_remarks | fin_notes | varchar(2000) | Yes | ext_remarks | No |
| ext_sys_billable | fin_enum_cd | varchar(5) | Yes | ext_sys_billable | No |
| ext_billable | fin_enum_cd | varchar(5) | Yes | ext_billable | No |
| ext_coa | fin_enum_cd | varchar(5) | Yes | ext_coa | No |
| ext_warratny_reco | fin_enum_cd | varchar(5) | Yes | ext_warratny_reco | No |
| ext_warranty_res | fin_enum_cd | varchar(5) | Yes | ext_warranty_res | No |
| ext_price_narration | fin_notes | varchar(2000) | Yes | ext_price_narration | No |
| ext_int_notes | fin_notes | varchar(2000) | Yes | ext_int_notes | No |
| ext_task_type | fin_type | varchar(25) | Yes | ext_task_type | No |
| ext_rep_class | fin_repairclassification | varchar(25) | Yes | ext_rep_class | No |
| ext_rep_process_code | fin_repairprocesscode | varchar(25) | Yes | ext_rep_process_code | No |
| ext_pricing_tsk_no | fin_partno | varchar(40) | Yes | ext_pricing_tsk_no | No |
| ext_pricing_tsk_desc | fin_description | varchar(100) | Yes | ext_pricing_tsk_desc | No |
| ext_parent_tsk_no | fin_partno | varchar(40) | Yes | ext_parent_tsk_no | No |
| ext_parent_tsk_desc | fin_description | varchar(100) | Yes | ext_parent_tsk_desc | No |
| ext_ws_ref_code | fin_documentno | varchar(40) | Yes | ext_ws_ref_code | No |
| ext_ws_notes | fin_notes | varchar(2000) | Yes | ext_ws_notes | No |
| ext_inc_excl_code | fin_documentno | varchar(40) | Yes | ext_inc_excl_code | No |
| ext_inc_excl_notes | fin_notes | varchar(2000) | Yes | ext_inc_excl_notes | No |
| ext_part_no | fin_partno | varchar(40) | Yes | ext_part_no | No |
| ext_mfr_part_no | fin_partno | varchar(40) | Yes | ext_mfr_part_no | No |
| ext_mfr_no | fin_vendorcode | varchar(45) | Yes | ext_mfr_no | No |
| ext_prt_srl_lot_no | fin_partserialnumber | varchar(40) | Yes | ext_prt_srl_lot_no | No |
| ext_part_desc | fin_description | varchar(100) | Yes | ext_part_desc | No |
| ext_ata_no | fin_documentno | varchar(40) | Yes | ext_ata_no | No |
| ext_ata_desc | fin_description | varchar(100) | Yes | ext_ata_desc | No |
| ext_ac_reg_no | fin_acregno | varchar(30) | Yes | ext_ac_reg_no | No |
| ext_last_updt_log | fin_notes | varchar(2000) | Yes | ext_last_updt_log | No |
| ext_pricing_source | fin_flag | varchar(25) | Yes | ext_pricing_source | No |
| ext_modify_notes | fin_notes | varchar(2000) | Yes | ext_modify_notes | No |
| ext_modified_by | fin_ctxt_user | varchar(30) | Yes | ext_modified_by | No |
| ext_modified_date | fin_date | datetime(8) | Yes | ext_modified_date | No |
| ext_proc_lineno | fin_lineno | int(4) | Yes | ext_proc_lineno | No |
| ext_co_curr | fin_currency | varchar(5) | Yes | ext_co_curr | No |
| ext_doc_lineno | fin_lineno | int(4) | Yes | ext_doc_lineno | No |
| ext_exch_rate | fin_rate | numeric(13) | Yes | ext_exch_rate | No |
| ext_doc_curr | fin_currency | varchar(5) | Yes | ext_doc_curr | No |
| ext_spl_no | fin_documentno | varchar(40) | Yes | ext_spl_no | No |
| ext_spl_ou | fin_ctxt_ouinstance | int(4) | Yes | ext_spl_ou | No |
| ext_total_cost | fin_amount | numeric(13) | Yes | ext_total_cost | No |
| ext_cost | fin_amount | numeric(13) | Yes | ext_cost | No |
| ext_spl_revision | fin_rev_no | int(4) | Yes | ext_spl_revision | No |
| ext_cap_indicator | fin_indicator | Char(25) | Yes | ext_cap_indicator | No |
| ext_ref_doc_no | fin_documentno | varchar(40) | Yes | ext_ref_doc_no | No |
| ext_priced_flag | fin_flag | varchar(25) | Yes | ext_priced_flag | No |
| ext_pg_price_facton | fin_designparamcode | varchar(5) | Yes | ext_pg_price_facton | No |
| ext_pricing_element | fin_designparamcode | varchar(5) | Yes | ext_pricing_element | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| mat_ou | fin_ctxt_ouinstance | int(4) | No | OU instance | Yes |
| mat_cso_no | fin_documentno | varchar(40) | No | Customer order no | Yes |
| mat_inv_rel_no | fin_rev_no | int(4) | No | Invoice release no | Yes |
| mat_tsk_lineno | fin_lineno | int(4) | No | Task line no | Yes |
| mat_lineno | fin_lineno | int(4) | No | Line no | Yes |
| mat_tsk_seqno | fin_seqno | int(4) | Yes | Task sequence no | No |
| mat_indicator | fin_enum_cd | varchar(5) | Yes | Indicator | No |
| mat_caps | fin_enum_cd | varchar(5) | Yes | Caps | No |
| mat_part_no | fin_partno | varchar(40) | Yes | Part no | No |
| mat_mfr_part_no | fin_partno | varchar(40) | Yes | MFR part no | No |
| mat_mfr_no | fin_partno | varchar(40) | Yes | Mfr no | No |
| mat_part_condition | fin_condition | varchar(15) | Yes | Part condition | No |
| mat_stock_status | fin_stockstatus | varchar(40) | Yes | Stock status | No |
| mat_part_attributes | fin_attributes | varchar(30) | Yes | Part attributes | No |
| mat_part_group | fin_quickcodes | varchar(25) | Yes | Part group | No |
| mat_part_type | fin_enum_cd | varchar(5) | Yes | Part type | No |
| mat_part_cls | fin_quickcodes | varchar(25) | Yes | Part cls | No |
| mat_llp | fin_enum_cd | varchar(5) | Yes | LLP | No |
| mat_repl_type | fin_enum_cd | varchar(5) | Yes | Repl type | No |
| mat_price_element | fin_element | varchar(80) | Yes | Price element | No |
| mat_cons_qty | fin_quantity | numeric(17) | Yes | Cons quantity | No |
| mat_uom | fin_uom | varchar(15) | Yes | UOM | No |
| mat_unit_rate | fin_rate | numeric(13) | Yes | unit rate | No |
| mat_base_adj_fac | fin_factor | numeric(13) | Yes | Base Adj factor | No |
| mat_adjust_unit_rate | fin_rate | numeric(13) | Yes | Adjust unit rate | No |
| mat_ext_amt | fin_amount | numeric(13) | Yes | Ext amount | No |
| mat_price_factor | fin_factor | numeric(13) | Yes | Price factor | No |
| mat_ext_mark_up | fin_markup | numeric(9) | Yes | Ext markup | No |
| mat_capped_mark_up | fin_markup | numeric(9) | Yes | Capped Mark up | No |
| mat_ext_price | fin_price | numeric(13) | Yes | Ext price | No |
| mat_capped_ext_price | fin_price | numeric(13) | Yes | Capped Ext price | No |
| mat_final_price | fin_price | numeric(13) | Yes | Final price | No |
| mat_pricing_disposition | fin_Disposition | varchar(40) | Yes | Pricing disposition | No |
| mat_pricing_basis | fin_enum_cd | varchar(5) | Yes | Pricing basis | No |
| mat_pg_cost | fin_cost | numeric(13) | Yes | Pg cost | No |
| mat_cap_grouping | fin_paramdesc | varchar(30) | Yes | Cap grouping | No |
| mat_quoted | fin_enum_cd | varchar(5) | Yes | quoted | No |
| mat_processed | fin_enum_cd | varchar(5) | Yes | Processed | No |
| mat_remarks | fin_remarks | varchar(100) | Yes | Remarks | No |
| mat_est_remarks | fin_remarks | varchar(100) | Yes | Est remarks | No |
| mat_sys_billable | fin_enum_cd | varchar(5) | Yes | Sys billable | No |
| mat_coa | fin_enum_cd | varchar(5) | Yes | Coa | No |
| mat_billable | fin_enum_cd | varchar(5) | Yes | Billable | No |
| mat_waranty_reco | fin_enum_cd | varchar(5) | Yes | Warranty reco | No |
| mat_price_narration | fin_Narration | varchar(500) | Yes | price narration | No |
| mat_internal_notes | fin_notes | varchar(2000) | Yes | Internal notes | No |
| mat_ppl | fin_documentno | varchar(40) | Yes | Part pricelist no | No |
| mat_ppl_revno | fin_rev_no | int(4) | Yes | Part pricelist rev no | No |
| mat_ref_cataloge_id | fin_quickcodes | varchar(25) | Yes | Ref catalogue id | No |
| mat_pricing_description | fin_notes | varchar(2000) | Yes | Pricing description | No |
| mat_pricing_notes | fin_notes | varchar(2000) | Yes | Pricing notes | No |
| mat_ref_currency | fin_currency | varchar(5) | Yes | Refernce currency | No |
| mat_exch_rate | fin_rate | numeric(13) | Yes | Exchange rate | No |
| mat_rep_class | fin_quickcodes | varchar(25) | Yes | Repair classification | No |
| mat_inc_exc_ref_cod | fin_effectivitycode | varchar(40) | Yes | Incl Excl ref code | No |
| mat_log | fin_Log | varchar(1000) | Yes | Log | No |
| mat_created_by | fin_ctxt_user | varchar(30) | Yes | Created by | No |
| mat_created_date | fin_date | datetime(8) | Yes | Created date | No |
| mat_modified_by | fin_ctxt_user | varchar(30) | Yes | Modified by | No |
| mat_modified_date | fin_date | datetime(8) | Yes | Modified date | No |
| mat_cso_currency | fin_currency | varchar(5) | Yes | CSO currency | No |
| mat_pg_ref_ppl_no | fin_documentno | varchar(40) | Yes | PG ref PPL no | No |
| mat_pg_exch_rate_date | fin_date | datetime(8) | Yes | PG exchange rate | No |
| mat_pg_price_facton | fin_designparamcode | varchar(5) | Yes | PG price fact on | No |
| mat_pg_process_seq | fin_seqno | int(4) | Yes | PG process sequence | No |
| mat_pg_std_cost | fin_amount | numeric(13) | Yes | Pg std cost | No |
| mat_pg_markup | fin_amount | numeric(13) | Yes | Pg markup | No |
| mat_pg_total_price | fin_amount | numeric(13) | Yes | PG total price | No |
| mat_pg_adjunit_rate | fin_amount | numeric(13) | Yes | PG adjunit rate | No |
| mat_pg_total_price_cocurr | fin_amount | numeric(13) | Yes | PG total price co currency | No |
| mat_pg_price_criteria | fin_flag | varchar(25) | Yes | PG price criteria | No |
| mat_pg_mult_criteria_match | fin_flag | varchar(25) | Yes | pg mult criteria match | No |
| mat_pg_matcount | fin_int | int(4) | Yes | PG mat count | No |
| mat_pg_sourceflag | fin_flag | varchar(25) | Yes | Source flag | No |
| mat_contractno | fin_documentno | varchar(40) | Yes | contract no | No |
| mat_pg_ref_pplno | fin_documentno | varchar(40) | Yes | PG ref partpricelist no | No |
| mat_pg_ref_pplrevno | fin_rev_no | int(4) | Yes | PG ref partpricelist rev no | No |
| mat_pg_ref_ppl_curr | fin_currency | varchar(5) | Yes | PG ref PPL currency | No |
| mat_pg_typeofsale | fin_flag | varchar(25) | Yes | PG typeof sale | No |
| mat_markup_cocurr | fin_amount | numeric(13) | Yes | Markup co currency | No |
| mat_cost | fin_cost | numeric(13) | Yes | Material cost | No |
| mat_base_rate_pl_cur | fin_rate | numeric(13) | Yes | Base rate PL currency | No |
| mat_base_rate_cso_cur | fin_rate | numeric(13) | Yes | Base rate CSO currency | No |
| mat_cap_notes | fin_notes | varchar(2000) | Yes | Cap notes | No |
| mat_quot_app_sts | fin_status | varchar(25) | Yes | Quote approved status | No |
| mat_inc_exc_ref_notes | fin_notes | varchar(2000) | Yes | Incl excl ref notes | No |
| mat_pg_source | fin_flag | varchar(25) | Yes | Pg source | No |
| mat_unit_markup | fin_amount | numeric(13) | Yes | Unit markup | No |
| mat_caped_unit_markup | fin_amount | numeric(13) | Yes | Caped unit markup | No |
| mat_final_unit_markup | fin_amount | numeric(13) | Yes | Final unit markup | No |
| mat_unit_price | fin_price | numeric(13) | Yes | Unit price | No |
| mat_cov_unit_price | fin_price | numeric(13) | Yes | Covered unit price | No |
| mat_cap_unit_price | fin_price | numeric(13) | Yes | Capped unit price | No |
| mat_final_unit_price | fin_price | numeric(13) | Yes | Final unit price | No |
| mat_ext_base_price | fin_price | numeric(13) | Yes | Ext base price | No |
| mat_cap_cov_price | fin_price | numeric(13) | Yes | Capped covered price | No |
| mat_cov_price | fin_price | numeric(13) | Yes | Covered price | No |
| mat_mod_notes | fin_notes | varchar(2000) | Yes | Modification notes | No |
| mat_fin_ext_markup | fin_markup | numeric(9) | Yes | Final Ext markup | No |
| mat_fac_base_rate | fin_rate | numeric(13) | Yes | Fac base rate | No |
| mat_org_waranty_reco | fin_enum_cd | varchar(5) | Yes | Org warranty reco | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes |
| mat_exchorderno | fin_documentno | varchar(40) | Yes | Exchange order no | No |
| mat_prime_partno | fin_partno | varchar(40) | Yes | Prime partno | No |
| mat_component_id | fin_component_id | varchar(40) | Yes | Component id | No |
| mat_partgroup | fin_partgroup | varchar(40) | Yes | PartGroup | No |
| mat_ref_rate | fin_price | numeric(13) | Yes | Ref rate | No |
| mat_covered_baserate | fin_price | numeric(13) | Yes | Covered base rate | No |
| mat_adj_baserate | fin_price | numeric(13) | Yes | Adj base rate | No |
| mat_final_base_rate | fin_price | numeric(13) | Yes | Final base rate | No |
| mat_cap_onunit_markup | fin_price | numeric(13) | Yes | Cap on unit markup | No |
| mat_cap_onext_markup | fin_price | numeric(13) | Yes | Cap on ext markup | No |
| mat_final_ext_price | fin_price | numeric(13) | Yes | Final ext price | No |
| mat_part_desc | fin_flag | varchar(25) | Yes | mat_part_desc | No |
| mat_factored_on | fin_designparamcode | varchar(5) | Yes | mat_factored_on | No |
| mat_srl_lineno | fin_designparamcode | varchar(5) | Yes | mat_srl_lineno | No |
| mat_prt_seqno | fin_seqno | int(4) | Yes | Null | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ext_cso_no | fin_documentno | varchar(40) | No | ext_cso_no | Yes |
| ext_inv_rel_no | fin_releaseno | int(4) | No | ext_inv_rel_no | Yes |
| ext_ouinst_id | fin_ctxt_ouinstance | int(4) | No | ext_ouinst_id | Yes |
| ext_lineno | fin_lineno | int(4) | No | ext_lineno | Yes |
| ext_brk_lineno | fin_lineno | int(4) | No | ext_brk_lineno | Yes |
| ext_indicator | fin_flag | varchar(25) | Yes | ext_indicator | No |
| ext_process_id | fin_seqno | int(4) | Yes | ext_process_id | No |
| ext_sub_process_id | fin_seqno | int(4) | Yes | ext_sub_process_id | No |
| ext_ou_id | fin_ctxt_ouinstance | int(4) | Yes | ext_ou_id | No |
| ext_Doc_no | fin_documentno | varchar(40) | Yes | ext_Doc_no | No |
| ext_Doc_line_no | fin_lineno | int(4) | Yes | ext_Doc_line_no | No |
| ext_part_no | fin_partno | varchar(40) | Yes | ext_part_no | No |
| ext_mfr_part_no | fin_partno | varchar(40) | Yes | ext_mfr_part_no | No |
| ext_mfr_no | fin_vendorcode | varchar(45) | Yes | ext_mfr_no | No |
| ext_part_condition | fin_condition | varchar(15) | Yes | ext_part_condition | No |
| ext_Part_stk_status | fin_status | varchar(25) | Yes | ext_Part_stk_status | No |
| ext_Exch_class | fin_type | varchar(25) | Yes | ext_Exch_class | No |
| ext_Exch_type | fin_type | varchar(25) | Yes | ext_Exch_type | No |
| ext_Exch_reason | fin_reasoncode | varchar(10) | Yes | ext_Exch_reason | No |
| ext_Billable | fin_enum_cd | varchar(5) | Yes | ext_Billable | No |
| ext_Doc_line_status | fin_status | varchar(25) | Yes | ext_Doc_line_status | No |
| ext_Doc_line_remarks | fin_notes | varchar(2000) | Yes | ext_Doc_line_remarks | No |
| ext_Element | fin_designparamcode | varchar(5) | Yes | ext_Element | No |
| ext_Quantity | fin_quantity | numeric(17) | Yes | ext_Quantity | No |
| ext_UOM | fin_uom | varchar(15) | Yes | ext_UOM | No |
| ext_Cost | fin_amount | numeric(13) | Yes | ext_Cost | No |
| ext_Rep_BER_Cost | fin_amount | numeric(13) | Yes | ext_Rep_BER_Cost | No |
| ext_Exch_fee | fin_amount | numeric(13) | Yes | ext_Exch_fee | No |
| ext_Non_Rtn_Cost | fin_amount | numeric(13) | Yes | ext_Non_Rtn_Cost | No |
| ext_Total_cost | fin_amount | numeric(13) | Yes | ext_Total_cost | No |
| ext_org_Rep_BER_Cost | fin_amount | numeric(13) | Yes | ext_org_Rep_BER_Cost | No |
| ext_org_Exch_fee | fin_amount | numeric(13) | Yes | ext_org_Exch_fee | No |
| ext_org_Non_Rtn_Cost | fin_amount | numeric(13) | Yes | ext_org_Non_Rtn_Cost | No |
| ext_Exch_part_no | fin_partno | varchar(40) | Yes | ext_Exch_part_no | No |
| ext_Exch_mfr_part_no | fin_partno | varchar(40) | Yes | ext_Exch_mfr_part_no | No |
| ext_Exchpart_mfr_no | fin_vendorcode | varchar(45) | Yes | ext_Exchpart_mfr_no | No |
| ext_Exch_part_condition | fin_condition | varchar(15) | Yes | ext_Exch_part_condition | No |
| ext_Exch_Part_stk_status | fin_status | varchar(25) | Yes | ext_Exch_Part_stk_status | No |
| ext_Exch_Part_Ownership | fin_status | varchar(25) | Yes | ext_Exch_Part_Ownership | No |
| ext_Exch_Source_CO_no | fin_documentno | varchar(40) | Yes | ext_Exch_Source_CO_no | No |
| ext_ppl_no | fin_documentno | varchar(40) | Yes | ext_ppl_no | No |
| ext_ppl_ou | fin_ctxt_ouinstance | int(4) | Yes | ext_ppl_ou | No |
| ext_ppl_revision | fin_int | int(4) | Yes | ext_ppl_revision | No |
| ext_pricing_element | fin_desc20 | varchar(20) | Yes | ext_pricing_element | No |
| ext_pricing_date | fin_date | datetime(8) | Yes | ext_pricing_date | No |
| ext_llp | fin_designparamcode | varchar(5) | Yes | ext_llp | No |
| ext_Repl_type | fin_designparamcode | varchar(5) | Yes | ext_Repl_type | No |
| ext_part_type | fin_designparamcode | varchar(5) | Yes | ext_part_type | No |
| ext_part_group | fin_desc40 | varchar(40) | Yes | ext_part_group | No |
| ext_part_class | fin_designparamcode | varchar(5) | Yes | ext_part_class | No |
| ext_factored_on | fin_designparamcode | varchar(5) | Yes | ext_factored_on | No |
| ext_ref_catalogue_id | fin_designparamcode | varchar(5) | Yes | ext_ref_catalogue_id | No |
| ext_ref_ppl_no | fin_documentno | varchar(40) | Yes | ext_ref_ppl_no | No |
| ext_ref_ppl_revision | fin_int | int(4) | Yes | ext_ref_ppl_revision | No |
| ext_ref_ppl_curr | fin_currencycode | varchar(5) | Yes | ext_ref_ppl_curr | No |
| ext_base_adj_fact | fin_amount | numeric(13) | Yes | ext_base_adj_fact | No |
| ext_price_fact | fin_amount | numeric(13) | Yes | ext_price_fact | No |
| ext_price_facton | fin_designparamcode | varchar(5) | Yes | ext_price_facton | No |
| ext_process_seq | fin_int | int(4) | Yes | ext_process_seq | No |
| ext_dir_ppl_curr | fin_currencycode | varchar(5) | Yes | ext_dir_ppl_curr | No |
| ext_std_cost | fin_amount | numeric(13) | Yes | ext_std_cost | No |
| ext_price | fin_amount | numeric(13) | Yes | ext_price | No |
| ext_baseunit_rate | fin_amount | numeric(13) | Yes | ext_baseunit_rate | No |
| ext_adjunit_rate | fin_amount | numeric(13) | Yes | ext_adjunit_rate | No |
| ext_ext_amt_baseval | fin_amount | numeric(13) | Yes | ext_ext_amt_baseval | No |
| ext_markup | fin_amount | numeric(13) | Yes | ext_markup | No |
| ext_markup_val | fin_amount | numeric(13) | Yes | ext_markup_val | No |
| ext_total_price | fin_amount | numeric(13) | Yes | ext_total_price | No |
| ext_erate_co_curr | fin_exchangerate | numeric(9) | Yes | ext_erate_co_curr | No |
| ext_adjunit_rate_cocurr | fin_amount | numeric(13) | Yes | ext_adjunit_rate_cocurr | No |
| ext_ext_amt_coval | fin_amount | numeric(13) | Yes | ext_ext_amt_coval | No |
| ext_markup_cocurr | fin_amount | numeric(13) | Yes | ext_markup_cocurr | No |
| ext_markup_val_cocurr | fin_amount | numeric(13) | Yes | ext_markup_val_cocurr | No |
| ext_total_price_cocurr | fin_amount | numeric(13) | Yes | ext_total_price_cocurr | No |
| ext_final_value | fin_amount | numeric(13) | Yes | ext_final_value | No |
| ext_price_criteria | fin_flag | varchar(25) | Yes | ext_price_criteria | No |
| ext_mult_criteria_match | fin_flag | varchar(25) | Yes | ext_mult_criteria_match | No |
| ext_matcount | fin_int | int(4) | Yes | ext_matcount | No |
| ext_Price_desc | fin_notes | varchar(2000) | Yes | ext_Price_desc | No |
| ext_price_notes | fin_notes | varchar(2000) | Yes | ext_price_notes | No |
| ext_sourceflag | fin_flag | varchar(25) | Yes | ext_sourceflag | No |
| ext_pricing_disposition | fin_notes | varchar(2000) | Yes | ext_pricing_disposition | No |
| ext_cap_flag | fin_designparamcode | varchar(5) | Yes | ext_cap_flag | No |
| ext_cap_max_limit | fin_designparamcode | varchar(5) | Yes | ext_cap_max_limit | No |
| ext_cap_max_limitcapcode | fin_enum | varchar(40) | Yes | ext_cap_max_limitcapcode | No |
| ext_cap_cov_limit | fin_designparamcode | varchar(5) | Yes | ext_cap_cov_limit | No |
| ext_cap_cov_limitcapcode | fin_enum | varchar(40) | Yes | ext_cap_cov_limitcapcode | No |
| ext_cap_ext_limit | fin_designparamcode | varchar(5) | Yes | ext_cap_ext_limit | No |
| ext_cap_ext_limitcapcode | fin_enum | varchar(40) | Yes | ext_cap_ext_limitcapcode | No |
| ext_capped_mark_up | fin_amount | numeric(13) | Yes | ext_capped_mark_up | No |
| ext_capped_ext_price | fin_amount | numeric(13) | Yes | ext_capped_ext_price | No |
| ext_cap_notes | fin_notes | varchar(2000) | Yes | ext_cap_notes | No |
| ext_excl_ref_cod | fin_effectivitycode | varchar(40) | Yes | ext_excl_ref_cod | No |
| ext_warranty_reco | fin_flag | varchar(25) | Yes | ext_warranty_reco | No |
| ext_doc_type | fin_type | varchar(25) | Yes | ext_doc_type | No |
| ext_proc_lineno | bigint | Bigint(8) | Yes | ext_proc_lineno | No |
| ext_spl_no | fin_documentno | varchar(40) | Yes | ext_spl_no | No |
| ext_spl_ou | fin_ctxt_ouinstance | int(4) | Yes | ext_spl_ou | No |
| ext_spl_revision | fin_int | int(4) | Yes | ext_spl_revision | No |
| ext_spl_curr | fin_currencycode | varchar(5) | Yes | ext_spl_curr | No |
| ext_final_markup | fin_amount | numeric(13) | Yes | ext_final_markup | No |
| ext_unitprice | fin_amount | numeric(13) | Yes | ext_unitprice | No |
| ext_cov_unitprice | fin_amount | numeric(13) | Yes | ext_cov_unitprice | No |
| ext_capped_unitprice | fin_amount | numeric(13) | Yes | ext_capped_unitprice | No |
| ext_final_unitprice | fin_amount | numeric(13) | Yes | ext_final_unitprice | No |
| ext_basicprice | fin_amount | numeric(13) | Yes | ext_basicprice | No |
| ext_ext_markup | fin_amount | numeric(13) | Yes | ext_ext_markup | No |
| ext_capped_ext_markup | fin_amount | numeric(13) | Yes | ext_capped_ext_markup | No |
| ext_final_ext_markup | fin_amount | numeric(13) | Yes | ext_final_ext_markup | No |
| ext_tcd_amt | fin_amount | numeric(13) | Yes | ext_tcd_amt | No |
| ext_ext_price | fin_amount | numeric(13) | Yes | ext_ext_price | No |
| ext_cov_price | fin_amount | numeric(13) | Yes | ext_cov_price | No |
| ext_capped_cov_price | fin_amount | numeric(13) | Yes | ext_capped_cov_price | No |
| ext_final_price | fin_amount | numeric(13) | Yes | ext_final_price | No |
| ext_net_unitrate_cur | fin_amount | numeric(13) | Yes | ext_net_unitrate_cur | No |
| ext_fin_unit_mark_up | fin_amount | numeric(13) | Yes | ext_fin_unit_mark_up | No |
| ext_basic_rate_cur | fin_amount | numeric(13) | Yes | ext_basic_rate_cur | No |
| ext_unit_markup | fin_amount | numeric(13) | Yes | ext_unit_markup | No |
| ext_warranty_res | fin_enum_cd | varchar(5) | Yes | ext_warranty_res | No |
| ext_sys_billable | fin_enum_cd | varchar(5) | Yes | ext_sys_billable | No |
| ext_org_coa | fin_enum_cd | varchar(5) | Yes | ext_org_coa | No |
| ext_pricing_source | fin_ctxt_user | varchar(30) | Yes | ext_pricing_source | No |
| ext_inv_remarks | fin_remarks | varchar(100) | Yes | ext_inv_remarks | No |
| ext_int_notes | fin_notes | varchar(2000) | Yes | ext_int_notes | No |
| ext_mod_notes | fin_notes | varchar(2000) | Yes | ext_mod_notes | No |
| ext_ws_code | fin_documentno | varchar(40) | Yes | ext_ws_code | No |
| ext_ws_notes | fin_notes | varchar(2000) | Yes | ext_ws_notes | No |
| ext_processed | fin_enum_cd | varchar(5) | Yes | ext_processed | No |
| ext_coa | fin_enum_cd | varchar(5) | Yes | ext_coa | No |
| ext_unit_tcd_mark_up | fin_amount | numeric(13) | Yes | ext_unit_tcd_mark_up | No |
| ext_repair_qty | fin_amount | numeric(13) | Yes | ext_repair_qty | No |
| ext_modified_by | fin_ctxt_user | varchar(30) | Yes | ext_modified_by | No |
| ext_modified_date | fin_date | datetime(8) | Yes | ext_modified_date | No |
| ext_price_narration | fin_notes | varchar(2000) | Yes | ext_price_narration | No |
| ext_ref_doc_erate | fin_exchangerate | numeric(9) | Yes | ext_ref_doc_erate | No |
| ext_doc_erate | fin_exchangerate | numeric(9) | Yes | ext_doc_erate | No |
| ext_doc_amt_basecurr | fin_amount | numeric(13) | Yes | ext_doc_amt_basecurr | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ext_cso_no | fin_documentno | varchar(40) | Yes | ext_cso_no | No |
| ext_inv_rel_no | fin_rev_no | int(4) | Yes | ext_inv_rel_no | No |
| ext_ou | fin_ctxt_ouinstance | int(4) | Yes | ext_ou | No |
| ext_lineno | fin_lineno | int(4) | Yes | ext_lineno | No |
| ext_pricing_disposition | fin_Disposition | varchar(40) | Yes | ext_pricing_disposition | No |
| ext_exec_doc_type | fin_type | varchar(25) | Yes | ext_exec_doc_type | No |
| ext_exec_doc_no | fin_documentno | varchar(40) | Yes | ext_exec_doc_no | No |
| ext_parent_wo_no | fin_documentno | varchar(40) | Yes | ext_parent_wo_no | No |
| ext_doc_type | fin_type | varchar(25) | Yes | ext_doc_type | No |
| ext_doc_no | fin_documentno | varchar(40) | Yes | ext_doc_no | No |
| ext_doc_line_no | fin_lineno | int(4) | Yes | ext_doc_line_no | No |
| ext_doc_status | fin_status | varchar(25) | Yes | ext_doc_status | No |
| ext_supplier_no | fin_suppliercode | varchar(16) | Yes | ext_supplier_no | No |
| ext_Doc_pric_basis | fin_basis | varchar(8) | Yes | ext_Doc_pric_basis | No |
| ext_ref_doc_no | fin_documentno | varchar(40) | Yes | ext_ref_doc_no | No |
| ext_ref_doc_lineno | fin_lineno | int(4) | Yes | ext_ref_doc_lineno | No |
| ext_ext_element | fin_element | varchar(80) | Yes | ext_ext_element | No |
| ext_Quantity | fin_quantity | numeric(17) | Yes | ext_Quantity | No |
| ext_uom | fin_uom | varchar(15) | Yes | ext_uom | No |
| ext_rate | fin_rate | numeric(13) | Yes | ext_rate | No |
| ext_doc_curr | fin_currency | varchar(5) | Yes | ext_doc_curr | No |
| ext_exch_rate | fin_rate | numeric(13) | Yes | ext_exch_rate | No |
| ext_doc_amount | fin_price | numeric(13) | Yes | ext_doc_amount | No |
| ext_price_fact | fin_factor | numeric(13) | Yes | ext_price_fact | No |
| ext_factored_on | fin_flag | varchar(25) | Yes | ext_factored_on | No |
| ext_markup | fin_markup | numeric(9) | Yes | ext_markup | No |
| ext_capped_mark_up | fin_markup | numeric(9) | Yes | ext_capped_mark_up | No |
| ext_final_markup | fin_markup | numeric(9) | Yes | ext_final_markup | No |
| ext_unitprice | fin_price | numeric(13) | Yes | ext_unitprice | No |
| ext_cov_unitprice | fin_price | numeric(13) | Yes | ext_cov_unitprice | No |
| ext_capped_unitprice | fin_price | numeric(13) | Yes | ext_capped_unitprice | No |
| ext_final_unitprice | fin_price | numeric(13) | Yes | ext_final_unitprice | No |
| ext_basicprice | fin_price | numeric(13) | Yes | ext_basicprice | No |
| ext_extnal_markup | fin_markup | numeric(9) | Yes | ext_extnal_markup | No |
| ext_capped_ext_markup | fin_markup | numeric(9) | Yes | ext_capped_ext_markup | No |
| ext_final_ext_markup | fin_markup | numeric(9) | Yes | ext_final_ext_markup | No |
| ext_tcd_amt | fin_price | numeric(13) | Yes | ext_tcd_amt | No |
| ext_price | fin_price | numeric(13) | Yes | ext_price | No |
| ext_cov_price | fin_price | numeric(13) | Yes | ext_cov_price | No |
| ext_capped_cov_price | fin_price | numeric(13) | Yes | ext_capped_cov_price | No |
| ext_capped_ext_price | fin_price | numeric(13) | Yes | ext_capped_ext_price | No |
| ext_final_price | fin_price | numeric(13) | Yes | ext_final_price | No |
| ext_ref_catalogue_id | fin_documentno | varchar(40) | Yes | ext_ref_catalogue_id | No |
| ext_Price_desc | fin_description | varchar(100) | Yes | ext_Price_desc | No |
| ext_price_notes | fin_notes | varchar(2000) | Yes | ext_price_notes | No |
| ext_cap_notes | fin_notes | varchar(2000) | Yes | ext_cap_notes | No |
| ext_workcenter | fin_workcenter | varchar(80) | Yes | ext_workcenter | No |
| ext_task_status | fin_status | varchar(25) | Yes | ext_task_status | No |
| ext_quoted_flag | fin_flag | varchar(25) | Yes | ext_quoted_flag | No |
| ext_Quote_appr_flag | fin_flag | varchar(25) | Yes | ext_Quote_appr_flag | No |
| ext_Invoiced_flag | fin_flag | varchar(25) | Yes | ext_Invoiced_flag | No |
| ext_billable | fin_enum_cd | varchar(5) | Yes | ext_billable | No |
| ext_coa | fin_enum_cd | varchar(5) | Yes | ext_coa | No |
| ext_warranty_reco | fin_enum_cd | varchar(5) | Yes | ext_warranty_reco | No |
| ext_warranty_res | fin_enum_cd | varchar(5) | Yes | ext_warranty_res | No |
| ext_price_narration | fin_Narration | varchar(500) | Yes | ext_price_narration | No |
| ext_task_type | fin_type | varchar(25) | Yes | ext_task_type | No |
| ext_repair_class | fin_repairclassification | varchar(25) | Yes | ext_repair_class | No |
| ext_repair_processcode | fin_repairprocesscode | varchar(25) | Yes | ext_repair_processcode | No |
| ext_pricing_task | fin_taskno | varchar(40) | Yes | ext_pricing_task | No |
| ext_parent_task | fin_taskno | varchar(40) | Yes | ext_parent_task | No |
| ext_ws_code | fin_workcenter | varchar(80) | Yes | ext_ws_code | No |
| ext_ws_notes | fin_notes | varchar(2000) | Yes | ext_ws_notes | No |
| ext_incl_excl_code | fin_documentno | varchar(40) | Yes | ext_incl_excl_code | No |
| ext_incl_excl_notes | fin_notes | varchar(2000) | Yes | ext_incl_excl_notes | No |
| ext_part_no | fin_partno | varchar(40) | Yes | ext_part_no | No |
| ext_mfr_part_no | fin_partno | varchar(40) | Yes | ext_mfr_part_no | No |
| ext_mfr_no | fin_partno | varchar(40) | Yes | ext_mfr_no | No |
| ext_part_srl_lot | fin_lotno | varchar(18) | Yes | ext_part_srl_lot | No |
| ext_ata_no | fin_documentno | varchar(40) | Yes | ext_ata_no | No |
| ext_acreg_no | fin_aircraftregno | varchar(30) | Yes | ext_acreg_no | No |
| ext_pricing_source | fin_itemsource | varchar(15) | Yes | ext_pricing_source | No |
| ext_unit_tcd_mark_up | fin_markup | numeric(9) | Yes | ext_unit_tcd_mark_up | No |
| ext_fin_unit_mark_up | fin_markup | numeric(9) | Yes | ext_fin_unit_mark_up | No |
| ext_last_modifiedby | fin_ctxt_user | varchar(30) | Yes | ext_last_modifiedby | No |
| ext_last_modified_dt | fin_date | datetime(8) | Yes | ext_last_modified_dt | No |
| ext_sys_billable | fin_enum_cd | varchar(5) | Yes | ext_sys_billable | No |
| ext_internal_notes | fin_notes | varchar(2000) | Yes | ext_internal_notes | No |
| ext_modify_notes | fin_notes | varchar(2000) | Yes | ext_modify_notes | No |
| ext_unit_tcd | fin_flag | varchar(25) | Yes | ext_unit_tcd | No |
| ext_unit_chrg | fin_price | numeric(13) | Yes | ext_unit_chrg | No |
| ext_unit_task | fin_taskno | varchar(40) | Yes | ext_unit_task | No |
| ext_unit_tcd_cur | fin_currency | varchar(5) | Yes | ext_unit_tcd_cur | No |
| ext_basic_rate_cur | fin_currency | varchar(5) | Yes | ext_basic_rate_cur | No |
| ext_cap_indicator | fin_indicator | Char(25) | Yes | ext_cap_indicator | No |
| ext_last_update_log | fin_flag | varchar(25) | Yes | ext_last_update_log | No |
| ext_rev_ind | fin_indicator | Char(25) | Yes | ext_rev_ind | No |
| ext_inv_remarks | fin_notes | varchar(2000) | Yes | ext_inv_remarks | No |
| ext_indicator | fin_indicator | Char(25) | Yes | ext_indicator | No |
| ext_unit_discount | fin_discount | varchar(16) | Yes | ext_unit_discount | No |
| ext_process_flag | fin_flag | varchar(25) | Yes | ext_process_flag | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION_KEY | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ext_cso_no | fin_documentno | varchar(40) | No | ext_cso_no | Yes |
| ext_inv_rel_no | fin_releaseno | int(4) | No | ext_inv_rel_no | Yes |
| ext_ouinst_id | fin_ctxt_ouinstance | int(4) | No | ext_ouinst_id | Yes |
| ext_lineno | fin_lineno | int(4) | No | ext_lineno | Yes |
| ext_indicator | fin_flag | varchar(25) | Yes | ext_indicator | No |
| ext_caps | fin_flag | varchar(25) | Yes | ext_caps | No |
| ext_process_id | fin_seqno | int(4) | Yes | ext_process_id | No |
| ext_sub_process_id | fin_seqno | int(4) | Yes | ext_sub_process_id | No |
| ext_est_release_id | fin_seqno | int(4) | Yes | ext_est_release_id | No |
| ext_est_inst_id | fin_seqno | int(4) | Yes | ext_est_inst_id | No |
| ext_exec_comm_id | fin_seqno | int(4) | Yes | ext_exec_comm_id | No |
| ext_exec_doc_type | fin_type | varchar(25) | Yes | ext_exec_doc_type | No |
| ext_exec_doc_no | fin_documentno | varchar(40) | Yes | ext_exec_doc_no | No |
| ext_exec_doc_line_no | fin_lineno | int(4) | Yes | ext_exec_doc_line_no | No |
| ext_exec_doc_status | fin_status | varchar(25) | Yes | ext_exec_doc_status | No |
| ext_parent_wo_no | fin_documentno | varchar(40) | Yes | ext_parent_wo_no | No |
| ext_ou_id | fin_ctxt_ouinstance | int(4) | Yes | ext_ou_id | No |
| ext_est_remarks | fin_notes | varchar(2000) | Yes | ext_est_remarks | No |
| ext_aircraft_reg_no | fin_acregno | varchar(30) | Yes | ext_aircraft_reg_no | No |
| ext_release_event | fin_event | varchar(40) | Yes | ext_release_event | No |
| ext_release_type | fin_type | varchar(25) | Yes | ext_release_type | No |
| ext_contract_no | fin_documentno | varchar(40) | Yes | ext_contract_no | No |
| ext_contract_rev_no | fin_seqno | int(4) | Yes | ext_contract_rev_no | No |
| ext_custorder_no | fin_documentno | varchar(40) | Yes | ext_custorder_no | No |
| ext_custorder_rev_no | fin_seqno | int(4) | Yes | ext_custorder_rev_no | No |
| ext_custorder_curr | fin_currencycode | varchar(5) | Yes | ext_custorder_curr | No |
| ext_eff_ref_cd | fin_quickcodes | varchar(25) | Yes | ext_eff_ref_cd | No |
| ext_doc_type | fin_type | varchar(25) | Yes | ext_doc_type | No |
| ext_doc_no | fin_documentno | varchar(40) | Yes | ext_doc_no | No |
| ext_doc_pric_basis | fin_enum_cd | varchar(5) | Yes | ext_doc_pric_basis | No |
| ext_doc_curr | fin_currencycode | varchar(5) | Yes | ext_doc_curr | No |
| ext_doc_amount | fin_amount | numeric(13) | Yes | ext_doc_amount | No |
| ext_doc_status | fin_status | varchar(25) | Yes | ext_doc_status | No |
| ext_doc_sub_type | fin_type | varchar(25) | Yes | ext_doc_sub_type | No |
| ext_exch_type | fin_type | varchar(25) | Yes | ext_exch_type | No |
| ext_entity | fin_enum_cd | varchar(5) | Yes | ext_entity | No |
| ext_exch_init_refdoc_type | fin_type | varchar(25) | Yes | ext_exch_init_refdoc_type | No |
| ext_exch_init_refdoc_no | fin_documentno | varchar(40) | Yes | ext_exch_init_refdoc_no | No |
| ext_exch_init_as | fin_enum_cd | varchar(5) | Yes | ext_exch_init_as | No |
| ext_reason_exch | fin_quickcodes | varchar(25) | Yes | ext_reason_exch | No |
| ext_exch_mr_no | fin_documentno | varchar(40) | Yes | ext_exch_mr_no | No |
| ext_remarks | fin_notes | varchar(2000) | Yes | ext_remarks | No |
| ext_supplier_no | fin_vendorcode | varchar(45) | Yes | ext_supplier_no | No |
| ext_supplier_name | fin_txt150 | varchar(150) | Yes | ext_supplier_name | No |
| ext_billable | fin_enum_cd | varchar(5) | Yes | ext_billable | No |
| ext_coa | fin_enum_cd | varchar(5) | Yes | ext_coa | No |
| ext_exch_source_inv_qty | fin_quantity | numeric(17) | Yes | ext_exch_source_inv_qty | No |
| ext_exch_source_rep_qty | fin_quantity | numeric(17) | Yes | ext_exch_source_rep_qty | No |
| ext_exch_source_pur_qty | fin_quantity | numeric(17) | Yes | ext_exch_source_pur_qty | No |
| ext_rep_quote_no | fin_documentno | varchar(40) | Yes | ext_rep_quote_no | No |
| ext_rep_quote_date | fin_date | datetime(8) | Yes | ext_rep_quote_date | No |
| ext_refdoc_amend_no | fin_seqno | int(4) | Yes | ext_refdoc_amend_no | No |
| ext_workcenter | fin_workcenter | varchar(80) | Yes | ext_workcenter | No |
| ext_quote_status | fin_status | varchar(25) | Yes | ext_quote_status | No |
| ext_warranty_reco | fin_checkflag | int(4) | Yes | ext_warranty_reco | No |
| ext_repair_class | fin_repairclassification | varchar(25) | Yes | ext_repair_class | No |
| ext_repair_process_code | fin_repairprocesscode | varchar(25) | Yes | ext_repair_process_code | No |
| ext_incl_excl_flag | fin_checkflag | int(4) | Yes | ext_incl_excl_flag | No |
| ext_incl_excl_code | fin_effectivitycode | varchar(40) | Yes | ext_incl_excl_code | No |
| ext_exclusion_line_no | fin_lineno | int(4) | Yes | ext_exclusion_line_no | No |
| ext_excl_notes | fin_notes | varchar(2000) | Yes | ext_excl_notes | No |
| ext_ata_no | fin_documentno | varchar(40) | Yes | ext_ata_no | No |
| ext_ata_desc | fin_txt150 | varchar(150) | Yes | ext_ata_desc | No |
| ext_created_by | fin_ctxt_user | varchar(30) | Yes | ext_created_by | No |
| ext_created_date | fin_date | datetime(8) | Yes | ext_created_date | No |
| ext_modified_by | fin_ctxt_user | varchar(30) | Yes | ext_modified_by | No |
| ext_modified_date | fin_date | datetime(8) | Yes | ext_modified_date | No |
| ext_quoted_flag | fin_status | varchar(25) | Yes | ext_quoted_flag | No |
| ext_quote_appr_flag | fin_enum_cd | varchar(5) | Yes | ext_quote_appr_flag | No |
| ext_quoted_status | fin_enum_cd | varchar(5) | Yes | ext_quoted_status | No |
| ext_Price_flag | fin_flag | varchar(25) | Yes | ext_Price_flag | No |
| ext_rel_status | fin_status | varchar(25) | Yes | ext_rel_status | No |
| ext_revrec_oth_cost | fin_cost | numeric(13) | Yes | ext_revrec_oth_cost | No |
| ext_revrec_tot_cost | fin_cost | numeric(13) | Yes | ext_revrec_tot_cost | No |
| ext_revrec_oth_amt | fin_amount | numeric(13) | Yes | ext_revrec_oth_amt | No |
| ext_revrec_tot_amt | fin_amount | numeric(13) | Yes | ext_revrec_tot_amt | No |
| ext_marginpercent | fin_percent | Numeric(17) | Yes | ext_marginpercent | No |
| ext_final_price | fin_price | numeric(13) | Yes | ext_final_price | No |
| ext_warranty_res | fin_enum_cd | varchar(5) | Yes | ext_warranty_res | No |
| ext_sys_billable | fin_enum_cd | varchar(5) | Yes | ext_sys_billable | No |
| ext_org_coa | fin_enum_cd | varchar(5) | Yes | ext_org_coa | No |
| ext_coa_exists | fin_flag | varchar(25) | Yes | ext_coa_exists | No |
| ext_int_notes | fin_notes | varchar(2000) | Yes | ext_int_notes | No |
| ext_tsk_ref_date | fin_date | datetime(8) | Yes | ext_tsk_ref_date | No |
| ext_tsk_src_doc_no | fin_documentno | varchar(40) | Yes | ext_tsk_src_doc_no | No |
| ext_fp_ref | fin_revisionno | varchar(40) | Yes | ext_fp_ref | No |
| ext_price_narration | fin_notes | varchar(2000) | Yes | ext_price_narration | No |
| ext_othdoc_exchrate | fin_exchangerate | numeric(9) | Yes | ext_othdoc_exchrate | No |
| ext_othdoccur_amt | fin_amount | numeric(13) | Yes | ext_othdoccur_amt | No |
| ext_doc_amt_basecurr | fin_amount | numeric(13) | Yes | ext_doc_amt_basecurr | No |
| ext_ref_doc_type | fin_documenttype | varchar(40) | Yes | ext_ref_doc_type | No |
| ext_ref_doc_no | fin_documentno | varchar(40) | Yes | ext_ref_doc_no | No |
| ext_ref_doc_curr | fin_currencycode | varchar(5) | Yes | ext_ref_doc_curr | No |
| ext_quot_type | fin_designparamcode | varchar(5) | Yes | ext_quot_type | No |
| ext_ref_doc_erate | fin_exchangerate | numeric(9) | Yes | ext_ref_doc_erate | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ext_ouinst_id | fin_ctxt_ouinstance | int(4) | No | ext_ouinst_id | Yes |
| ext_cso_no | fin_documentno | varchar(40) | No | ext_cso_no | Yes |
| ext_inv_rel_no | fin_releaseno | int(4) | No | ext_inv_rel_no | Yes |
| ext_lineno | fin_lineno | int(4) | No | ext_lineno | Yes |
| ext_srl_lineno | fin_lineno | int(4) | No | ext_srl_lineno | No |
| ext_process_id | fin_documentno | varchar(40) | Yes | ext_process_id | No |
| ext_sub_process_id | fin_seqno | int(4) | Yes | ext_sub_process_id | No |
| ext_est_release_id | fin_documentno | varchar(40) | Yes | ext_est_release_id | No |
| ext_exec_comm_id | fin_documentno | varchar(40) | Yes | ext_exec_comm_id | No |
| ext_task_track_id | fin_tasktrackid | bigint(8) | Yes | ext_task_track_id | No |
| ext_exec_doc_no | fin_documentno | varchar(40) | Yes | ext_exec_doc_no | No |
| ext_exec_doc_line_no | fin_lineno | int(4) | Yes | ext_exec_doc_line_no | No |
| ext_exec_doc_type | fin_type | varchar(25) | Yes | ext_exec_doc_type | No |
| ext_typeofsale | fin_quickcodes | varchar(25) | Yes | ext_typeofsale | No |
| ext_part_no | fin_partno | varchar(40) | Yes | ext_part_no | No |
| ext_part_serial_no | fin_partno | varchar(40) | Yes | ext_part_serial_no | No |
| ext_quantity | fin_quantity | numeric(17) | Yes | ext_quantity | No |
| ext_part_condn | fin_quickcodes | varchar(25) | Yes | ext_part_condn | No |
| ext_part_status | fin_status | varchar(25) | Yes | ext_part_status | No |
| ext_cost | fin_amount | numeric(13) | Yes | ext_cost | No |
| ext_custorder_curr | fin_currencycode | varchar(5) | Yes | ext_custorder_curr | No |
| ext_llp | fin_designparamcode | varchar(5) | Yes | ext_llp | No |
| ext_Repl_type | fin_designparamcode | varchar(5) | Yes | ext_Repl_type | No |
| ext_part_type | fin_designparamcode | varchar(5) | Yes | ext_part_type | No |
| ext_part_group | fin_desc40 | varchar(40) | Yes | ext_part_group | No |
| ext_part_class | fin_designparamcode | varchar(5) | Yes | ext_part_class | No |
| ext_mfg_no | fin_vendorcode | varchar(45) | Yes | ext_mfg_no | No |
| ext_mfg_partno | fin_partno | varchar(40) | Yes | ext_mfg_partno | No |
| ext_part_uom | fin_uom | varchar(15) | Yes | ext_part_uom | No |
| ext_factored_on | fin_designparamcode | varchar(5) | Yes | ext_factored_on | No |
| ext_Ref_catalog_id | fin_designparamcode | varchar(5) | Yes | ext_Ref_catalog_id | No |
| ext_ref_ppl_no | fin_documentno | varchar(40) | Yes | ext_ref_ppl_no | No |
| ext_ref_ppl_revision | fin_int | int(4) | Yes | ext_ref_ppl_revision | No |
| ext_ref_ppl_curr | fin_currencycode | varchar(5) | Yes | ext_ref_ppl_curr | No |
| ext_base_adj_fact | fin_amount | numeric(13) | Yes | ext_base_adj_fact | No |
| ext_price_fact | fin_amount | numeric(13) | Yes | ext_price_fact | No |
| ext_price_facton | fin_designparamcode | varchar(5) | Yes | ext_price_facton | No |
| ext_process_seq | fin_int | int(4) | Yes | ext_process_seq | No |
| ext_dir_ppl_curr | fin_currencycode | varchar(5) | Yes | ext_dir_ppl_curr | No |
| ext_pric_basis | fin_basis | varchar(8) | Yes | ext_pric_basis | No |
| ext_std_cost | fin_amount | numeric(13) | Yes | ext_std_cost | No |
| ext_billable_flag | fin_designparamcode | varchar(5) | Yes | ext_billable_flag | No |
| ext_price | fin_amount | numeric(13) | Yes | ext_price | No |
| ext_baseunit_rate | fin_amount | numeric(13) | Yes | ext_baseunit_rate | No |
| ext_adjunit_rate | fin_amount | numeric(13) | Yes | ext_adjunit_rate | No |
| ext_ext_amt_baseval | fin_amount | numeric(13) | Yes | ext_ext_amt_baseval | No |
| ext_markup | fin_amount | numeric(13) | Yes | ext_markup | No |
| ext_markup_val | fin_amount | numeric(13) | Yes | ext_markup_val | No |
| ext_total_price | fin_amount | numeric(13) | Yes | ext_total_price | No |
| ext_erate_co_curr | fin_exchangerate | numeric(9) | Yes | ext_erate_co_curr | No |
| ext_adjunit_rate_cocurr | fin_amount | numeric(13) | Yes | ext_adjunit_rate_cocurr | No |
| ext_ext_amt_coval | fin_amount | numeric(13) | Yes | ext_ext_amt_coval | No |
| ext_markup_cocurr | fin_amount | numeric(13) | Yes | ext_markup_cocurr | No |
| ext_markup_val_cocurr | fin_amount | numeric(13) | Yes | ext_markup_val_cocurr | No |
| ext_total_price_cocurr | fin_amount | numeric(13) | Yes | ext_total_price_cocurr | No |
| ext_final_value | fin_amount | numeric(13) | Yes | ext_final_value | No |
| ext_price_criteria | fin_flag | varchar(25) | Yes | ext_price_criteria | No |
| ext_mult_criteria_match | fin_flag | varchar(25) | Yes | ext_mult_criteria_match | No |
| ext_matcount | fin_int | int(4) | Yes | ext_matcount | No |
| ext_Price_desc | fin_notes | varchar(2000) | Yes | ext_Price_desc | No |
| ext_price_notes | fin_notes | varchar(2000) | Yes | ext_price_notes | No |
| ext_sourceflag | fin_flag | varchar(25) | Yes | ext_sourceflag | No |
| ext_pricing_disposition | fin_notes | varchar(2000) | Yes | ext_pricing_disposition | No |
| ext_prorated | fin_quickcodes | varchar(25) | Yes | ext_prorated | No |
| ext_serial_no | fin_partserialnumber | varchar(40) | Yes | ext_serial_no | No |
| ext_remaining_life | fin_conlimit | numeric(13) | Yes | ext_remaining_life | No |
| ext_ultimate_life | fin_conlimit | numeric(13) | Yes | ext_ultimate_life | No |
| ext_exch_date | fin_date | datetime(8) | Yes | ext_exch_date | No |
| ext_component_id | fin_quickcodes | varchar(25) | Yes | ext_component_id | No |
| ext_fact_price_notes | fin_notes | varchar(2000) | Yes | ext_fact_price_notes | No |
| ext_ppl_dir_curr | fin_currencycode | varchar(5) | Yes | ext_ppl_dir_curr | No |
| ext_updated_by | fin_ctxt_user | varchar(30) | Yes | ext_updated_by | No |
| ext_updated_date | fin_date | datetime(8) | Yes | ext_updated_date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ext_ou | fin_ctxt_ouinstance | int(4) | No | ext_ou | No |
| ext_cso_no | fin_documentno | varchar(40) | No | ext_cso_no | No |
| ext_inv_rel_no | fin_rev_no | int(4) | No | ext_inv_rel_no | No |
| ext_lineno | fin_lineno | int(4) | No | ext_lineno | No |
| ext_indicator | fin_lineno | int(4) | Yes | ext_indicator | No |
| ext_caps | fin_enum_cd | varchar(5) | Yes | ext_caps | No |
| ext_doc_no | fin_documentno | varchar(40) | Yes | ext_doc_no | No |
| ext_doc_no_status | fin_status | varchar(25) | Yes | ext_doc_no_status | No |
| ext_doc_line_no | fin_lineno | int(4) | Yes | ext_doc_line_no | No |
| ext_doc_type | fin_types | varchar(30) | Yes | ext_doc_type | No |
| ext_supplier_id | fin_vendorcode | varchar(45) | Yes | ext_supplier_id | No |
| ext_part_no | fin_partno | varchar(40) | Yes | ext_part_no | No |
| ext_mfr_part_no | fin_partno | varchar(40) | Yes | ext_mfr_part_no | No |
| ext_mfr_no | fin_partno | varchar(40) | Yes | ext_mfr_no | No |
| ext_part_serial_lot_no | fin_partserialnumber | varchar(40) | Yes | ext_part_serial_lot_no | No |
| ext_repair_qty | fin_quantity | numeric(17) | Yes | ext_repair_qty | No |
| ext_ber_qty | fin_quantity | numeric(17) | Yes | ext_ber_qty | No |
| ext_quot_type | fin_type | varchar(25) | Yes | ext_quot_type | No |
| ext_quot_price | fin_price | numeric(13) | Yes | ext_quot_price | No |
| ext_ber_cost | fin_cost | numeric(13) | Yes | ext_ber_cost | No |
| ext_inv_no | fin_documentno | varchar(40) | Yes | ext_inv_no | No |
| ext_inv_price | fin_price | numeric(13) | Yes | ext_inv_price | No |
| ext_inv_ber_cost | fin_cost | numeric(13) | Yes | ext_inv_ber_cost | No |
| ext_price_basis | fin_enum_cd | varchar(5) | Yes | ext_price_basis | No |
| ext_appl_on | fin_enum_cd | varchar(5) | Yes | ext_appl_on | No |
| ext_price_factor | fin_factor | numeric(13) | Yes | ext_price_factor | No |
| ext_markup | fin_markup | numeric(9) | Yes | ext_markup | No |
| ext_cap_markup | fin_markup | numeric(9) | Yes | ext_cap_markup | No |
| ext_ext_price | fin_price | numeric(13) | Yes | ext_ext_price | No |
| ext_cap_ext_price | fin_price | numeric(13) | Yes | ext_cap_ext_price | No |
| ext_final_price | fin_price | numeric(13) | Yes | ext_final_price | No |
| ext_price_disposition | fin_Disposition | varchar(40) | Yes | ext_price_disposition | No |
| ext_quot_rem | fin_remarks | varchar(100) | Yes | ext_quot_rem | No |
| ext_inv_rem | fin_remarks | varchar(100) | Yes | ext_inv_rem | No |
| ext_procesed | fin_enum_cd | varchar(5) | Yes | ext_procesed | No |
| ext_sys_billable | fin_enum_cd | varchar(5) | Yes | ext_sys_billable | No |
| ext_billable | fin_enum_cd | varchar(5) | Yes | ext_billable | No |
| ext_coa | fin_enum_cd | varchar(5) | Yes | ext_coa | No |
| ext_pricenarrarion | fin_Narration | varchar(500) | Yes | ext_pricenarrarion | No |
| ext_internalnotes | fin_notes | varchar(2000) | Yes | ext_internalnotes | No |
| ext_exch_rate | fin_rate | numeric(13) | Yes | ext_exch_rate | No |
| ext_lst_upd_log | fin_Log | varchar(1000) | Yes | ext_lst_upd_log | No |
| ext_spl | fin_documentno | varchar(40) | Yes | ext_spl | No |
| ext_spl_revno | fin_rev_no | int(4) | Yes | ext_spl_revno | No |
| ext_ref_currency | fin_currency | varchar(5) | Yes | ext_ref_currency | No |
| ext_process_id | fin_documentno | varchar(40) | Yes | ext_process_id | No |
| ext_sub_process_id | fin_seqno | int(4) | Yes | ext_sub_process_id | No |
| ext_created_by | fin_ctxt_user | varchar(30) | Yes | ext_created_by | No |
| ext_created_date | fin_date | datetime(8) | Yes | ext_created_date | No |
| ext_modified_by | fin_ctxt_user | varchar(30) | Yes | ext_modified_by | No |
| ext_modified_date | fin_date | datetime(8) | Yes | ext_modified_date | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION_KEY | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| res_ou | fin_ctxt_ouinstance | int(4) | No | OU instance | Yes |
| res_cso_no | fin_documentno | varchar(40) | No | Customer order no | Yes |
| res_inv_rel_no | fin_rev_no | int(4) | No | Invoice release no | Yes |
| res_tsk_lineno | fin_lineno | int(4) | No | Task line no | Yes |
| res_lineno | fin_lineno | int(4) | No | Line no | Yes |
| res_tsk_seqno | fin_seqno | int(4) | Yes | task sequence no | No |
| res_indicator | fin_enum_cd | varchar(5) | Yes | Indicator | No |
| res_caps | fin_enum_cd | varchar(5) | Yes | Caps | No |
| res_typ | fin_types | varchar(30) | Yes | Resource type | No |
| res_res_no | fin_resourcecode | varchar(40) | Yes | Reource no | No |
| res_wc | fin_wccode | varchar(30) | Yes | Workcenter | No |
| res_aircraft_mdl | fin_aircraftmodel | varchar(20) | Yes | Aircraft model | No |
| res_act_qty | fin_quantity | numeric(17) | Yes | ACT quantity | No |
| res_rate_uom | fin_uom | varchar(15) | Yes | Rate UOM | No |
| res_unit_rate | fin_rate | numeric(13) | Yes | Unit rate | No |
| res_att_type | fin_types | varchar(30) | Yes | ATT type | No |
| res_hrs | fin_duration | numeric(17) | Yes | Hrs | No |
| res_hrs_flag | fin_flag | varchar(25) | Yes | Hrs flag | No |
| res_act_qty_capped | fin_quantity | numeric(17) | Yes | ACT quantity capped | No |
| res_external_price | fin_price | numeric(13) | Yes | External price | No |
| res_capped_ext_price | fin_price | numeric(13) | Yes | Capped ext price | No |
| res_final_price | fin_price | numeric(13) | Yes | Final price | No |
| res_price_basis | fin_enum_cd | varchar(5) | Yes | Price basis | No |
| res_price_disposition | fin_Disposition | varchar(40) | Yes | Price disposition | No |
| res_quoted | fin_enum_cd | varchar(5) | Yes | Quoted | No |
| res_processed | fin_enum_cd | varchar(5) | Yes | Processed | No |
| res_inv_remarks | fin_remarks | varchar(100) | Yes | Invoice remarks | No |
| res_sys_billable | fin_enum_cd | varchar(5) | Yes | Sys billable | No |
| res_coa | fin_enum_cd | varchar(5) | Yes | Coa | No |
| res_billable | fin_enum_cd | varchar(5) | Yes | Billable | No |
| res_warenty_reco | fin_enum_cd | varchar(5) | Yes | Warrenty reco | No |
| res_price_narration | fin_Narration | varchar(500) | Yes | Price narration | No |
| res_internal_notes | fin_notes | varchar(2000) | Yes | Internal notes | No |
| res_spl | fin_documentno | varchar(40) | Yes | Servicepricelist | No |
| res_spl_rev_no | fin_rev_no | int(4) | Yes | Servicepricelist rev no | No |
| res_price_desc | fin_notes | varchar(2000) | Yes | Price description | No |
| res_price_notes | fin_notes | varchar(2000) | Yes | Price notes | No |
| res_ref_cur | fin_currency | varchar(5) | Yes | Ref currency | No |
| res_exch_rate | fin_rate | numeric(13) | Yes | Exchange rate | No |
| res_rep_cls | fin_quickcodes | varchar(25) | Yes | Repair classification | No |
| res_inc_exc_ref_cd | fin_effectivitycode | varchar(40) | Yes | Incl Excl ref code | No |
| res_tsk_ref_date | fin_date | datetime(8) | Yes | Task ref date | No |
| res_created_by | fin_ctxt_user | varchar(30) | Yes | created by | No |
| res_created_date | fin_date | datetime(8) | Yes | Created date | No |
| res_modified_by | fin_ctxt_user | varchar(30) | Yes | Modified by | No |
| res_modified_date | fin_date | datetime(8) | Yes | Modified date | No |
| res_cso_currency | fin_currency | varchar(5) | Yes | CSO currency | No |
| res_pg_nrm_rate_perhr | fin_amount | numeric(13) | Yes | PG nrm rate | No |
| res_pg_ot_rate_perhr | fin_amount | numeric(13) | Yes | PG ot rate per hour | No |
| res_pg_splcurr | fin_currency | varchar(5) | Yes | PG spl currency | No |
| res_pg_price_splcurr | fin_amount | numeric(13) | Yes | PG price spl currency | No |
| res_pg_price_cocurr | fin_amount | numeric(13) | Yes | PG price cust order currency | No |
| res_contractno | fin_documentno | varchar(40) | Yes | Contract no | No |
| res_spl_lineno | fin_lineno | int(4) | Yes | Service pricelist line no | No |
| res_pg_cost | fin_cost | numeric(13) | Yes | PG cost | No |
| res_cov_qty | fin_quantity | numeric(17) | Yes | Covered quantity | No |
| res_unit_price_co_curr | fin_price | numeric(13) | Yes | Unit price CO currency | No |
| res_cov_price | fin_price | numeric(13) | Yes | Covered price | No |
| res_cap_cov_price | fin_price | numeric(13) | Yes | Capped covered price | No |
| res_cap_notes | fin_notes | varchar(2000) | Yes | Cap notes | No |
| res_quot_app_sts | fin_status | varchar(25) | Yes | Quote approved status | No |
| res_inc_exc_ref_notes | fin_notes | varchar(2000) | Yes | Incl Excl ref notes | No |
| res_pricing_source | fin_flag | varchar(25) | Yes | Pricing source | No |
| res_mod_notes | fin_notes | varchar(2000) | Yes | Modification notes | No |
| res_pricing_element | fin_enum_cd | varchar(5) | Yes | Pricing element | No |
| res_org_warenty_reco | fin_enum_cd | varchar(5) | Yes | Org warrenty reco | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes |
| res_final_qty | fin_quantity | numeric(17) | Yes | Final quantity | No |
| res_fin_ext_price | fin_price | numeric(13) | Yes | Final Extended Price | No |
| res_max_qty | fin_quantity | numeric(17) | Yes | Maximum Quantity | No |
| res_res_seq_no | fin_seqno | int(4) | Yes | Null | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tcd_cso_no | fin_documentno | varchar(40) | No | Customer no | Yes |
| tcd_inv_rel_no | fin_rev_no | int(4) | No | Release no | Yes |
| tcd_ou | fin_ctxt_ouinstance | int(4) | No | OU instance | Yes |
| tcd_line_no | fin_lineno | int(4) | No | Line no | Yes |
| tcd_indicator | fin_enum_cd | varchar(5) | Yes | Indicator | No |
| tcd_code | fin_tcdcodes | varchar(25) | Yes | TCD code | No |
| tcd_variance_id | fin_tcdvariant | varchar(25) | Yes | Varaince id | No |
| tcd_rate | fin_rate | numeric(13) | Yes | TCD rate | No |
| tcd_amount | fin_amount | numeric(13) | Yes | TCD amount | No |
| tcd_currency | fin_currency | varchar(5) | Yes | TCD currency | No |
| tcd_applied_on | fin_ctxt_user | varchar(30) | Yes | TCD applied on | No |
| tcd_basis | fin_tcdbasis | varchar(15) | Yes | TCD basis | No |
| tcd_cost_center | fin_costcentercode | varchar(10) | Yes | TCD cost center | No |
| tcd_station | fin_station | varchar(40) | Yes | TCD station | No |
| tcd_price_narration | fin_comments | varchar(256) | Yes | TCd price narration | No |
| tcd_internal_notes | fin_notes | varchar(2000) | Yes | TCD internal notes | No |
| tcd_pay_to_supplier | fin_suppliercode | varchar(16) | Yes | TCD pay o supplier | No |
| tcd_effective_from | fin_date | datetime(8) | Yes | TCD effective from | No |
| tcd_effective_to | fin_date | datetime(8) | Yes | TCD effective to | No |
| tcd_source | fin_designparamcode | varchar(5) | Yes | TCD source | No |
| tcd_existing_billable | fin_designparamcode | varchar(5) | Yes | TCD existing billable | No |
| tcd_billable | fin_designparamcode | varchar(5) | Yes | TCD billable | No |
| tcd_created_by | fin_ctxt_user | varchar(30) | Yes | TCD craeted by | No |
| tcd_created_date | fin_date | datetime(8) | Yes | TCD created date | No |
| tcd_modified_by | fin_ctxt_user | varchar(30) | Yes | TCD modified by | No |
| tcd_modified_date | fin_date | datetime(8) | Yes | TCD modified date | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tsk_ou | fin_ctxt_ouinstance | int(4) | No | OU instance | Yes |
| tsk_cso_no | fin_documentno | varchar(40) | No | Customer no | Yes |
| tsk_inv_rel_no | fin_rev_no | int(4) | No | Release no | Yes |
| tsk_lineno | fin_lineno | int(4) | No | Task line no | Yes |
| tsk_seqno | fin_seqno | int(4) | Yes | Task sequence no | No |
| tsk_track_id | fin_tasktrackid | bigint(8) | Yes | Task track id | No |
| tsk_tsk_no | fin_taskno | varchar(40) | Yes | Task no | No |
| tsk_wbs_code | fin_quickcodes | varchar(25) | Yes | WBS code | No |
| tsk_wbs_level | fin_int | int(4) | Yes | WBS level | No |
| tsk_tot_cost | fin_amount | numeric(13) | Yes | Total cost | No |
| tsk_price_basis | fin_enum_cd | varchar(5) | Yes | Price basis | No |
| tsk_rev_rec_amt | fin_amount | numeric(13) | Yes | Rev Rec amount | No |
| tsk_cso_currency | fin_currency | varchar(5) | Yes | CSO currency | No |
| tsk_tm_mat_price | fin_price | numeric(13) | Yes | TM material price | No |
| tsk_tm_lab_price | fin_price | numeric(13) | Yes | TM labour price | No |
| tsk_tm_othser_price | fin_price | numeric(13) | Yes | TM other service price | No |
| tsk_tm_chg_price | fin_price | numeric(13) | Yes | TM charge price | No |
| tsk_tm_tot_price | fin_price | numeric(13) | Yes | TM total price | No |
| tsk_fp_mat_price | fin_price | numeric(13) | Yes | FP material price | No |
| tsk_fp_lab_price | fin_price | numeric(13) | Yes | FP labour price | No |
| tsk_fp_othser_price | fin_price | numeric(13) | Yes | FP other service price | No |
| tsk_fp_chg_price | fin_price | numeric(13) | Yes | FP charge price | No |
| tsk_fp_tot_price | fin_price | numeric(13) | Yes | FP total price | No |
| tsk_final_price | fin_price | numeric(13) | Yes | final price | No |
| tsk_price_disposition | fin_Disposition | varchar(40) | Yes | Price disposition | No |
| tsk_prim_task | fin_taskno | varchar(40) | Yes | Parent task no | No |
| tsk_process_id | fin_documentno | varchar(40) | Yes | Process id | No |
| tsk_sub_process_id | fin_seqno | int(4) | Yes | Sub process id | No |
| tsk_quoted | fin_enum_cd | varchar(5) | Yes | Quoted | No |
| tsk_verified | fin_enum_cd | varchar(5) | Yes | Verified | No |
| tsk_sys_billable | fin_enum_cd | varchar(5) | Yes | Sys billable | No |
| tsk_coa | fin_enum_cd | varchar(5) | Yes | Coa | No |
| tsk_waranty_reco | fin_enum_cd | varchar(5) | Yes | Warenty reco | No |
| tsk_price_naration | fin_Narration | varchar(500) | Yes | Price narration | No |
| tsk_rep_cls | fin_quickcodes | varchar(25) | Yes | Repair classification | No |
| tsk_pricing_notes | fin_notes | varchar(2000) | Yes | Pricing notes | No |
| tsk_pricing_tsk_no | fin_taskcode | varchar(30) | Yes | Pricing task no | No |
| tsk_coverage | fin_enum_cd | varchar(5) | Yes | coverage | No |
| tsk_inc_exc_cd | fin_effectivitycode | varchar(40) | Yes | Incl Excl code | No |
| tsk_inc_exc_notes | fin_notes | varchar(2000) | Yes | Incl Excl notes | No |
| tsk_typ | fin_type | varchar(25) | Yes | Task type | No |
| tsk_prt_no | fin_partno | varchar(40) | Yes | Part no | No |
| tsk_mfr_prt_no | fin_partno | varchar(40) | Yes | MFR part no | No |
| tsk_mfr_no | fin_partno | varchar(40) | Yes | MFR no | No |
| tsk_srl_lot_no | fin_partserialnumber | varchar(40) | Yes | Serial lot no | No |
| tsk_ac_reg | fin_acregno | varchar(30) | Yes | Aircraft reg no | No |
| tsk_ata_no | fin_atanumber | varchar(16) | Yes | ATA no | No |
| tsk_rep_proce_cd | fin_quickcodes | varchar(25) | Yes | Rep process code | No |
| tsk_exec_doc_line_no | fin_lineno | int(4) | Yes | Execution document line no | No |
| tsk_exec_doc_no | fin_documentno | varchar(40) | Yes | Execution document no | No |
| tsk_parent_WO | fin_documentno | varchar(40) | Yes | Parent WO No | No |
| tsk_wrk_center | fin_wccode | varchar(30) | Yes | Work center | No |
| tsk_created_by | fin_ctxt_user | varchar(30) | Yes | created by | No |
| tsk_created_date | fin_date | datetime(8) | Yes | created date | No |
| tsk_modified_by | fin_ctxt_user | varchar(30) | Yes | modified by | No |
| tsk_modified_date | fin_date | datetime(8) | Yes | modified date | No |
| tsk_priced_flag | fin_flag | varchar(25) | Yes | priced falg | No |
| tsk_exec_doc_type | fin_doctype | varchar(40) | Yes | Execution document type | No |
| tsk_ws_ref_code | fin_effectivitycode | varchar(40) | Yes | Work scope ref code | No |
| tsk_tm_othres_price | fin_price | numeric(13) | Yes | TM other resource price | No |
| tsk_fp_othres_price | fin_price | numeric(13) | Yes | FP other resource price | No |
| tsk_tm_res_price | fin_price | numeric(13) | Yes | TM Resource price | No |
| tsk_ws_ref_notes | fin_notes | varchar(2000) | Yes | Work scope ref notes | No |
| tsk_inv_rem | fin_remarks | varchar(100) | Yes | Invoice remarks | No |
| exec_ws_ref_notes | fin_notes | varchar(2000) | Yes | Execution Work scope ref notes | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes |
| tsk_tsk_status | fin_status | varchar(25) | Yes | Task status | No |
| tsk_tot_cost_cocurr | fin_amount | numeric(13) | Yes | Total cost CO currency | No |
| tsk_tsk_desc | fin_item_desc | varchar(150) | Yes | Task description | No |
| tsk_prim_tsk_desc | fin_item_desc | varchar(150) | Yes | Primary task description | No |
| tsk_price_tsk_desc | fin_item_desc | varchar(150) | Yes | Price task description | No |
| tsk_status | fin_status | varchar(25) | Yes | Status | No |
| tsk_exchordeno | fin_documentno | varchar(40) | Yes | Exchange order no | No |
| tsk_exchange_type | fin_doctype | varchar(40) | Yes | Exchange type | No |
| tsk_exch_initiatedas | fin_enum | varchar(40) | Yes | Exchange initiated as | No |
| tsk_exch_indicator | fin_indicator | Char(25) | Yes | Exchange indicator | No |
| tsk_reason_forexch | fin_reason | varchar(256) | Yes | Reason for exchange | No |
| tsk_billingdocno | fin_documentno | varchar(40) | Yes | Billing doc no | No |
| tsk_billingfor | fin_doctype | varchar(40) | Yes | Billing for | No |
| tsk_marginpercent | fin_percent | Numeric(17) | Yes | Margin percent | No |
| tsk_tsk_src_doc_no | fin_documentno | varchar(40) | Yes | Source Document NO. | No |
| tsk_tsk_ref_date | fin_date | datetime(8) | Yes | Reference date | No |
| tsk_fp_ref | fin_rev_no | int(4) | Yes | Fixed price reference | No |
| tsk_incl_cd | fin_effectivitycode | varchar(40) | Yes | Inclusion code | No |
| tsk_co_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | tsk_co_eff_ref_cd | No |
| tsk_tsk_eff_ref_cd | fin_effectivitycode | varchar(40) | Yes | tsk_tsk_eff_ref_cd | No |
| tsk_co_eff_ref_lineno | fin_lineno | int(4) | Yes | tsk_co_eff_ref_lineno | No |
| tsk_discrepancy_type | fin_designparamcode | varchar(5) | Yes | tsk_discrepancy_type | No |
| tsk_discrepancy_cat | fin_quickcodes | varchar(25) | Yes | tsk_discrepancy_cat | No |
| tsk_discrepancy_Rep_class | fin_repairclassification | varchar(25) | Yes | tsk_discrepancy_Rep_class | No |
| tsk_disctsk_flag | fin_flag | varchar(25) | Yes | tsk_disctsk_flag | No |
| tsk_parent_tsk_trackid | fin_tasktrackid | bigint(8) | Yes | tsk_parent_tsk_trackid | No |
| tsk_root_tsk_trackid | fin_tasktrackid | bigint(8) | Yes | tsk_root_tsk_trackid | No |
| tsk_pricingtsk_trackid | fin_tasktrackid | bigint(8) | Yes | tsk_pricingtsk_trackid | No |
| tsk_prim_wrk_center | fin_workcenter | varchar(80) | Yes | tsk_prim_wrk_center | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| rtb_guid | fin_guid | varchar(40) | Yes | GUID | No |
| rtb_ou | fin_ctxt_ouinstance | int(4) | Yes | OU Instance | No |
| rtb_cso_no | fin_documentno | varchar(40) | Yes | Customer Order NO. | No |
| rtb_rel_no | fin_releaseno | int(4) | Yes | Release No | No |
| rtb_type | fin_flag | varchar(25) | Yes | Ready To Bill Type | No |
| rtb_tsk_lineno | fin_lineno | int(4) | Yes | Task Line No | No |
| rtb_typ_lineno | fin_lineno | int(4) | Yes | Type Line No | No |
| rtb_price_disposition | fin_notes | varchar(2000) | Yes | Price Disposition | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Null | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| rtb_guid | fin_guid | varchar(40) | Yes | Null | No |
| rtb_ou | fin_ctxt_ouinstance | int(4) | Yes | Null | No |
| rtb_cso_no | fin_documentno | varchar(40) | Yes | Null | No |
| rtb_rel_no | fin_releaseno | int(4) | Yes | Null | No |
| rtb_status | fin_status | varchar(25) | Yes | Null | No |
| rtb_date | fin_date | datetime(8) | Yes | Null | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Null | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| csb_bw_order_no | fin_documentno | varchar(40) | No | Null | Yes |
| csb_bw_line_no | fin_lineno | int(4) | No | Null | Yes |
| csb_bw_ou_id | fin_ctxt_ouinstance | int(4) | No | Null | Yes |
| csb_bw_inv_cat | fin_invoicecategory | varchar(40) | Yes | Null | No |
| csb_bw_inv_event | fin_event | varchar(40) | Yes | Null | No |
| csb_bw_inv_type | fin_invoicetypes | varchar(25) | Yes | Null | No |
| csb_bw_event_desc | fin_description | varchar(100) | Yes | Null | No |
| csb_bw_triggr_task | fin_taskno | varchar(40) | Yes | Null | No |
| csb_bw_event_dt | fin_date | datetime(8) | Yes | Null | No |
| csb_bw_int_invoice | fin_designparamcode | varchar(5) | Yes | Null | No |
| csb_bw_basis | fin_basis | varchar(8) | Yes | Null | No |
| csb_bw_notes | fin_comments | varchar(256) | Yes | Null | No |
| csb_bw_modby | fin_ctxt_user | varchar(30) | Yes | Null | No |
| csb_bw_moddt | fin_date | datetime(8) | Yes | Null | No |
| csb_bw_rel_no | fin_releaseno | int(4) | Yes | Null | No |
| csb_bw_wo_compdt | fin_date | datetime(8) | Yes | Null | No |
| csb_bw_wo_closdt | fin_date | datetime(8) | Yes | Null | No |
| csb_bw_resbasis | fin_basis | varchar(8) | Yes | Null | No |
| csb_bw_invoiced | fin_designparamcode | varchar(5) | Yes | Null | No |
| csb_bw_invline_no | fin_rowno | int(4) | No | Null | Yes |
| csb_bw_cumm | fin_enum_cd | varchar(5) | Yes | Null | No |
| csb_bw_payterm | fin_payterm | varchar(30) | Yes | Null | No |
| csb_bw_billpriordays | fin_quantity | numeric(17) | Yes | Null | No |
| csb_bw_prepayval | fin_values | numeric(17) | Yes | Null | No |
| csb_bw_con_no | fin_documentno | varchar(40) | Yes | Null | No |
| csb_bw_conrev_no | fin_rev_no | int(4) | Yes | Null | No |
| csb_upd_doc_no | fin_documentno | varchar(40) | Yes | Null | No |
| csb_upd_doc_type | fin_doctype | varchar(40) | Yes | Null | No |
| csb_bw_relbfevent | fin_enum_cd | varchar(5) | Yes | Null | No |
| csb_bw_auto_rel | fin_enum_cd | varchar(5) | Yes | Null | No |
| csb_bw_rtb_rel | fin_enum_cd | varchar(5) | Yes | Null | No |
| csb_bw_auto_status | fin_designparamcode | varchar(5) | Yes | Null | No |
| csb_bw_warcoverage | fin_enum_cd | varchar(5) | Yes | Null | No |
| csb_bw_schd_status | fin_status | varchar(25) | Yes | Null | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| rel_guid | fin_guid | varchar(40) | No | GUID | No |
| rel_lineno | fin_lineno | int(4) | No | Line no | No |
| rel_ou | fin_ctxt_ouinstance | int(4) | No | OU instance | No |
| rel_cso_no | fin_documentno | varchar(40) | No | Customer order no | No |
| rel_cso_rev_no | fin_rev_no | int(4) | No | Cso rev no | No |
| rel_trigger_task | fin_taskcode | varchar(30) | No | Trigger task | No |
| rel_process_date | fin_date | datetime(8) | No | Process date | No |
| rel_error | fin_notes | varchar(2000) | No | Error | No |
| rel_errorid | fin_errorid | int(4) | No | Errorid | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes | |
| Table Name : | csb_rel_main_hdr |
| Comment : | Header information of Customer Service billing |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| csb_rel_cso_no | fin_documentno | varchar(40) | No | customer order no | Yes |
| csb_rel_no | fin_rev_no | int(4) | No | release no | Yes |
| csb_rel_typ | fin_type | varchar(25) | No | Release type | Yes |
| csb_rel_cat | fin_category | varchar(15) | No | Release category | Yes |
| csb_rel_ou | fin_ctxt_ouinstance | int(4) | No | OU instance | Yes |
| csb_rel_cso_rev_no | fin_rev_no | int(4) | Yes | Rel CSO revision no | No |
| csb_rel_inv_basis | fin_enum_cd | varchar(5) | Yes | Rel invoice basis | No |
| csb_rel_rel_mode | fin_enum_cd | varchar(5) | Yes | Release mode | No |
| csb_rel_currency | fin_currency | varchar(5) | Yes | Rel currency | No |
| csb_rel_event_lineno | fin_lineno | int(4) | Yes | Rel event line no | No |
| csb_rel_sts | fin_status | varchar(25) | Yes | Release status | No |
| csb_rel_date | fin_date | datetime(8) | Yes | Release date | No |
| csb_rel_cust_no | fin_customer_id | varchar(18) | Yes | Rel customer no | No |
| csb_rel_bill_to_cust | fin_customer_id | varchar(18) | Yes | Rel bill to customer | No |
| csb_rel_comm | fin_comments | varchar(256) | Yes | Rel comments | No |
| csb_rel_cnt_no | fin_documentno | varchar(40) | Yes | Rel contract no | No |
| csb_rel_event_date | fin_date | datetime(8) | Yes | rel eventdate | No |
| csb_rel_wo_comp_date | fin_date | datetime(8) | Yes | Rel wo comp date | No |
| csb_rel_quote_no | fin_documentno | varchar(40) | Yes | Release quote no | No |
| csb_rel_quote_rev_no | fin_rev_no | int(4) | Yes | Rel quote rev no | No |
| csb_rel_quote_sts | fin_status | varchar(25) | Yes | Release quote status | No |
| csb_rel_rtb_date | fin_date | datetime(8) | Yes | Rel RTB date | No |
| csb_rel_usr_sts | fin_quickcodes | varchar(25) | Yes | Rel User status | No |
| csb_rel_rtb_info | fin_enum_cd | varchar(5) | Yes | Rel RTB info | No |
| csb_rel_rtb_analysis | fin_rtbanalysis | varchar(1000) | Yes | Rel RTB analysis | No |
| csb_rel_rtb_user | fin_user | varchar(15) | Yes | Rel RTB user | No |
| csb_rel_rtb_overrid_date | fin_datetime | datetime(8) | Yes | Rel RTB overrid date | No |
| csb_rel_err_log | fin_Log | varchar(1000) | Yes | Rel error log | No |
| csb_rel_pay_term | fin_payterm | varchar(30) | Yes | Rel pay term | No |
| csb_rel_reporcess_comm | fin_comments | varchar(256) | Yes | Rel reporcess comments | No |
| csb_rel_proj_rel_date | fin_date | datetime(8) | Yes | Rel Project release date | No |
| csb_rel_internal_com | fin_comments | varchar(256) | Yes | Rel internal comments | No |
| csb_rel_quot_res_price | fin_price | numeric(13) | Yes | Rel quote resource price | No |
| csb_rel_quot_mat_price | fin_price | numeric(13) | Yes | Rel quote materials price | No |
| csb_rel_quot_othser_price | fin_price | numeric(13) | Yes | Rel quot other service price | No |
| csb_rel_quot_fp_price | fin_price | numeric(13) | Yes | Rel quote fixed price | No |
| csb_rel_quot_tm_price | fin_price | numeric(13) | Yes | Rel quote TM price | No |
| csb_rel_quot_chg_price | fin_price | numeric(13) | Yes | Rel Quote charge price | No |
| csb_rel_inv_res_price | fin_price | numeric(13) | Yes | Rel invoice resource price | No |
| csb_rel_inv_mat_price | fin_price | numeric(13) | Yes | Rel invoice materials price | No |
| csb_rel_inv_othser_price | fin_price | numeric(13) | Yes | Rel invoice other service price | No |
| csb_rel_inv_chg_price | fin_price | numeric(13) | Yes | Rel invoice charge price | No |
| csb_rel_quoted_price | fin_price | numeric(13) | Yes | Rel quoted price | No |
| csb_rel_actual_price | fin_price | numeric(13) | Yes | Rel Actual price | No |
| csb_rel_invoiced_price | fin_price | numeric(13) | Yes | Rel invoiced price | No |
| csb_rel_total_cost | fin_cost | numeric(13) | Yes | Rel total cost | No |
| csb_rel_tot_cld_tsks | fin_count | int(4) | Yes | Rel total cld tasks | No |
| csb_rel_tot_bild_tsks | fin_count | int(4) | Yes | Rel total bild tasks | No |
| csb_relprep_bfr_event | fin_enum_cd | varchar(5) | Yes | Rel rep bfr event | No |
| csb_relsetup | fin_enum_cd | varchar(5) | Yes | Release setup | No |
| csb_relof_rtbinv | fin_enum_cd | varchar(5) | Yes | Relof rtbinv | No |
| csb_rel_csi_genmd | fin_enum_cd | varchar(5) | Yes | Rel Csi genmd | No |
| csb_rel_csi_inv_no | fin_documentno | varchar(40) | Yes | Rel CSI invoice no | No |
| csb_rel_csi_sts | fin_status | varchar(25) | Yes | Rel csi status | No |
| csb_rel_timestamp | fin_timestamp | int(4) | Yes | Rel timestamp | No |
| csb_rel_created_by | fin_ctxt_user | varchar(30) | Yes | Rel created by | No |
| csb_rel_created_date | fin_date | datetime(8) | Yes | Rel created date | No |
| csb_rel_modified_by | fin_ctxt_user | varchar(30) | Yes | Rel modified by | No |
| csb_rel_modified_date | fin_date | datetime(8) | Yes | Rel modified date | No |
| csb_rel_inv_tcd_amount | fin_price | numeric(13) | Yes | Rel Invoice TCD amount | No |
| csb_rel_quot_tcd_amount | fin_price | numeric(13) | Yes | Rel Quote TCD amount | No |
| csb_rel_saletype | fin_quickcodes | varchar(25) | Yes | Rel saletype | No |
| csb_rel_pricingbasis | fin_enum_cd | varchar(5) | Yes | Rel paricing basis | No |
| csb_inv_process_date | fin_date | datetime(8) | Yes | Invoice process date | No |
| csb_rel_inv_othrep_price | fin_price | numeric(13) | Yes | Rel invoice other rep price | No |
| csb_rel_inv_fpmat_price | fin_price | numeric(13) | Yes | Rel invoice Fp material price | No |
| csb_rel_inv_fpres_price | fin_price | numeric(13) | Yes | Rel invoice FP resource price | No |
| csb_rel_inv_fptot_price | fin_price | numeric(13) | Yes | Rel Invoice FP total price | No |
| csb_rel_cnt_revno | fin_rev_no | int(4) | Yes | Rel contract rev no | No |
| csb_rel_voucher_no | fin_documentno | varchar(40) | Yes | Rel voucher no | No |
| csb_rel_onevent_comp | fin_checkflag | int(4) | Yes | Rel onevent comp | No |
| csb_rev_rec_amt | fin_amount | numeric(13) | Yes | Erl rec amount | No |
| csb_rel_confirmed_by | fin_ctxt_user | varchar(30) | Yes | Release confirmed by | No |
| csb_rel_confirmed_date | fin_date | datetime(8) | Yes | Release confirmed date | No |
| csb_rel_processed_by | fin_ctxt_user | varchar(30) | Yes | Processed by | No |
| csb_rel_processed_date | fin_date | datetime(8) | Yes | Processed date | No |
| csb_inv_rel_ready_man | fin_flag | varchar(25) | Yes | Invoice ready man | No |
| csb_rel_basic_value | fin_price | numeric(13) | Yes | Basic value | No |
| csb_rel_waranty | fin_flag | varchar(25) | Yes | Rel warranty | No |
| csb_rel_inv_othres_price | fin_price | numeric(13) | Yes | Rel invoice other resource price | No |
| csb_rel_inv_fplab_price | fin_price | numeric(13) | Yes | Rel inv FP lab price | No |
| csb_rel_inv_fpothres_price | fin_price | numeric(13) | Yes | Inv FP other resource price | No |
| csb_rel_inv_lab_price | fin_price | numeric(13) | Yes | Rel inv lab price | No |
| csb_rel_custrep | fin_ctxt_user | varchar(30) | Yes | Customer representative | No |
| csb_rel_exchrate | fin_exchangerate | numeric(9) | Yes | Rel exchange rate | No |
| csb_rel_rtb_last_date | fin_date | datetime(8) | Yes | Rel RTB last date | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes |
| csb_rel_inv_flag | fin_flag | varchar(25) | Yes | Rel invoice flag | No |
| csb_rel_marginpercent | fin_percent | Numeric(17) | Yes | Rel margin percent | No |
| csb_rel_atano | fin_atanumber | varchar(16) | Yes | Rel ATA no | No |
| csb_rel_cso_ord_date | fin_date | datetime(8) | Yes | Rel CSO order date | No |
| csb_rel_pg_cnt_revno | fin_rev_no | int(4) | Yes | Rel PG contract revision no | No |
| csb_reapply_caps | fin_designparamcode | varchar(5) | Yes | Rel reapply caps | No |
| csb_res_reapply_caps | fin_yesnoflag | varchar(5) | Yes | Null | No |
| csb_rel_dir_tot_price | fin_price | numeric(13) | Yes | Total price for Direct Pricing | No |
| csb_ext_reapply_caps | fin_yesnoflag | varchar(5) | Yes | Null | No |
| csb_rel_totval_basecurr | fin_price | numeric(13) | Yes | Total Value base currency | No |
| csb_rel_inv_ordchg_amount | fin_price | numeric(13) | Yes | Charges amount | No |
| csb_rel_inv_event_desc | fin_event | varchar(40) | Yes | invoice description | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| csb_rel_cso_no | fin_documentno | varchar(40) | No | Null | No |
| csb_rel_no | fin_int | int(4) | No | Null | No |
| csb_rel_ou | fin_ctxt_ouinstance | int(4) | No | Null | No |
| csb_rel_inv_event_lineno | fin_int | int(4) | Yes | Null | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Null | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| rel_tran_type | fin_cmntrantype | varchar(10) | No | Release tran type | Yes |
| rel_tran_ou | fin_ctxt_ouinstance | int(4) | No | Release tran OU | Yes |
| rel_tran_no | fin_documentno | varchar(40) | No | Rlease Tran No | Yes |
| rel_posting_line_no | fin_lineno | int(4) | No | Posting line no | Yes |
| rel_line_no | fin_lineno | int(4) | No | Release line no | Yes |
| rel_posting_date | fin_date | datetime(8) | Yes | Posting date | No |
| rel_fb_id | fin_financebookid | varchar(20) | Yes | Fb id | No |
| rel_tran_date | fin_date | datetime(8) | Yes | Tran date | No |
| rel_account_type | fin_vataccounttype | varchar(40) | Yes | Account type | No |
| rel_account_code | fin_accountcode | varchar(32) | Yes | Account code | No |
| rel_drcr_id | fin_designparamcode | varchar(5) | Yes | Drcr id | No |
| rel_tran_currency | fin_currency | varchar(5) | Yes | tran currency | No |
| rel_tran_amount | fin_amount | numeric(13) | Yes | Tran amount | No |
| rel_exchange_rate | fin_exchangerate | numeric(9) | Yes | Exchange rate | No |
| rel_base_amount | fin_amount | numeric(13) | Yes | Base amount | No |
| rel_par_exchange_rate | fin_exchangerate | numeric(9) | Yes | Par exchange rate | No |
| rel_par_base_amount | fin_amount | numeric(13) | Yes | Par base amount | No |
| rel_cost_center | fin_costcentercode | varchar(10) | Yes | cost center | No |
| rel_analysis_code | fin_analysiscode | varchar(5) | Yes | Analysis code | No |
| rel_subanalysis_code | fin_subanalysiscode | varchar(5) | Yes | Sub analysis code | No |
| rel_guid | fin_guid | varchar(40) | Yes | Guid | No |
| rel_item_code | fin_itemcode | varchar(40) | Yes | Item code | No |
| rel_item_variant | fin_itemcode | varchar(40) | Yes | Item variant | No |
| rel_cust_code | fin_customer_id | varchar(18) | Yes | Customer code | No |
| rel_ref_doc_type | fin_desc40 | varchar(40) | Yes | Reference Document type | No |
| rel_ref_doc_no | fin_documentno | varchar(40) | Yes | Reference Document no | No |
| rel_company_code | fin_companycode | varchar(10) | Yes | Company code | No |
| rel_timestamp | fin_int | int(4) | Yes | Time stamp | No |
| rel_createdby | fin_ctxt_user | varchar(30) | Yes | Created by | No |
| rel_createddate | fin_date | datetime(8) | Yes | Created date | No |
| rel_modifiedby | fin_ctxt_user | varchar(30) | Yes | Modified by | No |
| rel_modifieddate | fin_date | datetime(8) | Yes | Modified date | No |
| rel_ame_no | fin_documentno | varchar(40) | Yes | Ame no | No |
| rel_swo_no | fin_documentno | varchar(40) | Yes | Swo no | No |
| rel_ref_line_no | fin_lineno | int(4) | Yes | Ref line no | No |
| rel_bu_id | fin_buid | varchar(20) | Yes | BU id | No |
| rel_component_name | fin_desc20 | varchar(20) | Yes | Component name | No |
| rel_custorder_no | fin_documentno | varchar(40) | Yes | Customer order no | No |
| rel_no | fin_releaseno | int(4) | Yes | Release no | No |
| rel_entry_date | fin_date | datetime(8) | Yes | Entry date | No |
| rel_auth_date | fin_date | datetime(8) | Yes | Auth date | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| rtb_ou | fin_ctxt_ouinstance | int(4) | Yes | OU instance | No |
| rtb_cso_no | fin_documentno | varchar(40) | No | Customer order no | Yes |
| rtb_rel_no | fin_releaseno | int(4) | No | Release no | Yes |
| rtb_type | fin_flag | varchar(25) | No | RTB type | Yes |
| rtb_tsk_lineno | fin_lineno | int(4) | No | Task line no | Yes |
| rtb_typ_lineno | fin_lineno | int(4) | No | Type line no | Yes |
| rtb_price_disposition | fin_notes | varchar(2000) | Yes | Price disposition | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| rtb_ou | fin_ctxt_ouinstance | int(4) | Yes | OU instance | No |
| rtb_cso_no | fin_documentno | varchar(40) | Yes | Customer order no | No |
| rtb_rel_no | fin_releaseno | int(4) | Yes | Release No | No |
| rtb_status | fin_status | varchar(25) | Yes | RTB status | No |
| rtb_date | fin_date | datetime(8) | Yes | RTB date | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes |