Customer Order

Customer Order

Table Name CO_TskInv_Task_Invoice_Map

Table Comment Customer order Invoice for task level
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
TskInv_OUInstance	int	NOT NULL	Ou Instance	No	No
TskInv_COrderNo	sql_variant	NOT NULL	Customer Order Number	No	No
TskInv_COAmendNo	sql_variant	NOT NULL	Customer Order Amendment Number	No	No
TskInv_WOrderNo	sql_variant	NULL	Work Order Number	No	No
TskInv_TaskNo	sql_variant	NULL	Task Number	No	No
TskInv_TaskRevNo	sql_variant	NULL	Task Revision Number	No	No
TskInv_InvoiceNo	sql_variant	NULL	Invoice Number	No	No
TskInv_BilledFlag	sql_variant	NULL	Billed Flag	No	No

Table Name corder_add_address

Table Comment To Store the address 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
add_ship_cont_person	sql_variant	NULL	Contact person in the Shipping address	No	No
add_ship_phone	sql_variant	NULL	Phone number of the Shipping address	No	No
add_ship_email	sql_variant	NULL	Email id of the Contact person in the shipping address .	No	No
add_ship_address	sql_variant	NULL	Shipping address of the customer order	No	No
add_ship_to_add	sql_variant	NULL	Ship to address	No	No
add_ship_cust_ou	int	NULL	Ouinstance of the ship-to-customer	No	No
add_created_date	datetime	NULL	Created date	No	No
add_modified_by	sql_variant	NULL	Modified by ( user information )	No	No
add_ship_fax	sql_variant	NULL	Fax number of the shipping address	No	No
add_created_by	sql_variant	NULL	Created by ( user information )	No	No
add_timestamp	int	NULL	Timestamp value for concurrence check	No	No
add_modified_date	datetime	NULL	modified date	No	No
add_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
add_bill_cust	sql_variant	NULL	Bill to customer combo values Accepted values : Customer # who are identified as Bill to customers or both Bill To and Ship To Customers in the customer relationship page of &nbspcustomer component .	No	No
add_bill_cust_ou	int	NULL	ouinstance of bill to customer	No	No
add_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
add_order_ou	int	NOT NULL	Customer order ouinstance	Yes	Yes
add_ship_cust	sql_variant	NULL	Ship to customer combo values All the Customer # who are identified as Ship to customers or both Bill To and Ship To Customers in the customer relationship page of &nbspcustomer component .	No	No
add_bill_email	sql_variant	NULL	Email id of the Contact person in the billing address .	No	No
add_bill_fax	sql_variant	NULL	Fax number of the billing address	No	No
add_bill_to_add	sql_variant	NULL	Bill to Address values	No	No
add_bill_address	sql_variant	NULL	Billing address of the customer order	No	No
add_bill_phone	sql_variant	NULL	Phone number of the billing address	No	No
add_bill_cont_person	sql_variant	NULL	Contact person in the billing address	No	No

Table Name CORDER_AMD_ACC_MAT_DTL

Table Comment Material details for the Accrual for the corresponding Customer order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
AMD_LINE_NO	int	NOT NULL	Line Number	Yes	No
AMD_PROCESS_DATE	datetime	NOT NULL	Process date	Yes	No
AMD_PART_NO	sql_variant	NOT NULL	Part Number	Yes	No
AMD_STOCK_STATUS	sql_variant	NOT NULL	Part Stock status	Yes	No
AMD_CUSTORDER_OU	int	NOT NULL	Customer order OU Instance	Yes	No
AMD_UOM	sql_variant	NOT NULL	Unit Of Measurement	No	No
AMD_QUOTE_QTY	bigint	NULL	Quated Quantity	No	No
AMD_QUOTE_RATEPERQTY	bigint	NULL	Quated Rate Per Quantity	No	No
AMD_ACTUAL_QTY	bigint	NULL	Actual Quantity	No	No
AMD_ACT_RATEPERQTY	bigint	NULL	Actual Rate per Quantity	No	No
AMD_BILLABLE_QTY	bigint	NULL	Billable Quantity	No	No
AMD_BILL_RATEPERQTY	bigint	NULL	Billable Rate Quantity	No	No
AMD_MAT_REV_ORDCURR	bigint	NULL	Material Revenue in Order Currency	No	No
AMD_MAT_REV_BASCURR	bigint	NULL	Material Revenue in Base Currency	No	No
AMD_MAT_COST	bigint	NULL	Material Cost	No	No

Table Name CORDER_ARD_ACC_RES_DTL

Table Comment Resource details for the Accrual for the corresponding Customer order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ARD_LINE_NO	int	NOT NULL	Line Number	Yes	No
ARD_PROCESS_DATE	datetime	NOT NULL	Process date	Yes	No
ARD_RESOURCE_CODE	sql_variant	NOT NULL	Resource Code	Yes	No
ARD_RESOUCE_TYPE	sql_variant	NOT NULL	Resource Type	Yes	No
ARD_CUSTORDER_OU	int	NOT NULL	Customer Order OU Instance	Yes	No
ARD_EST_HRS	bigint	NULL	Estimated Hours	No	No
ARD_QUOTE_HRS	bigint	NULL	Quated Hours	No	No
ARD_ACT_HRS_NRM	bigint	NULL	Actual hours Normal	No	No
ARD_ACT_HRS_OT	bigint	NULL	Actual Hours overtime	No	No
ARD_ACT_RTPERHR_NRM	bigint	NULL	Actual Rate Per Hour Normal	No	No
ARD_ACT_RTPERHR_OT	bigint	NULL	Actual Rate Per Hour Overtime	No	No
ARD_BILL_HRS_NRM	bigint	NULL	Billable Hours Normal	No	No
ARD_BILL_HRS_OT	bigint	NULL	Billable Hours Overtime	No	No
ARD_BILL_RTPERHR_NRM	bigint	NULL	Billable rate Per Hours Normal	No	No
ARD_BILL_RTPERHR_OT	bigint	NULL	Billable Rate Per Hours Overtime	No	No
ARD_RES_REV_ORDCURR	bigint	NULL	Resource Revenue in Order Currency	No	No
ARD_RES_REV_BASCURR	bigint	NULL	Resource Revenue in Base Currency	No	No
ARD_RES_COST	bigint	NULL	Resource Cost	No	No

Table Name CORDER_AROD_ACC_RORD_DTL

Table Comment Repair order details for the Accrual for the corresponding Customer order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
AROD_LINE_NO	int	NOT NULL	Line Number	Yes	No
AROD_PROCESS_DATE	datetime	NOT NULL	Process Date	Yes	No
AROD_CUSTORDER_OU	int	NOT NULL	Customer Order OU Instance	Yes	No
AROD_REP_ORDER_OU	int	NOT NULL	Repair Order OU Instance	No	No
AROD_REP_ORDER_NO	sql_variant	NOT NULL	Repair Order number	No	No
AROD_QTY_ORDERED	bigint	NULL	Quantity Ordered	No	No
AROD_QTY_RECEIVED	bigint	NULL	Quantity received	No	No
AROD_BILL_RTPERQTY	bigint	NULL	Billable Rate Per Quantity	No	No
AROD_REV_ORDCURR	bigint	NULL	Revenue in Order Currency	No	No
AROD_REV_BASCURR	bigint	NULL	Revenue in Base Currency	No	No

Table Name CORDER_ASR_ACC_po_DTL

Table Comment Accrual table to store the PO cost
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
asr_guid	sql_variant	NOT NULL	asr_guid	Yes	No
asr_PROCESS_DATE	datetime	NOT NULL	asr_PROCESS_DATE	Yes	No
asr_seqno	int	NOT NULL	asr_seqno	Yes	No
asr_task_serial_no	int	NULL	asr_task_serial_no	No	No
asr_ouinstance	int	NULL	asr_ouinstance	No	No
asr_Document_OU	int	NULL	asr_Document_OU	No	No
asr_Document_No	sql_variant	NULL	asr_Document_No	No	No
asr_po_curency	sql_variant	NULL	asr_po_curency	No	No
asr_po_lineno	int	NULL	asr_po_lineno	No	No
asr_po_partno	sql_variant	NULL	asr_po_partno	No	No
asr_gr_no	sql_variant	NULL	asr_gr_no	No	No
asr_gr_lineno	int	NULL	asr_gr_lineno	No	No
asr_gr_cost	bigint	NULL	asr_gr_cost	No	No
asr_PO_ACCEPTED_DATE	datetime	NULL	asr_PO_ACCEPTED_DATE	No	No
asr_task_no	sql_variant	NULL	asr_task_no	No	No
asr_task_seqno	int	NULL	asr_task_seqno	No	No
asr_task_type	sql_variant	NULL	asr_task_type	No	No
asr_billable	sql_variant	NULL	asr_billable	No	No
asr_po_refdocno	sql_variant	NULL	asr_po_refdocno	No	No
asr_po_refdocou	int	NULL	asr_po_refdocou	No	No
asr_po_custno	sql_variant	NULL	asr_po_custno	No	No
asr_po_custou	int	NULL	asr_po_custou	No	No
asr_po_cost	bigint	NULL	asr_po_cost	No	No
asr_po_costper	bigint	NULL	asr_po_costper	No	No
asr_po_received_qty	bigint	NULL	asr_po_received_qty	No	No
asr_po_peg_unit_cost	bigint	NULL	asr_po_peg_unit_cost	No	No
asr_po_peg_cost	bigint	NULL	asr_po_peg_cost	No	No
asr_po_peg_rev	bigint	NULL	asr_po_peg_rev	No	No

Table Name CORDER_ATD_ACC_TASK_DTL

Table Comment Task details for the Accrual for the corresponding Customer order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ATD_LINE_NO	int	NOT NULL	Line Number	Yes	No
ATD_PROCESS_DATE	datetime	NOT NULL	Process Date	Yes	No
ATD_EXEC_DOC_TYPE	sql_variant	NOT NULL	Execution Document Type	Yes	No
ATD_EXEC_DOC_OU	int	NOT NULL	Execution Document OU Instance	Yes	No
ATD_EXEC_DOC_NO	sql_variant	NOT NULL	Execution Document Document Number	Yes	No
ATD_TASK_NO	sql_variant	NOT NULL	Task Number	Yes	No
ATD_TASK_SERIAL_NO	int	NOT NULL	Task Serial Number	Yes	No
ATD_CUSTORDER_OU	int	NOT NULL	Customer Order OU Instance	Yes	No
ATD_CUSTORDER_NO	sql_variant	NOT NULL	Customer Order Number	No	No
ATD_FIN_BOOK	sql_variant	NULL	Finance Book	No	No
ATD_CURRENCY	sql_variant	NOT NULL	Currency	No	No
ATD_INV_BASIS	sql_variant	NULL	Invoice Basis	No	No
ATD_QUOTE_LEVEL	sql_variant	NULL	Quatation Level	No	No
ATD_EXCH_RATE	bigint	NOT NULL	Exchange Rate	No	No
ATD_TASK_STATUS	sql_variant	NOT NULL	Task Status	No	No
ATD_MAT_REV	bigint	NULL	Material Revenue	No	No
ATD_RES_REV	bigint	NULL	Resource Revenue	No	No
ATD_REP_REV	bigint	NULL	Repair Revenue	No	No
ATD_TOT_REV_ORDCURR	bigint	NULL	Total Revenue in Order Currency	No	No
ATD_TOT_REV_BASCURR	bigint	NULL	Total Revenue in Base Currency	No	No
ATD_MAT_COST	bigint	NULL	Material Cost	No	No
ATD_RES_COST	bigint	NULL	Resource Cost	No	No
ATD_TOT_COST	bigint	NULL	Total Cost	No	No
ATD_CUST_ACC_GROUP	sql_variant	NOT NULL	Customer Account Group	No	No
ATD_CUST_NO	sql_variant	NOT NULL	Customer Number	No	No
ATD_COST_CENTER	sql_variant	NULL	Cost Center	No	No
ATD_WORK_CENTER	sql_variant	NULL	Work Center	No	No
ATD_AMENDMENT_NO	int	NULL	Customer Order Amendment Number	No	No

Table Name corder_cedt_certificate_det

Table Comment To Store the Cetificate 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
cedt_timestamp	int	NULL	Timestamp value for concurrence check	No	No
cedt_certi_template	sql_variant	NULL	Certificate template	No	No
cedt_primary	sql_variant	NULL	Primary Combo with values 1 ) Yes 2 ) No.	No	No
cedt_modified_by	sql_variant	NULL	modified by ( user information )	No	No
cedt_created_by	sql_variant	NULL	Created by ( user information )	No	No
cedt_created_date	datetime	NULL	created date	No	No
cedt_modified_date	datetime	NULL	modified date	No	No
cedt_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
cedt_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
cedt_order_ou	int	NOT NULL	Customer order ouinstance	Yes	Yes
cedt_cert_agent	sql_variant	NULL	Certifying Agency with all active Regulatory Authorities defined in interacting Common Master business componen	No	No
cedt_Suppcerti_type	sql_variant	NULL	Supplier Certificate Type combo with the list of certificate types from Logistics Common Master where the Certificate for is Supplier	No	No
cedt_lineno	int	NOT NULL	Running lineno for customer order and amendment number combination .	Yes	No
cedt_Partcerti_type	sql_variant	NULL	Part Certificate Type combo with the list of certificate types from Logistics Common Master where the Certificate for is Part.	No	No

