| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP31B: Blend Management |
| 1 | F31B03E | Barrel Inquiry Work File | 62 | BE | WOPST | Operation Status | String | UDC | 10 | 0 |
| 2 | F31B33DC | Dependency Chain Cache Structure | 9 | DT | WOPST | Operation Status | String | UDC | 10 | 0 |
| 3 | F31B65 | Operation Header | 7 | OH | WOPST | Operation Status | String | UDC | 10 | 0 |
| 4 | F31B74 | Operation Workflow Status Mapping | 2 | WM | WOPST | Operation Status | String | UDC | 10 | 0 |
| TOP40G: Grower Management |
| 5 | F40G70 | Harvest Operation Withholding Date | 5 | WH | WOPST | Operation Status | String | UDC | 10 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 31B / WF (WorkFlow Status) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 0 | PLANNED | N | Y |
| 2 | 1 | DRAFT | N | Y |
| 3 | 2 | ACTIVE | N | Y |
| 4 | 3 | ACTUAL | N | Y |
| 5 | 4 | CLOSED | N | Y |
| 6 | 5 | CANCELLED | N | Y |
