Customer Order Management

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	Reference	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	Correspondence Category	No	No
CUCRSP_HIS_CRSSTS	varchar(5)	NULL	Correspondence 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	language 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 sequence 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 miscellaneous 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 miscellaneous 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	reference 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 variant 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	Miscellaneous 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 created 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 modified 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 modified 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	Miscellaneous 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 created 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 modified 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 modified 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 order 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	miscellaneous 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 revised	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	Miscellaneous 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 revised	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 number	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 miscellaneous 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 number	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 Miscellaneous 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 Miscellaneous 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 Miscellaneous 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