swo_swoassoc_main_core_dtl
Stores association details between main cores and other components within a work order. This table is used to track dependencies, part usage, and ensures the integrity of component assemblies
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: SWO Associated Main Core Details
This table is the canonical store for the SWOCore entity.
Primary key
swoassoc_keyseqno
Columns (63)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swoassoc_associatedby | varchar | Replication key used to uniquely identify records. |
| 2 | swoassoc_associateddate | varchar | Date of the authentication task. |
| 3 | swoassoc_BERQty | numeric | Quantity related to the type of authentication performed. |
| 4 | swoassoc_bin | varchar | Indicates whether authentication is required (Yes or No). |
| 5 | Swoassoc_BrkupQty | numeric | Records any markup quantity related to customer warranty. |
| 6 | swoassoc_componentno | varchar | Identifies the component number associated with the work order. |
| 7 | swoassoc_comptype | varchar | Specifies the type of component in the work order. |
| 8 | swoassoc_condition | varchar | Notes the condition or discrepancy reported for the component. |
| 9 | swoassoc_consolidate | varchar | Captures remarks regarding the final disposition of the work order. |
| 10 | swoassoc_coreflag | varchar | Indicates core-specific notes or work estimation remarks. |
| 11 | Swoassoc_CoreStatus | varchar | Records the current status or final movement of the core. |
| 12 | swoassoc_co_lineno | int | Line number or sequence in the job card or report. |
| 13 | swoassoc_co_no | varchar | Reference number of the related job card. |
| 14 | Swoassoc_CR_keySeqno | int | Key sequence number for change requests or manufacturing remarks. |
| 15 | Swoassoc_cr_reconciled_qty | numeric | Quantity reconciled during manufacturing or inspection. |
| 16 | Swoassoc_cr_returned_qty | numeric | Quantity returned or adjusted during manufacturing. |
| 17 | swoassoc_Disposition | varchar | Instructions for handling or modifying the component. |
| 18 | swoassoc_keyseqno 🔑 | int | Sequence key for tracking progress in Review Part Readiness logs. |
| 19 | swoassoc_kit_status | varchar | Status of the kit or assembly associated with the core. |
| 20 | swoassoc_latestswono | varchar | Number of the latest shop work order associated. |
| 21 | swoassoc_lotno | varchar | Lot number for tracking components. |
| 22 | swoassoc_Mfrlotno | varchar | Manufacturer's lot number of the component. |
| 23 | swoassoc_Mfrno | varchar | Manufacturer identifier or replication key. |
| 24 | swoassoc_MfrPartno | varchar | Manufacturer’s part number of the component. |
| 25 | swoassoc_MfrSerialNo | varchar | Serial number assigned by the manufacturer. |
| 26 | swoassoc_modifiedby | varchar | User who last modified the record. |
| 27 | swoassoc_modifieddate | varchar | Timestamp of the last modification. |
| 28 | swoassoc_mod_lot_no | varchar | Modified lot number, if applicable. |
| 29 | swoassoc_mod_mfrno | varchar | Modified manufacturer number, if applicable. |
| 30 | swoassoc_mod_mfrpartno | varchar | Modified manufacturer part number. |
| 31 | swoassoc_mod_partno | varchar | Modified component part number. |
| 32 | swoassoc_mod_serialno | varchar | Modified serial number of the component. |
| 33 | Swoassoc_MVDtoWHQty | numeric | Quantity moved to warehouse. |
| 34 | swoassoc_NewMfrNo | varchar | New manufacturer number after change or replacement. |
| 35 | swoassoc_NewMfrPartNo | varchar | New manufacturer part number after change. |
| 36 | swoassoc_NewPartNo | varchar | New component part number after change. |
| 37 | swoassoc_NFF | varchar | Non-functional factor or user-defined field. |
| 38 | Swoassoc_OnWOQty | numeric | Quantity currently on work order. |
| 39 | swoassoc_org_keyseqno | int | Original sequence key before modifications. |
| 40 | swoassoc_org_qty | numeric | Original quantity before modifications. |
| 41 | swoassoc_ouinstance | int | Organizational unit instance. |
| 42 | swoassoc_partno | varchar | Part number of the component. |
| 43 | swoassoc_poscode | varchar | Position code of the component. |
| 44 | swoassoc_prog_notes | varchar | Progress notes for the component or work order. |
| 45 | swoassoc_PRqty | numeric | Planned or required quantity for the part. |
| 46 | swoassoc_remarks | varchar | General remarks for the record. |
| 47 | swoassoc_repairqty | numeric | Quantity of parts repaired. |
| 48 | Swoassoc_ROBERQtyBRS | numeric | Returned or rejected quantity for the work order. |
| 49 | Swoassoc_Rono | varchar | Reference number of the original work order. |
| 50 | Swoassoc_ROQty | numeric | Quantity recorded in the original work order. |
| 51 | swoassoc_RO_line_no | int | Line number in the original work order. |
| 52 | Swoassoc_RRcptQty | numeric | Quantity received after repair or change. |
| 53 | swoassoc_scrapflag | varchar | Indicates if a part is scrapped (Yes or No). |
| 54 | swoassoc_scrapnote | varchar | Notes regarding scrapped parts. |
| 55 | swoassoc_scrapnote_lineno | int | Line number of scrap note in report. |
| 56 | swoassoc_serialno | varchar | Serial number of the component. |
| 57 | swoassoc_Splitqty | numeric | Quantity split from original order or batch. |
| 58 | swoassoc_swono | varchar | Shop work order number associated with the component. |
| 59 | swoassoc_timestamp | int | Timestamp of record creation or activity. |
| 60 | swoassoc_usr_status | varchar | User-defined status for tracking manufacturing actions. |
| 61 | Swoassoc_WoScrapQtyWC | numeric | Work order scrap quantity (WC). |
| 62 | Swoassoc_WoScrapQtyWH | numeric | Work order scrap quantity (WH). |
| 63 | swoassoc_zoneid | varchar | Zone or location identifier. |
Sample rows (from live DB)
swoassoc_associatedby | swoassoc_associateddate | swoassoc_BERQty | swoassoc_bin | Swoassoc_BrkupQty | swoassoc_componentno |
|---|---|---|---|---|---|
| DMUSER | Mar 27 2013 5:51PM | — | — | — | C000050-2013 |
| DMUSER | Mar 27 2013 5:51PM | — | — | — | — |
| DMUSER | Mar 27 2013 5:51PM | — | — | — | — |
Showing 3 of 25,933 rows.