FL_TLISSRET_ISSUE_DTL
Holds part issues done for AME packages
Process: LINEMAINTENANCE · Component: BasFltLog · Table type: Transaction Category: Organize the table related to the Aircraft Maintenance Execution ( AME ) package which tracks part consumption, resources, materials, component removals and component replacement.
Columns (68)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLISSRET_SLFSRC_OUINSTANCE | — | The organization unit in which the issue detail is recorded |
| 2 | TLISSRET_TECHLOG_NO | — | AME Package # |
| 3 | TLISSRET_KEY_SEQ_NO | — | Key which helps to identify the issue details under AME package |
| 4 | TLISSRET_ISSUEPART | — | Issued Part Number |
| 5 | TLISSRET_LOT | — | Issued Lot Number |
| 6 | TLISSRET_SERIAL | — | Issued Serial Number |
| 7 | TLISSRET_RETURN_BASIS | — | Return Basis. E.g, EX- Exchange |
| 8 | TLISSRET_RETURN_PART | — | Return Part Number |
| 9 | TLISSRET_RETURN_LOT | — | Return Lot Number |
| 10 | TLISSRET_RETURN_SERIAL | — | Return Serial Number |
| 11 | TLISSRET_RETURN_QUANTITY | — | Return Quantity |
| 12 | TLISSRET_RETURN_UOM | — | Return UOM |
| 13 | TLISSRET_STOCK_STATUS | — | Stock Status |
| 14 | TLISSRET_CONDITION_RETURNED | — | Condition in which the part is returned |
| 15 | TLISSRET_EXPIRY_DATE | — | Expiry Date |
| 16 | TLISSRET_PART_TYPE | — | Type of part. 'Component', 'Consumable', etc., |
| 17 | TLISSRET_PART_CONTROL_TYPE | — | Part Control Type. 'Lot', 'Serial', 'Lot and Serial' |
| 18 | TLISSRET_EXPENSE_TYPE | — | The type of expense incurred |
| 19 | TLISSRET_VALUE | — | Return Value |
| 20 | TLISSRET_ISSUED_QUANTITY | — | Issued Quantity |
| 21 | TLISSRET_ISSUED_UOM | — | The Unit of Measurement in which the part is issued |
| 22 | TLISSRET_ISSUE_WAREHOUSE | — | Ware House from where the part is issued |
| 23 | TLISSRET_ACCOUNT_USAGE | — | Account Usage |
| 24 | TLISSRET_COSTING_USAGE | — | Costing Usage |
| 25 | TLISSRET_LINE_NO | — | Line NUmber |
| 26 | TLISSRET_TASK_NO | — | Task Number |
| 27 | TLISSRET_MATERIAL_TYPE | — | Material Type. 'Main Core', 'Regular' |
| 28 | TLISSRET_ISSUE_NO | — | Issue Document Number |
| 29 | TLISSRET_USED_QTY | — | Used Quantity |
| 30 | TLISSRET_PEND_RET_QTY | — | Pending Return quantity |
| 31 | TLISSRET_PEND_RET_QTY_CORE | — | Pending Return Core Quantity |
| 32 | TLISSRET_CORE_RET_QTY | — | Core Return Quantity |
| 33 | TLISSRET_ISSUE_COST | — | Issue Cost |
| 34 | TLISSRET_SRLOT_SEQNO | — | Issue Serial sequence Number |
| 35 | TLISSRET_TIME_STAMP | — | Timestamp. Helps to identify the number of time the issue request got modfied |
| 36 | TLISSRET_ISS_BASIS | — | Issue Basis |
| 37 | TLISSRET_ISUID_PRTSYSLNNO | — | Issue part line number |
| 38 | TLISSRET_RET_COST | — | Return Cost |
| 39 | TLISSRET_RET_NO | — | Return document Number |
| 40 | TLISSRET_RET_SYSLNNO | — | Return line number |
| 41 | TLISSRET_RECON_QTY | — | Reconcile Quantity |
| 42 | TLISSRET_RECQTY_EXCESS | — | Reconcile Excess Quantity |
| 43 | TLISSRET_RECREMARKS | — | Reconcile Remarks |
| 44 | TLISSRET_ISSCOMPID | — | Issued component ID |
| 45 | tlissret_autorec_remarks | — | Auto reconciliation remarks |
| 46 | TLISSRET_Task_Track_ID | — | Track ID which uniquely identifies tasks in AME packages |
| 47 | TLISSRET_request_part_no | — | Requested Part Number |
| 48 | TLISSRET_requested_serial_no | — | Requested Serial Number |
| 49 | TLISSRET_requested_lot_no | — | Requested Lot Number |
| 50 | TLISSRET_MR_NO | — | Material Request Number |
| 51 | TLISSRET_MR_LINE_NO | — | Material Request Line Number |
| 52 | tlissret_ben_stk_flag | — | Bench stock flag. Will be true if the issue is happened through bench stock consumption |
| 53 | created_area_code | — | Area code/Location in which the AME Issue infromation is recorded. Applicable only if the application is configured for OFMS operations. |
| 54 | TLISSRET_ISSUE_UNIQUEID | — | Key which helps to identify the issue details uniquely under AME package |
| 55 | tlissret_source_flag | — | Source flag. On-line / Off-line |
| 56 | tlissret_nonstockable_flag | — | Non-stockable flag of issued part |
| 57 | tlissret_sl_no_logic | — | Serial # generation logic of issued part |
| 58 | tlissret_sl_no_type_no | — | Numbering type for serial # generation for issued part |
| 59 | tlissret_lot_no_type_no | — | Numbering type for lot # generation for issued part |
| 60 | tlissret_part_acc_grp | — | Part account group of issued part |
| 61 | tlissret_part_desc | — | Part description of issued part |
| 62 | tlissret_valuation_method | — | Valuation method of issued part |
| 63 | tlissret_adj_act_cost | — | Adjusted actual cost of issued part |
| 64 | tlissret_expensing_policy | — | Expensing policy of issued part |
| 65 | tlissret_stock_uom | — | Stock UOM of issued part |
| 66 | TLISSRET_kit_cons_unique_id | — | TLISSRET_kit_cons_unique_id |
| 67 | TLISSRET_MODIFIED_DATETIME | — | Modified time |
| 68 | TLISSRET_CREATED_DATETIME | — | Created time |
Sample rows (from live DB)
TLISSRET_SLFSRC_OUINSTANCE | TLISSRET_TECHLOG_NO | TLISSRET_KEY_SEQ_NO | TLISSRET_ISSUEPART | TLISSRET_LOT | TLISSRET_SERIAL |
|---|---|---|---|---|---|
| 2.0 | VP-000408-2013 | -2147483647.0 | 0-0033466-0:2D671 | ## | ## |
| 2.0 | VP-000087-2012 | 3.0 | 0-0050845-1:5N982 | ## | ## |
| 2.0 | VP-000089-2012 | 5.0 | 0-0050845-1:5N982 | ## | ## |
Showing 3 of 1,317 rows.