Component Work Order & Component Work Reporting

Component Work Order & Component Work Reporting

Table Name cwo_acd_components_dtl

Table Comment Associated Components to Component work order details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acd_remarks	char(255)	NULL	Remarks	No	No
acd_updmodified_date	datetime	NULL	Updated date	No	No
acd_MainCoreIss	char(15)	NULL	Main Core Issue: 1. R - Required. 2. NR - Not Required.	No	No
acd_mainttype	char(5)	NULL	Values from Common master (Repair,Overhaul,Inspection,others and space) Inspection - INS Others - OTH Overhaul - OVH Repair - REP	No	No
acd_timestamp	int	NULL	timestamp	No	No
acd_lstmodified_date	datetime	NULL	Current date	No	No
acd_lstmodified_by	char(30)	NULL	Modifed by	No	No
acd_jobtype	char(5)	NULL	job type - C - Completed NC-Not Completed	No	No
acd_CompWorkorder	varchar(40)	NOT NULL	Comp Work Order	Yes	Yes
acd_componentid	char(90)	NOT NULL	Associated component id	No	No
acd_ouinstance	numeric(10)	NOT NULL	CWO OU Instance	Yes	Yes
acd_compcondition	char(5)	NULL	Associated component condition Over Hauled - OVH Phased Out - PO New - NW Servicable - SER UnServicable - USR	No	No
acd_partserialNo	char(40)	NULL	Associated part serialnumber	No	No
acd_component_ou	int	NULL	Associated component ou	No	No
acd_partno_ou	int	NULL	Associated part ou	No	No
acd_partno	char(40)	NULL	Associated part no	No	No

Table Name cwo_awu_author_work_units

Table Comment Authorise Work units Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
awu_Linkedcompworkorder	varchar(18)	NULL	Linked CWO It could be the New CWO or Existing CWO depends on the awu_addworkunits	No	No
awu_LinkedRepairOrder	char(18)	NULL	Linked repair order	No	No
awu_maint_type	char(25)	NULL	Maintenance type Corrective work order Repair order	No	No
awu_AddWorkunits	varchar(25)	NULL	Indicates whether New CWo to be created or added to the existing CWO N- New , E- Existing	No	No
awu_modifiedBy	varchar(30)	NULL	Last Modified By	No	No
awu_CreatedDate	datetime	NULL	Record Created Date	No	No
awu_modifiedDate	datetime	NULL	Last Modified Date	No	No
awu_CreatedBy	varchar(30)	NULL	Record Created Login Name	No	No
awu_timestamp	numeric(10)	NULL	Timestamp	No	No
ifrd_DocumentType	char(5)	NOT NULL	Document Type-’DP’ -Discrepancy ’MR’-Maint Report	Yes	Yes
awu_DiscrepancyNo	varchar(18)	NOT NULL	Discrepancy No	Yes	Yes
ifrd_disc_flag	varchar(20)	NOT NULL	This column will have values R or P. R for Reported Discrepancies and P for Pending Discrepancies.	Yes	Yes
awu_workunitcode	varchar(30)	NOT NULL	Work Unit Code Task no or Standard Procedure depends on the Workuint	No	No
awu_workunittype	varchar(25)	NULL	Work unit Type Task or Standard Procedure	No	No
awu_ouinstance	numeric(10)	NOT NULL	WO OU Instance	Yes	Yes
awu_Transid	varchar(40)	NOT NULL	Guid for maintaining uniqueness	Yes	No
awu_CompWorkOrder	varchar(40)	NOT NULL	CWO	Yes	Yes

Table Name cwo_cdd_cwo_delay_dtl

Table Comment CWO Delay Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cdd_DisplayDuration	numeric(28,8)	NULL	Display Time UOM Duration stored in Display UOM	No	No
cdd_duration	numeric(28,8)	NULL	Actual Duration in Mins	No	No
cdd_DisplayUOM	varchar(10)	NULL	Display Time UOM	No	No
cdd_todate	datetime	NULL	Delay To Date	No	No
cdd_modifiedBy	varchar(30)	NOT NULL	Last Modified By	No	No
cdd_CreatedBy	varchar(30)	NOT NULL	Record Created By	No	No
cdd_CreatedDate	datetime	NOT NULL	Record Created Date	No	No
cdd_modificationDate	datetime	NOT NULL	last Modification Date	No	No
cdd_ouinstance	numeric(10)	NOT NULL	CWO OU Instance	Yes	Yes
cdd_CompWorkOrder	varchar(40)	NOT NULL	CWO Work Order	Yes	Yes
cdd_DelayTranId	varchar(40)	NOT NULL	GUID	Yes	No
cdd_fromdate	datetime	NULL	Delay From Date	No	No
cdd_comments	varchar(255)	NULL	Delay Comments	No	No
cdd_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
cdd_Delaycode	varchar(25)	NULL	Work Order Delay Code	No	No

Table Name cwo_cwai_comp_wo_acc_info

Table Comment Component work order-Details of Account info
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CWAI_Ouinstance	int	NOT NULL	CWO Ouinstance	Yes	No
CWAI_CompWorkOrder	numeric(10)	NOT NULL	Component work order	Yes	No
CWAI_AccountCode	char(15)	NOT NULL	Account Code	Yes	No
CWAI_Account_Type	char(15)	NOT NULL	Account Type -Consumption/Suspense/maintenance loss account/Maintenance adjustment	Yes	No
CWAI_Anal_Code	char(15)	NULL	Analysis code	No	No
CWAI_Subanal_Code	char(15)	NULL	Sub Analysis code	No	No
CWAI_Control_Act_Type	char(15)	NULL	Control Account Type	No	No
CWAI_AutoPost_Act_Type	char(15)	NULL	Auto posting account type	No	No
CWAI_Account_Currency	char(15)	NULL	Account Currency	No	No
CWAI_Created_By	char(15)	NULL	Created user	No	No
CWAI_Created_Date	char(15)	NULL	Creation Date	No	No
CWAI_Modified_By	char(15)	NULL	modified user	No	No
CWAI_Modified_Date	char(15)	NULL	modified date	No	No

Table Name cwo_cwfi_comp_wo_fin_info

Table Comment Component work order-finance details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CWFI_Ouinstance	int	NOT NULL	CWO Ouinstance	Yes	No
CWFI_CompWorkOrder	numeric(10)	NOT NULL	Component work order	Yes	No
CWFI_Emod_FinBook	varchar(40)	NOT NULL	Finance book id	No	No
CWFI_AcGrp_FinBook	int	NULL	Account Group id	No	No
CWFI_Account_code	char(15)	NULL	Account Code	No	No
CWFI_Account_Type	char(15)	NULL	Account Type -Consumption/Suspense type	No	No
CWFI_MntLoss_Act	char(15)	NULL	maintenance loss account	No	No
CWFI_MntAdj_Act	char(15)	NULL	maintenance adjustment account code	No	No
CWFI_Erate_Type	char(15)	NULL	Exchange rate type	No	No
CWFI_BaseCurrency	char(15)	NULL	Base Currency	No	No
CWFI_Base_ExhRate	char(15)	NULL	base currency exchange rate	No	No
CWFI_Parallel_Currency	char(15)	NULL	Parallel currency	No	No
CWFI_Parallel_ExhRate	char(15)	NULL	Parallel currency Exchange rate	No	No
CWFI_Company	char(15)	NULL	Company code	No	No
CWFI_BU	char(15)	NULL	business unit code	No	No
CWFI_Created_By	char(15)	NULL	Created login user	No	No
CWFI_Created_Date	char(15)	NULL	Creation date	No	No
CWFI_Modified_By	char(15)	NULL	Modified user name	No	No
CWFI_Modified_Date	char(15)	NULL	modified date	No	No
CWFI_COST_CENTER	char(15)	NULL	Cost Center	No	No

Table Name cwo_cwh_comp_wo_hdr

Table Comment CWO Header Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cwh_ouinstance	numeric(10)	NOT NULL	CWO OU Instance	Yes	No
cwh_CompWorkorder	varchar(40)	NOT NULL	Comp Work Order	Yes	No
cwh_ComponentID	varchar(90)	NOT NULL	CWO Component ID	No	No
cwh_SourceOu	char(15)	NULL	Source Document Ouinstance (EO,FC,Workscope)	No	No
cwh_CompOUInst	numeric(10)	NOT NULL	Comp Ou Instance	No	No
cwh_partno	varchar(40)	NOT NULL	Component Part No	No	No
cwh_part_ou	char(15)	NULL	Associated part ou	No	No
cwh_partserialno	varchar(40)	NOT NULL	Comp Part Serial No	No	No
cwh_warranty	varchar(25)	NULL	Comp Warranty	No	No
cwh_sourcedoctype	varchar(25)	NULL	Source Document Type	No	No
cwh_SourceDocumentNo	varchar(40)	NULL	Source Document No	No	No
cwh_Rotablereplcmtno	varchar(40)	NULL	Component replacement No	No	No
cwh_cwodesc	varchar(150)	NULL	CWO Desc	No	No
cwh_CwoDesc_UP	varchar(150)	NULL	Comp work order Description in Upper case	No	No
cwh_CWOtype	varchar(25)	NULL	CWO Type-Maintenance type	No	No
cwh_CWOUDStatus	varchar(25)	NULL	CWO user Status	No	No
cwh_CWOPriorityno	numeric(10)	NULL	CWO Priority No	No	No
cwh_CWOcategory	varchar(25)	NULL	CWO Category	No	No
cwh_parentcwo	varchar(40)	NULL	CWO Parent WO NO	No	No
cwh_precedencecwo	varchar(40)	NULL	CWO Precedence WO No	No	No
cwh_PrimaryWCCode	varchar(30)	NOT NULL	Primary Work Center Code	No	No
cwh_WCOUInstance	numeric(10)	NOT NULL	Work Center OU Instance	No	No
cwh_cwostdate	datetime	NULL	CWO Start Date	No	No
Cwh_DisplayTimeuom	varchar(5)	NULL	Display Time UOM	No	No
cwh_CWOEnddate	datetime	NULL	CWO End Time	No	No
cwh_EstElapsedTime	numeric(28,8)	NULL	CWO Elapsed Time	No	No
Cwh_DisplayEst_Elap_Time	numeric(28,8)	NULL	Estimated Elapsed Time in Display Unit	No	No
cwh_status	varchar(5)	NOT NULL	CWO Status	No	No
cwh_MaxUniqueTaskNo	numeric(10)	NULL	CWO Max Task Serial No	No	No
cwh_ReschCount	numeric(10)	NULL	Rescheduled Count	No	No
cwh_EstManHrs	numeric(28,8)	NULL	Estimated Man Hrs	No	No
cwh_MiscCost	numeric(28,8)	NULL	Misc Cost	No	No
cwh_currency	varchar(20)	NULL	CWO Currency	No	No
cwh_CoMReqd	varchar(5)	NULL	Sign off Required Yes/No Checked - Yes, UnChecked - No	No	No
cwh_SchFlag	varchar(25)	NULL	Schedule Flag	No	No
Cwh_Childcount	numeric(10)	NULL	Sub work Orders Count	No	No
cwh_InspFindings	varchar(25)	NULL	Inspected Findings Flag	No	No
cwh_ESReqNo	varchar(40)	NULL	ES Request No	No	No
cwh_AOGFlag	varchar(25)	NULL	AOG Flag	No	No
cwh_ComStatus	varchar(15)	NULL	Com Status Flag ’ Y’ OR ’N’	No	No
cwh_Remarks	varchar(255)	NULL	Authorization Remarks	No	No
cwh_SourceDocRevNo	varchar(40)	NULL	Source Document No Revision No used to Store the EO Revision no	No	No
cwh_workPhoneNo	varchar(30)	NULL	Work Phone No	No	No
cwh_ContactPerson	varchar(80)	NULL	Contact Person	No	No
cwh_RequiredDate	datetime	NULL	Required Date	No	No
cwh_EnggAdviseNoteNo	varchar(40)	NULL	EAN No	No	No
cwh_Auth_Status	varchar(20)	NULL	Authorisation status is 1. Pending for authorisation. 2.Not Required	No	No
cwh_Transient_Status	varchar(20)	NULL	Transient Status	No	No
cwh_EnggAdvNote_RevNo	varchar(40)	NULL	Engineering Advice Note Revision No	No	No
cwh_MatEstimated	varchar(25)	NULL	Material Estimated - Work order level ’M’	No	No
cwh_ResEstimated	varchar(25)	NULL	Resource Estimated - Work order Level ’R’	No	No
cwh_AuthorizedBy	varchar(30)	NULL	Authorized By the User Login Name	No	No
cwh_AuthDate	datetime	NULL	Auth Date	No	No
cwh_createdby	varchar(30)	NOT NULL	Created By Login Name	No	No
cwh_created_date	datetime	NOT NULL	Created Date	No	No
cwh_modified_date	datetime	NOT NULL	modified Date	No	No
cwh_modified_by	varchar(30)	NOT NULL	modified By	No	No
cwh_timestamp	numeric(10)	NOT NULL	Timestamp	No	No
cwh_asscmp_comments	char(255)	NULL	comments for Associated components to Component work order	No	No
Cwh_MainCoreIssue	char(5)	NULL	Required -R Not Required -NR	No	No
cwh_job_type	varchar(20)	NULL	Job Type COM - Component FAC - Facility MAK - Make PIP - Piece Part PRO - Project RIN - Receipt-Inspection OTH - Miscellaneous	No	No
cwh_work_scope	varchar(20)	NULL	Work scope no	No	No
cwh_work_scope_ou	int	NULL	Work Scope OU	No	No
cwh_work_order_type	varchar(20)	NULL	CWO Type P - Planned U - UnPlanned	No	No
cwh_make_or_piece_part_no	varchar(20)	NULL	Make or peice part number	No	No
cwh_make_or_piece_part_ou	int	NULL	Make or peice part OU	No	No
cwh_make_or_repair_qty	char(15)	NULL	Make or repair quantity	No	No
cwh_scrap_qty	char(15)	NULL	Scrape quantity	No	No
cwh_comments	varchar(20)	NULL	Entered Comments	No	No
CWH_CWOREMFROM_AIRCR_REGNO	char(15)	NULL	Persist Aircraft Reg No	No	No