Table Name corder_corh_order_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
corh_order_ou	int	NOT NULL	Customer order ouinstance	Yes	No
corh_order_no	sql_variant	NOT NULL	Customer order number	Yes	No
corh_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	No
corh_desc	sql_variant	NOT NULL	Description of customer order number	No	No
corh_status	sql_variant	NOT NULL	Status of customer order number 1) Fresh 2) Confirmed 3) Cancelled 4) Revoked 5) Authorised 6) Processed 7) Amended 8) Completed 9) Closed	No	No
corh_Invc_status	sql_variant	NOT NULL	Invoice Status 1 ) Not Required 2 ) Pending Invoice 3 ) Partially Invoiced 4 ) Invoiced	No	No
corh_exec_status	sql_variant	NOT NULL	Status of Execution 1 ) Fresh 2 ) Confirmed 3 ) Authorised 4 ) Processed 5 ) Cancelled 6 ) Completed 7 ) Closed	No	No
corh_release_status	sql_variant	NOT NULL	Release Status 1 ) Fresh 2 ) Released 3 ) Returned	No	No
corh_Quot_status	sql_variant	NOT NULL	Quotation Status 1 ) Not Required 2 ) Pending Quote 3 ) Quoted 4 ) Partially Quoted	No	No
corh_Mov_status	sql_variant	NOT NULL	Movement Status 1 ) Received 2 ) Issued for Shipping 3 ) Shipped	No	No
corh_amend_comments	nchar(256)	NULL	Amendment comments	No	No
corh_cust_no	sql_variant	NOT NULL	Customer id	No	No
corh_cust_ou	int	NOT NULL	ouinstance of the customer id , Interaction with the customer component	No	No
corh_delivery_area	sql_variant	NULL	delivery area of the customer order .	No	No
corh_engage_mode	sql_variant	NULL	Engagement type values 1) regular 2) contract	No	No
corh_order_cat	sql_variant	NULL	Order category as defined in the quickcode screen	No	No
corh_user_status	sql_variant	NULL	User status as defined in the quickcode screen	No	No
corh_order_date	datetime	NOT NULL	Customer order date	No	No
corh_order_appl	sql_variant	NOT NULL	Order applicability values 1 ) Aircraft , 2 ) Engine 3 ) Component 4 ) Others	No	No
corh_currency	sql_variant	NULL	Currency information	No	No
corh_order_type	sql_variant	NULL	Order type values 1 ) Regular , 2 ) Prospect 3 ) Bid 4 ) Warranty	No	No
corh_expreceipt_date	datetime	NULL	Expected delivery date of the aircraft	No	No
corh_promdelivery_date	datetime	NULL	Promised delivery date of the aircraft	No	No
corh_priority	int	NULL	Priority Values All active Priority description defined in Priority master under common master component	No	No
corh_wc_capability	sql_variant	NULL	Work center capability Values 1 ) "Required" 2 ) "Not Required".	No	No
corh_po_no	sql_variant	NULL	Purchase order number	No	No
corh_po_date	datetime	NULL	Purchase order Date	No	No
corh_mat_valuelimit	bigint	NULL	Material value limit	No	No
corh_res_valuelimit	bigint	NULL	Resource value limit	No	No
corh_tot_routinehrs	bigint	NULL	Total routine hours Budgeted	No	No
corh_tot_nonroutinehrs	bigint	NULL	Total non-routine hours Budgeted	No	No
corh_tot_labhrs	bigint	NULL	Total Labour hours budgeted	No	No
corh_ord_valuelimit	bigint	NULL	Total order value limit ( PO value )	No	No
corh_ref_quot_no	sql_variant	NULL	Reference Quotation number .	No	No
corh_other_ref	sql_variant	NULL	Other References	No	No
corh_claim_status	sql_variant	NULL	warranty Claim status Values 1 ) "Under Investigation" 2 ) "Claim Accepted" 3 ) "Claim Rejected" 4 ) "Claim Partially Accepted"	No	No
corh_ref_orderno	sql_variant	NULL	Reference customer order number	No	No
corh_warranty_ref	sql_variant	NULL	Warranty reference number	No	No
corh_aud_report	sql_variant	NULL	Audit report Number	No	No
corh_audreport_req	sql_variant	NULL	Audit report required 1 ) Yes 2 ) No	No	No
corh_warranty_remarks	sql_variant	NULL	warranty remarks	No	No
corh_inv_appl	sql_variant	NULL	invoice applicable values 1 ) Yes 2 ) No	No	No
corh_quot_level	sql_variant	NULL	quotation level values 1 ) "Order level" 2 ) "Order-line level" 3 ) "Task level"	No	No
corh_invoice_level	sql_variant	NULL	Invoice level values 1 ) "order level" 2 ) "Task level".	No	No
corh_invoice_basic	sql_variant	NULL	Invoice basic values 1 ) "Actuals" 2 ) "Quote".	No	No
corh_res_pricemethd	sql_variant	NULL	Resource price method values 1 ) "As entered" 2 ) "Service Pricelist" 3 )) "Workunit wise flat".	No	No
corh_mat_pricemethd	sql_variant	NULL	Material price method values 1 ) "Service Pricelist" 2 ) "Part Price List" 3 ) "Workunit wise flat"	No	No
corh_Stdlab_rate	bigint	NULL	Standard labour rate	No	No
corh_serv_pricelist	sql_variant	NULL	Service price list	No	No
corh_Stdfacility_rate	bigint	NULL	Standard Facility rate	No	No
corh_part_pricelist	sql_variant	NULL	Part price list	No	No
corh_total_value	bigint	NULL	Total value of the customer order .This includes Basic value , Additional Basi , addl charges and tcd .	No	No
corh_basic_value	bigint	NULL	Basic value of the customer order . This includes material and resource value of planned workunits .	No	No
corh_Addl_basic_value	bigint	NULL	Additional basic value of the customer order . This includes material and resource value of Unplanned workunits .	No	No
corh_tax	bigint	NULL	Tax value of customer order .	No	No
corh_discount	bigint	NULL	Discount value of customer order .	No	No
corh_remarks	sql_variant	NULL	Remarks	No	No
corh_misc_cost	bigint	NULL	Miscellaneous cost value of customer order.	No	No
corh_charges	bigint	NULL	Charges value of customer order .	No	No
corh_addlncharges	bigint	NULL	Additional charges value of customer order .	No	No
corh_price_uom	sql_variant	NULL	Unit of measurement for price values 1 ) ’Days’ 2 ) ’Weeks’ 3 ) ’Months’	No	No
corh_price_hld_time	bigint	NULL	Price held time	No	No
corh_operator	sql_variant	NULL	Operator code	No	No
corh_cust_rep	sql_variant	NULL	Customer representative	No	No
corh_cust_rep_name	sql_variant	NULL	Customer representative name	No	No
corh_spare_supp_by	sql_variant	NULL	spares supplied by values 1 ) ’Customer’ 2 ) ’Internal’ 3 ) ’Internal & Customer’	No	No
corh_restrict_type	sql_variant	NULL	Restriction type value for parts supplied by 1 ) Include 2 ) exclude	No	No
corh_cust_supp_part_status	sql_variant	NULL	Customer supplied part status	No	No
corh_prefrd_stck_sts	sql_variant	NULL	Preferred stock status values All customer stock status in interacting UDSS component	No	No
corh_pri_part_grp	sql_variant	NULL	Primary Part Group values All controlled part groups of purpose "Product line" defined in Part administration business component	No	No
corh_app_work_scope	sql_variant	NULL	Approval of additional workscope values 1 ) ’Required’, 2 ) ’As Required’ 3 ) ’Not Required’	No	No
corh_cust_inspect	sql_variant	NULL	Customer inspection values 1 ) ’Required’ 2 ) ’Not Required’	No	No
corh_salv_main_core	sql_variant	NULL	Salvage main core values 1 ) MRO 2 ) Operator	No	No
corh_salv_ret_core	sql_variant	NULL	Salvage core returnable at values 1 ) MRO 2 ) Operator	No	No
corh_recv_loc	int	NULL	Receiving location values All the OU Codes of Storage Admin component wherever CGR is Deployed. If CGR is not deployed then all the OU Codes of Storage Admin component wherever Stock Receipt is Deployed	No	No
corh_ship_loc	int	NULL	Shipping location values All the Ous in the Storage Admin where Pack slip is Deployed.	No	No
corh_recv_warehouse	sql_variant	NULL	Receiving Warehouse values All active warehouse defined in Interacting Storage Administration business component	No	No
corh_gen_inst	sql_variant	NULL	General instruction for the customer order .	No	No
corh_file_name	sql_variant	NULL	File name	No	No
corh_ac_reg	sql_variant	NULL	Aircraft regno number	No	No
corh_ac_reg_ou	int	NULL	OU of Aircraft number component	No	No
corh_model_ou	int	NULL	model ouinstance	No	No
corh_model	sql_variant	NULL	Aircraft Model.	No	No
corh_primary_wrkcenter	sql_variant	NOT NULL	Primary work center values All active work centers defined in Work center business component with which the current component interaction is defined &nbspOnly those work centers with work center type as ’Hangar’ or ’Bay’ or ’Others’. Also those work centers whose execution capabilities are identified as ’Hangar’, ’Line’ or ’All’.	No	No
corh_manuf_serial	sql_variant	NULL	Manufacturer Serial	No	No
corh_visit_group	sql_variant	NULL	Visit group values Values of the quick code type "Visit Group" in Active Status defined in the interacting Visit Package component .	No	No
corh_visit_category	sql_variant	NULL	Visit Category values Values of the quick code type "Visit Category" in Active Status defined in the interacting Visit Package component .	No	No
corh_wrkscp_category	sql_variant	NULL	Workscope Category values All Quickcodes of type "Work Scope Category" which are of "Active" status,defined in the Login OU/ in interacting Component Maintenance Planning business component with which the current component interaction is defined.	No	No
corh_cwo_category	sql_variant	NULL	Component Work order category values All Quickcodes of type "Category" which are of "Active" status,defined in the Login OU/ in interacting Component Work Order business component	No	No
corh_ro_priority	sql_variant	NULL	Repair order priority values All values in "Active" status, defined in the Login OU/ in interacting Logistics Common Master business component	No	No
corh_ro_category	sql_variant	NULL	Repair order Category values All Quickcodes of type "Category" which are of "Active" status,defined in the Login OU/ in interacting Logistics Common Master business component	No	No
corh_work_requested	sql_variant	NULL	Work requested	No	No
corh_work_restricted	sql_variant	NULL	Work restricted	No	No
corh_other_inst	sql_variant	NULL	Other Instructions	No	No
corh_object_count	int	NULL	Total Object count	No	No
corh_timestamp	int	NULL	Timestamp value for concurrency check	No	No
corh_quot_routinehrs	bigint	NULL	Quoted Routine hours .	No	No
corh_quot_nonroutinehrs	bigint	NULL	Quoted Non - Routine hours .	No	No
corh_quot_TMat_Price	bigint	NULL	Total Quoted Material price	No	No
corh_quot_TRes_Price	bigint	NULL	Total Quoted Resource price	No	No
corh_quot_other_chrgs	bigint	NULL	Total Quoted other charges	No	No
corh_inv_tmat_Price	bigint	NULL	Total invoiced material price	No	No
corh_inv_tres_Price	bigint	NULL	Total invoiced resource price	No	No
corh_inv_tot_othchrg	bigint	NULL	Total Other changes	No	No
corh_expdelivery_date	datetime	NULL	Expected delivery date .	No	No
corh_quot_TFac_Hrs	bigint	NULL	Total Quoted facility hours	No	No
corh_quot_TLab_Hrs	bigint	NULL	Total Quoted Labour hours	No	No
corh_quot_no	sql_variant	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
corh_quot_revno	sql_variant	NULL	When Re-Quotation happen we will generate a revision number for the quotation that is created for the customer order .	No	No
corh_portal_comments	sql_variant	NULL	Portal Comments	No	No
corh_percent_completion	int	NULL	Percentage Completion of works for the customer order .	No	No
corh_quot_part_comments	nchar(256)	NULL	Order level part comments	No	No
corh_created_by	sql_variant	NULL	customer order created by user	No	No
corh_created_date	datetime	NULL	Created date and time of the customer order	No	No
corh_modified_by	sql_variant	NULL	customer order modified by user	No	No
corh_modified_date	datetime	NULL	Modified date and time of the customer order	No	No
corh_authorised_by	sql_variant	NULL	Authorised by user	No	No
corh_authorised_date	datetime	NULL	Authorised date and time of the customer order	No	No
corh_quot_ch_status	sql_variant	NULL	corh_quot_ch_status	No	No
CORH_EXECUTE_THROUGH	sql_variant	NULL	CORH_EXECUTE_THROUGH	No	No
CORDER_CORH_ORDER_HDR	sql_variant	NULL	CORDER_CORH_ORDER_HDR	No	No
CORH_PACKAGE_CATEGORY	sql_variant	NULL	CORH_PACKAGE_CATEGORY	No	No

