| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP42: Sales Management |
| 1 | F4211 | Sales Order Detail File | 257 | SD | ALLSTS | Allocation Status Number | String | UDC | 30 | 0 |
| 2 | F42119 | Sales Order History File | 257 | SD | ALLSTS | Allocation Status Number | String | UDC | 30 | 0 |
| 3 | F42199 | S.O. Detail Ledger File | 257 | SL | ALLSTS | Allocation Status Number | String | UDC | 30 | 0 |
| 4 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 133 | ZD | ALLSTS | Allocation Status Number | String | UDC | 30 | 0 |
| TOP42W: Fulfilment Management |
| 5 | F427UI01 | Release Fulfillment Work File | 11 | RF | ALLSTS | Allocation Status Number | String | UDC | 30 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 42 / AS (Fulfillment Status) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | Y |
| 2 | 10 | Entered | | Y |
| 3 | 20 | Not fulfilled | | Y |
| 4 | 30 | Fulfilled | | Y |
| 5 | 40 | Partially Fulfilled | | Y |
| 6 | 50 | Released | | Y |
