| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F4001Z50 | Batch Receiver File - Order Headings Commissions | 9 | HC | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| 2 | F4011Z60 | Batch Receiver File - Order Details Commissions | 11 | DC | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| 3 | F40344 | Preference Profile - Sales Commission | 31 | SA | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| TOP42: Sales Management |
| 4 | F42004 | Commission Constants File | 2 | CM | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| 5 | F42005 | Sales Commission File | 8 | SC | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| 6 | F42140 | Customer Master Commission Information | 8 | CM | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| 7 | F42150 | Sales Order Header Commission Information | 9 | SH | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| 8 | F42160 | Sales Order Detail Commission Information | 11 | SD | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| 9 | F42UI005 | Sales Commission File | 8 | SC | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| 10 | F42UI150 | Sales Order Header Commission Information Work File | 8 | ZH | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| 11 | F42UI160 | Sales Order Detail Commission Information Work File | 9 | ZD | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| TOP42B: Sales Order Entry |
| 12 | F42150Z1 | Header Commission Unedited Transaction File | 18 | S2 | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| 13 | F42160Z1 | Detail Commission Unedited Transaction File | 20 | S3 | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| TOP47: Electronic Commerce |
| 14 | F4701150 | EDI Purchase Order Header Commission Inbound | 9 | PH | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| 15 | F4701260 | EDI Purchase Order Detail Commission Inbound | 11 | PD | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| 16 | F4709150 | EDI Request for Quote Header Commission - Inbound | 9 | QH | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| 17 | F4709260 | EDI Request for Quote Detail Commission - Inbound | 11 | QD | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| 18 | F4713150 | EDI Purchase Order Change Header Commission - Inbound | 9 | CH | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| 19 | F4713260 | EDI Purchase Order Change Detail Commission - Inbound | 11 | PD | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
| TOP89: Conversion Programs |
| 20 | F42005A | Sales Commission File - Temporary | 8 | SC | CCTY | Commission Code Type | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