Table Name corder_hisadd_address

Table Comment To Store the address details history of customer order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
hisadd_ship_cont_person	sql_variant	NULL	Contact person in the Shipping address	No	No
hisadd_ship_phone	sql_variant	NULL	Phone number of the Shipping address	No	No
hisadd_ship_email	sql_variant	NULL	Email id of the Contact person in the shipping address.	No	No
hisadd_ship_address	sql_variant	NULL	Shipping address of the customer order	No	No
hisadd_ship_to_add	sql_variant	NULL	Ship to address	No	No
hisadd_ship_cust_ou	int	NULL	%AttDef	No	No
hisadd_created_date	datetime	NULL	Created date	No	No
hisadd_modified_by	sql_variant	NULL	Modified by ( user information )	No	No
hisadd_ship_fax	sql_variant	NULL	Fax number of the shipping address	No	No
hisadd_created_by	sql_variant	NULL	Created by ( user information )	No	No
hisadd_timestamp	int	NULL	Timestamp value for concurrence check	No	No
hisadd_modified_date	datetime	NULL	modified date	No	No
hisadd_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
hisadd_bill_cust	sql_variant	NULL	Bill to customer combo values Accepted values : Customer # who are identified as Bill to customers or both Bill To and Ship To Customers in the customer relationship page of &nbspcustomer component .	No	No
hisadd_bill_cust_ou	int	NULL	%AttDef	No	No
hisadd_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
hisadd_order_ou	int	NOT NULL	Customer order OU Instance	Yes	Yes
hisadd_ship_cust	sql_variant	NULL	Ship to customer combo values All the Customer # who are identified as Ship to customers or both Bill To and Ship To Customers in the customer relationship page of &nbspcustomer component .	No	No
hisadd_bill_email	sql_variant	NULL	Email id of the Contact person in the billing address .	No	No
hisadd_bill_fax	sql_variant	NULL	Fax number of the billing address	No	No
hisadd_bill_to_add	sql_variant	NULL	Bill to Address values	No	No
hisadd_bill_address	sql_variant	NULL	Billing address of the customer order	No	No
hisadd_bill_phone	sql_variant	NULL	Phone number of the billing address	No	No
hisadd_bill_cont_person	sql_variant	NULL	Contact person in the billing address	No	No

Table Name corder_hiscedt_certificate_det

Table Comment To Store the Cetificate details history of customer order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
hiscedt_timestamp	int	NULL	Timestamp value for concurrence check	No	No
hiscedt_certi_template	sql_variant	NULL	Certificate template	No	No
hiscedt_primary	sql_variant	NULL	Primary Combo with values 1 ) Yes 2 ) No.	No	No
hiscedt_modified_by	sql_variant	NULL	modified by ( user information )	No	No
hiscedt_created_by	sql_variant	NULL	Created by ( user information )	No	No
hiscedt_created_date	datetime	NULL	created date	No	No
hiscedt_modified_date	datetime	NULL	modified date	No	No
hiscedt_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
hiscedt_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
hiscedt_order_ou	int	NOT NULL	Customer order OU Instance	Yes	Yes
hiscedt_cert_agent	sql_variant	NULL	Certifying Agency with all active Regulatory Authorities defined in interacting Common Master business component	No	No
hiscedt_Suppcerti_type	sql_variant	NULL	Supplier Certificate Type combo with the list of certificate types from Logistics Common Master where the Certificate for is Supplier	No	No
hiscedt_lineno	int	NOT NULL	Running lineno for customer order and amendment number combination .	Yes	No
hiscedt_Partcerti_type	sql_variant	NULL	Part Certificate Type combo with the list of certificate types from Logistics Common Master where the Certificate for is Part.	No	No

Table Name corder_hismd_material_dtl

Table Comment To store the part details history of all workunits of customer order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
hismd_Embodiment_Fee	bigint	NULL	Embodiment fee for the part	No	No
hismd_standardCost	bigint	NULL	standard cost for the part	No	No
hismd_Remarks	sql_variant	NULL	remarks	No	No
hismd_pricelist	sql_variant	NULL	hismd_pricelist	No	No
hismd_Unit_Price	sql_variant	NULL	Unit price of the part	No	No
hismd_stockuom	sql_variant	NULL	hismd_stockuom	No	No
hismd_Actual_UnitPrice	bigint	NULL	Actual unit price	No	No
hismd_Amount_ToBe	bigint	NULL	hismd_Amount_ToBe	No	No
hismd_Quote_Status	sql_variant	NULL	Quotation status of the part	No	No
hismd_consumedQty	bigint	NULL	consumed quantity	No	No
hismd_Actual_IssueCost	bigint	NULL	Actual issue cost	No	No
hismd_BillableQty	bigint	NULL	Billable quantity	No	No
hismd_InvoiceStatus	sql_variant	NULL	Invoice status of the part	No	No
hismd_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
hismd_ref_line_no	int	NOT NULL	Running line number for customer order and amendment number combination	Yes	Yes
hismd_task_line_no	int	NOT NULL	Running line number for customer order , amendment number and wout_ref_line_no combination	Yes	Yes
hismd_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
hismd_order_ou	int	NOT NULL	Customer order OU Instance	Yes	Yes
hismd_unitofmeasurement	sql_variant	NULL	unit of measurement for the part	No	No
hismd_suppliedby	sql_variant	NULL	hismd_suppliedby	No	No
hismd_Quantity	bigint	NULL	part quantity	No	No
hismd_Part_No	sql_variant	NOT NULL	Part number	Yes	No
hismd_part_ou	int	NULL	%AttDef	No	No
hismd_stckstatus	sql_variant	NULL	hismd_stckstatus	No	No
hismd_RevisionNo	int	NULL	Part revision number	No	No

Table Name corder_hisobj_wrkunit_dtls

Table Comment To store the workunit and object details history 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
histhdr_order_ou	int	NOT NULL	Customer order OU Instance	Yes	Yes
histhdr_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
histhdr_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
hisobj_line_no	int	NOT NULL	Running line number for customer order and amendment number combination	Yes	No
hisobj_wrkunit_lineno	int	NULL	Line number of each distinct workunit .	No	No
hisobj_WorkRequest	sql_variant	NULL	hisobj_WorkRequest	No	No
hisobj_wrkunit_ou	int	NULL	Workunit ouinstance	No	No
hisobj_wrkunit_code	sql_variant	NULL	Workunit code	No	No
hisobj_wrkunit_type	sql_variant	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
hisobj_exec_status	sql_variant	NULL	Workunit status .. 1 ) Processed 2 ) Released 3 ) Inprogress 4 ) Completed 5 ) Closed	No	No
hisobj_invi_status	sql_variant	NULL	Invoice status .. 1 ) Pending Lobour Invoice 2 ) Pending Labour and Material Invoice 3 ) Pending Material Invoice 4 ) Pending Release 5 ) Pending Material Invoice Confirmal 6 ) Released	No	No
hisobj_Quot_status	sql_variant	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
hisobj_plan_status	sql_variant	NULL	Planning status of the workunit 1 ) Planned 2 ) Unplanned	No	No
hisobj_wrkunit_revno	sql_variant	NULL	Workunit revision number	No	No
hisobj_rp_code	sql_variant	NULL	Repair process code	No	No
hisobj_mnt_type	sql_variant	NULL	Maintenance type values 1 ) Overhaul 2 ) Repair 3 ) Inspection 4 ) Others	No	No
hisobj_task_card	sql_variant	NULL	Customer task card	No	No
hisobj_billable	sql_variant	NULL	Billable values 1 ) Yes 2 ) No	No	No
hisobj_ammcmm_item_no	sql_variant	NULL	Manual item number	No	No
hisobj_description	sql_variant	NULL	WorkUnit Description	No	No
hisobj_est_reqd	sql_variant	NULL	Estimation required values 1 ) Yes 2 ) No	No	No
hisobj_est_man_hrs	bigint	NULL	Estimated man hours	No	No
hisobj_nr_man_hrs	bigint	NULL	Non routine estimated man hours	No	No
hisobj_tot_res_price	bigint	NULL	Total estimated resource price	No	No
hisobj_tot_mtr_price	bigint	NULL	Total estimated material price	No	No
hisobj_mtr_price	bigint	NULL	hisobj_mtr_price	No	No
hisobj_embodiment_fee	bigint	NULL	Embodiment fee	No	No
hisobj_misc_cost	bigint	NULL	Miscellaneous cost	No	No
hisobj_est_total	bigint	NULL	Estimated total	No	No
hisobj_remarks	sql_variant	NULL	Remarks for the workunit	No	No
hisobj_part_lineno	int	NULL	Line number of each distinct part and serial number .	No	No
hisobj_partno	sql_variant	NULL	Part number	No	No
hisobj_part_ou	int	NULL	%AttDef	No	No
hisobj_cust_partno	sql_variant	NULL	Customer Part number	No	No
hisobj_part_serialno	sql_variant	NULL	Part serial number	No	No
hisobj_Mov_Status	sql_variant	NULL	Movement Status 1 ) Received 2 ) Issued for Shipping 3 ) Shipped	No	No
hisobj_lot_no	sql_variant	NULL	Lot number	No	No
hisobj_part_qty	bigint	NULL	Part quantity	No	No
hisobj_jobtype	sql_variant	NULL	Shop Job type values 1 ) "Make Job" 2 ) "Piece Job"	No	No
hisobj_stck_status	sql_variant	NULL	stock status values All customer stock status in interacting UDSS component	No	No
hisobj_exec_facility	sql_variant	NULL	Execution facility values 1 ) ’External’ 2 ) ’Internal’	No	No
hisobj_exec_loc	sql_variant	NULL	Execution Location values All the Work Centers OUs which are interacting with the self interacting set of aircraft components with which this component in the login OU is interacting.	No	No
hisobj_prt_remarks	sql_variant	NULL	hisobj_prt_remarks	No	No
hisobj_workcenter	sql_variant	NULL	Work center values All the active Work Centers defined in Interacting Work center component with which the current component interaction is defined and mapped to login user. &nbspLoad only those work centers with work center type as ’Hangar’ or ’Bay’ or ’Others’. Also load those work centers whose execution capabilities are identified as ’Hangar’, ’Line’ or ’All’.	No	No
hisobj_ro_location	int	NULL	Repair order location values All the Repair Order Ous where repair Order Component is deployed and the interaction is defined with the current business component exists.	No	No
hisobj_repair_shop	sql_variant	NULL	Repair shop code	No	No
hisobj_salvage_value	bigint	NULL	salvage value	No	No
hisobj_position_code	sql_variant	NULL	position code	No	No
hisobj_level_code	sql_variant	NULL	level code	No	No
hisobj_execu_doc_no	sql_variant	NULL	Execution order number (unplanned )	No	No
hisobj_execu_doc_type	sql_variant	NULL	Execution type	No	No
hisobj_execu_loc	int	NULL	%AttDef	No	No
hisobj_ac_reg	sql_variant	NULL	Aircraft number	No	No
hisobj_ac_reg_ou	int	NULL	OU of Aircraft number component	No	No
hisobj_model_ou	int	NULL	%AttDef	No	No
hisobj_model	sql_variant	NULL	Model of aircraft	No	No
hisobj_Addl_plnend_date	datetime	NULL	Planned end date of additional workunit	No	No
hisobj_Addl_plnstart_date	datetime	NULL	Planned start date of additional workunit	No	No
hisobj_Addl_Aut_stat	sql_variant	NULL	Additional workunit Authorization status 1 ) Pending customer authorization 2 ) Approve additional work 3 ) Reject additional work 4 ) Reject Quote	No	No
hisobj_Addl_Aut_refno	sql_variant	NULL	Authorization reference document number ( Customer reference document )	No	No
hisobj_Addl_Aut_Date	datetime	NULL	Authorization date ( Customer authorised date )	No	No
hisobj_Addl_Autby	sql_variant	NULL	Authorised by ( Internal Supervisor )	No	No
hisobj_Addl_Autorized_date	datetime	NULL	Authorised date ( Internal Supervisor authorised date )	No	No
hisobj_Addl_comments	sql_variant	NULL	Comments	No	No
hisobj_quot_revno	int	NULL	Quotation revision number	No	No
hisobj_actual_hr	bigint	NULL	%AttDef	No	No
hisobj_billable_hr	bigint	NULL	Billable hours	No	No
hisobj_invoiced_hr	bigint	NULL	Invoiced hours	No	No
hisobj_billable_labprice	bigint	NULL	Billable labour price	No	No
hisobj_billable_facprice	bigint	NULL	Billable Facility price	No	No
hisobj_billable_matprice	bigint	NULL	Billable Material price	No	No
hisobj_billable_miscost	numeric(28,8)	NULL	%AttDef	No	No
hisobj_created_by	sql_variant	NULL	Created by ( user id )	No	No
hisobj_created_date	datetime	NULL	Created date of the information	No	No
hisobj_modified_by	sql_variant	NULL	modified by ( user id )	No	No
hisobj_modified_date	datetime	NULL	Modified date of the information	No	No
HISOBJ_REL_TASK_COUNT	int	NULL	HISOBJ_REL_TASK_COUNT	No	No
HISOBJ_APPLICAB_GRP	int	NULL	HISOBJ_APPLICAB_GRP	No	No

