Data Dictionary -- Sale Quotation

Srl. No.	Table Name	Comment
1	salquot_charge_dtl	Sales Quotation of Charge Details
2	salquot_external_service_dtl	Sales Quotation of External Service Details
3	salquot_material_pricing_dtl	Sales Quotation of Material Pricing details
4	salquot_other_doc_details	Sales Quotation Other Document Details
5	salquot_pricing_summary	Sales Quotation of Pricing Summary
6	salquot_quot_info_mst	Sales Quotation Info Master
7	salquot_resource_pricing_dtl	Sales Quotation of Resource Pricing Details
8	salquot_rooster_dtl	Sales Quotation of rooster details
9	SalQuot_Task_Coa_flip	SalQuot_Task_Coa_flip
10	salquot_task_dtl	Sales Quotation of task details
11	salquot_task_fp_dtl	Sales Quotation of task fp details
12	salquot_tcd_app_dtl	Tcd apportion
13	salquot_tcd_dtl	Sales Quotation of tcd details

Table Name :	salquot_charge_dtl
Comment :	Sales Quotation of Charge Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
chr_quot_no	fin_documentno	varchar(40)	No	Charge quotation No	Yes
chr_quot_rev_no	fin_rev_no	int(4)	No	Charge quotation revsion No	Yes
chr_ouinst_id	fin_ctxt_ouinstance	int(4)	No	Charge Ou instance Id	Yes
chr_line_no	fin_lineno	int(4)	No	Charge Line No	Yes
timestamp	fin_int	int(4)	Yes	Charge time stamp	No
chr_quote_indicator	fin_desc40	varchar(40)	Yes	Charge quotation indicator	No
chr_quote_line_no	fin_lineno	int(4)	Yes	Charge quotation Line No	No
chr_cap	fin_desc40	varchar(40)	Yes	Charge Cap	No
chr_charge_source	fin_designparamcode	varchar(5)	Yes	Charge Source	No
chr_chargecode	fin_tcdcodes	varchar(25)	Yes	Charge Code	No
chr_variant	fin_tcdcodes	varchar(25)	Yes	Charge variant	No
chr_amount	fin_amount	numeric(13)	Yes	Charge Amount	No
chr_currency	fin_currencycode	varchar(5)	Yes	Charge Currency	No
chr_pricing_factor	fin_amount	numeric(13)	Yes	Charge Pricing Factor	No
chr_markup	fin_amount	numeric(13)	Yes	Charge Markup	No
chr_capped_markup	fin_amount	numeric(13)	Yes	Charge Capped Markup	No
chr_accountusage	fin_ccusage	varchar(20)	Yes	Charge Accout usage	No
chr_costcenter	fin_maccost	varchar(32)	Yes	Charge Cost Center	No
chr_final_charge	fin_amount	numeric(13)	Yes	Final Charge amount	No
chr_ext_price	fin_amount	numeric(13)	Yes	Charge External Price	No
chr_coa	fin_designparamcode	varchar(5)	Yes	Charge COA	No
chr_existing_billable	fin_designparamcode	varchar(5)	Yes	Charge Existing Billable	No
chr_billable	fin_designparamcode	varchar(5)	Yes	Charge Billable	No
chr_pricenarration	fin_comments	varchar(256)	Yes	Charge Price Narration	No
chr_internalnotes	fin_contextinfo	varchar(1024)	Yes	Charge Internal Notes	No
chr_remarks	fin_comments	varchar(256)	Yes	Charge Remarks	No
chr_last_updated_log	fin_contextinfo	varchar(1024)	Yes	Charge Last Updated Log	No
chr_pricing_notes	fin_notes	varchar(2000)	Yes	Charge Pricing Notes	No
chr_pricing_basis	fin_quickcodes	varchar(25)	Yes	Charge Pricing Basis	No
chr_price_disposition	fin_Disposition	varchar(40)	Yes	Charge Price display Position	No
chr_estimated_remarks	fin_comments	varchar(256)	Yes	Charge Estimated Remarks	No
chr_pricing_description	fin_partdesc	varchar(150)	Yes	Charge Pricing Description	No
chr_created_by	fin_ctxt_user	varchar(30)	Yes	Charge Created By	No
chr_created_date	fin_date	datetime(8)	Yes	Charge Created Date	No
chr_modified_by	fin_ctxt_user	varchar(30)	Yes	Charge Modified By	No
chr_modified_date	fin_date	datetime(8)	Yes	Charge Modified Date	No
chr_servicepricelist	fin_documentno	varchar(40)	Yes	Charge Service Price List	No
chr_pricelist_rev	fin_revision	varchar(10)	Yes	Charge Price List Revision	No
chr_chargecode_desc	fin_txt80	varchar(80)	Yes	Charge Code description	No
chr_variant_desc	fin_txt80	varchar(80)	Yes	Charge Variant Description	No
chr_exchnge_rate	fin_amount	numeric(13)	Yes	Charge Exchange Rate	No
chr_ref_currency	fin_currencycode	varchar(5)	Yes	Charge Ref Currency	No
chr_pricing_source	fin_type	varchar(25)	Yes	Charge Pricing Source	No
chr_modification_nts	fin_notes	varchar(2000)	Yes	Charge Modification Notes	No
chr_rel_no	fin_rev_no	int(4)	Yes	Release Number	No
chr_invoiced	fin_flag	varchar(25)	Yes	Invoiced	No

