FLOG_TLGRC_RES_CONSUMP_DTL
Records resource consumption details in Aircraft Maintenance Execution (AME) packages. Includes labor hours, tools, and other resource usage for tracking and costing.
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 ResourceConsumption entity.
Primary key
tlgrc_slfsrc_ouinstance, tlgrc_techlog_no, tlgrc_key_seq_no
Columns (43)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLGRC_SLFSRC_OUINSTANCE | #N/A | The Organization Unit to Which the Resource Consumption Recorded Unit is Interacting |
| 2 | TLGRC_TECHLOG_NO | varchar | Aircraft Maintenance and Execution Package Number for Which the Resource Consumption is Recorded |
| 3 | TLGRC_KEY_SEQ_NO | #N/A | Unique Number Which Identifies the Resource Consumption for Aircraft Maintenance and Execution Package |
| 4 | TLGRC_CRT_OU | #N/A | The Organization Unit in Which the Resource Consumption is Recorded |
| 5 | TLGRC_RESOURCE_TYPE | varchar | Type of the Resource |
| 6 | TLGRC_RESOURCE_OU | #N/A | The Organization Unit in Which the Consumed Resource is Defined |
| 7 | TLGRC_RESOURCE_NO | varchar | Resource Number |
| 8 | TLGRC_ACT_FROM_DATETIME | datetime | Actual Resource Consumption Start Time |
| 9 | TLGRC_ACT_TO_DATETIME | datetime | Actual Resource Consumption End Time |
| 10 | TLGRC_ACT_RES_DURN_HRS | decimal | Actual Duration in Hours |
| 11 | TLGRC_TASK_NO | varchar | Task for Which the Resource Consumption is Recorded |
| 12 | TLGRC_TASK_SEQNO | int | Sequence Number of the Task |
| 13 | TLGRC_ACT_COST | numeric | Actual Cost for the Resources Consumed |
| 14 | TLGRC_EST_FROM_DATETIME | datetime | Estimated Start Time |
| 15 | TLGRC_EST_TO_DATETIME | datetime | Estimated End Time |
| 16 | TLGRC_EST_DURN_HRS | numeric | Estimated Duration in Hours |
| 17 | TLGRC_UPMODE_ACT | varchar | Actual Update Mode |
| 18 | TLGRC_EST_COST | numeric | Estimated Cost |
| 19 | TLGRC_UPMODE_EST | varchar | Estimated Update Mode |
| 20 | TLGRC_ACT_RATE | numeric | Actual Rate |
| 21 | TLGRC_TASK_Track_id | bigint | Unique Id of Task in Aircraft Maintenance and Execution Package |
| 22 | TLGRC_FAC_OBJ_CODE | varchar | Facility Object Code |
| 23 | TLGRC_USED_VALUE | numeric | Used Value |
| 24 | TLGRC_USED_UOM | varchar | Used UOM |
| 25 | TLGRC_rep_class | varchar | Repair Classification |
| 26 | TLGRC_actual_no | numeric | Actual Resources Consumed |
| 27 | TLGRC_std_no | numeric | Estimated Resources |
| 28 | TLGRC_req_no | numeric | Requested Resources |
| 29 | tlgrc_plan_unplan_flag | varchar | Planned Unplanned Flag |
| 30 | tlgrc_created_by | varchar | The User Who Recorded the Resource Consumption |
| 31 | tlgrc_created_date | datetime | The Date and Time in Which the Resource Consumption is Recorded |
| 32 | tlgrc_modified_by | varchar | The User Who Last Modified the Resource Consumption |
| 33 | tlgrc_modified_date | datetime | The Date and Time in Which the Resource Consumption is Last Modified |
| 34 | tlgrc_timestamp | int | Indicates the Number of Times the Resource Consumption Got Modified |
| 35 | tlgrc_std_time | numeric | Estimated Time |
| 36 | tlgrc_req_time | numeric | Requested Time |
| 37 | tlgrc_actual_time | numeric | Actual Time |
| 38 | tlgrc_warranty_flag | varchar | Warranty Flag |
| 39 | tlgrc_est_time_uom | varchar | Unit of Measurement of Estimated Time |
| 40 | tlgrc_cost_center | varchar | Cost Center |
| 41 | tlgrc_fin_postingDone | varchar | Finance Posting Done Flag |
| 42 | tlgrc_est_no | int | Estimated Number of Person Needed |
| 43 | tlgrc_sch_updflag | varchar | Schedule Updated Flag |
Relationships (1)
- Task (FLOG_TLGWU_WORK_UNIT_DTL) →
HAS_RESOURCE_CONSUMPTION(this table is target)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGRC_RES_CONSUMP_DTL.TLGRC_TASK_Track_id - Task has resource consumption records
- Join:
Sample rows (from live DB)
TLGRC_SLFSRC_OUINSTANCE | TLGRC_TECHLOG_NO | TLGRC_KEY_SEQ_NO | TLGRC_CRT_OU | TLGRC_RESOURCE_TYPE | TLGRC_RESOURCE_OU |
|---|---|---|---|---|---|
| 2.0 | LC-000001-2019 | 2.0 | 2.0 | S | 2.0 |
| 2.0 | LC-000004-2019 | 1.0 | 2.0 | S | 2.0 |
| 2.0 | LC-000007-2019 | 2.0 | 2.0 | S | 2.0 |
Showing 3 of 43,718 rows.