AC_CMPID_COMPONENT_ID_INFO

Component Id information against the Aircraft

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 ComponentID entity.

Primary key

CMPID_COMPONENT_ID, CMPID_OUINSTANCE

Columns (65)

#	Column	Type	Description
1	`CMPID_OUINSTANCE` 🔑	varchar	Organization Unit instance for the component
2	`CMPID_COMPONENT_ID` 🔑	varchar	Component ID
3	`CMPID_PART_NO`	int	Part number
4	`CMPID_PART_OU`	varchar	Organization Unit instance for the part
5	`CMPID_SERIAL_NO`	varchar	Serial number of the component
6	`CMPID_STATUS`	Varchar	Status of the component
7	`CMPID_COMP_FAMILY_NO`	varchar	Component family number
8	`CMPID_COMP_TYPE`	varchar	Component type
9	`CMPID_PART_CLASSIFY`	varchar	Part classification
10	`CMPID_ATA_NO`	varchar	ATA chapter number
11	`CMPID_ZONE_NO`	Varchar	Zone number
12	`CMPID_CARGO_FLAG`	Varchar	Cargo applicability flag
13	`CMPID_RVSM_FLAG`	Varchar	RVSM applicability flag
14	`CMPID_MEL_FLAG`	varchar	MEL applicability flag
15	`CMPID_OWNERSHIP`	varchar	Ownership type
16	`CMPID_POSESSION_STATUS`	datetime	Possession status of the part
17	`CMPID_INDUCTION_DATE`	datetime	Induction date of the component
18	`CMPID_OPERATION_DATE`	#N/A	Operation start date of the component
19	`CMPID_PLANNING_BASE`	#N/A	Planning base for maintenance
20	`CMPID_MAINT_BASE`	varchar	Maintenance base for the component
21	`CMPID_PLANNER_CODE`	varchar	Planner code responsible
22	`CMPID_COMPONENT_CONDITION`	datetime	Condition of the component
23	`CMPID_FROMDATE`	varchar	From date of record or validity
24	`CMPID_LEAD_PARAM_CODE`	varchar	Lead parameter code
25	`CMPID_PO_NUMBER`	datetime	Purchase order number
26	`CMPID_PO_DATE`	decimal	Purchase order date
27	`CMPID_ACQUISITION_VALUE`	decimal	Acquisition value
28	`CMPID_BOOK_VALUE`	Varchar	Book value
29	`CMPID_USER_DEF1`	Varchar	User-defined field 1
30	`CMPID_USER_DEF2`	Varchar	User-defined field 2
31	`CMPID_USER_DEF3`	Varchar	User-defined field 3
32	`CMPID_COMPONENT_DET1`	Varchar	Component detail 1
33	`CMPID_COMPONENT_DET2`	Varchar	Component detail 2
34	`CMPID_COMPONENT_DET3`	varchar	Component detail 3
35	`CMPID_NOTES`	varchar	Notes related to the component
36	`CMPID_COMMENTS`	varchar	Comments on the component
37	`CMPID_SERIAL_PRE`	varchar	Serial number prefix
38	`CMPID_SERIAL_SUFF`	varchar	Serial number suffix
39	`CMPID_CREATED_BY`	datetime	Created by user
40	`CMPID_CREATIONDATE`	varchar	Creation date
41	`CMPID_MODIFIED_BY`	datetime	Modified by user
42	`CMPID_MODIFIEDDATE`	#N/A	Modification date
43	`CMPID_TIMESTAMP`	varchar	Timestamp of the record
44	`CMPID_MSN_NO`	datetime	Manufacturer serial number
45	`CMPID_MANUFACTURED_DATE`	varchar	Manufacture date of the component
46	`CMPID_DEF_WCCODE`	int	Default work center code
47	`CMPID_POLOCATION_OU`	varchar	Purchase order location Organization Unit
48	`CMPID_ENGAGEMENT_TYPE`	varchar	Engagement type
49	`CMPID_OWNING_AGENCY_NO`	int	Owning agency number
50	`CMPID_OWNING_AGENCY_OU`	Varchar	Owning agency Organization Unit
51	`CMPID_FIRST_ISSUE`	varchar	First issue date
52	`cmpid_pref_status`	varchar	Preferred status
53	`CMPID_STKSTATUS`	datetime	Stock status
54	`CMPID_RETMNT_DATETIME`	varchar	Return maintenance datetime
55	`CMPID_NotesID`	varchar	Notes ID
56	`cmpid_opr_code`	varchar	Operator code
57	`cmpid_DER`	varchar	DER (Documented Engineering Record)
58	`CMPID_RETIREMENT_FLAG`	varchar	Retirement flag
59	`CMPID_MFRNO`	varchar	Manufacturer number
60	`CMPID_MFRPARTNO`	Char	Manufacturer part number
61	`CMPID_lastveriBy`	Datetime	Last verified by user
62	`CMPID_lastveriDate`	Char	Last verification date
63	`CMPID_VerifiStatus`	Char	Verification status
64	`CMPID_UserStatus`	varchar	User status
65	`CMPID_VeriComments`	decimal	Verification comments

Relationships (2)

Discrepancy (DP_DISCP_DISCREPANCY_DTL) → FOR_COMPONENT (this table is target)
- Join: DP_DISCP_DISCREPANCY_DTL.DISCP_COMPONENT_ID = AC_CMPID_COMPONENT_ID_INFO.CMPID_COMPONENT_ID
- Discrepancy reported for component
ShopWorkOrder (swo_swoh_shop_wo_hdr) → FOR_COMPONENT (this table is target)
- Join: swo_swoh_shop_wo_hdr.swoh_component_id = AC_CMPID_COMPONENT_ID_INFO.CMPID_COMPONENT_ID
- SWO is for component

Sample rows (from live DB)

`CMPID_OUINSTANCE`	`CMPID_COMPONENT_ID`	`CMPID_PART_NO`	`CMPID_PART_OU`	`CMPID_SERIAL_NO`	`CMPID_STATUS`
2	000014	LBV25EA032-92:M0359	2.0	A747002	A
2	000018	337-001-503-0:F0301	2.0	BB698743	A
2	000019	FRH280002:U1918	2.0	FRTR293-AD	A

Showing 3 of 50,000 rows.

AC_CMPID_COMPONENT_ID_INFO

Primary key

Columns (65)

Relationships (2)

Sample rows (from live DB)

See also