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
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
4F0411RPAccounts Payable Ledger
5F4311PDPurchase Order Detail File
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

50 columns | Print definition?812 | MCUS

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006Business Unit Master95MCMCUSBusiness Unit - SubsequentStringGeneric Edit120
2F0006SDate Effective Business Unit Master97MCMCUSBusiness Unit - SubsequentStringGeneric Edit120
3F0006Z1Cost Center Unedited Transaction Table108SZMCUSBusiness Unit - SubsequentStringGeneric Edit120
4F1501Tenant/Lease Master29NEMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP15: Property Management
5F15013Sales Overage Master37NOMCUSBusiness Unit - SubsequentStringGeneric Edit120
6F15013BSales Overage Master File18NOMCUSBusiness Unit - SubsequentStringGeneric Edit120
7F15014Product Scales Master8NPMCUSBusiness Unit - SubsequentStringGeneric Edit120
8F15014BProduct Scales Master30NPMCUSBusiness Unit - SubsequentStringGeneric Edit120
9F15017Lease Master Detail File7NWMCUSBusiness Unit - SubsequentStringGeneric Edit120
10F1506Floor Master File1OPMCUSBusiness Unit - SubsequentStringGeneric Edit120
11F1507Unit Master File1NHMCUSBusiness Unit - SubsequentStringGeneric Edit120
12F1511Tenant/Lease Billings Detail8NJMCUSBusiness Unit - SubsequentStringGeneric Edit120
13F1511BTenant/Lease Billings Detail Master8NJMCUSBusiness Unit - SubsequentStringGeneric Edit120
14F1511HTenant/Lease Billings Detail History8N#MCUSBusiness Unit - SubsequentStringGeneric Edit120
15F1511HBTenant/Lease Billings Detail History8NCMCUSBusiness Unit - SubsequentStringGeneric Edit120
16F15141Gross Lease Occupied Areas1NCMCUSBusiness Unit - SubsequentStringGeneric Edit120
17F1540Sales Report Control File16NRMCUSBusiness Unit - SubsequentStringGeneric Edit120
18F1540BSales Report Control File32NRMCUSBusiness Unit - SubsequentStringGeneric Edit120
19F1541Tenant Sales History10N8MCUSBusiness Unit - SubsequentStringGeneric Edit120
20F15410Tenant Weekly Sales File12N9MCUSBusiness Unit - SubsequentStringGeneric Edit120
21F1541BTenant Sales History File11N8MCUSBusiness Unit - SubsequentStringGeneric Edit120
22F1541BWSales History Work File3OWMCUSBusiness Unit - SubsequentStringGeneric Edit120
23F1542Projected Sales12OJMCUSBusiness Unit - SubsequentStringGeneric Edit120
24F1543BTenant Sales Analysis Reporting File10OAMCUSBusiness Unit - SubsequentStringGeneric Edit120
25F1547Sales Seasonality1OIMCUSBusiness Unit - SubsequentStringGeneric Edit120
26F1549Seasonality Models1OLMCUSBusiness Unit - SubsequentStringGeneric Edit120
27F15702Legal Clause Space Detail5NFMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP15L: Adv Real Estate Forecasting
28F15L101AREF Unit Master4UMMCUSBusiness Unit - SubsequentStringGeneric Edit120
29F15L141AREF Gross Lease Occupied Area1GLMCUSBusiness Unit - SubsequentStringGeneric Edit120
30F15L301AREF Projected Sales12PSMCUSBusiness Unit - SubsequentStringGeneric Edit120
31F15L302AREF Prior Gross Billings19PGMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP17: Customer Service Management
32F1720Contract Header22CHMCUSBusiness Unit - SubsequentStringGeneric Edit120
33F1721Contract Detail16CDMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP31P: Engineer To Order
34F31P01Project Attributes16PAMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP42: Sales Management
35F42565Invoice Print File111IWMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP44H: Homebuilder Management
36F4450Lot Proceed Header (World)1JDMCUSBusiness Unit - SubsequentStringGeneric Edit120
37F4451Lot Proceed Detail (World)1JFMCUSBusiness Unit - SubsequentStringGeneric Edit120
38F4452Plan Master (World)10JAMCUSBusiness Unit - SubsequentStringGeneric Edit120
39F4453Lot Master (World)1JBMCUSBusiness Unit - SubsequentStringGeneric Edit120
40F4454Vendor Assignment (World)1JGMCUSBusiness Unit - SubsequentStringGeneric Edit120
41F4456Lot Proceed Entry (World)1JIMCUSBusiness Unit - SubsequentStringGeneric Edit120
42F4461Option Master (World)1JNMCUSBusiness Unit - SubsequentStringGeneric Edit120
43F44H712Lot Start Workfile Takeoff Detail8STMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP52: Contract Billing
44F5201Contract Master File26G4MCUSBusiness Unit - SubsequentStringGeneric Edit120
45F5202Contract Billing Line Detail16G6MCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP53: Change Management
46F5302F5302 World Specs11DKMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP76A: Argentina
47F76A394Adjustments - 76A11C4MCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP76B: Brazil - Reporting System Only
48F76B10Account Ledger - IN68 - 099ARMCUSBusiness Unit - SubsequentStringGeneric Edit120
49F76B50Item Ledger Table - IN68 - 4219CEMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP76H: Chile
50F76H6205Item Replacement Cost - CHI - 4110IRMCUSBusiness Unit - SubsequentStringGeneric Edit120