JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

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
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

88 columns | Print definition?812 | VR02

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP13C: Condition-Base Maintenance
1F1310Condition-Based Alerts43CAVR02Reference 2StringGeneric Edit250
2F1310Z1Unedited Condition-Based Alerts57CBVR02Reference 2StringGeneric Edit250
TOP17: Customer Service Management
3F3111Z2Warranty Claim/Supplier Recovery processing122WPVR02Reference 2StringGeneric Edit250
4F31171Parts List - Extension24WSVR02Reference 2StringGeneric Edit250
5F31171SPurge Parts List - Extension24WSVR02Reference 2StringGeneric Edit250
6F4801Z2Warranty Claim/Supplier Recovery processing67WSVR02Reference 2StringGeneric Edit250
TOP31: Shop Floor Control
7F4801SPurge - Work Order Master file48WAVR02Reference 2StringGeneric Edit250
8F4801Z1Outbound Work Order Header67SYVR02Reference 2StringGeneric Edit250
TOP40: Inventory/OP Base
9F4001ZBatch Receiver File - Order Headings49SYVR02Reference 2StringGeneric Edit250
10F4011ZBatch Receiver File - Order Details48SZVR02Reference 2StringGeneric Edit250
11F4201Z1Sales Order Header Unedited Transaction File38SYVR02Reference 2StringGeneric Edit250
12F4211Z1Sales Order Detail Unedited Transaction File45SZVR02Reference 2StringGeneric Edit250
TOP42: Sales Management
13F4201Sales Order Header File25SHVR02Reference 2StringGeneric Edit250
14F42019Sales Order Header History File25SHVR02Reference 2StringGeneric Edit250
15F4211Sales Order Detail File32SDVR02Reference 2StringGeneric Edit250
16F42119Sales Order History File32SDVR02Reference 2StringGeneric Edit250
17F42199S.O. Detail Ledger File32SLVR02Reference 2StringGeneric Edit250
18F42UI01SO Header Cache File (MBF)30ZHVR02Reference 2StringGeneric Edit250
19F42UI11SO Detail Cache File (MBF)35ZDVR02Reference 2StringGeneric Edit250
TOP43: Procurement
20F4301Purchase Order Header24PHVR02Reference 2StringGeneric Edit250
21F4301ZPO Header Work File28PAVR02Reference 2StringGeneric Edit250
22F4301Z1Purchase Order Header Unedited Transaction Table37SYVR02Reference 2StringGeneric Edit250
23F43080Approvals Fields Constants42PDVR02Reference 2StringGeneric Edit250
24F4311Purchase Order Detail File34PDVR02Reference 2StringGeneric Edit250
25F4311ZPurchase Order Generator File38PWVR02Reference 2StringGeneric Edit250
26F4311Z1Purchase Order Detail Unedited Transaction Table47SZVR02Reference 2StringGeneric Edit250
27F43121Purchase Order Receiver File120PRVR02Reference 2StringGeneric Edit250
28F43121ZReceiver workfile140PWVR02Reference 2StringGeneric Edit250
29F43121Z1Receipts Unedited Transaction Table117SZVR02Reference 2StringGeneric Edit250
30F43199P.O. Detail Ledger File - Flexible Version34OLVR02Reference 2StringGeneric Edit250
31F4371Suggested Reorder Stock Items25PDVR02Reference 2StringGeneric Edit250
32F43UI50DPO Print Detail Work File52PWVR02Reference 2StringGeneric Edit250
33F43UI50HPO Print Header Work File43PAVR02Reference 2StringGeneric Edit250
TOP44H: Homebuilder Management
34F44H611Bid Details33BDVR02Reference 2StringGeneric Edit250
35F44H611WBid Details Work File37BWVR02Reference 2StringGeneric Edit250
36F44H711Lot Start Workfile41SWVR02Reference 2StringGeneric Edit250
37F44H711PAfter Start Purchasing30TPVR02Reference 2StringGeneric Edit250
38F44H711ZHB Lot Start Unedited Transaction File54SZVR02Reference 2StringGeneric Edit250
39F44H71W1Lot Start Generation Workfile41GWVR02Reference 2StringGeneric Edit250
40F44H73W1Lot Start - P.O. / Committment Generation Work File36CGVR02Reference 2StringGeneric Edit250
TOP47: Electronic Commerce
41F47011EDI Purchase Order Header - Inbound44SYVR02Reference 2StringGeneric Edit250
42F47012EDI Purchase Order Detail - Inbound48SZVR02Reference 2StringGeneric Edit250
43F47016EDI Purchase Order Header - Outbound39SYVR02Reference 2StringGeneric Edit250
44F47017EDI Purchase Order Detail - Outbound47SZVR02Reference 2StringGeneric Edit250
45F47021EDI P.O. Acknowledgment Header - Inbound39SYVR02Reference 2StringGeneric Edit250
46F47022EDI P.O. Acknowledgment Detail - Inbound47SZVR02Reference 2StringGeneric Edit250
47F47026EDI P.O. Acknowledgment Header - Outbound40SYVR02Reference 2StringGeneric Edit250
48F47027EDI P.O. Acknowledgment Detail - Outbound48SZVR02Reference 2StringGeneric Edit250
49F47031EDI Shipping Notice Header - Inbound37SYVR02Reference 2StringGeneric Edit250
50F47032EDI Shipping Notice Detail - Inbound46SZVR02Reference 2StringGeneric Edit250
51F47037EDI Shipping Notice Detail - Outbound48SZVR02Reference 2StringGeneric Edit250
52F470371EDI Shipping Notice Detail - Outbound53SZVR02Reference 2StringGeneric Edit250
53F47041EDI Invoice Header - Inbound54SYVR02Reference 2StringGeneric Edit250
54F47042EDI Invoice Detail - Inbound92SZVR02Reference 2StringGeneric Edit250
55F47046EDI Invoice Header (Sales) - Outbound40SYVR02Reference 2StringGeneric Edit250
56F47047EDI Invoice Detail (Sales) - Outbound48SZVR02Reference 2StringGeneric Edit250
57F47061EDI Planning Schedule Header - Inbound17MJVR02Reference 2StringGeneric Edit250
58F47066EDI Planning Schedule Header - Outbound17MJVR02Reference 2StringGeneric Edit250
59F47071EDI Receiving Advice Header - Inbound40SYVR02Reference 2StringGeneric Edit250
60F47072EDI Receiving Advice Detail - Inbound48SZVR02Reference 2StringGeneric Edit250
61F47076EDI Receiving Advice Header - Outbound40SYVR02Reference 2StringGeneric Edit250
62F47077EDI Receiving Advice Detail - Outbound48SZVR02Reference 2StringGeneric Edit250
63F47091EDI Request for Quote Header - Inbound44SYVR02Reference 2StringGeneric Edit250
64F47092EDI Request for Quote Detail - Inbound48SZVR02Reference 2StringGeneric Edit250
65F47096EDI Request for Quote Header - Outbound39SYVR02Reference 2StringGeneric Edit250
66F47097EDI Request for Quote Detail - Outbound47SZVR02Reference 2StringGeneric Edit250
67F47101EDI Response to RFQ Header - Inbound39SYVR02Reference 2StringGeneric Edit250
68F47102EDI Response to RFQ Detail - Inbound47SZVR02Reference 2StringGeneric Edit250
69F47106EDI Response to RFQ Header - Outbound40SYVR02Reference 2StringGeneric Edit250
70F47107EDI Response to RFQ Detail - Outbound48SZVR02Reference 2StringGeneric Edit250
71F47112EDI Lockbox Header - Transaction21Z2VR02Reference 2StringGeneric Edit250
72F47131EDI Purchase Order Change Header - Inbound41SYVR02Reference 2StringGeneric Edit250
73F47132EDI Purchase Order Change Detail - Inbound49SZVR02Reference 2StringGeneric Edit250
74F47136EDI Purchase Order Change Header - Outbound39SYVR02Reference 2StringGeneric Edit250
75F47137EDI Purchase Order Change Detail - Outbound48SZVR02Reference 2StringGeneric Edit250
76F47141EDI P.O. Change Acknowledgment Header - Inbound40SYVR02Reference 2StringGeneric Edit250
77F47142EDI P.O. Change Acknowledgment Detail - Inbound49SZVR02Reference 2StringGeneric Edit250
78F47146EDI P.O. Change Acknowledgment Header - Outbound41SYVR02Reference 2StringGeneric Edit250
79F47147EDI P.O. Change Acknowledgment Detail - Outbound50SZVR02Reference 2StringGeneric Edit250
80F47156EDI Shipping Schedule Header - Outbound41SYVR02Reference 2StringGeneric Edit250
81F47157EDI Shipping Schedule Detail - Outbound49SZVR02Reference 2StringGeneric Edit250
TOP48: Work Order Processing
82F4801Work Order Master File48WAVR02Reference 2StringGeneric Edit250
83F48UI001X4801 Master Business Function Workfile51WAVR02Reference 2StringGeneric Edit250
TOP55: Reserved for Clients
84F55IF421Sales Order per BO38SDVR02Reference 2StringGeneric Edit250
85F55IF425Sales Order per BO - 200538SDVR02Reference 2StringGeneric Edit250
86F55W0100Correction Invoice Print - WF133SDVR02Reference 2StringGeneric Edit250
TOP76C: Colombia
87F76C0003VAT Certificates Retention - COL - 76C3CRVR02Reference 2StringGeneric Edit250
TOP89: Conversion Programs
88F43199ATemp F43199 for ERP 9.0 Upgrade34OLVR02Reference 2StringGeneric Edit250