| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0000194 | Generic Interface Table for B0000194 | 1 | SY | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 2 | F0006DZ1 | Business Unit Alternate Description Z file | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 3 | F0006Z1 | Cost Center Unedited Transaction Table | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 4 | F0006Z2 | Business Unit Master Z File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 5 | F0010Z | Company Constants Z File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 6 | F0046 | Processing Log | 1 | PL | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 7 | F0401Z1 | Supplier Master - Batch Upload | 1 | VO | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP01: Address Book |
| 8 | F0101Z2 | Address Book - Interoperability | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 9 | F01112Z1 | Batch - Related Person | 1 | PB | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 10 | F0111Z1 | Batch Who's Who Information | 1 | BW | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 11 | F01151Z1 | Batch - Electronic Address | 1 | EB | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 12 | F0115Z1 | Phones - Interoperability | 1 | PI | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 13 | F01161Z1 | Batch - Alternative Address | 1 | LB | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP03: Accounts Receivable |
| 14 | F03012Z1 | Customer Master LOB-Batch Table | 1 | VO | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 15 | F03B11Z1 | Batch Invoices | 1 | VJ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 16 | F03B11Z2 | F03B11 Interoperability Table | 1 | SY | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 17 | F03B13Z1 | Electronic Receipts Input | 1 | RU | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 18 | F03B13Z2 | F03B13 Interoperability Table | 1 | SY | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 19 | F03B14Z2 | F03B14 Interoperability Table | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 20 | F03B41Z1 | Inteoperability - Deductions Management | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP04: Accounts Payable |
| 21 | F0401Z1T | Supplier Master - Voucher Match Automation Tag File | 1 | VT | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 22 | F0411Z1 | Voucher Transactions - Batch Upload | 1 | VL | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 23 | F0411Z1T | Voucher Transactions Batch Upload - Voucher Match Automation | 1 | VT | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 24 | F0411Z3 | F0411 Interoperability Table | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 25 | F0413Z1 | F0413 Interoperability Table | 1 | SY | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 26 | F0414Z1 | F0414 Interoperability Table | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP05: Time Accounting and HRM Base |
| 27 | F05100Z1 | Resource Competencies Unedited Transactions File | 1 | CU | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP05A: PeopleSoft HR & PR Foundation |
| 28 | F060116Z | Unedited Quick Hire Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP05T: Time Entry |
| 29 | F06116Z1 | Employee Transactions - Batch File | 1 | VL | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 30 | F06116Z2 | ESS Timecard History | 1 | VM | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP09: General Accounting |
| 31 | F0902Z1 | Account Balances - Batch File | 8 | GB | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 32 | F0911Z1 | Journal Entry Transactions - Batch File | 1 | VN | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 33 | F0911Z4 | F0911 Interoperability Table | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP10: Financial Reporting |
| 34 | F1001 | Multi-Site Consolidation Transfer File Header | 2 | GP | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 35 | F1001Z1 | Unedited MSC Interoperability Header Table | 1 | IA | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 36 | F1002 | Multi-Site Consolidation Transfer File | 2 | GQ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 37 | F1002Z1 | Unedited MSC Interoperability Table | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 38 | F1003 | Multi-Site Consolidation Transfer File - Category Codes | 2 | GR | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 39 | F10UI002 | Dynamically Created Business Units | 1 | BU | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 40 | F10UI003 | Dynamically Created Accounts | 1 | AC | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 41 | F10UI006 | MSC - F1002 Elimination Work File | 1 | GE | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP11: Multi Currency |
| 42 | F0015Z1 | External Currency Exchange Rates | 1 | ZE | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP12: Fixed Assets |
| 43 | F1201Z1 | Unedited Asset Master Transactions | 1 | FA | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 44 | F1217Z1 | Unedited Equipment Tag Transactions | 1 | WR | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 45 | F1217Z2 | Unedited Equipment Tag Transactions | 1 | WR | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP13: Plant/Equipment Management |
| 46 | F12120Z1 | Unedited Meter Reading Transactions | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP13C: Condition-Base Maintenance |
| 47 | F1310Z1 | Unedited Condition-Based Alerts | 1 | CB | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP16: Profit Management (EPS) |
| 48 | F1602Z1 | External Cost Analyzer Balances - Interoperability Table | 1 | CZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 49 | F1632Z1 | External Driver Balances-Interoperability Table | 1 | CY | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP17: Customer Service Management |
| 50 | F3111Z2 | Warranty Claim/Supplier Recovery processing | 1 | WP | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 51 | F3112Z2 | Warranty Claim/Supplier Recovery processing | 1 | WL | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 52 | F4801TZ2 | Warranty Claim/Supplier Recovery processing | 1 | WQ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 53 | F4801Z2 | Warranty Claim/Supplier Recovery processing | 1 | WS | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP30: Product Data Management |
| 54 | F0007Z1 | Work Day Calendar Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 55 | F30006Z1 | Work Center Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 56 | F3002Z1 | Bill of Material Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 57 | F3003Z1 | Routing Transactions File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP31: Shop Floor Control |
| 58 | F30161Z1 | Inbound Kanban Card Detail | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 59 | F3111Z1 | Outbound Work Order Parts List | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 60 | F31122Z1 | Work Order Time Transactions Unedited Transaction Table | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 61 | F3112Z1 | Outbound Work Order Routings | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 62 | F3112Z1T | Outbound Work Order Routings Tag Table - Needed for upgrade | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP31B: Blend Management |
| 63 | F31B17Z1 | Operation EUR Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 64 | F31B18Z1 | VBT Barrel Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 65 | F31B19Z1 | Instructed Attributes Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 66 | F31B31Z1 | Operations Composition Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 67 | F31B34Z1 | Operations Style Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 68 | F31B3CZ1 | Operations Cost Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 69 | F31B52Z1 | Operations Equipment Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 70 | F31B53Z1 | Operations Consumables Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 71 | F31B65Z1 | Operations Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 72 | F31B93Z1 | WIM Work Order Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 73 | F31B97Z1 | Operations Resource Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 74 | F31BQAZ1 | Operations Quality Test Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 75 | F31BSPZ1 | Sample Transactions | 1 | ST | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP31P: Engineer To Order |
| 76 | F4801Z11 | Outbound Work Order ETO Tag File | 6 | SY | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP36: Forecasting |
| 77 | F3460Z1 | Forecast Unedited Transactions | 1 | FT | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP37: Quality Management |
| 78 | F3711Z1 | Test Results Unedited Transaction Table | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP40: Inventory/OP Base |
| 79 | F4106NC | Base Price Extraction | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 80 | F4201Z1 | Sales Order Header Unedited Transaction File | 1 | SY | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 81 | F4211Z1 | Sales Order Detail Unedited Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 82 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 1 | S1 | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP41: Inventory Management |
| 83 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 84 | F4101Z1A | F4101 Detail Item Master Unedited Transaction | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 85 | F41021Z1 | Item Location Unedited Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 86 | F4105Z1 | Unedited Transaction Table - Item Cost | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 87 | F4141Z1 | F4141 Cycle Count Unedited Transaction Table | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP42: Sales Management |
| 88 | F4201Z1T | Sales Order Header Unedited Tax Transaction File | 1 | HY | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 89 | F4211Z1T | Sales Order Detail Unedited Tax Transaction File | 1 | DZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP42B: Sales Order Entry |
| 90 | F4211CZ1 | Sales Order Detail Unedited Transaction File - CRM | 1 | CZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 91 | F4211URZ | F4211Z1 CRM User Reserved Tag File | 1 | UR | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 92 | F42150Z1 | Header Commission Unedited Transaction File | 1 | S2 | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 93 | F42160Z1 | Detail Commission Unedited Transaction File | 1 | S3 | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP43: Procurement |
| 94 | F4301Z1 | Purchase Order Header Unedited Transaction Table | 1 | SY | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 95 | F43092Z1 | Receipt Routing Unedited Transaction Table | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 96 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 97 | F43121Z1 | Receipts Unedited Transaction Table | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP44H: Homebuilder Management |
| 98 | F44H101Z | HB Community Master Unedited Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 99 | F44H201Z | HB Lot Master Unedited Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 100 | F44H501Z | HB Sales Master Unedited Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 101 | F44H604Z | HB Vendor Assignment Unedited Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 102 | F44H711Z | HB Lot Start Unedited Transaction File | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP45: Advanced Pricing |
| 103 | F4572Z1 | Live Promotions Interface - Inbound / Outbound | 1 | LP | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 104 | F4572ZP | Purge Live Promotions Interface | 1 | PG | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 105 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 1 | Z1 | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP46: Warehouse Management |
| 106 | F4611Z1 | Unedited Suggestion Table | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 107 | F4942Z1 | Work File for F4942 | 1 | SY | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP48: Work Order Processing |
| 108 | F4801Z1 | Outbound Work Order Header | 1 | SY | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP70: Multi-National Products |
| 109 | F703B1Z1 | Sales EDI Invoice Number | 1 | AZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 110 | F70XMLZ1 | XML Transaction Interfase | 1 | SY | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP74: EMEA Localization |
| 111 | F743011Z | Signed Batch Invoice - Tag Table -74 | 1 | TK | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 112 | F743013Z | Signed Batch Invoice - Tag Table -74 | 1 | TK | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 113 | F74XMLZ1 | XML Transaction Interface | 1 | SY | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 114 | F74XMLZ2 | XML Transaction Interface iSeries - COMM | 1 | SY | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP76A: Argentina |
| 115 | F76A010Z | F0101Z2 Argentinean Tag Table - ARG - 01 - 76A | 1 | V9 | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 116 | F76A19Z1 | Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A | 1 | VK | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 117 | F76A30 | F0411Z1 Tag Table - ARG - 04 - 76A | 1 | V8 | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 118 | F76A30H | EDI Batch Input Localization File - ARG - 04 - 76A | 1 | V6 | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 119 | F76A30T | F76A30 Tag File Z1 - ARG - 04 - 76A | 1 | V7 | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 120 | F76A60Z1 | Receipt Header Argentine Tag File Batch Input - ARG - - 76A | 1 | TF | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 121 | F76A85Z1 | Tag File F76A60 Batch Entry - ARG - 03B - 76A | 1 | BE | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP76B: Brazil |
| 122 | F76B12TZ | NF-e Status Log Z File - BRA - 76B | 1 | SZ | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP76H: Chile |
| 123 | F76H101Z | EDI - A/B Tag File - CHI - 76H - 76H | 1 | AH | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 124 | F76H3B1Z | F76H3B10 EDI Tag File - CHI - 03B - 76H | 1 | ZT | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 125 | F76H3B5Z | F76H3B15 EDI Tag File - CHI - 03B - 76H | 1 | IR | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 126 | F76HUI61 | Cache F76H3B1Z EDI Tag File - CHI - 03B - 76H | 3 | ZT | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP76P: Peru |
| 127 | F76P101Z | EDI - A/B Tag File - PER - 76P - 76P | 1 | AH | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP76V: Venezuela |
| 128 | F76V101Z | EDI A/B Additional Information - VE - 01 | 1 | ZW | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 129 | F76V411Z | Voucher Batch Upload Tag File - VEN - 04 | 1 | BI | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 130 | F76V415Z | Voucher - Credit/Debit Note Batch Upload - VEN - 04 | 1 | BI | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP79A: Greenhouse Gas Accounting |
| 131 | F79A11Z1 | GHG Ledger - Batch File | 1 | GL | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| TOP89: Conversion Programs |
| 132 | F01111Z1 | Batch - Contact Information | 1 | CB | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 133 | F06116TZ | Needed for upgrade from Xe to B9 | 1 | VL | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
| 134 | F0911Z1T | Needed for upgrade for XE and below | 1 | VN | EDUS | EDI - User ID | String | Generic Edit | 10 | 0 |
