| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP03: Accounts Receivable |
| 1 | F0311 | Accounts Receivable Ledger | 89 | RP | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 2 | F0312 | A/R Batch Cash Application | 52 | RU | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 3 | F03B11 | Customer Ledger | 86 | RP | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 4 | F03B11P | Customer Ledger Purge File | 86 | RP | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 5 | F03B11Z1 | Invoice Transactions - Batch File | 102 | VJ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 6 | F03B11Z2 | F03B11 Interoperability Table | 99 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 7 | F03B13Z1 | Electronic Receipts Input | 13 | RU | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 8 | F03B14 | A/R Check Detail File | 104 | RZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 9 | F03B14P | Receipts Detail Purge File | 104 | RZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 10 | F03B14Z2 | F03B14 Interoperability Table | 117 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 11 | F03B40 | A/R Deduction Management | 24 | RB | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 12 | F03B465 | A/R Netting Workfile | 8 | RO | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 13 | F03B575 | Auto Debit Invoice Select and Build | 95 | RD | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP04: Accounts Payable |
| 14 | F0411 | Accounts Payable Ledger | 68 | RP | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 15 | F0411A | WF - As Of - Accounts Payable Ledger | 68 | RP | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 16 | F0411P | Purge - Accounts Payable Ledger | 68 | RP | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 17 | F0411Z1 | Voucher Transactions - Batch File | 86 | VL | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 18 | F0411Z3 | F0411 Interoperability Table | 91 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP13C: Condition-Base Maintenance |
| 19 | F1310 | Condition-Based Alerts | 42 | CA | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 20 | F1310Z1 | Unedited Condition-Based Alerts | 56 | CB | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP17: Customer Service Management |
| 21 | F1721 | Contract Detail | 116 | CD | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 22 | F4801Z2 | Warranty Claim/Supplier Recovery processing | 66 | WS | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP17C: Call Management |
| 23 | F1755 | Customer Call Master | 187 | ZA | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 24 | F1760 | Time Entry | 66 | ZB | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP31: Shop Floor Control |
| 25 | F4801S | Purge - Work Order Master file | 47 | WA | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 26 | F4801Z1 | Outbound Work Order Header | 66 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP40: Inventory/OP Base |
| 27 | F4001Z | Batch Receiver File - Order Headings | 48 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 28 | F40051 | Return Material Authorization | 64 | RD | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 29 | F4011Z | Batch Receiver File - Order Details | 47 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 30 | F4201Z1 | Sales Order Header Unedited Transaction File | 37 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 31 | F4211DT | Sales Order Detail Date Tracking File | 9 | DT | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 32 | F4211Z1 | Sales Order Detail Unedited Transaction File | 44 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP42: Sales Management |
| 33 | F4201 | Sales Order Header File | 24 | SH | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 34 | F42019 | Sales Order Header History File | 24 | SH | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 35 | F4211 | Sales Order Detail File | 31 | SD | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 36 | F42119 | Sales Order History File | 31 | SD | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 37 | F42199 | S.O. Detail Ledger File | 31 | SL | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 38 | F42UI01 | SO Header Cache File (MBF) | 29 | ZH | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 39 | F42UI11 | SO Detail Cache File (MBF) | 34 | ZD | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 40 | F42UI520 | Pick Slips Header File | 37 | S8 | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 41 | F42UI521 | Pick Slips Detail File | 27 | S9 | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP43: Procurement |
| 42 | F4301 | Purchase Order Header | 23 | PH | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 43 | F4301Z | PO Header Work File | 27 | PA | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 44 | F4301Z1 | Purchase Order Header Unedited Transaction Table | 36 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 45 | F43080 | Approvals Fields Constants | 41 | PD | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 46 | F43092Z1 | Receipt Routing Unedited Transaction Table | 54 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 47 | F4311 | Purchase Order Detail File | 33 | PD | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 48 | F4311Z | Purchase Order Generator File | 37 | PW | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 49 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 46 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 50 | F43121 | Purchase Order Receiver File | 119 | PR | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 51 | F43121Z | Receiver workfile | 141 | PW | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 52 | F43121Z1 | Receipts Unedited Transaction Table | 116 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 53 | F43199 | P.O. Detail Ledger File - Flexible Version | 33 | OL | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 54 | F4371 | Suggested Reorder Stock Items | 24 | PD | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 55 | F43UI50D | PO Print Detail Work File | 51 | PW | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 56 | F43UI50H | PO Print Header Work File | 42 | PA | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP43Q: Strategic Sourcing |
| 57 | F43Q11 | Event Detail | 31 | ED | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP43S: Supplier Self Service |
| 58 | F43001 | Procurement Self-Service Transaction Log | 23 | SA | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP44H: Homebuilder Management |
| 59 | F44H611 | Bid Details | 32 | BD | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 60 | F44H611W | Bid Details Work File | 36 | BW | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 61 | F44H711 | Lot Start Workfile | 40 | SW | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 62 | F44H711P | After Start Purchasing | 29 | TP | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 63 | F44H711Z | HB Lot Start Unedited Transaction File | 53 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 64 | F44H71W1 | Lot Start Generation Workfile | 40 | GW | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 65 | F44H73W1 | Lot Start - P.O. / Committment Generation Work File | 35 | CG | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP46: Warehouse Management |
| 66 | F4600 | Warehouse Requests | 59 | R1 | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 67 | F4600PU | Warehouse Requests - Purged | 57 | R1 | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 68 | F4611 | Warehouse Suggestions | 67 | R2 | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 69 | F4611PU | Warehouse Suggestions - Purged | 66 | R2 | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 70 | F4611Z1 | Unedited Suggestion Table | 79 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 71 | F46201 | Carton Charge Reference Setup | 4 | CC | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP47: Electronic Commerce |
| 72 | F47011 | EDI Purchase Order Header - Inbound | 43 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 73 | F47012 | EDI Purchase Order Detail - Inbound | 47 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 74 | F47016 | EDI Purchase Order Header - Outbound | 38 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 75 | F47017 | EDI Purchase Order Detail - Outbound | 46 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 76 | F47021 | EDI P.O. Acknowledgment Header - Inbound | 38 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 77 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 46 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 78 | F47026 | EDI P.O. Acknowledgment Header - Outbound | 39 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 79 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 47 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 80 | F47031 | EDI Shipping Notice Header - Inbound | 36 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 81 | F47032 | EDI Shipping Notice Detail - Inbound | 45 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 82 | F47037 | EDI Shipping Notice Detail - Outbound | 47 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 83 | F470371 | EDI Shipping Notice Detail - Outbound | 52 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 84 | F47041 | EDI Invoice Header - Inbound | 53 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 85 | F47042 | EDI Invoice Detail - Inbound | 91 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 86 | F47046 | EDI Invoice Header (Sales) - Outbound | 39 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 87 | F47047 | EDI Invoice Detail (Sales) - Outbound | 47 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 88 | F47057 | EDI Payment Order Remittance Advice - Outbound | 55 | D3 | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 89 | F47057W | EDI Payment Order Remittance Advice - Work | 55 | D3 | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 90 | F47061 | EDI Planning Schedule Header - Inbound | 16 | MJ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 91 | F47066 | EDI Planning Schedule Header - Outbound | 16 | MJ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 92 | F47071 | EDI Receiving Advice Header - Inbound | 39 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 93 | F47072 | EDI Receiving Advice Detail - Inbound | 47 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 94 | F47076 | EDI Receiving Advice Header - Outbound | 39 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 95 | F47077 | EDI Receiving Advice Detail - Outbound | 47 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 96 | F47091 | EDI Request for Quote Header - Inbound | 43 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 97 | F47092 | EDI Request for Quote Detail - Inbound | 47 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 98 | F47096 | EDI Request for Quote Header - Outbound | 38 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 99 | F47097 | EDI Request for Quote Detail - Outbound | 46 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 100 | F47101 | EDI Response to RFQ Header - Inbound | 38 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 101 | F47102 | EDI Response to RFQ Detail - Inbound | 46 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 102 | F47106 | EDI Response to RFQ Header - Outbound | 39 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 103 | F47107 | EDI Response to RFQ Detail - Outbound | 47 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 104 | F47112 | EDI Lockbox Header - Transaction | 18 | Z2 | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 105 | F47121 | EDI Product Activity Data Header - Inbound | 19 | M1 | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 106 | F47122 | EDI Product Activity Data Detail - Inbound | 20 | MJ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 107 | F47126 | EDI Product Activity Data Header - Outbound | 19 | M1 | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 108 | F47127 | EDI Product Activity Data Detail - Outbound | 20 | MJ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 109 | F47131 | EDI Purchase Order Change Header - Inbound | 40 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 110 | F47132 | EDI Purchase Order Change Detail - Inbound | 48 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 111 | F47136 | EDI Purchase Order Change Header - Outbound | 38 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 112 | F47137 | EDI Purchase Order Change Detail - Outbound | 47 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 113 | F47141 | EDI P.O. Change Acknowledgment Header - Inbound | 39 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 114 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 48 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 115 | F47146 | EDI P.O. Change Acknowledgment Header - Outbound | 40 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 116 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 49 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 117 | F47156 | EDI Shipping Schedule Header - Outbound | 40 | SY | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 118 | F47157 | EDI Shipping Schedule Detail - Outbound | 48 | SZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP48: Work Order Processing |
| 119 | F4801 | Work Order Master File | 47 | WA | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 120 | F48UI001 | X4801 Master Business Function Workfile | 50 | WA | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP49: Transportation Management |
| 121 | F4960 | Load Header | 53 | TM | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP55: Reserved for Clients |
| 122 | F74H1051 | Invoicing Workfile - New | 25 | IW | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 123 | F74H1054 | Invoiced Order Lines - Work | 7 | IO | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 124 | F74H1058 | Invoice Lines - SO Details | 8 | IO | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 125 | F74T100 | Check Additional Table | 5 | CA | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP74R: CIS |
| 126 | F74R4500 | Paymet Order Supplemental Data - RU - 04 - 74R | 7 | PO | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP75C: China - Reporting System Only |
| 127 | F75C09Z1 | GUI cancel printing invoice-Jinsui - China | 4 | FF | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP76A: Argentina |
| 128 | F76A24 | Credit Invoice Information - Accounts Payable - ARG - - 76A | 20 | IE | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 129 | F76A30H | EDI Batch Input Localization File - ARG - 04 - 76A | 8 | V6 | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 130 | F76A411H | AP Header Tag File - ARG - 04 - 76A | 8 | B0 | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 131 | F76A411R | Voucher Localization Purge Header File - ARG - 04 - 76A | 8 | B4 | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 132 | F76A8011 | Supplier Information RG 726 - 04 | 9 | PA | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 133 | F76AUI04 | A/P Tag Legel Tax File - ARG - WF | 42 | WC | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 134 | F76AUI81 | Draft - Invoices Work File - ARG - 03B - 76A | 40 | WF | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 135 | F76AUI89 | Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A | 10 | WF | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP76B: Brazil - Reporting System Only |
| 136 | F7601B | Nota Fiscal Header - Brazil | 19 | FH | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP76C: Colombia |
| 137 | F76C0003 | VAT Certificates Retention - COL - 76C | 2 | CR | VR01 | Reference | String | Generic Edit | 25 | 0 |
| 138 | F76C034A | A/R Check Detail file As Of - COL - 76C | 104 | RZ | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP87: JDE Internal |
| 139 | F87SAR | SAR/Object Cross Reference | 10 | WS | VR01 | Reference | String | Generic Edit | 25 | 0 |
| TOP89: Conversion Programs |
| 140 | F43199A | Temp F43199 for ERP 9.0 Upgrade | 33 | OL | VR01 | Reference | String | Generic Edit | 25 | 0 |
