| 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 | 4 | HC | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 2 | F4011Z60 | Batch Receiver File - Order Details Commissions | 6 | DC | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 3 | F40344 | Preference Profile - Sales Commission | 30 | SA | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| TOP42: Sales Management |
| 4 | F42004 | Commission Constants File | 22 | CM | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 5 | F42005 | Sales Commission File | 52 | SC | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 6 | F42140 | Customer Master Commission Information | 3 | CM | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 7 | F42150 | Sales Order Header Commission Information | 4 | SH | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 8 | F42160 | Sales Order Detail Commission Information | 6 | SD | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 9 | F42UI005 | Sales Commission File | 52 | SC | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 10 | F42UI150 | Sales Order Header Commission Information Work File | 3 | ZH | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 11 | F42UI160 | Sales Order Detail Commission Information Work File | 4 | ZD | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| TOP42B: Sales Order Entry |
| 12 | F42150Z1 | Header Commission Unedited Transaction File | 13 | S2 | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 13 | F42160Z1 | Detail Commission Unedited Transaction File | 15 | S3 | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| TOP47: Electronic Commerce |
| 14 | F4701150 | EDI Purchase Order Header Commission Inbound | 4 | PH | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 15 | F4701260 | EDI Purchase Order Detail Commission Inbound | 6 | PD | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 16 | F4709150 | EDI Request for Quote Header Commission - Inbound | 4 | QH | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 17 | F4709260 | EDI Request for Quote Detail Commission - Inbound | 6 | QD | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 18 | F4713150 | EDI Purchase Order Change Header Commission - Inbound | 4 | CH | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 19 | F4713260 | EDI Purchase Order Change Detail Commission - Inbound | 6 | PD | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| TOP89: Conversion Programs |
| 20 | F40344A | Temporay Preference Profile - Sales Commission | 29 | SA | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| 21 | F42005A | Sales Commission File - Temporary | 52 | SC | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
| TOP90CB: CRM Sales Force Automation |
| 22 | F90CB02E | Opportunity_Employee Table | 38 | OE | CMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 |
