FLOG_FLMR_MAT_REQ_DTL
Maintains records of material requests raised for Aircraft Maintenance Execution ( AME ) packages. Includes material codes, quantities, requestors, and fulfillment statuses.
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.
Primary key
flmr_unique_id
Columns (32)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | flmr_part_key_seq_no | Bigint | Unique Id of an Aircraft Maintenance and Execution Part Request |
| 2 | flmr_task_track_id | Bigint | Unique Id of an Aircraft Maintenance and Execution Task |
| 3 | flmr_ouinstance | int | Organization Unit in Which the Part is Requested |
| 4 | flmr_part_no | varchar | Part Requested |
| 5 | flmr_mr_qty | numeric | Quantity Requested |
| 6 | flmr_mr_uom | varchar | Unit of Measurement of the Requested Part |
| 7 | flmr_wh_no | varchar | Warehouse from Where the Part is Requested |
| 8 | flmr_stock_status | varchar | Stock Status of the Requested Part |
| 9 | flmr_newpart_flag | varchar | Part Exist Flag N No Y Yes If the Part Requested is a New Part This Flag will be Yes |
| 10 | flmr_part_desc | varchar | Description of the Requested Part |
| 11 | flmr_rep_class | varchar | Repair Classification for Material Request |
| 12 | flmr_need_freq | varchar | Need Frequency for Part Number A Always AR As Required |
| 13 | flmr_request_mode | varchar | Part Request Mode NRM Normal CREQ Conditional Request FREQ Force Request |
| 14 | flmr_required_cond | varchar | Requested Condition of the Requested Part |
| 15 | flmr_alternate_type | varchar | Part Alternate Type NHA NHA NA Not Allowed SA Specific Alternates |
| 16 | flmr_alternate_part | varchar | Alternate Part for the Requested Part |
| 17 | flmr_eff_notes | varchar | Effectivity Notes for Request Mode Conditional Request and Force Request |
| 18 | flmr_hold_code | varchar | Hold Code When the Material Request is Put on Hold |
| 19 | flmr_hold_comments | varchar | Hold Code Comments When the Material Request is Put on Hold |
| 20 | flmr_mr_no | varchar | Material Request Number Through Which the Part is Requested |
| 21 | flmr_mr_lineno | int | Material Request Line Number Through Which the Part is Requested |
| 22 | flmr_mr_ou | int | Organization Unit in Which the Material Request is Generated |
| 23 | flmr_created_by | varchar | User Who Requested the Part |
| 24 | flmr_created_date | datetime | Date and Time in Which the Part Request is Raised |
| 25 | flmr_modified_by | varchar | User Who Modified the Part Request Last |
| 26 | flmr_modified_date | datetime | Date and Time in Which the Part Request is Modified Last |
| 27 | flmr_service_name | varchar | System Service Through Which the Part Request is Raised |
| 28 | flmr_timestamp | int | Timestamp for Part Request Incremented During Modification and Used for Concurrency Check |
| 29 | flmr_mr_shcl_qty | numeric | Short Close Quantity of the Requested Part |
| 30 | flmr_ben_stk_flag | varchar | Bench Stock Flag NRM Normal BF BackFlushing |
| 31 | flmr_unique_id 馃攽 | Bigint | Unique Id Helps to Track Aircraft Maintenance and Execution Material Requests |
| 32 | flmr_source_flag | varchar | Source from Where the Material Request is Generated ON Online OFF Offline |
Sample rows (from live DB)
flmr_part_key_seq_no | flmr_task_track_id | flmr_ouinstance | flmr_part_no | flmr_mr_qty | flmr_mr_uom |
|---|---|---|---|---|---|
| -2147483648 | 52447 | 2 | SD00001-10280 | 5.0 | EA |
| -2147483647 | 43 | 2 | 0-0033466-0:2D671 | 2.0 | EA |
| 2 | 41647 | 2 | 0-0050845-1:5N982 | 1.0 | EA |
Showing 3 of 4,534 rows.