ComponentID

A serialised component identity — tracks a specific physical unit through its installations, removals, and shop visits over its lifetime.

Canonical table: AC_CMPID_COMPONENT_ID_INFO · Key column: CMPID_COMPONENT_ID

Example record

• CMPID_OUINSTANCE: 2
• CMPID_COMPONENT_ID: 000014
• CMPID_PART_NO: LBV25EA032-92:M0359
• CMPID_PART_OU: 2.0
• CMPID_SERIAL_NO: A747002
• CMPID_STATUS: A
• CMPID_COMP_FAMILY_NO: —
• CMPID_COMP_TYPE: O

Incoming relationships (2)

• Discrepancy → FOR_COMPONENT
  • via DP_DISCP_DISCREPANCY_DTL.DISCP_COMPONENT_ID = AC_CMPID_COMPONENT_ID_INFO.CMPID_COMPONENT_ID
• ShopWorkOrder → FOR_COMPONENT
  • via swo_swoh_shop_wo_hdr.swoh_component_id = AC_CMPID_COMPONENT_ID_INFO.CMPID_COMPONENT_ID

See also

• AC_CMPID_COMPONENT_ID_INFO
• Discrepancy
• ShopWorkOrder