Table Name cwo_cwn_comp_wo_notes

Table Comment CWO Notes Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cwn_created_by	varchar(30)	NULL	Created By User name	No	No
cwn_created_date	datetime	NULL	Created Date	No	No
cwn_modified_date	datetime	NULL	Modified Date	No	No
cwn_modified_by	varchar(30)	NULL	Modified By	No	No
cwn_ouinstance	numeric(10)	NOT NULL	Wo OU Instance	Yes	Yes
cwn_Notes	varchar(2000)	NULL	CWO Notes	No	No
cwn_compworkorder	varchar(40)	NOT NULL	Comp Work Order	Yes	Yes

Table Name CWO_CWOTST_CWOTSK_SUB_TASK

Table Comment SubTask Information of a Component Work Order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CWOTST_OUINSTANCE	decimal(10)	NOT NULL	Organisation Unit of the component workorder.	Yes	No
CWOTST_COMPWORKORDER	varchar(40)	NOT NULL	Component workorder number.	Yes	No
CWOTST_TASKSERIALNO	decimal(10)	NOT NULL	Task serial number of the task in component workorder of the task which the subtask are to be signed off.	Yes	No
CWOTST_SEQNO	decimal(10)	NOT NULL	Task sequence number of the task in component workorder of the task which the subtask are to be signed off	Yes	No
CWOTST_PART_NO	varchar(40)	NULL	Part number for the task.	No	No
CWOTST_SERIAL_NO	varchar(40)	NULL	Part Serial Number	No	No
CWOTST_COMPONENT_ID	varchar(90)	NULL	Component Id of the component workorder.	No	No
CWOTST_TASK_CODE	varchar(40)	NULL	Task code in the component workorder.	No	No
CWOTST_TASK_REV_NO	varchar(40)	NULL	Latest revision number of the task.	No	No
CWOTST_TASK_OU	decimal(10)	NULL	OU instance of the task from where it has been added into the CWO.	No	No
CWOTST_SUB_TASK	varchar(2000)	NULL	Subtask code for the task code in the cwo.	No	No
CWOTST_SUB_TASK_SEQ_NO	decimal(10)	NULL	unique sub task sequence number	No	No
CWOTST_RESOURCE_GROUP	varchar(5)	NULL	Resource group (Inspector/Mechanic)	No	No
CWOTST_SKILL_CODE	varchar(30)	NULL	Employee skill code.	No	No
CWOTST_SKILL_OU	decimal(10)	NULL	Organisation unit of the skill code.	No	No
CWOTST_SIGN_OFF_STATUS	varchar(25)	NULL	Subtask singnoff status (Yes/No/Void)	No	No
CWOTST_FILE_NAME	varchar(50)	NULL	Attached File Name	No	No
CWOTST_SIGN_OFF_COMMENTS	varchar(2000)	NULL	Comments entered at the time of signoff of the subtask.	No	No
CWOTST_SIGN_OFF_DATE	datetime	NULL	Signoff date.	No	No
CWOTST_EMP_CODE	varchar(40)	NULL	Employee who does signoff of the subtask.	No	No
CWOTST_MECH_SIGN_OFF_FLAG	varchar(5)	NULL	Has the mechanic has performed signoff [Yes/No]	No	No
CWOTST_MODIFIEDDATE	datetime	NULL	Signoff details modification date.	No	No
CWOTST_MODIFIED_BY	varchar(30)	NULL	Login id of the user who modified the record.	No	No
CWOTST_TIMESTAMP	numeric(28)	NULL	number of times the record has been modified.	No	No

Table Name cwo_cwotst_cwotsk_sub_task

Table Comment Sub Task Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cwotst_sign_off_status	varchar(25)	NULL	Sign Off Status Y- Yes N - No	No	No
cwotst_file_name	varchar(50)	NULL	Attached File name	No	No
cwotst_sign_off_comments	varchar(2000)	NULL	Sign Off comments	No	No
cwotst_skill_ou	numeric(10)	NULL	Skill Ou	No	No
cwotst_skill_code	varchar(30)	NULL	Skill code	No	No
cwotst_resource_group	varchar(5)	NULL	Resource Group MEC - Mechanic INS - Inspector	No	No
cwotst_modifieddate	datetime	NULL	Modified Date	No	No
cwotst_modified_by	varchar(30)	NULL	Modified By	No	No
cwotst_sign_off_date	datetime	NULL	Sign Off Date	No	No
CWOTST_MECH_SIGN_OFF_FLAG	varchar(5)	NULL	Mechanic Sign Off Flag Y- Yes N - No	No	No
cwotst_emp_code	varchar(40)	NULL	Employee Code	No	No
CWOTST_TIMESTAMP	numeric	NULL	Timestamp	No	No
cwotst_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
cwotst_seqno	numeric(10)	NOT NULL	Sequence no	Yes	No
cwotst_part_no	varchar(40)	NULL	Associated Part no	No	No
cwotst_CompWorkorder	varchar(40)	NOT NULL	CWO Work Order	Yes	Yes
cwotst_ouinstance	numeric(10)	NOT NULL	CWO OU Instance	Yes	Yes
cwotst_sub_task_seq_no	numeric(10)	NULL	Associated Sub Task seq no	No	No
cwotst_task_ou	numeric(10)	NULL	Associated Task OU	No	No
cwotst_sub_task	varchar(2000)	NULL	Associated Sub Task no	No	No
cwotst_serial_no	varchar(40)	NULL	Serial number	No	No
cwotst_component_id	varchar(90)	NULL	Component Id	No	No
cwotst_task_rev_no	varchar(40)	NULL	Task revision number	No	No
cwotst_task_code	varchar(40)	NULL	Associated Task Code	No	No

Table Name cwo_cwp_parameter_dtl

Table Comment Component Work Order Parameter Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cwp_componentname	varchar(80)	NOT NULL	CWO Component Name	Yes	No
Cwp_ParamCategory	varchar(10)	NOT NULL	Parameter Category	Yes	No
Cwp_ParamType	varchar(25)	NOT NULL	Parameter Types	Yes	No
Cwp_ParamCode	varchar(5)	NOT NULL	Param Code	Yes	No
Cwp_DisplayOrder	decimal(10)	NOT NULL	Display Order	No	No
Cwp_LangId	decimal(10)	NOT NULL	Lang Id	No	No
Cwp_ParamDesc	varchar(80)	NULL	param Desc	No	No
Cwp_CreationDate	datetime	NOT NULL	Creation Date	No	No

Table Name cwo_cwpsd_piece_prt_srl_dtl

Table Comment Holds piece part serial details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cwpsd_quantity	numeric(28,8)	NULL	Quantity	No	No
cwpsd_lot_no	varchar(18)	NULL	Lot No	No	No
cwpsd_condition	varchar(5)	NULL	Condition SER - Serviceable USR - Un Serviceable PO - Phased Out B - Blank	No	No
cwpsd_remarks	varchar(255)	NULL	Remarks	No	No
cwpsd_pend_ret_qty	numeric(28,8)	NULL	Pending Return Quantity	No	No
cwpsd_CompWorkorder	varchar(40)	NOT NULL	Comp Work Order	Yes	Yes
cwpsd_ouinstance	numeric(10)	NOT NULL	CWO OU Instance	Yes	Yes
cwpsd_serial_no	varchar(40)	NOT NULL	Serial number	No	No
cwpsd_seq_no	int	NOT NULL	Sequence no	Yes	No
cwpsd_part_no	varchar(40)	NOT NULL	Associated part number	No	No

Table Name cwo_cws_comp_wo_sch_dtl

Table Comment CWO Schedule Details History. This Entity maintains the Scheduling details of the WO and Task. The Last Resch Count Rev Start/End Date and Time Represent the Planned Start /End and Times of the CWo /Task
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cws_RevStdate	datetime	NULL	Rev Wo Start Date	No	No
cws_plenddate	datetime	NULL	Planned End Date	No	No
cws_plstdate	datetime	NULL	Planned Start Date	No	No
cws_scheduleRemarks	varchar(255)	NULL	Schedule Remarks	No	No
cws_RevEndDate	datetime	NULL	Rev End Date	No	No
cws_scheduledBy	varchar(30)	NULL	The Rescheduling done by - Login User	No	No
cws_created_date	datetime	NULL	Reschedule Transaction Date	No	No
cws_CompWorkOrder	varchar(40)	NOT NULL	CWo No	Yes	Yes
cws_ouinstance	numeric(10)	NOT NULL	OU Instance	Yes	Yes
cws_status	varchar(5)	NOT NULL	CWO/Task Status at the time of Reschedule	No	No
cws_ReschType	varchar(25)	NOT NULL	Reschedule Type W - Work Order Level T - Task Level	No	No
cws_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
cws_ReschCount	numeric(10)	NOT NULL	Reschedule Count for this CWO/ task	Yes	No

Table Name cwo_cwt_comp_wo_task_dtl

Table Comment CWO Planned Task Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cwt_ouinstance	numeric(10)	NOT NULL	CWO OU Instance	Yes	Yes
cwt_CompWorkorder	varchar(40)	NOT NULL	CWO Work Order	Yes	Yes
cwt_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	No
cwt_seqno	numeric(10)	NOT NULL	Sequence No	No	No
cwt_Taskcode	varchar(30)	NOT NULL	Task Code	No	No
cwt_RevisionNo	varchar(40)	NOT NULL	Task Revision No	No	No
cwt_TaskOuinstance	numeric(10)	NOT NULL	Task Ou Instance	No	No
cwt_PlanUnplanType	varchar(25)	NOT NULL	Task Types : P - Planned Tasks U - Unplanned Tasks Unplanned Tasks can be added using Unplanned Tasks Reporting	No	No
cwt_WCCode	varchar(30)	NOT NULL	Work Center	No	No
cwt_TaskPriorityNo	numeric(10)	NULL	Task Priority	No	No
Cwt_DisplayTimeUom	varchar(5)	NULL	Display time Uom	No	No
cwt_EstElapsedTime	numeric(28,8)	NULL	Estimated Elapsed Time	No	No
cwt_EstManHrs	numeric(28,8)	NULL	Estimated Man Hrs	No	No
Cwt_Displayest_Elap_Time	numeric(28,8)	NULL	Display Duration	No	No
cwt_CWOPlStartDate	datetime	NULL	Planned Start Date	No	No
cwt_CWOPlEndDate	datetime	NULL	Planned End Date	No	No
cwt_status	varchar(5)	NOT NULL	CWO Status	No	No
cwt_Transient_Status	varchar(10)	NULL	Transient Status	No	No
cwt_Auth_Status	varchar(10)	NULL	Authorisation status is Authorisation Reqd Pending for Authorisation	No	No
cwt_ReschCount	numeric(10)	NULL	Reschedule Count Value - Represent the latest value Initial Value Would be Zero	No	No
cwt_ResAssigned	varchar(25)	NULL	Resource Assigned Status	No	No
cwt_EmpAssigned	varchar(25)	NULL	Employee Assigned	No	No
cwt_MatPlanned	varchar(25)	NULL	Material Planned	No	No
cwt_MatEstimated	varchar(25)	NULL	Link Flag Indicating whether the Material Estimated or Not Maintained by the Material Estimation Valid Values M - Material	No	No
cwt_ResEstimated	varchar(25)	NULL	Link Flag Indicating the Resource Estimation Status Default Value NULL R - Resource Estimated Maintained by the Resource Estimation	No	No
cwt_ref_workunit_ou	numeric(10)	NULL	WorkUnit OUInstance, Reference Task, SP or WP OU	No	No
cwt_ref_workunit_type	varchar(5)	NULL	Reference WorkUnit Type Task - T Standard Procedure - P work Package - W	No	No
cwt_ref_workunit	varchar(40)	NULL	Reference Work Unit No Task, Sp or WP	No	No
cwt_created_date	datetime	NOT NULL	Created Date	No	No
cwt_created_by	varchar(30)	NOT NULL	Record Created User Name	No	No
cwt_modified_date	datetime	NOT NULL	Last Modification Date	No	No
cwt_modified_by	varchar(30)	NOT NULL	Last Modified By	No	No
cwt_timestamp	numeric(10)	NOT NULL	Timestamp	No	No
cwt_parttimestamp	numeric(10)	NULL	Part Time Stamp - Used for concurrency check during the part consumption reporting	No	No
cwt_restimestamp	numeric(10)	NULL	Resource Timestamp Used to check for the concurrency during resource reporting	No	No
cwt_delayTimestamp	numeric(10)	NULL	Delay Details timestamp	No	No
cwt_ref_srcdocno	char(18)	NULL	Reference Document no of tasks Work scope no/EO no/FCD no/Component id/DP no/Maint Report no/CWO no/null	No	No
cwt_ref_srcdoctype	char(25)	NULL	Reference Document type of tasks CMPL-Workscope EO-Engineering order FC-FCD CWOTY-Component maintenance pgm DP-Discrepancy processing MR-Maint Report CWO-Copied from CWO no null-new tasks	No	No
cwt_child_component_id	varchar(20)	NULL	This will have component ids identified against restoration and removal work units in Component Maintenance Planning.	No	No
cwt_ref_maint_type	char(15)	NULL	Maintenance Type	No	No
CWT_PARENT_TASKCODE	char(30)	NULL	Parent Task of the Related Task	No	No
CWT_TASK_RELATIONSHIP	char(5)	NULL	Relationship of the Related Task	No	No
CWT_PERPETUAL_FLAG	char(5)	NULL	Whether Related Task is Perpetual or not	No	No

