| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0018 | Sales/Use/V.A.T. Tax File | 31 | TD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
2 | F0028 | Sales Tax Work File by Taxing Authority | 2 | TE | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
3 | F0029 | Sales Tax Work File by Taxing Authority and Document | 2 | TF | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
4 | F4008 | Tax Areas | 4 | TA | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP04: Accounts Payable |
5 | F09UI006 | Tax (F0018) Replica | 31 | TD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP09E: Expense Reimbursment |
6 | F20112 | Expense Report Detail | 38 | ED | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP40: Inventory/OP Base |
7 | F40UI00T | Tax Work File | 8 | PN | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP42: Sales Management |
8 | F42565 | Invoice Print File | 51 | IW | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP43E: Requisition Self Service |
9 | F43E20 | Shopping Cart Detail | 23 | SC | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
10 | F43E20WF | eReq - Shopping Cart Work File | 24 | SW | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP47: Electronic Commerce |
11 | F470161 | EDI Purchase Order Additional Header - Outbound | 24 | S3 | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
12 | F470171 | EDI Purchase Order Additional Detail - Outbound | 21 | S4 | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
13 | F470461 | EDI Invoice Additional Header - Outbound | 26 | S3 | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
14 | F470471 | EDI Invoice Additional Detail - Outbound | 24 | S4 | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
15 | F470473 | EDI Invoice Detail Charges | 24 | S7 | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
16 | F471061 | EDI Response to RFQ Additional Header - Outbound | 26 | S3 | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
17 | F471071 | EDI Response to RFQ Additional Detail - Outbound | 24 | S4 | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP55: Reserved for Clients |
18 | F74H1051 | Invoicing Workfile - New | 29 | IW | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP74: EMEA Localization |
19 | F74093 | Workfile for Printing IVA Summary - Italy | 30 | HC | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
20 | F7420018 | Taxes by Sales Order Line - COMM - 42 | 6 | ST | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
21 | F7430018 | Taxes by A/R Invoice Line - COMM - 03B | 6 | TI | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
22 | F7430035 | Taxes by Legal Document Line - COMM - 03B | 7 | PI | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP74H: Hungary |
23 | F74H1004 | VAT Declaration Detail | 10 | VD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP74R: CIS |
24 | F74R0018 | Russian Tax File - 74R | 24 | TD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP75T: Taiwan |
25 | F75T004 | GUI/VAT Transaction Header - 75T | 16 | TH | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
26 | F75T0049 | GUI/VAT Transaction Header History - 75T | 16 | TH | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
27 | F75T004P | GUI/VAT Transaction Header POS - 75T | 16 | TH | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
28 | F75T004Z | GUI/VAT Transaction Header - Work - 75T | 14 | ZH | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP76A: Argentina |
29 | F76A13 | Taxes - Tax Values - ARG - 00 | 8 | TV | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
30 | F76A18 | Taxes - Tax Amounts by Sales Order Line - ARG - 00 | 16 | TO | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
31 | F76A18P | Taxes - Tax Amounts by Sales Order Line Purge - ARG - - 76A | 16 | TO | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
32 | F76A19 | Taxes - Tax Amounts by Invoice Suffix AGR | 14 | TI | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
33 | F76A19P | Taxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A | 14 | TI | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
34 | F76A19Z1 | Taxes - Tax Amounts by Invoice Suffix - Batch Entry A - 03B | 32 | VK | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
35 | F76A8050 | Perceptions Exempt Percentages - 03B | 5 | PP | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
36 | F76A8230 | Percentages by state / agreement Gross Income - ARG - - 76A | 6 | C1 | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
37 | F76AUI18 | Taxes - Tax amount by order line - Work File - ARG - 42 | 10 | WF | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
38 | F76AUI24 | Taxes Work File - ARG - 00 | 14 | TI | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
39 | F76AUI89 | Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A | 24 | WF | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP76B: Brazil - Reporting System Only |
40 | F7603B1 | A/R Additional Information - Brazil | 6 | CI | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
41 | F7603B1P | Archive A/R Additional Information - Brazil - 03B | 6 | BP | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
42 | F7608B | ICMS Tax Rates | 4 | TB | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
43 | F7611B | Nota Fiscal Detail - Brazil | 66 | FD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
44 | F761BA | AS Fiscal file book | 65 | FB | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
45 | F76B18 | IPI Taxes | 6 | FC | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP76C: Colombia |
46 | F76CI1 | Tax Parameters - COL - 76C | 11 | PI | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
47 | F76CI2 | Economic Activity - COL - 76C | 7 | AE | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
48 | F76CT2 | Sales/Use/V.A.T. Tax File - COL - 76C | 19 | CT | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
49 | F76CUI02 | Tax Detail - Work File - COL - 76C | 30 | TD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
50 | F76CUI04 | Tax Detail for Distribution - Work File - COL - 76C | 31 | TD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP76E: Ecuador |
51 | F76E4020 | Withholding Certificate Information w/ SRI - EC - 04 | 10 | CR | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP76H: Chile |
52 | F76H218 | Taxes by Sales Order Line - CHI - 42 - 76H | 15 | TD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
TOP76V: Venezuela |
53 | F76VLC01 | Purchase Register Temporal - VEN -04 - 76V | 4 | LC | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
54 | F76VLO01 | Withholdings Temporal Table - VEN -04 - 76V | 18 | LO | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
55 | F76VLV01 | Temporal Table for VAT Type - R76VLV01 - VEN -03B - 76V | 2 | IM | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
56 | F76VLV03 | Temporal Table for VAT Type - R76VLV02 - VEN -03B - 76V | 2 | IA | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |