| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP03B: Enhanced Accounts Receivable |
| 1 | F03B11Z1 | Batch Invoices | 2 | VJ | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP04: Accounts Payable |
| 2 | F0411Z1 | Voucher Transactions - Batch Upload | 2 | VL | EDTY | Type Record | Character | UDC | 1 | 0 |
| 3 | F0411Z3 | F0411 Interoperability Table | 14 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 4 | F04572 | A/P Payment Processing - Summary | 53 | KK | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP05: Time Accounting and HRM Base |
| 5 | F05100Z1 | Resource Competencies Unedited Transactions File | 28 | CU | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP05T: Time Entry |
| 6 | F06116Z1 | Employee Transactions - Batch File | 2 | VL | EDTY | Type Record | Character | UDC | 1 | 0 |
| 7 | F06116Z2 | ESS Timecard History | 2 | VM | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP09: General Accounting |
| 8 | F0911Z1 | Journal Entry Transactions - Batch File | 2 | VN | EDTY | Type Record | Character | UDC | 1 | 0 |
| 9 | F0911Z4 | F0911 Interoperability Table | 14 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP11: Multi Currency |
| 10 | F0015Z1 | External Currency Exchange Rates | 14 | ZE | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP16: Profit Management (EPS) |
| 11 | F1602Z1 | External Cost Analyzer Balances - Interoperability Table | 14 | CZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 12 | F1632Z1 | External Driver Balances-Interoperability Table | 14 | CY | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP40: Inventory/OP Base |
| 13 | F4001Z | Batch Receiver File - Order Headings | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 14 | F4011Z | Batch Receiver File - Order Details | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP40R: Demand Scheduling |
| 15 | F47171 | EDI Demand Header | 1 | EH | EDTY | Type Record | Character | UDC | 1 | 0 |
| 16 | F47172 | EDI Demand Detail | 1 | ED | EDTY | Type Record | Character | UDC | 1 | 0 |
| 17 | F471721 | EDI Demand Supplemental Data | 1 | EU | EDTY | Type Record | Character | UDC | 1 | 0 |
| 18 | F471722 | EDI Demand Addresses | 1 | EA | EDTY | Type Record | Character | UDC | 1 | 0 |
| 19 | F471723 | EDI Demand Contact Names | 1 | EC | EDTY | Type Record | Character | UDC | 1 | 0 |
| 20 | F471724 | EDI Demand Contact Numbers | 1 | EN | EDTY | Type Record | Character | UDC | 1 | 0 |
| 21 | F47173 | EDI Demand Scheduling Detail | 1 | ES | EDTY | Type Record | Character | UDC | 1 | 0 |
| 22 | F471731 | EDI Demand Packaging | 1 | EP | EDTY | Type Record | Character | UDC | 1 | 0 |
| 23 | F47800 | EDI Transmission Values | 1 | FF | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP42: Sales Management |
| 24 | F47027T | Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound | 18 | UZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 25 | F470371T | Tag for F470371- EDI shipping Notice Detail - Outbound | 29 | UZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 26 | F47047T | Tag for F47047- EDI Invoice Detail (Sales) - Outbound | 18 | UZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 27 | F47107T | Tag for F47107- EDI Response to RFQ Detail - Outbound | 18 | UZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 28 | F47147T | Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound | 18 | UZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP42B: Sales Order Entry |
| 29 | F4011ZT | Batch Receiver File - Order Details Tag | 1 | UZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 30 | F47012T | EDI Purchase Order Detail Tag - Inbound | 1 | UZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 31 | F47092T | EDI Request for Quote Detail Tag - Inbound | 1 | UZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 32 | F47132T | EDI Purchase Order Change Detail Tag - Inbound | 1 | UZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP45: Advanced Pricing |
| 33 | F4572Z1 | Live Promotions Interface - Inbound / Outbound | 8 | LP | EDTY | Type Record | Character | UDC | 1 | 0 |
| 34 | F4572ZP | Purge Live Promotions Interface | 8 | PG | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP47: Electronic Commerce |
| 35 | F47002 | Flat File Cross-Reference Table | 3 | SV | EDTY | Type Record | Character | UDC | 1 | 0 |
| 36 | F47003 | EDI Discrepancy Report Work File | 18 | SX | EDTY | Type Record | Character | UDC | 1 | 0 |
| 37 | F47006 | EDI Order Header - Outbound Tax Table | 1 | ST | EDTY | Type Record | Character | UDC | 1 | 0 |
| 38 | F47007 | EDI Order Detail - Outbound Tax Table | 1 | DT | EDTY | Type Record | Character | UDC | 1 | 0 |
| 39 | F47011 | EDI Purchase Order Header - Inbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 40 | F47011TX | EDI Purchase Order Header Tax - Inbound | 1 | ST | EDTY | Type Record | Character | UDC | 1 | 0 |
| 41 | F47012 | EDI Purchase Order Detail - Inbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 42 | F47012TX | EDI Purchase Order Detail Tax - Inbound | 1 | DT | EDTY | Type Record | Character | UDC | 1 | 0 |
| 43 | F47013 | EDI Purchase Order Detail (SDQ) - Inbound | 1 | SP | EDTY | Type Record | Character | UDC | 1 | 0 |
| 44 | F47016 | EDI Purchase Order Header - Outbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 45 | F470161 | EDI Purchase Order Additional Header - Outbound | 1 | S3 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 46 | F47017 | EDI Purchase Order Detail - Outbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 47 | F470171 | EDI Purchase Order Additional Detail - Outbound | 1 | S4 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 48 | F47021 | EDI P.O. Acknowledgment Header - Inbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 49 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 50 | F47026 | EDI P.O. Acknowledgment Header - Outbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 51 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 52 | F47031 | EDI Shipping Notice Header - Inbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 53 | F47032 | EDI Shipping Notice Detail - Inbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 54 | F47036 | EDI Shipping Notice Header - Outbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 55 | F47036X | EDI Shipping Notice Header Tax - Outbound | 1 | ST | EDTY | Type Record | Character | UDC | 1 | 0 |
| 56 | F47037 | EDI Shipping Notice Detail - Outbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 57 | F470371 | EDI Shipping Notice Detail - Outbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 58 | F470371X | EDI Shipping Notice Detail Tax - Outbound | 1 | DT | EDTY | Type Record | Character | UDC | 1 | 0 |
| 59 | F470372 | EDI ASN Demand Scheduling Detail | 1 | AI | EDTY | Type Record | Character | UDC | 1 | 0 |
| 60 | F470373 | EDI ASN Shipping | 1 | AG | EDTY | Type Record | Character | UDC | 1 | 0 |
| 61 | F470374 | EDI ASN Demand Addresses | 16 | AM | EDTY | Type Record | Character | UDC | 1 | 0 |
| 62 | F470375 | EDI ASN Packaging Detail | 1 | AK | EDTY | Type Record | Character | UDC | 1 | 0 |
| 63 | F47041 | EDI Invoice Header - Inbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 64 | F47042 | EDI Invoice Detail - Inbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 65 | F47044 | EDI Invoice Summary - Inbound | 1 | SW | EDTY | Type Record | Character | UDC | 1 | 0 |
| 66 | F47046 | EDI Invoice Header (Sales) - Outbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 67 | F470461 | EDI Invoice Additional Header - Outbound | 1 | S3 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 68 | F470462 | EDI Invoice Expanded Header (Sales) | 1 | S5 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 69 | F47047 | EDI Invoice Detail (Sales) - Outbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 70 | F470471 | EDI Invoice Additional Detail - Outbound | 1 | S4 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 71 | F470472 | EDI Invoice Expanded Detail (Sales) | 1 | S6 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 72 | F470473 | EDI Invoice Detail Charges | 1 | S7 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 73 | F47056 | EDI Payment Order Header - Outbound | 1 | D1 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 74 | F470561 | EDI Payment Order Bank N & A - Outbound | 1 | D2 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 75 | F470561W | EDI Payment Order Bank N & A - Work | 1 | D2 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 76 | F470562 | EDI Payment Order Vendor N & A - Outbound | 1 | D4 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 77 | F470562W | EDI Payment Order Vendor N & A - Work | 1 | D4 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 78 | F470563 | EDI Payment Order Payee N & A - Outbound | 1 | D5 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 79 | F470563W | EDI Payment Order Payee N & A - Work | 1 | D5 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 80 | F47056W | EDI Payment Order Header - Work | 1 | D1 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 81 | F47057 | EDI Payment Order Remittance Advice - Outbound | 1 | D3 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 82 | F47057W | EDI Payment Order Remittance Advice - Work | 1 | D3 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 83 | F4706 | EDI Order Address Information | 1 | ZA | EDTY | Type Record | Character | UDC | 1 | 0 |
| 84 | F47061 | EDI Planning Schedule Header - Inbound | 1 | MJ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 85 | F47062 | EDI Planning Schedule Detail - Inbound | 1 | MY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 86 | F47066 | EDI Planning Schedule Header - Outbound | 1 | MJ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 87 | F47067 | EDI Planning Schedule Detail - Outbound | 1 | MY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 88 | F47071 | EDI Receiving Advice Header - Inbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 89 | F47072 | EDI Receiving Advice Detail - Inbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 90 | F47076 | EDI Receiving Advice Header - Outbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 91 | F47077 | EDI Receiving Advice Detail - Outbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 92 | F47081 | EDI Price Sales Catalog Header - Inbound | 1 | FV | EDTY | Type Record | Character | UDC | 1 | 0 |
| 93 | F47082 | EDI Price Sales Catalog Detail - Inbound | 1 | FY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 94 | F47091 | EDI Request for Quote Header - Inbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 95 | F47091TX | EDI Request for Quote Header Tax - Inbound | 1 | ST | EDTY | Type Record | Character | UDC | 1 | 0 |
| 96 | F47092 | EDI Request for Quote Detail - Inbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 97 | F47093 | EDI Request for Quote Detail (SDQ) - Inbound | 1 | SP | EDTY | Type Record | Character | UDC | 1 | 0 |
| 98 | F47096 | EDI Request for Quote Header - Outbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 99 | F47097 | EDI Request for Quote Detail - Outbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 100 | F47098 | EDI RFQ Detail Quantity - Outbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 101 | F47101 | EDI Response to RFQ Header - Inbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 102 | F47102 | EDI Response to RFQ Detail - Inbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 103 | F47103 | EDI Response to RFQ Detail Quantity - Inbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 104 | F47106 | EDI Response to RFQ Header - Outbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 105 | F471061 | EDI Response to RFQ Additional Header - Outbound | 1 | S3 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 106 | F47107 | EDI Response to RFQ Detail - Outbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 107 | F471071 | EDI Response to RFQ Additional Detail - Outbound | 1 | S4 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 108 | F47111 | EDI Lockbox/Payment Header - Transaction | 1 | Z1 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 109 | F47112 | EDI Lockbox Header - Transaction | 1 | Z2 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 110 | F47113 | EDI Lockbox/Payment Detail - Batch | 1 | Z3 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 111 | F47114 | EDI Lockbox/Payment Detail - Payment | 1 | Z4 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 112 | F47121 | EDI Product Activity Data Header - Inbound | 1 | M1 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 113 | F47122 | EDI Product Activity Data Detail - Inbound | 1 | MJ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 114 | F47123 | EDI Product Activity Data (SDQ) - Inbound | 1 | MK | EDTY | Type Record | Character | UDC | 1 | 0 |
| 115 | F47126 | EDI Product Activity Data Header - Outbound | 1 | M1 | EDTY | Type Record | Character | UDC | 1 | 0 |
| 116 | F47127 | EDI Product Activity Data Detail - Outbound | 1 | MJ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 117 | F47128 | EDI Product Activity Data (SDQ) - Outbound | 1 | MK | EDTY | Type Record | Character | UDC | 1 | 0 |
| 118 | F47131 | EDI Purchase Order Change Header - Inbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 119 | F47131TX | EDI Purchase Order Change Header Tax - Inbound | 1 | ST | EDTY | Type Record | Character | UDC | 1 | 0 |
| 120 | F47132 | EDI Purchase Order Change Detail - Inbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 121 | F47132TX | EDI Purchase Order Change Detail Tax - Inbound | 1 | DT | EDTY | Type Record | Character | UDC | 1 | 0 |
| 122 | F47136 | EDI Purchase Order Change Header - Outbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 123 | F47137 | EDI Purchase Order Change Detail - Outbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 124 | F4714 | EDI Order Text Lines - Header | 1 | ZT | EDTY | Type Record | Character | UDC | 1 | 0 |
| 125 | F47141 | EDI P.O. Change Acknowledgment Header - Inbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 126 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 127 | F47146 | EDI P.O. Change Acknowledgment Header - Outbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 128 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 129 | F4715 | EDI Order Text Lines - Detail | 1 | ZD | EDTY | Type Record | Character | UDC | 1 | 0 |
| 130 | F47156 | EDI Shipping Schedule Header - Outbound | 1 | SY | EDTY | Type Record | Character | UDC | 1 | 0 |
| 131 | F47157 | EDI Shipping Schedule Detail - Outbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 132 | F4716 | EDI Item Text - Inbound/Outbound | 1 | SZ | EDTY | Type Record | Character | UDC | 1 | 0 |
| 133 | F47181 | EDI Consumption Header (FUTURE) | 21 | EH | EDTY | Type Record | Character | UDC | 1 | 0 |
| 134 | F47182 | EDI Consumption Detail (FUTURE) | 30 | ED | EDTY | Type Record | Character | UDC | 1 | 0 |
| 135 | F47191 | EDI Acknowledgement Header | 1 | AH | EDTY | Type Record | Character | UDC | 1 | 0 |
| 136 | F47192 | EDI Acknowledgement Error Detail | 1 | AE | EDTY | Type Record | Character | UDC | 1 | 0 |
| 137 | F47194 | EDI Acknowledgement References | 1 | AR | EDTY | Type Record | Character | UDC | 1 | 0 |
| 138 | F47196 | EDI Acknowledgement Name And Address | 1 | AA | EDTY | Type Record | Character | UDC | 1 | 0 |
| 139 | F47198 | EDI Acknowledgement Notes | 1 | AN | EDTY | Type Record | Character | UDC | 1 | 0 |
| 140 | F47CTL | EDI Lockbox/Payment Work File | 1 | Z5 | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP49: Transportation Management |
| 141 | F47092TX | EDI Request for Quote Detail Tax - Inbound | 1 | DT | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP76A: Argentina |
| 142 | F76A19Z1 | Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A | 2 | VK | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP76B: Brazil - Reporting System Only |
| 143 | F76B472 | Dynamic Formater Layout Transaction & Line Types - 03B | 3 | DD | EDTY | Type Record | Character | UDC | 1 | 0 |
| 144 | F76B473 | Dynamic Formater Layouts Specification - 03B | 3 | DS | EDTY | Type Record | Character | UDC | 1 | 0 |
| 145 | F76B474 | Dynamic Formater Bank Attributes - 03B | 7 | BA | EDTY | Type Record | Character | UDC | 1 | 0 |
| 146 | F76B474I | File Upload For Bank Transaction Inbound Process - 03B | 5 | BI | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP79A: Greenhouse Gas Accounting |
| 147 | F79A11Z1 | GHG Ledger - Batch File | 2 | GL | EDTY | Type Record | Character | UDC | 1 | 0 |
| TOP89: Conversion Programs |
| 148 | F470375T | EDI ASN Packaging Detail Tag Table | 10 | AK | EDTY | Type Record | Character | UDC | 1 | 0 |