Table Name :	salquot_external_service_dtl
Comment :	Sales Quotation of External Service Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ext_quot_no	fin_documentno	varchar(40)	No	External Quotation No	Yes
ext_quot_rev_no	fin_rev_no	int(4)	No	External Quotation Revision No	Yes
ext_quote_line_no	fin_lineno	int(4)	No	External Quotation Line No	Yes
ext_ouinst_id	fin_ctxt_ouinstance	int(4)	No	External Oraganization Unit Instance Id	Yes
timestamp	fin_int	int(4)	Yes	External Time Stamp	No
ext_quote_indicator	fin_desc40	varchar(40)	Yes	External Quotation Indicator	No
ext_caps	fin_paramdesc	varchar(30)	Yes	External Caps	No
ext_supplier_id	fin_vendorcode	varchar(45)	Yes	External Supplier Id	No
ext_part_id	fin_partno	varchar(40)	Yes	External Part Id	No
ext_mfr_part_id	fin_partno	varchar(40)	Yes	External Manufactor Part Id	No
ext_mfr_id	fin_partno	varchar(40)	Yes	External Manufactor Id	No
ext_repair_qty	fin_quantity	numeric(17)	Yes	External Repair Quantity	No
ext_ber_qty	fin_quantity	numeric(17)	Yes	External ber Quantity	No
ext_price	fin_amount	numeric(13)	Yes	External Price	No
ext_ber_cost	fin_amount	numeric(13)	Yes	External ber Cost	No
ext_pricing_factor	fin_factor	numeric(13)	Yes	External Pricing Factor	No
ext_mark_up	fin_amount	numeric(13)	Yes	External Markup	No
ext_capped_mark_up	fin_amount	numeric(13)	Yes	External Capped Markup	No
ext_capped_ext_price	fin_amount	numeric(13)	Yes	External capped External price	No
ext_final_price	fin_amount	numeric(13)	Yes	External final price	No
ext_price_disposition	fin_Disposition	varchar(40)	Yes	External Price Display position	No
ext_remarks	fin_remarks	varchar(100)	Yes	External Remarks	No
ext_sys_billable	fin_designparamcode	varchar(5)	Yes	External System Billable	No
ext_billable	fin_designparamcode	varchar(5)	Yes	External Billable	No
ext_coa	fin_designparamcode	varchar(5)	Yes	External COA	No
ext_pricenarrarion	fin_comments	varchar(256)	Yes	External Price Narrarion	No
ext_internalnotes	fin_contextinfo	varchar(1024)	Yes	External Internal Notes	No
ext_lastupdatedlog	fin_contextinfo	varchar(1024)	Yes	External Last Updated Log	No
ext_service_price_list	fin_documentno	varchar(40)	Yes	External Service Price List	No
ext_service_price_list_rev	fin_revision	varchar(10)	Yes	External Price List revision	No
ext_exec_doc_line_no	fin_lineno	int(4)	Yes	External execution document Line No	No
ext_doc_type	fin_documenttype	varchar(40)	Yes	External document type	No
ext_pricing_basis	fin_quickcodes	varchar(25)	Yes	External Pricing Basis	No
ext_exch_rate	fin_exchangerate	numeric(9)	Yes	External Exchange rate	No
ext_ref_currency	fin_currencycode	varchar(5)	Yes	External Reference Currency	No
ext_process_id	fin_documentno	varchar(40)	Yes	External Process Id	No
ext_sub_process_id	fin_documentno	varchar(40)	Yes	External Sub Process Id	No
ext_order_type	fin_type	varchar(25)	Yes	External Order Type	No
ext_order_no	fin_documentno	varchar(40)	Yes	External Order No	No
ext_order_status	fin_status	varchar(25)	Yes	External Order status	No
ext_modified_by	fin_ctxt_user	varchar(30)	Yes	External Modified By	No
ext_modified_date	fin_date	datetime(8)	Yes	External modified Date	No
ext_created_by	fin_ctxt_user	varchar(30)	Yes	External Created By	No
ext_created_date	fin_date	datetime(8)	Yes	External Created Date	No
ext_supplier_name	fin_suppliername	varchar(40)	Yes	External Supplier Name	No
ext_ext_price	fin_amount	numeric(13)	Yes	External External Price	No
ext_part_condition	fin_description	varchar(100)	Yes	External Part Condition	No
ext_stock_status	fin_status	varchar(25)	Yes	External Stock Status	No
ext_part_attributes	fin_description	varchar(100)	Yes	External part Attributes	No
ext_llp	fin_paramdesc	varchar(30)	Yes	External llp	No
ext_unit_rate	fin_rate	numeric(13)	Yes	External Unit Rate	No
ext_base_adjust_factor	fin_rate	numeric(13)	Yes	External Base Adjust Factor	No
ext_adjust_unit_rate	fin_rate	numeric(13)	Yes	External Adjust Unit Rate	No
ext_ref_cataloge_id	fin_documentno	varchar(40)	Yes	External Reference Cataloge Id	No
ext_pricing_qty	fin_quantity	numeric(17)	Yes	External Pricing Quatity	No
ext_pricing_unit_rate	fin_rate	numeric(13)	Yes	external Pricing Unit Rate	No
ext_pricing_coa	fin_designparamcode	varchar(5)	Yes	External Pricing COA	No
ext_pricing_warenty_reco	fin_designparamcode	varchar(5)	Yes	External Pricing Warenty Reco	No
ext_pricing_custorder_curr	fin_currencycode	varchar(5)	Yes	External Pricing Customer order Currency	No
ext_pricing_repl_type	fin_designparamcode	varchar(5)	Yes	External Pricing Repl Type	No
ext_pricing_part_type	fin_designparamcode	varchar(5)	Yes	External Pricing part Type	No
ext_pricing_part_group	fin_desc40	varchar(40)	Yes	External Pricing Part Group	No
ext_pricing_part_class	fin_designparamcode	varchar(5)	Yes	External Pricing Part Class	No
ext_cap_max_limit	fin_designparamcode	varchar(5)	Yes	External Cap maximum Limit	No
ext_cap_max_limitcapcode	fin_enum	varchar(40)	Yes	External Cap Maximum Limit cap code	No
ext_cap_cov_limit	fin_designparamcode	varchar(5)	Yes	External Cap Cov Limit	No
ext_cap_cov_limitcapcode	fin_enum	varchar(40)	Yes	External Cap Cov Limit Cap Code	No
ext_cap_ext_limit	fin_designparamcode	varchar(5)	Yes	External Cap Limit	No
ext_cap_ext_limitcapcode	fin_enum	varchar(40)	Yes	External Cap Limit Cap Code	No
ext_cap_flag	fin_designparamcode	varchar(5)	Yes	External Cap Flag	No
ext_service_price_list_ou	fin_ctxt_ouinstance	int(4)	Yes	External Price List Organization unit	No
ext_line_id	fin_lineno	int(4)	No	External Line Id	Yes
ext_cost	fin_amount	numeric(13)	Yes	Extternal Cost	No
Ext_Rep_BER_Cost	fin_amount	numeric(13)	Yes	External Repair Ber Coset	No
Ext_Exch_fee	fin_amount	numeric(13)	Yes	External Exchange Fee	No
Ext_Non_Rtn_Cost	fin_amount	numeric(13)	Yes	External Non Return Cost	No
Ext_Total_cost	fin_amount	numeric(13)	Yes	External total cost	No
ext_element	fin_designparamcode	varchar(5)	Yes	External Element	No
ext_sourceflag	fin_flag	varchar(25)	Yes	External Source Flag	No
ext_part_serial_lot_id	fin_partserialnumber	varchar(40)	Yes	External Part Serial Lot Id	No
ext_exch_indicator	fin_paramdesc	varchar(30)	Yes	External Exchange Indicator	No
ext_quot_comments	fin_comments	varchar(256)	Yes	External Quote Comments	No
ext_comments	fin_comments	varchar(256)	Yes	External Comments	No
ext_quote_type	fin_type	varchar(25)	Yes	ext_quote_type	No
ext_price_element	fin_designparamcode	varchar(5)	Yes	ext_price_element	No
ext_uom	fin_uom	varchar(15)	Yes	ext_uom	No
ext_fact_appliedon	fin_designparamcode	varchar(5)	Yes	ext_fact_appliedon	No
ext_basic_rate_cocur	fin_amount	numeric(13)	Yes	ext_basic_rate_cocur	No
ext_covered_baserate	fin_amount	numeric(13)	Yes	ext_covered_baserate	No
ext_adj_baserate	fin_amount	numeric(13)	Yes	ext_adj_baserate	No
ext_final_base_rate	fin_amount	numeric(13)	Yes	ext_final_base_rate	No
ext_pg_price_facton	fin_designparamcode	varchar(5)	Yes	ext_pg_price_facton	No
ext_cap_onunit_markup	fin_amount	numeric(13)	Yes	ext_cap_onunit_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_cov_unit_price	fin_amount	numeric(13)	Yes	ext_cov_unit_price	No
ext_final_unit_price	fin_amount	numeric(13)	Yes	ext_final_unit_price	No
ext_ext_base_price	fin_amount	numeric(13)	Yes	ext_ext_base_price	No
ext_ext_mark_up	fin_amount	numeric(13)	Yes	ext_ext_mark_up	No
ext_cap_onext_markup	fin_amount	numeric(13)	Yes	ext_cap_onext_markup	No
ext_Adj_mark_up	fin_amount	numeric(13)	Yes	ext_Adj_mark_up	No
ext_fin_ext_markup	fin_amount	numeric(13)	Yes	ext_fin_ext_markup	No
ext_cov_price	fin_amount	numeric(13)	Yes	ext_cov_price	No
ext_adj_cov_price	fin_amount	numeric(13)	Yes	ext_adj_cov_price	No
ext_final_ext_price	fin_amount	numeric(13)	Yes	ext_final_ext_price	No
ext_pricingsource	fin_quickcodes	varchar(25)	Yes	ext_pricingsource	No
ext_unit_chargecocurr	fin_amount	numeric(13)	Yes	ext_unit_chargecocurr	No
ext_unit_discountcocurr	fin_amount	numeric(13)	Yes	ext_unit_discountcocurr	No
ext_unit_taxcocurr	fin_amount	numeric(13)	Yes	ext_unit_taxcocurr	No
ext_unit_price	fin_amount	numeric(13)	Yes	ext_unit_price	No
ext_modification_notes	fin_notes	varchar(2000)	Yes	ext_modification_notes	No
ext_warranty_res	fin_status	varchar(25)	Yes	ext_warranty_res	No

