| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F4215 | Shipment Header | 68 | XH | ETRSC | Excess Reason Code | String | UDC | 3 | 0 |
| TOP47: Electronic Commerce |
| 2 | F470373 | EDI ASN Shipping | 23 | AG | ETRSC | Excess Reason Code | String | UDC | 3 | 0 |
| 3 | F470472 | EDI Invoice Expanded Detail (Sales) | 22 | S6 | ETRSC | Excess Reason Code | String | UDC | 3 | 0 |
| TOP49: Transportation Management |
| 4 | F49110 | Transportation Bill of Lading Workfile | 75 | BW | ETRSC | Excess Reason Code | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 49 / ES (Excess Reason) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | N | N |
| 2 | A | Special rail car order | N | N |
| 3 | B | Eng. change or late release | N | N |
| 4 | C | Specification error | N | N |
| 5 | D | Shipment tracing delay | N | N |
