| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0401Z1 | Supplier Master - Batch File | 48 | VO | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| TOP01: Address Book |
| 2 | F0401 | Supplier Master | 34 | A6 | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| TOP03: Accounts Receivable |
| 3 | F03012 | Customer Master by Line of Business | 80 | AI | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 4 | F03012Z1 | Customer Master LOB-Batch File | 93 | VO | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| TOP17C: Call Management |
| 5 | F17111 | Base Warranty Defaults | 10 | BC | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| TOP40: Inventory/OP Base |
| 6 | F4094 | Item/Customer Key ID Master File | 6 | KI | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 7 | F40942 | Customer Key ID Master File | 1 | CK | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 8 | F4106NC | Base Price Extraction | 19 | SZ | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 9 | F4208 | Price by Customer | 1 | PG | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| TOP42: Sales Management |
| 10 | F42UI01 | SO Header Cache File (MBF) | 106 | ZH | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| TOP45: Advanced Pricing |
| 11 | F4071 | Price Adjustment Type | 3 | AT | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 12 | F4094TEM | ICID Conversion X-Ref | 7 | TC | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 13 | F4510 | Price Workbench Query Header | 4 | PW | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 14 | F4511W | Pricing Structure View | 8 | AP | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 15 | F4574 | Key Reference Table | 83 | KR | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 16 | F4575 | Ship and Debit History | 14 | AH | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 17 | F4575TMP | Ship and Debit History - Temp Table | 14 | AH | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 18 | F4576 | Ship and Debit Claims | 15 | AC | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 19 | F4576TMP | Ship and Debit Claims- Temp Table | 15 | AC | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 20 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 28 | Z1 | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| TOP48S: Service Billing |
| 21 | F48096 | Billing Rate / Mark up Table | 23 | WQ | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 22 | F4812 | Billing Detail Workfile | 166 | WD | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 23 | F4812H | Billing Workfile - History | 166 | WD | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 24 | F4812HS | Billing Workfile History Purged Save | 166 | WD | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| 25 | F48SUI01 | Billing Detail Print Workfile | 166 | WD | CPGP | Customer Price Group | String | UDC | 8 | 0 |
| TOP52: Contract Billing |
| 26 | F5212 | T and M - Unit Price and Lumpsum Cross Reference Accounts | 24 | G5 | CPGP | Customer Price 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.
