JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

52 columns | Print definition?910 | EMCU

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F004201Prepayment Transaction Table42PTEMCUBusiness Unit - HeaderStringGeneric Edit120
TOP32: Configuration Management
2F3201Configurator Master Table11CMEMCUBusiness Unit - HeaderStringGeneric Edit120
3F32019Configurator Master History Table11CHEMCUBusiness Unit - HeaderStringGeneric Edit120
4F3292Cross Segment Editing Rules11KUEMCUBusiness Unit - HeaderStringGeneric Edit120
5F3293Assembly Inclusions Rules16KYEMCUBusiness Unit - HeaderStringGeneric Edit120
TOP40: Inventory/OP Base
6F4011ZBatch Receiver File - Order Details64SZEMCUBusiness Unit - HeaderStringGeneric Edit120
7F40303Preference Profile - Revenue Cost Center12RVEMCUBusiness Unit - HeaderStringGeneric Edit120
8F40303RPreference Resolution Ledger - Revenue Business Unit14RVEMCUBusiness Unit - HeaderStringGeneric Edit120
9F40349Preference Profile - Revenue Business Unit (Branch)16RVEMCUBusiness Unit - HeaderStringGeneric Edit120
10F40349RPreference Resolution Ledger - Revenue Bus Unit (Branch)18RVEMCUBusiness Unit - HeaderStringGeneric Edit120
11F4211AUSales Order Detail Audit File8AUEMCUBusiness Unit - HeaderStringGeneric Edit120
12F4211Z1Sales Order Detail Unedited Transaction File61SZEMCUBusiness Unit - HeaderStringGeneric Edit120
TOP42: Sales Management
13F4211Sales Order Detail File48SDEMCUBusiness Unit - HeaderStringGeneric Edit120
14F42119Sales Order History File48SDEMCUBusiness Unit - HeaderStringGeneric Edit120
15F42199S.O. Detail Ledger File48SLEMCUBusiness Unit - HeaderStringGeneric Edit120
16F42565Invoice Print File99IWEMCUBusiness Unit - HeaderStringGeneric Edit120
17F42UI12Sales Order Detail Cache 2 (MBF)14ZDEMCUBusiness Unit - HeaderStringGeneric Edit120
18F42UI521Pick Slips Detail File44S9EMCUBusiness Unit - HeaderStringGeneric Edit120
19F42UI800Sales Detail Work File - Sales Update11SDEMCUBusiness Unit - HeaderStringGeneric Edit120
20F470371TTag for F470371- EDI shipping Notice Detail - Outbound94UZEMCUBusiness Unit - HeaderStringGeneric Edit120
TOP42B: Sales Order Entry
21F42420Audit Log Transaction55ALEMCUBusiness Unit - HeaderStringGeneric Edit120
TOP45: Advanced Pricing
22F4575Ship and Debit History57AHEMCUBusiness Unit - HeaderStringGeneric Edit120
23F4575TMPShip and Debit History - Temp Table57AHEMCUBusiness Unit - HeaderStringGeneric Edit120
24F4576Ship and Debit Claims85ACEMCUBusiness Unit - HeaderStringGeneric Edit120
25F4576TMPShip and Debit Claims- Temp Table85ACEMCUBusiness Unit - HeaderStringGeneric Edit120
26F4576Z1Ship and Debit Claims Unedited Transaction Table82Z1EMCUBusiness Unit - HeaderStringGeneric Edit120
TOP47: Electronic Commerce
27F47012EDI Purchase Order Detail - Inbound65SZEMCUBusiness Unit - HeaderStringGeneric Edit120
28F47027EDI P.O. Acknowledgment Detail - Outbound65SZEMCUBusiness Unit - HeaderStringGeneric Edit120
29F47037EDI Shipping Notice Detail - Outbound65SZEMCUBusiness Unit - HeaderStringGeneric Edit120
30F470371EDI Shipping Notice Detail - Outbound73SZEMCUBusiness Unit - HeaderStringGeneric Edit120
31F47047EDI Invoice Detail (Sales) - Outbound65SZEMCUBusiness Unit - HeaderStringGeneric Edit120
32F47092EDI Request for Quote Detail - Inbound65SZEMCUBusiness Unit - HeaderStringGeneric Edit120
33F47107EDI Response to RFQ Detail - Outbound65SZEMCUBusiness Unit - HeaderStringGeneric Edit120
34F47132EDI Purchase Order Change Detail - Inbound66SZEMCUBusiness Unit - HeaderStringGeneric Edit120
35F47147EDI P.O. Change Acknowledgment Detail - Outbound67SZEMCUBusiness Unit - HeaderStringGeneric Edit120
TOP49: Transportation Management
36F49110Transportation Bill of Lading Workfile30BWEMCUBusiness Unit - HeaderStringGeneric Edit120
37F49130Shipment Document Workfile34BWEMCUBusiness Unit - HeaderStringGeneric Edit120
38F49141Packing List Workfile15PWEMCUBusiness Unit - HeaderStringGeneric Edit120
39F49160Document Next Number2NNEMCUBusiness Unit - HeaderStringGeneric Edit120
40F49197Depot Document Print Set Up (Conversion from World File)12OQEMCUBusiness Unit - HeaderStringGeneric Edit120
41F49198Depot Document Print Setup14OQEMCUBusiness Unit - HeaderStringGeneric Edit120
42F49592Document Print Batch Document Header11DHEMCUBusiness Unit - HeaderStringGeneric Edit120
43F49594Document Print - Document Detail15DIEMCUBusiness Unit - HeaderStringGeneric Edit120
44F49595Document Print - Document Summary4DKEMCUBusiness Unit - HeaderStringGeneric Edit120
45F49695Document Register2DREMCUBusiness Unit - HeaderStringGeneric Edit120
46F49696Document Register Detail2DJEMCUBusiness Unit - HeaderStringGeneric Edit120
47F49697Document Register Summary2DNEMCUBusiness Unit - HeaderStringGeneric Edit120
TOP80D: Plant Manager Dashboard
48F80D010Sales Order Fact8SFEMCUBusiness Unit - HeaderStringGeneric Edit120
49F80D240Booked Orders Aggregate2BOEMCUBusiness Unit - HeaderStringGeneric Edit120
50F80D241Shipped Orders Aggregate2SOEMCUBusiness Unit - HeaderStringGeneric Edit120
51F80D242Projected Revenue Aggregate2PREMCUBusiness Unit - HeaderStringGeneric Edit120
52F80D243Backlog Aggregate2BCEMCUBusiness Unit - HeaderStringGeneric Edit120