FLOG_TLGPC_PART_CONSUMP_DTL
Tracks part requests and consumption activities within Aircraft Maintenance Execution (AME) packages. Includes request IDs, part numbers, usage details, and consumption status.
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 PartConsumption entity.
Primary key
tlgpc_key_seq_no
Columns (90)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLGPC_SLFSRC_OUINSTANCE | #N/A | The Organization Unit to Which the Part Consumption Request Unit is Interacting |
| 2 | TLGPC_TECHLOG_NO | varchar | Aircraft Maintenance and Execution Package Number for Which the Part Request Consumption is Recorded |
| 3 | TLGPC_KEY_SEQ_NO2 | Bigint | Key Sequence Number |
| 4 | TLGPC_CRT_OU | #N/A | Part Request Consumption Recorded Organization Unit |
| 5 | TLGPC_MR_SOURCE | varchar | Source of Material Request |
| 6 | TLGPC_PART_CRT_OU | #N/A | The Organization Unit in Which the Part is Defined |
| 7 | TLGPC_PART_NO | varchar | Requested Consumed Part Number |
| 8 | TLGPC_STOCK_STATUS | varchar | Stock Status of the Part |
| 9 | TLGPC_REQD_QTY | decimal | Required Quantity |
| 10 | TLGPC_MATREQ_NO | varchar | Material Request Number |
| 11 | TLGPC_MATREQ_OU | #N/A | Organization Unit in Which the Material Request is Created |
| 12 | TLGPC_MATREQ_LINE_NO | #N/A | Material Request Line Number |
| 13 | TLGPC_CONSMD_QTY | decimal | Consumed Quantity |
| 14 | TLGPC_ISSUED_PART_CRT_OU | #N/A | The Organization Unit in Which the Issued Part is Created |
| 15 | TLGPC_ISSUED_PART_NO | varchar | Issued Part Number |
| 16 | TLGPC_ISSUED_QTY | decimal | Issued Quantity |
| 17 | TLGPC_MATERIAL_COST | decimal | Cost of the Material |
| 18 | TLGPC_SUBSTITUTE_TYPE | varchar | Substitute Type |
| 19 | TLGPC_SUBSTITUTE_PART_NO | varchar | Substitute Part Number |
| 20 | TLGPC_SUBS_PART_CRT_OU | #N/A | The Organization Unit in Which the Substitute Part is Created |
| 21 | TLGPC_WAREHOUSE_NO | varchar | Warehouse Number |
| 22 | TLGPC_WAREHOUSE_OU | #N/A | The Organization Unit in Which the Warehouse is Created |
| 23 | TLGPC_PEND_RET_QTY | decimal | Pending Return Quantity |
| 24 | TLGPC_PEND_RET_QTY_CORE | decimal | Pending Return Quantity Core |
| 25 | TLGPC_RET_QTY | decimal | Returned Quantity |
| 26 | TLGPC_CORE_RET_QTY | decimal | Returned Quantity Core |
| 27 | TlgPc_Reqmnt_Type | Varchar | Requirement Type |
| 28 | TLGPC_DiscrepancyNo | varchar | Discrepancy for Which the Part is Requested Consumed |
| 29 | TLGPC_AVAIL_QTY | decimal | Available Quantity |
| 30 | TLGPC_DISCREPANCY_SRCOU | int | The Organization Unit in Which the Discrepancy is Created |
| 31 | TLGPC_TASK_OU | int | The Organization Unit in Which the Task is Created |
| 32 | TLGPC_TASK_NO | varchar | Task for Which the Part is Requested Consumed |
| 33 | TLGPC_TASK_SEQ | Bigint | Sequence Number of the Task |
| 34 | TLGPC_NewPart | varchar | New Part Flag |
| 35 | TLGPC_NeedFrequency | varchar | Need Frequency |
| 36 | TLGPC_MRPriority | varchar | Material Request Priority |
| 37 | TLGPC_UOM | varchar | Unit of Measurement of Part |
| 38 | TLGPC_PartDescription | varchar | Description of Part |
| 39 | TLGPC_RECON_QTY | numeric | Reconciliation Quantity |
| 40 | tlgpc_wcstatus | varchar | Work Center Status |
| 41 | TLGPC_CreatedBy | varchar | The User Who Recorded the Part Request Consumption |
| 42 | TLGPC_CreatedDt | datetime | The Date and Time in Which the Part Request Consumption is Recorded |
| 43 | TLGPC_ModifiedBy | varchar | The User Who Modified the Part Request Consumption Last |
| 44 | TLGPC_ModifiedDt | datetime | The Date and Time in Which the Part Request Consumption Modified Last |
| 45 | TLGPC_Remarks | varchar | Remarks |
| 46 | TLGPC_TmpStamp | int | Indicates the Number of Times the Part Request Consumption is Modified |
| 47 | TLGPC_RECMODE | varchar | Record Mode |
| 48 | TLGPC_EFFFLAG | varchar | Effectivity Flag |
| 49 | TLGPC_RECQTL_EXCESS | numeric | Reconciliation Quantity Excess |
| 50 | TLGPC_ACTMAT_COST | numeric | Actual Material Cost |
| 51 | tlgpc_required_for | varchar | Part Required Part |
| 52 | tlgpc_std_qty | numeric | Standard Quantity |
| 53 | tlgpc_est_qty | numeric | Estimation Quantity |
| 54 | tlgpc_confirmed_qty | numeric | Confirmed Quantity |
| 55 | tlgpc_mr_qty | numeric | Material Request Quantity |
| 56 | tlgpc_rep_class | varchar | Repair Classification |
| 57 | tlgpc_requirment_flag | varchar | Requirement Flag |
| 58 | tlgpc_pma_flag | varchar | PMA Flag |
| 59 | tlgpc_billable_flag | varchar | Billable Flag |
| 60 | tlgpc_warranty_flag | varchar | Warranty Flag |
| 61 | tlgpc_est_remarks | varchar | Estimation Remarks |
| 62 | tlgpc_curr_rev_no | varchar | Current Estimation Revision Number |
| 63 | tlgpc_baseline_rev_no | varchar | Baseline Estimation Revision Number |
| 64 | tlgpc_plan_unplan_flag | varchar | Planned Unplanned Flag |
| 65 | tlgpc_effect_notes | varchar | Effectivity Notes |
| 66 | tlgpc_est_done | varchar | Estimation Completeness Flag |
| 67 | TLGPC_TASK_Track_id | Bigint | Unique Id of the Task |
| 68 | tlgpc_probability | numeric | Probability |
| 69 | tlgpc_mfr_part_no | varchar | Manufacturer Part Number |
| 70 | tlgpc_mfr_no | varchar | Manufacturer Number |
| 71 | TLGPC_Spec_Est_flag | varchar | Estimation Flag |
| 72 | TLGPC_PART_CONDITION | varchar | Condition of the Part |
| 73 | TLGPC_KEY_SEQ_NO | Bigint | Unique Key Which Identifies the Part Request Consumption Uniquely |
| 74 | tlgpc_source_flag | varchar | Source Flag |
| 75 | tlgpc_mr_need_date | datetime | Material Request Need Date |
| 76 | tlgpc_mr_req_by | varchar | Requested By |
| 77 | tlgpc_mr_class | varchar | Material Request Class |
| 78 | tlgpc_mr_category | varchar | Material Request Category |
| 79 | tlgpc_mr_file_name | varchar | File Name |
| 80 | tlgpc_mr_src_doc_type | varchar | Source Document Type |
| 81 | tlgpc_mr_src_refdoc_no | varchar | Source Document Number |
| 82 | tlgpc_mr_src_doc_date | varchar | Source Document Date |
| 83 | tlgpc_mr_src_docrevno | varchar | Source Document Revision Number |
| 84 | tlgpc_BFE_flag | Char | Tlgpc BFE Flag |
| 85 | tlgpc_endcustno | Char | Tlgpc Endcustno |
| 86 | TLGPCH_REMARKS | varchar | Part Request Remarks |
| 87 | tlgpc_dem_id | Bigint | Material Demand Track Id |
| 88 | tlgpc_auto_res_flg | varchar | Auto Allocation Restriction Flag for Material Request Generation |
| 89 | tlgpc_refreqid | bigint | Reference Document Request Record Tracking Number |
| 90 | tlgpc_refreqtyp | varchar | Reference Document Type |
Relationships (2)
- Task (FLOG_TLGWU_WORK_UNIT_DTL) →
HAS_PART_CONSUMPTION(this table is target)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGPC_PART_CONSUMP_DTL.TLGPC_TASK_Track_id - Task has part consumption records
- Join:
HAS_SERIAL_LOT→ SerialLotDetail (FLOG_TLGSL_SERIAL_LOT_DTL)- 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)
TLGPC_SLFSRC_OUINSTANCE | TLGPC_TECHLOG_NO | TLGPC_KEY_SEQ_NO2 | TLGPC_CRT_OU | TLGPC_MR_SOURCE | TLGPC_PART_CRT_OU |
|---|---|---|---|---|---|
| 2.0 | VP-000375-2012 | 1.0 | 2.0 | — | 2.0 |
| 2.0 | VP-000408-2013 | 1.0 | 2.0 | — | 2.0 |
| 2.0 | VP-000004-2012 | 1.0 | 2.0 | PRG | 2.0 |
Showing 3 of 14,441 rows.