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
10F4111ILItem Ledger File

812: Top 10 requests

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

64 columns | Print definition?920 | 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
4F0006Z2Business Unit Master Z File108SZMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP15: Real Estate Management
5F1501Tenant/Lease Master29NEMCUSBusiness Unit - SubsequentStringGeneric Edit120
6F150122AShare Factor Denominator Audit5SAMCUSBusiness Unit - SubsequentStringGeneric Edit120
7F15013Sales Overage Master37NOMCUSBusiness Unit - SubsequentStringGeneric Edit120
8F15013BSales Overage Master File18NOMCUSBusiness Unit - SubsequentStringGeneric Edit120
9F15014Product Scales Master8NPMCUSBusiness Unit - SubsequentStringGeneric Edit120
10F15014BProduct Scales Master30NPMCUSBusiness Unit - SubsequentStringGeneric Edit120
11F15017Lease Master Detail7NWMCUSBusiness Unit - SubsequentStringGeneric Edit120
12F1506Floor Master1OPMCUSBusiness Unit - SubsequentStringGeneric Edit120
13F1507Unit Master1NHMCUSBusiness Unit - SubsequentStringGeneric Edit120
14F1511Tenant/Lease Billings Detail8NJMCUSBusiness Unit - SubsequentStringGeneric Edit120
15F1511BLease Billings Master8NJMCUSBusiness Unit - SubsequentStringGeneric Edit120
16F1511HTenant/Lease Billings Detail History8N#MCUSBusiness Unit - SubsequentStringGeneric Edit120
17F1511HBLease Billings History8NCMCUSBusiness Unit - SubsequentStringGeneric Edit120
18F15141Gross Lease Occupied Areas1NCMCUSBusiness Unit - SubsequentStringGeneric Edit120
19F1540Sales Report Control File16NRMCUSBusiness Unit - SubsequentStringGeneric Edit120
20F1540BSales Report Control32NRMCUSBusiness Unit - SubsequentStringGeneric Edit120
21F1541Tenant Sales History10N8MCUSBusiness Unit - SubsequentStringGeneric Edit120
22F15410Tenant Weekly Sales12N9MCUSBusiness Unit - SubsequentStringGeneric Edit120
23F1541BTenant Sales History11N8MCUSBusiness Unit - SubsequentStringGeneric Edit120
24F1541BWSales History Work File3OWMCUSBusiness Unit - SubsequentStringGeneric Edit120
25F1542Projected Sales12OJMCUSBusiness Unit - SubsequentStringGeneric Edit120
26F1543BTenant Sales Analysis Reporting File10OAMCUSBusiness Unit - SubsequentStringGeneric Edit120
27F1547Sales Seasonality1OIMCUSBusiness Unit - SubsequentStringGeneric Edit120
28F1549Seasonality Models1OLMCUSBusiness Unit - SubsequentStringGeneric Edit120
29F15702Legal Clause Space Detail5NFMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP15L: Adv Real Estate Forecasting
30F15L101AREF Unit Master4UMMCUSBusiness Unit - SubsequentStringGeneric Edit120
31F15L141AREF Gross Lease Occupied Area1GLMCUSBusiness Unit - SubsequentStringGeneric Edit120
32F15L301AREF Projected Sales12PSMCUSBusiness Unit - SubsequentStringGeneric Edit120
33F15L302AREF Prior Gross Billings19PGMCUSBusiness Unit - SubsequentStringGeneric Edit120
34F15L401AREF Share Factor Denominator Audit6SFMCUSBusiness Unit - SubsequentStringGeneric Edit120
35F15L402AREF Tenant Exclusion Rule Audit4SGMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP17: Customer Service Management
36F1720Contract Header22CHMCUSBusiness Unit - SubsequentStringGeneric Edit120
37F1721Contract Detail16CDMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP31P: Engineer To Order
38F31P01Project Attributes16PAMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP42: Sales Management
39F42565Invoice Print File111IWMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP44H: Homebuilder Management
40F4450Lot Proceed Header (World)1JDMCUSBusiness Unit - SubsequentStringGeneric Edit120
41F4451Lot Proceed Detail (World)1JFMCUSBusiness Unit - SubsequentStringGeneric Edit120
42F4452Plan Master (World)10JAMCUSBusiness Unit - SubsequentStringGeneric Edit120
43F4453Lot Master (World)1JBMCUSBusiness Unit - SubsequentStringGeneric Edit120
44F4454Vendor Assignment (World)1JGMCUSBusiness Unit - SubsequentStringGeneric Edit120
45F4456Lot Proceed Entry (World)1JIMCUSBusiness Unit - SubsequentStringGeneric Edit120
46F4461Option Master (World)1JNMCUSBusiness Unit - SubsequentStringGeneric Edit120
47F44H712Lot Start Workfile Takeoff Detail8STMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP48S: Service Billing
48F48426Service Billing Trigger Configuration4STMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP51X: In-Memory Project Management
49F51X10Project Advisor Console Worktable12EXMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP52: Contract Billing
50F5201Contract Master26G4MCUSBusiness Unit - SubsequentStringGeneric Edit120
51F5202Contract Billing Line Detail16G6MCUSBusiness Unit - SubsequentStringGeneric Edit120
52F52425Contract Billing Trigger Configuration5TKMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP52G: Proj & Gov Contract Accounting
53F52G01MAdvanced Contracts Modifications31CMMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP53: Change Management
54F5302F5302 World Specs11DKMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP54HS: Health & Safety Incident Mgt
55F54HS01Incident Master26S1MCUSBusiness Unit - SubsequentStringGeneric Edit120
56F54HS01MIncident Master Change History29I1MCUSBusiness Unit - SubsequentStringGeneric Edit120
57F54HS20Safety Hours4SHMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP74U: United Kingdom Localizations
58F74U0412Application Commitment Workfile - UK - 438ACMCUSBusiness Unit - SubsequentStringGeneric Edit120
59F74U0414Certificate Commitment Workfile - UK - 438CCMCUSBusiness Unit - SubsequentStringGeneric Edit120
60F74U0416Purchase Order Commitment Workfile - UK - 438PCMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP76A: Argentina
61F76A394Adjustments - 76A11C4MCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP76B: Brazil
62F76B10Account Ledger - IN68 - 099ARMCUSBusiness Unit - SubsequentStringGeneric Edit120
63F76B50Item Ledger Table - IN68 - 4219CEMCUSBusiness Unit - SubsequentStringGeneric Edit120
TOP76H: Chile
64F76H6205Item Replacement Cost - CHI - 4110IRMCUSBusiness Unit - SubsequentStringGeneric Edit120