FLOG_TLGSL_SERIAL_LOT_DTL
Stores preferred serial and lot information selected for parts consumed in AME packages. Ensures traceability of serialized and lot-controlled parts.
Process: LINEMAINTENANCE · Component: BasFltLog · Table type: Transaction Table Category: Organize the table related to the Aircraft Maintenance Execution ( AME ) package which tracks part consumption, resources, materials, component removals and component replacement.
This table is the canonical store for the SerialLotDetail entity.
Primary key
TLGSL_SLFSRC_OUINSTANCE, TLGSL_TECHLOG_NO, TLGSL_PART_KEY_SEQ_NO, TLGSL_SL_KEY_SEQ_NO
Columns (15)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLGSL_SLFSRC_OUINSTANCE 🔑 | int | The Organization Unit in Which the Preferred Serial Lot Details are Recorded |
| 2 | TLGSL_TECHLOG_NO 🔑 | varchar | Aircraft Maintenance and Execution Package Number for Which the Preferred Serial Lot Details are Recorded |
| 3 | TLGSL_PART_KEY_SEQ_NO 🔑 | int | Unique Id Which Uniquely Identifies the Part Request Raised Against the Corresponding Aircraft Maintenance and Execution Package |
| 4 | TLGSL_SL_KEY_SEQ_NO 🔑 | int | Unique Id Which Uniquely Identifies the Preferred Serial Lot Details Raised Against the Corresponding Aircraft Maintenance and Execution Package |
| 5 | TLGSL_SL_DISP_SEQ_NO | int | Display Sequence Number of the Preferred Serial Lot Request |
| 6 | TLGSL_SERIAL_NO | varchar | Preferred Serial Number Requested |
| 7 | TLGSL_LOT_NO | varchar | Preferred Lot Number Requested |
| 8 | TLGSL_QUANTITY | numeric | Quantity Requested |
| 9 | TLGSL_CREATED_BY | varchar | The User Who Raised the Preferred Serial Lot Request |
| 10 | TLGSL_CREATED_DATETIME | datetime | The Date and Time at Which the Preferred Serial Lot Request is Recorded |
| 11 | TLGSL_MODIFIED_BY | varchar | The User Who Modified the Preferred Serial Lot Request Last |
| 12 | TLGSL_MODIFIED_DATETIME | datetime | The Date and Time at Which the Preferred Serial Lot Request is Modified Last |
| 13 | TLGSL_MR_Quantity | numeric | Material Request Quantity |
| 14 | TLGSL_Task_Track_id | int | Task Track Id |
| 15 | tlgsl_dem_id | Bigint | Material Demand Tracking Number |
Relationships (1)
- PartConsumption (FLOG_TLGPC_PART_CONSUMP_DTL) →
HAS_SERIAL_LOT(this table is target)- Join:
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
- Join:
Sample rows (from live DB)
TLGSL_SLFSRC_OUINSTANCE | TLGSL_TECHLOG_NO | TLGSL_PART_KEY_SEQ_NO | TLGSL_SL_KEY_SEQ_NO | TLGSL_SL_DISP_SEQ_NO | TLGSL_SERIAL_NO |
|---|---|---|---|---|---|
| 2 | LC-000133-2020 | 4583 | 1 | 1 | — |
| 2 | LC-000133-2020 | 4584 | 1 | 1 | SL-000083-2014 |
| 2 | LC-000133-2020 | 4585 | 1 | 1 | SL-001459-2020 |
Showing 3 of 45 rows.