| 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 | 6 | HC | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
2 | F4011Z60 | Batch Receiver File - Order Details Commissions | 8 | DC | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
3 | F40344 | Preference Profile - Sales Commission | 16 | SA | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
4 | F40344R | Preference Resolution Ledger - Sales Commission | 18 | SA | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
TOP42: Sales Management |
5 | F42140 | Customer Master Commission Information | 5 | CM | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
6 | F42150 | Sales Order Header Commission Information | 6 | SH | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
7 | F42160 | Sales Order Detail Commission Information | 8 | SD | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
8 | F42160A | Temp Table Sales Order Commission information | 6 | SD | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
9 | F42UI150 | Sales Order Header Commission Information Work File | 5 | ZH | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
10 | F42UI160 | Sales Order Detail Commission Information Work File | 6 | ZD | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
TOP42B: Sales Order Entry |
11 | F42150Z1 | Header Commission Unedited Transaction File | 15 | S2 | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
12 | F42160Z1 | Detail Commission Unedited Transaction File | 17 | S3 | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
TOP47: Electronic Commerce |
13 | F4701150 | EDI Purchase Order Header Commission Inbound | 6 | PH | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
14 | F4701260 | EDI Purchase Order Detail Commission Inbound | 8 | PD | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
15 | F4709150 | EDI Request for Quote Header Commission - Inbound | 6 | QH | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
16 | F4709260 | EDI Request for Quote Detail Commission - Inbound | 8 | QD | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
17 | F4713150 | EDI Purchase Order Change Header Commission - Inbound | 6 | CH | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
18 | F4713260 | EDI Purchase Order Change Detail Commission - Inbound | 8 | PD | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |
TOP89: Conversion Programs |
19 | F40344A | Temporay Preference Profile - Sales Commission | 16 | SA | SLCM | Salesperson Commission 001 | Numeric | Generic Edit | 7 | 3 |