swo_msgprt_upd_dtl
Table holds the missing parts details
Process: COMPMAINTENANCE 路 Component: BasSWO 路 Table type: Transaction Table Category: Message Part Update Details for SWO
Primary key
swo_msgprt_Seqno
Columns (20)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swo_msgprt_createdby | varchar | User who created the message part record |
| 2 | swo_msgprt_createddate | datetime | Date and time of creation of message part record |
| 3 | swo_msgprt_hdrpart | varchar | Header part number in the message |
| 4 | swo_msgprt_hdrserial | varchar | Header serial number in the message |
| 5 | swo_msgprt_lotno | varchar | Lot number of the part in message |
| 6 | swo_msgprt_mfrno | varchar | Manufacturer number of the part |
| 7 | swo_msgprt_mfrpartno | varchar | Manufacturer part number |
| 8 | swo_msgprt_mfrserialno | varchar | Manufacturer serial number |
| 9 | swo_msgprt_modifiedby | varchar | User who last modified the message part record |
| 10 | swo_msgprt_modifieddate | datetime | Date and time of last modification |
| 11 | swo_msgprt_ouinstance | numeric | Organizational unit instance associated with the part |
| 12 | swo_msgprt_partno | varchar | Part number in the message |
| 13 | swo_msgprt_qty | int | Quantity of the part |
| 14 | swo_msgprt_remarks | varchar | Remarks related to the part |
| 15 | swo_msgprt_Seqno 馃攽 | int | Sequence number of the part record |
| 16 | swo_msgprt_serialno | varchar | Serial number of the part |
| 17 | swo_msgprt_swono | varchar | Shop work order number associated with the part |
| 18 | swo_msgprt_swotype | varchar | Shop work order type |
| 19 | swo_msgprt_timestamp | int | Timestamp of message part record |
| 20 | swo_msgprt_uom | varchar | Unit of measure for the part quantity |