| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP01: Address Book |
1 | F0101 | Address Book Master | 3 | AB | TAX | Tax ID | String | Generic Edit | 20 | 0 |
2 | F0101Z2 | Address Book - Interoperability | 16 | SZ | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP04: Accounts Payable |
3 | F04514 | 1099 Merged Worktables (F045141:F045143) | 3 | G1 | TAX | Tax ID | String | Generic Edit | 20 | 0 |
4 | F045141 | 1099 G/L Worktable | 3 | G1 | TAX | Tax ID | String | Generic Edit | 20 | 0 |
5 | F045143 | 1099 A/P Worktable | 3 | G1 | TAX | Tax ID | String | Generic Edit | 20 | 0 |
6 | F045145 | 1099 Securities Identification File | 3 | G2 | TAX | Tax ID | String | Generic Edit | 20 | 0 |
7 | F04UI006 | 1099 Worktable User Index | 4 | G1 | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP05: Time Accounting and HRM Base |
8 | F054101 | Employee Personal Profile Information History Table | 13 | EH | TAX | Tax ID | String | Generic Edit | 20 | 0 |
9 | F054101W | Employee Personal Profile Information Work Table | 13 | EP | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP07: Payroll |
10 | F055011W | Auto Deposit Instructions Work File | 5 | AD | TAX | Tax ID | String | Generic Edit | 20 | 0 |
11 | F065016 | Automatic Bank Deposit Master | 5 | YG | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP43Q: Strategic Sourcing |
12 | F43Q10 | Event Header | 19 | EH | TAX | Tax ID | String | Generic Edit | 20 | 0 |
13 | F43Q91 | Bidder Registration | 5 | BR | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP47: Electronic Commerce |
14 | F470161 | EDI Purchase Order Additional Header - Outbound | 15 | S3 | TAX | Tax ID | String | Generic Edit | 20 | 0 |
15 | F470461 | EDI Invoice Additional Header - Outbound | 17 | S3 | TAX | Tax ID | String | Generic Edit | 20 | 0 |
16 | F471061 | EDI Response to RFQ Additional Header - Outbound | 17 | S3 | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP70: Multi-National Products |
17 | F7009001 | Chart of Accounts by Level | 1 | CA | TAX | Tax ID | String | Generic Edit | 20 | 0 |
18 | F704001 | Payment WH Info TEMP - COMM - 04 | 20 | PT | TAX | Tax ID | String | Generic Edit | 20 | 0 |
19 | F704002 | Payment WH Info - COMM - 04 | 19 | PF | TAX | Tax ID | String | Generic Edit | 20 | 0 |
20 | F704002P | Payment WH Info Purge - COMM - 04 | 19 | PF | TAX | Tax ID | String | Generic Edit | 20 | 0 |
21 | F704003 | Payment Done - Accum - COMM - 04 | 7 | PD | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP74: EMEA Localization |
22 | F00900 | Year-End VAT Revision - Italy | 4 | IR | TAX | Tax ID | String | Generic Edit | 20 | 0 |
23 | F7400B1 | Belgium VAT Worktable | 2 | QA | TAX | Tax ID | String | Generic Edit | 20 | 0 |
24 | F7430031 | Legal Document Address (Print Info) - COMM - 03B | 19 | PI | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP74B: Begium Localization |
25 | F7403B11 | Belgium - Work File Yearly Vat Declaration Data | 7 | QA | TAX | Tax ID | String | Generic Edit | 20 | 0 |
26 | F74B200 | Yearly/Quarterly VAT Listing - Belgium | 6 | VT | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP74L: Portugal |
27 | F74LUI01 | Referential Account Details - Temp Table - 74L | 5 | TT | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP74R: Russia |
28 | F74RUI31 | VAT Sales Book Workfile - RUS - 03B | 17 | W1 | TAX | Tax ID | String | Generic Edit | 20 | 0 |
29 | F74RUI41 | VAT Purchase Book Workfile - RUS - 04 | 19 | W1 | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP74Y: Italy |
30 | F74Y015 | Yearly List Declaration - WF - IT - 00 | 10 | YL | TAX | Tax ID | String | Generic Edit | 20 | 0 |
31 | F74Y020 | Italy Intrastat Declarations - Header - ITA - 00 | 8 | IH | TAX | Tax ID | String | Generic Edit | 20 | 0 |
32 | F74Y021 | Italy Intrastat Declarations - Detail Sections - ITA - 00 | 14 | ID | TAX | Tax ID | String | Generic Edit | 20 | 0 |
33 | F74Y060 | Yearly List Summarized Workfile -ITA - 74Y | 11 | YS | TAX | Tax ID | String | Generic Edit | 20 | 0 |
34 | F74Y061 | Yearly List Detailed Workfile -ITA - 74Y | 12 | YD | TAX | Tax ID | String | Generic Edit | 20 | 0 |
35 | F74Y170 | Contracts - IT - 00 | 9 | CT | TAX | Tax ID | String | Generic Edit | 20 | 0 |
36 | F74Y171 | Contract Relations - IT - 00 | 13 | CR | TAX | Tax ID | String | Generic Edit | 20 | 0 |
37 | F74YUI01 | Italy Legal Company WF - ITA - 74Y | 2 | LC | TAX | Tax ID | String | Generic Edit | 20 | 0 |
38 | F74YUI10 | Italy Customer Detail WF - ITA - 74Y | 4 | CD | TAX | Tax ID | String | Generic Edit | 20 | 0 |
39 | F74YUI11 | Italy SupplierDetail WF - ITA - 74Y | 4 | SD | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP75A: Australia |
40 | F75A0220 | Payment Summary Workfile | 4 | PS | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP76A: Argentina |
41 | F760081A | SICORE Step 1 & 2 - ARG - 03B - 76A | 7 | V6 | TAX | Tax ID | String | Generic Edit | 20 | 0 |
42 | F76A0209 | Header & Footer Invoice/ShipmentNote History WF - ARG - 76A | 21 | HF | TAX | Tax ID | String | Generic Edit | 20 | 0 |
43 | F76A020P | Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A | 21 | HF | TAX | Tax ID | String | Generic Edit | 20 | 0 |
44 | F76A0440 | Check details RG 1547 - ARG - 04 - 76A | 5 | CD | TAX | Tax ID | String | Generic Edit | 20 | 0 |
45 | F76A09 | Invoice Total - ARG - 03B - 76A | 20 | TT | TAX | Tax ID | String | Generic Edit | 20 | 0 |
46 | F76A09P | Invoice Total Purge - ARG - 03B - 76A | 20 | TT | TAX | Tax ID | String | Generic Edit | 20 | 0 |
47 | F76A8001 | Generation SICORE's - Last Step -RG 738/99 - ARG - 04 - 76A | 17 | V2 | TAX | Tax ID | String | Generic Edit | 20 | 0 |
48 | F76A8002 | SICORE RG738 Withholding Entity - ARG - 04 - 76A | 1 | V3 | TAX | Tax ID | String | Generic Edit | 20 | 0 |
49 | F76A8011 | Supplier Information RG 726 - ARG - 04 - 76A | 2 | PA | TAX | Tax ID | String | Generic Edit | 20 | 0 |
50 | F76A8014 | CITI Report - ARG - 04 - 76A | 4 | CT | TAX | Tax ID | String | Generic Edit | 20 | 0 |
51 | F76A82 | A/P Payment Control Group File - ARG - 04 - 76A | 24 | C6 | TAX | Tax ID | String | Generic Edit | 20 | 0 |
52 | F76AUI20 | Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A | 21 | HF | TAX | Tax ID | String | Generic Edit | 20 | 0 |
53 | F76AUI50 | VAT Perception Support RG 715 WF - ARG - 04 - 76A | 2 | WF | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP76B: Brazil |
54 | F761BA | AS Fiscal file book - 09 | 26 | FB | TAX | Tax ID | String | Generic Edit | 20 | 0 |
55 | F76B0070 | FCI TXT File Process Header Blocks - BRA - 76B | 5 | HB | TAX | Tax ID | String | Generic Edit | 20 | 0 |
56 | F76B0403 | Service Taxes Paid Externally - 04 | 8 | ST | TAX | Tax ID | String | Generic Edit | 20 | 0 |
57 | F76B0411 | Voucher Additional Information Brazil - 04 | 27 | VB | TAX | Tax ID | String | Generic Edit | 20 | 0 |
58 | F76B050 | Address Book - SPED Project - WF - BRA - 76B | 4 | WA | TAX | Tax ID | String | Generic Edit | 20 | 0 |
59 | F76B051 | Item number - SPED Project - WF - BRA - 76B | 4 | WI | TAX | Tax ID | String | Generic Edit | 20 | 0 |
60 | F76B052 | Unit of measure - SPED Fiscal Brazilian WF - BRA - 76B | 4 | WU | TAX | Tax ID | String | Generic Edit | 20 | 0 |
61 | F76B053 | Transaction Nature - SPED Fiscal Brazilian WF - BRA - 76B | 4 | WT | TAX | Tax ID | String | Generic Edit | 20 | 0 |
62 | F76B054 | Messages Information - SPED Fiscal Brazilian WF - BRA - 76B | 4 | WM | TAX | Tax ID | String | Generic Edit | 20 | 0 |
63 | F76B055 | Cost Center - SPED Fiscal Brazilian WF - BRA - 76B | 4 | WC | TAX | Tax ID | String | Generic Edit | 20 | 0 |
64 | F76B056 | Account - SPED Fiscal Brazilian WF - BRA - 76B | 4 | WT | TAX | Tax ID | String | Generic Edit | 20 | 0 |
65 | F76B057 | Administrative Process - SPED Project - WF - BRA - 76B | 4 | WD | TAX | Tax ID | String | Generic Edit | 20 | 0 |
66 | F76B058 | Judicial Process- SPED Project - WF - BRA - 76B | 4 | WJ | TAX | Tax ID | String | Generic Edit | 20 | 0 |
67 | F76B060 | ePIS COFINS NF Worktable - BRA - 76B | 7 | NW | TAX | Tax ID | String | Generic Edit | 20 | 0 |
68 | F76B401 | DIRF WorkTable - BRA - 76B | 6 | DI | TAX | Tax ID | String | Generic Edit | 20 | 0 |
69 | F76B473T | F04573 Brazilian Temp WH File - BR - 04 | 31 | W3 | TAX | Tax ID | String | Generic Edit | 20 | 0 |
70 | F76B70 | Physical and Legal Person Table - IN68 - 42 | 5 | FJ | TAX | Tax ID | String | Generic Edit | 20 | 0 |
71 | F76B8601 | IN86-Work Table for Individuals and Legal Entities - 04 | 3 | FJ | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP76C: Colombia |
72 | F76CT2 | Sales/Use/V.A.T. Tax File - COL - 76C | 24 | CT | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP76H: Chile |
73 | F76H3B31 | Legal Document Header (Print Info) - CHI - 03B - 76H | 19 | PI | TAX | Tax ID | String | Generic Edit | 20 | 0 |
74 | F76HUI32 | Workfile for R76H3B40 - CHI - 42 - 76H | 15 | WF | TAX | Tax ID | String | Generic Edit | 20 | 0 |
TOP76V: Venezuela |
75 | F76VLO01 | Withholdings Temporal Table - VEN -04 - 76V | 7 | LO | TAX | Tax ID | String | Generic Edit | 20 | 0 |
76 | F76VTART | Temporal Table for Withholdings - VEN -04 - 76V | 2 | TR | TAX | Tax ID | String | Generic Edit | 20 | 0 |