Table Name :	salquot_material_pricing_dtl
Comment :	Sales Quotation of Material Pricing details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mat_pric_quot_no	fin_documentno	varchar(40)	No	Material Pricing Quotation No	Yes
mat_pric_quot_rev_no	fin_rev_no	int(4)	No	Material Pricing Quotation Revision No	Yes
mat_pric_quote_line_no	fin_lineno	int(4)	No	Material Pricing Quotation Line No	Yes
mat_part_line_id	fin_lineno	int(4)	No	Material part line id	Yes
mat_ouinst_id	fin_ctxt_ouinstance	int(4)	No	Material Organization Unit instance id	Yes
timestamp	fin_int	int(4)	Yes	Material Time Stamp	No
mat_pricing_revision_id	fin_revision	varchar(10)	Yes	Material Prcing Revision Id	No
mat_pricing_element	fin_quickcodes	varchar(25)	Yes	Material Pricing Element	No
mat_quoted_qty	fin_quantity	numeric(17)	Yes	Material Quatated Qty	No
mat_uom	fin_uom	varchar(15)	Yes	Material Unit of Measurement	No
mat_unit_rate	fin_rate	numeric(13)	Yes	Material Unit Rate	No
mat_base_adjust_factor	fin_rate	numeric(13)	Yes	Material Base Adjust Factor	No
mat_adjust_unit_rate	fin_rate	numeric(13)	Yes	Material adjust Unit Rate	No
mat_ext_amt	fin_amount	numeric(13)	Yes	Material External Amount	No
mat_price_factor	fin_factor	numeric(13)	Yes	Material Price Factor	No
mat_ext_mark_up	fin_amount	numeric(13)	Yes	Material external Markup	No
mat_capped_mark_up	fin_amount	numeric(13)	Yes	Material Capped mark up	No
mat_ext_price	fin_amount	numeric(13)	Yes	Material External Price	No
mat_capped_ext_price	fin_amount	numeric(13)	Yes	Material Capped External Price	No
mat_final_price	fin_amount	numeric(13)	Yes	Material Final Price	No
mat_pricing_disposition	fin_Disposition	varchar(40)	Yes	Material Pricing Display Position	No
mat_cap_grouping	fin_paramdesc	varchar(30)	Yes	Material Cap Grouping	No
mat_remarks	fin_remarks	varchar(100)	Yes	Material Remarks	No
mat_est_remarks	fin_remarks	varchar(100)	Yes	Material Estimation Remarks	No
mat_sys_billable	fin_designparamcode	varchar(5)	Yes	Material system Billable	No
mat_coa	fin_designparamcode	varchar(5)	Yes	Material COA	No
mat_billable	fin_designparamcode	varchar(5)	Yes	Material Billable	No
mat_warenty_reco	fin_designparamcode	varchar(5)	Yes	Material Warenty Reco	No
mat_price_narration	fin_comments	varchar(256)	Yes	Material Price Narration	No
mat_internal_notes	fin_contextinfo	varchar(1024)	Yes	Material Internal Notes	No
mat_part_price_list	fin_documentno	varchar(40)	Yes	Material Part Price List	No
mat_part_price_list_rev	fin_revision	varchar(10)	Yes	Material Part Price List Revision	No
mat_pricing_description	fin_partdesc	varchar(150)	Yes	Material Pricing Description	No
mat_pricing_notes	fin_notes	varchar(2000)	Yes	Material pricing Notes	No
mat_last_updated_log	fin_contextinfo	varchar(1024)	Yes	Material Last Updated log	No
mat_pricing_currency	fin_currencycode	varchar(5)	Yes	Material Pricing Currency	No
mat_ref_cataloge_id	fin_documentno	varchar(40)	Yes	Material reference Cataloge Id	No
mat_pricing_qty	fin_quantity	numeric(17)	Yes	Material Pricing Qty	No
mat_pricing_unit_rate	fin_rate	numeric(13)	Yes	Material Pricing Unit Rate	No
mat_pricing_coa	fin_designparamcode	varchar(5)	Yes	Material Pricing COA	No
mat_pricing_warenty_reco	fin_designparamcode	varchar(5)	Yes	Material Pricing Warenty Reco	No
mat_created_by	fin_ctxt_user	varchar(30)	Yes	Material Created By	No
mat_created_date	fin_date	datetime(8)	Yes	Material Created Date	No
mat_modified_by	fin_ctxt_user	varchar(30)	Yes	Material Modified By	No
mat_modified_date	fin_date	datetime(8)	Yes	Material Modified Date	No
mat_pricing_basis	fin_quickcodes	varchar(25)	Yes	Material Pricing Basis	No
mat_quote_indicator	fin_desc40	varchar(40)	Yes	Material Quotation Indicator	No
mat_caps	fin_paramdesc	varchar(30)	Yes	Material caps	No
mat_part_id	fin_partno	varchar(40)	Yes	Material part id	No
mat_mfr_part_id	fin_partno	varchar(40)	Yes	Material Manufactor part id	No
mat_mfr_id	fin_partno	varchar(40)	Yes	Material manufactor Id	No
mat_part_condition	fin_description	varchar(100)	Yes	Material Part Condition	No
mat_stock_status	fin_status	varchar(25)	Yes	Material Stock Status	No
mat_part_attributes	fin_description	varchar(100)	Yes	Material Part Attributes	No
mat_llp	fin_paramdesc	varchar(30)	Yes	Material llp	No
mat_repair_classification	fin_repairclassification	varchar(25)	Yes	Material Repair Classification	No
mat_part_desc	fin_partdesc	varchar(150)	Yes	Material part description	No
mat_cap_flag	fin_designparamcode	varchar(5)	Yes	Material cap flag	No
mat_pricing_custorder_curr	fin_currencycode	varchar(5)	Yes	Material Pricing Customer Order Currency	No
mat_pricing_repl_type	fin_designparamcode	varchar(5)	Yes	Material Pricing Replace Type	No
mat_pricing_part_type	fin_designparamcode	varchar(5)	Yes	Material Pricing Part Type	No
mat_pricing_part_group	fin_desc40	varchar(40)	Yes	Material Pricing Part Group	No
mat_pricing_part_class	fin_designparamcode	varchar(5)	Yes	Material Pricing Part Class	No
mat_inc_exc_ref_code	fin_effectivitycode	varchar(40)	Yes	Material Inclusive exclusive reference Code	No
mat_exch_rate	fin_exchangerate	numeric(9)	Yes	Material exchange Rate	No
mat_part_price_list_ou	fin_ctxt_ouinstance	int(4)	Yes	Material Part Price List Oraganization Unit	No
mat_Oth_Quot_line_no	fin_lineno	int(4)	Yes	Material Other Quatation line No	No
mat_warranty_Reso	fin_designparamcode	varchar(5)	Yes	Material Warranty Resolution	No
mat_ref_price	fin_price	numeric(13)	Yes	Material Ref Price	No
mat_pg_sourceflag	fin_designparamcode	varchar(5)	Yes	mat_pg_sourceflag	No
mat_base_rate_pl_cur	fin_amount	numeric(13)	Yes	mat_base_rate_pl_cur	No
mat_ref_rate_pl_cur	fin_amount	numeric(13)	Yes	mat_ref_rate_pl_cur	No
mat_base_rate_cso_cur	fin_amount	numeric(13)	Yes	mat_base_rate_cso_cur	No
mat_covered_baserate	fin_amount	numeric(13)	Yes	mat_covered_baserate	No
mat_adj_baserate	fin_amount	numeric(13)	Yes	mat_adj_baserate	No
mat_final_base_rate	fin_amount	numeric(13)	Yes	mat_final_base_rate	No
mat_fac_base_rate	fin_amount	numeric(13)	Yes	mat_fac_base_rate	No
mat_pg_price_facton	fin_designparamcode	varchar(5)	Yes	mat_pg_price_facton	No
mat_unit_markup	fin_amount	numeric(13)	Yes	mat_unit_markup	No
mat_cap_onunit_markup	fin_amount	numeric(13)	Yes	mat_cap_onunit_markup	No
mat_Adj_unit_markup	fin_amount	numeric(13)	Yes	mat_Adj_unit_markup	No
mat_final_unit_markup	fin_amount	numeric(13)	Yes	mat_final_unit_markup	No
mat_cov_unit_price	fin_amount	numeric(13)	Yes	mat_cov_unit_price	No
mat_Adj_unit_price	fin_amount	numeric(13)	Yes	mat_Adj_unit_price	No
mat_final_unit_price	fin_amount	numeric(13)	Yes	mat_final_unit_price	No
mat_cap_onext_markup	fin_amount	numeric(13)	Yes	mat_cap_onext_markup	No
mat_Adj_mark_up	fin_amount	numeric(13)	Yes	mat_Adj_mark_up	No
mat_fin_ext_markup	fin_amount	numeric(13)	Yes	mat_fin_ext_markup	No
mat_cov_price	fin_amount	numeric(13)	Yes	mat_cov_price	No
mat_adj_cov_price	fin_amount	numeric(13)	Yes	mat_adj_cov_price	No
mat_final_ext_price	fin_amount	numeric(13)	Yes	mat_final_ext_price	No
mat_part_seq_no	fin_seqno	int(4)	Yes	mat_part_seq_no	No
mat_unit_price	fin_amount	numeric(13)	Yes	mat_unit_price	No
mat_fact_lineno	fin_int	int(4)	Yes	Factored Lineno	No
mat_rel_no	fin_rev_no	int(4)	Yes	Release Number	No
mat_invoiced	fin_flag	varchar(25)	Yes	Invoiced	No