Table Name cwo_dri_doc_ref_info

Table Comment Component Work Order Document Reference Information
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
dri_created_by	varchar(30)	NULL	Created By User name	No	No
dri_taskcode	char(15)	NULL	Task number	No	No
dri_document_id	varchar(40)	NULL	Document ID	No	No
dri_created_date	datetime	NULL	Created Date	No	No
dri_modified_by	varchar(30)	NULL	Record Last Modified By	No	No
dri_modified_date	datetime	NULL	Record Last Modified Date	No	No
dri_CompWorkOrder	varchar(40)	NOT NULL	Comp Work Order	Yes	Yes
dri_ouinstance	numeric(10)	NOT NULL	CWO OU Instance	Yes	Yes
dri_file_name	varchar(30)	NULL	File Name	No	No
dri_reference_doc_type	varchar(15)	NULL	Reference Document Type (CWO Quick Codes )	No	No
dri_taskserialno	int	NOT NULL	Task Serial number	Yes	No
dri_seq_no	numeric(10)	NOT NULL	Running Serial No (System Generated)	Yes	No

Table Name CWO_EAD_EMP_ASSIGN_DTL

Table Comment Employee Assignment Details - Daywise
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
EAD_COMPWORKORDER	varchar(40)	NOT NULL	Component workorder number for which the employee is being assigned.	Yes	No
EAD_TASKSERIALNO	decimal(10)	NOT NULL	Task serial number of the task against which the employee is assigned for the workorder.	Yes	No
EAD_EMPCODE	varchar(15)	NOT NULL	Employee code of the employee who is being assigned.	Yes	No
EAD_EMPSEQNO	decimal(10)	NOT NULL	If more than one employee is assigned, the a unique number to distinguish the employees.	Yes	No
EAD_OUINSTANCE	decimal(10)	NOT NULL	Organisation unit of the login user who assigns the employee.	Yes	No
EAD_FROMDATE	datetime	NULL	Start date from which the employee is assigned.	No	No
EAD_TODATE	datetime	NULL	End date from which the employee is assigned.	No	No
EAD_DISPLAYTIMEUOM	varchar(5)	NULL	Unit of measurement of the time displayed in the UI.	No	No
EAD_TIMEPERDAY	decimal(28,8)	NULL	Total working hours per day.	No	No
EAD_DISPLAYTIMEPERDAY	decimal(28,8)	NULL	Total working hours per day displayed in the UI.	No	No
EAD_CREATED_DATE	datetime	NOT NULL	Employee assignment creation date.	No	No
EAD_CREATED_BY	varchar(30)	NOT NULL	Login user’s id who created the details.	No	No
EAD_MODIFIED_DATE	datetime	NOT NULL	date of modification of the details.	No	No
EAD_MODIFIED_BY	varchar(30)	NOT NULL	Login user’s id who modifies the details.	No	No
EAD_TIMESTAMP	decimal(10)	NOT NULL	Number of times the details has been modified.	No	No
EAD_ASSGNHOURS	decimal(15,4)	NULL	Employee Assigned hours.	No	No

Table Name cwo_ead_emp_assign_dtl

Table Comment CWO Employee Assignment Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ead_created_date	datetime	NOT NULL	Record Created Date	No	No
ead_created_by	varchar(30)	NOT NULL	Record Created user login anme	No	No
ead_Displaytimeperday	numeric(28,8)	NULL	Display Duration	No	No
ead_timeperday	numeric(28,8)	NULL	Time Per Day - Stored in Min. During display it should be converted to unit of Display	No	No
ead_timestamp	numeric(10)	NOT NULL	Timestamp	No	No
ead_modified_date	datetime	NOT NULL	Last Modified Date	No	No
ead_modified_by	varchar(30)	NOT NULL	Last Modified By	No	No
ead_assgnhours	char(15)	NULL	Assigned hours (between From date and To date)	No	No
ead_CompWorkOrder	varchar(40)	NOT NULL	CWO	Yes	Yes
ead_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
ead_ouinstance	numeric(10)	NOT NULL	OU Instance	Yes	Yes
ead_DisplayTimeUOM	varchar(5)	NULL	Display Time UOM	No	No
ead_todate	datetime	NULL	To Date	No	No
ead_Empcode	varchar(15)	NOT NULL	Employee Code	Yes	No
ead_Fromdate	datetime	NULL	From Date	No	No
ead_EmpSeqno	numeric(10)	NOT NULL	Unique Emp Seq no - System Generated. Running Serial no for a given CWO, Task, Emp Code.	Yes	No

Table Name cwo_eday_emp_assign_dtl

Table Comment CWO Employee Assignment Details -Day wise
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eday_endtime	datetime	NOT NULL	Assign Date -End Time	Yes	No
eday_starttime	datetime	NOT NULL	Assign Date -Start Time	Yes	No
eday_assgndate	datetime	NOT NULL	Assignment Date	Yes	No
eday_assgnhours	numeric(28,8)	NULL	Assigned hours (between Assgn Date Start Time and End time)	No	No
eday_DisplayTimeUOM	varchar(5)	NULL	Display Time UOM	No	No
eday_Displaytimeperday	numeric(28,8)	NULL	Display Duration	No	No
eday_CompWorkOrder	varchar(40)	NOT NULL	CWO	Yes	Yes
eday_ouinstance	numeric(10)	NOT NULL	OU Instance	Yes	Yes
eday_EmpSeqno	numeric(10)	NOT NULL	Unique Emp Seq no - System Generated. Running Serial no for a given CWO, Task, Emp Code.	Yes	Yes
eday_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
eday_Empcode	varchar(15)	NOT NULL	Employee Code	Yes	Yes

Table Name CWO_EDAY_EMP_ASSIGN_DTL

Table Comment Employee Assignment Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
EDAY_OUINSTANCE	decimal(38)	NOT NULL	Organization unit of the login user who assigns the employee.	Yes	No
EDAY_COMPWORKORDER	varchar(40)	NOT NULL	Component workorder number against which the employee is assigned.	Yes	No
EDAY_TASKSERIALNO	decimal(10)	NOT NULL	Task serial number of the task for which the employee is assigned.	Yes	No
EDAY_EMPCODE	varchar(15)	NOT NULL	employee code of the employee assigned for the task.	Yes	No
EDAY_EMPSEQNO	decimal(10)	NOT NULL	If more than one employee is assigned for a task then the unique sequence number to identify each employee.	Yes	No
EDAY_ASSGNDATE	datetime	NOT NULL	Date on which the employee is assigned.	Yes	No
EDAY_STARTTIME	datetime	NOT NULL	Start time for the employee work assigned.	Yes	No
EDAY_ENDTIME	datetime	NOT NULL	End time for the employee work assigned.	Yes	No
EDAY_DISPLAYTIMEUOM	varchar(5)	NULL	Unit of measurement of the time displayed.	No	No
EDAY_ASSGNHOURS	decimal(28,8)	NULL	Number of hours the employee has been assigned.	No	No
EDAY_DISPLAYTIMEPERDAY	decimal(28,8)	NULL	Unit of measurement to be displayed in the screen.	No	No

Table Name CWO_EPD_EST_PARTS_DETL

Table Comment Component Work Order Part Estimation Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
epd_specific_Issqty	char(15)	NULL	It has to be updated from Issue component for the part’s Requirement type ’Specific’.	No	No
epd_specific_Reqqty	char(15)	NULL	It has to be updated thro’ serial/lot no page. whenever changing the qty (summation of the sl no/lot no qty for the part)	No	No
epd_request_priority	varchar(20)	NULL	Request Priority NOR - Normal AOG - AOG	No	No
EPD_PEND_MAIN_CORE_RET	decimal(28,8)	NULL	Number of parts that needs to be returned to warehouse of type ’Main Core’	No	No
epd_Part_Crt_Ou	int	NULL	Central Reference List Part Ou	No	No
epd_ReqType	char(5)	NULL	Requirement Type Specific (S)If Any lot/serial no defined for the part NorMal (N) -If no lot/serial no defined in the Edit Preferred/Serial # Screen	No	No
epd_Warehouse_Ou	int	NULL	Ou of Ware House	No	No
epd_MaterialType	char(5)	NULL	Material Type Main Core -MC Regular -RG	No	No
epd_timestamp	int	NOT NULL	Timestamp	No	No
EPD_NEEDFREQ	char(5)	NULL	Need Freq	No	No
EPD_REMARKS	varchar(255)	NULL	Remarks	No	No
EPD_NEWPARTNO	char(5)	NULL	EPD_NEWPARTNO	No	No
EPD_PEND_RET_QTY	decimal(28,8)	NULL	Number of parts that needs to be returned to warehouse of type other than ’Main Core’	No	No
EPD_RETURN_QTY	decimal(28,8)	NULL	Total number of parts that has been returned to warehouse other than ’Main Core’	No	No
EPD_REQD_CONDITION	varchar(5)	NULL	Required Condition	No	No
EPD_RET_CORE_QTY	decimal(28,8)	NULL	Total number of parts that has been returned to warehouse of type ’Main Core’	No	No
EPD_RETURN_BASIS	varchar(5)	NULL	Type of return eg: core returnable.	No	No
EPD_PARTDESC	char(150)	NULL	EPD_PARTDESC	No	No
epd_WarehouseNo	char(10)	NULL	Warehouse No	No	No
epd_stock_status	varchar(20)	NULL	Stock Status	No	No
epd_UOM	char(10)	NOT NULL	Requested and Consumed Qty UOM	No	No
epd_parttype	char(25)	NOT NULL	Part Type - Stored for ease of Search Filter	No	No
epd_CompWorkOrder	varchar(40)	NOT NULL	Component Work Order number	Yes	Yes
epd_ouinstance	numeric(10)	NOT NULL	OU Instance	Yes	Yes
epd_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
epd_PartNo	char(40)	NOT NULL	Part No	Yes	No
epd_modified_by	char(30)	NOT NULL	Last Modified By	No	No
epd_created_date	datetime	NOT NULL	Transaction Date	No	No
epd_MatCost	numeric(28,8)	NULL	Material Cost = Qty Required * Standard Part Cost	No	No
epd_created_by	char(30)	NOT NULL	Login User Id	No	No
epd_modified_date	datetime	NOT NULL	Last Modification Date	No	No
epd_sub_part_no	char(15)	NULL	Substitute part no	No	No
epd_sub_part_crt_ou	char(15)	NULL	Substitute part created ou	No	No
epd_QtyIssued	numeric(28,8)	NULL	Total Qty Issued in the epd_UOM Updated whenever the issue against the task gets Confirmed.	No	No
epd_sub_type	char(15)	NULL	Substitute Type is ’NHA’ , ’ALTERHATE’	No	No
epd_QtyReq	numeric(28,8)	NOT NULL	Total requested Qty	No	No

Table Name cwo_erd_est_res_dtl

Table Comment CWO Estimated Resource Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
erd_rescost	numeric(28,8)	NULL	Resource Cost	No	No
erd_ApplReqd	char(15)	NULL	Approval Required ’YES’ or ’NO’	No	No
erd_SignOff	varchar(25)	NULL	Sign off Required	No	No
erd_QtyReq	numeric(28,8)	NULL	Qty Required	No	No
erd_modified_by	varchar(30)	NOT NULL	Last Modified User Name	No	No
erd_created_date	datetime	NOT NULL	Record Created Date	No	No
erd_modified_date	datetime	NOT NULL	Last Modification Date	No	No
erd_created_by	varchar(30)	NOT NULL	Record Created By	No	No
erd_timestamp	numeric(10)	NOT NULL	Timestamp	No	No
erd_compworkorder	varchar(40)	NOT NULL	CWO	Yes	Yes
erd_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
erd_ouinstance	numeric(10)	NOT NULL	OU Instance	Yes	Yes
erd_DispTimeUom	varchar(5)	NULL	Display Time UOM	No	No
erd_DispReqDur	numeric(28,8)	NULL	Display Required Duration in the Display Time UOM	No	No
erd_ResourceCode	varchar(40)	NOT NULL	Resource Code	Yes	No
erd_ReqdDuration	numeric(28,8)	NULL	Required Duration In MIn	No	No
erd_Resourcetype	varchar(5)	NOT NULL	Resource Type	Yes	No

Table Name CWO_ERD_EST_RES_DTL

Table Comment Resource Requirements for a WorkOrder
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ERD_COMPWORKORDER	varchar(40)	NOT NULL	Component workorder number	Yes	No
ERD_TASKSERIALNO	decimal(10)	NOT NULL	component workorder task serial number	Yes	No
ERD_RESOURCECODE	varchar(40)	NOT NULL	Resource code	Yes	No
ERD_RESOURCETYPE	varchar(5)	NOT NULL	Resource type(Tool/Skill/other/Equipment)	Yes	No
ERD_OUINSTANCE	decimal(10)	NOT NULL	Organisation Unit	Yes	No
ERD_REQDDURATION	decimal(28,8)	NULL	Required duration of the resource	No	No
ERD_DISPREQDUR	decimal(28,8)	NULL	Value of the required hours displayed in the front end.	No	No
ERD_DISPTIMEUOM	varchar(5)	NULL	Unit of measurement.	No	No
ERD_QTYREQ	decimal(28,8)	NULL	Required quantity	No	No
ERD_SIGNOFF	varchar(25)	NULL	Resource siignoff status.	No	No
ERD_RESCOST	decimal(28,8)	NULL	Resource cost.	No	No
ERD_APPLREQD	varchar(25)	NULL	Appln Required (Y/N)	No	No
ERD_CREATED_DATE	datetime	NOT NULL	Report Resource Actuals Information creation date.	No	No
ERD_CREATED_BY	varchar(30)	NOT NULL	Resource Actuals Information created user (Login user id)	No	No
ERD_MODIFIED_DATE	datetime	NOT NULL	Resource Actuals Information modified date	No	No
ERD_MODIFIED_BY	varchar(30)	NOT NULL	User who modifies Resource Actuals Information (Login user.)	No	No
ERD_TIMESTAMP	decimal(10)	NOT NULL	Number of times the record has been modified.	No	No
ERD_RESOURCE_OU		NULL	Organization unit of the resource.	No	No

