| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0018 | Taxes | 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 | 23 | 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 |
| TOP70: Multi-National Products |
| 18 | F702018 | Taxes by Sales Order Line - COMM - 42 | 8 | TA | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 19 | F704100 | Suspended VAT AP - COMM - 70 | 23 | VA | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| TOP74: EMEA Localization |
| 20 | F74093 | Worktable for Printing IVA Summary - Italy | 30 | HC | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 21 | F7420018 | Taxes by Sales Order Line - COMM - 42 | 6 | ST | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 22 | F7430018 | Taxes by A/R Invoice Line - COMM - 03B | 6 | TI | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 23 | F7430035 | Taxes by Legal Document Line - COMM - 03B | 7 | PI | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 24 | F743035 | Display Taxes by Legal Document Line - COMM - 03B | 9 | DT | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| TOP74H: Hungary |
| 25 | F74H1004 | VAT Declaration Detail - HUN -04 | 10 | VD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| TOP74L: Portugal |
| 26 | F74L3035 | Tax Details by Legal Document - POR - 74L | 11 | TD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 27 | F74LUI03 | Tax Details - Temp Table - 74L | 5 | TT | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| TOP74R: Russia |
| 28 | F74R0018 | Russian Tax File - 74R | 24 | TD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| TOP74Y: Italy |
| 29 | F74Y171 | Contract Relations - IT - 00 | 12 | CR | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| TOP74Z: Czech Republic |
| 30 | F74ZUI02 | Czech VAT Report - CZE - 74Z - Work File | 3 | CZ | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| TOP75T: Taiwan |
| 31 | F75T004 | GUI/VAT Transaction Header - 75T | 18 | TH | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 32 | F75T0049 | GUI/VAT Transaction Header History - 75T | 18 | TH | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 33 | F75T004P | GUI/VAT Transaction Header POS - 75T | 17 | TH | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 34 | F75T004Z | GUI/VAT Transaction Header - Work - 75T | 16 | ZH | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| TOP76A: Argentina |
| 35 | F76A13 | Taxes - Tax Values - ARG - 00 - 76A | 8 | TV | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 36 | F76A18 | Taxes - Tax Amounts by Sales Order Line - ARG - 03B - 76A | 16 | TO | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 37 | F76A18P | Taxes - Tax Amounts by Sales Order Line Purge - ARG - - 76A | 16 | TO | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 38 | F76A19 | Taxes - Tax Amounts by Invoice Suffix - ARG - 03B - 76A | 14 | TI | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 39 | F76A19P | Taxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A | 14 | TI | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 40 | F76A19Z1 | Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A | 32 | VK | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 41 | F76A8050 | Perceptions Exempt Percentages - ARG - 03B - 76A | 5 | PP | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 42 | F76A8230 | Percentages by state / agreement Gross Income - ARG - - 76A | 6 | C1 | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 43 | F76AUI18 | Taxes - Tax amount by order line - Work File - ARG - - 76A | 10 | WF | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 44 | F76AUI24 | Taxes Work File - ARG - 03B - 76A | 14 | TI | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 45 | 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 |
| 46 | F7603B1 | A/R Additional Information - Brazil - 03B | 6 | CI | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 47 | F7603B1P | Archive A/R Additional Information - Brazil - 03B | 6 | BP | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 48 | F7608B | ICMS Tax Rates - 40 | 4 | TB | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 49 | F7611B | Nota Fiscal Detail - BRA - 42 | 66 | FD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 50 | F761BA | AS Fiscal file book - 09 | 65 | FB | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 51 | F76B1001 | Tag File F7601B Nota Fiscal Header - BRA - 76B | 7 | TH | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 52 | F76B1010 | Tag File F7611B Nota Fiscal Detail - BRA - 76B | 10 | TD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 53 | F76B18 | IPI Taxes - 40 | 6 | FC | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| TOP76C: Colombia |
| 54 | F76CI1 | Tax Parameters - COL - 76C | 11 | PI | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 55 | F76CI2 | Economic Activity - COL - 76C | 7 | AE | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 56 | F76CT2 | Sales/Use/V.A.T. Tax File - COL - 76C | 19 | CT | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 57 | F76CUI02 | Tax Detail - Work File - COL - 76C | 30 | TD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 58 | F76CUI04 | Tax Detail for Distribution - Work File - COL - 76C | 31 | TD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| TOP76E: Ecuador |
| 59 | F76E4020 | Withholding Certificate Information w/ SRI - EC - 04 | 10 | CR | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| TOP76H: Chile |
| 60 | F76H218 | Taxes by Sales Order Line - CHI - 42 - 76H | 15 | TD | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| TOP76V: Venezuela |
| 61 | F76VLC01 | Purchase Register Temporal - VEN -04 - 76V | 4 | LC | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 62 | F76VLO01 | Withholdings Temporal Table - VEN -04 - 76V | 18 | LO | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 63 | F76VLV01 | Temporal Table for VAT Type - R76VLV01 - VEN -03B - 76V | 2 | IM | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
| 64 | F76VLV03 | Temporal Table for VAT Type - R76VLV02 - VEN -03B - 76V | 2 | IA | TXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 |
