| Data Dictionary - Customer Order Management | ||||||||
| Table Name comgt_cucrsp_dtl | ||||||||
| Table Comment This table is used to store Customer Correspondence details for a customer order | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| cucrsp_order_ou | int | NOT NULL | order ou instance | Yes | No | |||
| cucrsp_order_no | varchar(40) | NOT NULL | order number | Yes | No | |||
| cucrsp_amend_no | int | NOT NULL | amendment number | Yes | No | |||
| cucrsp_refno | int | NOT NULL | Line number | Yes | No | |||
| cucrsp_dateml | date | NULL | Date | No | No | |||
| cucrsp_cusremrks | varchar(255) | NULL | customer remarks | No | No | |||
| cucrsp_oprremrks | varchar(255) | NULL | Operator Remarks | No | No | |||
| cucrsp_splinst | varchar(255) | NULL | Special Instructions | No | No | |||
| cucrsp_contprson | varchar(80) | NULL | Contact person | No | No | |||
| cucrsp_phone | char(15) | NULL | Contact Phone | No | No | |||
| cucrsp_crscat | varchar(5) | NULL | Correspondence category | No | No | |||
| cucrsp_crssts | varchar(5) | NULL | Correspondence Status | No | No | |||
| cucrsp_reference | char(255) | NULL | Referrence | No | No | |||
| cucrsp_attendby | varchar(80) | NULL | Attended By | No | No | |||
| cucrsp_timestamp | int | NULL | Timestamp count | No | No | |||
| cucrsp_created_by | varchar(30) | NULL | record created by | No | No | |||
| cucrsp_created_date | datetime | NULL | record created Date | No | No | |||
| cucrsp_modified_by | varchar(30) | NULL | record Modified by | No | No | |||
| cucrsp_modified_date | datetime | NULL | record Modified Date | No | No | |||
| Table Name Comgt_Cucrsp_His | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| CUCRSP_HIS_ORDER_OU | int | NOT NULL | Store the Instance | Yes | No | |||
| CUCRSP_HIS_ORDER_NO | varchar(40) | NOT NULL | To store the Customer order no | Yes | No | |||
| CUCRSP_HIS_AMEND_NO | int | NOT NULL | STore the amend# of the customer order no | Yes | No | |||
| CUCRSP_HIS_REFNO | int | NOT NULL | reference lineno to identify the multi information for the same customer order | Yes | No | |||
| CUCRSP_HIS_DATEML | date | NULL | Date | No | No | |||
| CUCRSP_HIS_CUSREMRKS | varchar(255) | NULL | Customer Remarks | No | No | |||
| CUCRSP_HIS_OPRREMRKS | varchar(255) | NULL | Operator Remarks | No | No | |||
| CUCRSP_HIS_SPLINST | varchar(255) | NULL | Special information | No | No | |||
| CUCRSP_HIS_CONTPRSON | varchar(80) | NULL | Contact person | No | No | |||
| CUCRSP_HIS_PHONE | char(15) | NULL | Phone no of the contact person | No | No | |||
| CUCRSP_HIS_CRSCAT | varchar(5) | NULL | Correspondance Category | No | No | |||
| CUCRSP_HIS_CRSSTS | varchar(5) | NULL | Correspondance Status | No | No | |||
| CUCRSP_HIS_REFERENCE | char(255) | NULL | Reference | No | No | |||
| CUCRSP_HIS_ATTENDBY | varchar(80) | NULL | Attended by | No | No | |||
| CUCRSP_HIS_TIMESTAMP | int | NULL | Timestamp | No | No | |||
| CUCRSP_HIS_CREATED_BY | varchar(30) | NULL | Created user name | No | No | |||
| CUCRSP_HIS_CREATED_DATE | datetime | NULL | Created Date | No | No | |||
| CUCRSP_HIS_MODIFIED_BY | varchar(30) | NULL | Modified User name | No | No | |||
| CUCRSP_HIS_MODIFIED_DATE | datetime | NULL | Modified Date | No | No | |||
| Table Name comgt_parameter_details | ||||||||
| Table Comment To store the parameter details of the customer order | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| componentname | varchar(20) | NOT NULL | component name | Yes | No | |||
| paramcategory | varchar(10) | NOT NULL | category | Yes | No | |||
| paramtype | varchar(25) | NOT NULL | type | Yes | No | |||
| paramcode | varchar(5) | NOT NULL | code | Yes | No | |||
| langid | int | NOT NULL | languge id | Yes | No | |||
| paramdesc | varchar(254) | NOT NULL | param description | No | No | |||
| sortby | int | NOT NULL | sort by | No | No | |||
| creationdate | datetime | NOT NULL | creation date | No | No | |||
| Table Name corm_ad_addlncharge_dtl | ||||||||
| Table Comment This table is used to stored additional charge details for a customer order against the Release #. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| ad_billable_yn | varchar(5) | NULL | billable y - yes n - no | No | No | |||
| ad_paytosupplier | char(16) | NULL | pay to supplier | No | No | |||
| ad_currency | varchar(20) | NULL | currency | No | No | |||
| ad_accounting_usage | char(20) | NULL | accounting usage | No | No | |||
| ad_cost_center | char(10) | NULL | cost center | No | No | |||
| ad_created_date | datetime | NULL | created date | No | No | |||
| ad_modified_by | varchar(30) | NULL | modified by | No | No | |||
| ad_remarks | varchar(255) | NULL | remarks | No | No | |||
| ad_created_by | varchar(30) | NULL | created by | No | No | |||
| ad_amount | numeric(28,8) | NULL | amount | No | No | |||
| ad_modified_date | datetime | NULL | modified date | No | No | |||
| ad_release_no | int | NOT NULL | release number | Yes | Yes | |||
| ad_lineno | int | NOT NULL | line number | Yes | No | |||
| ad_order_no | varchar(40) | NOT NULL | order number | Yes | Yes | |||
| ad_order_ou | int | NOT NULL | order ou instance | Yes | Yes | |||
| ad_markup_factor | bigint | NULL | mark up factor | No | No | |||
| ad_amend_no | int | NOT NULL | amendment number | No | No | |||
| ad_tcd_Rate | numeric(28,8) | NULL | tcd rate | No | No | |||
| ad_tcd_ou | int | NOT NULL | tcd ou instance | Yes | No | |||
| ad_tcd_variant_no | varchar(25) | NOT NULL | tcd variant number | Yes | No | |||
| ad_tcd_no | varchar(25) | NOT NULL | tcd number | Yes | No | |||
| Table Name corm_ibd_invbilling_dtl | ||||||||
| Table Comment This table is used to Stored Billing Head Details for the Customer order. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| ibd_quoted_price | numeric(28,8) | NULL | quoted price | No | No | |||
| ibd_actualcost | numeric(28,8) | NULL | actual cost | No | No | |||
| ibd_actual_price | numeric(19) | NULL | actual price | No | No | |||
| idb_invoiced_amount | numeric(28,8) | NULL | invoiced amount | No | No | |||
| ibd_Amount | numeric(19) | NULL | amount | No | No | |||
| ibd_order_no | varchar(40) | NOT NULL | order number | Yes | Yes | |||
| ibd_order_ou | int | NOT NULL | order ou instance | Yes | Yes | |||
| ibd_amend_no | int | NOT NULL | amendment number | No | No | |||
| ibd_release_no | int | NOT NULL | release number | Yes | Yes | |||
| ibd_billing_head | char(15) | NOT NULL | billing head | Yes | No | |||
| Table Name corm_imd_invmat_dtl | ||||||||
| Table Comment This table is used to store Part Invoice details against the Release ID for a Customer Order | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| imd_actual_issuecost | numeric(19) | NULL | actual issue code | No | No | |||
| imd_actual_unitprice | numeric(19) | NULL | actual unit price | No | No | |||
| imd_billableqty | numeric(28) | NULL | billable quantity | No | No | |||
| imd_consumedqty | numeric(28) | NULL | consumed quantity | No | No | |||
| imd_partpricelist | varchar(40) | NULL | part price list number | No | No | |||
| imd_bill_mat_price | numeric(19) | NULL | billable material price | No | No | |||
| imd_amount_tobe | numeric(19) | NULL | amount to be | No | No | |||
| imd_revisionno | varchar(40) | NULL | part price list revision number | No | No | |||
| imd_order_no | varchar(40) | NOT NULL | order number | Yes | Yes | |||
| imd_release_no | int | NOT NULL | release number | Yes | Yes | |||
| imd_order_ou | int | NOT NULL | order ou instance | Yes | Yes | |||
| imd_amend_no | int | NOT NULL | amendment number | No | No | |||
| imd_part_no | char(40) | NOT NULL | part number | Yes | No | |||
| imd_ref_line_no | int | NOT NULL | reference line number | Yes | Yes | |||
| imd_part_ou | int | NOT NULL | part ou instance | Yes | No | |||
| imd_line_no | int | NOT NULL | Running line number for customer order and amendment number combination | Yes | Yes | |||
| Table Name corm_Invh_invoice_hdr | ||||||||
| Table Comment This table is used to Store Header Level Information Like Release ID, Invoicing Comments,etc., for the Customer order. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| invh_order_ou | int | NOT NULL | order ou instance | Yes | No | |||
| invh_order_no | varchar(40) | NOT NULL | order number | Yes | No | |||
| invh_release_no | int | NOT NULL | release number | Yes | No | |||
| invh_amend_no | int | NOT NULL | amendment number | No | No | |||
| invh_release_status | varchar(5) | NOT NULL | release status | No | No | |||
| invh_Invoice_stage | varchar(5) | NULL | invoice stage | No | No | |||
| invh_actnormal_hr | numeric(28,8,) | NULL | actual normal hour | No | No | |||
| invh_actovertime_hr | numeric(28,8,) | NULL | actual overtime hour | No | No | |||
| invh_billnormal_hr | numeric(28,8,) | NULL | billable normal hour | No | No | |||
| invh_billovertime_hr | numeric(28,8,) | NULL | billable overtime hour | No | No | |||
| invh_invnormal_hr | numeric(28,8,) | NULL | invoice normal hour | No | No | |||
| invh_invovertime_hr | numeric(28,8,) | NULL | invoice over time hour | No | No | |||
| invh_invoicednormal_hr | numeric(28,8,) | NULL | invoiced normal hour | No | No | |||
| invh_invoicedot_hr | numeric(28,8,) | NULL | invoiced overtime hour | No | No | |||
| invh_comments | varchar(255) | NULL | comments | No | No | |||
| invh_prt_invcomments | varchar(255) | NULL | part invoice comments | No | No | |||
| invh_Invoicedby | varchar(30) | NOT NULL | invoiced by | No | No | |||
| invh_Invoiceddate | datetime | NOT NULL | invoiced date | No | No | |||
| invh_modifiedby | varchar(30) | NULL | modified by | No | No | |||
| invh_modifieddate | datetime | NULL | modified date | No | No | |||
| invh_timestamp | int | NULL | time stamp | No | No | |||
| invh_Exchange_Rate | numeric(28,8) | NULL | exchange rate | No | No | |||
| invh_confirmed_date | datetime | NULL | confirmed date | No | No | |||
| invh_confirmed_by | varchar(30) | NULL | confirmed by | No | No | |||
| invh_rep_comments | varchar(255) | NULL | reprocessing comments | No | No | |||
| INVH_DISPLAY_OPTN | varchar(5) | NULL | display option whether orderline level, task level or roster code level will be stored | No | No | |||
| INVH_BILLTO_CUST | varchar(18) | NULL | added for the cr : alt-sal-ps-005 Bill to multiple customers To store the bill to customer name | No | No | |||
| INVH_BILLTO_ADDRESS | varchar(40) | NULL | added for the cr : alt-sal-ps-005 Bill to multiple customers To store the bill to address of the customer | No | No | |||
| INVH_CLOSE_FROM_DATE | datetime | NULL | INVH_CLOSE_FROM_DATE | No | No | |||
| INVH_CLOSE_TO_DATE | datetime | NULL | INVH_CLOSE_TO_DATE | No | No | |||
| Table Name CORM_IRd_INV_PORD_dtl | ||||||||
| Table Comment po COST UPDATION TABLE FOR INVOICE | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| IRD_task_seqno | int | NULL | task seqence no define at the workorder for the task no | No | No | |||
| IRD_task_type | varchar(25) | NULL | task type | No | No | |||
| IRD_billable | varchar(25) | NULL | billable flag | No | No | |||
| IRD_gr_cost | numeric(28,8,) | NULL | gr cost | No | No | |||
| IRD_task_no | char(40) | NULL | task no | No | No | |||
| IRD_PO_ACCEPTED_DATE | datetime | NULL | po freeze acceptance date | No | No | |||
| IRD_gr_lineno | int | NULL | gr line no | No | No | |||
| IRD_po_peg_unit_cost | numeric(28,8,) | NULL | unit price | No | No | |||
| IRD_po_received_qty | numeric(28) | NULL | received qty | No | No | |||
| IRD_po_peg_cost | numeric(28,8,) | NULL | cost from pricing engine after applying the margin factor | No | No | |||
| IRD_po_refdocno | varchar(40) | NULL | reference document no (hwo/cwo) | No | No | |||
| IRD_po_refdocou | int | NOT NULL | reference document ou | No | No | |||
| IRD_po_costper | numeric(28,8,) | NULL | cost per quantity level | No | No | |||
| IRD_po_cost | numeric(28,8,) | NULL | po cost | No | No | |||
| IRD_po_peg_rev | numeric(28,8,) | NULL | revenue of the PO gr, Gr line# combination | No | No | |||
| IRD_PO_CUST_RELNO | int | NOT NULL | customer order release no | Yes | No | |||
| IRD_ref_line_NO | int | NOT NULL | reference line no for po gr line # combination | Yes | No | |||
| invh_order_ou | int | NOT NULL | order ou instance | Yes | Yes | |||
| IRD_ouinstance | int | NOT NULL | instance | Yes | No | |||
| IRD_po_custou | int | NOT NULL | customer order ou | Yes | No | |||
| IRD_po_custno | varchar(40) | NOT NULL | customer order no | Yes | No | |||
| IRD_gr_no | varchar(40) | NULL | gr no | No | No | |||
| IRD_po_lineno | int | NULL | Po item line no | No | No | |||
| IRD_po_curency | varchar(20) | NULL | Po currency | No | No | |||
| IRD_po_partno | varchar(40) | NULL | po part no | No | No | |||
| invh_order_no | varchar(40) | NOT NULL | order number | Yes | Yes | |||
| invh_release_no | int | NOT NULL | release number | Yes | Yes | |||
| IRD_PO_No | varchar(40) | NULL | Purchase order no | No | No | |||
| IRD_PO_OU | int | NOT NULL | po instance | No | No | |||
| Table Name corm_ird_inv_repord_dtl | ||||||||
| Table Comment This table is used to stored Repair order details for a customer order against the Release #. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| ird_pricing_basis | varchar(25) | NULL | pricing basis | No | No | |||
| ird_remarks | varchar(150) | NULL | remarks | No | No | |||
| ird_ser_pricelist | varchar(10) | NULL | service price list number | No | No | |||
| ird_total_value | numeric(28,8) | NULL | total value | No | No | |||
| ird_misc_price | numeric(28,8) | NULL | misc price | No | No | |||
| IRD_CREATED_DATE | datetime | NULL | created date | No | No | |||
| IRD_MODIFIED_BY | varchar(30) | NULL | modified user name | No | No | |||
| ird_billable | varchar(5) | NULL | billable | No | No | |||
| IRD_CREATED_BY | varchar(30) | NULL | created user name | No | No | |||
| ird_inv_status | varchar(5) | NULL | invoice status | No | No | |||
| IRD_MODIFIED_DATE | datetime | NULL | modified date | No | No | |||
| ird_release_no | int | NOT NULL | release number | Yes | Yes | |||
| ird_line_no | int | NOT NULL | line number | Yes | No | |||
| ird_repairorder_no | varchar(40) | NOT NULL | repair order number | No | No | |||
| ird_order_no | varchar(40) | NOT NULL | order number | Yes | Yes | |||
| ird_order_ou | int | NOT NULL | order ou instance | Yes | Yes | |||
| ird_material_price | numeric(28,8) | NULL | material price | No | No | |||
| ird_serial_no | varchar(40) | NULL | serial number | No | No | |||
| ird_resource_price | numeric(28,8) | NULL | resource price | No | No | |||
| ird_repairorder_ou | int | NOT NULL | repair order ou instance | No | No | |||
| ird_part_no | varchar(40) | NULL | part number | No | No | |||
| ird_amend_no | int | NOT NULL | amendment number | No | No | |||
| Table Name corm_ird_inv_resource_dtl | ||||||||
| Table Comment This table is used to store the Resource Reported against the workunits for a Customer order Release # wise. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| ird_effective_tilldate | datetime | NULL | effective till date | No | No | |||
| ird_revision_no | int(6) | NULL | revision number | No | No | |||
| IRD_ATTROSTER_CODE | varchar(25) | NULL | attendance roster code | No | No | |||
| IRD_INVOICABLEHR | numeric(28,8,) | NULL | invoicable hour | No | No | |||
| ird_facilityrate_perhr | numeric(19) | NULL | facility rate per hour | No | No | |||
| ird_service_pricelist | varchar(40) | NULL | service price list | No | No | |||
| ird_resource_price | numeric(28,8) | NULL | resource price | No | No | |||
| ird_otrate_perhr | numeric(19) | NULL | over time rate per hour | No | No | |||
| IRD_INVPROC_STATUS | varchar(5) | NULL | invoice process status | No | No | |||
| IRD_TOTAL_PRICE | numeric(28,8) | NULL | total price | No | No | |||
| IRD_SEQNO | int | NULL | sequence no | No | No | |||
| IRD_BILLABLE | varchar(5) | NULL | billable yes or no | No | No | |||
| IRD_COMMENTS | varchar(150) | NULL | comments | No | No | |||
| IRD_SELL_RATEPERHR | numeric(28,8) | NULL | sell rate per hour | No | No | |||
| IRD_BILLABLE_LABPRICE | numeric(28,8,) | NULL | billable labour price | No | No | |||
| IRD_BILLABLE_FACPRICE | numeric(28,8,) | NULL | billable facility price | No | No | |||
| IRD_ATTROSTER_DESC | varchar(25) | NULL | attendance roster code description | No | No | |||
| ird_resource_code | char(40) | NOT NULL | resource code | Yes | No | |||
| ird_line_no | int | NOT NULL | Running line number for customer order and amendment number combination | Yes | Yes | |||
| ird_amend_no | int | NOT NULL | amendment number | No | No | |||
| ird_wrkunit_lineno | int | NULL | workunit line number | No | No | |||
| ird_order_ou | int | NOT NULL | order ou instance | Yes | Yes | |||
| ird_ref_line_no | int | NOT NULL | reference number | Yes | Yes | |||
| ird_order_no | varchar(40) | NOT NULL | order number | Yes | Yes | |||
| ird_release_no | int | NOT NULL | release number | Yes | Yes | |||
| ird_normalrate_perhr | numeric(19) | NULL | normal rate per hour | No | No | |||
| ird_billable_hr_no | numeric(5) | NULL | billable hour normal | No | No | |||
| ird_actual_hr_ot | numeric(5) | NULL | actual hour overtime | No | No | |||
| ird_billable_hr_ot | numeric(5) | NULL | billable hour overtime | No | No | |||
| ird_resouce_type | char(25) | NULL | resource type | No | No | |||
| ird_est_man_hrs | numeric(28,8,) | NULL | estimated man hours | No | No | |||
| ird_actual_hr_nor | numeric(5) | NULL | actual hour normal | No | No | |||
| ird_quot_ratehr_nor | numeric(19) | NULL | quotation normal rate per hour | No | No | |||
| ird_quot_ratehr_ot | numeric(19) | NULL | quotation overtime rate per hour | No | No | |||
| Table Name corm_iwd_inv_wrkunit_dtl | ||||||||
| Table Comment To store the workunit and object details of the customer order . All the workunits defined in the workunit tab will be executed , For each part captured in object details tab page . | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| iwd_billable_facprice | numeric(28,8,) | NULL | billable facility price | No | No | |||
| iwd_billable_matprice | numeric(28,8) | NULL | billable material price | No | No | |||
| iwd_billable_misccost | numeric(28,8) | NULL | billable miscellenous cost | No | No | |||
| iwd_billable_labprice | numeric(28,8,) | NULL | billable labour price | No | No | |||
| iwd_invoicablehr | numeric(28,8,) | NULL | invoicable hour | No | No | |||
| iwd_invoiced_hr | numeric(28,8,) | NULL | invoiced hour | No | No | |||
| iwd_modified_date | datetime | NULL | Modified date of the information | No | No | |||
| iwd_ref_document | varchar(40) | NULL | reference document number | No | No | |||
| iwd_comments | varchar(150) | NULL | comments | No | No | |||
| iwd_created_by | varchar(30) | NULL | Created by ( user id ) | No | No | |||
| iwd_modified_by | varchar(30) | NULL | modified by ( user id ) | No | No | |||
| iwd_created_date | datetime | NULL | Created date of the information | No | No | |||
| iwd_ref_doc_type | char(15) | NULL | reference document type | No | No | |||
| iwd_line_no | int | NOT NULL | Running line number for customer order and amendment number combination | Yes | No | |||
| iwd_amend_no | int | NOT NULL | amendment number | No | No | |||
| iwd_invproc_status | varchar(5) | NULL | Quotation Status 1 ) Pending Labour Estimate 2 ) Pending Labour & material Estimate 3 ) Pending Material Estimate 4 ) Pending Confirmation 5 ) Quoted ( on confimration ) | No | No | |||
| iwd_order_ou | int | NOT NULL | order ou instance | Yes | Yes | |||
| iwd_release_no | int | NOT NULL | release number | Yes | Yes | |||
| iwd_order_no | varchar(40) | NOT NULL | order number | Yes | Yes | |||
| iwd_billable | varchar(5) | NULL | Billable values 1 ) Yes 2 ) No | No | No | |||
| iwd_actual_hr | numeric(5) | NULL | actual hour | No | No | |||
| iwd_billable_hr | numeric(28,8,) | NULL | billable hour | No | No | |||
| iwd_wrkunit_lineno | int | NULL | Line number of each distinct workunit . | No | No | |||
| iwd_workunit_ou | int | NOT NULL | Workunit ouinstance | No | No | |||
| iwd_workunit_type | varchar(25) | NULL | WorkunitType  values 1 ) Task 2 ) Standard Procedure 3 ) Aircraft Work Package 4 ) Component Work Package 5 ) Maint. Change Request 6 ) Engineering Order | No | No | |||
| iwd_workunit_no | char(40) | NULL | Workunit code | No | No | |||
| Table Name corm_iwd_inv_wutask_dtl | ||||||||
| Table Comment To store the workunit taskdetails and object details of the customer order . All the workunits defined in the workunit tab will be executed , For each part captured in object details tab page . | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| iwd_modified_by | varchar(30) | NULL | modified by ( user id ) | No | No | |||
| iwd_created_date | datetime | NULL | Created date of the information | No | No | |||
| iwd_modified_date | datetime | NULL | Modified date of the information | No | No | |||
| iwd_ref_document | varchar(40) | NULL | reference document  number | No | No | |||
| iwd_ref_doc_type | char(15) | NULL | reference document type | No | No | |||
| iwd_billable_matprice | numeric(28,8) | NULL | billable material price | No | No | |||
| iwd_created_by | varchar(30) | NULL | Created by ( user id ) | No | No | |||
| iwd_billable_miscost | numeric(28,8) | NULL | billable miscellneous cost | No | No | |||
| iwd_comments | varchar(150) | NULL | comments | No | No | |||
| iwd_billable_facprice | numeric(28,8,) | NULL | billable facility price | No | No | |||
| IWD_RESOURCE_CODE | char(40) | NULL | resource code | No | No | |||
| IWD_TOTAL_PRICE | numeric(28,8) | NULL | total price | No | No | |||
| IWD_RESOUCE_TYPE | char(25) | NULL | resource type | No | No | |||
| IWD_ATTROSTER_CODE | varchar(25) | NULL | attendance code of roster code | No | No | |||
| iwd_WorkOrder_No | char(40) | NULL | work order number | No | No | |||
| IWD_FACILITYRATE | numeric(28,8) | NULL | facility rate to be stored | No | No | |||
| IWD_LABOURRATE | numeric(28,8) | NULL | labour rate to be stored | No | No | |||
| IWD_SELL_RATEPERHR | numeric(28,8) | NULL | sell rate per hour | No | No | |||
| IWD_TASK_SERIALNO | int | NULL | task serial no of workorder  to be stored | No | No | |||
| IWD_ROSTER_CODE_FLAG | varchar(25) | NULL | roster code flag | No | No | |||
| IWD_ATTROSTER_DESC | varchar(25) | NULL | attendance description of roster code | No | No | |||
| iwd_amend_no | int | NOT NULL | amendment number | No | No | |||
| iwd_line_no | int | NOT NULL | Running line number for customer order and amendment number combination | Yes | Yes | |||
| iwd_invproc_status | varchar(5) | NULL | Quotation Status 1 ) Pending Labour Estimate 2 ) Pending Labour & material Estimate 3 ) Pending Material Estimate 4 ) Pending Confirmation 5 ) Quoted ( on confimration ) | No | No | |||
| iwd_wrkunit_lineno | int | NULL | work unit line number | No | No | |||
| iwd_parent_wu_ou | int | NOT NULL | Workunit ouinstance | No | No | |||
| iwd_order_ou | int | NOT NULL | order ou instance | Yes | Yes | |||
| iwd_ref_line_no | int | NOT NULL | rerence line number | Yes | No | |||
| iwd_order_no | varchar(40) | NOT NULL | order number | Yes | Yes | |||
| iwd_release_no | int | NOT NULL | release number | Yes | Yes | |||
| iwd_billable_labprice | numeric(28,8,) | NULL | billable labour price | No | No | |||
| iwd_billable_hr | numeric(28,8,) | NULL | billable hour | No | No | |||
| iwd_actual_hr | numeric(5) | NULL | actual hour | No | No | |||
| iwd_billable | varchar(5) | NULL | Billable values 1 ) Yes 2 ) No | No | No | |||
| iwd_invoicablehr | numeric(28,8,) | NULL | invoicable hour | No | No | |||
| iwd_parent_wu_no | char(40) | NULL | Workunit code | No | No | |||
| iwd_wrkpckage | varchar(40) | NULL | work package | No | No | |||
| iwd_parent_wu_type | varchar(25) | NULL | WorkunitType  values 1 ) Task 2 ) Standard Procedure 3 ) Aircraft Work Package 4 ) Component Work Package 5 ) Maint. Change Request 6 ) Engineering Order | No | No | |||
| iwd_taskrevno | varchar(40) | NULL | task revision number | No | No | |||
| iwd_stdproc | varchar(40) | NULL | standard procedure | No | No | |||
| iwd_taskcode | char(30) | NULL | task code | No | No | |||
| Table Name corm_oad_ord_addl_chr_dtl | ||||||||
| Table Comment This table is used to store additional charges occurs during workorder execution. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| oad_order_ou | int | NOT NULL | order ou instance | Yes | No | |||
| oad_order_no | varchar(40) | NOT NULL | order number | Yes | No | |||
| oad_amend_no | int | NOT NULL | amend number | Yes | No | |||
| oad_lineno | int | NOT NULL | line number | Yes | No | |||
| oad_tcd_ou | int | NOT NULL | tcd ou instance | Yes | No | |||
| oad_tcd_no | varchar(25) | NOT NULL | tcd number | Yes | No | |||
| oad_tcd_variant_no | varchar(25) | NOT NULL | tcd varient number | Yes | No | |||
| oad_tcd_Rate | numeric(28,8) | NULL | tcd rate | No | No | |||
| oad_markup_factor | bigint | NULL | mark up factor | No | No | |||
| oad_cost_center | char(10) | NULL | cost center | No | No | |||
| oad_accounting_usage | char(20) | NULL | accounting usage | No | No | |||
| oad_currency | varchar(20) | NULL | currency | No | No | |||
| oad_billable_yn | varchar(5) | NULL | billable yes / no | No | No | |||
| oad_paytosupplier | char(16) | NULL | pay to supplier | No | No | |||
| oad_remarks | varchar(255) | NULL | remarks | No | No | |||
| oad_amount | numeric(28,8) | NULL | amount | No | No | |||
| oad_invoiced | varchar(5) | NULL | invoiced | No | No | |||
| oad_created_by | varchar(30) | NULL | created by | No | No | |||
| oad_created_date | datetime | NULL | created date | No | No | |||
| oad_modified_by | varchar(30) | NULL | modified by | No | No | |||
| oad_modified_date | datetime | NULL | modified date | No | No | |||
| Table Name corm_qh_quotation_hdr | ||||||||
| Table Comment To Store the header details of the customer order Number . | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| qh_order_ou | int | NOT NULL | Customer order ouinstance | Yes | No | |||
| qh_order_no | varchar(40) | NOT NULL | Customer order number | Yes | No | |||
| qh_amend_no | int | NOT NULL | Amendment number for the Customer order | Yes | No | |||
| qh_quot_no | varchar(40) | NOT NULL | Quotation will be generated when the quotation is done for the first time for customer order . For a customer order we will have only one quotation number . | No | No | |||
| qh_quot_revisionno | int | NULL | When  Re-Quotation happen we will generate a revision number for the quotation that is created for the customer order . | No | No | |||
| qh_Quot_status | varchar(5) | NULL | Quotation Status 1 ) Not Required 2 ) Pending Quote 3 ) Quoted | No | No | |||
| qh_labrate_perhr | numeric(28,8) | NULL | Labour Rate/HR | No | No | |||
| qh_facrate_perhr | numeric(28,8) | NULL | Facility Rate Per Hour | No | No | |||
| qh_total_value | numeric(28,8) | NULL | Total value | No | No | |||
| qh_basic_value | numeric(28,8) | NULL | Basic value | No | No | |||
| qh_remarks | varchar(255) | NULL | Remarks | No | No | |||
| qh_misc_cost | numeric(28,8) | NULL | Miscellenous cost | No | No | |||
| qh_quot_routinehrs | numeric(28,8,) | NULL | Quoted Routine hours . | No | No | |||
| qh_quot_nonroutinehrs | numeric(28,8,) | NULL | Quoted Non - Routine hours . | No | No | |||
| qh_quot_TMat_Price | numeric(28,8) | NULL | Total Quoted Material price | No | No | |||
| qh_quot_TRes_Price | numeric(28,8) | NULL | Total Quoted Resource price | No | No | |||
| qh_quot_TFac_Hrs | numeric(28,8,) | NULL | Total Quoted facility hours | No | No | |||
| qh_part_comments | char(256) | NULL | qh_part_comments | No | No | |||
| qh_timestamp | int | NULL | qh_timestamp | No | No | |||
| qh_quot_created_by | varchar(30) | NULL | customer order quotation createdby by user | No | No | |||
| qh_quot_created_date | datetime | NULL | Created date and time of the customer order quotation | No | No | |||
| qh_quot_modified_by | varchar(30) | NULL | customer order quotation modifedby by user | No | No | |||
| qh_quot_modified_date | datetime | NULL | Modified date and time of the customer order quotation | No | No | |||
| qh_mquot_created_by | varchar(30) | NULL | Material Quote Created By | No | No | |||
| qh_mquot_created_date | datetime | NULL | Material Quote Created Date | No | No | |||
| qh_mquot_modified_by | varchar(30) | NULL | customer order Material quotation modifedby by user | No | No | |||
| qh_mquot_modified_date | datetime | NULL | Modified date and time of the customer order material quotation | No | No | |||
| qh_resquot_basis | varchar(5) | NULL | This column will store the previous quote basis of resource for a customer order . | No | No | |||
| qh_matquot_basis | varchar(5) | NULL | This column will store the previous quote basis of material for a customer order . | No | No | |||
| qh_quot_comments | char(256) | NULL | This column will store the quotation comments for resource . | No | No | |||
| Table Name corm_qhh_quotation_hdr | ||||||||
| Table Comment To Store the header details of the customer order Number -history. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| qhh_order_ou | int | NOT NULL | OU Instance | Yes | No | |||
| qhh_order_no | varchar(40) | NOT NULL | Customer order number | Yes | No | |||
| qhh_amend_no | int | NOT NULL | Amendment number for the Customer order | Yes | No | |||
| qhh_quot_no | varchar(40) | NOT NULL | Quotation will be generated when the quotation is done for the first time for customer order . For a customer order we will have only one quotation number . | No | No | |||
| qhh_quot_revisionno | int | NULL | When  Re-Quotation happen we will generate a revision number for the quotation that is created for the customer order . | No | No | |||
| qhh_Quot_status | varchar(5) | NULL | Quotation Status 1 ) Not Required 2 ) Pending Quote 3 ) Quoted | No | No | |||
| qhh_labrate_perhr | numeric(28,8) | NULL | Labour Rate/HR | No | No | |||
| qhh_facrate_perhr | numeric(28,8) | NULL | Facility Rate Per Hour | No | No | |||
| qhh_total_value | numeric(28,8) | NULL | Total value | No | No | |||
| qhh_basic_value | numeric(28,8) | NULL | Basic value | No | No | |||
| qhh_remarks | varchar(255) | NULL | Remarks | No | No | |||
| qhh_misc_cost | numeric(28,8) | NULL | Miscellenous cost | No | No | |||
| qhh_quot_routinehrs | numeric(28,8,) | NULL | Quoted Routine hours . | No | No | |||
| qhh_quot_nonroutinehrs | numeric(28,8,) | NULL | Quoted Non - Routine hours . | No | No | |||
| qhh_quot_TMat_Price | numeric(28,8) | NULL | Total Quoted Material price | No | No | |||
| qhh_quot_TRes_Price | numeric(28,8) | NULL | Total Quoted Resource price | No | No | |||
| qhh_quot_TFac_Hrs | numeric(28,8,) | NULL | Total Quoted facility hours | No | No | |||
| qhh_part_comments | char(256) | NULL | Part Comments | No | No | |||
| qhh_timestamp | int | NULL | Timestamp count | No | No | |||
| qhh_quot_created_by | varchar(30) | NULL | customer order quotation createdby by user | No | No | |||
| qhh_quot_created_date | datetime | NULL | Created date and time of the customer order quotation | No | No | |||
| qhh_quot_modified_by | varchar(30) | NULL | customer order quotation modifedby by user | No | No | |||
| qhh_quot_modified_date | datetime | NULL | Modified date and time of the customer order quotation | No | No | |||
| qhh_mquot_created_by | varchar(30) | NULL | Material Quote Created By | No | No | |||
| qhh_mquot_created_date | datetime | NULL | Material Quote Created Date | No | No | |||
| qhh_mquot_modified_by | varchar(30) | NULL | customer order Material quotation modifedby by user | No | No | |||
| qhh_mquot_modified_date | datetime | NULL | Modified date and time of the customer order material quotation | No | No | |||
| qhh_resquot_basis | varchar(5) | NULL | This column shows the Resource Quote Basis | No | No | |||
| qhh_matquot_basis | varchar(5) | NULL | qhh_matquot_basis | No | No | |||
| qhh_quot_comments | char(256) | NULL | This column shows the Resource Quote Comments | No | No | |||
| Table Name corm_qmd_quotemat_dtl | ||||||||
| Table Comment To Store Part details of the Customer order | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| qmd_order_ou | int | NOT NULL | order ou instance | Yes | Yes | |||
| qmd_order_no | varchar(40) | NOT NULL | order number | Yes | Yes | |||
| qmd_amend_no | int | NOT NULL | amendment number | Yes | Yes | |||
| qmd_ref_line_no | int | NOT NULL | Running line number for customer order and amendment number combination | Yes | Yes | |||
| qmd_Line_no | int | NOT NULL | line number | Yes | Yes | |||
| qmd_part_ou | int | NOT NULL | part ou instance | Yes | No | |||
| qmd_part_no | char(40) | NOT NULL | part number | Yes | No | |||
| qmd_stk_status | char(40) | NOT NULL | This column shows the stock status of the part | Yes | No | |||
| qmd_revisionno | int | NULL | revision number | No | No | |||
| qmd_quantity | numeric(28) | NULL | quantity | No | No | |||
| qmd_unit_price | numeric(28,8) | NULL | unit price | No | No | |||
| qmd_embodiment_fee | bigint | NULL | embodiment fee | No | No | |||
| qmd_standardcost | numeric(28,8) | NULL | standard cost | No | No | |||
| qmd_remarks | varchar(255) | NULL | remarks | No | No | |||
| qmd_partpricelist | varchar(40) | NULL | part price list number | No | No | |||
| qmd_pplrevisionno | varchar(40) | NULL | part price list revision number | No | No | |||
| qmd_quoteind | varchar(40) | NULL | This column will store value that will indicate the increase in existing part quantity or addition of new part . Values 1 ) Additional part 1 ) Additional quantity | No | No | |||
| qmd_act_qty | numeric(28) | NULL | This column will store the actual part quantity used . | No | No | |||
| qmd_comp_unit_price | numeric(28,8) | NULL | This column will store the value that is computed  by the pricing engine . | No | No | |||
| qmd_comp_embodimentfee | bigint | NULL | qmd_comp_embodimentfee | No | No | |||
| Table Name corm_qmhd_quotemat_dtl | ||||||||
| Table Comment This table is used to store Material quote details for a customer order | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| qmhd_order_ou | int | NOT NULL | Customer Order OU Instance | Yes | Yes | |||
| qmhd_order_no | varchar(40) | NOT NULL | Customer Order Number | Yes | Yes | |||
| qmhd_amend_no | int | NOT NULL | Customer Order Amendment Number | Yes | Yes | |||
| qmhd_ref_line_no | int | NOT NULL | Running line number for customer order and amendment number combination | Yes | Yes | |||
| qmhd_Line_no | int | NOT NULL | Line Number | Yes | Yes | |||
| qmhd_part_ou | int | NOT NULL | Part OU Instance | Yes | No | |||
| qmhd_part_no | char(40) | NOT NULL | Part Number | Yes | No | |||
| qmhd_stk_status | char(40) | NOT NULL | This shows Part Stock Status | Yes | No | |||
| qmhd_revisionno | int | NULL | Revision Number | No | No | |||
| qmhd_quantity | numeric(28) | NULL | Quantity | No | No | |||
| qmhd_unit_price | numeric(28,8) | NULL | Unit Price | No | No | |||
| qmhd_embodiment_fee | bigint | NULL | Embodiment Fee | No | No | |||
| qmhd_standardcost | numeric(28,8) | NULL | Standard Cost | No | No | |||
| qmhd_remarks | varchar(255) | NULL | Remarks | No | No | |||
| qmhd_partpricelist | varchar(40) | NULL | Part Price List | No | No | |||
| qmhd_pplrevisionno | varchar(40) | NULL | Part Price List revision Number | No | No | |||
| qmhd_comp_unit_price | numeric(28,8) | NULL | This shows Part Unit Price | No | No | |||
| qmhd_comp_embodimentfee | bigint | NULL | This shows Part Embodiment Fee | No | No | |||
| qmhd_quoteind | varchar(40) | NULL | This shows Part Indicator | No | No | |||
| qmhd_act_qty | numeric(28) | NULL | This shows Actual Part Qty | No | No | |||
| Table Name corm_qrd_qout_repord_dtl | ||||||||
| Table Comment This table will have information on Quoted Repair Order | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| qrd_order_ou | int | NOT NULL | Customer order ouinstance | Yes | Yes | |||
| qrd_order_no | varchar(40) | NOT NULL | Customer order number | Yes | Yes | |||
| qrd_amend_no | int | NOT NULL | Amendment number for the Customer order | Yes | Yes | |||
| qrd_line_no | int | NOT NULL | line number | Yes | No | |||
| qrd_repairorder_no | varchar(40) | NOT NULL | repair oder number | No | No | |||
| qrd_repairorder_ou | int | NOT NULL | repair order ou instance | No | No | |||
| qrd_part_no | varchar(40) | NULL | part number | No | No | |||
| qrd_serial_no | varchar(40) | NULL | serial number | No | No | |||
| qrd_resource_price | numeric(28,8) | NULL | resource price | No | No | |||
| qrd_material_price | numeric(28,8) | NULL | material price | No | No | |||
| qrd_misc_price | numeric(28,8) | NULL | miscellenous price | No | No | |||
| qrd_total_value | numeric(28,8) | NULL | total value | No | No | |||
| qrd_ser_pricelist | varchar(10) | NULL | service price list number | No | No | |||
| qrd_pricing_basis | varchar(25) | NULL | pricing basis | No | No | |||
| qrd_billable | varchar(5) | NULL | billable y - yes n - no | No | No | |||
| qrd_quot_status | varchar(5) | NULL | quotation status | No | No | |||
| qrd_revision_no | int | NULL | revision number - number of times the repair order value revisied | No | No | |||
| qrd_remarks | varchar(150) | NULL | remarks | No | No | |||
| qrd_resquot_basis | varchar(5) | NULL | This column will store the resource quote basis of each repair order . | No | No | |||
| qrd_matquot_basis | varchar(5) | NULL | This column will store the material quote basis of each repair order . | No | No | |||
| Table Name corm_qrhd_qout_repord_dtl | ||||||||
| Table Comment This table is used to store Quotation Repair Order details for a customer order | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| qrhd_pricing_basis | varchar(25) | NULL | Pricing Basis | No | No | |||
| qrhd_billable | varchar(5) | NULL | Billable | No | No | |||
| qrhd_ser_pricelist | varchar(10) | NULL | Service Price List | No | No | |||
| qrhd_total_value | numeric(28,8) | NULL | Total value | No | No | |||
| qrhd_misc_price | numeric(28,8) | NULL | Miscelaneous Price | No | No | |||
| qrhd_resquot_basis | varchar(5) | NULL | This Shows Resource Quote Basis | No | No | |||
| qrhd_quot_status | varchar(5) | NULL | Quotation Status | No | No | |||
| qrhd_remarks | varchar(150) | NULL | Remarks | No | No | |||
| qrhd_revision_no | int | NULL | revision number - number of times the repair order value revisied | No | No | |||
| qrhd_matquot_basis | varchar(5) | NULL | This Shows Material Quote Basis | No | No | |||
| qrhd_amend_no | int | NOT NULL | Amendment number for the Customer order | Yes | Yes | |||
| qrhd_line_no | int | NOT NULL | Line Number | Yes | No | |||
| qrhd_order_no | varchar(40) | NOT NULL | Customer order number | Yes | Yes | |||
| qrhd_order_ou | int | NOT NULL | Customer Order OU Instance | Yes | Yes | |||
| qrhd_material_price | numeric(28,8) | NULL | Material Price | No | No | |||
| qrhd_serial_no | varchar(40) | NULL | Serial number | No | No | |||
| qrhd_resource_price | numeric(28,8) | NULL | Resource Price | No | No | |||
| qrhd_repairorder_no | varchar(40) | NOT NULL | Repair Order Number | No | No | |||
| qrhd_part_no | varchar(40) | NULL | Part Number | No | No | |||
| qrhd_repairorder_ou | int | NOT NULL | Repair Order OU Instance | No | No | |||
| Table Name CORM_QRS_QUOTE_RES_DTL | ||||||||
| Table Comment This table will store the resource details at task level . | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| qrs_order_ou | int | NOT NULL | order ou instance | Yes | Yes | |||
| qrs_order_no | varchar(40) | NOT NULL | order number | Yes | Yes | |||
| qrs_amend_no | int | NOT NULL | amendment number | Yes | Yes | |||
| qrs_ref_line_no | int | NOT NULL | Running line number for customer order and amendment number combination | Yes | Yes | |||
| qrs_task_line_no | int | NOT NULL | task like numer | Yes | Yes | |||
| qrs_resource_code | char(40) | NOT NULL | Resource Code | Yes | No | |||
| qrs_resource_type | varchar(25) | NULL | Resource Type | No | No | |||
| qrs_est_no | numeric(28) | NULL | Estimation Number | No | No | |||
| qrs_billable_hrs | numeric(28,8,) | NULL | Billable Hours | No | No | |||
| qrs_nonbillable_hrs | numeric(28,8,) | NULL | Non billable Hours | No | No | |||
| qrs_resourcerate_perhr | numeric(28,8) | NULL | Resource Rate Per Hour | No | No | |||
| qrs_pricelist | varchar(40) | NULL | Service Price List | No | No | |||
| qrs_spl_revno | varchar(40) | NULL | Service Price List Revision Number | No | No | |||
| qrs_spl_eff_date | datetime | NULL | Service Price List Effectivity date | No | No | |||
| Table Name corm_qwd_quote_wrkunit_dtl | ||||||||
| Table Comment To store the workunit and object details of the customer order . All the workunits defined in the workunit tab will be executed , For each part captured in object details tab page . | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| qwd_order_ou | int | NOT NULL | Customer order ouinstance | Yes | Yes | |||
| qwd_order_no | varchar(40) | NOT NULL | Customer order number | Yes | Yes | |||
| qwd_amend_no | int | NOT NULL | Amendment number for the Customer order | Yes | Yes | |||
| qwd_line_no | int | NOT NULL | Running line number for customer order and amendment number combination | Yes | No | |||
| qwd_quot_no | varchar(40) | NOT NULL | quotation number | No | No | |||
| qwd_revisionno | int | NULL | revision number | No | No | |||
| qwd_quot_status | varchar(5) | NULL | Quotation Status 1 ) Pending Labour Estimate 2 ) Pending Labour & material Estimate 3 ) Pending Material Estimate 4 ) Pending Confirmation 5 ) Quoted ( on confimration ) | No | No | |||
| qwd_wrkunit_lineno | int | NULL | Line number of each distinct workunit . | No | No | |||
| qwd_workunit_ou | int | NOT NULL | Workunit ouinstance | No | No | |||
| qwd_workunit_no | char(40) | NULL | Workunit code | No | No | |||
| qwd_wrkunit_type | varchar(25) | NULL | WorkunitType  values 1 ) Task 2 ) Standard Procedure 3 ) Aircraft Work Package 4 ) Component Work Package 5 ) Maint. Change Request 6 ) Engineering Order | No | No | |||
| qwd_billable | varchar(5) | NULL | Billable values 1 ) Yes 2 ) No | No | No | |||
| qwd_estman_hrs | numeric(28,8,) | NULL | Estimated ManHours | No | No | |||
| qwd_qlabour_hrs | numeric(28,8,) | NULL | quoted labour hours | No | No | |||
| qwd_qfacility_hrs | numeric(28,8,) | NULL | quoted facility hours | No | No | |||
| qwd_labourrate_perhr | numeric(28,8) | NULL | labour rate per hour | No | No | |||
| qwd_facilityrate_perhr | numeric(28,8) | NULL | facility rate per hour | No | No | |||
| qwd_estresource_price | numeric(28,8) | NULL | estimated resource price | No | No | |||
| qwd_estmat_price_flat | numeric(28,8) | NULL | estimated material price flat | No | No | |||
| qwd_estmat_price | numeric(28,8) | NULL | Estimated Material Price = SUM ( Unit Material Price ) + SUM ( Embodiment Fee ) | No | No | |||
| qwd_embodiment_fee | numeric(28,8) | NULL | Embodiment Fee | No | No | |||
| qwd_estmisc_price | numeric(28,8) | NULL | estimated miscellenous price | No | No | |||
| qwd_remarks | varchar(150) | NULL | remarks | No | No | |||
| qwd_pricingbasis | varchar(25) | NULL | pricing basis | No | No | |||
| qwd_created_by | varchar(30) | NULL | Created by ( user id ) | No | No | |||
| qwd_created_date | datetime | NULL | Created date of the information | No | No | |||
| qwd_modified_by | varchar(30) | NULL | modified by ( user id ) | No | No | |||
| qwd_modified_date | datetime | NULL | Modified date of the information | No | No | |||
| qwd_ref_document | varchar(40) | NULL | reference document number | No | No | |||
| qwd_ref_doc_type | char(15) | NULL | reference document type | No | No | |||
| qwd_resquot_basis | varchar(5) | NULL | This column will store the quote basis of resource for each workunit . | No | No | |||
| qwd_matquot_basis | varchar(5) | NULL | This column will store the quote basis of material for each workunit . | No | No | |||
| qwd_act_labhrs | numeric(28,8,) | NULL | This column will store actual labour hours for each workunit . | No | No | |||
| qwd_act_fachrs | numeric(28,8,) | NULL | This column will store actual facility hours for each workunit . | No | No | |||
| Table Name corm_qwd_quote_wutask_dtl | ||||||||
| Table Comment To store the workunit task details and object details of the customer order . All the workunits (tasks) defined in the workunit tab will be executed , For each part captured in object details tab page . | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| qwd_order_ou | int | NOT NULL | order ou instance | Yes | Yes | |||
| qwd_order_no | varchar(40) | NOT NULL | order number | Yes | Yes | |||
| qwd_amend_no | int | NOT NULL | amendment number | Yes | Yes | |||
| qwd_ref_line_no | int | NOT NULL | Running line number for customer order and amendment number combination | Yes | Yes | |||
| qwd_task_line_no | int | NOT NULL | task like numer | Yes | No | |||
| qwd_quot_no | varchar(40) | NOT NULL | quotation number | No | No | |||
| qwd_quot_status | varchar(5) | NULL | Quotation Status 1 ) Pending Labour Estimate 2 ) Pending Labour & material Estimate 3 ) Pending Material Estimate 4 ) Pending Confirmation 5 ) Quoted ( on confimration ) | No | No | |||
| qwd_revisionno | int | NULL | revision number | No | No | |||
| qwd_wrkunit_lineno | int | NULL | Line number of each distinct workunit . | No | No | |||
| qwd_parent_wu_ou | int | NOT NULL | Workunit ouinstance | No | No | |||
| qwd_parent_wu_no | char(40) | NULL | Workunit code | No | No | |||
| qwd_parent_wu_type | varchar(25) | NULL | WorkunitType  values 1 ) Task 2 ) Standard Procedure 3 ) Aircraft Work Package 4 ) Component Work Package 5 ) Maint. Change Request 6 ) Engineering Order | No | No | |||
| qwd_wrkpckage | varchar(40) | NULL | Work Pakage | No | No | |||
| qwd_stdproc | varchar(40) | NULL | Standard procedure | No | No | |||
| qwd_taskcode | varchar(30) | NULL | Task Code | No | No | |||
| qwd_taskrevno | varchar(40) | NULL | Task Revision Number | No | No | |||
| qwd_billable | varchar(5) | NULL | Billable values 1 ) Yes 2 ) No | No | No | |||
| qwd_estman_Hrs | numeric(28,8,) | NULL | Estimated ManHours | No | No | |||
| qwd_qlabour_Hrs | numeric(28,8,) | NULL | Quated Labour Hours | No | No | |||
| qwd_qfacility_hrs | numeric(28,8,) | NULL | Quated Facility Hours | No | No | |||
| qwd_labourrate_perhr | numeric(28,8) | NULL | Quated Labour rate Per Hour | No | No | |||
| qwd_facilityrate_perhr | numeric(28,8) | NULL | Quated Facility rate per Hours | No | No | |||
| qwd_estresource_price | numeric(28,8) | NULL | Estimated Resource Price | No | No | |||
| qwd_estmaterial_price_flt | numeric(28,8) | NULL | Estimated Material price Flat | No | No | |||
| qwd_estmat_price | numeric(28,8) | NULL | Estimated Material Price = SUM ( Unit Material Price ) + SUM ( Embodiment Fee ) | No | No | |||
| qwd_embodiment_fee | numeric(28,8) | NULL | Embodiment Fee | No | No | |||
| qwd_estmisc_price | numeric(28,8) | NULL | Estimated Misclaneous price | No | No | |||
| qwd_pricingbasis | varchar(25) | NULL | Pricing Basis | No | No | |||
| qwd_remarks | varchar(150) | NULL | Remarks | No | No | |||
| qwd_created_by | varchar(30) | NULL | Created by ( user id ) | No | No | |||
| qwd_created_date | datetime | NULL | Created date of the information | No | No | |||
| qwd_modified_by | varchar(30) | NULL | modified by ( user id ) | No | No | |||
| qwd_modified_date | datetime | NULL | Modified date of the information | No | No | |||
| qwd_ref_document | varchar(40) | NULL | Reference Document Number | No | No | |||
| qwd_ref_doc_type | char(15) | NULL | reference document type | No | No | |||
| qwd_resquot_basis | varchar(5) | NULL | This column will store the quote basis of resource for each task . | No | No | |||
| qwd_matquot_basis | varchar(5) | NULL | This column will store the quote basis of material for each task . | No | No | |||
| qwd_act_labhrs | numeric(28,8,) | NULL | This column will store actual labour hours for each task. | No | No | |||
| qwd_act_fachrs | numeric(28,8,) | NULL | This column will store actual facility hours for each task . | No | No | |||
| Table Name corm_qwhd_quote_wrkunit_dtl | ||||||||
| Table Comment To store the quoted workunit and object details of the customer order . All the workunits defined in the workunit tab will be executed , For each part captured in object details tab page . | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| qwhd_order_ou | int | NOT NULL | Customer order OU Instance | Yes | Yes | |||
| qwhd_order_no | varchar(40) | NOT NULL | Customer order number | Yes | Yes | |||
| qwhd_amend_no | int | NOT NULL | Amendment number for the Customer order | Yes | Yes | |||
| qwhd_line_no | int | NOT NULL | Running line number for customer order and amendment number combination | Yes | No | |||
| qwhd_quot_no | varchar(40) | NULL | Quotation Number | No | No | |||
| qwhd_revisionno | int | NULL | Revision Number | No | No | |||
| qwhd_quot_status | varchar(5) | NULL | Quotation Status 1 ) Pending Labour Estimate 2 ) Pending Labour & material Estimate 3 ) Pending Material Estimate 4 ) Pending Confirmation 5 ) Quoted ( on confimration ) | No | No | |||
| qwhd_wrkunit_lineno | int | NULL | Line number of each distinct workunit . | No | No | |||
| qwhd_wrkunit_ou | int | NOT NULL | Workunit ouinstance | No | No | |||
| qwhd_workunit_no | char(40) | NULL | Workunit code | No | No | |||
| qwhd_wrkunit_type | varchar(25) | NULL | WorkunitType  values 1 ) Task 2 ) Standard Procedure 3 ) Aircraft Work Package 4 ) Component Work Package 5 ) Maint. Change Request 6 ) Engineering Order | No | No | |||
| qwhd_billable | varchar(5) | NULL | Billable values 1 ) Yes 2 ) No | No | No | |||
| qwhd_estman_hrs | numeric(28,8,) | NULL | Estimated ManHours | No | No | |||
| qwhd_qlabour_hrs | numeric(28,8,) | NULL | Quotated Labour Hours | No | No | |||
| qwhd_qfacility_hrs | numeric(28,8,) | NULL | Quotated Facility Hours | No | No | |||
| qwhd_labourrate_perhr | numeric(28,8) | NULL | Labour Rate PerHour | No | No | |||
| qwhd_facilityrate_perhr | numeric(28,8) | NULL | Facility Rate PerHour | No | No | |||
| qwhd_estresource_price | numeric(28,8) | NULL | Estimated Resource Price | No | No | |||
| qwhd_estmat_price_flat | numeric(28,8) | NULL | Flat Estimated Material Price | No | No | |||
| qwhd_estmat_price | numeric(28,8) | NULL | Estimated Material Price = SUM ( Unit Material Price ) + SUM ( Embodiment Fee ) | No | No | |||
| qwhd_embodiment_fee | numeric(28,8) | NULL | Embodiment Fee | No | No | |||
| qwhd_estmisc_price | numeric(28,8) | NULL | Estimated Miscelaneous Price | No | No | |||
| qwhd_remarks | varchar(150) | NULL | Remarks | No | No | |||
| qwhd_pricingbasis | varchar(25) | NULL | Pricing basis | No | No | |||
| qwhd_created_by | varchar(30) | NULL | Created by ( user id ) | No | No | |||
| qwhd_created_date | datetime | NULL | Created date of the information | No | No | |||
| qwhd_modified_by | varchar(30) | NULL | modified by ( user id ) | No | No | |||
| qwhd_modified_date | datetime | NULL | Modified date of the information | No | No | |||
| qwhd_ref_document | varchar(40) | NULL | Reference Document | No | No | |||
| qwhd_ref_doc_type | char(15) | NULL | Reference Document Type | No | No | |||
| qwhd_act_labhrs | numeric(28,8,) | NULL | This Column shows Actual Labour Hour | No | No | |||
| qwhd_act_fachrs | numeric(28,8,) | NULL | This Column shows Actual Facility Hour | No | No | |||
| qwhd_resquot_basis | varchar(5) | NULL | This Column shows Resource Quote Basis | No | No | |||
| qwhd_matquot_basis | varchar(5) | NULL | This Column shows Material Quote Basis | No | No | |||
| Table Name corm_qwhd_quote_wutask_dtl | ||||||||
| Table Comment To store the quoted workunit task details and object details of the customer order . All the workunits defined in the workunit tab will be executed , For each part captured in object details tab page . | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| qwhd_embodiment_fee | numeric(28,8) | NULL | Embodiment Fee | No | No | |||
| qwhd_estmat_price | numeric(28,8) | NULL | Estimated Material Price = SUM ( Unit Material Price ) + SUM ( Embodiment Fee ) | No | No | |||
| qwhd_estmisc_price | numeric(28,8) | NULL | Estimated Miscelaneous price | No | No | |||
| qwhd_pricingbasis | varchar(25) | NULL | Pricing Basis | No | No | |||
| qwhd_remarks | varchar(150) | NULL | Remarks | No | No | |||
| qwhd_labourrate_perhr | numeric(28,8) | NULL | Labour rate per Hour | No | No | |||
| qwhd_estmaterial_price_flt | numeric(28,8) | NULL | Flat Estimated Material Price | No | No | |||
| qwhd_facilityrate_perhr | numeric(28,8) | NULL | Facility rate per Hour | No | No | |||
| qwhd_estresource_price | numeric(28,8) | NULL | Estimated resource Price | No | No | |||
| qwhd_qfacility_hrs | numeric(28,8,) | NULL | Quotated Facility Hours | No | No | |||
| qwhd_act_labhrs | numeric(28,8,) | NULL | This Column shows Actual Labour Hours | No | No | |||
| qwhd_ref_doc_type | char(15) | NULL | Reference Document Type | No | No | |||
| qwhd_act_fachrs | numeric(28,8,) | NULL | This Column shows Actual Facility Hours | No | No | |||
| qwhd_resquot_basis | varchar(5) | NULL | This Column shows Resource Quote Basis | No | No | |||
| qwhd_created_by | varchar(30) | NULL | Created by ( user id ) | No | No | |||
| qwhd_created_date | datetime | NULL | Created date of the information | No | No | |||
| qwhd_ref_document | varchar(40) | NULL | Reference Document Number | No | No | |||
| qwhd_modified_by | varchar(30) | NULL | modified by ( user id ) | No | No | |||
| qwhd_modified_date | datetime | NULL | Modified date of the information | No | No | |||
| qwhd_matquot_basis | varchar(5) | NULL | This Column shows Material Quote Bas | No | No | |||
| qwhd_quot_no | varchar(40) | NULL | Quotation Number | No | No | |||
| qwhd_task_line_no | int | NOT NULL | Task Line Number | Yes | No | |||
| qwhd_revisionno | int | NULL | Revision Number | No | No | |||
| qwhd_quot_status | varchar(5) | NULL | Quotation Status 1 ) Pending Labour Estimate 2 ) Pending Labour & material Estimate 3 ) Pending Material Estimate 4 ) Pending Confirmation 5 ) Quoted ( on confimration ) | No | No | |||
| qwhd_wrkunit_lineno | int | NULL | Line number of each distinct workunit . | No | No | |||
| qwhd_order_ou | int | NOT NULL | Customer Order OU Instance | Yes | Yes | |||
| qwhd_ref_line_no | int | NOT NULL | Running line number for customer order and amendment number combination | Yes | Yes | |||
| qwhd_order_no | varchar(40) | NOT NULL | Customer Order Number | Yes | Yes | |||
| qwhd_amend_no | int | NOT NULL | Customer Order Amendment Number | Yes | Yes | |||
| qwhd_qlabour_Hrs | numeric(28,8,) | NULL | Quotated Labour Hours | No | No | |||
| qwhd_taskrevno | varchar(40) | NULL | Task Revision Number | No | No | |||
| qwhd_taskcode | varchar(30) | NULL | Task Code | No | No | |||
| qwhd_billable | varchar(5) | NULL | Billable values 1 ) Yes 2 ) No | No | No | |||
| qwhd_estman_Hrs | numeric(28,8,) | NULL | Estimated ManHours | No | No | |||
| qwhd_parent_wu_ou | int | NOT NULL | Workunit ouinstance | No | No | |||
| qwhd_parent_wu_no | char(40) | NULL | Workunit code | No | No | |||
| qwhd_stdproc | varchar(40) | NULL | Standard Procedure | No | No | |||
| qwhd_parent_wu_type | varchar(25) | NULL | WorkunitType  values 1 ) Task 2 ) Standard Procedure 3 ) Aircraft Work Package 4 ) Component Work Package 5 ) Maint. Change Request 6 ) Engineering Order | No | No | |||
| qwhd_wrkpckage | varchar(40) | NULL | Work Package | No | No | |||
| Table Name corm_td_tcd_dtl | ||||||||
| Table Comment This table is used to stored Tax, Charge and Discount details for a customer order against the Release #. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| td_billable_yn | varchar(5) | NULL | billable y-yes n - no | No | No | |||
| td_Amount | numeric(28,8) | NULL | amount | No | No | |||
| td_rate | numeric(28,8) | NULL | rate | No | No | |||
| td_currency | varchar(20) | NULL | currency | No | No | |||
| td_modified_by | varchar(30) | NULL | modified by | No | No | |||
| td_PaytoSupplier | char(16) | NULL | pay to supplier | No | No | |||
| td_created_date | datetime | NULL | created date | No | No | |||
| td_created_by | varchar(30) | NULL | created by | No | No | |||
| td_modified_date | datetime | NULL | modified date | No | No | |||
| td_release_no | int | NOT NULL | release number | Yes | Yes | |||
| td_Lineno | int | NOT NULL | line number | Yes | No | |||
| td_order_no | varchar(40) | NOT NULL | order number | Yes | Yes | |||
| td_order_ou | int | NOT NULL | order ou instance | Yes | Yes | |||
| td_amend_no | int | NOT NULL | amendment number | No | No | |||
| td_tcd_Variant_no | varchar(25) | NOT NULL | tcd variant number | Yes | No | |||
| td_ApplnOn | varchar(5) | NOT NULL | applicable on | Yes | No | |||
| td_tcd_no | varchar(25) | NOT NULL | tcd number | Yes | No | |||
| td_tcd_ou | int | NOT NULL | tcd ou instance | Yes | No | |||