| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP03: Accounts Receivable |
| 1 | F0311 | Accounts Receivable Ledger | 8 | RP | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 2 | F0312 | A/R Batch Cash Application | 18 | RU | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP04: Accounts Payable |
| 3 | F0411Z1 | Voucher Transactions - Batch Upload | 147 | VL | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 4 | F0411Z3 | F0411 Interoperability Table | 141 | SZ | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 5 | F0413 | Accounts Payable - Matching Document | 3 | RM | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 6 | F0413A | WF - 'As Of' Accounts Payable Payment Register | 3 | RM | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 7 | F0413P | Purge - Accounts Payable Matching Documents | 3 | RM | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 8 | F0413Z1 | F0413 Interoperability Table | 16 | SY | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 9 | F04572 | A/P Payment Processing - Summary | 9 | KK | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP05: Time Accounting and HRM Base |
| 10 | F0607 | Wage Attachment Ledger File | 5 | JI | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP05A: PeopleSoft HR & PR Foundation |
| 11 | F06345 | Historical Payroll Register | 20 | JL | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP05T: Time Entry |
| 12 | F06116Z1 | Employee Transactions - Batch File | 189 | VL | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 13 | F06116Z2 | ESS Timecard History | 189 | VM | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP07: Payroll |
| 14 | F06053 | Interim Check Parameters File | 2 | YW | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 15 | F06156 | Pay Check History Summary | 2 | YU | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 16 | F06166 | Pay Check History Tax Ledger | 2 | YV | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 17 | F06166A | Tax Ledger (Additional) | 12 | YV | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 18 | F06270 | Retro Processing Parameter | 15 | JP | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 19 | F06350I | WF - Paycheck (Interims) | 10 | Y4 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 20 | F06560 | Bank Reconciliation - Issue File | 2 | Y8 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 21 | F06561 | Bank Reconciliation - Paid File | 2 | Y9 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 22 | F07350 | Payment File | 43 | Y0 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 23 | F07351 | Payment Distribution File | 10 | Y1 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 24 | F07355 | Pre-Payroll Error File | 30 | Y5 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 25 | F07991 | Deduction, Benefit, Accrual History Conversion Data | 2 | YX | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 26 | F07992 | Payroll Tax History Conversion Data | 3 | YQ | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP08B: Benefits Administration |
| 27 | F08371 | Reimbursement Spending Account Claims File | 20 | B6 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP08U: PeopleSoft HR US |
| 28 | F08360 | Nondiscrimination Groups | 26 | HE | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP09: General Accounting |
| 29 | F0917 | Bank Statement Detail | 28 | GD | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 30 | F09617 | Auto Bank Statement Detail | 31 | GM | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP17C: Call Management |
| 31 | F1755 | Case Master | 87 | ZA | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP42: Sales Management |
| 32 | F42005 | Sales Commission File | 4 | SC | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 33 | F42UI005 | Sales Commission File | 4 | SC | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP43: Procurement |
| 34 | F44445Z | Subcontractor Waiver | 3 | SW | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP45: Advanced Pricing |
| 35 | F4576 | Ship and Debit Claims | 40 | AC | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 36 | F4576TMP | Ship and Debit Claims- Temp Table | 40 | AC | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 37 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 53 | Z1 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP47: Electronic Commerce |
| 38 | F47056 | EDI Payment Order Header - Outbound | 20 | D1 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 39 | F470561 | EDI Payment Order Bank N & A - Outbound | 15 | D2 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 40 | F470561W | EDI Payment Order Bank N & A - Work | 17 | D2 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 41 | F470562 | EDI Payment Order Vendor N & A - Outbound | 14 | D4 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 42 | F470562W | EDI Payment Order Vendor N & A - Work | 14 | D4 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 43 | F470563 | EDI Payment Order Payee N & A - Outbound | 14 | D5 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 44 | F470563W | EDI Payment Order Payee N & A - Work | 14 | D5 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 45 | F47056W | EDI Payment Order Header - Work | 20 | D1 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 46 | F47057 | EDI Payment Order Remittance Advice - Outbound | 20 | D3 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 47 | F47057W | EDI Payment Order Remittance Advice - Work | 20 | D3 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 48 | F47113 | EDI Lockbox/Payment Detail - Batch | 11 | Z3 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 49 | F47114 | EDI Lockbox/Payment Detail - Payment | 12 | Z4 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP48S: Service Billing |
| 50 | F4812 | Billing Detail Workfile | 57 | WD | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 51 | F4812H | Billing Workfile History | 57 | WD | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 52 | F4812HS | Billing Workfile History Purged Save | 57 | WD | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 53 | F48SUI01 | Billing Detail Print Workfile | 57 | WD | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP49: Transportation Management |
| 54 | F49595 | Document Print - Document Summary | 20 | DK | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 55 | F49695 | Document Register | 18 | DR | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP53: Change Management |
| 56 | F5302 | F5302 World Specs | 44 | DK | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 57 | F5311 | Change Request Details Table | 121 | DK | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 58 | F5311Z1 | Change Request Details Table Workfile | 126 | DK | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP70: Multi-National Products |
| 59 | F704001 | Payment WH Info TEMP - COMM - 04 | 5 | PT | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 60 | F704002 | Payment WH Info - COMM - 04 | 4 | PF | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 61 | F704002P | Payment WH Info Purge - COMM - 04 | 4 | PF | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP74S: Spain |
| 62 | F74S55 | Expenses and Exchange Rate for Payments - Spain - 04 | 3 | Q5 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP75A: Australia |
| 63 | F75A0201 | Recipient Created Tax Invoice Tag File | 7 | TF | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 64 | F75A0220 | Payment Summary Workfile | 2 | PS | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP75J: Japan |
| 65 | F750411 | Withholding Tax Detail - Japan - 04 | 13 | JX | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP76A: Argentina |
| 66 | F760499A | Contract Withholding - Advances - ARG -04 - 76A | 7 | K8 | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 67 | F76A09 | Invoice Total - ARG - 03B - 76A | 5 | TT | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 68 | F76A09P | Invoice Total Purge - ARG - 03B - 76A | 5 | TT | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 69 | F76A19 | Taxes - Tax Amounts by Invoice Suffix - ARG - 03B - 76A | 6 | TI | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 70 | F76A19P | Taxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A | 6 | TI | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 71 | F76A19Z1 | Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A | 24 | VK | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 72 | F76A24 | Credit Invoice Information - Accounts Payable - ARG - - 76A | 18 | IE | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 73 | F76AUI24 | Taxes Work File - ARG - 03B - 76A | 6 | TI | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP76C: Colombia |
| 74 | F76CUI02 | Tax Detail - Work File - COL - 76C | 7 | TD | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP76M: Mexico |
| 75 | F76M0414 | F0414 - Payment Detail Tag File - Mexico | 4 | RT | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 76 | F76M413 | Manual Payment Header Additional Details - MEX - 04 | 5 | MW | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| 77 | F76M572 | A/P Header Withholding Summary Details - MEX - 04 | 6 | WS | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP77: Payroll (Canadian) |
| 78 | F0716 | Pay Check History Tax Ledger - Canadian DB | 2 | YV | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
| TOP89: Conversion Programs |
| 79 | F42005A | Sales Commission File - Temporary | 4 | SC | DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 |
