| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP12: Fixed Assets |
| 1 | F1217 | Equipment Master Extension | 14 | WR | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 2 | F1217P | Equipment Master Extension Purge Table | 14 | WR | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 3 | F1217Z1 | Unedited Equipment Tag Transactions | 27 | WR | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 4 | F1217Z2 | Unedited Equipment Tag Transactions | 27 | WR | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| TOP40: Inventory/OP Base |
| 5 | F4001Z50 | Batch Receiver File - Order Headings Commissions | 5 | HC | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 6 | F4011Z60 | Batch Receiver File - Order Details Commissions | 7 | DC | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 7 | F40303 | Preference Profile - Revenue Cost Center | 23 | RV | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 8 | F40344 | Preference Profile - Sales Commission | 15 | SA | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 9 | F40344R | Preference Resolution Ledger - Sales Commission | 17 | SA | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 10 | F40349 | Preference Profile - Revenue Business Unit (Branch) | 15 | RV | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 11 | F40349R | Preference Resolution Ledger - Revenue Bus Unit (Branch) | 17 | RV | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 12 | F4211AU | Sales Order Detail Audit File | 31 | AU | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| TOP42: Sales Management |
| 13 | F42140 | Customer Master Commission Information | 4 | CM | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 14 | F42150 | Sales Order Header Commission Information | 5 | SH | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 15 | F42160 | Sales Order Detail Commission Information | 7 | SD | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 16 | F42160A | Temp Table Sales Order Commission information | 5 | SD | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 17 | F42UI150 | Sales Order Header Commission Information Work File | 4 | ZH | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 18 | F42UI160 | Sales Order Detail Commission Information Work File | 5 | ZD | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| TOP42B: Sales Order Entry |
| 19 | F42150Z1 | Header Commission Unedited Transaction File | 14 | S2 | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 20 | F42160Z1 | Detail Commission Unedited Transaction File | 16 | S3 | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| TOP47: Electronic Commerce |
| 21 | F4701150 | EDI Purchase Order Header Commission Inbound | 5 | PH | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 22 | F4701260 | EDI Purchase Order Detail Commission Inbound | 7 | PD | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 23 | F4709150 | EDI Request for Quote Header Commission - Inbound | 5 | QH | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 24 | F4709260 | EDI Request for Quote Detail Commission - Inbound | 7 | QD | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 25 | F4713150 | EDI Purchase Order Change Header Commission - Inbound | 5 | CH | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| 26 | F4713260 | EDI Purchase Order Change Detail Commission - Inbound | 7 | PD | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| TOP89: Conversion Programs |
| 27 | F40344A | Temporay Preference Profile - Sales Commission | 15 | SA | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
| TOP90CA: CRM Foundation |
| 28 | F90CA003 | F42140 Mirror table for sync filtering. | 2 | SM | SLSM | Salesperson 01 | Numeric | Generic Edit | 8 | 0 |
