| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F4008 | Tax Areas | 13 | TA | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
2 | F744008 | Tax areas - Tag Table EMEA - Spain / Italy | 3 | TA | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
TOP42: Sales Management |
3 | F4020 | Freight/Additional Charges Rate Information | 14 | AR | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
TOP74: EMEA Localization |
4 | F7430030 | Legal Document Header (Print Info) - COMM - 03B | 7 | PI | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
TOP74S: Spain |
5 | F74S408 | Tax Areas - 340 Model - ESP - 00 | 3 | TA | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
TOP75T: Taiwan |
6 | F75T1113 | Taiwan Exchange Rate Update | 7 | TR | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
TOP76A: Argentina |
7 | F760401A | Gross Income Withholding Percentage - ARG - 04 - 76A | 6 | K2 | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
8 | F760402A | V.A.T. withholding percentage - ARG - 04 - 76A | 4 | K1 | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
9 | F760403A | Profit Withholding Percentage - ARG - 04 - 76A | 3 | K3 | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
10 | F760404A | Profit Withholding Percentage - 4th.Category - ARG - - 76A | 3 | K5 | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
11 | F760405A | Contract Withholding Percentage - ARG - 04 - 76A | 4 | K7 | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
12 | F760410A | Eventual Services Withholding Percentage - ARG - 04 - 76A | 5 | K0 | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
13 | F7607A | Withholding Exempt Percentage - ARG - 04 - 04 - 76A | 5 | V4 | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
14 | F764008A | Aditionals Tax Areas - ARG - 04 - 76A | 3 | TQ | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
15 | F76A003 | A/P Tag File - CAI Storage - ARG - 04 - 76A | 6 | RG | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
16 | F76A0209 | Header & Footer Invoice/ShipmentNote History WF - ARG - 76A | 16 | HF | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
17 | F76A020P | Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A | 16 | HF | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
18 | F76A0219 | Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A | 25 | DL | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
19 | F76A021P | Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A | 25 | DL | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
20 | F76A043 | A/P Tag Table - CAI Storage - ARG - 04 - 76A | 6 | RG | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
21 | F76A10 | Taxes - Tax Definition - ARG - 00 - 76A | 15 | TD | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
22 | F76A12 | Taxes - Minimum Tax By Date - ARG - 00 - 76A | 3 | TM | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
23 | F76A13 | Taxes - Tax Values - ARG - 00 - 76A | 7 | TV | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
24 | F76A15 | Taxes - Effective and Expiration Dates - ARG - 00 - 76A | 5 | TE | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
25 | F76A8020 | Gross Income Exempt Percentage - ARG - 04 - 76A | 6 | EP | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
26 | F76A8030 | Taxes - Minimun Tax By Invoice - ARG - 03B - 76A | 3 | MT | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
27 | F76A8050 | Perceptions Exempt Percentages - ARG - 03B - 76A | 4 | PP | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
28 | F76A8090 | V.A.T. Witholding Percentage Rg726 - ARG - 04 - 76A | 6 | VP | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
29 | F76A8230 | Percentages by state / agreement Gross Income - ARG - - 76A | 5 | C1 | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
30 | F76AUI20 | Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A | 16 | HF | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
31 | F76AUI21 | Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A | 25 | DL | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
TOP76B: Brazil - Reporting System Only |
32 | F76B409 | Taxes Setup by City and Service - BR - 04 | 6 | CS | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
TOP76C: Colombia |
33 | F76C0101 | A/B Tag File - COL - 76C | 7 | V0 | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
34 | F76C4008 | Additionals Tax Areas - COL - 04 | 3 | TA | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
35 | F76CI1 | Tax Parameters - COL - 76C | 5 | PI | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
36 | F76CI2 | Economic Activity - COL - 76C | 4 | AE | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
37 | F76CI3 | Tax Areas Tag File - COL - 76C | 2 | TA | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
TOP76H: Chile |
38 | F76H020 | Tax rate columns reports set up - CHI - 00 - 76H | 3 | NO | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
39 | F76H3B31 | Legal Document Header (Print Info) - CHI - 03B - 76H | 5 | PI | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
TOP76P: Peru |
40 | F76P405 | IGV Withholding Percentage - PER - 04 - 76P | 4 | IG | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
41 | F76P410 | SPOT Withholdings Percentage - PER - 04 - 76P | 4 | SP | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
TOP76V: Venezuela |
42 | F76V4020 | ISLR Withholdings Setup - VEN - 04 | 7 | WS | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
43 | F76V4025 | IM Withholdings Setup - VEN - 04 | 6 | WS | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |
44 | F76V4030 | VAT Withholdings Setup - VEN - 04 | 4 | VW | EFDJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 |