| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40R: Demand Scheduling |
| 1 | F40R14 | Demand Addresses | 5 | DA | IDNUMTYP | ID Number Type | String | UDC | 2 | 0 |
| 2 | F40R143 | Demand Address History | 4 | DS | IDNUMTYP | ID Number Type | String | UDC | 2 | 0 |
| 3 | F471722 | EDI Demand Addresses | 26 | EA | IDNUMTYP | ID Number Type | String | UDC | 2 | 0 |
| TOP47: Electronic Commerce |
| 4 | F470374 | EDI ASN Demand Addresses | 28 | AM | IDNUMTYP | ID Number Type | String | UDC | 2 | 0 |
| 5 | F47196 | EDI Acknowledgement Name And Address | 17 | AA | IDNUMTYP | ID Number Type | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 40R / ID (Identification Number Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 16 | DUNS | Dun & Brad | N |
| 2 | 86 | Assigned by Originator | | N |
| 3 | 88 | Assigned by Owner of Operation | | N |
| 4 | 92 | Assigned by Buyer | | N |
| 5 | 98 | Purchasing Office | | N |
