| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0911 | Account Ledger | 99 | GL | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 2 | F03B11 | Customer Ledger | 116 | RP | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 3 | F03B11P | Customer Ledger Purge File | 116 | RP | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 4 | F03B11Z2 | F03B11 Interoperability Table | 129 | SY | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 5 | F03B13 | Receipts Header | 1 | RY | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 6 | F03B13P | Receipts Header Purge File | 1 | RY | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 7 | F03B13Z1 | Electronic Receipts Input | 14 | RU | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 8 | F03B13Z2 | F03B13 Interoperability Table | 14 | SY | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 9 | F03B14 | Receipts Detail | 1 | RZ | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 10 | F03B14P | Receipts Detail Purge File | 1 | RZ | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 11 | F03B14Z2 | F03B14 Interoperability Table | 14 | SZ | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 12 | F03B40 | A/R Deduction Management | 22 | RB | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 13 | F03B575 | Auto Debit Invoice Select and Build | 125 | RD | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 14 | F03B672 | Draft Remittance | 4 | RD | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 15 | F09UI011 | Receipt Prepost Work File | 37 | GL | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 16 | F74W300 | A/R Fee Journal History Detail Tag File | 3 | RU | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP04: Accounts Payable |
| 17 | F0413 | Accounts Payable - Matching Document | 1 | RM | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 18 | F0413A | WF - As Of Accounts Payable Payment Register | 1 | RM | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 19 | F0413P | Purge - Accounts Payable Matching Documents | 1 | RM | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 20 | F0413Z1 | F0413 Interoperability Table | 14 | SY | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 21 | F0414 | Accounts Payable Matching Document Detail | 1 | RN | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 22 | F0414A | WF - As Of Accounts Payable Payment Detail | 1 | RN | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 23 | F0414P | Purge - Accounts Payable Matching Document Detail | 1 | RN | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 24 | F0414Z1 | F0414 Interoperability Table | 14 | SZ | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 25 | F09UI005 | Tax Offsets User Index | 21 | GL | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP09: General Accounting |
| 26 | F0911P | Purge - Account Ledger | 99 | GL | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 27 | F0911Z1 | Journal Entry Transactions - Batch File | 116 | VN | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 28 | F0911Z4 | F0911 Interoperability Table | 120 | SZ | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 29 | F0917 | Bank Statement Detail | 51 | GD | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 30 | F09617 | Auto Bank Statement Detail | 45 | GM | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 31 | F09UI015 | Indexed Computations Multi-Tiered Entries | 98 | GL | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP47: Electronic Commerce |
| 32 | F47057 | EDI Payment Order Remittance Advice - Outbound | 105 | D3 | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 33 | F47057W | EDI Payment Order Remittance Advice - Work | 105 | D3 | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP55: Reserved for Clients |
| 34 | F74T101 | Check History Table | 1 | CH | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 35 | F74T205 | Checks Collected | 11 | CC | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 36 | F74T531 | Customer Ledger Tranaction File | 21 | CT | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 37 | F74T532 | Supplier Ledger Transaction File | 21 | SL | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 38 | F74T100 | Check Additional Table | 1 | CA | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 39 | F74T100W | Endorsment Temp Table | 2 | MK | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP70: Multi-National Products - obsolete-do not reuse |
| 40 | F704002 | Payment WH Info - COMM - 04 | 2 | PF | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 41 | F704002P | Payment WH Info Purge - COMM - 04 | 2 | PF | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP74: EMEA Localization |
| 42 | F7400006 | Processed Documents in Legal Applications - COMM - 00 | 5 | PD | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 43 | F740018O | Original Transaction Detail for Data Extraction | 23 | OT | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 44 | F7400C2A | French VAT on A/R | 1 | FC | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 45 | F7400C3 | French VAT on A/P | 1 | TG | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP74P: Poland |
| 46 | F74P03BW | A/R Trial Balance - POL - 03B - 74P | 18 | P3 | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 47 | F74P04W | A/P Trial Balance Work Table - POL - 04 - 74P | 17 | P2 | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 48 | F74P9100 | Cash Desk Transaction - POL - 74P | 15 | CD | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP74R: CIS |
| 49 | F74R0018 | Russian Tax File - 74R | 65 | TD | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 50 | F74R0100 | Petty Cash Transactions - RUS - 00 - 74R | 16 | PC | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 51 | F74R311 | Prepayment Detail Tax File - RUS - 03B | 6 | DE | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 52 | F74R3B14 | F03B14 Tag File - RUS - 03B - 74R | 1 | TF | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 53 | F74R4014 | F0414 Tag File - RUS - 04 - 74R | 1 | TF | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP74U: United Kingdom Localizations |
| 54 | F74U0445 | SPC Accounts Payable Match Doc Detail Tag File - UK - 43 | 1 | RN | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP74Y: Italy - Reporting System Only |
| 55 | F743B14I | Suspended IVA Generation - Receipt/Rebate Control-Ita - 03B | 1 | TI | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP75A: Australia - Reporting System Only |
| 56 | F75A0202 | GST - RCTI Adjustment Print Control Table | 7 | RA | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 57 | F75A200 | GST - Tax Invoice / Adjustment Note Tag file | 1 | TF | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP75I: India |
| 58 | F75I611 | TCS Prepayment Transaction File - IND-03B | 5 | TT | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 59 | F75I732 | Service Tax A/R File Additional Info - IND - 03B | 6 | ST | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 60 | F75I734 | Service Tax Received File - IND - 03B | 1 | PF | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 61 | F75I742 | Service Tax A/P File Additional Info - IND - 04 | 7 | ST | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 62 | F75I744 | Service Tax Payment File - IND - 04 | 1 | PF | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 63 | F75I754 | Advance Service Tax Payment File - IND -04 | 1 | AP | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 64 | F75IUI7 | Service Tax Credit Register - Work File - IND | 1 | WF | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP75J: Japan - Reporting System Only |
| 65 | F750411 | Withholding Tax Detail - Japan - 04 | 11 | JX | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP76A: Argentina |
| 66 | F760414A | A/P Payment Detail Tag Table - ARG - 04 - 76A | 1 | V1 | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 67 | F76A0440 | Check details RG 1547 - ARG - 04 - 76A | 1 | CD | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 68 | F76A414P | Purge - A/P Payment Detail - ARG - 04 - 76A | 1 | V1 | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 69 | F76A48 | CERG A/P - Control Payments -ARG - 04 - 76A | 1 | PI | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 70 | F76A49 | CERG A/R - Control Receipts - ARG - 03B - 76A | 1 | CR | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 71 | F76A60 | Receipts Header Argentine Tag File - 03B - 76A | 1 | BY | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 72 | F76A60Z1 | Receipt Header Argentine Tag File Batch Input - ARG - - 76A | 6 | TF | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 73 | F76A82 | A/P Payment Control Group File - ARG - 04 - 76A | 1 | C6 | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 74 | F76A8500 | Tag File F03B14 - ARG - 03B - 76A | 1 | TF | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 75 | F76A8510 | Tag File F76A60 - ARG - 03B - 76A | 1 | TF | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 76 | F76A85Z1 | Tag File F76A60 Batch Entry - ARG - 03B - 76A | 6 | BE | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 77 | F76AUI82 | Draft - Drafts Work File - ARG - 03B - 03B | 3 | WF | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 78 | F76AUI83 | Draft - Application Drafts - Invoices Work File - ARG - 76A | 3 | WF | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP76B: Brazil - Reporting System Only |
| 79 | F76B8602 | IN86-Work Table for Suppliers and Customers - 04 | 20 | PR | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP76C: Colombia |
| 80 | F76C0003 | VAT Certificates Retention - COL - 76C | 13 | CR | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 81 | F76C034A | A/R Check Detail file As Of - COL - 03B | 1 | RZ | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 82 | F76C4F01 | DIAN Formats File by Payment - COL - 04 | 2 | FP | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP76H: Chile |
| 83 | F76H402 | Chilean A/P Doc Lines Print Mark - CHI - 04 - 76H | 1 | LP | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP76M: Mexico |
| 84 | F76M0314 | Receipt Detail Tag File - Mexico | 1 | MA | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 85 | F76M0414 | F0414 - Payment Detail Tag File - Mexico | 1 | RT | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 86 | F76M413 | Manual Payment Header Additional Details - MEX - 04 | 1 | MW | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 87 | F76M413A | Withholding Certificate Information - MEX - 04 | 1 | WC | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 88 | F76M414 | A/P Matching Detail Withholding Information - MEX - 04 | 1 | MW | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 89 | F76M930 | AR VAT on Gain/loss MEX - 76M | 1 | AP | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 90 | F76M940 | AP VAT on Gain/loss - MEX - 76M | 1 | AP | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| 91 | F76M990 | GL VAT on Gain/loss MEX - 76M | 18 | GL | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP76P: Peru |
| 92 | F76P414T | F0414 Tag File - PER - 04 - 76P | 1 | P4 | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP76V: Venezuela |
| 93 | F76VLV02 | Temporal for receipts from F03B14 - VEN - 03B - 76V | 1 | CO | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
| TOP89: Conversion Programs |
| 94 | F0917S | Needed for upgrade for XE and below | 5 | GD | PYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 |
