| 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 | 50 | AI | DLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 |
2 | F03012Z1 | Customer Master LOB-Batch File | 63 | VO | DLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 |
TOP03B: Enhanced Accounts Receivable |
3 | F03B16S | A/R Statistical Summary | 19 | RS | DLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 |
TOP40: Inventory/OP Base |
4 | F4207 | Price by Item | 22 | PM | DLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 |
TOP41: Inventory Management |
5 | F4115 | Item History | 27 | IH | DLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 |
TOP42: Sales Management |
6 | F42005 | Sales Commission File | 5 | SC | DLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 |
7 | F4229 | Sales Summary History File | 64 | SS | DLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 |
8 | F42UI005 | Sales Commission File | 5 | SC | DLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 |
TOP89: Conversion Programs |
9 | F42005A | Sales Commission File - Temporary | 5 | SC | DLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 |