Table Name corder_hispspc_prtsupp_cust

Table Comment To Store the part details history of customer order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
hispspc_timestamp	int	NULL	Timestamp value for concurrence check	No	No
hispspc_remarks	sql_variant	NULL	Remarks for part and customer part details	No	No
hispspc_repln_policy	sql_variant	NULL	Replenishment Policy with the values 1 ) Periodically 2 ) Order Based	No	No
hispspc_modified_by	sql_variant	NULL	modified by (user information )	No	No
hispspc_created_by	sql_variant	NULL	created by (user information )	No	No
hispspc_created_date	datetime	NULL	created date	No	No
hispspc_modified_date	datetime	NULL	modified date	No	No
hispspc_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
hispspc_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
hispspc_order_ou	int	NOT NULL	Customer order OU Instance	Yes	Yes
hispspc_cust_part_no	sql_variant	NULL	Customer Part no	No	No
hispspc_part_no	sql_variant	NULL	Part no	No	No
hispspc_lineno	int	NOT NULL	Running lineno for customer order and amendment number combination	Yes	No
hispspc_part_ou	int	NULL	%AttDef	No	No

Table Name corder_hisrd_resource_dtl

Table Comment To store the resource details history of customer order .
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
hisrd_Billable_hrs	bigint	NULL	Billable hours	No	No
hisrd_Est_no	bigint	NULL	Estimated number	No	No
hisrd_Resource_type	varchar(25)	NULL	%AttDef	No	No
hisrd_NonBillable_hrs	bigint	NULL	Non-Billable hours	No	No
hisrd_ResourceRate_perhr	bigint	NULL	Resource rate per hour	No	No
hisrd_pricelist	sql_variant	NULL	hisrd_pricelist	No	No
hisrd_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
hisrd_order_ou	int	NOT NULL	Customer order OU Instance	Yes	Yes
hisrd_Resource_code	sql_variant	NOT NULL	Resource number	Yes	No
hisrd_task_line_no	int	NOT NULL	Running line number for customer order , amendment number and wout_ref_line_no combination	Yes	Yes
hisrd_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
hisrd_ref_line_no	int	NOT NULL	Running line number for customer order and amendment number combination	Yes	Yes

Table Name corder_histcin_tcd_info

Table Comment To Store the tax , charge and discount history 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
histcin_billable	sql_variant	NULL	Billable combo with the values 1 ) Yes 2 ) No	No	No
histcin_pay_to_supp	sql_variant	NULL	Supplier code	No	No
histcin_tcd_amount	bigint	NULL	TCD amount	No	No
histcin_currency	sql_variant	NULL	Currency code	No	No
histcin_modified_by	sql_variant	NULL	modified by ( user information )	No	No
histcin_timestamp	int	NULL	Timestamp value for concurrence check .	No	No
histcin_created_date	datetime	NULL	Created date	No	No
histcin_created_by	sql_variant	NULL	Created by ( user information )	No	No
histcin_modified_date	datetime	NULL	modified date	No	No
histcin_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
histcin_ApplOn	sql_variant	NOT NULL	Taxes , charges and discount applicable on 1 )Order Level 2 ) Labor 3 )Material	Yes	No
histcin_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
histcin_order_ou	int	NOT NULL	histcin_order_ou	Yes	Yes
histcin_tcd_rate	bigint	NULL	Tax , charge and discount rate .	No	No
histcin_variant_no	sql_variant	NULL	Tax , charge and discount number variant , which is defined in the TCD master component .	No	No
histcin_line_no	int	NOT NULL	Running lineno for customer order and amendment combination	Yes	No
histcin_tcd_no	sql_variant	NULL	Tax , charge and discount number , which is defined in the TCD master component .	No	No
histcin_tcd_ou	int	NULL	%AttDef	No	No

Table Name corder_histhdr_corh_order

Table Comment To Store the history of customer order header details .
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
histhdr_order_ou	int	NOT NULL	Customer order OU Instance	Yes	No
histhdr_order_no	sql_variant	NOT NULL	Customer order number	Yes	No
histhdr_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	No
histhdr_desc	sql_variant	NOT NULL	Description of customer order number	No	No
histhdr_status	sql_variant	NOT NULL	Status of customer order number 1) Fresh 2) Confirmed 3) Cancelled 4) Revoked 5) Authorised 6) Processed 7) Amended 8) Completed 9) Closed	No	No
histhdr_Invc_status	sql_variant	NOT NULL	Invoice Status 1 ) Not Required 2 ) Pending Invoice 3 ) Partially Invoiced 4 ) Invoiced	No	No
histhdr_exec_status	sql_variant	NOT NULL	Status of Execution 1 ) Fresh 2 ) Confirmed 3 ) Authorised 4 ) Processed 5 ) Cancelled 6 ) Completed 7 ) Closed	No	No
histhdr_release_status	sql_variant	NOT NULL	Release Status 1 ) Fresh 2 ) Released 3 ) Returned	No	No
histhdr_Quot_status	sql_variant	NOT NULL	Quotation Status 1 ) Not Required 2 ) Pending Quote 3 ) Quoted	No	No
histhdr_Mov_status	sql_variant	NOT NULL	Movement Status 1 ) Received 2 ) Issued for Shipping 3 ) Shipped	No	No
histhdr_amend_comments	nchar(256)	NULL	histhdr_amend_comments	No	No
histhdr_cust_no	sql_variant	NOT NULL	Customer id	No	No
histhdr_cust_ou	int	NOT NULL	%AttDef	No	No
histhdr_delivery_area	sql_variant	NULL	delivery area of the aircraft	No	No
histhdr_engage_mode	sql_variant	NULL	Engagement type values 1) regular 2) contract	No	No
histhdr_order_cat	sql_variant	NULL	Order category as defined in the quickcode screen	No	No
histhdr_user_status	sql_variant	NULL	User status as defined in the quickcode screen	No	No
histhdr_order_date	datetime	NULL	Customer order date	No	No
histhdr_order_appl	sql_variant	NULL	Order applicability values 1 ) Aircraft , 2 ) Engine 3 ) Component 4 ) Others	No	No
histhdr_currency	sql_variant	NULL	Currency information	No	No
histhdr_order_type	sql_variant	NULL	Order type values 1 ) Regular , 2 ) Prospect 3 ) Bid 4 ) Warranty	No	No
histhdr_expreceipt_date	datetime	NULL	Expected delivery date of the aircraft	No	No
histhdr_promdelivery_date	datetime	NULL	Promised delivery date of the aircraft	No	No
histhdr_priority	int	NULL	Priority Values All active Priority description defined in Priority master under common master component	No	No
histhdr_wc_capability	sql_variant	NULL	Work center capability Values 1 ) "Required" 2 ) "Not Required".	No	No
histhdr_po_no	sql_variant	NULL	Purchase order number	No	No
histhdr_po_date	datetime	NULL	Purchase order Date	No	No
histhdr_mat_valuelimit	bigint	NULL	Material value limit	No	No
histhdr_res_valuelimit	bigint	NULL	Resource value limit	No	No
histhdr_tot_routinehrs	bigint	NULL	Total routine hours Budgeted	No	No
histhdr_tot_nonroutinehrs	bigint	NULL	Total non-routine hours Budgeted	No	No
histhdr_tot_labhrs	bigint	NULL	Total Labour hours budgeted	No	No
histhdr_ord_valuelimit	bigint	NULL	Total order value limit	No	No
histhdr_ref_quot_no	sql_variant	NULL	Reference Quotation number at the time of customer order	No	No
histhdr_other_ref	sql_variant	NULL	Other References	No	No
histhdr_claim_status	sql_variant	NULL	warranty Claim status Values 1 ) "Under Investigation" 2 ) "Claim Accepted" 3 ) "Claim Rejected" 4 ) "Claim Partially Accepted"	No	No
histhdr_ref_orderno	sql_variant	NULL	Reference customer order number	No	No
histhdr_warranty_ref	sql_variant	NULL	Warranty reference number	No	No
histhdr_aud_report	sql_variant	NULL	Audit report Number	No	No
histhdr_audreport_req	sql_variant	NULL	Audit report required 1 ) Yes 2 ) No	No	No
histhdr_warranty_remarks	sql_variant	NULL	warranty remarks	No	No
histhdr_inv_appl	sql_variant	NULL	invoice applicable values 1 ) Yes 2 ) No	No	No
histhdr_quot_level	sql_variant	NULL	quotation level values 1 ) "Order level" 2 ) "Order-line level" 3 ) "Task level"	No	No
histhdr_invoice_level	sql_variant	NULL	Invoice level values 1 ) "order level" 2 ) "Task level".	No	No
histhdr_invoice_basic	sql_variant	NULL	Invoice basic values 1 ) "Actuals" 2 ) "Quote".	No	No
histhdr_res_pricemethd	sql_variant	NULL	Resource price method values 1 ) "As entered" 2 ) "Service Pricelist" 3 )) "Workunit wise flat".	No	No
histhdr_mat_pricemethd	sql_variant	NULL	Material price method values 1 ) "Service Pricelist" 2 ) "Part Price List" 3 ) "Workunit wise flat"	No	No
histhdr_Stdlab_rate	bigint	NULL	Standard labour rate	No	No
histhdr_serv_pricelist	sql_variant	NULL	Service price list	No	No
histhdr_Stdfacility_rate	bigint	NULL	Standard Facility rate	No	No
histhdr_part_pricelist	sql_variant	NULL	Part price list	No	No
histhdr_total_value	bigint	NULL	Total value	No	No
histhdr_basic_value	bigint	NULL	Basic value	No	No
histhdr_Addl_basic_value	bigint	NULL	Additional basic value ..	No	No
histhdr_tax	bigint	NULL	Tax value	No	No
histhdr_discount	bigint	NULL	Discount value	No	No
histhdr_remarks	sql_variant	NULL	Remarks	No	No
histhdr_misc_cost	bigint	NULL	Miscellaneous cost	No	No
histhdr_charges	bigint	NULL	Total amount	No	No
histhdr_price_uom	sql_variant	NULL	Unit of measurement for price values 1 ) ’Days’ 2 ) ’Weeks’ 3 ) ’Months’	No	No
histhdr_price_hld_time	bigint	NULL	Price held time	No	No
histhdr_operator	sql_variant	NULL	Operator	No	No
histhdr_cust_rep	sql_variant	NULL	Customer representative	No	No
histhdr_cust_rep_name	sql_variant	NULL	histhdr_cust_rep_name	No	No
histhdr_spare_supp_by	sql_variant	NULL	spares supplied by values 1 ) ’Customer’ 2 ) ’Internal’ 3 ) ’Internal & Customer’	No	No
histhdr_restrict_type	sql_variant	NULL	Restriction type value for parts supplied by 1 ) Include 2 ) exclude	No	No
histhdr_supp_part_status	sql_variant	NULL	histhdr_supp_part_status	No	No
histhdr_prefrd_stck_sts	sql_variant	NULL	Preferred stock status values All customer stock status in interacting UDSS component	No	No
histhdr_pri_part_grp	sql_variant	NULL	Primary Part Group values All controlled part groups of purpose "Product line" defined in Part administration business component	No	No
histhdr_app_work_scope	sql_variant	NULL	Approval of additional workscope values 1 ) ’Required’, 2 ) ’As Required’ 3 ) ’Not Required’	No	No
histhdr_cust_inspect	sql_variant	NULL	Customer inspection values 1 ) ’Required’ 2 ) ’Not Required’	No	No
histhdr_salv_main_core	sql_variant	NULL	Salvage main core values 1 ) MRO 2 ) Operator	No	No
histhdr_salv_ret_core	sql_variant	NULL	Salvage core returnable at values 1 ) MRO 2 ) Operator	No	No
histhdr_recv_loc	int	NULL	%AttDef	No	No
histhdr_ship_loc	int	NULL	histhdr_ship_loc	No	No
histhdr_recv_warehouse	sql_variant	NULL	Receiving Warehouse values All active warehouse defined in Interacting Storage Administration business component	No	No
histhdr_gen_inst	sql_variant	NULL	General instructions	No	No
histhdr_file_name	sql_variant	NULL	File name	No	No
histhdr_ac_reg	sql_variant	NULL	Aircraft number	No	No
histhdr_ac_reg_ou	int	NULL	%AttDef	No	No
histhdr_model_ou	int	NULL	histhdr_model_ou	No	No
histhdr_model	sql_variant	NULL	Model	No	No
histhdr_primary_wrkcenter	sql_variant	NULL	Primary work center values All active work centers defined in Work center business component with which the current component interaction is defined &nbspOnly those work centers with work center type as ’Hangar’ or ’Bay’ or ’Others’. Also those work centers whose execution capabilities are identified as ’Hangar’, ’Line’ or ’All’.	No	No
histhdr_manuf_serial	sql_variant	NULL	Manufacturer Serial	No	No
histhdr_visit_group	sql_variant	NULL	Visit group values Values of the quick code type "Visit Group" in Active Status defined in the interacting Visit Package component .	No	No
histhdr_visit_category	sql_variant	NULL	Visit Category values Values of the quick code type "Visit Category" in Active Status defined in the interacting Visit Package component .	No	No
histhdr_wrkscp_category	sql_variant	NULL	Workscope Category values All Quickcodes of type "Work Scope Category" which are of "Active" status,defined in the Login OU/ in interacting Component Maintenance Planning business component with which the current component interaction is defined.	No	No
histhdr_cwo_category	sql_variant	NULL	Component Work order category values All Quickcodes of type "Category" which are of "Active" status,defined in the Login OU/ in interacting Component Work Order business component	No	No
histhdr_ro_priority	sql_variant	NULL	Repair order priority values All values in "Active" status, defined in the Login OU/ in interacting Logistics Common Master business component	No	No
histhdr_ro_category	sql_variant	NULL	Repair order Category values All Quickcodes of type "Category" which are of "Active" status,defined in the Login OU/ in interacting Logistics Common Master business component	No	No
histhdr_work_requested	sql_variant	NULL	Work requested	No	No
histhdr_work_restricted	sql_variant	NULL	Work restricted	No	No
histhdr_other_inst	sql_variant	NULL	Other Instructions	No	No
histhdr_object_count	int	NULL	Total Object count	No	No
histhdr_timestamp	int	NULL	Timestamp value for concurrency check	No	No
histhdr_quot_routinehrs	bigint	NULL	Quoted Routine hours .	No	No
histhdr_quot_nonroutinehrs	bigint	NULL	Quoted Non - Routine hours .	No	No
histhdr_quot_TMat_Price	bigint	NULL	Total Quoted Material price	No	No
histhdr_quot_TRes_Price	bigint	NULL	Total Quoted Resource price	No	No
histhdr_quot_other_chrgs	bigint	NULL	histhdr_quot_other_chrgs	No	No
histhdr_inv_tmat_Price	bigint	NULL	Total invoiced material price	No	No
histhdr_inv_tres_Price	bigint	NULL	Total invoiced resource price	No	No
histhdr_inv_tot_othchrg	bigint	NULL	histhdr_inv_tot_othchrg	No	No
histhdr_expdelivery_date	datetime	NULL	histhdr_expdelivery_date	No	No
histhdr_quot_TFac_Hrs	bigint	NULL	Total Quoted facility hours	No	No
histhdr_quot_TLab_Hrs	bigint	NULL	Total Quoted Labour hours	No	No
histhdr_quot_no	sql_variant	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
histhdr_quot_revno	sql_variant	NULL	When pRe-Quotation happen we will generate a revision number for the quotation that is created for the customer order .	No	No
histhdr_portal_comments	sql_variant	NULL	Portal Comments	No	No
histhdr_percent_completion	int	NULL	Percentage Completion	No	No
histhdr_quot_part_comments	nchar(256)	NULL	Order level part comments	No	No
histhdr_created_by	sql_variant	NULL	customer order created by user	No	No
histhdr_created_date	datetime	NULL	Created date and time of the customer order	No	No
histhdr_modified_by	sql_variant	NULL	customer order modified by user	No	No
histhdr_modified_date	datetime	NULL	Modified date and time of the customer order	No	No
histhdr_authorised_by	sql_variant	NULL	Authorised by user	No	No
histhdr_authorised_date	datetime	NULL	Authorised date and time of the customer order	No	No
HISTHDR_EXECUTE_THROUGH	sql_variant	NULL	HISTHDR_EXECUTE_THROUGH	No	No
HISTHDR_PACKAGE_TYPE	sql_variant	NULL	HISTHDR_PACKAGE_TYPE	No	No
HISTHDR_PACKAGE_CATEGORY	sql_variant	NULL	HISTHDR_PACKAGE_CATEGORY	No	No

