| 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 Table | 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 |
TOP54R: Rental Management |
9 | F54R099 | Rental Contract Header Ledger | 40 | HL | DLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 |
10 | F54R10 | Rental Contract Header | 38 | CH | DLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 |
11 | F54R11 | Rental Contract Detail | 75 | CD | DLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 |
12 | F54R199 | Rental Contract Detail Ledger | 71 | DL | DLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 |
TOP89: Conversion Programs |
13 | F42005A | Sales Commission File - Temporary | 5 | SC | DLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 |