SerialLotDetail

Serial or lot trace for a consumed part. Regulatory requirement for life-limited or serialised aviation parts.

Canonical table: FLOG_TLGSL_SERIAL_LOT_DTL · Key column: TLGSL_SL_KEY_SEQ_NO

Example record

• TLGSL_SLFSRC_OUINSTANCE: 2
• TLGSL_TECHLOG_NO: LC-000133-2020
• TLGSL_PART_KEY_SEQ_NO: 4583
• TLGSL_SL_KEY_SEQ_NO: 1
• TLGSL_SL_DISP_SEQ_NO: 1
• TLGSL_SERIAL_NO: —
• TLGSL_LOT_NO: LOT-007755-2020
• TLGSL_QUANTITY: 1.0

Incoming relationships (1)

• PartConsumption → HAS_SERIAL_LOT
  • via FLOG_TLGPC_PART_CONSUMP_DTL.tlgpc_key_seq_no = FLOG_TLGSL_SERIAL_LOT_DTL.TLGSL_PART_KEY_SEQ_NO

See also

• FLOG_TLGSL_SERIAL_LOT_DTL
• PartConsumption