Table Name :	salquot_other_doc_details
Comment :	Sales Quotation Other Document Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Oth_quot_no	fin_documentno	varchar(40)	No	Other Quotation No	Yes
Oth_quot_rev_no	fin_rev_no	int(4)	No	Other Quotation Revision No	Yes
Oth_Quot_line_no	fin_lineno	int(4)	No	Other Quotation line No	Yes
Oth_ou_id	fin_ctxt_ouinstance	int(4)	No	Other Organization Unit Id	Yes
Oth_process_id	fin_seqno	int(4)	Yes	Other Process Id	No
Oth_sub_process_id	fin_seqno	int(4)	Yes	Other Sub Process Id	No
Oth_exec_doc_type	fin_type	varchar(25)	Yes	Other Execution Document Type	No
Oth_exec_doc_no	fin_documentno	varchar(40)	Yes	Other Execution Document No	No
Oth_exec_doc_line_no	fin_lineno	int(4)	Yes	Other Execution Document Line No	No
Oth_exec_doc_status	fin_status	varchar(25)	Yes	Other Execution Document Status	No
Oth_parent_wo_no	fin_documentno	varchar(40)	Yes	Other Parent Wo No	No
Oth_est_remarks	fin_notes	varchar(2000)	Yes	Other estimation Remarks	No
Oth_aircraft_reg_no	fin_acregno	varchar(30)	Yes	Other Aircraft Register No	No
Oth_eff_ref_cd	fin_quickcodes	varchar(25)	Yes	Other Effective Reference Code	No
Oth_Doc_type	fin_type	varchar(25)	Yes	Other Document Type	No
Oth_Doc_no	fin_documentno	varchar(40)	Yes	Other document No	No
Oth_Doc_pric_basis	fin_enum_cd	varchar(5)	Yes	Other Document Price Basis	No
Oth_Doc_curr	fin_currencycode	varchar(5)	Yes	Other Document Currency	No
Oth_doc_amount	fin_amount	numeric(13)	Yes	Other Document Amount	No
Oth_Doc_status	fin_status	varchar(25)	Yes	Other Document Status	No
Oth_Doc_Sub_Type	fin_type	varchar(25)	Yes	Other Document Sub Type	No
Oth_supplier_no	fin_vendorcode	varchar(45)	Yes	Other Supplier No	No
Oth_Supplier_name	fin_txt150	varchar(150)	Yes	Other Supplier Name	No
Oth_billable	fin_enum_cd	varchar(5)	Yes	Other Billable	No
Oth_COA	fin_enum_cd	varchar(5)	Yes	Other COA	No
Oth_Rep_Quote_no	fin_documentno	varchar(40)	Yes	Other Repeat Quotation No	No
Oth_Rep_Quote_date	fin_date	datetime(8)	Yes	Other Repeat Ouotation Date	No
Oth_workcenter	fin_workcenter	varchar(80)	Yes	Other Work Center	No
Oth_warranty_reco	fin_designparamcode	varchar(5)	Yes	Other Warranty Reco	No
Oth_repair_class	fin_repairclassification	varchar(25)	Yes	Other Repair Class	No
Oth_repair_process_code	fin_repairprocesscode	varchar(25)	Yes	Other Repair Process Code	No
Oth_exclusion_code	fin_effectivitycode	varchar(40)	Yes	Other Exclusion Code	No
Oth_exclusion_line_no	fin_lineno	int(4)	Yes	Other Exclusion Line No	No
Oth_excl_notes	fin_notes	varchar(2000)	Yes	Other Exclusion Notes	No
Oth_ATA_no	fin_documentno	varchar(40)	Yes	Other ATA No	No
Oth_ATA_Desc	fin_txt150	varchar(150)	Yes	Other ATA Description	No
Oth_Exch_type	fin_type	varchar(25)	Yes	Other Exchange Type	No
Oth_Reason_Exch	fin_remarks	varchar(100)	Yes	Other Reason Exchange	No
Oth_Exch_init_as	fin_enum_cd	varchar(5)	Yes	Other Exchange Init As	No
Oth_Createdby	fin_ctxt_user	varchar(30)	Yes	Other Created By	No
Oth_Createddate	fin_date	datetime(8)	Yes	Other Created Date	No
Oth_Modifiedby	fin_ctxt_user	varchar(30)	Yes	Other Modified By	No
Oth_Modifieddate	fin_date	datetime(8)	Yes	Other Modified Date	No
Oth_total_price	fin_amount	numeric(13)	Yes	Other Total Price	No
Oth_final_price	fin_amount	numeric(13)	Yes	Other Final Price	No
Oth_sys_billable	fin_enum_cd	varchar(5)	Yes	Other System Billable	No
Oth_action	fin_designparamcode	varchar(5)	Yes	Other Action	No
Oth_action_remarks	fin_comments	varchar(256)	Yes	Other Action Remarks	No
Oth_remarks	fin_comments	varchar(256)	Yes	Other Remarks	No
oth_approval_status	fin_designparamcode	varchar(5)	Yes	Other Approval Status	No
oth_prev_approval_status	fin_designparamcode	varchar(5)	Yes	Other Previous Approval Status	No
oth_internalnotes	fin_contextinfo	varchar(1024)	Yes	Other Internal Notes	No
oth_lastupdatedlog	fin_contextinfo	varchar(1024)	Yes	Other Last Updated Log	No
oth_pricenarration	fin_comments	varchar(256)	Yes	Other Price Narration	No
oth_quote_indicator	fin_desc40	varchar(40)	Yes	Other Quote Indicator	No
OTH_hold_inst_id	fin_tasktrackid	bigint(8)	Yes	Other Hold Instance Id	No
OTH_hold_code	fin_quickcodes	varchar(25)	Yes	Other Hold Code	No
Oth_Exchange_Entity	fin_enum_cd	varchar(5)	Yes	Exchange Entity	No
Oth_modification_nts	fin_contextinfo	varchar(1024)	Yes	Other Modification Notes	No
Oth_qt_doc_type	fin_type	varchar(25)	Yes	Other Quoted Document Type	No
Oth_qt_doc_no	fin_documentno	varchar(40)	Yes	Other Quoted Document Tno	No
oth_warranty_res	fin_designparamcode	varchar(5)	Yes	Other warranty Resolution	No
oth_quot_comments	fin_notes	varchar(2000)	Yes	Other Quote Comments	No
oth_doc_amount_cocurr	fin_amount	numeric(13)	Yes	Other Document CO Cuurency Amount	No
oth_doc_exchrate	fin_exchangerate	numeric(9)	Yes	Other Document Exchange Rate	No
oth_exchrate_cocurr	fin_exchangerate	numeric(9)	Yes	Other Document CO Currency Exchange Rate	No
oth_doc_amt_basecurr	fin_count	int(4)	Yes	oth_quote_count	No
oth_quote_count	fin_amount	numeric(13)	Yes	oth_doc_amt_basecurr	No
oth_coa_exists	fin_flag	varchar(25)	Yes	oth_coa_exists	No

Table Name :	salquot_pricing_summary
Comment :	Sales Quotation of Pricing Summary

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
pri_quot_no	fin_documentno	varchar(40)	No	Pricing Quotation No	Yes
pri_quot_rev_no	fin_rev_no	int(4)	No	Pricing Quotation Revision No	Yes
pri_ouinst_id	fin_ctxt_ouinstance	int(4)	No	Pricing Oraganization Unit Instance Id	Yes
timestamp	fin_int	int(4)	Yes	Pricing Time Stamp	No
pri_level_1_description	fin_text255	varchar(255)	Yes	Pricing Level one Description	No
pri_level_2_description	fin_text255	varchar(255)	Yes	Pricing Level Two Description	No
pri_level_3_description	fin_txt255	varchar(255)	Yes	Pricing Level Three Description	No
pri_level_4_description	fin_txt255	varchar(255)	Yes	Pricing Level Four Description	No
pri_level_5_description	fin_txt255	varchar(255)	Yes	Pricing Level Five Description	No
pri_level_1_lst_apprvd_amt	fin_amount	numeric(13)	Yes	Pricing Level First Approved Amount	No
pri_level_2_lst_apprvd_amt	fin_amount	numeric(13)	Yes	Pricing Level second Approved Amount	No
pri_level_3_lst_apprvd_amt	fin_amount	numeric(13)	Yes	Pricing Level Third Approved Amount	No
pri_level_4_lst_apprvd_amt	fin_amount	numeric(13)	Yes	Pricing Level Forth Approved Amount	No
pri_level_5_lst_apprvd_amt	fin_amount	numeric(13)	Yes	Pricing Level Fifth Approved Amount	No
pri_level_1_rev_amt	fin_amount	numeric(13)	Yes	Pricing Level One Revision Amount	No
pri_level_2_rev_amt	fin_amount	numeric(13)	Yes	Pricing Level Two Revision Amount	No
pri_level_3_rev_amt	fin_amount	numeric(13)	Yes	Pricing Level Third Revison Amount	No
pri_level_4_rev_amt	fin_amount	numeric(13)	Yes	Pricing Level Fourth Revision Amount	No
pri_level_5_rev_amt	fin_amount	numeric(13)	Yes	Pricing Level Fitth Revision Amount	No
pri_level_1_quote_amt	fin_amount	numeric(13)	Yes	Pricing Level One Quote Amount	No
pri_level_2_quote_amt	fin_amount	numeric(13)	Yes	Pricing Level Two Quote Amount	No
pri_level_3_quote_amt	fin_amount	numeric(13)	Yes	Pricing Level Third Quote Amount	No
pri_level_4_quote_amt	fin_amount	numeric(13)	Yes	Pricing Level Fourth Quote Amount	No
pri_level_5_quote_amt	fin_amount	numeric(13)	Yes	Pricing Level Fifth Quote Amount	No

