| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | SWJOBS | Job Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | SWCTID | Computer ID | String | Generic Edit | 15 | 0 | Allow NULL? |
| 3 | SWSHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | SWMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 5 | SWSSTS | Shipment Status | String | UDC (41 SS) | 2 | 0 | Allow NULL? |
| 6 | SWDL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 7 | SWDRQJ | Date - Requested | Date | Generic Edit | 6 | 0 | |
| 8 | SWADDJ | Date - Actual Ship Date | Date | Generic Edit | 6 | 0 | |
| 9 | SWADTM | Actual Shipment Time | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 10 | SWDLDT | Delivery Date | Date | Generic Edit | 6 | 0 | |
| 11 | SWDLTM | Time - Delivery | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 12 | SWCARS | Carrier Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 13 | SWALPH | Name - Alpha | String | Generic Edit | 40 | 0 | Allow NULL? |
| 14 | SWMOT | Mode of Transport | String | UDC (00 TM) | 3 | 0 | Allow NULL? |
| 15 | SWFRTH | Freight Handling Code | String | UDC (42 FR) | 3 | 0 | Allow NULL? |
| 16 | SWCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 17 | SWFRCC | Amount - Customer Freight Charge | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 18 | SWFRCF | Amount - Customer Freight Charge Foreign | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 19 | SWCRDC | Currency Code - To | String | Generic Edit | 3 | 0 | Allow NULL? |
| 20 | SWFRVC | Amount - Supplier Freight Charge | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 21 | SWFRVF | Amount - Supplier Freight Charge Foreign | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 22 | SWCRCP | Currency Code - A/P Amounts | String | Generic Edit | 3 | 0 | Allow NULL? |
| 23 | SWAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 24 | SWSHAN | Address Number - Ship To | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 25 | SWORGN | Origin Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 26 | SWNRTS | Number of Routing Steps | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 27 | SWILEL | Include/Exclude | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 28 | SWURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 29 | SWURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 30 | SWURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 31 | SWURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 32 | SWURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 33 | SWUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 34 | SWPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 35 | SWUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 36 | SWTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