Table Name corder_histrcd_terms_condns

Table Comment To store the terms and condition history of &nbspcustomer order .
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
histrcd_core_pack_code	sql_variant	NULL	Packaging code of core	No	No
histrcd_core_trans_mode	sql_variant	NULL	Transportation Mode of core	No	No
histrcd_serv_ship_label	sql_variant	NULL	Shipping label of serviceable component	No	No
histrcd_spare_trans_mode	sql_variant	NULL	Transportation Mode of spare	No	No
histrcd_core_freight_term	sql_variant	NULL	freight term of core	No	No
histrcd_core_ship_label	sql_variant	NULL	Shipping label core	No	No
histrcd_spare_pack_code	sql_variant	NULL	Packaging code of spare	No	No
histrcd_pack_notes	sql_variant	NULL	Packaging notes	No	No
histrcd_freight_amount	bigint	NULL	Freight amount	No	No
histrcd_serv_freight_term	sql_variant	NULL	freight term of serviceable component	No	No
histrcd_serv_pack_code	sql_variant	NULL	Packaging code of Serviceable Component	No	No
histrcd_ship_notes	sql_variant	NULL	Shipping notes	No	No
histrcd_serv_trans_mode	sql_variant	NULL	Transportation Mode of Serviceable Component	No	No
histrcd_freight_billable	sql_variant	NULL	Freight Billable combo with values 1 ) Yes 2 ) No	No	No
histrcd_timestamp	int	NULL	timestamp value for concurrency check .	No	No
histrcd_AgreeDtls	sql_variant	NULL	Agreement details	No	No
histrcd_WarrTerms	sql_variant	NULL	warranty terms	No	No
histrcd_modified_by	sql_variant	NULL	modified by ( user name )	No	No
histrcd_created_by	sql_variant	NULL	Created by ( user name )	No	No
histrcd_created_date	datetime	NULL	Created date of the record	No	No
histrcd_spare_freight_term	sql_variant	NULL	freight term of spare	No	No
histrcd_fwd_covappl	sql_variant	NULL	Forward cover applicability values 1 ) Yes 2 ) No	No	No
histrcd_fwd_rate	bigint	NULL	Forward rate	No	No
histrcd_spare_ship_label	sql_variant	NULL	Shipping label spare	No	No
histrcd_Warrty_RefNo	sql_variant	NULL	warranty reference number	No	No
histrcd_Warr_FrmDate	datetime	NULL	warranty from date	No	No
histrcd_Warrty_PrdDays	bigint	NULL	warranty period days	No	No
histrcd_Wrnty_ExpDt	datetime	NULL	warranty expire date	No	No
histrcd_modified_date	datetime	NULL	modified date of the record	No	No
histrcd_allow_ship	sql_variant	NULL	Allow Shipping combo values 1) Before Payment Receipt" 2 ) After Payment Receipt	No	No
histrcd_Init_Invat	sql_variant	NULL	Initiate Invoicing At combo values 1 ) "Task Closure", 2 ) "Order Closure" 3 ) "Work Completion".	No	No
histrcd_ord_settle	sql_variant	NULL	Order settlement combo values 1 ) "Single" 2 ) "Multiple"	No	No
histrcd_pay_term	sql_variant	NULL	Pay term value	No	No
histrcd_rcpt_method	sql_variant	NULL	Receipt Method combo values 1 ) Regular 2 ) ESR 3 ) ESR Plus 4 ) LSV 5 ) Specific Bank	No	No
histrcd_rcpt_mode	sql_variant	NULL	Receipt mode values	No	No
histrcd_insurance_liable	sql_variant	NULL	Insurance Liability combo values 1 ) Self 2 ) Customer 3 )None	No	No
histrcd_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
histrcd_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
histrcd_order_ou	int	NOT NULL	Customer order OU Instance	Yes	Yes
histrcd_file_name	sql_variant	NULL	To capture File name	No	No
histrcd_gta_remarks	sql_variant	NULL	GTA Remarks is captured	No	No
histrcd_gta_ref	sql_variant	NULL	General terms agreement reference number .	No	No
histrcd_ref_doc_date	datetime	NULL	GTA Reference document date .	No	No
histrcd_port_of_dest	sql_variant	NULL	Port of destination	No	No
histrcd_remarks	sql_variant	NULL	Remarks of advance payment terms	No	No
histrcd_action	sql_variant	NULL	Action On Non Payment combo values 1 ) Hold Order Processing 2 ) Hold Release of Work 3 ) None	No	No
histrcd_dd_charges_by	sql_variant	NULL	DD Charges Borne by combo values 1 ) Customer 2 ) Self 3 ) None	No	No
histrcd_port_of_dept	sql_variant	NULL	Port of departure	No	No
histrcd_inco_term	sql_variant	NULL	INCO term combo .	No	No
histrcd_carrier	sql_variant	NULL	Carrier code	No	No
histrcd_insurance_amount	bigint	NULL	Insurance amount value	No	No
histrcd_advance_appl	sql_variant	NULL	Advance Applicable combo values 1 ) Yes 2 ) No	No	No
histrcd_advance_date	datetime	NULL	Advance payable by date	No	No
histrcd_insurance_terms	sql_variant	NULL	Insurance terms	No	No
histrcd_advance_tol_perc	bigint	NULL	Advance tolerance percentage	No	No
histrcd_advance_payable	sql_variant	NULL	Advance payable	No	No
histrcd_advance_perc	bigint	NULL	Percentage of advance payable	No	No
histrcd_advance_perc_on	sql_variant	NULL	Advance Percent On combo values 1 ) Total Value 2 ) Basic Value	No	No

Table Name corder_hiswunit_task_det

Table Comment To store the history of workunit breakup information , that is the task level information of a workunit .
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
hiswout_order_ou	int	NOT NULL	Customer order OU Instance	Yes	Yes
hiswout_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
hiswout_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
hiswout_ref_line_no	int	NOT NULL	Running line number for customer order and amendment number combination	Yes	Yes
hiswout_task_line_no	int	NOT NULL	Running line number for customer order , amendment number and wout_ref_line_no combination	Yes	No
hiswout_parent_wu_lineno	int	NOT NULL	Reference lineno for column "obj_wrkunit_lineno" &nbspin "corder_obj_wrkunit_dtls" table .	No	No
hiswout_parent_wu_ou	int	NULL	Ouinstance of the workunit	No	No
hiswout_parent_wu_no	sql_variant	NULL	Reference number for column "obj_wrkunit_code " &nbspin "corder_obj_wrkunit_dtls" table .	No	No
hiswout_parent_wu_type	sql_variant	NULL	Reference type for column "obj_wrkunit_type" in "corder_obj_wrkunit_dtls" table .	No	No
hiswout_wrkpckage	sql_variant	NULL	Work package number	No	No
hiswout_stdproc	sql_variant	NULL	standard procedure	No	No
hiswout_quote_status	sql_variant	NULL	hiswout_quote_status	No	No
hiswout_taskcode	sql_variant	NULL	Task number	No	No
hiswout_taskrevno	sql_variant	NULL	Revision number	No	No
hiswout_est_labhr	bigint	NULL	Estimated Labour rate per hour	No	No
hiswout_est_fachr	bigint	NULL	Estimated facility rate per hour	No	No
hiswout_Billable_YN	sql_variant	NULL	Billable yes or no	No	No
hiswout_labourrate_perhr	numeric(28,8)	NULL	%AttDef	No	No
hiswout_facilityrate_perhr	bigint	NULL	Facility rate per hour	No	No
hiswout_estmanhrs	bigint	NULL	Estimated man hours	No	No
hiswout_estresource_price	bigint	NULL	Estimated resource price	No	No
hiswout_estmat_price_flat	bigint	NULL	Estimated material price flat	No	No
hiswout_estmisc_price	numeric(28,8)	NULL	%AttDef	No	No
hiswout_remarks	sql_variant	NULL	remarks	No	No
hiswout_actual_hr	bigint	NULL	%AttDef	No	No
hiswout_billable_hr	bigint	NULL	Billable hours	No	No
hiswout_invoiceblehr	bigint	NULL	Invoiceable hours	No	No
hiswout_billable_labprice	bigint	NULL	Billable labour price	No	No
hiswout_billable_facprice	bigint	NULL	Billable facility price	No	No
hiswout_billable_matprice	bigint	NULL	Billable material price	No	No
hiswout_billable_miscost	numeric(28,8)	NULL	%AttDef	No	No
hiswout_inv_comments	sql_variant	NULL	Invoice comments	No	No
hiswout_invoiced	sql_variant	NULL	hiswout_invoiced	No	No
hiswout_createdby	sql_variant	NULL	Created by ( user )	No	No
hiswout_createddate	datetime	NULL	Created date	No	No
hiswout_modifiedby	sql_variant	NULL	modified by ( user )	No	No
hiswout_modifieddate	datetime	NULL	modified date	No	No
hiswout_wccode	sql_variant	NULL	Workcenter code	No	No
HISWOUT_REL_PARENT_TASK	sql_variant	NULL	HISWOUT_REL_PARENT_TASK	No	No
HISWOUT_PERPETUAL	sql_variant	NULL	HISWOUT_PERPETUAL	No	No
HISWOUT_TASK_RELSHIP	sql_variant	NULL	HISWOUT_TASK_RELSHIP	No	No
HISWOUT_MNT_TYPE	sql_variant	NULL	HISWOUT_MNT_TYPE	No	No