Table Name :	salquot_quot_info_mst
Comment :	Sales Quotation Info Master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
quot_quot_no	fin_documentno	varchar(40)	No	Quotation No	Yes
quot_quot_rev_no	fin_rev_no	int(4)	No	Quotation Revision No	Yes
quot_ouinst_id	fin_ctxt_ouinstance	int(4)	No	Quotation Organization Unit Instance Id	Yes
timestamp	fin_int	int(4)	Yes	Quotation Time Stamp	No
quot_date	fin_date	datetime(8)	Yes	Quotation Date	No
quot_basis	fin_designparamcode	varchar(5)	Yes	Quotation Basis	No
quot_category	fin_quickcodes	varchar(25)	Yes	Quotation Category	No
quot_status	fin_designparamcode	varchar(5)	Yes	Quotation status	No
quot_currency	fin_currencycode	varchar(5)	Yes	Quotation Currency	No
quot_price_held_firm	fin_days	int(4)	Yes	Quotation Price Held Firm	No
quot_std_appr_lead_time	fin_days	int(4)	Yes	Quotation Standard Appear Lead Time	No
quot_cust_approval	fin_desc100	varchar(100)	Yes	Quotation Customer Approval	No
quot_desc	fin_desc100	varchar(100)	Yes	Quotation description	No
quot_user_status	fin_designparamcode	varchar(5)	Yes	Quotation User Stauts	No
quot_qtd_value	fin_amount	numeric(13)	Yes	Quotation Quoted Value	No
quot_remarks	fin_remark	varchar(100)	Yes	Quotation Remarks	No
quot_ci_cust_id	fin_documentno	varchar(40)	Yes	Quotation Ci Customer Id	No
quot_ci_contract_id	fin_documentno	varchar(40)	Yes	Quotation Ci Contract id	No
quot_ci_cust_ord_rev_no	fin_rev_no	int(4)	Yes	Quotation Ci Customer Order Revision no	No
quot_ci_cust_order_no	fin_documentno	varchar(40)	Yes	Quotation Ci Customer Order No	No
quot_ci_sale_type	fin_quickcodes	varchar(25)	Yes	Quotation ci Sale type	No
quot_ci_pricing_basis	fin_txt80	varchar(80)	Yes	Quotation Ci Pricing Basis	No
quot_ci_num_type	fin_notypeno	varchar(10)	Yes	Quotation Ci Number Type	No
quot_warenty_req	fin_designparamcode	varchar(5)	Yes	Quotation Warenty Request	No
quot_warenty_notes	fin_contextinfo	varchar(1024)	Yes	Quotation Warenty Notes	No
quot_warenty_res_exe	fin_desc100	varchar(100)	Yes	Quotation Warenty Resource Excutuion	No
quot_warenty_notes_exe	fin_contextinfo	varchar(1024)	Yes	Quotation Warenty Notes Excution	No
quot_warenty_res_sts	fin_designparamcode	varchar(5)	Yes	Quotation Warenty Resource Status	No
quot_ber	fin_designparamcode	varchar(5)	Yes	Quotation Ber	No
quot_ber_threshold_val	fin_amount	numeric(13)	Yes	Quotation Ber Threshold Value	No
quot_replacement_new	fin_amount	numeric(13)	Yes	Quotation Replacement New	No
quot_ber_comments	fin_comments	varchar(256)	Yes	Quotation Ber Comments	No
quot_core_disposition	fin_txt40	varchar(40)	Yes	Quotation Core Display Position	No
quot_hold_code	fin_quickcodes	varchar(25)	Yes	Quotation Hold Code	No
quot_cancelled_by	fin_ctxt_user	varchar(30)	Yes	Quotation Cancelled By	No
quot_cancelled_date	fin_date	datetime(8)	Yes	Quotation Cancelled date	No
quot_confirmed_by	fin_ctxt_user	varchar(30)	Yes	Quotation Confirmed By	No
quot_confirmed_date	fin_date	datetime(8)	Yes	Quotation Confirmed Date	No
quot_released_by	fin_ctxt_user	varchar(30)	Yes	Quotation Relesed by	No
quot_released_date	fin_date	datetime(8)	Yes	Quotation Relesed Date	No
quot_apprej_reason	fin_txt1024	varchar(1024)	Yes	Quotation Approvel Reject Reason	No
quot_approved_by	fin_ctxt_user	varchar(30)	Yes	Quotation Approved By	No
quot_approved_date	fin_date	datetime(8)	Yes	Quotation Approved Date	No
quot_rejected_by	fin_ctxt_user	varchar(30)	Yes	Quotation Rejected By	No
quot_rejected_date	fin_date	datetime(8)	Yes	Quotation Rejected Date	No
quot_created_by	fin_ctxt_user	varchar(30)	Yes	Quotation Created By	No
quot_created_date	fin_date	datetime(8)	Yes	Quotation Created Date	No
quot_modified_by	fin_ctxt_user	varchar(30)	Yes	Quotation Modified By	No
quot_modified_date	fin_date	datetime(8)	Yes	Quotation Modified Date	No
quot_approval_id	fin_documentno	varchar(40)	Yes	Quotation Approved Id	No
quot_cust_instructions	fin_txt255	varchar(255)	Yes	Quotation Customer Instructions	No
quot_basic_value	fin_amount	numeric(13)	Yes	Quotation basic Value	No
quot_tcd_amount	fin_amount	numeric(13)	Yes	Quotation Tcd Amount	No
quot_print_comments	fin_comments	varchar(256)	Yes	Quotation Print Comments	No
quot_TM_mat_price	fin_price	numeric(13)	Yes	Quotation Time and Manage Material Price	No
quot_TM_lab_price	fin_price	numeric(13)	Yes	Quotation Time and mange Labour Price	No
quot_TM_other_price	fin_price	numeric(13)	Yes	Quotation Time and Manage Other Price	No
quot_TM_ext_price	fin_price	numeric(13)	Yes	Quotation Time and External Price	No
quot_TM_chrg_price	fin_price	numeric(13)	Yes	Quotation Time and Manage Charge Price	No
quot_TM_total_price	fin_price	numeric(13)	Yes	Time and Manage Total Price	No
quot_FP_mat_price	fin_price	numeric(13)	Yes	Quotation Fixed Price Material Price	No
quot_FP_lab_price	fin_price	numeric(13)	Yes	Quotation Fixed Price Labour Price	No
quot_FP_ext_price	fin_price	numeric(13)	Yes	Quotation Fixed Price External Price	No
quot_FP_chrg_price	fin_price	numeric(13)	Yes	Quotation Fixed Price Charge Price	No
quot_FP_total_price	fin_price	numeric(13)	Yes	Quotation Fixed Price Total Price	No
quot_cust_rep	fin_documentno	varchar(40)	Yes	Quotation Customer rep	No
quot_material_price	fin_price	numeric(13)	Yes	Quotation Material Price	No
quot_labour_price	fin_price	numeric(13)	Yes	Quotation Labour Price	No
quot_other_res_price	fin_price	numeric(13)	Yes	Quotation Other Resources Price	No
quot_ext_repair_price	fin_price	numeric(13)	Yes	Quotation External repairs Price	No
quot_service_purchase	fin_price	numeric(13)	Yes	Quotation Service Purchase	No
quot_add_charges	fin_price	numeric(13)	Yes	Quotation Additional Charges	No
prev_quot_status	fin_designparamcode	varchar(5)	Yes	prev_quot_status	No
quot_dir_tot_price	fin_price	numeric(13)	Yes	quot_dir_tot_price	No
quot_external_RO_price	fin_price	numeric(13)	Yes	quot_external_RO_price	No
quot_external_PO_price	fin_price	numeric(13)	Yes	quot_external_PO_price	No
quot_hold_instid	fin_tasktrackid	bigint(8)	Yes	quot_hold_instid	No
quot_erate_basecurr	fin_exchangerate	numeric(9)	Yes	Excahnge rate from Co currency to Base currecy	No
quot_totval_basecurr	fin_price	numeric(13)	Yes	Total value in base currecy	No
quot_auth_stage	fin_status	varchar(25)	Yes	Quoute Authorisation Stage	No
quot_doc_key	fin_wfdockey	Char(128)	Yes	Document Key	No
quot_returned_by	fin_ctxt_user	varchar(30)	Yes	Returned By	No
quot_returned_date	fin_date	datetime(8)	Yes	Returned Date	No
quote_cost	fin_amount	numeric(13)	Yes	Quotation Cost	No
quot_unbilled_amt	fin_amount	numeric(13)	Yes	Unbilled Amount	No
quote_prt_qty	fin_txt255	varchar(255)	Yes	Part Quantity	No

