SWO_Swoisu_Issue_dtl
Main header table containing SWO information. This is the primary table that stores work order details including work order number, aircraft information, customer details, maintenance type, status, dates, and other core work order attributes.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Contains details of issues identified in Shop Work Orders (SWO)
Primary key
swoisu_uniqueid
Columns (61)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | SWOISU_adj_act_cost | varchar | User who created the record. |
| 2 | swoisu_created_by | varchar | Creation date of the record. |
| 3 | swoisu_created_date | datetime | Expense type. |
| 4 | SWOISU_expense_type | varchar | Expensing policy. |
| 5 | SWOISU_expensing_policy | varchar | Manufacturer of issued part. |
| 6 | swoisu_issmfr_no | varchar | Manufacturer part number of issued part. |
| 7 | swoisu_issmfr_part_no | varchar | Issued part description. |
| 8 | swoisu_isspart_desc | varchar | Issued part number. |
| 9 | swoisu_issued_cost | numeric | Organizational unit instance for issued part. |
| 10 | swoisu_issued_part_no | varchar | Issued quantity. |
| 11 | swoisu_issued_part_ou | int | Issued unit of measure. |
| 12 | swoisu_issued_qty | numeric | Issued warehouse. |
| 13 | swoisu_issued_uom | varchar | Issued unit of measure |
| 14 | swoisu_issued_wh | varchar | Issued warehouse |
| 15 | swoisu_issue_basis | varchar | Basis for the issue |
| 16 | swoisu_issue_lineno | int | Material issue line number |
| 17 | swoisu_issue_no | varchar | Material issue number |
| 18 | swoisu_issue_stockstatus | varchar | Issued stock status |
| 19 | swoisu_kit_cons_unique_id | Bigint | Unique identifier based on kit |
| 20 | swoisu_latest_return_no | varchar | Latest return document number |
| 21 | swoisu_latest_return_ou | int | Return component instance |
| 22 | swoisu_lot_no | varchar | Issued lot number |
| 23 | SWOISU_lot_no_type_no | varchar | Lot number type |
| 24 | swoisu_mat_type | varchar | Material type (Regular or Main Core) |
| 25 | swoisu_modified_by | varchar | Modified by |
| 26 | swoisu_modified_date | datetime | Modified date |
| 27 | swoisu_mr_line_no | int | Material request transaction line number |
| 28 | swoisu_mr_no | varchar | Material request transaction number |
| 29 | swoisu_mr_ou | int | Material request component instance |
| 30 | SWOISU_nonstockable_flag | varchar | Non-stockable flag |
| 31 | swoisu_ouinstance | int | SWO instance |
| 32 | SWOISU_part_acc_grp | varchar | Part account group |
| 33 | SWOISU_part_control_type | varchar | Part control type |
| 34 | swoisu_part_seq_no | bigint | Unique identifier for part requirement/estimation record |
| 35 | swoisu_part_type | varchar | Part type |
| 36 | swoisu_pend_ret_core_qty | numeric | Pending return quantity Core |
| 37 | swoisu_pend_ret_excess_qty | numeric | Pending return quantity Excess |
| 38 | swoisu_pend_ret_Mcore_qty | numeric | Pending return quantity Main Core |
| 39 | swoisu_recon_core_qty | numeric | Reconciliation quantity Core |
| 40 | swoisu_recon_excess_qty | numeric | Reconciliation quantity Excess |
| 41 | swoisu_recon_remarks | varchar | Reconciliation remarks |
| 42 | swoisu_reqmfr_no | varchar | Manufacturer for the requested part |
| 43 | swoisu_reqmfr_part_no | varchar | Requested manufacturer part number |
| 44 | swoisu_reqpart_desc | varchar | Requested part description |
| 45 | swoisu_request_part_no | varchar | Requested part number |
| 46 | swoisu_request_part_ou | int | Request part instance |
| 47 | swoisu_return_basis | varchar | Return basis |
| 48 | swoisu_return_remarks | varchar | Return remarks |
| 49 | swoisu_return_wh | varchar | Return warehouse |
| 50 | swoisu_ret_core_qty | numeric | Returned quantity Core |
| 51 | swoisu_ret_excess_qty | numeric | Returned quantity Excess |
| 52 | swoisu_ret_Mcore_qty | numeric | Returned quantity Main Core |
| 53 | swoisu_serial_no | varchar | Issued serial number |
| 54 | swoisu_service | varchar | Service name of the transaction updating the record |
| 55 | SWOISU_sl_no_logic | varchar | Serial number logic |
| 56 | SWOISU_sl_no_type_no | varchar | Serial number type |
| 57 | swoisu_task_track_id | bigint | Task track ID for material issue |
| 58 | swoisu_timestamp | int | Timestamp |
| 59 | swoisu_uniqueid 🔑 | bigint | Unique ID, primary key |
| 60 | swoisu_used_qty | numeric | Used quantity |
| 61 | SWOISU_valuation_method | varchar | Valuation method |
Sample rows (from live DB)
SWOISU_adj_act_cost | swoisu_created_by | swoisu_created_date | SWOISU_expense_type | SWOISU_expensing_policy | swoisu_issmfr_no |
|---|---|---|---|---|---|
| — | DMUSER | 2013-04-01 12:21:37.097 | — | — | 58828 |
| — | DMUSER | 2013-04-01 14:21:34.533 | — | — | 20772 |
| — | DMUSER | 2013-04-01 17:47:17.430 | — | — | 35895 |
Showing 3 of 10,157 rows.