Table Name corder_md_material_dtl

Table Comment To store the part details of the workunit 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
Md_Remarks	sql_variant	NULL	remarks	No	No
Md_Quote_Status	sql_variant	NULL	Quotation status of the part	No	No
Md_consumedQty	bigint	NULL	consumed quantity	No	No
Md_pricelist	sql_variant	NULL	Pricelist for the part .	No	No
Md_standardCost	bigint	NULL	standard cost for the part	No	No
Md_Embodiment_Fee	bigint	NULL	Embodiment fee for the part	No	No
Md_Unit_Price	bigint	NULL	Unit price of the part	No	No
Md_InvoiceStatus	sql_variant	NULL	Invoice status of the part	No	No
Md_ppl_rev_no	sql_variant	NULL	Part Price List’s Revision Number	No	No
Md_BillableQty	bigint	NULL	Billable quantity	No	No
Md_Actual_IssueCost	bigint	NULL	Actual issue cost	No	No
Md_Amount_ToBe	bigint	NULL	Amount Tobe	No	No
Md_Actual_UnitPrice	bigint	NULL	Actual unit price	No	No
Md_wuf_yn	sql_variant	NULL	Pricing Method	No	No
Md_ref_line_no	int	NOT NULL	Reference line number for column " obj_line_no" &nbspin ( corder_obj_wrkunit_dtls ) .	Yes	Yes
Md_task_line_no	int	NOT NULL	Reference line number for column " wout_task_line_no " in ( "corder_Wunit_task_det" ) .	Yes	Yes
Md_Part_No	sql_variant	NOT NULL	Part number	Yes	No
Md_order_ou	int	NOT NULL	Customer order ouinstance	Yes	Yes
Md_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
Md_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
Md_stockuom	sql_variant	NULL	Stock uom of the part	No	No
Md_Quantity	bigint	NULL	part quantity	No	No
Md_unitofmeasurement	sql_variant	NULL	unit of measurement for the part	No	No
md_Part_ou	int	NULL	Part ou	No	No
Md_RevisionNo	int	NULL	Part revision number	No	No
Md_suppliedby	sql_variant	NULL	Part was supplied by 1 ) Mro 2 ) Customer	No	No
Md_stckstatus	sql_variant	NULL	stock status of the part .	No	No

Table Name corder_obj_wrkunit_dtls

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
obj_order_ou	int	NOT NULL	Customer order ouinstance	Yes	Yes
obj_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
obj_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
obj_line_no	int	NOT NULL	Running line number for customer order and amendment number combination	Yes	No
obj_wrkunit_lineno	int	NULL	Line number of each distinct workunit .	No	No
obj_WorkRequest	sql_variant	NULL	Work request for the customer order .	No	No
obj_wrkunit_ou	int	NULL	Workunit ouinstance	No	No
obj_wrkunit_code	sql_variant	NULL	Workunit code	No	No
obj_wrkunit_type	sql_variant	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
obj_exec_status	sql_variant	NULL	Workunit status .. 1 ) Processed 2 ) Released 3 ) Inprogress 4 ) Completed 5 ) Closed	No	No
obj_invi_status	sql_variant	NULL	Invoice status .. 1 ) Pending Lobour Invoice 2 ) Pending Labour and Material Invoice 3 ) Pending Material Invoice 4 ) Pending Release 5 ) Pending Material Invoice Confirmal 6 ) Released	No	No
obj_Quot_status	sql_variant	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
obj_plan_status	sql_variant	NULL	Planning status of the workunit 1 ) Planned 2 ) Unplanned	No	No
obj_wrkunit_revno	sql_variant	NULL	Workunit revision number	No	No
obj_rp_code	sql_variant	NULL	Repair process code	No	No
obj_mnt_type	sql_variant	NULL	Maintenance type values 1 ) Overhaul 2 ) Repair 3 ) Inspection 4 )Others	No	No
obj_task_card	sql_variant	NULL	Customer task card	No	No
obj_billable	sql_variant	NULL	Billable values 1 ) Yes 2 ) No	No	No
obj_ammcmm_item_no	sql_variant	NULL	Manual tem number	No	No
obj_description	sql_variant	NULL	WorkUnit Description	No	No
obj_est_reqd	sql_variant	NULL	Estimation required values 1 ) Yes 2 ) No	No	No
obj_est_man_hrs	bigint	NULL	Estimated man hours	No	No
obj_nr_man_hrs	bigint	NULL	Non routine estimated man hours	No	No
obj_tot_res_price	bigint	NULL	Total estimated resource price	No	No
obj_tot_mtr_price	bigint	NULL	Total estimated material price flat .	No	No
obj_mtr_price	bigint	NULL	Total estimated material price ( calculated from each material value )	No	No
obj_embodiment_fee	bigint	NULL	Embodiment fee	No	No
obj_misc_cost	bigint	NULL	Miscellaneous cost	No	No
obj_est_total	bigint	NULL	Estimated total of the workunit.	No	No
obj_remarks	sql_variant	NULL	Remarks for the workunit	No	No
obj_part_lineno	int	NULL	Line number of each distinct part and serial number .	No	No
obj_partno	sql_variant	NULL	Part number	No	No
obj_part_ou	int	NULL	Part ou	No	No
obj_cust_partno	sql_variant	NULL	Customer Part number	No	No
obj_part_serialno	sql_variant	NULL	Part serial number	No	No
obj_Mov_Status	sql_variant	NULL	Movement Status 1 ) Received 2 ) Issued for Shipping 3 ) Shipped	No	No
obj_lot_no	sql_variant	NULL	Lot number	No	No
obj_part_qty	bigint	NULL	Part quantity	No	No
obj_jobtype	sql_variant	NULL	Shop Job type values 1 ) "Make Job" 2 ) "Piece Job"	No	No
obj_stck_status	sql_variant	NULL	stock status values All customer stock status in interacting UDSS component	No	No
obj_exec_facility	sql_variant	NULL	Execution facility values 1 ) ’External’ 2 ) ’Internal’	No	No
obj_exec_loc	sql_variant	NULL	Execution Location values All the Work Centers OUs which are interacting with the self interacting set of aircraft components with which this component in the login OU is interacting.	No	No
obj_prt_remarks	sql_variant	NULL	Part Remarks	No	No
obj_workcenter	sql_variant	NULL	Work center values All the active Work Centers defined in Interacting Work center component with which the current component interaction is defined and mapped to login user. &nbspLoad only those work centers with work center type as ’Hangar’ or ’Bay’ or ’Others’. Also load those work centers whose execution capabilities are identified as ’Hangar’, ’Line’ or ’All’.	No	No
obj_ro_location	int	NULL	Repair order location values All the Repair Order Ous where repair Order Component is deployed and the interaction is defined with the current business component exists.	No	No
obj_repair_shop	sql_variant	NULL	Repair shop code	No	No
obj_salvage_value	bigint	NULL	salvage value	No	No
obj_position_code	sql_variant	NULL	position code	No	No
obj_level_code	sql_variant	NULL	level code	No	No
obj_execu_doc_no	sql_variant	NULL	Execution order number (unplanned )	No	No
obj_execu_doc_type	sql_variant	NULL	Execution type ( unplanned )	No	No
obj_execu_loc	int	NULL	Execution location	No	No
obj_ac_reg	sql_variant	NULL	Aircraft regno number	No	No
obj_ac_reg_ou	int	NULL	OU of Aircraft number component	No	No
obj_model_ou	int	NULL	Model ou	No	No
obj_model	sql_variant	NULL	Model of aircraft	No	No
obj_Addl_plnend_date	datetime	NULL	Planned end date of additional workunit	No	No
obj_Addl_plnstart_date	datetime	NULL	Planned start date of additional workunit	No	No
obj_Addl_Aut_stat	sql_variant	NULL	Additional workunit Authorization status 1 ) Pending customer authorization 2 ) Approve additional work 3 ) Reject additional work 4 ) Reject Quote	No	No
obj_Addl_Aut_refno	sql_variant	NULL	Authorization reference document number ( Customer reference document )	No	No
obj_Addl_Aut_Date	datetime	NULL	Authorization date ( Customer authorised date )	No	No
obj_Addl_Autby	sql_variant	NULL	Authorised by ( Internal Supervisor )	No	No
obj_Addl_Autorized_date	datetime	NULL	Authorised date ( Internal Supervisor authorised date )	No	No
obj_Addl_comments	sql_variant	NULL	Comments	No	No
obj_quot_revno	int	NULL	Quotation revision number	No	No
obj_actual_hr	bigint	NULL	Actual hours	No	No
obj_billable_hr	bigint	NULL	Billable hours	No	No
obj_invoiced_hr	bigint	NULL	Invoiced hours	No	No
obj_billable_labprice	bigint	NULL	Billable labour price	No	No
obj_billable_facprice	bigint	NULL	Billable Facility price	No	No
obj_billable_matprice	bigint	NULL	Billable Material price	No	No
obj_billable_miscost	bigint	NULL	Billable Misc cost	No	No
obj_pricing_basis	sql_variant	NULL	Pricing Basis for a WorkUnit	No	No
obj_created_by	sql_variant	NULL	Created by ( user id )	No	No
obj_created_date	datetime	NULL	Created date of the information	No	No
obj_modified_by	sql_variant	NULL	modified by ( user id )	No	No
obj_modified_date	datetime	NULL	Modified date of the information	No	No
OBJ_REL_TASK_COUNT	int	NULL	OBJ_REL_TASK_COUNT	No	No
OBJ_APPLICAB_GRP	int	NULL	OBJ_APPLICAB_GRP	No	No

Table Name corder_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	sql_variant	NOT NULL	Component name	Yes	No
paramcategory	sql_variant	NOT NULL	Parameter Category	Yes	No
paramtype	sql_variant	NOT NULL	Parameter type	Yes	No
paramcode	sql_variant	NOT NULL	Parameter code	Yes	No
paramdesc	sql_variant	NOT NULL	Parameter desc	No	No
langid	int	NOT NULL	Language id	No	No
sortby	int	NOT NULL	Sorting order of the values	No	No
creationdate	datetime	NOT NULL	Created date ( Date on which the record was created )	No	No

Table Name corder_pspc_prtsupp_cust

Table Comment To Store the 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
pspc_timestamp	int	NULL	Timestamp value for concurrence check	No	No
pspc_remarks	sql_variant	NULL	Remarks for part and customer part details	No	No
pspc_repln_policy	sql_variant	NULL	Replenishment Policy with the values 1 ) Periodically 2 ) Order Based	No	No
pspc_modified_by	sql_variant	NULL	modified by (user information )	No	No
pspc_created_by	sql_variant	NULL	created by (user information )	No	No
pspc_created_date	datetime	NULL	created date	No	No
pspc_modified_date	datetime	NULL	modified date	No	No
pspc_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
pspc_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
pspc_order_ou	int	NOT NULL	Customer order ouinstance	Yes	Yes
pspc_cust_part_no	sql_variant	NULL	Customer Part no	No	No
pspc_part_no	sql_variant	NULL	Part no	No	No
pspc_lineno	int	NOT NULL	Running lineno for customer order and amendment number combination	Yes	No
pspc_part_ou	int	NULL	part ouinstance	No	No