Table Name :	salquot_resource_pricing_dtl
Comment :	Sales Quotation of Resource Pricing Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
res_quot_no	fin_documentno	varchar(40)	No	Resource Quotation No	Yes
res_quot_rev_no	fin_rev_no	int(4)	No	Resource Quotation Revision No	Yes
res_quote_line_no	fin_lineno	int(4)	No	Resource Quotation Line No	Yes
res_ouinst_id	fin_ctxt_ouinstance	int(4)	No	Resource Organization Unit Instance Id	Yes
res_line_id	fin_lineno	int(4)	No	Resource Line Id	Yes
timestamp	fin_int	int(4)	Yes	Resource Time Stamp	No
res_quote_indicator	fin_paramdesc	varchar(30)	Yes	Resource Quotation Indicator	No
res_caps	fin_desc40	varchar(40)	Yes	Resource Caps	No
res_resource_type	fin_resourcetype	varchar(25)	Yes	Resource Type	No
res_resource_id	fin_resourcecode	varchar(40)	Yes	Resource id	No
res_work_center	fin_workcenter	varchar(80)	Yes	Resource work Center	No
res_aircraft_model	fin_aircraftmodel	varchar(20)	Yes	Resource Aircraft Model	No
res_quoted_qty	fin_quantity	numeric(17)	Yes	Resource Quoted Qty	No
res_uom	fin_uom	varchar(15)	Yes	Resource Unit of Measurement	No
res_unit_rate	fin_rate	numeric(13)	Yes	Resource Unit Rate	No
res_quoted_qty_capped	fin_amount	numeric(13)	Yes	Resource Quoted qty Capped	No
res_ext_price	fin_amount	numeric(13)	Yes	Resource External Price	No
res_capped_ext_price	fin_amount	numeric(13)	Yes	Resource Capped External Price	No
res_final_price	fin_amount	numeric(13)	Yes	Resource Final Price	No
res_price_disposition	fin_Disposition	varchar(40)	Yes	Resource Price Display Position	No
res_remarks	fin_remarks	varchar(100)	Yes	Resource Remarks	No
res_est_remarks	fin_remarks	varchar(100)	Yes	Resource Estimation Remarks	No
res_sys_billable	fin_designparamcode	varchar(5)	Yes	Resource system Billable	No
res_coa	fin_designparamcode	varchar(5)	Yes	Resource COA	No
res_billable	fin_designparamcode	varchar(5)	Yes	Resource Billable	No
res_warenty_reco	fin_designparamcode	varchar(5)	Yes	Resource Warenty Reco	No
res_price_narration	fin_comments	varchar(256)	Yes	Resource Price Narration	No
res_internal_notes	fin_contextinfo	varchar(1024)	Yes	Resource Internal Notes	No
res_service_pricelist	fin_documentno	varchar(40)	Yes	Resource Service Price List	No
res_service_pricelist_rev	fin_revision	varchar(10)	Yes	Resource Service Price List Revision	No
res_pricing_description	fin_partdesc	varchar(150)	Yes	Resource Pricing Description	No
res_pricing_qty	fin_quantity	numeric(17)	Yes	Resource Pricing Qty	No
res_pricing_unit_rate	fin_rate	numeric(13)	Yes	Resource Pricing Unit Rate	No
res_pricing_price	fin_amount	numeric(13)	Yes	Resource Pricing Price	No
res_pricing_coa	fin_designparamcode	varchar(5)	Yes	Resource Pricing COA	No
res_pricing_warenty_reco	fin_designparamcode	varchar(5)	Yes	Resource Pricing Warenty Reco	No
res_created_by	fin_ctxt_user	varchar(30)	Yes	Resource Created By	No
res_created_date	fin_date	datetime(8)	Yes	Resource Created Date	No
res_modified_by	fin_ctxt_user	varchar(30)	Yes	Resource Modified By	No
res_modified_date	fin_date	datetime(8)	Yes	Resource Modified Date	No
res_pricing_basis	fin_quickcodes	varchar(25)	Yes	Resource Pricing Basis	No
res_cap_flag	fin_designparamcode	varchar(5)	Yes	Resource Cap Flag	No
res_pricing_ovrate_perhr	fin_amount	numeric(13)	Yes	Resource Pricing Over rate Per Hour	No
res_pricing_method	fin_designparamcode	varchar(5)	Yes	Resource Pricing Method	No
res_pricing_price_cocurr	fin_amount	numeric(13)	Yes	Resource Pricing Preice Co Currency	No
res_pricing_price_splcurr	fin_amount	numeric(13)	Yes	Resource Pricing Price Special Currency	No
res_pricing_priceperhr_splcurr	fin_currencycode	varchar(5)	Yes	Resource Pricing Price per Hour Spacial Currency	No
res_pricing_exchrate_date	fin_date	datetime(8)	Yes	Resource Pricing Exchange Rate Date	No
res_pricing_hours_flag	fin_designparamcode	varchar(5)	Yes	Resource Pricing Hours Flag	No
res_pricing_spl_ou	fin_ctxt_ouinstance	int(4)	Yes	Resource Pricing Spacial Organization Unit	No
res_pricing_spl_lineno	fin_int	int(4)	Yes	Resource Pricing Spacial Line No	No
res_pricing_notes	fin_notes	varchar(2000)	Yes	Resource Pricing Notes	No
res_ref_cur	fin_currencycode	varchar(5)	Yes	Resource Reference Currency	No
res_exch_rate	fin_exchangerate	numeric(9)	Yes	Resource Exchange Rate	No
res_repair_classification	fin_repairclassification	varchar(25)	Yes	Resource Repair Classification	No
res_inc_exc_ref_cd	fin_effectivitycode	varchar(40)	Yes	Resource Inclusive exclusive Reference Code	No
res_tsk_ref_date	fin_date	datetime(8)	Yes	Resource task reference Date	No
res_lastupdate_log	fin_contextinfo	varchar(1024)	Yes	Resource Last Update Log	No
res_desc	fin_description	varchar(100)	Yes	Resource description	No
res_hrs_source	fin_designparamcode	varchar(5)	Yes	Resource Hrs Source	No
res_covered_qty	fin_quantity	numeric(17)	Yes	Resource Covered Quantity	No
res_final_qty	fin_quantity	numeric(17)	Yes	Resource Final Quantity	No
res_unit_rate_co_cur	fin_amount	numeric(13)	Yes	Resource CO Currency Unit Rate	No
res_covered_price	fin_amount	numeric(13)	Yes	Resource Covered Price	No
res_adj_ext_price	fin_amount	numeric(13)	Yes	Resource Adj. Ext. Price	No
res_pricing_source	fin_type	varchar(25)	Yes	Resource Pricing Source	No
res_modification_nts	fin_contextinfo	varchar(1024)	Yes	Resource Modification Notes	No
res_warranty_res	fin_designparamcode	varchar(5)	Yes	Resource Warranty Resolution	No
res_act_qty	fin_quantity	numeric(17)	Yes	res_act_qty	No
res_adj_qty	fin_quantity	numeric(17)	Yes	res_adj_qty	No
res_fin_ext_price	fin_amount	numeric(13)	Yes	res_fin_ext_price	No
res_max_qty	fin_quantity	numeric(17)	Yes	res_max_qty	No
res_max_ext_price	fin_amount	numeric(13)	Yes	res_max_ext_price	No
res_seq_no	fin_seqno	int(4)	Yes	res_seq_no	No
res_baserate_nm	fin_amount	numeric(13)	Yes	baserate normal	No
res_baserate_ot	fin_amount	numeric(13)	Yes	baserate Over time	No
res_price_fact	fin_amount	numeric(13)	Yes	Price Factor	No
res_mrkp_nm	fin_amount	numeric(13)	Yes	Markup nomal	No
res_mrup_ot	fin_amount	numeric(13)	Yes	Markup Overtime	No
res_ext_markup	fin_amount	numeric(13)	Yes	Ecternal Markup	No
res_unit_markup	fin_amount	numeric(13)	Yes	Unit Markup	No
res_baserate	fin_amount	numeric(13)	Yes	Base Rate	No
res_rel_no	fin_rev_no	int(4)	Yes	Release Number	No
res_invoiced	fin_flag	varchar(25)	Yes	Invoiced	No

Table Name :	salquot_rooster_dtl
Comment :	Sales Quotation of rooster details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ros_quot_no	fin_documentno	varchar(40)	No	Rooster Quotation No	Yes
ros_quot_rev_no	fin_rev_no	int(4)	No	Rooster Quotation Revision No	Yes
ros_quote_line_no	fin_lineno	int(4)	No	Rooster Quotation Line No	Yes
ros_ouinst_id	fin_ctxt_ouinstance	int(4)	No	Rooster Organization unit Instant Id	Yes
ros_line_id	fin_lineno	int(4)	No	Rooster Line id	Yes
ros_roster_code	fin_quickcode	varchar(20)	Yes	Rooster Code	No
timestamp	fin_int	int(4)	Yes	Rooster time Stamp	No
ros_roster_code_basis	fin_quickcode	varchar(20)	Yes	Rooster Code Basis	No
ros_element	fin_designparamcode	varchar(5)	Yes	Rooster Element	No
ros_from_time	fin_datetime	datetime(8)	Yes	Rooster From Time	No
ros_to_time	fin_datetime	datetime(8)	Yes	Rooster To Time	No
ros_roster_remarks	fin_remarks	varchar(100)	Yes	Rooster Remarks	No
ros_created_by	fin_ctxt_user	varchar(30)	Yes	Rooster Created By	No
ros_created_date	fin_date	datetime(8)	Yes	Rooster Created Date	No
ros_modified_by	fin_ctxt_user	varchar(30)	Yes	Rooster Modified By	No
ros_modified_date	fin_date	datetime(8)	Yes	Rooster Modified Date	No

Table Name :	SalQuot_Task_Coa_flip
Comment :	SalQuot_Task_Coa_flip

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
task_line_no	fin_rev_no	int(4)	No	tsk_line_no	Yes
task_quot_no	fin_documentno	varchar(40)	No	tsk_quot_no	No
task_quot_rev_no	fin_rev_no	int(4)	No	tsk_quot_rev_no	No
task_ouinst_id	fin_ctxt_ouinstance	int(4)	No	tsk_ouinst_id	No
task_timestamp	fin_timestamp	int(4)	Yes	timestamp	No
task_quote_line_no	fin_lineno	int(4)	Yes	tsk_quote_line_no	No
task_task_no	fin_taskcode	varchar(30)	Yes	tsk_task_no	No
task_pricing_task	fin_taskcode	varchar(30)	Yes	tsk_pricing_task	No
task_task_track_id	fin_documentno	varchar(40)	Yes	tsk_task_track_id	No
task_old_coa	fin_designparamcode	varchar(5)	Yes	tsk_old_coa	No
task_new_coa	fin_designparamcode	varchar(5)	Yes	tsk_new_coa	No
task_processe_id	fin_documentno	varchar(40)	Yes	tsk_processe_id	No
task_sub_process_id	fin_documentno	varchar(40)	Yes	tsk_sub_process_id	No
task_tm_materials_flag	fin_checkflag	int(4)	Yes	tsk_tm_materials_flag	No
task_tm_labours_flag	fin_checkflag	int(4)	Yes	tsk_tm_labours_flag	No
task_tm_others_flag	fin_checkflag	int(4)	Yes	tsk_tm_others_flag	No
task_fp_materials_flag	fin_checkflag	int(4)	Yes	tsk_fp_materials_flag	No
task_fp_labours_flag	fin_checkflag	int(4)	Yes	tsk_fp_labours_flag	No
task_fp_others_flag	fin_checkflag	int(4)	Yes	tsk_fp_others_flag	No
task_pricing_basis	fin_documentno	varchar(40)	Yes	tsk_pricing_basis	No
task_new_matpb	fin_documentno	varchar(40)	Yes	tsk_new_matpb	No
task_new_respb	fin_documentno	varchar(40)	Yes	tsk_new_respb	No
task_new_othpb	fin_documentno	varchar(40)	Yes	tsk_new_othpb	No
task_old_matpb	fin_documentno	varchar(40)	Yes	tsk_old_matpb	No
task_old_respb	fin_documentno	varchar(40)	Yes	tsk_old_respb	No
task_old_othpb	fin_documentno	varchar(40)	Yes	tsk_old_othpb	No
task_doc_no	fin_documentno	varchar(40)	Yes	tsk_doc_no	No
task_doc_type	fin_doctype	varchar(40)	Yes	tsk_doc_type	No
task_doc_old_pb	fin_documentno	varchar(40)	Yes	tsk_doc_old_pb	No
task_doc_new_pb	fin_documentno	varchar(40)	Yes	tsk_doc_new_pb	No
task_created_date	fin_date	datetime(8)	Yes	tsk_created_date	No
task_created_by	ctxt_user	varchar(30)	Yes	tsk_created_by	No

