PartConsumption

A record of a part used during a task. Links the task/AME package to the specific part number, quantity, and (if tracked) serial or lot. Critical for airworthiness traceability.

Canonical table: FLOG_TLGPC_PART_CONSUMP_DTL · Key column: tlgpc_key_seq_no

Example record

• TLGPC_SLFSRC_OUINSTANCE: 2.0
• TLGPC_TECHLOG_NO: VP-000375-2012
• TLGPC_KEY_SEQ_NO2: 1.0
• TLGPC_CRT_OU: 2.0
• TLGPC_MR_SOURCE: —
• TLGPC_PART_CRT_OU: 2.0
• TLGPC_PART_NO: SD00001-10280
• TLGPC_STOCK_STATUS: Aveos Owned

Outgoing relationships (1)

• HAS_SERIAL_LOT → SerialLotDetail
  • via FLOG_TLGPC_PART_CONSUMP_DTL.tlgpc_key_seq_no = FLOG_TLGSL_SERIAL_LOT_DTL.TLGSL_PART_KEY_SEQ_NO
  • Part consumption has serial/lot details

Incoming relationships (1)

• Task → HAS_PART_CONSUMPTION
  • via FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGPC_PART_CONSUMP_DTL.TLGPC_TASK_Track_id

See also

• FLOG_TLGPC_PART_CONSUMP_DTL
• SerialLotDetail
• Task