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
3F9671SDSoftware Update Detail Table
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F41021LIItem Location File
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
7F03B11RPCustomer Ledger
8F4311PDPurchase Order Detail File
9F4111ILItem Ledger File
10F0411RPAccounts Payable Ledger

812: Top 10 requests

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

57 columns | Print definition?920 | WCD

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP31B: Blend Management
1F31B02Staff Master35STWCDBlend Mgmt CodeStringGeneric Edit30
2F31B03Barrel Master Table107BMWCDBlend Mgmt CodeStringGeneric Edit30
3F31B032Barrel Types and Capacities17BTWCDBlend Mgmt CodeStringGeneric Edit30
4F31B033Current Barrel Segment Master12BSWCDBlend Mgmt CodeStringGeneric Edit30
5F31B05Equipment Master44EMWCDBlend Mgmt CodeStringGeneric Edit30
6F31B052Equipment Assignments19EAWCDBlend Mgmt CodeStringGeneric Edit30
7F31B053Consumable Assignments24CAWCDBlend Mgmt CodeStringGeneric Edit30
8F31B07EUR Master File35EUWCDBlend Mgmt CodeStringGeneric Edit30
9F31B0700Specification Master15SMWCDBlend Mgmt CodeStringGeneric Edit30
10F31B0701Specification Detail21SDWCDBlend Mgmt CodeStringGeneric Edit30
11F31B0702EUR Specifications14ESWCDBlend Mgmt CodeStringGeneric Edit30
12F31B0703Specification Wine Statuses16WSWCDBlend Mgmt CodeStringGeneric Edit30
13F31B0704Specification Version Detail22VDWCDBlend Mgmt CodeStringGeneric Edit30
14F31B0705Blend Named Calculation Version38BNWCDBlend Mgmt CodeStringGeneric Edit30
15F31B0710Harvest Assumptions24HAWCDBlend Mgmt CodeStringGeneric Edit30
16F31B0720Protocol Master25PMWCDBlend Mgmt CodeStringGeneric Edit30
17F31B0721EUR Protocols27EPWCDBlend Mgmt CodeStringGeneric Edit30
18F31B0730EUR Loss Assumptions17LAWCDBlend Mgmt CodeStringGeneric Edit30
19F31B0731EUR Wine Status Loss Assumptions17WSWCDBlend Mgmt CodeStringGeneric Edit30
20F31B0740Planning Assumptions48PAWCDBlend Mgmt CodeStringGeneric Edit30
21F31B0741EUR Cull and Cascade14CCWCDBlend Mgmt CodeStringGeneric Edit30
22F31B0750EUR Operation List Flag15OFWCDBlend Mgmt CodeStringGeneric Edit30
23F31B0751Operation List16OLWCDBlend Mgmt CodeStringGeneric Edit30
24F31B0760EUR Conversion Assumptions18CAWCDBlend Mgmt CodeStringGeneric Edit30
25F31B0770Brand Master26BMWCDBlend Mgmt CodeStringGeneric Edit30
26F31B0790Specification Validation35SVWCDBlend Mgmt CodeStringGeneric Edit30
27F31B08Tank Master86TMWCDBlend Mgmt CodeStringGeneric Edit30
28F31B104Named Calculation User Default Paths13DPWCDBlend Mgmt CodeStringGeneric Edit30
29F31B105Named Calculation Path Header15PHWCDBlend Mgmt CodeStringGeneric Edit30
30F31B106Named Calculation Path Detail11PDWCDBlend Mgmt CodeStringGeneric Edit30
31F31B107Named Calculation Format Header15FHWCDBlend Mgmt CodeStringGeneric Edit30
32F31B108Named Calculation Format Detail12FDWCDBlend Mgmt CodeStringGeneric Edit30
33F31B109Blend Named Calculation33NCWCDBlend Mgmt CodeStringGeneric Edit30
34F31B11Work Group Master20WGWCDBlend Mgmt CodeStringGeneric Edit30
35F31B110Mass Barrel Update93MBWCDBlend Mgmt CodeStringGeneric Edit30
36F31B114Trial Blend Header29TBWCDBlend Mgmt CodeStringGeneric Edit30
37F31B115Trial Blend Lot Details25BDWCDBlend Mgmt CodeStringGeneric Edit30
38F31B115WTrial Blend Input Lot Workfile74LWWCDBlend Mgmt CodeStringGeneric Edit30
39F31B116Temperature Conversion Chart Header14CHWCDBlend Mgmt CodeStringGeneric Edit30
40F31B117Temperature Conversion Chart Detail13CDWCDBlend Mgmt CodeStringGeneric Edit30
41F31B13Winery Constants30WCWCDBlend Mgmt CodeStringGeneric Edit30
42F31B130Container Master Table13CMWCDBlend Mgmt CodeStringGeneric Edit30
43F31B31Blend Lot Master75WLWCDBlend Mgmt CodeStringGeneric Edit30
44F31B45Additive Templates25ATWCDBlend Mgmt CodeStringGeneric Edit30
45F31B46Consumable Templates23CTWCDBlend Mgmt CodeStringGeneric Edit30
46F31B60Operation Trace Track Workfile87OTWCDBlend Mgmt CodeStringGeneric Edit30
47F31B65Operation Header51OHWCDBlend Mgmt CodeStringGeneric Edit30
48F31B66Blend Transactions37BTWCDBlend Mgmt CodeStringGeneric Edit30
49F31B70Operation Vessel Assignments27VAWCDBlend Mgmt CodeStringGeneric Edit30
50F31B73Base Operation Configuration.48BCWCDBlend Mgmt CodeStringGeneric Edit30
51F31B75Operation Configuration90OCWCDBlend Mgmt CodeStringGeneric Edit30
52F31B751Operation Configuration for Vessel Attributes75OAWCDBlend Mgmt CodeStringGeneric Edit30
53F31B91Bill Of Lading Master40BLWCDBlend Mgmt CodeStringGeneric Edit30
54F31B93Work Order Header30WHWCDBlend Mgmt CodeStringGeneric Edit30
55F31B97Human Resource Assignments14HRWCDBlend Mgmt CodeStringGeneric Edit30
56F31BSPZ1Sample Transactions29STWCDBlend Mgmt CodeStringGeneric Edit30
TOP37: Quality Management
57F3712Sample Detail26SDWCDBlend Mgmt CodeStringGeneric Edit30