swo_swotad_shop_wo_tsk_addl_dtl

Holds task addition comments and details for work order tasks. This table captures additional information, comments, and supplementary details related to individual tasks within a work order.

Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: This category stores supplementary details related to shop work order tasks. It includes additional task-specific information that extends beyond the core task definitions, such as extra parameters, extended descriptions, references, or other supporting attributes that help in tracking and managing tasks more effectively within a shop work order

This table is the canonical store for the SWOTaskAddl entity.

Primary key

swotad_task_track_id

Columns (727)

#	Column	Type	Description
1	`swotad_eng_instruction`	varchar	Present value of the parameter entered by the user
2	`swotad_est_remarks`	varchar	Value of the parameter since inspection
3	`swotad_exec_comments`	varchar	Value of the parameter since overhaul
4	`swotad_ReEst_Remarks`	varchar	Value of the parameter since repair
5	`swotad_swbstsk_id`	Bigint	Value of the parameter since the last shop visit
6	`swotad_swbs_task`	varchar	Shop work order number associated with the parameter
7	`swotad_task_track_id` 🔑	bigint	Tracking identification number related to the task
8	`swotad_wrk_scp_notes`	varchar	Total time associated with the parameter or task
9	`swotad_wsrev_comments`	varchar	Revision number for the parameter tracking
10	`REPLICATION_KEY`	Bigint	Replication Key
11	`swotct_ouinstance`	int	Organizational unit instance related to shop work order for TCT (Teardown Component Tracking)
12	`swotct_param_code`	varchar	Parameter details
13	`swotct_present_value`	varchar	Present Value , Entered by User
14	`swotct_since_inspection`	numeric	Since Inspection , Entered by User
15	`swotct_since_overhaul`	numeric	Overhaul value , Entered by User
16	`swotct_since_repair`	numeric	Since Repair , Entered by User
17	`swotct_since_shop_visit`	numeric	Shop Visit , Entered by User
18	`swotct_swo_no`	varchar	Shop work order ( SWO ) number
19	`swotct_tdr_tracking_id`	varchar	Tracking Id
20	`swotct_tot_time`	numeric	Total Time
21	`swotct_tracking_rev`	int	Revision No
22	`swotct_UOM`	varchar	UOM correponding to the chosen Parameter
23	`swotdr_act_inspect_done`	varchar	Inspection Done
24	`swotdr_act_mod_done`	varchar	Modified Done
25	`swotdr_act_overhaul_done`	varchar	Overhaul Done
26	`swotdr_act_repair_done`	varchar	Repair Done
27	`swotdr_act_rep_proc_code`	varchar	Actual Repair Process Code
28	`swotdr_approval_no`	varchar	Approval No
29	`swotdr_certificate`	varchar	Certificate #
30	`swotdr_corr_action`	varchar	Corrective Action
31	`swotdr_created_by`	varchar	Crreated By
32	`swotdr_created_date`	datetime	Created Date
33	`swotdr_cust_inspect_opt`	varchar	Customer Instruction , Inspection
34	`swotdr_cust_modify_opt`	varchar	Customer Instruction , Indicates any maintenance changes the part was subjected to
35	`swotdr_cust_overhaul_opt`	varchar	Customer Instruction , Overhaul
36	`swotdr_cust_repair_opt`	varchar	Customer Instruction , Repair
37	`swotdr_cust_rep_proc_code`	varchar	Customer Instruction , Repair Process Code
38	`swotdr_cust_rfr_code`	varchar	Customer Reference Code
39	`swotdr_cust_rfr_conf_flag`	varchar	Confirm Customer Reference Flag
40	`swotdr_exec_facility`	varchar	Execution Facility , Combo
41	`swotdr_failure_desc`	varchar	Failure Description
42	`swotdr_iss_by`	varchar	Issued by
43	`swotdr_iss_date`	datetime	Issued Date
44	`swotdr_latest_flag`	varchar	Latest flag to identify the latest document
45	`swotdr_modified_by`	varchar	Modified By
46	`swotdr_modified_date`	datetime	Modified Date
47	`swotdr_mod_done`	varchar	Mod Details , Embodied
48	`swotdr_new_warr_seal`	varchar	new Warranty Seal Check Box
49	`swotdr_other_findgs_dtl`	varchar	Other findings Detail
50	`swotdr_other_findgs_flag`	varchar	Other findings flag
51	`swotdr_other_findgs_pri`	varchar	Other findings Primary
52	`swotdr_other_findgs_sec`	varchar	Other findings Secondary
53	`swotdr_ouinstance`	int	Organizational Unit Instance of Shop work order ( SWO )
54	`swotdr_param_code`	varchar	Parameter Codes
55	`swotdr_prior_test_flag`	varchar	Tested Prior to Tear Down , Combo
56	`swotdr_reference_no`	varchar	Editable field , User Entry
57	`swotdr_rep_cond_found`	varchar	Condition Found
58	`swotdr_rev_no`	int	Revision No
59	`swotdr_rfr_reason`	varchar	Reason
60	`swotdr_serviced_by`	varchar	Serviced By , Editable
61	`swotdr_since_overhaul`	numeric	Overhaul , Editable
62	`swotdr_since_shop_visit`	numeric	Since Shop Visit , Editable
63	`swotdr_swo_no`	varchar	Shop work order ( SWO ) no
64	`swotdr_tdr_tracking_id`	varchar	Tracking Id
65	`swotdr_test_eqp`	varchar	Test Equipment
66	`swotdr_test_hrs`	numeric	Test Hours
67	`swotdr_Timestamp`	int	timestamp
68	`swotdr_tot_time`	numeric	Total Time
69	`swotdr_unique_no`	int	Unique No
70	`swotdr_Warr_Claim`	varchar	Warranty Details , ClaimValues Combo
71	`swotdr_Warr_Notes`	varchar	Warranty Details , Notes
72	`swotdr_Warr_Seal`	varchar	Warranty Details , Seal Values Combo
73	`swotsk_level_eff_flag`	varchar	Maintennance level effective flag
74	`swotsk_maint_level`	varchar	Maintenance level code
75	`swotsk_ouinstance`	int	Organization unit for the shop work order task (SWO ) Instance
76	`swotsk_swo_no`	varchar	Number for the work order (WO )
77	`swotsk_trackid`	Bigint	Task Track ID
78	`swotsk_uniqueid`	bigint	Unique Identifier ID
79	`swotsk_act_end_datetime`	datetime	Actual End Date Time
80	`swotsk_act_start_datetime`	datetime	Actual Start Date Time
81	`swotsk_act_tsk_cmptn_datetime`	Datetime	Actual Task Completion Date time
82	`swotsk_act_tsk_cmptn_utcdatetime`	datetime	Actual UTC Completion Date Time
83	`swotsk_act_utc_end_datetime`	datetime	Actual UTC End Date Time
84	`swotsk_act_utc_start_datetime`	datetime	Actual UTC Start Date Time
85	`swotsk_addn_report_by`	varchar	Addlitonal Reported By
86	`swotsk_ALT_EFFECTIVE`	varchar	Alternate Effective
87	`swotsk_ata_no`	varchar	Represents the aircraft turn around time ( ATA )
88	`swotsk_billable_flag`	varchar	Billable flag
89	`swotsk_buyback_flag`	varchar	Buyback flag
90	`swotsk_capex_proposal_no`	varchar	CAPEX Proposal Number
91	`swotsk_charge_est_flag`	varchar	Represents the Charge estimated flag
92	`swotsk_cls_date`	datetime	Task Closure Date
93	`swotsk_coa_flag`	varchar	Certificate of Authentication (COA ) Flag
94	`swotsk_compl_datetime`	datetime	Compliance Date Time
95	`swotsk_compl_flag`	varchar	Compilance Operations flag
96	`swotsk_component_id`	varchar	Component ID
97	`swotsk_ConstDate`	datetime	Constraint Date (Used in Scheduling )
98	`swotsk_ConstType`	varchar	Constraint Type (Used in Scheduling )
99	`swotsk_created_by`	varchar	Created By
100	`swotsk_created_date`	datetime	Created Date
101	`swotsk_curr_wrk_scp_revno`	int	Current Work Scope Rev
102	`swotsk_cust_req_wksc_flg`	Char	Cust Req Workscope Flag
103	`swotsk_display_est_elap_Time`	numeric	Display Elapsed Time
104	`swotsk_display_time_uom`	varchar	Elapsed Time UOM
105	`swotsk_disposition_code`	varchar	Disposition Code
106	`swotsk_dlink_flag`	varchar	Delink Flag
107	`swotsk_dtchange_flag`	varchar	Date Change Flag ( Used in Scheduling )
108	`swotsk_emploading_flag`	varchar	Employee Loading flag ( Task Master Attributes )
109	`swotsk_equipment_cost`	numeric	Equipment cost
110	`swotsk_est_act_flag`	varchar	Estimation Actual Flag
111	`swotsk_est_elapsed_time_mins`	numeric	Elapsed Time in Mins
112	`swotsk_est_equipment_cost`	numeric	Estimated Equipment Cost
113	`swotsk_est_inst_id`	varchar	Estimate Instance ID
114	`swotsk_est_labour_cost`	numeric	Estimated Labour Cost
115	`swotsk_est_man_hrs`	numeric	Estimation Man Hrs
116	`swotsk_est_material_cost`	numeric	Estimated Material Cost
117	`swotsk_est_others_cost`	numeric	Estimated Others Cost
118	`swotsk_est_purpose`	varchar	Estimate purpose
119	`swotsk_est_req_for`	varchar	Estimation Required For
120	`swotsk_est_skill_cost`	numeric	Estimated Skill Cost
121	`swotsk_est_status`	varchar	Estimation Status
122	`swotsk_est_tools_cost`	numeric	Estimated Tools Cost
123	`swotsk_eventid`	varchar	Event ID
124	`swotsk_exec_action`	varchar	Execution Action
125	`swotsk_exec_category`	varchar	Execution Category
126	`swotsk_exec_opr_flag`	varchar	Exec Operations flag
127	`swotsk_exec_phase`	varchar	Execution Phase
128	`swotsk_exec_priority_no`	int	Priority
129	`swotsk_expense_type`	varchar	Expense type
130	`swotsk_ext_facility_flag`	varchar	Execution Facility Flag
131	`swotsk_filename`	varchar	File Name
132	`swotsk_FlaggDate`	datetime	Highlighted Date ( Used in Scheduling UI )
133	`swotsk_FlaggEmp`	varchar	Highlighted By (Used in Scheduling UI )
134	`swotsk_FlaggRemarks`	varchar	Highlighted Remarks ( Unsed in Scheduling UI )
135	`swotsk_forecast_instid`	int	Forecast Instance ID
136	`swotsk_forecast_no`	varchar	Forecast #
137	`swotsk_hierarchy_id`	varchar	Task Hierarchy ID
138	`swotsk_labour_cost`	numeric	Labour cost
139	`swotsk_levelcode`	varchar	Level Code
140	`swotsk_MaintManualRef`	varchar	Maintain Manual Reference
141	`swotsk_MaintManualRef_Date`	datetime	Maintain Manual Reference Date
142	`swotsk_MaintManualRef_Rev`	varchar	Maintain Manual Reference Rev
143	`swotsk_mandatory_flag`	varchar	Mandatory Flag
144	`swotsk_man_hours`	numeric	Man Hours
145	`swotsk_material_cost`	numeric	Material cost
146	`swotsk_mfr_no`	varchar	Mfr No
147	`swotsk_mfr_partno`	varchar	Mfr Part No
148	`swotsk_misc_cost`	numeric	Miscelleneous cost
149	`swotsk_modified_by`	varchar	Modified By
150	`swotsk_modified_date`	datetime	Modified Date
151	`swotsk_multipos_flag`	varchar	Multiple position flag
152	`swotsk_nhamfrno`	varchar	NHA Nfr No
153	`swotsk_nhamfrpartno`	varchar	NHA Mfr Part No
154	`swotsk_nhapartno`	varchar	NHA Part No
155	`swotsk_nhaserialno`	varchar	NHA Serial No
156	`swotsk_onwing_flag`	varchar	ONWING Flag
157	`swotsk_org_seqno`	int	Original Rep Seq #
158	`swotsk_org_wrk_scp_revno`	int	Original WorkScope Rev
159	`swotsk_others_cost`	numeric	Others cost
160	`swotsk_other_est_flag`	varchar	Others estimated flag
161	`swotsk_ouinstance`	int	OU Instance
162	`swotsk_parent_ref_id`	varchar	Parent Ref ID
163	`swotsk_parent_taskcode`	varchar	Parent Task Code
164	`swotsk_parent_task_trackid`	Bigint	Parent Task Track ID
165	`swotsk_partno`	varchar	Part No
166	`swotsk_part_desc`	varchar	Part Description
167	`swotsk_part_est_flag`	varchar	Part estimated flag
168	`swotsk_part_type`	varchar	Part Type
169	`swotsk_perpectual_flag`	varchar	Perpetual Flag
170	`swotsk_per_comp`	numeric	Completion %
171	`swotsk_planid`	Bigint	Scheduling Plan ID
172	`swotsk_plan_endate`	datetime	Plan End Date
173	`swotsk_plan_startdate`	datetime	Plan Start Date
174	`swotsk_position_code`	varchar	Position Code
175	`swotsk_proplan_tskflag`	varchar	Process Plan Flag
176	`swotsk_proplan_tsktrackid`	Bigint	Process Plan Track ID
177	`swotsk_qty_type`	varchar	Output Qty Type ( Task Master Attributes )
178	`swotsk_quote_rel_id`	varchar	Quote Rel ID
179	`swotsk_reference_task`	Int	Reference Task
180	`swotsk_reference_Tasktrackid`	Bigint	Reference Task Track ID
181	`swotsk_ref_doc_revno`	varchar	Reference Document Rev
182	`swotsk_ref_src_docno`	varchar	Reference Document No
183	`swotsk_ref_src_doctype`	varchar	Reference Document Type
184	`swotsk_repair_agency`	varchar	Repair Agency
185	`swotsk_repair_class`	varchar	Repair Class
186	`swotsk_repair_proc_code`	varchar	Repair process code
187	`swotsk_rep_basis`	varchar	Repair basis
188	`swotsk_rep_seqno`	int	Represnets the sequence number
189	`swotsk_res_equip_hrs`	numeric	Resource Equipment Hourss
190	`swotsk_res_est_flag`	varchar	Resource estimated flag
191	`swotsk_res_other_hrs`	numeric	Resource Other Hrs
192	`swotsk_res_skill_hrs`	numeric	Resource Skill Hrs
193	`swotsk_res_tools_hrs`	numeric	Resource tool hours
194	`swotsk_revision_no`	varchar	Task Revision No
195	`swotsk_rii_report_by`	varchar	RII Reported By
196	`swotsk_rii_report_req`	varchar	Indicating whether Reporting of Inflight Inspection is required
197	`swotsk_rii_skill`	varchar	Skill associated with the Reporting of Inflight Inspection task
198	`swotsk_rii_type`	varchar	Type classification of the Reporting of Inflight Inspection
199	`swotsk_root_task_code`	varchar	Code of the root task from which the current task is derived
200	`swotsk_routing_reg`	varchar	Flag indicating whether routing is required for the task
201	`swotsk_ro_no`	varchar	Repair Order number associated with the task
202	`swotsk_Rpr_schm_flag`	varchar	Flag indicating whether a repair scheme is defined for the task
203	`swotsk_rson_nonexec`	varchar	Reason for Non execution
204	`swotsk_sch_appl`	varchar	Schedule Applicability ( Task Master Attributes )
205	`swotsk_seperated_flag`	varchar	Seperated Flag
206	`swotsk_seperation_rule`	varchar	Seperation Rule
207	`swotsk_seq_cntrl_no`	int	Seq Control No
208	`swotsk_serial_no`	varchar	Serial No
209	`swotsk_sign_off_info`	varchar	Sign Off Info
210	`swotsk_skill_cost`	numeric	Skill cost
211	`swotsk_station`	varchar	Station
212	`swotsk_status`	varchar	Task Status
213	`swotsk_std_elap_time`	numeric	Standard Elapsed Time
214	`swotsk_swo_no`	varchar	Represnts the work order number ( WO )
215	`swotsk_taskcode`	varchar	Represents the task code
216	`swotsk_task_desc`	varchar	Represnets the Task Description
217	`swotsk_task_ou`	int	Represnts the shop work order ( SWO )Task organizational unit
218	`swotsk_task_plan_type`	varchar	Task Plan Type ( Planned or Unplanned )
219	`swotsk_task_rel_flag`	varchar	Task Rel Flag
220	`swotsk_task_track_id`	bigint	Task Track ID
221	`swotsk_task_type`	varchar	TaskType
222	`swotsk_timestamp`	int	Timestamp
223	`swotsk_tools_cost`	numeric	Tools cost
224	`swotsk_transient_status`	varchar	Transient status
225	`swotsk_upgraded_prnttrackid`	Bigint	Upgraded Parent Task Track ID
226	`swotsk_upgraded_task`	varchar	Upgraded Task
227	`swotsk_upgraded_tasktrackid`	Bigint	Upgraded Task Track ID
228	`swotsk_upgraded_wstasktrackid`	Bigint	Upgraded WorkScoping Task Track ID
229	`swotsk_upgrade_flag`	varchar	Upgrade Flag
230	`swotsk_user_defined1`	varchar	User defined 1 ( Scheduling UI attributes )
231	`swotsk_user_defined2`	varchar	User defined 2 ( Scheduling UI attributes )
232	`swotsk_user_defined3`	datetime	User defined 3 ( Scheduling UI attributes )
233	`swotsk_user_status`	varchar	User defined status indicating task completion
234	`swotsk_warranty`	varchar	Warranty details associated with the component or task
235	`swotsk_wbs_code`	varchar	Work breakdown structure code for the task
236	`swotsk_wbs_flg`	varchar	Flag indicating mapping in the work breakdown structure
237	`swotsk_wbs_level`	varchar	Level within the work breakdown structure
238	`swotsk_wc_code`	varchar	Work center performing the task
239	`swotsk_wrenchtime_min`	numeric	Wrench time in minutes derived from task master attributes
240	`swotsk_wrk_scp_flag`	varchar	Flag indicating whether workscoping has been performed for the task
241	`swotsk_act_end_datetime`	datetime	Actual end date of the task
242	`swotsk_act_start_datetime`	datetime	Actual start date of the task
243	`swotsk_act_tsk_cmptn_datetime`	Datetime	Actual task completion date
244	`swotsk_act_tsk_cmptn_utcdatetime`	datetime	Task Completion date in UTC
245	`swotsk_act_utc_end_datetime`	datetime	Actual End date & time in UTC
246	`swotsk_act_utc_start_datetime`	datetime	Actual Start date & time in UTC
247	`swotsk_addn_report_by`	varchar	swotsk_addn_report_by
248	`swotsk_adsource_flag`	varchar	Additional source flag
249	`swotsk_alt_effective`	varchar	Alternate Effective ( Task Rel IS )
250	`swotsk_amend_no`	int	Amendment Number
251	`swotsk_amend_unique_id`	Bigint	Amendment Unique ID
252	`swotsk_amend_wsatiuniqueid`	Bigint	Amendment Task Unique ID
253	`swotsk_ata_no`	varchar	ATA Number
254	`swotsk_billable_flag`	varchar	Billable Flag
255	`swotsk_buyback_flag`	varchar	Buyback Flag
256	`swotsk_capex_proposal_no`	varchar	The capital expense proposal number applicable to the work order.
257	`swotsk_charge_est_flag`	varchar	Estimation completed for charges -0/1
258	`swotsk_cls_date`	datetime	Task Closure date
259	`swotsk_coa_flag`	varchar	COA Flag
260	`swotsk_compl_datetime`	datetime	Compliance date
261	`swotsk_compl_flag`	varchar	Auto or manual for Work scope element Task
262	`swotsk_component_id`	varchar	Component ID for the Main core Part/Serial No
263	`swotsk_ConstDate`	datetime	Scheduling , Constraint Date
264	`swotsk_ConstType`	varchar	Scheduling -, Constraint Type
265	`swotsk_created_by`	varchar	Created By
266	`swotsk_created_date`	datetime	Created Date
267	`swotsk_curr_wrk_scp_revno`	int	work scope current revision No
268	`swotsk_cust_req_wksc_flg`	Char	Not used in any of the SPs
269	`swotsk_display_est_elap_Time`	numeric	The estimated elapsed time for execution of the task.
270	`swotsk_display_time_uom`	varchar	Time UOM
271	`swotsk_disposition_code`	varchar	to specify the type of work performed on the part
272	`swotsk_dlink_flag`	varchar	Dlink flag
273	`swotsk_dtchange_flag`	varchar	Scheduling (Manual date change flag )
274	`swotsk_emploading_flag`	varchar	Task Master Attirbutes ( Employee loading )
275	`swotsk_equipment_cost`	numeric	Equipment cost
276	`swotsk_est_act_flag`	varchar	Flag used to check whether task got added in Plan sWo/Shop Execution
277	`swotsk_est_elapsed_time_mins`	numeric	Elapstime in Minutes
278	`swotsk_est_equipment_cost`	numeric	Estimated equipment cost
279	`swotsk_est_inst_id`	varchar	Estimation Instace id
280	`swotsk_est_labour_cost`	numeric	Estimated Labour cost
281	`swotsk_est_man_hrs`	numeric	Estimated man Hrs
282	`swotsk_est_material_cost`	numeric	Estimated Material Cost
283	`swotsk_est_others_cost`	numeric	Estimated other cost
284	`swotsk_est_purpose`	varchar	Estimation Purpose
285	`swotsk_est_req_for`	varchar	Estimation Request
286	`swotsk_est_skill_cost`	numeric	Estrimated skill cost
287	`swotsk_est_status`	varchar	Estimation Status
288	`swotsk_est_tools_cost`	numeric	Estimated tools cost
289	`swotsk_eventid`	varchar	The event number indicating the visit of the main core and identified for grouping the shop work order.
290	`swotsk_exec_action`	varchar	Execution action used for Upgrade/Append work scope
291	`swotsk_exec_category`	varchar	to specify the execution category of the task
292	`swotsk_exec_opr_flag`	varchar	Execution operation (Yes or No)-defaulted from wbs
293	`swotsk_exec_phase`	varchar	to specify the execution phase of the task
294	`swotsk_exec_priority_no`	int	to specify the priority of execution of the task
295	`swotsk_expense_type`	varchar	Revenue - Select this option to indicate that the task in the work order is of expense type Revenue. Capital - Select this option to indicate that the task in the work order is of expense type Capital
296	`swotsk_ext_facility_flag`	varchar	Flag indicating the type Internal or External
297	`swotsk_filename`	varchar	Represtnts the File Name
298	`swotsk_FlaggDate`	datetime	Scheduling -(Task Highlighted date)
299	`swotsk_FlaggEmp`	varchar	Scheduling (Task Highlighted by)
300	`swotsk_FlaggRemarks`	varchar	Scheduling (Task Highlighted Remarks )
301	`swotsk_forecast_instid`	int	JOB Id from Forecast table
302	`swotsk_forecast_no`	varchar	Forecast No(Defaulted for Forecasted task)
303	`swotsk_hierarchy_id`	varchar	Hierarchy id used to maintain parent / child relationship within the SWO
304	`swotsk_labour_cost`	numeric	Labour cost
305	`swotsk_levelcode`	varchar	The level code of the sub-assembly
306	`swotsk_MaintManualRef`	varchar	Maintain Manual Ref
307	`swotsk_MaintManualRef_Date`	datetime	Maintain Manual Ref Date
308	`swotsk_MaintManualRef_Rev`	varchar	Maintain Manual Ref Rev
309	`swotsk_mandatory_flag`	varchar	Task mandatory Flag-Defaulted from Repair Scheme
310	`swotsk_man_hours`	numeric	Man hours
311	`swotsk_material_cost`	numeric	Material cost
312	`swotsk_mfr_no`	varchar	The code identifying the manufacturer of the part
313	`swotsk_mfr_partno`	varchar	The number issued to the part, by the manufacturer of the part
314	`swotsk_misc_cost`	numeric	Miscellaneous cost
315	`swotsk_modified_by`	varchar	Modified by
316	`swotsk_modified_date`	datetime	Modified Date
317	`swotsk_movedfrom`	varchar	Moved from
318	`swotsk_multipos_flag`	varchar	Multiple position flag
319	`swotsk_nhamfrno`	varchar	The manufacturer number of the NHA Part # of the sub-assembly
320	`swotsk_nhamfrpartno`	varchar	The next higher assembly (NHA) Mfr. Part # of the sub-assembly
321	`swotsk_nhapartno`	varchar	The NHA Part # of the sub-assembly
322	`swotsk_nhaserialno`	varchar	The NHA Serial # of the sub-assembly
323	`swotsk_onwing_flag`	varchar	Off or CR Task
324	`swotsk_org_seqno`	int	Orginal Repair sequence No-defaulted from repair scheme
325	`swotsk_org_wrk_scp_revno`	int	work scope revision No
326	`swotsk_others_cost`	numeric	Other cost
327	`swotsk_other_est_flag`	varchar	Estimation completed for Others -0/1
328	`swotsk_ouinstance`	int	Organizational unit instance associated with the Basswo system
329	`swotsk_parent_ref_id`	varchar	Parent reference identification number for the task
330	`swotsk_parent_taskcode`	varchar	Parent task code defaulted from the repair scheme for child tasks
331	`swotsk_parent_task_trackid`	Bigint	Parent task tracking identification number indicating the task that initiates the child task
332	`swotsk_partno`	varchar	Code identifying the part against which the task is executed
333	`swotsk_part_desc`	varchar	Description of the part
334	`swotsk_part_est_flag`	varchar	Flag indicating whether estimation has been completed for the part
335	`swotsk_part_type`	varchar	Type of the part
336	`swotsk_perpectual_flag`	varchar	Flag indicating whether the task is perpetual
337	`swotsk_per_comp`	numeric	Percentage of task completion
338	`swotsk_planid`	Bigint	Scheduling plan identification number
339	`swotsk_plan_endate`	datetime	Planned end date and time for the task
340	`swotsk_plan_startdate`	datetime	Planned start date and time for the task
341	`swotsk_position_code`	varchar	Position code of the component or task
342	`swotsk_proplan_tsk`	varchar	Process plan task
343	`swotsk_proplan_tskflag`	varchar	Flag indicating whether the task is part of the process plan
344	`swotsk_proplan_tsktrackid`	Bigint	Tracking identification number for the process plan task
345	`swotsk_qty_type`	varchar	Output quantity type attribute from task master
346	`swotsk_quote_flag`	varchar	Quote flag associated with the task
347	`swotsk_quote_rel_id`	varchar	Release identification associated with the quote
348	`swotsk_reference_task`	Int	Reference task not used in any of the stored procedures
349	`swotsk_reference_Tasktrackid`	Bigint	Reference task tracking identification not used in any of the procedures
350	`swotsk_ref_doc_revno`	varchar	Source document revision number
351	`swotsk_ref_src_docno`	varchar	Source document number
352	`swotsk_ref_src_doctype`	varchar	Source document type
353	`swotsk_repair_agency`	varchar	Repair agency responsible for executing the task
354	`swotsk_repair_class`	varchar	Repair classification specifying whether the task is contract over and above (COA) between the operator and the MRO
355	`swotsk_repair_proc_code`	varchar	Repair process code defining the specific repair process performed on a component
356	`swotsk_rep_basis`	varchar	Repair basis indicating whether the repair scheme is provided by the Original Equipment Manufacturer (OEM), MRO specific, or operator specific
357	`swotsk_rep_seqno`	int	Current sequence number of the repair process
358	`swotsk_res_equip_hrs`	numeric	Equipment Hours
359	`swotsk_res_est_flag`	varchar	Estimation completed for Resource -0/1
360	`swotsk_res_other_hrs`	numeric	Other hours
361	`swotsk_res_skill_hrs`	numeric	Skill hours
362	`swotsk_res_tools_hrs`	numeric	Tools hours
363	`swotsk_revision_no`	varchar	Task Revision No
364	`swotsk_rii_report_by`	varchar	swotsk_rii_report_by
365	`swotsk_rii_report_req`	varchar	swotsk_rii_report_req
366	`swotsk_rii_signoff_comments`	varchar	RII Sign off comments
367	`swotsk_rii_skill`	varchar	RII Skill
368	`swotsk_rii_type`	varchar	RII Type
369	`swotsk_root_task_code`	varchar	Root task code defauted from Repair scheme for Child tasks
370	`swotsk_routing_reg`	varchar	Routing Required(Yes or No)-Defaulted from Repair Scheme
371	`swotsk_ro_no`	varchar	The number identifying the repair order is displayed here, when the part sent to external agency for repair
372	`swotsk_Rpr_schm_flag`	varchar	Repair Scheme defined or not-defaulted from repair scheme
373	`swotsk_rson_nonexec`	varchar	Reason for Non Exec
374	`swotsk_sch_appl`	varchar	Task Master Attributes ( Schedule Applicability )
375	`swotsk_seperated_flag`	varchar	to specify whether the tasks can be moved from the parent work order to the child work order or not
376	`swotsk_seperation_rule`	varchar	Seperation Rules
377	`swotsk_seq_cntrl_no`	int	Master sequence No
378	`swotsk_serial_no`	varchar	The serial number of the part
379	`swotsk_sign_off_info`	varchar	Sign Off Status
380	`swotsk_skill_cost`	numeric	Skill cost
381	`swotsk_srctsk_maflg`	varchar	Source task flag
382	`swotsk_srctsk_seqno`	int	Source task seq number
383	`swotsk_station`	varchar	Station Mapped to the Task work center
384	`swotsk_status`	varchar	Task Status
385	`swotsk_std_elap_time`	numeric	Standard Elapsed Time
386	`swotsk_swo_no`	varchar	Shop Work Order No
387	`swotsk_taskcode`	varchar	Task code
388	`swotsk_task_desc`	varchar	Task Description
389	`swotsk_task_ou`	int	Bastask OU
390	`swotsk_task_plan_type`	varchar	Planning Type(Planned or Un Planned)
391	`swotsk_task_rel_flag`	varchar	Task Relationship ( defaulted from repair scheme )
392	`swotsk_task_track_id`	bigint	An Unique Id, Primary Key- Identity Column - Clustered Index Column
393	`swotsk_task_type`	varchar	Type of the task
394	`swotsk_timestamp`	int	Timestamp indicating when the task record was created or updated
395	`swotsk_tools_cost`	numeric	Cost associated with the tools used for the task
396	`swotsk_transient_status`	varchar	Current transient status of the task
397	`swotsk_upgraded_prnttrackid`	Bigint	Upgraded Parent Task Track ID
398	`swotsk_upgraded_task`	varchar	Upgraded Task
399	`swotsk_upgraded_tasktrackid`	Bigint	Upgraded Task Track ID
400	`swotsk_upgraded_wstasktrackid`	Bigint	Upgraded Workscope Task Track ID
401	`swotsk_upgrade_flag`	varchar	Upgrade Flag
402	`swotsk_user_defined1`	varchar	Scheduling - User defined 1 ( USD Columns )
403	`swotsk_user_defined2`	varchar	Scheduling - User defined 2 ( USD Columns )
404	`swotsk_user_defined3`	datetime	Scheduling - user defined 3 ( USD Columns )
405	`swotsk_user_status`	varchar	to specify the user status with respect to the work order
406	`swotsk_warranty`	varchar	to specify whether the warranty is applicable for the task performed on the part # - serial #.
407	`swotsk_wbs_code`	varchar	The Work Breakdown Structure (WBS) code indicating the attributes that identify whether the task is executed for planning purpose or execution purpose
408	`swotsk_wbs_flg`	varchar	Set option ( Source Task under the entity WBS Code in define process entities )
409	`swotsk_wbs_level`	varchar	WBS level-Root,intermediate,leaf
410	`swotsk_wc_code`	varchar	Tasks Work Center
411	`swotsk_wrenchtime_min`	numeric	Task Master Attributes ( Wrench Time )
412	`swotsk_wrk_scp_flag`	varchar	Work scope element y/n(defaulted from repair scheme)
413	`swotsk_wsappreq`	varchar	Workscoping : Approval Required
414	`swotsk_wsclass`	varchar	Workscoping Class
415	`swotsk_wscomments`	varchar	Workscoping Comments
416	`swotsk_wscusrevno`	int	Workscoping Customer Rev No
417	`swotsk_wsholdcode`	varchar	Workscoping Hold Code
418	`swotsk_wsrevno`	int	Workscoping Rev No
419	`swotsk_wsrevstatus`	varchar	Workscoping Revision Status
420	`swotsk_wsstage`	varchar	Workscoping Stage
421	`swostk_createdby`	varchar	Created By
422	`swostk_createddate`	datetime	Created Date
423	`swostk_elapsedtime`	numeric	Sub Task - Elapsed Time
424	`swostk_emploading`	varchar	Employee Loading Flag
425	`swostk_laddlsdt`	datetime	Latest Additoanl Sign Off Datetime
426	`swostk_laddlsoff`	varchar	Latest Additoanl Sign Off by
427	`swostk_lsocomm`	varchar	Latest Additoanl Sign Off Comments
428	`swostk_modifiedby`	varchar	Modified By
429	`swostk_modifieddate`	datetime	Modified Date
430	`swostk_opqty_type`	varchar	Task Master Attributes -Output Quantity Type
431	`swostk_ouinstance`	int	OUInstance
432	`swostk_planenddate`	datetime	Sub Task - Plan End Date
433	`swostk_planid`	Bigint	Scheduling - Plan ID
434	`swostk_planstartdate`	datetime	Sub Task - Plan Start Date
435	`swostk_schworktime`	varchar	Task Master Attributes -Schedule within work time ?
436	`swostk_sch_appl`	varchar	Task Master Attributes - Schedule Applicability
437	`swostk_subtaskdesc`	varchar	Sub Task Desc
438	`swostk_subtskseqno`	int	Sub Task Seq No
439	`swostk_swono`	varchar	Work order number representing the SWO or WO
440	`swostk_timeuom`	varchar	Elapsed time unit of measurement
441	`swostk_trackid`	Bigint	Tracking identification number for the task
442	`swostk_uniqueid`	bigint	Unique key identification for the record
443	`swopos_created_by`	varchar	Name of the person who created the record
444	`swopos_created_date`	datetime	Date when the record was created
445	`swopos_dispositioncode`	varchar	Disposition code for the visit
446	`swopos_modified_by`	varchar	Name of the person who last modified the record
447	`swopos_modified_date`	datetime	Date when the record was last modified
448	`swopos_nhapartno`	varchar	NHA (Next Higher Assembly) part number
449	`swopos_nhaserialno`	varchar	NHA (Next Higher Assembly) serial number
450	`swopos_ouinstance`	int	Organizational unit instance
451	`swopos_partno`	varchar	Part number associated with the task or component
452	`swopos_positioncode`	varchar	Position code of the component or task
453	`swopos_process_flag`	varchar	Flag indicating whether the process has been completed
454	`swopos_root_componentid`	varchar	Root component identification number
455	`swopos_serialno`	varchar	Serial number of the component
456	`swopos_swo_no`	varchar	Work order number
457	`swopos_taskno`	varchar	Task number associated with the work order
458	`swopos_trackid`	Bigint	Task tracking identification number
459	`swowka_assign_comments`	varchar	Comments provided during task assignment
460	`swowka_assign_hrs`	numeric	Hours assigned for the task
461	`swowka_created_by`	varchar	Name of the person who created the work assignment record
462	`swowka_created_date`	datetime	Date when the work assignment record was created
463	`swowka_emp_code`	varchar	Employee code assigned to the task
464	`swowka_emp_ou`	int	HRMS organizational unit instance for the employee
465	`swowka_from_date`	datetime	Date from which the task is assigned
466	`swowka_license`	varchar	License associated with the task
467	`swowka_modified_by`	varchar	Name of the person who modified the work assignment record
468	`swowka_modified_date`	datetime	Date when the work assignment record was modified
469	`swowka_ouinstance`	int	Organizational unit instance
470	`swowka_resourcegrp`	varchar	Resource group associated with the task
471	`swowka_seq_no`	bigint	Unique sequence number, primary key, identity column, clustered index column
472	`swowka_skill_flag`	varchar	Flag indicating if a skill is required
473	`swowka_swo_no`	varchar	Work order number associated with the SWO
474	`swowka_task_code`	varchar	Task code for the work assignment
475	`swowka_task_track_id`	bigint	Task tracking ID for the task code against which the work assignment is recorded
476	`swowka_timestamp`	int	Timestamp when the work assignment record was created or updated
477	`swowka_to_date`	datetime	Date to which the task is assigned
478	`swowka_UnitsPercent`	int	Percentage of units assigned
479	`swowka_userdefined`	varchar	User defined field
480	`swowka_wc_code`	varchar	Work center code
481	`REPLICATION_KEY`	Bigint	Replication key for the record
482	`swp_componentname`	varchar	Component name used in metadata to record system predefined value
483	`swp_creationdate`	datetime	Creation date of the parameter or record
484	`swp_displayorder`	int	Display order for parameters
485	`swp_langid`	int	Language identification
486	`swp_paramcategory`	varchar	Parameter category
487	`swp_paramcode`	varchar	Parameter code
488	`swp_paramdesc`	varchar	Parameter description
489	`swp_paramtype`	varchar	Parameter type
490	`replication_key`	Bigint	Replication key for the parameter
491	`swotws_Task_status1`	varchar	Task status one
492	`swotws_Task_status2`	varchar	Task status two
493	`swotws_WO_status`	varchar	Work order status
494	`REPLICATION_KEY`	Bigint	Replication Key
495	`swotp_attribute_name`	varchar	Work Level OR Task level Status change
496	`swotp_auto_return`	varchar	Meta Data used to identiy the activities to performed when status changes-Auto return to be triggered or not
497	`swotp_capex_posting`	varchar	Meta Data used to identiy the activities to performed when status changes
498	`swotp_compl_upd`	varchar	Meta Data used to identiy the activities to performed when status changes-Compliance to be called or not
499	`swotp_comp_cond_upd`	varchar	Meta Data used to identiy the activities to performed when status changes-Component codition to be called or not
500	`swotp_comp_creation`	varchar	Meta Data used to identiy the activities to performed when status changes
501	`swotp_eo_service_scrap`	varchar	Engineering Order {EO }Service
502	`swotp_est_service`	varchar	Estimation service to be called or not
503	`swotp_facility_object`	varchar	facility obect
504	`swotp_fin_posting`	varchar	Meta Data used to identiy the activities to performed when status changes-Finance postings (Only for To status-Pre close,Close Service has to be called)
505	`swotp_from_status`	varchar	when status changes - From status
506	`swotp_mr_short_closure`	varchar	Meta Data used to identiy the activities to performed when status changes-MR short close service to be called or not
507	`swotp_ownership_update`	varchar	Meta Data used to identiy the activities to performed when status changes-Ownership service to be called or not
508	`swotp_param_upd`	varchar	Meta Data used to identiy the activities to performed when status changes-Paramter values updates to be called or not
509	`swotp_part_change`	varchar	Meta Data used to identiy the activities to performed when status changes-part changes
510	`swotp_to_status`	varchar	when status changes - To status status
511	`swotp_tskchg_allowed`	varchar	Meta Data used to identiy the activities to performed when status changes
512	`tsksch_createdby`	varchar	Created By
513	`tsksch_createddate`	datetime	Created Date
514	`tsksch_modifiedby`	varchar	Modified By
515	`tsksch_modifieddate`	datetime	Modified Date
516	`tsksch_ouinstance`	int	OUInstance
517	`tsksch_rel`	varchar	Relationship between tasks, with types such as FS (Finish-to-Start), SS (Start-to-Start), SF (Start-to-Finish), and FF (Finish-to-Finish)
518	`tsksch_reltask`	varchar	Related task, where the relationship is defined from right to left
519	`tsksch_reltasktrackid`	Bigint	Tracking ID of the related task
520	`tsksch_reltype`	varchar	Type of relationship, such as DF (Default), EXP (Expected), or PLN (Planned)
521	`tsksch_swono`	varchar	Work order number (WO) associated with the task
522	`tsksch_taskcode`	varchar	Task number
523	`tsksch_taskrev`	varchar	Revision number of the task
524	`tsksch_tasktrackid`	Bigint	Tracking ID of the task
525	`tsksch_timelag`	int	Time Lag
526	`tsksch_timestamp`	int	Timestamp
527	`tsksch_timeuom`	varchar	Time UOM
528	`tsksch_uniqueid`	bigint	Key ID
529	`eochg_assgrp`	varchar	Assembly group
530	`eochg_cfgstatus`	varchar	Configuration status
531	`eochg_cfg_change`	varchar	Configuration changes
532	`eochg_cfg_flag`	varchar	Configuration flag
533	`eochg_cmpllvlcode`	varchar	Compliance level code
534	`eochg_cmplnhalvlcode`	varchar	Compliance Next higher assembly level code
535	`eochg_cmplnhaposcode`	varchar	Compliance Next higher assembly position code
536	`eochg_cmpl_componentid`	varchar	Compliance component id
537	`eochg_cmpl_instpart`	varchar	Compliance installed part
538	`eochg_cmpl_instserial`	varchar	Compliance installed serial
539	`eochg_cmpl_partno`	varchar	Complaince part number
540	`eochg_cmpl_poscode`	varchar	Compliance position code
541	`eochg_cmpl_pospart`	varchar	Compliance position part
542	`eochg_cretaedby`	varchar	Created by
543	`eochg_cretaed_date`	Datetime	Created date
544	`eochg_disposcode`	varchar	Disposition code
545	`eochg_eo`	varchar	Engineering order number
546	`eochg_eorevno`	varchar	Engineering order revision number
547	`eochg_error`	varchar	Error id
548	`eochg_ex_maxqty`	Decimal	Existing maximum quantity
549	`eochg_ex_minqty`	Decimal	Existing minimum quantity
550	`eochg_ex_mod`	varchar	Existing mod
551	`eochg_ex_partno`	varchar	Existing part number
552	`eochg_ex_posstatus`	varchar	Existing position status
553	`eochg_ex_qty`	Decimal	Existing quantity
554	`eochg_modifiedby`	varchar	Modified by
555	`eochg_modified_date`	Datetime	Modified date
556	`eochg_new_mod`	varchar	New mod
557	`eochg_new_partno`	varchar	New part number
558	`eochg_new_posstatus`	varchar	New position status
559	`eochg_new_qty`	Decimal	New quantity
560	`eochg_nhapart`	varchar	Next higher assembly part
561	`eochg_nhaposcode`	varchar	Next higher assembly position code
562	`eochg_nw_maxqty`	Decimal	New maximum quantity
563	`eochg_nw_minqty`	Decimal	New minimum quantity
564	`eochg_ouinstance`	int	Ouinstance
565	`eochg_pos_code`	varchar	Position code
566	`eochg_pr_info`	varchar	Pr information
567	`eochg_pr_status`	varchar	Pr status
568	`eochg_refid`	varchar	Reference id
569	`eochg_uniqueid`	bigint	Uinque id
570	`eochg_visitcompid`	varchar	Visit component id
571	`eochg_visitdoc`	varchar	Visit reference number
572	`vpeo_compid`	varchar	Component id
573	`vpeo_createdby`	varchar	created by
574	`vpeo_createddate`	datetime	created date
575	`vpeo_Dispcode`	varchar	Disposition code
576	`vpeo_eo`	varchar	Engineering document
577	`vpeo_eorevno`	varchar	Engineering document revision number
578	`vpeo_Level_No`	varchar	Level number
579	`vpeo_lsteo`	varchar	List engineering order
580	`vpeo_lvlcode`	varchar	Level code
581	`vpeo_modifiedby`	varchar	MODIFIED BY
582	`vpeo_modifieddate`	datetime	Modified date
583	`vpeo_nha`	varchar	NHA
584	`vpeo_nhacompid`	varchar	NHA component id
585	`vpeo_nha_emptypos`	varchar	NHA empty positions
586	`vpeo_ouinstance`	int	Ouinstance
587	`vpeo_poscode`	varchar	Position code
588	`vpeo_recomdeuse`	varchar	Recommended use
589	`vpeo_refid`	varchar	Reference id
590	`vpeo_uniqueid`	bigint	Unique id
591	`vpeo_visitcompid`	varchar	Visit component id
592	`vpeo_visitdoc`	varchar	Visit document number
593	`VBCP_acmodel`	varchar	Aircraft model number
594	`VBCP_addl_Comments`	varchar	Additional comments
595	`VBCP_addtlremarks`	varchar	Additional remarks
596	`VBCP_allocexedoc`	varchar	Aloow excution document
597	`vbcp_applevel`	varchar	Applicability level
598	`VBCP_Applicability`	varchar	Applicability
599	`VBCP_baselined_flag`	varchar	Baselined flag
600	`VBCP_Baslined_by`	varchar	Baselined by
601	`VBCP_Baslined_date`	Datetime	Baselined date
602	`VbCP_CMPLSEQ`	int	Compliance sequence
603	`VBCP_Comments`	varchar	Comments
604	`VBCP_compliance_date`	varchar	Compliance date
605	`VBCP_Compliance_time`	Datetime	Compliance time
606	`VBCP_COMPLMCR`	varchar	Complaince mcr
607	`VBCP_Component`	varchar	Component
608	`VBCP_Component_ID`	varchar	Component id
609	`VbCP_CONCFG_REV_NO`	varchar	Configuration change revision number
610	`VBCP_configclss`	varchar	Configuration class
611	`VBCP_confirmed_By`	varchar	Confirmed by
612	`VBCP_confirmed_date`	Datetime	Confirmed date
613	`VBCP_Created_By`	varchar	Created by
614	`VBCP_Created_date`	datetime	Created date
615	`VBCP_currval`	varchar	Current value
616	`VBCP_Document_No`	varchar	Visit reference number
617	`VBCP_Doc_Revisiono`	varchar	Document revision number
618	`vbcp_EOCMPL_STS`	varchar	Eo compliance status
619	`vbcp_eo_flag`	varchar	Engineering order flag
620	`VBCP_Eo_no`	varchar	Engineering order number
621	`VBCP_Eo_Rev`	varchar	Engineering order revision number
622	`VbCP_ExecInfo`	varchar	Execution information
623	`VBCP_Execution_Comments`	varchar	Execution comments
624	`VBCP_Exe_Document`	varchar	Execution document
625	`vbcp_filappgrp`	varchar	Applicability group
626	`vbcp_filapplvl`	varchar	Applicability level1
627	`VBCP_fllwupinst`	varchar	Follow up installed part
628	`VbCP_INSQTY`	int	Installed quantity
629	`VBCP_jobtype`	varchar	Job type
630	`vbcp_kitid`	bigint	Kit id
631	`Vbcp_LEVEL_CODE`	varchar	Level code
632	`vbcp_lvlnumber`	int	Level number
633	`VBCP_maint_type`	varchar	Maint type
634	`VbCP_MAXQTY`	int	Maximum quantity
635	`VbCP_MINQTY`	int	Minimum quantity
636	`VBCP_Modified_by`	varchar	Modified by
637	`VBCP_Modified_date`	datetime	Modified date
638	`VBCP_mpditem`	varchar	Mpd item
639	`VBCP_mssgecnter`	varchar	Message center
640	`VbCP_NHALVL_CODE`	varchar	Next higher assembly level code
641	`Vbcp_NHA_COMP`	varchar	Nha component
642	`Vbcp_NHA_PART`	varchar	Nha part
643	`VbCP_NHA_POSCODE`	int	Next higher assembly position code
644	`VBCP_OU_Instance`	int	Ouinstance
645	`VBCP_Ovride_EO`	varchar	Override engineering order
646	`VBCP_Ovride_Ref`	varchar	Override reference
647	`VBCP_Ovride_Remarks`	varchar	Override remarks
648	`VBCP_partdesc`	varchar	Part description
649	`VBCP_Part_no`	varchar	Part number
650	`vbcp_pieceprt`	varchar	Piece parts
651	`vbcp_Planeo`	varchar	Plan engineering order
652	`VbCP_PLANEO_SEQ`	int	Plan engineering order sequence
653	`vbcp_Plantsk`	varchar	Planned task
654	`VbCP_plntask_updated`	varchar	Planned task updated
655	`VBCP_posbsdsched`	varchar	Position based schedule
656	`VBCP_POSITIONCODE`	varchar	Position code
657	`VbCP_POSPART`	varchar	Position part
658	`VBCP_program_rev`	varchar	Program revision number
659	`VBCP_PRTCMPLREM`	varchar	Part complaince remaning value
660	`vbcp_prteffid`	bigint	Part effectivity is
661	`VbCP_REFQTY`	int	Reference quantity
662	`VBCP_Remarks`	varchar	Remarks
663	`VBCP_remval`	varchar	Remainning value
664	`VBCP_REQ_FOR`	varchar	Required for
665	`VBCP_schedval`	varchar	Scheduled value
666	`VBCP_Serial_No`	varchar	Serial number
667	`VBCP_SHEDULED`	varchar	Scheduled
668	`VBCP_shrttrmesclref`	varchar	Short term esclation reference
669	`vbcp_srcdocno`	varchar	Source document number
670	`VBCP_taskdesc`	varchar	Task description
671	`VBCP_taskrev`	varchar	Task revision number
672	`VBCP_Task_no`	varchar	Task number
673	`VBCP_timestamp`	int	Timestamp
674	`VBCP_TSKCMPL_STS`	varchar	Task compliance status
675	`VBCP_ud6`	varchar	User defined 6
676	`VBCP_unique_id`	bigint	Unique id
677	`VbCP_updtBy`	varchar	Updated by
678	`VBCP_User_Defined1`	varchar	User defined 1
679	`VBCP_User_Defined2`	varchar	User defined 2
680	`VBCP_User_Defined3`	varchar	User defined 3
681	`VBCP_User_Defined4`	varchar	User defined 4
682	`VBCP_User_Defined5`	varchar	User defined 5
683	`VbCP_user_flag`	varchar	User flag
684	`VBCP_workunit_line_no`	int	Work unit line number
685	`vbcp_wsamdchngtyp`	varchar	Amendment change type
686	`vbcp_WSAMDNO`	varchar	Amendment number
687	`vbcp_WSAMDSTS`	varchar	Amendment status
688	`VbPNEO_filappgrp`	varchar	Applicability group
689	`VbPNEO_filapplvl`	varchar	Applicability level
690	`vbpneo_insqty`	int	Installed quantity
691	`vbpneo_ins_component`	varchar	Installed component
692	`vbpneo_ins_partno`	varchar	Installed part number
693	`vbpneo_ins_serial_no`	varchar	Installed serial number
694	`vbpneo_kitid`	bigint	Kit id
695	`vbpneo_lvlcode`	varchar	Level code
696	`vbpneo_lvlnumber`	int	Level number
697	`vbpneo_maxqty`	int	Maximum quantity
698	`vbpneo_minqty`	int	Minimum quantity
699	`vbpneo_modified_by`	varchar	Modified by
700	`vbpneo_modified_date`	datetime	Modified date
701	`vbpneo_nha_comp`	varchar	Next higher assembly component
702	`vbpneo_nha_lvlcode`	varchar	Next higher assembly level code
703	`vbpneo_nha_part`	varchar	Next higher assembly part
704	`vbpneo_nha_poscode`	varchar	Next higher assembly position code
705	`vbpneo_ouinstance`	int	Ouinstance
706	`vbpneo_Ovride_EO`	varchar	Override engineering order
707	`vbpneo_Ovride_Ref`	varchar	Override reference
708	`vbpneo_Ovride_Remarks`	varchar	Override remarks
709	`vbpneo_pieceprt`	varchar	Piece part
710	`vbpneo_plneo`	varchar	Planned Engineering order
711	`vbpneo_plneo_seq`	int	Planned Engineering order sequence
712	`vbpneo_poscode`	varchar	Position code
713	`vbpneo_pospart`	varchar	Position part
714	`vbpneo_prteffid`	bigint	Part effectivity id
715	`vbpneo_refqty`	int	Reference quantity
716	`vbpneo_srcdocno`	varchar	Source document number
717	`vbpneo_uniqueid`	bigint	Unique id
718	`VbPNEO_updtBy`	varchar	Updated by
719	`vbpneo_visitno`	varchar	Visit reference number
720	`vbpneo_woflag`	varchar	Work order flag
721	`vbpneo_wsamdchngtyp`	varchar	Ammendment change type
722	`vbpneo_WSAMDNO`	varchar	Ammendment number
723	`vbpneo_WSAMDSTS`	varchar	Ammendment status
724	`vdpneo_Baselined_by`	varchar	Baselined by
725	`vdpneo_Baselined_datetime`	datetime	Baselined datetime
726	`vdpneo_Baslind_Rev`	varchar	Baselined revision
727	`vdpneo_Baslin_Ver`	varchar	Baselined version

Relationships (1)

SWOTask (swo_swostk_sub_task_details) → SWO_TASK_ADDITIONAL (this table is target)
- Join: swo_swostk_sub_task_details.swostk_task_track_id = swo_swotad_shop_wo_tsk_addl_dtl.swotad_task_track_id
- SWO task has additional details

Sample rows (from live DB)

`swotad_eng_instruction`	`swotad_est_remarks`	`swotad_exec_comments`	`swotad_ReEst_Remarks`	`swotad_swbstsk_id`	`swotad_swbs_task`
—	—	—	—	—	—
—	—	—	—	—	—
—	—	—	—	—	—

Showing 3 of 13,160 rows.

swo_swotad_shop_wo_tsk_addl_dtl

Primary key

Columns (727)

Relationships (1)

Sample rows (from live DB)

See also