Table Name CWO_ESLD_EST_SRL_LOT_DTL

Table Comment Component Work Order Part Estimation Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ESLD_PEND_MAIN_CORE_RET	decimal(28,8)	NULL	Total number of parts of type Main core pending for return.	No	No
ESLD_PEND_RET_QTY	decimal(28,8)	NULL	Total number of parts of type other than Main core pending for return.	No	No
esld_Issued_qty	char(15)	NULL	Updated Issued qty from Issue	No	No
esld_ComponentID	char(15)	NULL	Component ID	No	No
esld_LotNo	char(40)	NULL	Lot number	No	No
ESLD_STOCKSTATUS	varchar(40)	NULL	Stock status of the part.	No	No
ESLD_MANFSERIAL_NO	varchar(40)	NULL	Manufacturing serial number for the part.	No	No
ESLD_RETURN_QTY	decimal(28,8)	NULL	Total number of parts returned	No	No
ESLD_RETURN_BASIS	varchar(5)	NULL	Return Basis	No	No
ESLD_RET_CORE_QTY	decimal(28,8)	NULL	Total number of Main core parts returned.	No	No
ESLD_MANFLOT_NO	varchar(40)	NULL	Manufacturing lot number for the part.	No	No
esld_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
ESLD_PARTNO	varchar(40)	NOT NULL	Part Number	Yes	No
esld_CompWorkOrder	varchar(40)	NOT NULL	Component Work Order	Yes	Yes
esld_ouinstance	numeric(10)	NOT NULL	Organisation Unit	Yes	Yes
esld_SerialNo	char(15)	NULL	Serial number	No	No
esld_displayseqno	int	NULL	Display sequence number	No	No
esld_Quantity	numeric(28,8)	NULL	Estimated quantity	No	No
esld_MaterialType	char(5)	NOT NULL	Material Type MC - Main Core RG - Regular	Yes	No
epd_PartNo	char(40)	NOT NULL	Part No	Yes	Yes
esld_seqno	int	NOT NULL	Sequence Number	Yes	No

Table Name cwo_ifrd_insp_find_report_dtl

Table Comment CWO Inspection Findings Report details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ifrd_ouinstance	numeric(10)	NOT NULL	WO OU Instance	Yes	Yes
ifrd_CompWorkOrder	varchar(40)	NOT NULL	CWO	Yes	Yes
ifrd_DocumentNo	varchar(18)	NOT NULL	Discrepancy No/MR No	Yes	No
ifrd_DocumentType	char(5)	NOT NULL	Document Type-’DP’ -Discrepancy ’MR’-Maint Report	Yes	No
ifrd_disc_flag	varchar(20)	NOT NULL	This column will have values R or P. R for Reported Discrepancies and P for Pending Discrepancies.	Yes	No
ifrd_Document_desc	char(255)	NULL	Discrepancy Description/MR Description	No	No
ifrd_Document_status	char(5)	NULL	Discrepancy Status or MR Status F - Fresh C - Closed	No	No
ifrd_partno	varchar(40)	NULL	Part No	No	No
ifrd_partno_ou	int	NULL	Associated part’s ou	No	No
ifrd_partserialno	varchar(40)	NULL	Part Serial No	No	No
ifrd_ComponentId	char(90)	NULL	component Id	No	No
ifrd_ComponentId_ou	int	NULL	Associated component’s OU	No	No
ifrd_remedialaction	varchar(255)	NULL	Remedial action	No	No
ifrd_source_doc_no	char(18)	NULL	Source Document No - If the Discrepancies are reported during Removal, CR# would be Source Document No. Otherwise it would be CWO#	No	No
ifrd_source_doc_type	char(25)	NULL	Source Document Type CWO - Component Work Order # CR - Component Replacement #	No	No
ifrd_source_doc_ou	int	NULL	Source Document OU#	No	No
ifrd_ReportedBy	varchar(30)	NULL	Reported By	No	No
ifrd_ReportedDate	datetime	NULL	Reported Date	No	No
ifrd_CreatedDate	datetime	NULL	Transaction Date	No	No
ifrd_CreatedBy	varchar(30)	NULL	Recorded By	No	No
ifrd_ModifiedDate	datetime	NULL	Last Modification Date	No	No
ifrd_ModifiedBy	varchar(30)	NULL	Last Modified By	No	No
ifrd_ExpTTATime_Disp	numeric(10)	NULL	Display Expected Turn Around Time	No	No
ifrd_ExpTTATime_Min	numeric(10)	NULL	Expected Time around time in Min	No	No
ifrd_TimeUOM	char(5)	NULL	Time Unit in UOM	No	No
ifrd_Action	char(5)	NULL	Action -Blank,No fault found,Cancelled,To process and Transfer	No	No
ifrd_Tracking_status	char(25)	NULL	Tracking Status from common master	No	No
ifrd_rectifiedby	char(30)	NULL	Rectified user	No	No
ifrd_Inspectedby	char(30)	NULL	Inspected user	No	No
ifrd_EanNo	char(18)	NULL	Engineering Advice note no	No	No
ifrd_EanNo_ou	int	NULL	Engineering Advise Note	No	No
ifrd_EanRevNo	char(40)	NULL	Engineering Advice note Revision no	No	No
ifrd_remarks	char(255)	NULL	Remarks	No	No
ifrd_Rectifieddate	datetime	NULL	Rectified date	No	No
ifrd_Inspecteddate	datetime	NULL	Inspected date	No	No
ifrd_task_code	char(15)	NULL	Associated Task code	No	No
ifrd_task_ou	char(15)	NULL	Associated Task OU	No	No
ifrd_task_rev_no	char(15)	NULL	Associated Task’s revision number	No	No
IFRD_DISCTYP	char(25)	NULL	Discrepancy Type	No	No
IFRD_ESTMANHRS	numeric(28,8)	NULL	Estimated man Hours	No	No

Table Name cwo_ifrh_insp_find_report_hdr

Table Comment CWO Inspection Findings Report details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ifrh_ouinstance	numeric(10)	NOT NULL	WO OU Instance	Yes	No
ifrh_CompWorkOrder	varchar(40)	NOT NULL	CWO	Yes	No
ifrh_InspFindings	varchar(255)	NULL	Inspection Findings remarks	No	No
ifrh_CnfFindings	varchar(25)	NULL	Indicate Confirm Findings Status	No	No
ifrh_inspectedby	varchar(30)	NULL	Inspected By Employee Code	No	No
ifrh_inspecteddate	datetime	NULL	Inspected Date	No	No
ifrh_refurbcost	numeric(28,8)	NULL	Cost of Refurbishment	No	No
ifrh_cwoobservation	varchar(255)	NULL	Other Observations	No	No
ifrh_eanno	varchar(18)	NULL	Engg Advice Note #	No	No
ifrh_EANRevNo	varchar(40)	NULL	Engg Advice Note # - Revision #	No	No
ifrh_CreatedDate	datetime	NULL	Record Created Date	No	No
ifrh_CreatedBy	varchar(30)	NULL	Created By Login name	No	No
ifrh_ModifiedDate	datetime	NULL	Last Modified Date	No	No
ifrh_ModifiedBy	varchar(30)	NULL	Last Modified By	No	No
ifrh_timestamp	numeric(10)	NULL	Timestamp	No	No
ifrh_TotalTALTATime_Display	numeric(10)	NULL	Display in Total Turn Around time	No	No
ifrh_TotalTATime_Min	numeric(10)	NULL	Total Around Time in Min.	No	No
ifrh_TotalTATime_UOM	varchar(5)	NULL	Total turn around time unit uom	No	No
ifrh_ComponentId	char(90)	NULL	Component Id	No	No
ifrh_CompCondition	char(5)	NULL	Component Condition -Unserviceable, Serviceable and blank value (USR,SER)	No	No
ifrh_CwoInspectDetail1	char(25)	NULL	Inspection Detail1	No	No
ifrh_CwoInspectDetail2	char(25)	NULL	Inspection Detail2	No	No
ifrh_CwoInspectDetail3	char(25)	NULL	Inspection Detail3	No	No
ifrh_CwoInspectOption1	char(25)	NULL	Inspection option1	No	No
ifrh_CwoInspectOption2	char(25)	NULL	Inspection option2	No	No
ifrh_CwoInspectOption3	char(25)	NULL	Inspection option3	No	No
ifrh_BeyondRepair	char(5)	NULL	Beyond Repair Values:Yes,No	No	No

Table Name Cwo_mdc_Master_Delay_Codes

Table Comment CWO Delay Code Master
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mdc_OUInstance	decimal(10)	NOT NULL	%AttDef	Yes	No
mdc_Code	varchar(25)	NOT NULL	Workorder Delay Code	Yes	No
mdc_Description	varchar(80)	NOT NULL	Delay Description	No	No
MDC_DESCRIPTION_UP	varchar(80)	NOT NULL	Delay description in Upper Case	No	No
mdc_WorkDelayCategory	varchar(25)	NULL	Delay Category	No	No
mdc_Status	varchar(5)	NOT NULL	Active or Inactive	No	No
mdc_Created_Date	datetime	NOT NULL	The date on which user creates the record	No	No
mdc_Modified_Date	datetime	NOT NULL	The date on which user last modified the record	No	No
mdc_Created_By	varchar(30)	NOT NULL	Login User Name of the user who Created the Delay Document	No	No
mdc_Modified_By	varchar(30)	NOT NULL	Login User Name of the user who modified the Delay Document	No	No
mdc_Timestamp	decimal(10)	NOT NULL	Record Update Count	No	No

Table Name Cwo_Mqc_Code_Mast

Table Comment Table for quick codes
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MQC_OUINSTANCE	numeric(10)	NOT NULL	OU Instance	Yes	No
MQC_CWORQUICKCODEMLT	varchar(25)	NOT NULL	Quick Codes	Yes	No
MQC_CWORQCTYPE	varchar(25)	NOT NULL	Quick Code Type C-Cwo Category U-User Status D-Delay Category OP1-CWO Option1 OP2-CWO Option2 OP3-CWO Option3 OP4-CWO Option4	Yes	No
MQC_CWORQCDESCMLT	varchar(80)	NULL	Quick Code Description	No	No
MQC_STATUS	varchar(5)	NULL	Quick Code Status A-Active I-Inactive	No	No
MQC_CREATEDBY	varchar(30)	NULL	Created user	No	No
MQC_CREATEDDATE	datetime	NULL	Creation date	No	No
MQC_MODIFIEDBY	varchar(30)	NULL	Modified user	No	No
MQC_MODIFIEDDATE	datetime	NULL	modified date	No	No
MQC_TIMESTAMP	numeric(10)	NULL	Timestamp	No	No

Table Name CWO_OSD_OPTION_SETTINGS_DTL

Table Comment Consists of the Option Settings Details (Multi-Line info)
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
OSD_OUINSTANCE	decimal(10)	NOT NULL	Organization Unit	Yes	No
OSD_AUTHMANDATORY	varchar(5)	NOT NULL	Authorization of Work Order (Required/Not Required)	No	No
OSD_RESPARTONSCH	varchar(5)	NOT NULL	Reservation of Parts on Scheduling	No	No
OSD_DEFDESCCWO	varchar(150)	NULL	Default Description of Auto CWO	No	No
OSD_ALLOWADDNONROUTTASKS	varchar(5)	NOT NULL	Addition of Non-Routine Tasks to CWO during execution :	No	No
OSD_VALTASKSEQ	varchar(5)	NOT NULL	Validation of Task Sequencing (Yes/No)	No	No
OSD_ONAUTHCHANGECWOSTAT	varchar(5)	NOT NULL	CWO Reporting in "HOLD" Status	No	No
OSD_CWONUMBERING	varchar(15)	NULL	CWO Numbering :	No	No
OSD_TASKSTATUSAFTERAUTH	varchar(15)	NULL	Task Status after authorisation.	No	No
OSD_DEFERDISCREPANCY	varchar(15)	NULL	Deferments of Discrepancies	No	No
OSD_AUTHOFDEFERRALS	varchar(15)	NULL	Authorisation of Deferrals (Not Used)	No	No
OSD_MATREQAUTHREQ	varchar(15)	NULL	MR Authorisation required or Not	No	No
OSD_MATREQAUTOCREATION	varchar(15)	NULL	Auto Creation of Material Request on Scheduling	No	No
OSD_AUTOCREATION	varchar(15)	NULL	(Not Used)	No	No
OSD_MATREQSTATUS	varchar(15)	NULL	OSD_MATREQSTATUS	No	No
OSD_MRCATEGORY	varchar(20)	NULL	MR Category	No	No
OSD_CWOASSIGNMENT	varchar(15)	NULL	CWO Assignments Prior to Scheduling	No	No
OSD_MODCWO	varchar(15)	NULL	Modification of CWO	No	No
OSD_MATREQNUMTYPE	varchar(20)	NULL	Numbering Type for Regular Part	No	No
OSD_CREATEDBY	varchar(30)	NOT NULL	Login user	No	No
OSD_CREATEDDATE	datetime	NOT NULL	Created date	No	No
OSD_MODIFIEDBY	varchar(30)	NOT NULL	Login user who modifies the details	No	No
OSD_MODIFIEDDATE	datetime	NOT NULL	Modification date	No	No
OSD_TIMESTAMP	decimal(10)	NOT NULL	Time stamp value to track number of times the record has been modified.	No	No
OSD_DPNOTYPENO	varchar(20)	NULL	Numbering type for Discrepancy #	No	No
OSD_HOLDOPTION	varchar(15)	NULL	CWO Reporting in "HOLD" Status	No	No
OSD_DISTINCTMRMCORE	varchar(5)	NULL	Distinct Material Request for Main Core	No	No
OSD_MRCATEGORY_MCORE	varchar(20)	NULL	Request Category for Main Core	No	No
OSD_MATREQNUMTYPE_MCORE	varchar(20)	NULL	Numbering Type for Main Core	No	No

