| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP03: Accounts Receivable |
1 | F03012 | Customer Master by Line of Business | 108 | AI | CMC1 | Commission Code 1 | Numeric | Generic Edit | 8 | 0 |
2 | F03012Z1 | Customer Master LOB-Batch Table | 121 | VO | CMC1 | Commission Code 1 | Numeric | Generic Edit | 8 | 0 |
3 | F0311 | Accounts Receivable Ledger | 88 | RP | CMC1 | Commission Code 1 | Numeric | Generic Edit | 8 | 0 |
TOP03B: Enhanced Accounts Receivable |
4 | F03B11 | Customer Ledger | 85 | RP | CMC1 | Commission Code 1 | Numeric | Generic Edit | 8 | 0 |
5 | F03B11P | Customer Ledger Purge File | 85 | RP | CMC1 | Commission Code 1 | Numeric | Generic Edit | 8 | 0 |
6 | F03B11Z1 | Batch Invoices | 101 | VJ | CMC1 | Commission Code 1 | Numeric | Generic Edit | 8 | 0 |
7 | F03B11Z2 | F03B11 Interoperability Table | 98 | SY | CMC1 | Commission Code 1 | Numeric | Generic Edit | 8 | 0 |
8 | F03B575 | Auto Debit Invoice Select and Build | 94 | RD | CMC1 | Commission Code 1 | Numeric | Generic Edit | 8 | 0 |
TOP40: Inventory/OP Base |
9 | F4211DT | Sales Order Detail Date Tracking File | 10 | DT | CMC1 | Commission Code 1 | Numeric | Generic Edit | 8 | 0 |
TOP89: Conversion Programs |
10 | F42140A | Copy from F42140 to Temp Table F42140A | 3 | CM | CMC1 | Commission Code 1 | Numeric | Generic Edit | 8 | 0 |
11 | F42150A | ERP9.0 Update F42150 (Temp File) | 4 | SH | CMC1 | Commission Code 1 | Numeric | Generic Edit | 8 | 0 |