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

92 columns | Print definition?920 | 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
TOP40: Inventory/OP Base
7F4001ZBatch Receiver File - Order Headings49SYVR02Reference 2StringGeneric Edit250
8F4011ZBatch Receiver File - Order Details48SZVR02Reference 2StringGeneric Edit250
9F4201Z1Sales Order Header Unedited Transaction File38SYVR02Reference 2StringGeneric Edit250
10F4211Z1Sales Order Detail Unedited Transaction File45SZVR02Reference 2StringGeneric Edit250
TOP41F: Apparel Management
11FCW65Work Order Header for Style Items49OFVR02Reference 2StringGeneric Edit250
TOP42: Sales Management
12F4201Sales Order Header File25SHVR02Reference 2StringGeneric Edit250
13F42019Sales Order Header History File25SHVR02Reference 2StringGeneric Edit250
14F4211Sales Order Detail File32SDVR02Reference 2StringGeneric Edit250
15F42119Sales Order History File32SDVR02Reference 2StringGeneric Edit250
16F42199S.O. Detail Ledger File32SLVR02Reference 2StringGeneric Edit250
17F42UI01SO Header Cache File (MBF)30ZHVR02Reference 2StringGeneric Edit250
18F42UI11SO Detail Cache File (MBF)35ZDVR02Reference 2StringGeneric Edit250
TOP43: Procurement
19F4301Purchase Order Header24PHVR02Reference 2StringGeneric Edit250
20F4301ZPO Header Work File28PAVR02Reference 2StringGeneric Edit250
21F4301Z1Purchase Order Header Unedited Transaction Table37SYVR02Reference 2StringGeneric Edit250
22F43080Approvals Fields Constants42PDVR02Reference 2StringGeneric Edit250
23F4311Purchase Order Detail File34PDVR02Reference 2StringGeneric Edit250
24F4311ZPurchase Order Generator File38PWVR02Reference 2StringGeneric Edit250
25F4311Z1Purchase Order Detail Unedited Transaction Table47SZVR02Reference 2StringGeneric Edit250
26F43121Purchase Order Receiver File120PRVR02Reference 2StringGeneric Edit250
27F43121ZReceiver workfile140PWVR02Reference 2StringGeneric Edit250
28F43121Z1Receipts Unedited Transaction Table117SZVR02Reference 2StringGeneric Edit250
29F43199P.O. Detail Ledger File - Flexible Version34OLVR02Reference 2StringGeneric Edit250
30F4371Suggested Reorder Stock Items25PDVR02Reference 2StringGeneric Edit250
31F43UI50DPO Print Detail Work File52PWVR02Reference 2StringGeneric Edit250
32F43UI50HPO Print Header Work File43PAVR02Reference 2StringGeneric Edit250
TOP44H: Homebuilder Management
33F44H611Bid Details33BDVR02Reference 2StringGeneric Edit250
34F44H611WBid Details Work File37BWVR02Reference 2StringGeneric Edit250
35F44H711Lot Start Workfile41SWVR02Reference 2StringGeneric Edit250
36F44H711PAfter Start Purchasing30TPVR02Reference 2StringGeneric Edit250
37F44H711ZHB Lot Start Unedited Transaction File54SZVR02Reference 2StringGeneric Edit250
38F44H71W1Lot Start Generation Workfile41GWVR02Reference 2StringGeneric Edit250
39F44H73W1Lot Start - P.O. / Committment Generation Work File36CGVR02Reference 2StringGeneric Edit250
TOP47: Electronic Commerce
40F47011EDI Purchase Order Header - Inbound44SYVR02Reference 2StringGeneric Edit250
41F47012EDI Purchase Order Detail - Inbound48SZVR02Reference 2StringGeneric Edit250
42F47016EDI Purchase Order Header - Outbound39SYVR02Reference 2StringGeneric Edit250
43F47017EDI Purchase Order Detail - Outbound47SZVR02Reference 2StringGeneric Edit250
44F47021EDI P.O. Acknowledgment Header - Inbound39SYVR02Reference 2StringGeneric Edit250
45F47022EDI P.O. Acknowledgment Detail - Inbound47SZVR02Reference 2StringGeneric Edit250
46F47026EDI P.O. Acknowledgment Header - Outbound40SYVR02Reference 2StringGeneric Edit250
47F47027EDI P.O. Acknowledgment Detail - Outbound48SZVR02Reference 2StringGeneric Edit250
48F47031EDI Shipping Notice Header - Inbound37SYVR02Reference 2StringGeneric Edit250
49F47032EDI Shipping Notice Detail - Inbound46SZVR02Reference 2StringGeneric Edit250
50F47037EDI Shipping Notice Detail - Outbound48SZVR02Reference 2StringGeneric Edit250
51F470371EDI Shipping Notice Detail - Outbound53SZVR02Reference 2StringGeneric Edit250
52F47041EDI Invoice Header - Inbound54SYVR02Reference 2StringGeneric Edit250
53F47042EDI Invoice Detail - Inbound92SZVR02Reference 2StringGeneric Edit250
54F47046EDI Invoice Header (Sales) - Outbound40SYVR02Reference 2StringGeneric Edit250
55F47047EDI Invoice Detail (Sales) - Outbound48SZVR02Reference 2StringGeneric Edit250
56F47061EDI Planning Schedule Header - Inbound17MJVR02Reference 2StringGeneric Edit250
57F47066EDI Planning Schedule Header - Outbound17MJVR02Reference 2StringGeneric Edit250
58F47071EDI Receiving Advice Header - Inbound40SYVR02Reference 2StringGeneric Edit250
59F47072EDI Receiving Advice Detail - Inbound48SZVR02Reference 2StringGeneric Edit250
60F47076EDI Receiving Advice Header - Outbound40SYVR02Reference 2StringGeneric Edit250
61F47077EDI Receiving Advice Detail - Outbound48SZVR02Reference 2StringGeneric Edit250
62F47091EDI Request for Quote Header - Inbound44SYVR02Reference 2StringGeneric Edit250
63F47092EDI Request for Quote Detail - Inbound48SZVR02Reference 2StringGeneric Edit250
64F47096EDI Request for Quote Header - Outbound39SYVR02Reference 2StringGeneric Edit250
65F47097EDI Request for Quote Detail - Outbound47SZVR02Reference 2StringGeneric Edit250
66F47101EDI Response to RFQ Header - Inbound39SYVR02Reference 2StringGeneric Edit250
67F47102EDI Response to RFQ Detail - Inbound47SZVR02Reference 2StringGeneric Edit250
68F47106EDI Response to RFQ Header - Outbound40SYVR02Reference 2StringGeneric Edit250
69F47107EDI Response to RFQ Detail - Outbound48SZVR02Reference 2StringGeneric Edit250
70F47112EDI Lockbox Header - Transaction21Z2VR02Reference 2StringGeneric Edit250
71F47131EDI Purchase Order Change Header - Inbound41SYVR02Reference 2StringGeneric Edit250
72F47132EDI Purchase Order Change Detail - Inbound49SZVR02Reference 2StringGeneric Edit250
73F47136EDI Purchase Order Change Header - Outbound39SYVR02Reference 2StringGeneric Edit250
74F47137EDI Purchase Order Change Detail - Outbound48SZVR02Reference 2StringGeneric Edit250
75F47141EDI P.O. Change Acknowledgment Header - Inbound40SYVR02Reference 2StringGeneric Edit250
76F47142EDI P.O. Change Acknowledgment Detail - Inbound49SZVR02Reference 2StringGeneric Edit250
77F47146EDI P.O. Change Acknowledgment Header - Outbound41SYVR02Reference 2StringGeneric Edit250
78F47147EDI P.O. Change Acknowledgment Detail - Outbound50SZVR02Reference 2StringGeneric Edit250
79F47156EDI Shipping Schedule Header - Outbound41SYVR02Reference 2StringGeneric Edit250
80F47157EDI Shipping Schedule Detail - Outbound49SZVR02Reference 2StringGeneric Edit250
TOP48: Work Order Processing
81F4801Work Order Master File48WAVR02Reference 2StringGeneric Edit250
82F4801SPurge - Work Order Master file48WAVR02Reference 2StringGeneric Edit250
83F4801Z1Outbound Work Order Header67SYVR02Reference 2StringGeneric Edit250
84F48UI001X4801 Master Business Function Workfile51WAVR02Reference 2StringGeneric Edit250
TOP49: Transportation Management
85F49T10Sales Order Release Staging Table37ORVR02Reference 2StringGeneric Edit250
86F49T100Procurement Freight Request staging table24OBVR02Reference 2StringGeneric Edit250
TOP54R: Rental Management
87F54R099Rental Contract Header Ledger42HLVR02Reference 2StringGeneric Edit250
88F54R10Rental Contract Header40CHVR02Reference 2StringGeneric Edit250
89F54R11Rental Contract Detail53CDVR02Reference 2StringGeneric Edit250
90F54R199Rental Contract Detail Ledger49DLVR02Reference 2StringGeneric Edit250
TOP76C: Colombia
91F76C0003VAT Certificates Retention - COL - 76C3CRVR02Reference 2StringGeneric Edit250
TOP89: Conversion Programs
92F43199ATemp F43199 for ERP 9.0 Upgrade34OLVR02Reference 2StringGeneric Edit250