flog_rbsc_bench_stk_cons_dtl
Logs bench stock part consumption transactions through Aircraft Maintenance Execution (AME) processes. Tracks backflushing operations and inventory deductions.
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 BenchStockConsump entity.
Primary key
rbsc_ou_instance, rbsc_mr_no, rbsc_iss_no
Columns (36)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | rbsc_ou_instance 🔑 | int | Organization Unit in Which the Bench Stock Consumption is Done |
| 2 | rbsc_package_no | varchar | Package Reference Number for Bench Stock Consumption |
| 3 | rbsc_task_no | varchar | Task Number Against Which the Bench Stock Consumption is Done |
| 4 | rbsc_tally_no | int | Tally Number |
| 5 | rbsc_part_no | varchar | Bench Stock Part Consumed |
| 6 | rbsc_serial_no | varchar | Serial Number of the Part |
| 7 | rbsc_lot_no | varchar | Lot Number of the Part |
| 8 | rbsc_remarks | varchar | Remarks |
| 9 | rbsc_warehouse | varchar | Warehouse |
| 10 | rbsc_stock_stat | varchar | Stock Status |
| 11 | rbsc_condition | varchar | Condition of the Part |
| 12 | rbsc_zone | varchar | Warehouse Zone |
| 13 | rbsc_bin | varchar | Warehouse Bin |
| 14 | rbsc_mr_no 🔑 | varchar | Material Request Number Generated for Bench Stock Consumption |
| 15 | rbsc_iss_no 🔑 | varchar | Issue Number Generated for Bench Stock Consumption |
| 16 | rbsc_track_id | bigint | Unique Tracking Id of the Task Against Which the Bench Stock Consumption is Done |
| 17 | rbsc_used_qty | numeric | Consumed Quantity |
| 18 | rbsc_rec_status | varchar | Status |
| 19 | rbsc_part_key_seqno | Bigint | Unique Key Which Identifies the Bench Stock Consumptions Part |
| 20 | rbsc_created_by | varchar | The User Who Has Consumed the Bench Stock Part and Recorded the Details in the System |
| 21 | rbsc_created_date | datetime | The Date and Time in Which the Bench Stock Consumption is Done |
| 22 | rbsc_modified_by | varchar | The User Who Has Last Modified the Bench Stock Consumption Details |
| 23 | rbsc_modified_date | datetime | The Date and Time in Which the Bench Stock Consumption is Last Modified |
| 24 | rbsc_timestamp | int | Timestamp |
| 25 | rbsc_issue_track_id | Bigint | Unique Id Which Associates the Bench Stock Consumption with Corresponding Issue Transaction |
| 26 | rbsc_mr_track_id | Bigint | Unique Id Which Associates the Bench Stock Consumption with Corresponding Material Request Transaction |
| 27 | rbsc_key_Seq_no | Bigint | Unique Key Which Uniquely Identifies the Bench Stock Consumption Across Packages |
| 28 | rbsc_stock_uom | varchar | Stock UOM of the Consumed Part |
| 29 | rbsc_part_desc | varchar | Part Description |
| 30 | rbsc_issue_basis | varchar | Issue Basis of the Consumed Part |
| 31 | rbsc_part_type | varchar | Type of the Consumed Part |
| 32 | rbsc_uom_desc | varchar | UOM Description |
| 33 | rbsc_issueCost | numeric | Issue Cost |
| 34 | rbsc_issue_LineNo | int | Issue Transaction Line Number |
| 35 | rbsc_MR_Priority | varchar | Material Request Priority Number |
| 36 | rbsc_line_no | int | Bench Stock Transaction Line Number |
Relationships (1)
- Task (FLOG_TLGWU_WORK_UNIT_DTL) →
HAS_BENCH_STOCK(this table is target)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = flog_rbsc_bench_stk_cons_dtl.rbsc_track_id - Task has bench stock consumption
- Join:
Sample rows (from live DB)
rbsc_ou_instance | rbsc_package_no | rbsc_task_no | rbsc_tally_no | rbsc_part_no | rbsc_serial_no |
|---|---|---|---|---|---|
| 2 | vp-000247-2012 | VP-000247-2012/1 | 1 | 0-0101-3-2769:36361 | ## |
| 2 | vp-000247-2012 | VP-000247-2012/1 | 1 | 0-0101-3-2769:36361 | ## |
| 2 | vp-000247-2012 | VP-000247-2012/1 | 1 | 0-0101-3-2769:36361 | ## |
Showing 3 of 118 rows.