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