Table Name cwo_osd_option_settings_dtl

Table Comment CWO Option Settings Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
osd_ouinstance	numeric(10)	NOT NULL	CWO OU Instance	Yes	No
osd_AuthMandatory	varchar(5)	NOT NULL	Authorisation Mandatory Flag	No	No
osd_ResPartOnSch	varchar(5)	NOT NULL	Reservation of Parts on Scheduling flag	No	No
osd_DefDescCWO	varchar(150)	NULL	Default Description of CWO, when it is created automatically value	No	No
osd_AllowAddNonRoutTasks	varchar(5)	NOT NULL	Allow addition of Non-Routine Tasks flag	No	No
osd_ValTaskSeq	varchar(5)	NOT NULL	Validate Task Sequencing during Scheduling & Execution flag	No	No
osd_OnAuthChangeCWoStat	varchar(5)	NOT NULL	On Addition of new Tasks, Change Status of Authorised CWO To flag	No	No
osd_CWONumbering	varchar(15)	NULL	Flag indicating the Numbering type is User Defined or Auto U - "User Defined" A - "Auto".	No	No
osd_TaskStatusAfterAuth	varchar(15)	NULL	Status of Tasks added after "Authorization" :	No	No
osd_DeferDiscrepancy	varchar(15)	NULL	Flag Indicating Allowing Deferment of Discrepancies A - Allowed N - Not Allowed	No	No
osd_AuthOfDeferrals	varchar(15)	NULL	Flag Indicating Authorization of Deferrals Required and Not Required R - Required N - Not Required	No	No
osd_MatReqAuthReq	varchar(15)	NULL	Indicates Material Request Authorization Required or Not Required R - Required N - Not Required	No	No
osd_MatReqAutoCreation	varchar(15)	NULL	Flag indicating Auto Creation of Material Request N - Not Allowed O - On Scheduling	No	No
osd_AutoCreation	varchar(15)	NULL	Auto Creation options W - Workcenter wise C - CWO wise P - Part type wise T - Task wise	No	No
osd_MatReqStatus	varchar(15)	NULL	Flag indicating the Material Request status at the time of creation from the CWO. D - Draft F - Fresh A -Authorised	No	No
osd_MRCategory	varchar(20)	NULL	Quick Code indicating the MR Category as defined in the material request component with which this component is interacting.	No	No
osd_CWOAssignment	varchar(15)	NULL	Flag indicating the CWO Assignments prior to Scheduling allowed or not A - Allowed N - Not allowed	No	No
osd_ModCWO	varchar(15)	NULL	Flag indicating the "Modification of CWO" A - Allowed N - Not Allowed if Scheduled R - Requires Re-Authorisation T - Add New Tasks Only	No	No
osd_MatReqNumType	varchar(20)	NULL	Numbering type for Auto Creation of Material Request . ("Numbering Type" combo with all the Numbering Type values, defined in the Numbering Type component with which the Material Request component with which the current component interacts, which are, in Active Status, valid for the current date, mapped to the login OU and Transaction Type "Material Request")	No	No
osd_CreatedBy	varchar(30)	NOT NULL	Record Created By Login User Name	No	No
osd_CreatedDate	datetime	NOT NULL	Record Created Date	No	No
osd_modifiedDate	datetime	NOT NULL	Last Modified Date	No	No
osd_modifiedBy	varchar(30)	NOT NULL	Last Modified By Log in User Name	No	No
osd_timestamp	numeric(10)	NOT NULL	Timestamp	No	No
osd_DPNoTypeNo	varchar(20)	NULL	Discrepancy Numbering type	No	No
osd_Holdoption	char(15)	NULL	Reporting of CWO Reporting in HOLD Status - "Allowed", "Not Allowed"	No	No
osd_DistinctMrmcore	char(15)	NULL	Distinct Material Request For Main Core: R- Required NR - Not Required.	No	No
osd_MrCategory_MCore	char(15)	NULL	Material Request Category - Quick Code.	No	No
osd_MatReqNumType_MCore	char(15)	NULL	Material Requirement Numbering Type	No	No
OSD_MRCREATIONOPT	char(5)	NULL	Option to Restrict MR Creation based on WO/Task Status	No	No
OSD_STATUSNRT	char(5)	NULL	OSD_STATUSNRT	No	No

Table Name Cwo_Osh_Ond_Stat_Hist

Table Comment Table for Storing the History Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
osh_Ouinstance	int	NOT NULL	OU Instance	Yes	No
osh_Compworkorder	char(18)	NOT NULL	CWO No	Yes	No
osh_Taskserialno	char(40)	NOT NULL	Task Serial No	Yes	No
osh_Statserialno	char(40)	NOT NULL	Unique no - GUID	Yes	No
osh_FromStat	char(5)	NOT NULL	From Start Date	No	No
osh_ToStat	char(5)	NOT NULL	To Start Date	No	No
osh_Statchangedate	datetime	NOT NULL	Status Changed Date	No	No
osh_changed_by	char(30)	NOT NULL	Status Changed by User Name	No	No
osh_plnstdate	datetime	NOT NULL	Planned Start Date	No	No
osh_plnendate	datetime	NOT NULL	Planned End Date	No	No

Table Name cwo_pid_part_issue_dtl

Table Comment CWO Issue Transaction Details. Posted by the Issue transaction in the Stock Maintenance
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
pid_ReqPartNo	varchar(40)	NOT NULL	Requested part no	No	No
pid_QtyIssued	numeric(28,8)	NOT NULL	Qty Issued in pid_IssUOM	No	No
PID_WAREHOUSENO	char(15)	NULL	Warehouse no	No	No
pid_CreatedBy	varchar(30)	NOT NULL	Issue Created By Login User name	No	No
pid_IssUOM	varchar(10)	NOT NULL	Issue UOM	No	No
pid_IssTranDate	datetime	NOT NULL	Issue Transaction Date	No	No
pid_CreatedDate	datetime	NOT NULL	Creation Date	No	No
pid_CompWorkOrder	varchar(40)	NOT NULL	COMP Work Order	Yes	Yes
pid_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
pid_ouinstance	numeric(10)	NOT NULL	OU Instance	Yes	Yes
pid_IssPartType	varchar(25)	NULL	Part Type - Component or Consumables.	No	No
pid_IssPartNo	char(40)	NOT NULL	Part No	Yes	Yes
pid_IssTransactionNo	varchar(40)	NOT NULL	issue Transaction No	Yes	No
pid_IsslineNo	numeric(10)	NOT NULL	Issue Line Item No	Yes	No

Table Name CWO_PID_PART_ISSUE_DTL