Table Name corder_qucd_quick_codes

Table Comment To Store the quick code 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
qucd_qc_ou	int	NOT NULL	Quickcode ouinstance	Yes	No
qucd_qc_type	sql_variant	NOT NULL	Quickcode type	Yes	No
qucd_qc_code	sql_variant	NOT NULL	Quickcode	Yes	No
qucd_qc_desc	sql_variant	NULL	Quickcode description	No	No
qucd_qc_status	sql_variant	NOT NULL	Quickcode status values 1 ) " Active " 2 ) " Inactive "	No	No
qucd_timestamp	int	NULL	Timestamp value for concurrency check	No	No
qucd_created_by	sql_variant	NULL	Created by ( user information )	No	No
qucd_created_date	datetime	NULL	Created date ( date on which the document was created )	No	No
qucd_modified_by	sql_variant	NULL	Modified by ( user information )	No	No
qucd_modified_date	datetime	NULL	Modified date ( date on which the document was modified )	No	No

Table Name corder_rd_resource_dtl

Table Comment Customer Order Resource details for the task in the work unit
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Rd_NonBillable_hrs	bigint	NULL	Non-Billable hours	No	No
Rd_Billable_hrs	bigint	NULL	Billable hours	No	No
Rd_Est_no	bigint	NULL	Estimated number	No	No
Rd_spl_revno	sql_variant	NULL	Service Price List’s Revision Number	No	No
Rd_ResourceRate_perhr	bigint	NULL	Resource rate per hour	No	No
Rd_pricelist	sql_variant	NULL	Pricelist of resource .	No	No
Rd_spl_eff_date	datetime	NULL	Service Price List’s Effective till date	No	No
Rd_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
Rd_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
Rd_order_ou	int	NOT NULL	Customer order ouinstance	Yes	Yes
Rd_Resource_type	sql_variant	NULL	Resource type	No	No
Rd_Resource_code	sql_variant	NOT NULL	Resource number	Yes	No
Rd_ref_line_no	int	NOT NULL	Reference line number for column " obj_line_no" &nbspin ( corder_obj_wrkunit_dtls ) .	Yes	Yes
Rd_task_line_no	int	NOT NULL	Reference line number for column " wout_task_line_no " in ( "corder_Wunit_task_det" ) .	Yes	Yes

Table Name corder_resrq_res_req

Table Comment Resource requirement for the corresponding Cutomer order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
resrq_order_no	sql_variant	NOT NULL	resrq_order_no	No	No
resrq_order_ou	int	NOT NULL	resrq_order_ou	No	No
resrq_amend_no	sql_variant	NOT NULL	resrq_amend_no	No	No
resrq_serial_no	int	NULL	resrq_serial_no	No	No
resrq_line_no	int	NULL	resrq_line_no	No	No
resrq_subcomp_line_no	int	NULL	resrq_subcomp_line_no	No	No
resrq_subcomp_wkunit_line_no	int	NULL	resrq_subcomp_wkunit_line_no	No	No
resrq_workunit_no	sql_variant	NOT NULL	resrq_workunit_no	No	No
resrq_workunit_ou	int	NOT NULL	resrq_workunit_ou	No	No
resrq_workunit_type	sql_variant	NOT NULL	resrq_workunit_type	No	No
resrq_res_no	sql_variant	NOT NULL	resrq_res_no	No	No
resrq_res_ou	int	NOT NULL	resrq_res_ou	No	No
resrq_res_type	sql_variant	NULL	resrq_res_type	No	No
resrq_est_nos	int	NULL	resrq_est_nos	No	No
resrq_bill_hrs	int	NULL	resrq_bill_hrs	No	No
resrq_non_bill_hrs	int	NULL	resrq_non_bill_hrs	No	No
resrq_rate_per_hr	sql_variant	NULL	resrq_rate_per_hr	No	No
resrq_tot_price	bigint	NULL	resrq_tot_price	No	No
resrq_created_by	sql_variant	NOT NULL	resrq_created_by	No	No
resrq_created_date	datetime	NOT NULL	resrq_created_date	No	No
resrq_modified_by	sql_variant	NULL	resrq_modified_by	No	No
resrq_modified_date	datetime	NULL	resrq_modified_date	No	No
resrq_est_time	sql_variant	NULL	resrq_est_time	No	No
resrq_uom	sql_variant	NULL	resrq_uom	No	No
resrq_comgt_serial_no	int	NULL	resrq_comgt_serial_no	No	No

Table Name CORDER_REVENUE_ACC_RES_DTL

Table Comment Resource details for the revenue forecost for the corresponding Customer order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RER_LINE_NO	int	NOT NULL	Line No	Yes	No
RER_CUSTORDER_OU	int	NOT NULL	Customer Order OU Instance	Yes	No
RER_RES_CODE	sql_variant	NOT NULL	Resource Code	Yes	No
RER_RES_TYPE	sql_variant	NOT NULL	Resource Type	Yes	No
RER_GUID	sql_variant	NOT NULL	Guid	Yes	No
RER_EST_HRS	bigint	NULL	Estimated Hours	No	No
RER_ACT_HRS_NRM	bigint	NULL	Actual Hours Normal time	No	No
RER_ACT_HRS_OT	bigint	NULL	Actual Hours Overtime	No	No
RER_ACT_RTPERHR_NRM	bigint	NULL	Actual Rate per Hour Normal	No	No
RER_ACT_RTPERHR_OT	bigint	NULL	Actual Rate per Hour Overtime	No	No
RER_BILL_HRS_NRM	bigint	NULL	Billable Hours Normal	No	No
RER_BILL_HRS_OT	bigint	NULL	Billable Hours Overtime	No	No
RER_BILL_RTPERHR_NRM	bigint	NULL	Billable rate per Hour Normal	No	No
RER_BILL_RTPERHR_OT	bigint	NULL	Billable rate per Hour overtime	No	No
RER_RES_REV_ORDCURR	bigint	NULL	Resource Revenue in Order Currency	No	No
RER_RES_REV_BASCURR	bigint	NULL	Resource Revenue in base Currency	No	No
RER_RES_COST	bigint	NULL	Resource Cost	No	No

Table Name CORDER_REVENUE_ACC_TASK_DTL

Table Comment Task details for the revenue forecost for the corresponding Customer order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
REV_LINE_NO	int	NOT NULL	Line Number	Yes	No
REV_CUSTORDER_OU	int	NOT NULL	Customer Order OU Instance	Yes	No
REV_CUSTORDER_NO	sql_variant	NOT NULL	Customer Order Number	Yes	No
REV_AMENDMENT_NO	int	NOT NULL	Customer Order Amendment Number	Yes	No
REV_EXEC_DOC_NO	sql_variant	NOT NULL	Execution Document Number	Yes	No
REV_EXEC_DOC_TYPE	sql_variant	NOT NULL	Execution Document Type	Yes	No
REV_TASK_NO	sql_variant	NOT NULL	Task Number	Yes	No
REV_TASK_SERIAL_NO	int	NOT NULL	Task Serial Number	Yes	No
REV_REF_LINE_NO	int	NOT NULL	Reference Line Number	Yes	No
REV_GUID	sql_variant	NOT NULL	Guid	Yes	No
REV_CUST_NO	sql_variant	NOT NULL	Customer Number	No	No
REV_CURRENCY	sql_variant	NOT NULL	Currency	No	No
REV_INV_BASIS	sql_variant	NULL	Invoice basis	No	No
REV_QUOTE_LEVEL	sql_variant	NULL	Quatation Level	No	No
REV_EXEC_DOC_OU	int	NULL	Execution Document OU Instance	No	No
REV_TASK_STATUS	sql_variant	NOT NULL	Task Status	No	No
REV_PLAN_STARTDATE	datetime	NULL	Plan Start date	No	No
REV_PLAN_ENDDATE	datetime	NULL	Plan End date	No	No
REV_FIN_BOOK	sql_variant	NULL	Finance Book	No	No
REV_EXCH_RATE	bigint	NULL	Exchange Rate	No	No
REV_RES_REV	bigint	NULL	Resource Revenue	No	No
REV_REP_REV	bigint	NULL	Revenue	No	No
REV_TOT_REV_ORDCURR	bigint	NULL	Total Revenue in order currency	No	No
REV_TOT_REV_BASCURR	bigint	NULL	Total Revenue in Base currency	No	No
REV_RES_COST	bigint	NULL	Resource Cost	No	No
REV_CUST_ACC_GROUP	sql_variant	NULL	Customer Account Group	No	No
REV_COST_CENTER	sql_variant	NULL	Cost center	No	No
REV_WORK_CENTER	sql_variant	NULL	Work Center	No	No
REV_PRIMARY_PART_GROUP	sql_variant	NULL	Primary part Group	No	No
REV_ORDER_TYPE	sql_variant	NULL	Order type	No	No
REV_TASK_LINE_NO	int	NULL	Task Line Number	No	No
REV_WORKUNIT_OU	int	NULL	Work Unit OU Instance	No	No
REV_WORKUNIT_NO	sql_variant	NULL	Work Unit Number	No	No
REV_WORKUNIT_TYPE	sql_variant	NULL	Work Unit Type	No	No
REV_TASK_REV_NO	sql_variant	NULL	Task Revision Number	No	No
REV_ACC_CODE	sql_variant	NULL	Account Code	No	No

Table Name CORDER_REVENUE_RORD_DTL

Table Comment Repair order details for the revenue forecost for the corresponding Customer order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RERO_LINE_NO	int	NOT NULL	Line No	Yes	No
RERO_REP_ORDER_NO	sql_variant	NOT NULL	Repair Order Number	Yes	No
RERO_GUID	sql_variant	NOT NULL	Guid	Yes	No
RERO_REP_ORDER_OU	int	NOT NULL	Repair Order OU Instance	No	No
RERO_QTY_ORDERED	bigint	NULL	Quantity Ordered	No	No
RERO_QTY_RECEIVED	bigint	NULL	Quantity Received	No	No
RERO_BILL_RTPERQTY	bigint	NULL	Billable Rate per Quantity	No	No
RERO_REV_ORDCURR	bigint	NULL	Order Currency	No	No
RERO_REV_BASCURR	bigint	NULL	Base Currency	No	No
RERO_CUSTORDER_OU	int	NOT NULL	Customer Order OU Instance	No	No

Table Name corder_seop_set_options

Table Comment To store the set options 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
seop_ou	int	NOT NULL	Ou instance	Yes	No
seop_val_spl	sql_variant	NULL	Validity of Service Price List values 1 ) "Required" 2 ) "Not Required".	No	No
seop_app_cust_order	sql_variant	NULL	Approval of Customer Order values 1 ) "Required" 2 ) "Not Required".	No	No
seop_auto_gen_vis_pak	sql_variant	NULL	Automatic Creation of Visit Package values 1 ) "On Authorize" 2 ) " On Confirm" 3 ) "Not Required"	No	No
seop_auto_gen_rep_order	sql_variant	NULL	Automatic Creation of Repair Order values 1 ) "On Authorize" 2 ) "On Confirm" 3 ) "Not Required".	No	No
seop_auto_gen_work_scope	sql_variant	NULL	Automatic Creation of Work Scope values 1 ) "On Authorize" 2 ) "On Confirm" 3 ) "Not Required".	No	No
seop_cap_chk_auto_order	sql_variant	NULL	Capability check of Work Center values 1) "Required" 2 ) "Not Required"	No	No
seop_num_type_vis_pak	sql_variant	NULL	Values which are defined for the "Visit Package" transaction	No	No
seop_num_type_rep_order	sql_variant	NULL	Values which are defined for the "Repair Order" transaction type	No	No
seop_num_type_work_scope	sql_variant	NULL	Values which are defined for the "Work Scope" transaction type	No	No
seop_num_type_discrep	sql_variant	NULL	seop_num_type_discrep	No	No
seop_num_type_cwo	sql_variant	NULL	Values which are defined for the "CWO" transaction type	No	No
seop_auto_gen_cwo	sql_variant	NULL	Automatic creation of CWO &nbspvalues 1 ) On Confirm 2 ) On Authorize 3 ) Not Required.	No	No
seop_Mat_Quot_Prior_Quot_Con	sql_variant	NULL	Material Quotation Prior to Quote Confirmation values 1 ) Required 2 ) Required.	No	No
seop_Prt_Inv_Pro_Pri_Inv_Rel	sql_variant	NULL	Part Invoicing Prior to Invoice Release values 1 ) Required 2 ) Not Required.	No	No
seop_timestamp	int	NULL	Timestamp value for concurruncy check	No	No
seop_created_by	sql_variant	NULL	Created by ( user information )	No	No
seop_created_date	datetime	NULL	Created date ( date on which the data was created )	No	No
seop_modified_by	sql_variant	NULL	modified by ( user information )	No	No
seop_modified_date	datetime	NULL	modified date ( date on which the data was modified )	No	No
seop_ROUTE_value	sql_variant	NULL	seop_ROUTE_value	No	No
seop_AUTO_value	sql_variant	NULL	seop_AUTO_value	No	No

