JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides |  920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

147 columns | Print definition?812 | VR01

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP03: Accounts Receivable
1F0311Accounts Receivable Ledger89RPVR01ReferenceStringGeneric Edit250
2F0312A/R Batch Cash Application52RUVR01ReferenceStringGeneric Edit250
TOP03B: Enhanced Accounts Receivable
3F03B11Customer Ledger86RPVR01ReferenceStringGeneric Edit250
4F03B11PCustomer Ledger Purge File86RPVR01ReferenceStringGeneric Edit250
5F03B11Z1Invoice Transactions - Batch File102VJVR01ReferenceStringGeneric Edit250
6F03B11Z2F03B11 Interoperability Table99SYVR01ReferenceStringGeneric Edit250
7F03B13Z1Electronic Receipts Input13RUVR01ReferenceStringGeneric Edit250
8F03B14A/R Check Detail File104RZVR01ReferenceStringGeneric Edit250
9F03B14PReceipts Detail Purge File104RZVR01ReferenceStringGeneric Edit250
10F03B14Z2F03B14 Interoperability Table117SZVR01ReferenceStringGeneric Edit250
11F03B40A/R Deduction Management24RBVR01ReferenceStringGeneric Edit250
12F03B465A/R Netting Workfile8ROVR01ReferenceStringGeneric Edit250
13F03B575Auto Debit Invoice Select and Build95RDVR01ReferenceStringGeneric Edit250
TOP04: Accounts Payable
14F0411Accounts Payable Ledger68RPVR01ReferenceStringGeneric Edit250
15F0411AWF - As Of - Accounts Payable Ledger68RPVR01ReferenceStringGeneric Edit250
16F0411PPurge - Accounts Payable Ledger68RPVR01ReferenceStringGeneric Edit250
17F0411Z1Voucher Transactions - Batch File86VLVR01ReferenceStringGeneric Edit250
18F0411Z3F0411 Interoperability Table91SZVR01ReferenceStringGeneric Edit250
TOP13C: Condition-Base Maintenance
19F1310Condition-Based Alerts42CAVR01ReferenceStringGeneric Edit250
20F1310Z1Unedited Condition-Based Alerts56CBVR01ReferenceStringGeneric Edit250
TOP17: Customer Service Management
21F1721Contract Detail116CDVR01ReferenceStringGeneric Edit250
22F4801Z2Warranty Claim/Supplier Recovery processing66WSVR01ReferenceStringGeneric Edit250
TOP17C: Call Management
23F1755Customer Call Master187ZAVR01ReferenceStringGeneric Edit250
24F1760Time Entry66ZBVR01ReferenceStringGeneric Edit250
TOP31: Shop Floor Control
25F4801SPurge - Work Order Master file47WAVR01ReferenceStringGeneric Edit250
26F4801Z1Outbound Work Order Header66SYVR01ReferenceStringGeneric Edit250
TOP40: Inventory/OP Base
27F4001ZBatch Receiver File - Order Headings48SYVR01ReferenceStringGeneric Edit250
28F40051Return Material Authorization64RDVR01ReferenceStringGeneric Edit250
29F4011ZBatch Receiver File - Order Details47SZVR01ReferenceStringGeneric Edit250
30F4201Z1Sales Order Header Unedited Transaction File37SYVR01ReferenceStringGeneric Edit250
31F4211DTSales Order Detail Date Tracking File9DTVR01ReferenceStringGeneric Edit250
32F4211Z1Sales Order Detail Unedited Transaction File44SZVR01ReferenceStringGeneric Edit250
TOP42: Sales Management
33F4201Sales Order Header File24SHVR01ReferenceStringGeneric Edit250
34F42019Sales Order Header History File24SHVR01ReferenceStringGeneric Edit250
35F4211Sales Order Detail File31SDVR01ReferenceStringGeneric Edit250
36F42119Sales Order History File31SDVR01ReferenceStringGeneric Edit250
37F42199S.O. Detail Ledger File31SLVR01ReferenceStringGeneric Edit250
38F42UI01SO Header Cache File (MBF)29ZHVR01ReferenceStringGeneric Edit250
39F42UI11SO Detail Cache File (MBF)34ZDVR01ReferenceStringGeneric Edit250
40F42UI520Pick Slips Header File37S8VR01ReferenceStringGeneric Edit250
41F42UI521Pick Slips Detail File27S9VR01ReferenceStringGeneric Edit250
TOP43: Procurement
42F4301Purchase Order Header23PHVR01ReferenceStringGeneric Edit250
43F4301ZPO Header Work File27PAVR01ReferenceStringGeneric Edit250
44F4301Z1Purchase Order Header Unedited Transaction Table36SYVR01ReferenceStringGeneric Edit250
45F43080Approvals Fields Constants41PDVR01ReferenceStringGeneric Edit250
46F43092Z1Receipt Routing Unedited Transaction Table54SZVR01ReferenceStringGeneric Edit250
47F4311Purchase Order Detail File33PDVR01ReferenceStringGeneric Edit250
48F4311ZPurchase Order Generator File37PWVR01ReferenceStringGeneric Edit250
49F4311Z1Purchase Order Detail Unedited Transaction Table46SZVR01ReferenceStringGeneric Edit250
50F43121Purchase Order Receiver File119PRVR01ReferenceStringGeneric Edit250
51F43121ZReceiver workfile141PWVR01ReferenceStringGeneric Edit250
52F43121Z1Receipts Unedited Transaction Table116SZVR01ReferenceStringGeneric Edit250
53F43199P.O. Detail Ledger File - Flexible Version33OLVR01ReferenceStringGeneric Edit250
54F4371Suggested Reorder Stock Items24PDVR01ReferenceStringGeneric Edit250
55F43UI50DPO Print Detail Work File51PWVR01ReferenceStringGeneric Edit250
56F43UI50HPO Print Header Work File42PAVR01ReferenceStringGeneric Edit250
TOP43Q: Strategic Sourcing
57F43Q11Event Detail31EDVR01ReferenceStringGeneric Edit250
TOP43S: Supplier Self Service
58F43001Procurement Self-Service Transaction Log23SAVR01ReferenceStringGeneric Edit250
TOP44H: Homebuilder Management
59F44H611Bid Details32BDVR01ReferenceStringGeneric Edit250
60F44H611WBid Details Work File36BWVR01ReferenceStringGeneric Edit250
61F44H711Lot Start Workfile40SWVR01ReferenceStringGeneric Edit250
62F44H711PAfter Start Purchasing29TPVR01ReferenceStringGeneric Edit250
63F44H711ZHB Lot Start Unedited Transaction File53SZVR01ReferenceStringGeneric Edit250
64F44H71W1Lot Start Generation Workfile40GWVR01ReferenceStringGeneric Edit250
65F44H73W1Lot Start - P.O. / Committment Generation Work File35CGVR01ReferenceStringGeneric Edit250
TOP46: Warehouse Management
66F4600Warehouse Requests59R1VR01ReferenceStringGeneric Edit250
67F4600PUWarehouse Requests - Purged57R1VR01ReferenceStringGeneric Edit250
68F4611Warehouse Suggestions67R2VR01ReferenceStringGeneric Edit250
69F4611PUWarehouse Suggestions - Purged66R2VR01ReferenceStringGeneric Edit250
70F4611Z1Unedited Suggestion Table79SZVR01ReferenceStringGeneric Edit250
71F46201Carton Charge Reference Setup4CCVR01ReferenceStringGeneric Edit250
TOP47: Electronic Commerce
72F47011EDI Purchase Order Header - Inbound43SYVR01ReferenceStringGeneric Edit250
73F47012EDI Purchase Order Detail - Inbound47SZVR01ReferenceStringGeneric Edit250
74F47016EDI Purchase Order Header - Outbound38SYVR01ReferenceStringGeneric Edit250
75F47017EDI Purchase Order Detail - Outbound46SZVR01ReferenceStringGeneric Edit250
76F47021EDI P.O. Acknowledgment Header - Inbound38SYVR01ReferenceStringGeneric Edit250
77F47022EDI P.O. Acknowledgment Detail - Inbound46SZVR01ReferenceStringGeneric Edit250
78F47026EDI P.O. Acknowledgment Header - Outbound39SYVR01ReferenceStringGeneric Edit250
79F47027EDI P.O. Acknowledgment Detail - Outbound47SZVR01ReferenceStringGeneric Edit250
80F47031EDI Shipping Notice Header - Inbound36SYVR01ReferenceStringGeneric Edit250
81F47032EDI Shipping Notice Detail - Inbound45SZVR01ReferenceStringGeneric Edit250
82F47037EDI Shipping Notice Detail - Outbound47SZVR01ReferenceStringGeneric Edit250
83F470371EDI Shipping Notice Detail - Outbound52SZVR01ReferenceStringGeneric Edit250
84F47041EDI Invoice Header - Inbound53SYVR01ReferenceStringGeneric Edit250
85F47042EDI Invoice Detail - Inbound91SZVR01ReferenceStringGeneric Edit250
86F47046EDI Invoice Header (Sales) - Outbound39SYVR01ReferenceStringGeneric Edit250
87F47047EDI Invoice Detail (Sales) - Outbound47SZVR01ReferenceStringGeneric Edit250
88F47057EDI Payment Order Remittance Advice - Outbound55D3VR01ReferenceStringGeneric Edit250
89F47057WEDI Payment Order Remittance Advice - Work55D3VR01ReferenceStringGeneric Edit250
90F47061EDI Planning Schedule Header - Inbound16MJVR01ReferenceStringGeneric Edit250
91F47066EDI Planning Schedule Header - Outbound16MJVR01ReferenceStringGeneric Edit250
92F47071EDI Receiving Advice Header - Inbound39SYVR01ReferenceStringGeneric Edit250
93F47072EDI Receiving Advice Detail - Inbound47SZVR01ReferenceStringGeneric Edit250
94F47076EDI Receiving Advice Header - Outbound39SYVR01ReferenceStringGeneric Edit250
95F47077EDI Receiving Advice Detail - Outbound47SZVR01ReferenceStringGeneric Edit250
96F47091EDI Request for Quote Header - Inbound43SYVR01ReferenceStringGeneric Edit250
97F47092EDI Request for Quote Detail - Inbound47SZVR01ReferenceStringGeneric Edit250
98F47096EDI Request for Quote Header - Outbound38SYVR01ReferenceStringGeneric Edit250
99F47097EDI Request for Quote Detail - Outbound46SZVR01ReferenceStringGeneric Edit250
100F47101EDI Response to RFQ Header - Inbound38SYVR01ReferenceStringGeneric Edit250
101F47102EDI Response to RFQ Detail - Inbound46SZVR01ReferenceStringGeneric Edit250
102F47106EDI Response to RFQ Header - Outbound39SYVR01ReferenceStringGeneric Edit250
103F47107EDI Response to RFQ Detail - Outbound47SZVR01ReferenceStringGeneric Edit250
104F47112EDI Lockbox Header - Transaction18Z2VR01ReferenceStringGeneric Edit250
105F47121EDI Product Activity Data Header - Inbound19M1VR01ReferenceStringGeneric Edit250
106F47122EDI Product Activity Data Detail - Inbound20MJVR01ReferenceStringGeneric Edit250
107F47126EDI Product Activity Data Header - Outbound19M1VR01ReferenceStringGeneric Edit250
108F47127EDI Product Activity Data Detail - Outbound20MJVR01ReferenceStringGeneric Edit250
109F47131EDI Purchase Order Change Header - Inbound40SYVR01ReferenceStringGeneric Edit250
110F47132EDI Purchase Order Change Detail - Inbound48SZVR01ReferenceStringGeneric Edit250
111F47136EDI Purchase Order Change Header - Outbound38SYVR01ReferenceStringGeneric Edit250
112F47137EDI Purchase Order Change Detail - Outbound47SZVR01ReferenceStringGeneric Edit250
113F47141EDI P.O. Change Acknowledgment Header - Inbound39SYVR01ReferenceStringGeneric Edit250
114F47142EDI P.O. Change Acknowledgment Detail - Inbound48SZVR01ReferenceStringGeneric Edit250
115F47146EDI P.O. Change Acknowledgment Header - Outbound40SYVR01ReferenceStringGeneric Edit250
116F47147EDI P.O. Change Acknowledgment Detail - Outbound49SZVR01ReferenceStringGeneric Edit250
117F47156EDI Shipping Schedule Header - Outbound40SYVR01ReferenceStringGeneric Edit250
118F47157EDI Shipping Schedule Detail - Outbound48SZVR01ReferenceStringGeneric Edit250
TOP48: Work Order Processing
119F4801Work Order Master File47WAVR01ReferenceStringGeneric Edit250
120F48UI001X4801 Master Business Function Workfile50WAVR01ReferenceStringGeneric Edit250
TOP49: Transportation Management
121F4960Load Header53TMVR01ReferenceStringGeneric Edit250
TOP55: Reserved for Clients
122F55IF311As Of132RPVR01ReferenceStringGeneric Edit250
123F55IF421Sales Order per BO37SDVR01ReferenceStringGeneric Edit250
124F55IF425Sales Order per BO - 200537SDVR01ReferenceStringGeneric Edit250
125F55IFCSVTabella csv Stampa Fattura - UK4CSVR01ReferenceStringGeneric Edit250
126F55W0100Correction Invoice Print - WF132SDVR01ReferenceStringGeneric Edit250
127F55W0105Correction Invoice Print - WF28WFVR01ReferenceStringGeneric Edit250
128F74H1051Invoicing Workfile - New25IWVR01ReferenceStringGeneric Edit250
129F74H1054Invoiced Order Lines - Work7IOVR01ReferenceStringGeneric Edit250
130F74H1058Invoice Lines - SO Details8IOVR01ReferenceStringGeneric Edit250
131F74T100Check Additional Table5CAVR01ReferenceStringGeneric Edit250
132F59H0220CRM Case Tag File - Proposals16CCVR01ReferenceStringGeneric Edit250
TOP74R: CIS
133F74R4500Paymet Order Supplemental Data - RU - 04 - 74R7POVR01ReferenceStringGeneric Edit250
TOP75C: China - Reporting System Only
134F75C09Z1GUI cancel printing invoice-Jinsui - China4FFVR01ReferenceStringGeneric Edit250
TOP76A: Argentina
135F76A24Credit Invoice Information - Accounts Payable - ARG - - 76A20IEVR01ReferenceStringGeneric Edit250
136F76A30HEDI Batch Input Localization File - ARG - 04 - 76A8V6VR01ReferenceStringGeneric Edit250
137F76A411HAP Header Tag File - ARG - 04 - 76A8B0VR01ReferenceStringGeneric Edit250
138F76A411RVoucher Localization Purge Header File - ARG - 04 - 76A8B4VR01ReferenceStringGeneric Edit250
139F76A8011Supplier Information RG 726 - 049PAVR01ReferenceStringGeneric Edit250
140F76AUI04A/P Tag Legel Tax File - ARG - WF42WCVR01ReferenceStringGeneric Edit250
141F76AUI81Draft - Invoices Work File - ARG - 03B - 76A40WFVR01ReferenceStringGeneric Edit250
142F76AUI89Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A10WFVR01ReferenceStringGeneric Edit250
TOP76B: Brazil - Reporting System Only
143F7601BNota Fiscal Header - Brazil19FHVR01ReferenceStringGeneric Edit250
TOP76C: Colombia
144F76C0003VAT Certificates Retention - COL - 76C2CRVR01ReferenceStringGeneric Edit250
145F76C034AA/R Check Detail file As Of - COL - 76C104RZVR01ReferenceStringGeneric Edit250
TOP87: JDE Internal
146F87SARSAR/Object Cross Reference10WSVR01ReferenceStringGeneric Edit250
TOP89: Conversion Programs
147F43199ATemp F43199 for ERP 9.0 Upgrade33OLVR01ReferenceStringGeneric Edit250