| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP04: Accounts Payable |
| 1 | F04572 | A/P Payment Processing - Summary File | 55 | KK | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| TOP32: Configuration Management |
| 2 | F3294Z | Configurator Batch Segments | 3 | AZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| TOP40: Inventory/OP Base |
| 3 | F4001Z | Batch Receiver File - Order Headings | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 4 | F4006Z | Batch Order Receiver - Order Address Information | 3 | OY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 5 | F4011Z | Batch Receiver File - Order Details | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 6 | F4012Z | Batch Receiver File - Destination Quantity | 1 | SP | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 7 | F4012ZW | WF - Destination Quantity | 1 | SP | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 8 | F4013Z | Kit Components Batch File | 3 | KS | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| TOP40R: Demand Scheduling |
| 9 | F47171 | EDI Demand Header | 3 | EH | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 10 | F47172 | EDI Demand Detail | 3 | ED | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 11 | F471721 | EDI Demand Supplemental Data | 3 | EU | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 12 | F471722 | EDI Demand Addresses | 3 | EA | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 13 | F471723 | EDI Demand Contact Names | 3 | EC | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 14 | F471724 | EDI Demand Contact Numbers | 3 | EN | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 15 | F47173 | EDI Demand Scheduling Detail | 3 | ES | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 16 | F471731 | EDI Demand Packaging | 3 | EP | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 17 | F47800 | EDI Transmission Values | 2 | FF | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| TOP42: Sales Management |
| 18 | F42565 | Invoice Print File | 74 | IW | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 19 | F47027T | Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound | 19 | UZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 20 | F470371T | Tag for F470371- EDI shipping Notice Detail - Outbound | 30 | UZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 21 | F47047T | Tag for F47047- EDI Invoice Detail (Sales) - Outbound | 19 | UZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 22 | F47107T | Tag for F47107- EDI Response to RFQ Detail - Outbound | 19 | UZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 23 | F47147T | Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound | 19 | UZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| TOP42B: Sales Order Entry |
| 24 | F4011ZT | Batch Receiver File - Order Details Tag | 5 | UZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 25 | F47012T | EDI Purchase Order Detail Tag - Inbound | 5 | UZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 26 | F47092T | EDI Request for Quote Detail Tag - Inbound | 5 | UZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 27 | F47132T | EDI Purchase Order Change Detail Tag - Inbound | 5 | UZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| TOP47: Electronic Commerce |
| 28 | F47003 | EDI Discrepancy Report Work File | 6 | SX | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 29 | F47011 | EDI Purchase Order Header - Inbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 30 | F47012 | EDI Purchase Order Detail - Inbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 31 | F47013 | EDI Purchase Order Detail (SDQ) - Inbound | 3 | SP | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 32 | F47016 | EDI Purchase Order Header - Outbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 33 | F470161 | EDI Purchase Order Additional Header - Outbound | 3 | S3 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 34 | F47017 | EDI Purchase Order Detail - Outbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 35 | F470171 | EDI Purchase Order Additional Detail - Outbound | 3 | S4 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 36 | F47021 | EDI P.O. Acknowledgment Header - Inbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 37 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 38 | F47026 | EDI P.O. Acknowledgment Header - Outbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 39 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 40 | F47031 | EDI Shipping Notice Header - Inbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 41 | F47032 | EDI Shipping Notice Detail - Inbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 42 | F47032T | EDI Shipping Notice Detail- Inbound Tag | 30 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 43 | F47036 | EDI Shipping Notice Header - Outbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 44 | F47037 | EDI Shipping Notice Detail - Outbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 45 | F470371 | EDI Shipping Notice Detail - Outbound | 4 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 46 | F470372 | EDI ASN Demand Scheduling Detail | 3 | AI | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 47 | F470373 | EDI ASN Shipping | 3 | AG | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 48 | F470374 | EDI ASN Demand Addresses | 3 | AM | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 49 | F470375 | EDI ASN Packaging Detail | 3 | AK | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 50 | F47041 | EDI Invoice Header - Inbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 51 | F47042 | EDI Invoice Detail - Inbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 52 | F47044 | EDI Invoice Summary - Inbound | 3 | SW | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 53 | F47046 | EDI Invoice Header (Sales) - Outbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 54 | F470461 | EDI Invoice Additional Header - Outbound | 3 | S3 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 55 | F470462 | EDI Invoice Expanded Header (Sales) | 3 | S5 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 56 | F47047 | EDI Invoice Detail (Sales) - Outbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 57 | F470471 | EDI Invoice Additional Detail - Outbound | 3 | S4 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 58 | F470472 | EDI Invoice Expanded Detail (Sales) | 3 | S6 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 59 | F470473 | EDI Invoice Detail Charges | 3 | S7 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 60 | F47056 | EDI Payment Order Header - Outbound | 3 | D1 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 61 | F470561 | EDI Payment Order Bank N and A - Outbound | 3 | D2 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 62 | F470561W | EDI Payment Order Bank N and A - Work | 3 | D2 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 63 | F470562 | EDI Payment Order Vendor N and A - Outbound | 3 | D4 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 64 | F470562W | EDI Payment Order Vendor N and A - Work | 3 | D4 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 65 | F470563 | EDI Payment Order Payee N and A - Outbound | 3 | D5 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 66 | F470563W | EDI Payment Order Payee N and A - Work | 3 | D5 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 67 | F47056W | EDI Payment Order Header - Work | 3 | D1 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 68 | F47057 | EDI Payment Order Remittance Advice - Outbound | 3 | D3 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 69 | F47057W | EDI Payment Order Remittance Advice - Work | 3 | D3 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 70 | F4706 | EDI Order Address Information | 3 | ZA | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 71 | F47061 | EDI Planning Schedule Header - Inbound | 3 | MJ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 72 | F47062 | EDI Planning Schedule Detail - Inbound | 3 | MY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 73 | F47066 | EDI Planning Schedule Header - Outbound | 3 | MJ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 74 | F47067 | EDI Planning Schedule Detail - Outbound | 3 | MY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 75 | F47071 | EDI Receiving Advice Header - Inbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 76 | F47072 | EDI Receiving Advice Detail - Inbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 77 | F47076 | EDI Receiving Advice Header - Outbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 78 | F47077 | EDI Receiving Advice Detail - Outbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 79 | F47081 | EDI Price Sales Catalog Header - Inbound | 3 | FV | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 80 | F47082 | EDI Price Sales Catalog Detail - Inbound | 3 | FY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 81 | F47091 | EDI Request for Quote Header - Inbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 82 | F47092 | EDI Request for Quote Detail - Inbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 83 | F47093 | EDI Request for Quote Detail (SDQ) - Inbound | 3 | SP | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 84 | F47096 | EDI Request for Quote Header - Outbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 85 | F47097 | EDI Request for Quote Detail - Outbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 86 | F47098 | EDI RFQ Detail Quantity - Outbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 87 | F47101 | EDI Response to RFQ Header - Inbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 88 | F47102 | EDI Response to RFQ Detail - Inbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 89 | F47103 | EDI Response to RFQ Detail Quantity - Inbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 90 | F47106 | EDI Response to RFQ Header - Outbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 91 | F471061 | EDI Response to RFQ Additional Header - Outbound | 3 | S3 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 92 | F47107 | EDI Response to RFQ Detail - Outbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 93 | F471071 | EDI Response to RFQ Additional Detail - Outbound | 3 | S4 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 94 | F47111 | EDI Lockbox/Payment Header - Transaction | 3 | Z1 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 95 | F47112 | EDI Lockbox Header - Transaction | 3 | Z2 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 96 | F47113 | EDI Lockbox/Payment Detail - Batch | 3 | Z3 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 97 | F47114 | EDI Lockbox/Payment Detail - Payment | 3 | Z4 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 98 | F47121 | EDI Product Activity Data Header - Inbound | 3 | M1 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 99 | F47122 | EDI Product Activity Data Detail - Inbound | 3 | MJ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 100 | F47123 | EDI Product Activity Data (SDQ) - Inbound | 3 | MK | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 101 | F47126 | EDI Product Activity Data Header - Outbound | 3 | M1 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 102 | F47127 | EDI Product Activity Data Detail - Outbound | 3 | MJ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 103 | F47128 | EDI Product Activity Data (SDQ) - Outbound | 3 | MK | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 104 | F47131 | EDI Purchase Order Change Header - Inbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 105 | F47132 | EDI Purchase Order Change Detail - Inbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 106 | F47136 | EDI Purchase Order Change Header - Outbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 107 | F47137 | EDI Purchase Order Change Detail - Outbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 108 | F4714 | EDI Order Text Lines - Header | 3 | ZT | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 109 | F47141 | EDI P.O. Change Acknowledgment Header - Inbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 110 | F471411 | Purchase Order Edit Object Log Table | 1 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 111 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 112 | F47146 | EDI P.O. Change Acknowledgment Header - Outbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 113 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 114 | F4715 | EDI Order Text Lines - Detail | 3 | ZD | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 115 | F47156 | EDI Shipping Schedule Header - Outbound | 3 | SY | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 116 | F47157 | EDI Shipping Schedule Detail - Outbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 117 | F4716 | EDI Item Text - Inbound/Outbound | 3 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 118 | F47191 | EDI Acknowledgement Header | 3 | AH | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 119 | F47192 | EDI Acknowledgement Error Detail | 3 | AE | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 120 | F47194 | EDI Acknowledgement References | 3 | AR | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 121 | F47196 | EDI Acknowledgement Name And Address | 3 | AA | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 122 | F47198 | EDI Acknowledgement Notes | 3 | AN | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| 123 | F47CTL | EDI Lockbox/Payment Work File | 3 | Z5 | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| TOP49: Transportation Management |
| 124 | F47500WF | Inbound Transaction Processor Workfile | 1 | SZ | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
| TOP89: Conversion Programs |
| 125 | F470375T | EDI ASN Packaging Detail Tag Table | 3 | AK | EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 |
