| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP01: Address Book |
1 | F0101 | Address Book Master | 35 | AB | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
2 | F0101Z2 | Address Book - Interoperability | 48 | SZ | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
TOP03: Accounts Receivable |
3 | F03012 | Customer Master by Line of Business | 146 | AI | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
4 | F03012A | Date Effective Category Codes | 11 | A2 | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
5 | F03012Z1 | Customer Master LOB-Batch File | 154 | VO | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
6 | F0311 | Accounts Receivable Ledger | 112 | RP | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
TOP03B: Enhanced Accounts Receivable |
7 | F03B465 | A/R Netting Workfile | 41 | RO | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
TOP04: Accounts Payable |
8 | F0411 | Accounts Payable Ledger | 84 | RP | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
9 | F0411A | WF - As Of - Accounts Payable Ledger | 84 | RP | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
10 | F0411P | Purge - Accounts Payable Ledger | 84 | RP | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
11 | F0411Z1 | Voucher Transactions - Batch File | 102 | VL | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
12 | F0411Z3 | F0411 Interoperability Table | 107 | SZ | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
13 | F04514 | WF - 1099 Combined Workfile (Merge of F045141 and F045143) | 17 | G1 | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
14 | F045141 | WF - 1099 G/L Workfile | 17 | G1 | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
15 | F045143 | WF - 1099 A/P WorkFile | 17 | G1 | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
TOP05A: OW HR & PR Foundation |
16 | F060116Z | Unedited Quick Hire Transaction File | 184 | SZ | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
TOP15: Property Management |
17 | F15525W | PM Statements Credit/Cash Build Workfile | 29 | RT | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
TOP43: Procurement |
18 | F4314Z | Voucher Match Selection File | 49 | PN | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
TOP47: Electronic Commerce |
19 | F47056 | EDI Payment Order Header - Outbound | 45 | D1 | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
20 | F47056W | EDI Payment Order Header - Work | 45 | D1 | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
TOP75T: Taiwan |
21 | F75T001 | GUI/VAT Declaration Site - 75T | 26 | DS | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
TOP76C: Colombia |
22 | F76CI2 | Economic Activity - COL - 76C | 3 | AE | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
23 | F76CT2 | Sales/Use/V.A.T. Tax File - COL - 76C | 31 | CT | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
TOP76V: Venezuela |
24 | F76V4580 | Retention Parameters - VEN - 04 - 76V | 1 | RT | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
25 | F76V4581 | Withholding Historical File - VEN - 04 | 11 | HR | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |
26 | F76V4583 | Withholdings I.S.L.R. Fee 2 - VEN - 04 | 3 | TD | AC07 | Category Code - Address Book 07 | String | UDC | 3 | 0 |