swo_visit_plan_eo_dtl
VISITHUB PLAN EO DETAIL TABLE
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Contains planned details of Engineering Orders (EO) for a shop visit, including scheduled compliance tasks, due dates, and expected execution timelines
This table is the canonical store for the VisitPlanEO entity.
Primary key
vpneo_uniqueid
Columns (44)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | VPNEO_applevel | datetime | Captures applicability at level 1. |
| 2 | vpneo_cmpldate | varchar | Records the compliance date for the component or task. |
| 3 | vpneo_component | varchar | Identifies the visit component ID. |
| 4 | vpneo_confcfg_revno | varchar | Tracks the revision number of the configuration change. |
| 5 | vpneo_created_by | datetime | Identifies the user who created the record. |
| 6 | vpneo_created_date | varchar | Records the creation date of the record. |
| 7 | vpneo_eono | varchar | Records the engineering order number. |
| 8 | vpneo_eorevno | varchar | Records the revision number of the engineering order. |
| 9 | VPNEO_filappgrp | varchar | Captures the applicability group for the task or component. |
| 10 | VPNEO_filapplvl | int | Captures the applicability level for the task or component. |
| 11 | vpneo_insqty | varchar | Records the quantity of the installed component |
| 12 | vpneo_ins_component | varchar | Identifies the installed component. |
| 13 | vpneo_ins_partno | varchar | Records the installed part number. |
| 14 | vpneo_ins_serial_no | bigint | Records the installed serial number. |
| 15 | vpneo_kitid | varchar | Tracks the Kit ID for the component. |
| 16 | vpneo_lvlcode | int | Records the level code within the assembly. |
| 17 | vpneo_lvlnumber | int | Records the level number in the hierarchy. |
| 18 | vpneo_maxqty | int | Indicates the maximum allowable quantity. |
| 19 | vpneo_minqty | varchar | Indicates the minimum required quantity. |
| 20 | vpneo_modified_by | datetime | Identifies the user who last modified the record. |
| 21 | vpneo_modified_date | varchar | Records the date when the record was last modified. |
| 22 | vpneo_nha_comp | varchar | Identifies the next higher assembly component. |
| 23 | vpneo_nha_lvlcode | varchar | Records the level code of the next higher assembly component. |
| 24 | vpneo_nha_part | varchar | Records the part number of the next higher assembly component. |
| 25 | vpneo_nha_poscode | int | Records the position code of the next higher assembly component. |
| 26 | vpneo_ouinstance | varchar | Captures the organizational unit instance associated. |
| 27 | VPNEO_Ovride_EO | varchar | Overrides the engineering order if applicable. |
| 28 | VPNEO_Ovride_Ref | varchar | Overrides the reference if applicable. |
| 29 | VPNEO_Ovride_Remarks | varchar | Stores remarks related to overrides. |
| 30 | vpneo_pieceprt | varchar | Identifies a piece part in the assembly. |
| 31 | vpneo_plneo | int | Records the planned engineering order number. |
| 32 | vpneo_plneo_seq | varchar | Records the sequence number of the planned engineering order. |
| 33 | vpneo_poscode | varchar | Captures the position code for the component. |
| 34 | vpneo_pospart | bigint | Records the position part. |
| 35 | vpneo_prteffid | int | Tracks the part effectivity ID. |
| 36 | vpneo_refqty | varchar | Records the reference quantity. |
| 37 | vpneo_srcdocno | bigint | Captures the source document number. |
| 38 | vpneo_uniqueid 🔑 | varchar | Provides a unique identifier for the record. |
| 39 | VPNEO_updtBy | varchar | Identifies the user who last updated the record. |
| 40 | vpneo_visitno | varchar | Captures the visit reference number associated with the record. |
| 41 | vpneo_woflag | varchar | Indicates if the record is linked to a work order. |
| 42 | vpneo_wsamdchngtyp | varchar | Identifies the type of amendment change. |
| 43 | vpneo_WSAMDNO | varchar | Records the amendment number. |
| 44 | vpneo_WSAMDSTS | varchar | Tracks the status of the amendment. |
Relationships (1)
- VisitPackage (SWO_Visit_Lvl_Info) →
VISIT_HAS_PLAN_EO(this table is target) (no automatic join)- Visit has planned EO