| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP01: Address Book |
1 | F0101 | Address Book Master | 29 | AB | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
2 | F0101Z2 | Address Book - Interoperability | 42 | SZ | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
TOP03: Accounts Receivable |
3 | F03012 | Customer Master by Line of Business | 140 | AI | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
4 | F03012A | Date Effective Category Codes | 5 | A2 | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
5 | F03012Z1 | Customer Master LOB-Batch File | 148 | VO | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
6 | F0311 | Accounts Receivable Ledger | 106 | RP | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
TOP03B: Enhanced Accounts Receivable |
7 | F03B465 | A/R Netting Workfile | 35 | RO | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
TOP04: Accounts Payable |
8 | F04514 | WF - 1099 Combined Workfile (Merge of F045141 and F045143) | 11 | G1 | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
9 | F045141 | WF - 1099 G/L Workfile | 11 | G1 | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
10 | F045143 | WF - 1099 A/P WorkFile | 11 | G1 | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
11 | F04572 | A/P Payment Processing - Summary File | 32 | KK | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
TOP05A: OW HR & PR Foundation |
12 | F060116Z | Unedited Quick Hire Transaction File | 178 | SZ | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
TOP07: Payroll |
13 | F074001 | New Hire Reporting Workfile - OneWorld Only | 106 | NH | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
TOP15: Property Management |
14 | F15525W | PM Statements Credit/Cash Build Workfile | 23 | RT | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
TOP42: Sales Management |
15 | F42004 | Commission Constants File | 6 | CM | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
16 | F42005 | Sales Commission File | 13 | SC | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
17 | F42UI005 | Sales Commission File | 13 | SC | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
18 | F42UI800 | Sales Detail Work File - Sales Update | 66 | SD | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
TOP47: Electronic Commerce |
19 | F47056 | EDI Payment Order Header - Outbound | 39 | D1 | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
20 | F47056W | EDI Payment Order Header - Work | 39 | D1 | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
TOP75T: Taiwan |
21 | F75T001 | GUI/VAT Declaration Site - 75T | 20 | DS | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
TOP76A: Argentina |
22 | F76A8001 | Generation SICORE's Files - Last Step -RG 738/99 - 04 | 12 | V2 | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
23 | F76A8051 | Perceptions Exempt per Company - 03B | 6 | PE | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
24 | F76A8500 | Tag File F03B14 - ARG - 03B - 76A | 30 | TF | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
25 | F76A8510 | Tag File F76A60 - ARG - 03B - 76A | 16 | TF | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
26 | F76A85Z1 | Tag File F76A60 Batch Entry - ARG - 03B - 76A | 21 | BE | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
27 | F76AUI44 | CERG A/P - Work File - ARG - 04 - 04 | 11 | WF | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
28 | F76AUI46 | CERG A/R -Work File - ARG - 03B - 03B | 11 | WF | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |
TOP89: Conversion Programs |
29 | F42005A | Sales Commission File - Temporary | 13 | SC | AC01 | Category Code - Address Book 01 | String | UDC | 3 | 0 |