| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F40943 | Order Group Key ID Master File | 1 | OK | SDGR | Order Detail Group | String | UDC | 8 | 0 |
TOP45: Advanced Pricing |
2 | F4071 | Price Adjustment Type | 4 | AT | SDGR | Order Detail Group | String | UDC | 8 | 0 |
3 | F4071P | Price Adjustment Type Purge | 5 | AT | SDGR | Order Detail Group | String | UDC | 8 | 0 |
4 | F4510 | Price Workbench Query Header | 14 | PW | SDGR | Order Detail Group | String | UDC | 8 | 0 |
5 | F4511W | Pricing Structure View | 9 | AP | SDGR | Order Detail Group | String | UDC | 8 | 0 |
TOP89: Conversion Programs |
6 | F4072TEM | Price Adjustment Detail - Temp for Upgrade | 7 | AD | SDGR | Order Detail Group | String | UDC | 8 | 0 |
7 | F4074TEM | Price Adjustment Ledger File - Temp for Upgrade | 7 | AL | SDGR | Order Detail Group | String | UDC | 8 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 40 / SD (Sales Detail Groups) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | . | | N |
2 | CODE | Price Code 1 | | N |
3 | EDI | Electronic Commerce | | N |
4 | REPAS/SG | Repasse-SO Group (Brazil) | | N |