Table Name :	salquot_task_dtl
Comment :	Sales Quotation of task details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tsk_quot_no	fin_documentno	varchar(40)	No	Task Quotation No	Yes
tsk_quot_rev_no	fin_rev_no	int(4)	No	Task Quotation Revision No	Yes
tsk_quote_line_no	fin_lineno	int(4)	No	Task Quotation Line No	Yes
tsk_ouinst_id	fin_ctxt_ouinstance	int(4)	No	Task organization Unit Instance Id	Yes
timestamp	fin_int	int(4)	No	Task Time Stamp	Yes
tsk_quote_indicator	fin_desc40	varchar(40)	Yes	Task Quote Indicatior	No
tsk_rev_reference	fin_txt40	varchar(40)	Yes	Task Revision Reference	No
tsk_task_no	fin_taskcode	varchar(30)	Yes	Task No	No
tsk_task_track_id	fin_documentno	varchar(40)	Yes	Task Track Id	No
tsk_wbs_code	fin_quickcodes	varchar(25)	Yes	Task WBS Code	No
tsk_total_price	fin_amount	numeric(13)	Yes	Task Total Price	No
tsk_final_price	fin_amount	numeric(13)	Yes	Task Final Price	No
tsk_primary_task_no	fin_taskcode	varchar(30)	Yes	Task Primary Task No	No
tsk_remarks	fin_comments	varchar(256)	Yes	Task Remarks	No
tsk_coa	fin_designparamcode	varchar(5)	Yes	Task COA	No
tsk_billable	fin_designparamcode	varchar(5)	Yes	Task Billable	No
tsk_warranty_reco	fin_designparamcode	varchar(5)	Yes	Task Warranty Reco	No
tsk_action	fin_designparamcode	varchar(5)	Yes	Task Action	No
tsk_action_remarks	fin_comments	varchar(256)	Yes	Task Action Remarks	No
tsk_pricenarrarion	fin_comments	varchar(256)	Yes	Task Price Narration	No
tsk_internalnotes	fin_contextinfo	varchar(1024)	Yes	Task Internal Notes	No
tsk_lastupdatedlog	fin_contextinfo	varchar(1024)	Yes	Task Updated Log	No
tsk_approval_status	fin_designparamcode	varchar(5)	Yes	Task Approval Status	No
tsk_qoute_count	fin_count	int(4)	Yes	Task Quote Count	No
tsk_hold_code	fin_quickcode	varchar(20)	Yes	Task Hold Code	No
tsk_work_enum	fin_notes	varchar(2000)	Yes	Task Work Emumber	No
tsk_material_price	fin_amount	numeric(13)	Yes	Task Material Price	No
tsk_labour_price	fin_amount	numeric(13)	Yes	Task Labour Price	No
tsk_other_res_price	fin_amount	numeric(13)	Yes	Task Other Resource Price	No
tsk_external_repair	fin_amount	numeric(13)	Yes	Task External Repair	No
tsk_service_purchases	fin_amount	numeric(13)	Yes	Task Service Purchases	No
tsk_task_add_charges	fin_amount	numeric(13)	Yes	Task Add Charges	No
tsk_quote_level_task	fin_designparamcode	varchar(5)	Yes	Task Quote Level Task	No
tsk_processe_id	fin_documentno	varchar(40)	Yes	Task Process Id	No
tsk_sub_process_id	fin_documentno	varchar(40)	Yes	Task Sub Process Id	No
tsk_exec_doc_no	fin_documentno	varchar(40)	Yes	Task Execution Document No	No
tsk_exec_doc_line_no	fin_lineno	int(4)	Yes	Task Execution Document Line No	No
tsk_parent_workorder_no	fin_documentno	varchar(40)	Yes	Task Parent Work Order No	No
tsk_tm_materials_flag	fin_checkflag	int(4)	Yes	Task TM Materials Flag	No
tsk_tm_labours_flag	fin_checkflag	int(4)	Yes	Task TM Labours Flag	No
tsk_tm_others_flag	fin_checkflag	int(4)	Yes	Task TM Others Flag	No
tsk_fp_materials_flag	fin_checkflag	int(4)	Yes	Task Fixed Price Materials Flag	No
tsk_fp_labours_flag	fin_checkflag	int(4)	Yes	Task Fixed Price Labours Flag	No
tsk_fp_others_flag	fin_checkflag	int(4)	Yes	Task Fixed Price Others Flag	No
tsk_tm_material_amount	fin_amount	numeric(13)	Yes	Task TM Material Amount	No
tsk_tm_labours_amount	fin_amount	numeric(13)	Yes	Task TM Labours Amount	No
tsk_tm_others_charges	fin_amount	numeric(13)	Yes	Task TM Others Charges	No
tsk_fp_material_amount	fin_amount	numeric(13)	Yes	Task Fixed Price Materials Amount	No
tsk_fp_labour_amount	fin_amount	numeric(13)	Yes	Task Fixed Price Labours Amount	No
tsk_fp_charges	fin_amount	numeric(13)	Yes	Task Fixed Price Charges	No
tsk_part_id	fin_partno	varchar(40)	Yes	Task Part Id	No
tsk_mfr_id	fin_partno	varchar(40)	Yes	Task Manufactor Id	No
tsk_mfr_part_id	fin_partno	varchar(40)	Yes	Task Manufactor part Id	No
tsk_part_serial_lot_id	fin_partserialnumber	varchar(40)	Yes	Task Part Serial Lot Id	No
tsk_estimated_remarks	fin_remarks	varchar(100)	Yes	Task Estimated Remarks	No
tsk_sys_billable	fin_designparamcode	varchar(5)	Yes	Task System Billable	No
tsk_repair_classification	fin_repairclassification	varchar(25)	Yes	Task Repair Classification	No
tsk_created_by	fin_ctxt_user	varchar(30)	Yes	Task Created By	No
tsk_created_date	fin_date	datetime(8)	Yes	Task Created Date	No
tsk_modified_by	fin_ctxt_user	varchar(30)	Yes	Task Modified By	No
tsk_modified_date	fin_date	datetime(8)	Yes	Task Modified Date	No
tsk_repairprocess_code	fin_repairprocesscode	varchar(25)	Yes	Task Repair Process Code	No
tsk_aircraft_reg_id	fin_aircraftnumber	varchar(30)	Yes	Task Aircraft Register Id	No
tsk_disposition	fin_Disposition	varchar(40)	Yes	Task Display Position	No
tsk_price_disposition	fin_Disposition	varchar(40)	Yes	Task Price Display Posistion	No
tsk_pricing_basis	fin_quickcodes	varchar(25)	Yes	Task Pricing Basis	No
tsk_pricing_task	fin_taskcode	varchar(30)	Yes	Task Pricing Task	No
tsk_coverage	fin_paramdesc	varchar(30)	Yes	Task coverage	No
tsk_pricing_tm_material_amount	fin_amount	numeric(13)	Yes	Task original TM Material Amount	No
tsk_pricing_tm_labours_amount	fin_amount	numeric(13)	Yes	Task original TM Labours Amount	No
tsk_pricing_tm_other_charges	fin_amount	numeric(13)	Yes	Task original TM Other Charges	No
tsk_pricing_fp_material_amount	fin_amount	numeric(13)	Yes	Task original Fixed Price Material Amount	No
tsk_pricing_fp_labour_amount	fin_amount	numeric(13)	Yes	Task original Fixed Price Labour Amount	No
tsk_pricing_fp_charges	fin_amount	numeric(13)	Yes	Task original Fixed Price Charges	No
tsk_pricing_warenty_tm	fin_designparamcode	varchar(5)	Yes	Task original TM warenty	No
tsk_pricing_coa_tm	fin_designparamcode	varchar(5)	Yes	Task Pricing COA TM	No
tsk_task_sequence_no	fin_lineno	int(4)	Yes	Task Sequence No	No
tsk_part_desc	fin_partdesc	varchar(150)	Yes	Task Part Description	No
tsk_task_desc	fin_taskdesc	varchar(150)	Yes	Task description	No
tsk_primary_task_desc	fin_taskdesc	varchar(150)	Yes	Task Primary Task Description	No
tsk_task_type	fin_tasktype	varchar(25)	Yes	Task type	No
tsk_org_mat_pricingbasis	fin_quickcodes	varchar(25)	Yes	Task original Material Pricing Basis	No
tsk_org_lab_pricingbasis	fin_quickcodes	varchar(25)	Yes	Task original Labour Pricing Basis	No
tsk_org_oth_pricingbasis	fin_quickcodes	varchar(25)	Yes	Task original Other Pricing Basis	No
tsk_org_mat_excl_pricingbasis	fin_quickcodes	varchar(25)	Yes	Task original Material Exclusive Pricing Basis	No
tsk_org_lab_excl_pricingbasis	fin_quickcodes	varchar(25)	Yes	Task original Labour Exclusive Pricing Basis	No
tsk_org_oth_excl_pricingbasis	fin_quickcodes	varchar(25)	Yes	Task original Other Exclusive Pricing Basis	No
tsk_fp_total_price	fin_amount	numeric(13)	Yes	Task Fixed Price Total Price	No
tsk_fp_defnfor	fin_enum	varchar(40)	Yes	Task Fixed Price Defin for	No
tsk_prev_approval_status	fin_designparamcode	varchar(5)	Yes	Task Previous Approval Status	No
tsk_wbs_level	fin_quickcodes	varchar(25)	Yes	Task WBS Level	No
tsk_work_center	fin_workcenter	varchar(80)	Yes	Task Work Center	No
tsk_fp_pricing_notes	fin_notes	varchar(2000)	Yes	Task Fixed Price Pricing Notes	No
tsk_NE_total_price	fin_amount	numeric(13)	Yes	Task NE Total Price	No
tsk_exec_doc_type	fin_type	varchar(25)	Yes	Task Executive Document Type	No
tsk_cust_hold_code	fin_quickcodes	varchar(25)	Yes	Task Customer Hold code	No
tsk_hold_inst_id	fin_tasktrackid	bigint(8)	Yes	Task hold Instance Id	No
tsk_app_rej_holdinstid	fin_tasktrackid	bigint(8)	Yes	Task Approve Reject Hold Instance Id	No
tsk_work_scope_code	fin_effectivitycode	varchar(40)	Yes	Task Work Scope Code	No
tsk_inclusion_code	fin_effectivitycode	varchar(40)	Yes	Task inclusion Code	No
tsk_exclusion_code	fin_effectivitycode	varchar(40)	Yes	Task Exclusion Code	No
tsk_ATA_no	fin_documentno	varchar(40)	Yes	Task ATA No	No
tsk_tm_oth_res_amount	fin_amount	numeric(13)	Yes	Task TM Other Resources Amount	No
tsk_modification_nts	fin_contextinfo	varchar(1024)	Yes	Task Modification Notes	No
tsk_pricing_nts	fin_notes	varchar(2000)	Yes	Task Pricing Notes	No
tsk_pricing_task_desc	fin_taskdesc	varchar(150)	Yes	Task Pricing Task Description	No
tsk_qt_doc_type	fin_type	varchar(25)	Yes	Task Quoted Document Type	No
tsk_qt_doc_no	fin_documentno	varchar(40)	Yes	Task Quoted Document No	No
tsk_warranty_res	fin_designparamcode	varchar(5)	Yes	Task Warranty Resolution	No
tsk_fp_pricing_source	fin_type	varchar(25)	Yes	Task FP Pricing Source	No
tsk_hierarchy_id	hierarchyid	varchar(892)	Yes	Task Hierarchy Id	No
tsk_doc_curr	fin_currencycode	varchar(5)	Yes	Doc. Currency	No
tsk_doc_status	fin_status	varchar(25)	Yes	Doc. Status	No
tsk_exch_init_as	fin_enum_cd	varchar(5)	Yes	Exchange Initiated as	No
tsk_exchange_entity	fin_enum_cd	varchar(5)	Yes	Exchange Entity	No
tsk_exchrate_cocurr	fin_exchangerate	numeric(9)	Yes	Exchange Co.Currency	No
tsk_exch_sub_type	fin_type	varchar(25)	Yes	Exchange Sub-type	No
tsk_exch_type	fin_type	varchar(25)	Yes	Exchange Type	No
tsk_excl_line_no	fin_effectivitycode	varchar(40)	Yes	Excl. line no	No
tsk_excl_notes	fin_notes	varchar(2000)	Yes	Excl. notes	No
tsk_reason_Exch	fin_remarks	varchar(100)	Yes	Reason for Exchange	No
tsk_doc_no	fin_documentno	varchar(40)	Yes	Document no	No
tsk_doc_type	fin_type	varchar(25)	Yes	Document type	No
tsk_work_scope_notes	fin_notes	varchar(2000)	Yes	fin_notes	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_exch_pric_basis	fin_enum_cd	varchar(5)	Yes	tsk_exch_pric_basis	No
tsk_prim_work_center	fin_workcenter	varchar(80)	Yes	tsk_prim_work_center	No
tsk_coa_exists	fin_flag	varchar(25)	Yes	tsk_coa_exists	No
tsk_await_est	fin_enum_cd	varchar(5)	Yes	tsk_await_est	No
tsk_pend_est_inst_id	fin_seqno	int(4)	Yes	tsk_pend_est_inst_id	No
tsk_fp_cnt_rev_no	fin_revno	varchar(3)	Yes	latest contract revision# for fixed price	No
tsk_pricing_tm_oth_res_amount	fin_price	numeric(13)	Yes	tsk original tm_oth_res_price	No
tsk_pricing_fp_total	fin_price	numeric(13)	Yes	tsk original fp_total_price	No
tsk_invoiced	fin_flag	varchar(25)	Yes	Invoiced flag	No
tsk_releaseno	fin_flag	varchar(25)	Yes	release #	No

