AC_ACPRT_AIRCRAFT_PART_INFO
This is an aircraft master table that stores maintenance-related details for aircraft parts. It provides structured reference data about Aircraft, Part and Component Master Information used for linking transactions with accurate technical information.
Process: MAINTPLANNING · Component: BASAircraft · Table type: Master Table Category: Holds master details of aircraft, parts, and components for accurate technical and operational reference in transactions.
This table is the canonical store for the AircraftPart entity.
Primary key
ACPRT_PART_NO, ACPRT_OUINSTANCE
Columns (57)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | ACPRT_OUINSTANCE 🔑 | varchar | Organization Unit instance for part |
| 2 | ACPRT_PART_NO 🔑 | #N/A | Part number |
| 3 | ACPRT_PART_OU | varchar | Organization Unit instance for part |
| 4 | ACPRT_COMP_GEN_FLAG | varchar | Component generation flag |
| 5 | ACPRT_COMP_ID_PRFX | Varchar | Component ID prefix |
| 6 | ACPRT_COMP_FAMILY_CODE | varchar | Component family code |
| 7 | ACPRT_COMP_TYPE | varchar | Component type |
| 8 | ACPRT_PART_CLASSIFY | varchar | Part classification |
| 9 | ACPRT_ATA_NO | #N/A | ATA chapter number |
| 10 | ACPRT_ATA_OUINSTANCE | varchar | ATA Organization Unit instance |
| 11 | ACPRT_ZONE_NO | Varchar | Zone number |
| 12 | ACPRT_CARGO_FLAG | Varchar | Cargo applicability flag |
| 13 | ACPRT_MEL_FLAG | Varchar | MEL applicability flag |
| 14 | ACPRT_RVSM_FLAG | #N/A | RVSM applicability flag |
| 15 | ACPRT_PLANNING_BASE | #N/A | Planning base for part maintenance |
| 16 | ACPRT_MAINT_BASE | varchar | Maintenance base for part |
| 17 | ACPRT_PLANNER_CODE | Varchar | Planner code |
| 18 | ACPRT_USAGE_TYPE | varchar | Usage type |
| 19 | ACPRT_LEAD_PARAM_CODE | Varchar | Lead parameter code |
| 20 | ACPRT_USER_DEF1 | Varchar | User-defined field 1 |
| 21 | ACPRT_USER_DEF2 | Varchar | User-defined field 2 |
| 22 | ACPRT_USER_DEF3 | Varchar | User-defined field 3 |
| 23 | ACPRT_COMP_DET1 | Varchar | Component detail 1 |
| 24 | ACPRT_COMP_DET2 | Varchar | Component detail 2 |
| 25 | ACPRT_COMP_DET3 | varchar | Component detail 3 |
| 26 | ACPRT_CREATED_BY | datetime | Created by user |
| 27 | ACPRT_CREATIONDATE | varchar | Creation date |
| 28 | ACPRT_MODIFIED_BY | datetime | Modified by user |
| 29 | ACPRT_MODIFIEDDATE | #N/A | Modification date |
| 30 | ACPRT_TIMESTAMP | #N/A | Timestamp |
| 31 | ACPRT_LAST_NUM_GEN | Varchar | Last number generated for part |
| 32 | ACPRT_PART_CATEGORY_TXT | varchar | Part category text |
| 33 | ACPRT_REPLACEMENT_TYPE | varchar | Replacement type |
| 34 | ACPRT_DEF_WCCODE | varchar | Default work center code |
| 35 | acprt_lifted | varchar | Lifted flag |
| 36 | acprt_maint_proc | varchar | Maintenance process code |
| 37 | acprt_exec_fac | Varchar | Execution facility |
| 38 | acprt_pref_rep_agency | varchar | Preferred repair agency |
| 39 | acprt_phase_out_policy | varchar | Phase-out policy |
| 40 | ACPRT_COMP_TRACKED | Varchar | Component tracked flag |
| 41 | ACPRT_AUTOLAND_FLAG | varchar | Autoland applicability flag |
| 42 | ACPRT_SOS_APP | varchar | SOS applicability |
| 43 | ACPRT_EXEDOC_INT_REP | varchar | Execution documentation internal report |
| 44 | ACPRT_ETOPS_FLAG | varchar | ETOPS flag |
| 45 | ACPRT_LLM_CODE | varchar | LLM code |
| 46 | ACPRT_CFGCTRL_BASIS | varchar | Configuration control basis |
| 47 | ACPRT_PMA | numeric | PMA applicability |
| 48 | ACPRT_TAT | numeric | Turnaround time (TAT) |
| 49 | ACPRT_ULTI_LIFE_DAY | varchar | Ultimate life in days |
| 50 | ACPRT_MaintOEMPartNo | varchar | Maintenance OEM part number |
| 51 | ACPRT_CONSOLIDATD_WO_FLAG | varchar | Consolidated work order flag |
| 52 | ACPRT_MFRNO | varchar | Manufacturer number |
| 53 | ACPRT_MFRPARTNO | varchar | Manufacturer part number |
| 54 | ACPRT_Standard_Task | varchar | Standard task flag |
| 55 | acprt_lep_flg | varchar | LEP flag |
| 56 | acprt_altpref | varchar | Alternate preference |
| 57 | acprt_engbseprt | int | Engine base part indicator |
Sample rows (from live DB)
ACPRT_OUINSTANCE | ACPRT_PART_NO | ACPRT_PART_OU | ACPRT_COMP_GEN_FLAG | ACPRT_COMP_ID_PRFX | ACPRT_COMP_FAMILY_CODE |
|---|---|---|---|---|---|
| 2.0 | % | — | % | COMP | — |
| 2.0 | :09832 | 2.0 | A | COMP- | LC8012 |
| 2.0 | :101_WH1 | 2.0 | A | — | ENGINE-GE09 |
Showing 3 of 50,000 rows.