Table Comment CWO Issue Details (Issue Transaction/ Line # wise breakup).
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PID_COMPWORKORDER	varchar(40)	NOT NULL	Component workorder number	Yes	No
PID_TASKSERIALNO	decimal(10)	NOT NULL	Task serial number of the task in the workorder	Yes	No
PID_ISSTRANSACTIONNO	varchar(40)	NOT NULL	Issue number	Yes	No
PID_ISSLINENO	decimal(10)	NOT NULL	Line number in the issue document for this task serial number in the workorder.	Yes	No
PID_ISSPARTNO	varchar(40)	NOT NULL	Issued part number	Yes	No
PID_OUINSTANCE	decimal(10)	NOT NULL	organization unit	Yes	No
PID_ISSPARTTYPE	varchar(25)	NULL	Issued part type (regular/Main core)	No	No
PID_QTYISSUED	decimal(28,8)	NOT NULL	Number of quantity issued.	No	No
PID_REQPARTNO	varchar(40)	NOT NULL	Requested part number	No	No
PID_ISSUOM	varchar(10)	NOT NULL	Unit of measurement	No	No
PID_WAREHOUSENO	varchar(10)	NULL	Warehouse	No	No
PID_ISSTRANDATE	datetime	NOT NULL	Issued date	No	No
PID_CREATEDBY	varchar(30)	NOT NULL	Login user id	No	No
PID_CREATEDDATE	datetime	NOT NULL	Issue created date	No	No
PID_STOCKSTATUS	varchar(40)	NULL	Stock status of the part requested from warehouse.	No	No

Table Name cwo_pir_part_iss_ret_sum

Table Comment Summary of Issue and Return Qty in Stock UOM. Maintained for the Purpose of Inventory Issue /Return Entry Fetches
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
pir_ouinstance	int	NOT NULL	OU Instance	Yes	No
pir_CompWorkOrder	varchar(40)	NOT NULL	Component Work Order No	Yes	No
pir_part_no	varchar(40)	NOT NULL	Issue / Return Part No	Yes	No
pir_warehouseNo	varchar(10)	NOT NULL	Issue /Return Warehouse No	Yes	No
PIR_PART_OU	numeric	NULL	Associated part ou	No	No
Pir_Warehouse_ou	int	NULL	Warehouse Ou	No	No
PIR_ISSUE_QTY_STOCKUOM	numeric(28,8)	NULL	Issue quantity stock UOM	No	No
PIR_RETURN_QTY_STOCKUOM	numeric(28,8)	NULL	Return quantity stock UOM	No	No
pir_last_modified_date	datetime	NULL	Last Modified Date	No	No

Table Name CWO_PIR_PART_ISS_RET_SUM

Table Comment Summary of Parts Issued/Returned against CWO
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PIR_COMPWORKORDER	varchar(40)	NOT NULL	Component workorder number.	Yes	No
PIR_PART_NO	varchar(40)	NOT NULL	Part Number	Yes	No
PIR_WAREHOUSENO	varchar(10)	NOT NULL	Warehouse name	Yes	No
PIR_OUINSTANCE	decimal(38)	NOT NULL	Organization unit of the component workorder	Yes	No
PIR_PART_OU	decimal(38)	NULL	Organization unit of the part number.	No	No
PIR_WAREHOUSE_OU	decimal(38)	NULL	Organization unit of the warehouse.	No	No
PIR_ISSUE_QTY_STOCKUOM	decimal(28,8)	NULL	Unit of measurement of the part on issue.	No	No
PIR_RETURN_QTY_STOCKUOM	decimal(28,8)	NULL	Unit of measurement of the part on return	No	No
PIR_LAST_MODIFIED_DATE	datetime	NULL	Date on which lastly the details has been modified.	No	No

Table Name cwo_prd_part_return_dtl

Table Comment CWO Part Return details stored in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
prd_ouinstance	numeric(10)	NOT NULL	OU Instance	Yes	No
prd_CompWorkOrder	varchar(40)	NOT NULL	CWO No	Yes	No
prd_TaskSerialNo	numeric(10)	NOT NULL	Task Serial No	Yes	No
prd_RetTransactionNo	varchar(40)	NOT NULL	Return Transaction No	Yes	No
prd_RetlineNo	numeric(10)	NOT NULL	Return Line Item No	Yes	No
prd_RetOuInstance	numeric(10)	NOT NULL	Part return ou	Yes	No
prd_partno	varchar(40)	NOT NULL	Return Part No	Yes	No
prd_QtyReturned	numeric(28,8)	NOT NULL	Qty Returned	No	No
prd_RetUOM	varchar(10)	NOT NULL	Return UOM	No	No
prd_Warehouse	varchar(10)	NULL	Return Warehouse	No	No
prd_RetTranDate	datetime	NOT NULL	Return Tran Date	No	No
prd_CreatedBy	varchar(30)	NOT NULL	Created By User Name	No	No
prd_CreatedDate	datetime	NOT NULL	Return Created Date	No	No

Table Name CWO_PRD_PART_RETURN_DTL

Table Comment Parts Returned for the Component Work Order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PRD_COMPWORKORDER	varchar(40)	NOT NULL	Component workorder number	Yes	No
PRD_TASKSERIALNO	decimal(10)	NOT NULL	Task serial of the task against which the return has been done.	Yes	No
PRD_RETTRANSACTIONNO	varchar(40)	NOT NULL	Return transaction number.	Yes	No
PRD_RETLINENO	decimal(10)	NOT NULL	Line number of the part in the return against the task serial number.	Yes	No
PRD_RETOUINSTANCE	decimal(10)	NOT NULL	Organization unit of the Return document.	Yes	No
PRD_OUINSTANCE	decimal(10)	NOT NULL	Organization unit ff the return details.	Yes	No
PRD_PARTNO	varchar(40)	NOT NULL	Part number that has been returned against the task serial number.	No	No
PRD_QTYRETURNED	decimal(28,8)	NOT NULL	Number of quantity returned.	No	No
PRD_RETUOM	varchar(10)	NOT NULL	Unit of measurement of the returned part.	No	No
PRD_WAREHOUSE	varchar(10)	NULL	Warehouse to which the part has been returned.	No	No
PRD_RETTRANDATE	datetime	NOT NULL	Return transaction creation date.	No	No
PRD_CREATEDBY	varchar(30)	NOT NULL	Login user id who created the return.	No	No
PRD_CREATEDDATE	datetime	NOT NULL	Date of creation of the return.	No	No
PRD_STOCKSTATUS	varchar(40)	NULL	Stock status of the part returned to the warehouse.	No	No

Table Name cwo_quick_code_mast

Table Comment CWO Quick Code Master
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mqc_ouinstance	int	NOT NULL	OU Instance	Yes	No
mqc_CWORQuickcodeMlt	char(25)	NOT NULL	%AttDef	Yes	No
mqc_CWORQCDescmlt	char(80)	NOT NULL	Quick Code Desc	No	No
mqc_CWORQcType	char(25)	NOT NULL	Quick Code Type	No	No
mqc_Status	char(5)	NOT NULL	Quick Code Status	No	No
mqc_CreatedDate	datetime	NOT NULL	Created Date	No	No
mqc_CreatedBy	char(30)	NOT NULL	Created By	No	No
mqc_ModifiedDate	datetime	NOT NULL	last Modified Date	No	No
mqc_ModifiedBy	char(30)	NOT NULL	last modified By	No	No
mqc_timestamp	int	NOT NULL	timestamp	No	No

Table Name CWO_RAD_RES_ASSIGN_DTL

Table Comment Resource Assignment that are required for carrying out the component work order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RAD_COMPWORKORDER	varchar(40)	NOT NULL	Component workorder number	Yes	No
RAD_TASKSERIALNO	decimal(10)	NOT NULL	Task serial number	Yes	No
RAD_RESOURCECODE	varchar(40)	NOT NULL	Resource code	Yes	No
RAD_RESOURCETYPE	varchar(5)	NOT NULL	Resource type (tools/skill/others..)	Yes	No
RAD_RESOURCESEQNO	decimal(10)	NOT NULL	Unique sequence for the number of resources assigned	Yes	No
RAD_OUINSTANCE	decimal(10)	NOT NULL	Organization unit	Yes	No
RAD_FROMDATE	datetime	NULL	Start date of usage of resource	No	No
RAD_TODATE	datetime	NULL	End date of usage of resource	No	No
RAD_DISPLAYTIMEUOM	varchar(5)	NULL	Unit of measurement of time	No	No
RAD_DISPLAYTIMEPERDAY	decimal(28,8)	NULL	Total working hours in a day displayed in the screen	No	No
RAD_TIMEPERDAY	decimal(28,8)	NULL	Total working hours in a day	No	No
RAD_CREATED_DATE	datetime	NOT NULL	Date of creation	No	No
RAD_CREATED_BY	varchar(30)	NOT NULL	User (Login id) who allocated the resource	No	No
RAD_MODIFIED_DATE	datetime	NOT NULL	Date of modification of the resource	No	No
RAD_MODIFIED_BY	varchar(30)	NOT NULL	User (Login id) who has modified the details	No	No
RAD_TIMESTAMP	decimal(10)	NOT NULL	Number of times the record has been modified.	No	No
RAD_ASSGNHOURS	decimal(15,4)	NULL	Total hours of usage of the resource.	No	No

Table Name cwo_rad_res_assign_dtl

Table Comment CWO Resource Assignment Details. Currently only one Schedule would be there for a resource in a task.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
rad_timeperday	numeric(28,8)	NULL	Time Per Day - Duration Stored in MIn	No	No
rad_created_date	datetime	NOT NULL	Record Created Date	No	No
rad_displaytimeperday	numeric(28,8)	NULL	Display Duration	No	No
rad_DisplayTimeUOM	varchar(5)	NULL	Display Time UOM	No	No
rad_timestamp	numeric(10)	NOT NULL	Timestamp	No	No
rad_created_by	varchar(30)	NOT NULL	Record Created By	No	No
rad_modified_by	varchar(30)	NOT NULL	Modified By	No	No
rad_modified_date	datetime	NOT NULL	Modified Date	No	No
rad_assgnhours	char(15)	NULL	Resource Assgined Hours (between from date and to date)	No	No
rad_compworkorder	varchar(40)	NOT NULL	CWO	Yes	Yes
rad_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
rad_ouinstance	numeric(10)	NOT NULL	OU Instance	Yes	Yes
rad_Todate	datetime	NULL	To Date	No	No
rad_Fromdate	datetime	NULL	From Date	No	No
rad_ResourceCode	varchar(40)	NOT NULL	Resource Code	Yes	Yes
rad_ResourceSeqNo	numeric(10)	NOT NULL	Resource Schedule No - Running serial no of the Resource Schedule details for a given resource and resource type. The ResSchno does not indicate the sequence of the time horizon.	Yes	No
rad_Resourcetype	varchar(5)	NOT NULL	Resource Type	Yes	Yes

Table Name cwo_rday_res_assign_dtl

Table Comment CWO Resource Assignment Details -Day wise
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
rday_endtime	datetime	NOT NULL	Assign Date -End Time	Yes	No
rday_starttime	datetime	NOT NULL	Assign Date -Start Time	Yes	No
rday_assgndate	datetime	NOT NULL	Assignment Date	Yes	No
rday_assgnhours	numeric(28,8)	NULL	Assigned hours (between Assgn Date Start Time and End time)	No	No
rday_DisplayTimeUOM	varchar(5)	NULL	Display Time UOM	No	No
rday_Displaytimeperday	numeric(28,8)	NULL	Display Duration	No	No
rday_compworkorder	varchar(40)	NOT NULL	CWO	Yes	Yes
rday_ouinstance	numeric(10)	NOT NULL	OU Instance	Yes	Yes
rday_ResourceSeqNo	numeric(10)	NOT NULL	Resource Schedule No - Running serial no of the Resource Schedule details for a given resource and resource type. The ResSchno does not indicate the sequence of the time horizon.	Yes	Yes
rday_Resourcetype	varchar(5)	NOT NULL	Resource Type	Yes	Yes
rday_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
rday_ResourceCode	varchar(40)	NOT NULL	Resource Code	Yes	Yes

Table Name CWO_SID_SUBPART_ISS_DETL

Table Comment Component Work Order Issue Details (Task Serial No Wise) for all the parts issued.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SID_OUINSTANCE	decimal(10)	NOT NULL	Organisation Unit	Yes	No
SID_COMPWORKORDER	varchar(40)	NOT NULL	Component workorder number	Yes	No
SID_TASKSERIALNO	decimal(10)	NOT NULL	Task serial number	Yes	No
SID_REQPARTNO	varchar(40)	NOT NULL	Required part number	Yes	No
SID_LINENO	decimal(10)	NOT NULL	Line number	Yes	No
SID_ISS_PARTNO	varchar(40)	NULL	Issue part number	No	No
SID_ISSUE_NO	varchar(40)	NULL	Issue document Number	No	No
SID_WAREHOUSENO	varchar(10)	NULL	warehouse	No	No
SID_UOM	varchar(10)	NOT NULL	Unit of measurement	No	No
SID_PARTTYPE	varchar(25)	NULL	Part type	No	No
SID_QTYREQ	decimal(28,8)	NOT NULL	Required quantity	No	No
SID_QTYISSUED	decimal(28,8)	NULL	Issued quantity	No	No
SID_ISSCOST	decimal(28,8)	NULL	Issue cost for the part number	No	No
SID_CREATED_DATE	datetime	NOT NULL	Date of creation	No	No
SID_CREATED_BY	varchar(30)	NOT NULL	login user id	No	No
SID_MODIFIED_DATE	datetime	NOT NULL	Date of modification	No	No
SID_MODIFIED_BY	varchar(30)	NOT NULL	login User id	No	No
SID_TIMESTAMP	decimal(10)	NOT NULL	Timestamp to track number of times the record has been modified	No	No
SID_WAREHOUSE_OU	decimal(10)	NULL	Organization unit of the warehouse	No	No
SID_MATERIALTYPE	varchar(5)	NULL	Material type	No	No
SID_REQTYPE	varchar(5)	NULL	Required quantity	No	No
SID_STOCK_STATUS	varchar(40)	NULL	Stock status of the part	No	No
SID_PEND_MAIN_CORE_RET	decimal(28,8)	NULL	Pending number of main core parts to returned	No	No
SID_PEND_RET_QTY	decimal(28,8)	NULL	Pending parts to returned	No	No
SID_RETURN_QTY	decimal(28,8)	NULL	Number of parts returned	No	No
SID_RET_CORE_QTY	decimal(28,8)	NULL	Number of main core parts returned	No	No
SID_RETURN_BASIS	varchar(5)	NULL	Return Basis	No	No
SID_PART_OU	decimal(10)	NULL	Organization unit of part	No	No

Table Name cwo_udd_user_defined_det

Table Comment Component Work Order User Defined Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
udd_user_def_option4	varchar(30)	NULL	User Defined Details Option4	No	No
udd_remarks	varchar(255)	NULL	Remarks	No	No
udd_user_def_option3	varchar(30)	NULL	User Defined Details Option3	No	No
udd_user_def_option2	varchar(30)	NULL	User Defined Details Option2	No	No
udd_modified_by	varchar(30)	NULL	Record Last modified By	No	No
udd_created_by	varchar(30)	NULL	Created By User	No	No
udd_created_Date	datetime	NULL	Created Date	No	No
udd_modified_Date	datetime	NULL	Record last Modified Date	No	No
udd_CompWorkOrder	varchar(40)	NOT NULL	Comp Work Order	Yes	Yes
udd_user_def_det1	varchar(25)	NULL	User Defined Details Filed1	No	No
udd_ouinstance	numeric(10)	NOT NULL	CWO OU Instance	Yes	Yes
udd_user_def_option1	varchar(30)	NULL	User Defined Details Option1	No	No
udd_user_def_det4	varchar(25)	NULL	User Defined Details Filed4	No	No
udd_user_def_det2	varchar(25)	NULL	User Defined Details Filed2	No	No
udd_user_def_det3	varchar(25)	NULL	User Defined Details Filed3	No	No

Table Name cwor_bcd_backflush_cons_dtl

Table Comment CWOR Backflush item reporting.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
bcd_ouinstance	decimal(38)	NOT NULL	Organization Unit	Yes	No
bcd_compworkorder	varchar(40)	NOT NULL	Component work order	Yes	No
bcd_taskserialno	decimal(38)	NOT NULL	Task serial no	Yes	No
bcd_seqno	decimal(38)	NOT NULL	Sequence No	Yes	No
bcd_displayseqno	decimal(38)	NULL	Display Sequence No to be shown in front end	No	No
bcd_part_no	varchar(40)	NULL	Associated Part	No	No
bcd_conspart_no	varchar(40)	NULL	Consumable Part	No	No
bcd_reported_qty	decimal(28,13)	NULL	Reported By	No	No
bcd_warehouse	varchar(10)	NULL	Associated Warehouse	No	No
bcd_stock_status	varchar(40)	NULL	Stock status	No	No
bcd_remarks	varchar(150)	NULL	Remarks	No	No
bcd_CreationDate	datetime	NULL	Record Creation Date	No	No
bcd_CreatedBy	varchar(30)	NULL	Record Created By	No	No
bcd_modificationDate	datetime	NULL	Last Modification Date	No	No
bcd_modifiedBy	varchar(30)	NULL	Last Modified By	No	No
bcd_timestamp	decimal(38)	NULL	TimeStamp	No	No

Table Name cwor_bsld_backflsh_srllot_dtl

Table Comment CWOR Backflush item reporting - Serial and Lot level details.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
bsld_bin	varchar(10)	NULL	Bin no	No	No
BSLD_TIMESTAMP	decimal(38)	NULL	Record modification Timestamp	No	No
bsld_zone	varchar(10)	NULL	Zone	No	No
bsld_quantity	decimal(28,13)	NULL	Backflush quantity	No	No
bsld_modificationDate	datetime	NULL	Last Modification Date	No	No
bsld_CreationDate	datetime	NULL	Record Creation Date	No	No
bsld_CreatedBy	varchar(30)	NULL	Record Created By	No	No
bsld_modifiedBy	varchar(30)	NULL	Last Modified By	No	No
bsld_compworkorder	varchar(40)	NOT NULL	Component work order	Yes	Yes
bsld_taskserialno	decimal(38)	NOT NULL	Associated task serial number	Yes	Yes
bsld_ouinstance	decimal(38)	NOT NULL	Organization Unit	Yes	Yes
bsld_lot_no	varchar(18)	NULL	Backflush lot number	No	No
bsld_serial_no	varchar(40)	NULL	Backflush serial number	No	No
bsld_seqno	decimal(38)	NOT NULL	Sequence No	Yes	Yes
bsld_part_no	varchar(40)	NULL	Main Back Flush Part No	No	No
bsld_sub_seqno	decimal(38)	NOT NULL	Sub sequence no	Yes	No

Table Name cwor_ccd_comp_cons_dtl

Table Comment CWOR Component Consumption Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ccd_modifiedBy	varchar(30)	NULL	Last Modified By	No	No
ccd_modificationDate	datetime	NULL	Last Modification Date	No	No
ccd_reason_category	varchar(20)	NULL	Reason Category	No	No
ccd_consumed	varchar(5)	NULL	Consumed can be Y as Yes, N as NO of Blank	No	No
ccd_InstallDateTime	datetime	NULL	Consumed Comp Installation date time	No	No
ccd_outgoingPart	varchar(40)	NULL	Out Going part NO	No	No
ccd_CreatedBy	varchar(30)	NULL	Record Created By	No	No
ccd_outgoingSerial	varchar(40)	NULL	Out going part serial no	No	No
ccd_CreationDate	datetime	NULL	Record Creation Date	No	No
ccd_comments	varchar(255)	NULL	Comments	No	No
ccd_manf_lot_no	varchar(40)	NULL	Manufacturing lot number.	No	No
CCD_ACTION	varchar(25)	NULL	Action be carried out.	No	No
ccd_outg_lot_no	varchar(40)	NULL	Outgoing lot number	No	No
CCD_PROCESSFLAG	char()	NULL	CCD_PROCESSFLAG	No	No
ccd_install_by	varchar(20)	NULL	Install By	No	No
CCD_NHACOMPONENTID	varchar(90)	NULL	Component Id	No	No
CCD_MANF_SERIALNO	varchar(40)	NULL	Manufacturing serial number	No	No
CCD_OBJECT_TYPE	varchar(5)	NULL	Object Type (O-Other, C-Component, M-Misc)	No	No
CCD_SERIALNO_TYPE	varchar(5)	NULL	Serial number type. New / Existing.	No	No
CCD_RETURN_FLAG	char(5)	NULL	This flag will be updated as ’Y’ when the part is returned to the warehouse	No	No
cwota_CompWorkOrder	varchar(40)	NOT NULL	Comp Work Order No	Yes	Yes
ccd_SeqNo	numeric(28)	NOT NULL	Sequence No	Yes	No
cwota_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
ccd_IssuePart	varchar(40)	NULL	Issued part - Consumed	No	Yes
ccd_IssueSerialNo	varchar(40)	NULL	Issued Serial no - Consumed	No	Yes
cwota_ouinstance	numeric(10)	NOT NULL	Organization Unit	Yes	Yes
ccd_TaskSerialNo	decimal(10)	NOT NULL	Task Serial no	Yes	No
ccd_ouinstance	decimal(10)	NOT NULL	COmp WO OU Instance	Yes	No
ccd_CompWorkOrder	varchar(40)	NOT NULL	CWO	Yes	No
ccd_replacedby	varchar(20)	NULL	Replaced By	No	No
ccd_PositionCode	varchar(25)	NULL	Position code at which the Consumed part Fitted in the NHA	No	No
ccd_cfglevel	varchar(150)	NULL	Configuration Level	No	No
ccd_itemtagno	varchar(40)	NULL	Item Tag no	No	No
ccd_replacementdatetime	datetime	NULL	Component replacement date and time	No	No
ccd_CompRemovalNo	varchar(40)	NULL	Component removal number	No	No
ccd_RemType	varchar(10)	NULL	Removal Type S - Scheduled US - Unscheduled O - Others	No	No
ccd_CompCond	varchar(5)	NULL	Component condition	No	No
ccd_NHASerial	varchar(40)	NULL	NHA Serial	No	No
ccd_basremoval	varchar(10)	NULL	Basremoval Y - Yes N - No	No	No
ccd_Accept_Ref	Varchar(40)	NULL	Acceptance Ref.	NO	NO
ccd_NHAPart	varchar(40)	NULL	Next Higher Assembly Part	No	No

Table Name cwor_com_cirt_of_maint_dtl

Table Comment Certificate of Maintenance (COM) Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
com_CreatedBy	varchar(30)	NOT NULL	Record Created By User Login name	No	No
com_CreatedDate	datetime	NOT NULL	Record Creation Date	No	No
com_ModifiedBy	varchar(30)	NOT NULL	Last Modified By	No	No
com_AuthDateTime	datetime	NULL	Authorization Date Time	No	No
com_ReturnToService	varchar(25)	NOT NULL	Flag Indicating the Return to Service	No	No
com_NewlyOverhauled	varchar(25)	NOT NULL	Flag Indicating the NewlyOverhauled	No	No
com_AuthorizedBy	varchar(30)	NULL	Authorization Employee Code - Login user Name	No	No
COM_CERTAGENT	sql_variant	NULL	Certifying agent who authorises	No	No
COM_CERTREFNO	sql_variant	NULL	Certificate Reference Details	No	No
com_ModificationDate	datetime	NOT NULL	Last Modification Date	No	No
COM_DOCUMENTNAME	varchar(150)	NULL	COM Document Name	No	No
COM_CERTTYPE	char(25)	NULL	Certificate type	No	No
com_timestamp	decimal(10)	NOT NULL	Timestamp	No	No
COM_CERTREMARKS	char(2000)	NULL	Certifying Remarks	No	No
com_status	varchar(5)	NOT NULL	COM Status F- Fresh A- Authorized C - Cancel	No	No
com_partno	varchar(40)	NOT NULL	Partno of the CWo Stored here for Last COM details fetch	No	No
com_serialno	varchar(40)	NOT NULL	CWO Part Serial No Stored here for Last COM details fetch	No	No
com_ouinstance	numeric(10)	NOT NULL	CWO OU Instance	Yes	Yes
com_ComNo	varchar(40)	NOT NULL	Certificate of Maintenance	Yes	No
com_CompWorkOrder	varchar(40)	NOT NULL	Comp Work Order	Yes	Yes
com_AuthEmpCode	varchar(15)	NULL	Authorization Employee Code	No	No
com_Authremarks	varchar(255)	NULL	Authorization Remarks	No	No
com_AuthSkillCode	varchar(40)	NOT NULL	Authorization Employee Skill Code	No	No
com_AuthEmpName	varchar(150)	NOT NULL	Authorized Employee Name	No	No
com_AuthLicenseNo	varchar(15)	NULL	Authorized Licence No	No	No
com_CertificationDetails	varchar(5)	NOT NULL	Indicates that the Employee is Internal or outsider	No	No
com_AuthApprovalno	varchar(15)	NULL	Authorized Approval No	No	No

Table Name cwor_cra_cwo_res_actuals

Table Comment CWO Resource Actuals
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cra_ResCost	decimal(28,8)	NULL	Resource Cost	No	No
cra_createdDate	datetime	NOT NULL	Reported Date	No	No
cra_ToDate	datetime	NULL	To Date	No	No
cra_Attendancetype	varchar(25)	NULL	Attendance type	No	No
cra_DisplayActDuration	decimal(28,8)	NULL	Display Duration	No	No
cra_modifiedBy	varchar(30)	NOT NULL	Actuals Lst Modified User name	No	No
cra_timestamp	decimal(10)	NOT NULL	Timestamp for Concurrency check	No	No
CRA_CREATEDBY	varchar(30)	NOT NULL	Created user	No	No
cra_modifiedDate	datetime	NOT NULL	Actuals Last modification date	No	No
cra_creartedBy	char(30)	NOT NULL	Actuals Reported user name	No	No
CRA_RESOBJCODE	char(40)	NULL	Resource Object Code (Facility)	No	No
cra_CompWorkOrder	varchar(40)	NOT NULL	Component workorder number	Yes	Yes
cra_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
cra_ouinstance	numeric(10)	NOT NULL	CWO Organization Unit	Yes	Yes
cra_ResCode	varchar(40)	NOT NULL	Resource Code	Yes	Yes
cra_FromDate	datetime	NULL	From Date	No	No
cra_CWOActDuration	decimal(28,8)	NULL	Resource Actual Usage Duration in min	No	No
cra_DisplayTimeUom	varchar(5)	NOT NULL	Display Time Uom	No	No
cra_TransId	varchar(40)	NOT NULL	Unique Transaction Id - GUID	Yes	No
cra_Comments	varchar(255)	NULL	Comments	No	No
cra_Restype	varchar(25)	NOT NULL	Resource Type	Yes	Yes

Table Name Cwor_cwota_cwo_Task_actuals

Table Comment CWO Task Actuals
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CWOTA_RES_EQUIP_COST	decimal(28,8)	NULL	Cost of resources of type Equipment used.	No	No
CWOTA_NET_MAT_COST	numeric(28,8)	NULL	Difference of Total issue cost and total return cost	No	No
CWOTA_RES_OTH_COST	decimal(28,8)	NULL	Cost of resources of type Others used.	No	No
CWOTA_RES_SKIL_COST	decimal(28,8)	NULL	Cost of resources of type Skill used.	No	No
CWOTA_EXECCOMMENTS	varchar(255)	NULL	Execution comments	No	No
CWOTA_MATERIAL_COST	decimal(28,8)	NULL	Material Issue cost	No	No
CWOTA_LABOUR_COST	decimal(28,8)	NULL	Employee timesheet based cost	No	No
CWOTA_FINPOST_FLAG	varchar(5)	NULL	Financial Posting Done (Y/N)	No	No
CWOTA_RES_TOOL_HRS	decimal(28,8)	NULL	Total resource of type tools usage hours	No	No
CWOTA_RES_SKIL_HRS	decimal(28,8)	NULL	Total resource of type skill usage hours	No	No
CWOTA_TOTAL_COST	numeric(28,8)	NULL	Sum of all the cost (Material + labou +resourse(Equipment,skill,others)	No	No
CWOTA_RES_TOOL_COST	decimal(28,8)	NULL	Cost of resources of type tool used.	No	No
CWOTA_LABOUR_HRS	decimal(28,8)	NULL	Total employee hours booked	No	No
CWOTA_RES_OTH_HRS	decimal(28,8)	NULL	Total resource of type others usage hours	No	No
CWOTA_MATERIAL_HRS	decimal(28,8)	NULL	Total material usage hours	No	No
CWOTA_RES_EQUIP_HRS	decimal(28,8)	NULL	Total resource of type Equipment usage hours	No	No
CWOTA_CAP_AMT	numeric(28,8)	NULL	The amount that has been capitalized from the Net Cost.	No	No
cwota_CWOActEndDate	datetime	NULL	Task End Date	No	No
Cwota_DisplayTimeUOM	varchar(5)	NOT NULL	Display Time Uom	No	No
Cwota_DisplayActHrs	decimal(28,8)	NULL	Display Duration	No	No
cwota_MiscCost	decimal(28,8)	NULL	Misc cost saved in the WO Currency	No	No
cwota_ouinstance	numeric(10)	NOT NULL	Organization Unit	Yes	Yes
cwota_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
cwota_CompWorkOrder	varchar(40)	NOT NULL	Comp Work Order No	Yes	Yes
cwota_CWOActStDate	datetime	NULL	Task Actual Start Date	No	No
cwota_PercComp	decimal(10)	NULL	Task Percentage Completion	No	No
cwota_ClosingComments	varchar(2000)	NULL	Task Closing comments	No	No
cwota_CWOActHrs	decimal(28,8)	NULL	Actual Duration of the task Execution stored in Min	No	No
cwota_created_date	datetime	NOT NULL	Task Actual Reported Date	No	No
cwota_created_by	varchar(30)	NOT NULL	Task Actual Reported Login user name	No	No
cwota_timestamp	decimal(10)	NOT NULL	Timestamp for concurrency check	No	No
cwota_modified_date	datetime	NOT NULL	Task Actuals modification date	No	No
cwota_modified_by	varchar(30)	NOT NULL	Task Actuals modified by user name	No	No

Table Name CWOR_ECH_EMP_CMT_HIST

Table Comment Employee Comments History
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ECH_OUINSTANCE	decimal(10)	NOT NULL	Organization Unit	No	No
ECH_COMPWORKORDER	varchar(40)	NOT NULL	Component Work Order #	No	No
ECH_TASKSERIALNO	decimal(10)	NOT NULL	Task Serial #	No	No
ECH_LINENO	decimal(10)	NOT NULL	Line #	No	No
ECH_EMPCODE	varchar(40)	NULL	Employee Code	No	No
ECH_USERNAME	varchar(30)	NULL	Login User	No	No
ECH_EMP_COMMENTS	varchar(2000)	NULL	Comments given by the Employee for the Task	No	No
ECH_COMMENTDATE	datetime	NULL	Commented Date	No	No

Table Name cwor_eind_emp_idir_work_hrs

Table Comment Indirect work hours
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eind_empcode	varchar(20)	NOT NULL	Employee code.	Yes	No
eind_ouinstance	varchar(10)	NOT NULL	The reported ouinstance	Yes	No
eind_lineno	decimal(6)	NOT NULL	this will be generated for each employee.	Yes	No
eind_start_datetime	datetime	NULL	the reported start date and time	No	No
eind_end_datetime	datetime	NULL	the reported end date and time	No	No
eind_category	char(25)	NULL	the quick code value will be storing	No	No
eind_duartion_hrs	decimal(28,8)	NULL	Duration	No	No
eind_upd_mode	varchar(5)	NULL	the mode value will be (manual-man,clock-clk)	No	No
eind_comments	varchar(2000)	NULL	Comments	No	No
EIND_MODIFIED_DATE	datetime	NULL	Modified date	No	No
EIND_MODIFIED_BY	varchar(30)	NULL	Login user who modified the details.	No	No
EIND_TIMESTAMP	decimal(5)	NULL	number of times the record has been modified.	No	No
EIND_TIMESHTSTATUS	char(5)	NULL	Status of timesheet (fresh/confirmed/Authorised/not required)	No	No
EIND_ATTENDTYPE	char(25)	NULL	Attendance type (Normal/overtime...)	No	No
EIND_sKILLcODE	sql_variant	NULL	Employee skill code.	No	No

Table Name cwor_eta_emp_timesheet_act

Table Comment CWO Employee Assignment Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eta_created_by	varchar(30)	NOT NULL	Created By - Log in USer name	No	No
eta_created_date	datetime	NOT NULL	Created Date	No	No
eta_ToDate	datetime	NULL	timesheet Actuals To Date	No	No
eta_modified_date	datetime	NOT NULL	LastModified Date	No	No
eta_modified_by	varchar(30)	NOT NULL	Last Modified By	No	No
eta_timestamp	decimal(10)	NOT NULL	Timestamp	No	No
eta_CompWorkOrder	varchar(40)	NOT NULL	Component workorder number	Yes	Yes
eta_ouinstance	numeric(10)	NOT NULL	Organization Unit	Yes	Yes
eta_FromDate	datetime	NULL	Timesheet actuals From Date	No	No
eta_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
eta_Empcode	varchar(20)	NOT NULL	Employee Code Assigned to this Task No	Yes	No
eta_TransId	varchar(40)	NOT NULL	Time Sheet Entry Serial No for the given OU, CWO No, Task Serial No, Employee Code Use GUID	Yes	No

Table Name cwor_etd_emp_timesheet_dtl

Table Comment CWO Employee Timesheet Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
etd_ouinstance	decimal(10)	NOT NULL	reported ouinstance	Yes	No
etd_Empcode	varchar(15)	NOT NULL	Employee code	Yes	No
etd_compworkorder	varchar(40)	NOT NULL	Component work order	Yes	No
etd_taskserialno	decimal(10)	NOT NULL	Time Sheet Entry Serial No for the given OU, CWO No, Task Serial No, Employee Code Use GUID	Yes	No
ETD_LINENO	decimal(10)	NOT NULL	Time Sheet - Line Number - Seq #	Yes	No
etd_transId	varchar(40)	NOT NULL	Time Sheet Entry Serial No for the given OU, CWO No, Task Serial No, Employee Code Use GUID	No	No
etd_DisplayTimeUom	varchar(5)	NOT NULL	Display Time Uom	No	No
etd_from_datetime	datetime	NULL	From Time - Time Stored in hh:mm format	No	No
etd_to_datetime	datetime	NULL	To Time - Time Stored in hh:mm format	No	No
etd_timeperday	decimal(28,8)	NULL	Time Per Day - Stored in Min. During display it should be converted to unit of Display	No	No
etd_DisplayTimeperday	decimal(28,8)	NULL	Display Duration	No	No
ETD_EMPOTCOST	decimal(28,8)	NULL	Employee OverTime Cost	No	No
etd_empCost	numeric(28,8)	NULL	Emp Cost	No	No
etd_Emptaskstatus	varchar(25)	NULL	Task Status at the time of Reporting this Transaction	No	No
etd_comments	varchar(2000)	NULL	Comments	No	No
ETD_EMPACT_COMMENTS	varchar(2000)	NULL	Employee’s Comments	No	No
etd_worked_hours	decimal(28,8)	NULL	the actual worked hours	No	No
etd_upd_mode	varchar(25)	NULL	the clock mode (’clock’-clk manual-man)	No	No
etd_act_worked_hours	decimal(28,8)	NULL	actual worked hours	No	No
etd_act_indir_hours	decimal(28,8)	NULL	actual indirect hours	No	No
etd_break_hours	decimal(28,8)	NULL	the break hours include launch and dinner	No	No
ETD_TILL_DATETIME	datetime	NULL	Worked Till date (computed)	No	No
ETD_EXECSTATUS	varchar(25)	NULL	Execution status (In-progress/Completed)	No	No
ETD_LABOURCOST	decimal(28,8)	NULL	Cost of the labour on basis of his primary skill of the employee for the worked hours.	No	No
ETD_MODIFIED_BY	varchar(30)	NULL	Modified user(Login id)	No	No
ETD_MODIFIED_DATE	datetime	NULL	date of modification of the timesheet record.	No	No
ETD_TIMESTAMP	decimal(10)	NULL	Number of times the record has been modified.	No	No
ETD_Attendancetype	char(25)	NULL	Timesheet attendance type(Normal/1ot/2ot...)	No	No
ETD_TimesheetStatus	sql_variant	NULL	Status of time booking (Fresh/Confirmed/Authirosed/Not Required.)	No	No
ETD_BILLABLE	sql_variant	NULL	Is the timesheet record is billable or not (Yes/No)	No	No
ETD_PRI_SKILL	sql_variant	NULL	Primary skill of the employee who books the timesheet.	No	No
ETD_Task_SeqNO	int	NULL	Task sequence against which the employee books the timesheet.	No	No

Table Name cwor_npc_nonstd_part_act

Table Comment Consumables and Non Standard Part consumption actual details of CWO
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
npc_Warehouse	varchar(10)	NOT NULL	Warehouse	No	No
npc_PartType	varchar(25)	NOT NULL	Part Type S- Standard, N - Non Standard	No	No
npc_MatCost	decimal(28,8)	NOT NULL	Material Cost in Base Currency	No	No
npc_qtyused	decimal(28,8)	NOT NULL	Qty Used	No	No
npc_modifiedBy	varchar(30)	NOT NULL	Last Modified By	No	No
npc_createdDate	datetime	NOT NULL	Reported Date	No	No
npc_modifiedDate	datetime	NOT NULL	last Modification Date	No	No
npc_createdBy	varchar(30)	NOT NULL	Reported By - Login User Name	No	No
npc_timestamp	decimal(10)	NOT NULL	Timestamp	No	No
npc_ouinstance	numeric(10)	NOT NULL	Organization Unit	Yes	Yes
npc_CompWorkOrder	varchar(40)	NOT NULL	Component Workorder Number	Yes	Yes
npc_Transid	varchar(40)	NOT NULL	Unique Transaction Id to take care of Non Standard Part details capturing. Non Standard parts need not have Partno and Part non can’t be the key	Yes	No
npc_UOMMlt	varchar(10)	NOT NULL	Used Qty UOM	No	No
npc_PartDescMlt	varchar(150)	NULL	Non Standard Part Desc	No	No
npc_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
NPC_PARTOU	decimal(10)	NULL	Corresponding Part Organization unit	No	No
npc_partnomlt	varchar(40)	NULL	Consumable or Non Standard Prt No	No	No

Table Name CWOR_OS_OPTION_SETTINGS

Table Comment Contains the Option Setting Information for the Component Work Reporting
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
OS_OUINSTANCE	numeric(28)	NOT NULL	Organization Unit	Yes	No
OS_ALLOW_EXTRA_HRS	varchar(5)	NULL	Allow extra hour reporting with out Authorization (Yes/no)	No	No
OS_VAL_EMP_PRESENCE	varchar(5)	NULL	Validate for employee presence as per ARS (Yes/No)	No	No
OS_OVER_TIME_BASIS	varchar(5)	NULL	Basis for computing OverTime	No	No
OS_COM_NUM_OPT	varchar(5)	NULL	Numbering Type for CoM	No	No
OS_PRM_UPD_MODE	varchar(5)	NULL	Parameter Update Mode	No	No
OS_ASSEMLY_STATUS	varchar(5)	NULL	Check Whether Assembly Status is Complete (Yes/no)	No	No
OS_DEFAULT_REPLDATE	varchar(5)	NULL	Default Replacement Date Based on Source Document. (Yes/No)	No	No
OS_CWOTASK_STATUS	varchar(5)	NULL	Staus of CWO/Task to be closed	No	No
OS_DEFERDP	varchar(5)	NULL	Deferment of Discrepancy / MR	No	No
OS_CREATED_DATE	datetime	NULL	Created Date	No	No
OS_CREATED_BY	varchar(40)	NULL	Login user	No	No
OS_MODIFIED_DATE	datetime	NULL	Modified date	No	No
OS_MODIFIED_BY	varchar(40)	NULL	Login user id who modified	No	No
OS_TIMESTAMP	numeric(28)	NULL	Timestamp.	No	No
OS_ENFORCE_CORERET	varchar(5)	NULL	Enforce Core Returns for Backflush/Regular Parts	No	No
OS_ISU_NUM_TYPE	varchar(5)	NULL	Numbering Type For Auto Issue	No	No
OS_MR_NUM_TYPE	varchar(5)	NULL	Numbering Type for Auto Material Request	No	No
OS_CR_NUM_TYPE	varchar(5)	NULL	Numbering Type for Component Replacement	No	No
OS_ADLQTY_BCKFLSH	varchar(5)	NULL	Additional Qty. for Backflushing	No	No
OS_ADLPART_BCKFLSH	varchar(5)	NULL	Additional Part for Backflushing	No	No
OS_WHMOD_BCKFLSH	varchar(5)	NULL	Warehouse Modification for Backflushed Parts	No	No
OS_EMPTS_UPDMODE	varchar(5)	NULL	Employee Time Sheet Updation Mode	No	No
OS_BACKDT_REP_LIMIT	numeric(28)	NULL	Back Dated Reporting Time Limit	No	No
OS_CONFIRM_TS	char(5)	NULL	Confirmation of Timesheet Records	No	No
OS_AUTH_TS	char(5)	NULL	Authorization of Timesheet Records	No	No

Table Name cwor_pcd_Parts_Cons_dtl

Table Comment Component Work Order Part Consumption Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
pcd_createdDate	datetime	NOT NULL	Transaction Date	No	No
pcd_createdBy	varchar(30)	NOT NULL	Login User Id	No	No
pcd_QtyUsed	decimal(28,8)	NOT NULL	Consumption Qty	No	No
pcd_MatCost	decimal(28,8)	NOT NULL	Material Cost	No	No
PCD_REQPARTNO	varchar(40)	NULL	Requested part number	No	No
pcd_modifiedDate	datetime	NOT NULL	last Modification Date	No	No
pcd_modifiedBy	varchar(30)	NOT NULL	Last Modified user name	No	No
PCD_STOCKSTATUS	varchar(40)	NULL	On a particular Stock status on which the part is required from the warehouse.	No	No
pcd_ouinstance	numeric(10)	NOT NULL	CWO Organization Unit	Yes	Yes
pcd_CompWorkOrder	varchar(40)	NOT NULL	Component workorder number	Yes	Yes
pcd_PartNoMlt	char(40)	NOT NULL	Part No	Yes	Yes
pcd_UOMMlt	varchar(10)	NOT NULL	Part Consumption Qty Unit of Measurement	No	No
PCD_LINENO	decimal(10)	NOT NULL	Running Sequence number for the list of all the parts for a particular component workorder with its task serial number combination.	Yes	No
pcd_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
pcd_Warehousemlt	varchar(10)	NOT NULL	Warehouse	Yes	No

Table Name CWOR_PFD_PART_FITMENT_DET

Table Comment Update spare part consumption details for a task in a CWO
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PFD_COMPWORKORDER	varchar(40)	NOT NULL	Component Work Order #	Yes	No
PFD_TASKSERIALNO	varchar(40)	NOT NULL	Task Serial No for which spare is used	Yes	No
PFD_PARTNOMLT	varchar(40)	NOT NULL	The Spare part Number	Yes	No
PFD_PART_SERIAL_NO	varchar(40)	NOT NULL	Spare Part Serial #	Yes	No
PFD_OUINSTANCE	numeric(28)	NOT NULL	The transaction OU	Yes	No
PFD_WAREHOUSEMLT	varchar(10)	NULL	Issue WareHouse for the Spare	No	No
PFD_LOT_NO	varchar(18)	NULL	Spare Part Lot Number	No	No
PFD_POS_NO	varchar(25)	NULL	Position Code to which the Spare is fitted	No	No
PFD_DATE_OF_ATTACHMENT	datetime	NULL	Date of Attachment	No	No
PFD_COMMENTS	varchar(255)	NULL	remarks regarding the attachment of spare part in the position code	No	No
PFD_CREATED_DATE	datetime	NULL	Transaction Created Date	No	No
PFD_CREATED_BY	varchar(40)	NULL	Transaction Created By	No	No
PFD_MODIFIED_DATE	datetime	NULL	Transaction Modified Date	No	No
PFD_MODIFIED_BY	varchar(40)	NULL	Transaction Modified By	No	No
PFD_TIMESTAMP	numeric(28)	NULL	Transaction TimeStamp (Multi-User Check)	No	No

Table Name CWOR_SCH_SIGNOFF_CMT_HIST

Table Comment Sign-off History
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SCH_OUINSTANCE	decimal(10)	NOT NULL	Organization Unit	Yes	No
SCH_COMPWORKORDER	varchar(40)	NOT NULL	Component Workorder number	Yes	No
SCH_TASKSERIALNO	decimal(10)	NOT NULL	Unique taskserial number in the workorder	Yes	No
SCH_LINENO	decimal(10)	NOT NULL	line number	Yes	No
SCH_TASKCODE	varchar(40)	NULL	Task code present in the workorder	No	No
SCH_SUBTASKSEQNO	decimal(10)	NULL	Unique subtask sequence number given for each task against which it is mapped	No	No
SCH_SUBTASK	varchar(2000)	NULL	Sub task code	No	No
SCH_SKILLCODE	varchar(30)	NULL	Skill code for which the sub task is mapped	No	No
SCH_RESOURCEGRP	varchar(5)	NULL	Resource group (Mechanic/Inspector)	No	No
SCH_EMPCODE	varchar(40)	NULL	Employee code	No	No
SCH_USERNAME	varchar(30)	NULL	Login user name	No	No
SCH_SIGNOFF_COMMENTS	varchar(2000)	NULL	Sign off comments	No	No
SCH_COMMENTDATE	datetime	NULL	Date on which sign off comments has been entered/modified.	No	No

Table Name cwor_sod_sign_off_dtl

Table Comment Task Sign off details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
sod_CreatedDate	datetime	NOT NULL	Record Creation Date	No	No
sod_SignFlag	varchar(5)	NOT NULL	Sign Flag Indicating that the CWo,Task, skill code has been signed or not Y - Signed N- Not Signed	No	No
sod_Comments	varchar(255)	NULL	Sign off Comments	No	No
sod_modifiedby	varchar(30)	NOT NULL	Last Modified By	No	No
sod_CreatedBy	varchar(30)	NOT NULL	Record Created by User Login name	No	No
sod_modifiedDate	datetime	NOT NULL	Last Modification Date	No	No
sod_timestamp	decimal(10)	NOT NULL	Timestamp	No	No
sod_CompWorkOrder	varchar(40)	NOT NULL	Component Work Order No	Yes	Yes
sod_ouinstance	numeric(10)	NOT NULL	Organisation Unit	Yes	Yes
sod_SignoffDate	datetime	NULL	Sign Off Date	No	No
sod_EmpCode	varchar(20)	NOT NULL	Employee Code	No	No
sod_TaskSerialNo	numeric(10)	NOT NULL	Unique task no - System Generated	Yes	Yes
sod_SkillCode	varchar(40)	NOT NULL	Employee Skill Code	Yes	No