Table Name :	salquot_task_fp_dtl
Comment :	Sales Quotation of task fp details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tsk_fp_quot_no	fin_documentno	varchar(40)	No	Task Fixed Price Quotation No	Yes
tsk_fp_quot_rev_no	fin_rev_no	int(4)	No	Task Fixed Price Quotation Revision No	Yes
tsk_fp_quote_line_no	fin_lineno	int(4)	No	Task Fixed Price Quotation Line No	Yes
tsk_fp_ouinst_id	fin_ctxt_ouinstance	int(4)	No	Task Fixed Price Organization Unit Instanct Id	Yes
tsk_fp_task_no	fin_taskno	varchar(40)	Yes	Task Fixed Price task No	No
tsk_fp_part_no	fin_partno	varchar(40)	Yes	Task Fixed Price Part No	No
tsk_fp_pricing_notes	fin_notes	varchar(2000)	Yes	Task Fixed Price Pricing Notes	No
tsk_fp_pricing_disposition	fin_notes	varchar(2000)	Yes	Task Fixed Price Pricing Display Position	No
tsk_fp_fixprice_defnfor	fin_enum	varchar(40)	Yes	Task Fixed Price Fix Price Defin For	No
tsk_fp_erate_cnt_co_curr	fin_exchangerate	numeric(9)	Yes	Task Fixed Price Exchange Rate Cnt Co Currency	No
tsk_fp_mat_price	fin_price	numeric(13)	Yes	Task Fixed Price Material Price	No
tsk_fp_lab_price	fin_price	numeric(13)	Yes	Task Fixed Price Labour Price	No
tsk_fp_oth_resprice	fin_price	numeric(13)	Yes	Task Fixed Price Other Resource Price	No
tsk_fp_tot_fixprice	fin_price	numeric(13)	Yes	Task Fixed Price Total Fix Price	No
tsk_fp_pricing_basis	fin_quickcodes	varchar(25)	Yes	Task Fixed Price Pricing Basis	No
tsk_effectivity_code	fin_effectivitycode	varchar(40)	Yes	Task Fixed Price Effectivity Code	No
tsk_work_scope_code	fin_quickcodes	varchar(25)	Yes	Task Fixed Price Work Scope Code	No
tsk_inclusion_code	fin_effectivitycode	varchar(40)	Yes	Task Fixed Price Inclusion Code	No
tsk_exclusion_code	fin_effectivitycode	varchar(40)	Yes	Task Fixed Price Exclusion Code	No
tsk_work_scope_notes	fin_notes	varchar(2000)	Yes	Task_work_scope_notes	No

Table Name :	salquot_tcd_app_dtl
Comment :	Tcd apportion

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tsk_quot_no	fin_documentno	varchar(40)	No	tsk_quot_no	Yes
tsk_quot_rev_no	fin_rev_no	int(4)	No	tsk_quot_rev_no	Yes
tsk_quote_line_no	fin_lineno	int(4)	No	tsk_quote_line_no	Yes
tsk_ouinst_id	fin_ctxt_ouinstance	int(4)	No	tsk_ouinst_id	Yes
tcd_code	fin_documentno	varchar(40)	Yes	tcd_code	No
tcd_var	fin_documentno	varchar(40)	Yes	tcd_var	No
tcd_trackid	fin_documentno	varchar(40)	Yes	tcd_trackid	No
tcd_tcdline_amt	fin_amount	numeric(13)	Yes	tcd_tcdline_amt	No
tcd_app_amt	fin_amount	numeric(13)	Yes	tcd_app_amt	No
tcd_tsk_amt	fin_amount	numeric(13)	Yes	tcd_tsk_amt	No
tcd_lineno	fin_lineno	int(4)	No	tcd_lineno	Yes
task_lineno	fin_amount	numeric(13)	No	task_lineno	Yes

Table Name :	salquot_tcd_dtl
Comment :	Sales Quotation of tcd details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tcd_quot_no	fin_documentno	varchar(40)	No	TCD Quotation No	Yes
tcd_quot_rev_no	fin_rev_no	int(4)	No	TCD Quotation Revision No	Yes
tcd_ouinst_id	fin_ctxt_ouinstance	int(4)	No	TCD Organization Unit Instant ID	Yes
tcd_line_no	fin_lineno	int(4)	No	TCD Line No	Yes
timestamp	fin_int	int(4)	Yes	TCD TIME STAMP	No
tcd_quote_indicator	fin_desc40	varchar(40)	Yes	TCD Quote Indicator	No
tcd_code	fin_itemtcd	varchar(40)	Yes	TCD Code	No
tcd_variance_id	fin_itemtcd	varchar(40)	Yes	TCD Variance 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_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 To 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 Created 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
tcd_basis	fin_tcdbasis	varchar(15)	Yes	TCD Basis	No
tcd_tcdcodedesc	fin_tcddesc	varchar(225)	Yes	TCD Tcd Code Descriprion	No
tcd_tcdtype	fin_tcdtype	varchar(10)	Yes	TCD Type	No
tcd_invoiced	fin_documentno	varchar(40)	Yes	invoiced flag	No