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

58 columns | Print definition?920 | WNUM

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP31: Shop Floor Control
1F3118Shortage Maintenance Master File7WNUMUnit of MeasureStringUDC20
TOP31B: Blend Management
2F31B02Staff Master37STWNUMBlend Mgmt NumericNumericGeneric Edit154
3F31B03Barrel Master Table109BMWNUMBlend Mgmt NumericNumericGeneric Edit154
4F31B032Barrel Types and Capacities19BTWNUMBlend Mgmt NumericNumericGeneric Edit154
5F31B033Current Barrel Segment Master10BSWNUMBlend Mgmt NumericNumericGeneric Edit154
6F31B05Equipment Master46EMWNUMBlend Mgmt NumericNumericGeneric Edit154
7F31B052Equipment Assignments21EAWNUMBlend Mgmt NumericNumericGeneric Edit154
8F31B053Consumable Assignments26CAWNUMBlend Mgmt NumericNumericGeneric Edit154
9F31B07EUR Master File37EUWNUMBlend Mgmt NumericNumericGeneric Edit154
10F31B0700Specification Master17SMWNUMBlend Mgmt NumericNumericGeneric Edit154
11F31B0701Specification Detail23SDWNUMBlend Mgmt NumericNumericGeneric Edit154
12F31B0702EUR Specifications16ESWNUMBlend Mgmt NumericNumericGeneric Edit154
13F31B0703Specification Wine Statuses18WSWNUMBlend Mgmt NumericNumericGeneric Edit154
14F31B0704Specification Version Detail24VDWNUMBlend Mgmt NumericNumericGeneric Edit154
15F31B0705Blend Named Calculation Version40BNWNUMBlend Mgmt NumericNumericGeneric Edit154
16F31B0710Harvest Assumptions26HAWNUMBlend Mgmt NumericNumericGeneric Edit154
17F31B0720Protocol Master27PMWNUMBlend Mgmt NumericNumericGeneric Edit154
18F31B0721EUR Protocols29EPWNUMBlend Mgmt NumericNumericGeneric Edit154
19F31B0730EUR Loss Assumptions19LAWNUMBlend Mgmt NumericNumericGeneric Edit154
20F31B0731EUR Wine Status Loss Assumptions19WSWNUMBlend Mgmt NumericNumericGeneric Edit154
21F31B0740Planning Assumptions50PAWNUMBlend Mgmt NumericNumericGeneric Edit154
22F31B0741EUR Cull and Cascade16CCWNUMBlend Mgmt NumericNumericGeneric Edit154
23F31B0750EUR Operation List Flag17OFWNUMBlend Mgmt NumericNumericGeneric Edit154
24F31B0751Operation List18OLWNUMBlend Mgmt NumericNumericGeneric Edit154
25F31B0760EUR Conversion Assumptions20CAWNUMBlend Mgmt NumericNumericGeneric Edit154
26F31B0770Brand Master28BMWNUMBlend Mgmt NumericNumericGeneric Edit154
27F31B0790Specification Validation37SVWNUMBlend Mgmt NumericNumericGeneric Edit154
28F31B08Tank Master88TMWNUMBlend Mgmt NumericNumericGeneric Edit154
29F31B104Named Calculation User Default Paths12DPWNUMBlend Mgmt NumericNumericGeneric Edit154
30F31B105Named Calculation Path Header14PHWNUMBlend Mgmt NumericNumericGeneric Edit154
31F31B106Named Calculation Path Detail10PDWNUMBlend Mgmt NumericNumericGeneric Edit154
32F31B107Named Calculation Format Header14FHWNUMBlend Mgmt NumericNumericGeneric Edit154
33F31B108Named Calculation Format Detail11FDWNUMBlend Mgmt NumericNumericGeneric Edit154
34F31B109Blend Named Calculation32NCWNUMBlend Mgmt NumericNumericGeneric Edit154
35F31B11Work Group Master22WGWNUMBlend Mgmt NumericNumericGeneric Edit154
36F31B110Mass Barrel Update99MBWNUMBlend Mgmt NumericNumericGeneric Edit154
37F31B114Trial Blend Header28TBWNUMBlend Mgmt NumericNumericGeneric Edit154
38F31B115Trial Blend Lot Details24BDWNUMBlend Mgmt NumericNumericGeneric Edit154
39F31B115WTrial Blend Input Lot Workfile73LWWNUMBlend Mgmt NumericNumericGeneric Edit154
40F31B116Temperature Conversion Chart Header13CHWNUMBlend Mgmt NumericNumericGeneric Edit154
41F31B117Temperature Conversion Chart Detail12CDWNUMBlend Mgmt NumericNumericGeneric Edit154
42F31B13Winery Constants32WCWNUMBlend Mgmt NumericNumericGeneric Edit154
43F31B130Container Master Table16CMWNUMBlend Mgmt NumericNumericGeneric Edit154
44F31B31Blend Lot Master77WLWNUMBlend Mgmt NumericNumericGeneric Edit154
45F31B45Additive Templates27ATWNUMBlend Mgmt NumericNumericGeneric Edit154
46F31B46Consumable Templates25CTWNUMBlend Mgmt NumericNumericGeneric Edit154
47F31B60Operation Trace Track Workfile89OTWNUMBlend Mgmt NumericNumericGeneric Edit154
48F31B65Operation Header50OHWNUMBlend Mgmt NumericNumericGeneric Edit154
49F31B66Blend Transactions36BTWNUMBlend Mgmt NumericNumericGeneric Edit154
50F31B70Operation Vessel Assignments29VAWNUMBlend Mgmt NumericNumericGeneric Edit154
51F31B73Base Operation Configuration.50BCWNUMBlend Mgmt NumericNumericGeneric Edit154
52F31B75Operation Configuration87OCWNUMBlend Mgmt NumericNumericGeneric Edit154
53F31B751Operation Configuration for Vessel Attributes77OAWNUMBlend Mgmt NumericNumericGeneric Edit154
54F31B91Bill Of Lading Master38BLWNUMBlend Mgmt NumericNumericGeneric Edit154
55F31B93Work Order Header28WHWNUMBlend Mgmt NumericNumericGeneric Edit154
56F31B97Human Resource Assignments13HRWNUMBlend Mgmt NumericNumericGeneric Edit154
57F31BSPZ1Sample Transactions27STWNUMBlend Mgmt NumericNumericGeneric Edit154
TOP37: Quality Management
58F3712Sample Detail24SDWNUMBlend Mgmt NumericNumericGeneric Edit154