Table Name corder_seop_set_options_Dtl

Table Comment To store the set options 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
seop_ou	int	NOT NULL	%AttDef	Yes	No
seop_Category	sql_variant	NULL	seop_Category	No	No
seop_parameter	sql_variant	NULL	seop_parameter	No	No
seop_permitvalue	sql_variant	NULL	seop_permitvalue	No	No
seop_value	sql_variant	NULL	seop_value	No	No
seop_status	sql_variant	NULL	seop_status	No	No
seop_errormsg	sql_variant	NULL	seop_errormsg	No	No

Table Name corder_status_log_dtl

Table Comment Maintains the status details of customer order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Status_Quot_stat	sql_variant	NULL	Captures the changed Quotation status of customer order .	No	No
Status_order_stat	sql_variant	NULL	Captures the changed Order status of customer order .	No	No
Status_Inv_stat	sql_variant	NULL	Captures the changed Invoice status of customer order .	No	No
Status_Changed_by	sql_variant	NULL	user name	No	No
Status_Changed_Date	datetime	NULL	date and time of the changed information	No	No
Status_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
Status_order_ou	int	NOT NULL	Customer order ouinstance	Yes	Yes
Status_Entity_type	sql_variant	NULL	Entity Type values 1 ) Order status 2 ) Quotation status 3 ) Invoice status	No	No
Status_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
Status_lineno	int	NOT NULL	Running lineno for customer order and amendment combination .	Yes	No

Table Name corder_tcin_tcd_info

Table Comment To Store the tax , charge and discount 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
tcin_pay_to_supp	sql_variant	NULL	Supplier code	No	No
tcin_timestamp	int	NULL	Timestamp value for concurrence check .	No	No
tcin_billable	sql_variant	NULL	Billable combo with the values 1 ) Yes 2 ) No	No	No
tcin_tcd_amount	bigint	NULL	TCD amount	No	No
tcin_currency	sql_variant	NULL	Currency code	No	No
tcin_modified_date	datetime	NULL	modified date	No	No
tcin_created_by	sql_variant	NULL	Created by ( user information )	No	No
tcin_modified_by	sql_variant	NULL	modified by ( user information )	No	No
tcin_created_date	datetime	NULL	Created date	No	No
tcin_invoiced	sql_variant	NULL	Invoiced	No	No
tcin_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
tcin_ApplOn	sql_variant	NOT NULL	Taxes , charges and discount applicable on 1 ) Order Level 2 ) Labor 3 ) Material	Yes	No
tcin_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
tcin_order_ou	int	NOT NULL	Customer order ouinstance	Yes	Yes
tcin_tcd_rate	bigint	NULL	Tax , charge and discount rate .	No	No
tcin_variant_no	sql_variant	NULL	Tax , charge and discount number variant , which is defined in the TCD master component .	No	No
tcin_line_no	int	NOT NULL	Running lineno for customer order and amendment combination	Yes	No
tcin_tcd_no	sql_variant	NULL	Tax , charge and discount number , which is defined in the TCD master component .	No	No
tcin_tcd_ou	int	NULL	TCD ouinstance	No	No

Table Name corder_trcd_terms_condns

Table Comment To store the terms and condition 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
trcd_core_pack_code	sql_variant	NULL	Packaging code of core	No	No
trcd_core_trans_mode	sql_variant	NULL	Transportation Mode of core	No	No
trcd_serv_ship_label	sql_variant	NULL	Shipping label of serviceable component	No	No
trcd_spare_trans_mode	sql_variant	NULL	Transportation Mode of spare	No	No
trcd_core_freight_term	sql_variant	NULL	freight term of core	No	No
trcd_core_ship_label	sql_variant	NULL	Shipping label core	No	No
trcd_spare_pack_code	sql_variant	NULL	Packaging code of spare	No	No
trcd_pack_notes	sql_variant	NULL	Packaging notes	No	No
trcd_freight_amount	bigint	NULL	Freight amount	No	No
trcd_serv_freight_term	sql_variant	NULL	freight term of serviceable component	No	No
trcd_serv_pack_code	sql_variant	NULL	Packaging code of Serviceable Component	No	No
trcd_ship_notes	sql_variant	NULL	Shipping notes	No	No
trcd_serv_trans_mode	sql_variant	NULL	Transportation Mode of Serviceable Component	No	No
trcd_freight_billable	sql_variant	NULL	Freight Billable combo with values 1 ) Yes 2 ) No	No	No
trcd_timestamp	int	NULL	timestamp value for concurrency check .	No	No
trcd_AgreeDtls	sql_variant	NULL	Agreement details	No	No
trcd_WarrTerms	sql_variant	NULL	warranty terms	No	No
trcd_modified_by	sql_variant	NULL	modified by ( user name )	No	No
trcd_created_by	sql_variant	NULL	Created by ( user name )	No	No
trcd_created_date	datetime	NULL	Created date of the record	No	No
trcd_spare_freight_term	sql_variant	NULL	freight term of spare	No	No
trcd_fwd_covappl	sql_variant	NULL	Forward cover applicability values 1 ) Yes 2 ) No	No	No
trcd_fwd_rate	bigint	NULL	Forward rate	No	No
trcd_spare_ship_label	sql_variant	NULL	Shipping label spare	No	No
trcd_Warrty_RefNo	sql_variant	NULL	warranty reference number	No	No
trcd_Warr_FrmDate	datetime	NULL	warranty from date	No	No
trcd_Warrty_PrdDays	bigint	NULL	warranty period days	No	No
trcd_Wrnty_ExpDt	datetime	NULL	warranty expire date	No	No
trcd_modified_date	datetime	NULL	modified date of the record	No	No
trcd_allow_ship	sql_variant	NULL	Allow Shipping combo values 1) Before Payment Receipt" 2 ) After Payment Receipt	No	No
trcd_Init_Invat	sql_variant	NULL	Initiate Invoicing At combo values 1 ) "Task Closure", 2 ) "Order Closure" 3 ) "Work Completion".	No	No
trcd_ord_settle	sql_variant	NULL	Order settlement combo values 1 ) "Single" 2 ) "Multiple"	No	No
trcd_pay_term	sql_variant	NULL	Pay term value	No	No
trcd_rcpt_method	sql_variant	NULL	Receipt Method combo values 1 ) Regular 2 ) ESR 3 ) ESR Plus 4 ) LSV 5 ) Specific Bank	No	No
trcd_rcpt_mode	sql_variant	NULL	Receipt mode values	No	No
trcd_insurance_liable	sql_variant	NULL	Insurance Liability combo values 1 ) Self 2 ) Customer 3 ) None	No	No
trcd_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
trcd_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
trcd_order_ou	int	NOT NULL	Customer order ouinstance	Yes	Yes
trcd_file_name	sql_variant	NULL	To capture File name	No	No
trcd_gta_remarks	sql_variant	NULL	GTA Remarks is captured	No	No
trcd_gta_ref	sql_variant	NULL	General terms agreement reference number .	No	No
trcd_ref_doc_date	datetime	NULL	GTA Reference document date .	No	No
trcd_port_of_dest	sql_variant	NULL	Port of destination	No	No
trcd_remarks	sql_variant	NULL	Remarks of advance payment terms	No	No
trcd_action	sql_variant	NULL	Action On Non Payment combo values 1 ) Hold Order Processing 2 ) Hold Release of Work 3 ) None	No	No
trcd_dd_charges_by	sql_variant	NULL	DD Charges Borne by combo values 1 ) Customer 2 ) Self 3 ) None	No	No
trcd_port_of_dept	sql_variant	NULL	Port of departure	No	No
trcd_inco_term	sql_variant	NULL	INCO term combo .	No	No
trcd_carrier	sql_variant	NULL	Carrier code	No	No
trcd_insurance_amount	bigint	NULL	Insurance amount value	No	No
trcd_advance_appl	sql_variant	NULL	Advance Applicable combo values 1 ) Yes 2 ) No	No	No
trcd_advance_date	datetime	NULL	Advance payable by date	No	No
trcd_insurance_terms	sql_variant	NULL	Insurance terms	No	No
trcd_advance_tol_perc	bigint	NULL	Advance tolerance percentage	No	No
trcd_advance_payable	sql_variant	NULL	Advance payable	No	No
trcd_advance_perc	bigint	NULL	Percentage of advance payable	No	No
trcd_advance_perc_on	sql_variant	NULL	Advance Percent On combo values 1 ) Total Value 2 ) Basic Value	No	No

Table Name corder_Wunit_task_det

Table Comment To store the breakup information of the workunit , that is the task level information of a workunit .
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wunit_order_ou	int	NOT NULL	Customer order ouinstance	Yes	Yes
wunit_order_no	sql_variant	NOT NULL	Customer order number	Yes	Yes
wunit_amend_no	int	NOT NULL	Amendment number for the Customer order	Yes	Yes
wunit_ref_line_no	int	NOT NULL	Reference line number for column " obj_line_no" &nbspin ( corder_obj_wrkunit_dtls ) .	Yes	Yes
wunit_task_line_no	int	NOT NULL	Running line number for customer order and amendment number .	Yes	No
wunit_parent_wu_lineno	int	NOT NULL	Reference lineno for column "obj_wrkunit_lineno" &nbspin "corder_obj_wrkunit_dtls" table .	No	No
wunit_parent_wu_ou	int	NULL	Ouinstance of the workunit	No	No
wunit_parent_wu_no	sql_variant	NULL	Reference number for column "obj_wrkunit_code " &nbspin "corder_obj_wrkunit_dtls" table .	No	No
wunit_parent_wu_type	sql_variant	NULL	Reference type for column "obj_wrkunit_type" in "corder_obj_wrkunit_dtls" table .	No	No
wunit_wrkpckage	sql_variant	NULL	Work package number	No	No
wunit_stdproc	sql_variant	NULL	standard procedure	No	No
wunit_taskcode	sql_variant	NULL	Task number	No	No
wunit_taskrevno	sql_variant	NULL	Task Revision number	No	No
wunit_quote_status	sql_variant	NULL	Quotation status	No	No
wunit_est_labhr	bigint	NULL	Estimated Labour rate per hour	No	No
wunit_est_fachr	bigint	NULL	Estimated facility rate per hour	No	No
wunit_Billable_YN	sql_variant	NULL	Billable yes or no	No	No
wunit_labourrate_perhr	bigint	NULL	Labour rate per hour	No	No
wunit_facilityrate_perhr	bigint	NULL	Facility rate per hour	No	No
wunit_estmanhrs	bigint	NULL	Estimated man hours	No	No
wunit_estresource_price	bigint	NULL	Estimated resource price	No	No
wunit_estmat_price_flat	bigint	NULL	Estimated material price flat	No	No
wunit_estmisc_price	bigint	NULL	Estimated misc price	No	No
wunit_remarks	sql_variant	NULL	remarks	No	No
wunit_actual_hr	bigint	NULL	Actual hours	No	No
wunit_billable_hr	bigint	NULL	Billable hours	No	No
wunit_invoiceblehr	bigint	NULL	Invoiceable hours	No	No
wunit_billable_labprice	bigint	NULL	Billable labour price	No	No
wunit_billable_facprice	bigint	NULL	Billable facility price	No	No
wunit_billable_matprice	bigint	NULL	Billable material price	No	No
wunit_billable_miscost	bigint	NULL	Billable misc cost	No	No
wunit_inv_comments	sql_variant	NULL	Invoice comments	No	No
wunit_invoiced	sql_variant	NULL	Task Invoice information values 1 ) Yes 2 ) No	No	No
wunit_Pricing_Basis	sql_variant	NULL	Pricing Basis for a WorkUnit	No	No
wunit_createdby	sql_variant	NULL	Created by ( user )	No	No
wunit_createddate	datetime	NULL	Created date	No	No
wunit_modifiedby	sql_variant	NULL	modified by ( user )	No	No
wunit_modifieddate	datetime	NULL	modified date	No	No
wunit_wccode	sql_variant	NULL	Workcenter code derived from Task master	No	No
WUNIT_REL_PARENT_TASK	sql_variant	NULL	WUNIT_REL_PARENT_TASK	No	No
WUNIT_PERPETUAL	sql_variant	NULL	WUNIT_PERPETUAL	No	No
WUNIT_TASK_RELSHIP	sql_variant	NULL	WUNIT_TASK_RELSHIP	No	No
WUNIT_MNT_TYPE	sql_variant	NULL	WUNIT_MNT_TYPE	No	No