swo_visit_dft_plan_eo_dtl
Visit hub draft plan EO detail table. This table stores draft engineering order plans for aircraft visits, allowing for planning and review before final implementation.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Stores draft-level engineering order (EO) planning details for a visit, including tasks and scheduling data
Primary key
vdpneo_uniqueid
Columns (46)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | VDPNEO_applevel | varchar | Specifies the applicability level of the configuration or engineering order |
| 2 | vdpneo_cmpldate | datetime | Date on which the requirement or configuration was complied with |
| 3 | vdpneo_component | varchar | Unique identifier assigned to a component during a maintenance visit |
| 4 | vdpneo_confcfg_revno | varchar | Revision number of a configuration change used for version tracking |
| 5 | vdpneo_created_by | varchar | The user who created the record or configuration entry |
| 6 | vdpneo_created_date | datetime | The date on which the record or configuration was created |
| 7 | vdpneo_eono | varchar | Unique engineering order number associated with the configuration |
| 8 | vdpneo_eorevno | varchar | Revision number of the engineering order |
| 9 | VDPNEO_filappgrp | varchar | Group under which the applicability rules are categorized |
| 10 | VDPNEO_filapplvl | varchar | Specifies the first applicability level within the group |
| 11 | vdpneo_insqty | int | Quantity of parts or components installed in the configuration |
| 12 | vdpneo_ins_component | varchar | Identifier of the component that has been installed |
| 13 | vdpneo_ins_partno | varchar | Part number of the installed component |
| 14 | vdpneo_ins_serial_no | varchar | Serial number of the installed component |
| 15 | vdpneo_kitid | bigint | Unique identifier assigned to a kit used for assembly or maintenance |
| 16 | vdpneo_lvlcode | varchar | Code representing the level or hierarchy in the configuration structure |
| 17 | vdpneo_lvlnumber | int | The sequence number representing the level within the configuration hierarchy |
| 18 | vdpneo_maxqty | int | Maximum quantity allowed for the part or component |
| 19 | vdpneo_minqty | int | Minimum quantity required for the part or component |
| 20 | vdpneo_modified_by | varchar | User who last modified the record or configuration |
| 21 | vdpneo_modified_date | datetime | Date when the record or configuration was last modified |
| 22 | vdpneo_mssgecnter | varchar | Message center details or reference linked to the configuration |
| 23 | vdpneo_nha_comp | varchar | Identifier of the next higher assembly component |
| 24 | vdpneo_nha_lvlcode | varchar | Level code of the next higher assembly component |
| 25 | vdpneo_nha_part | varchar | Part number of the next higher assembly component |
| 26 | vdpneo_nha_poscode | varchar | Position code of the next higher assembly component |
| 27 | vdpneo_ouinstance | int | Organizational unit instance related to the record or configuration |
| 28 | Vdpneo_Ovride_EO | varchar | Indicates if the engineering order has been overridden |
| 29 | Vdpneo_Ovride_Ref | varchar | Reference details provided for the override action |
| 30 | Vdpneo_Ovride_Remarks | varchar | Remarks or comments regarding the override action |
| 31 | vdpneo_pieceprt | varchar | Flag indicating whether the component is treated as a piece part |
| 32 | vdpneo_plneo | varchar | Planned engineering order reference number |
| 33 | vdpneo_plneo_seq | int | Sequence number of the planned engineering order |
| 34 | vdpneo_poscode | varchar | Position code assigned to the component in the configuration |
| 35 | vdpneo_pospart | varchar | Part assigned to a specific position in the configuration |
| 36 | vdpneo_prtcmpovr | varchar | Indicates if a compliance override is applied for partial compliance |
| 37 | vdpneo_prteffid | bigint | Unique identifier for part effectivity within the configuration |
| 38 | vdpneo_refqty | int | Reference quantity used for configuration or compliance tracking |
| 39 | vdpneo_relexep | varchar | Exception recorded based on an engineering document relationship |
| 40 | vdpneo_srcdocno | varchar | Source document number associated with the configuration |
| 41 | vdpneo_uniqueid 🔑 | bigint | Unique identifier assigned to the record or component |
| 42 | VDPNEO_updtBy | varchar | The user who last updated the record or configuration |
| 43 | vdpneo_visitno | varchar | Reference number for the maintenance visit |
| 44 | vdpneo_wsamdchngtyp | varchar | Indicates the type of amendment change such as addition or update |
| 45 | vdpneo_WSAMDNO | varchar | Unique amendment number associated with the configuration |
| 46 | vdpneo_WSAMDSTS | varchar | Status of the amendment such as approved rejected or pending |
Sample rows (from live DB)
VDPNEO_applevel | vdpneo_cmpldate | vdpneo_component | vdpneo_confcfg_revno | vdpneo_created_by | vdpneo_created_date |
|---|---|---|---|---|---|
| Detailed Level | — | COMP-006712 | — | — | — |
| Detailed Level | — | COMP-006712 | — | — | — |
| Detailed Level | — | COMP-006712 | — | — | — |
Showing 3 of 3,233 rows.