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

112 columns | Print definition?920 | ENTJ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP15: Real Estate Management
1F150120Tenant Exclusion Header13NWENTJDate - EnteredDateGeneric Edit60
2F150120DTenant Exclusion - Alternate Description10NWENTJDate - EnteredDateGeneric Edit60
3F150121Tenant Exclusion Detail13NXENTJDate - EnteredDateGeneric Edit60
4F150122Share Factor Denominator Header15NYENTJDate - EnteredDateGeneric Edit60
5F150122AShare Factor Denominator Audit23SAENTJDate - EnteredDateGeneric Edit60
6F150122DShare Factor Denominator - Alternate Description10NYENTJDate - EnteredDateGeneric Edit60
7F150123Share Factor Denominator Detail13NZENTJDate - EnteredDateGeneric Edit60
8F15012BTenant E.P. Class Master84NSENTJDate - EnteredDateGeneric Edit60
9F15013BSales Overage Master File85NOENTJDate - EnteredDateGeneric Edit60
10F15014BProduct Scales Master49NPENTJDate - EnteredDateGeneric Edit60
11F15015BMin/Max Rents And Recoveries Master50NQENTJDate - EnteredDateGeneric Edit60
12F15016BTenant Escalation Master80NUENTJDate - EnteredDateGeneric Edit60
13F15017Lease Master Detail53NWENTJDate - EnteredDateGeneric Edit60
14F15019DBilling Frequency - Alternate Description10NLENTJDate - EnteredDateGeneric Edit60
15F1501BLease Master Header56NEENTJDate - EnteredDateGeneric Edit60
16F1501BDLease Master Header - Alternate Description11NEENTJDate - EnteredDateGeneric Edit60
17F15020Extended Billings Master61NNENTJDate - EnteredDateGeneric Edit60
18F1502BRecurring Billings Master80NFENTJDate - EnteredDateGeneric Edit60
19F1502BDRecurring Billings Master - Alternate Description11NFENTJDate - EnteredDateGeneric Edit60
20F1506DFloor Master - Alternate Description13OPENTJDate - EnteredDateGeneric Edit60
21F1507DUnit Master - Alternate Description15NHENTJDate - EnteredDateGeneric Edit60
22F1510BReal Estate Management Constants42OEENTJDate - EnteredDateGeneric Edit60
23F1512DBilling Code Extension - Alternate Description11NAENTJDate - EnteredDateGeneric Edit60
24F1513BFASB 13 Lease Control65O3ENTJDate - EnteredDateGeneric Edit60
25F1514Area Master24NWENTJDate - EnteredDateGeneric Edit60
26F15142Area Definitions25NVENTJDate - EnteredDateGeneric Edit60
27F1514DArea Master - Alternate Description16NWENTJDate - EnteredDateGeneric Edit60
28F1515E.P. Cap Rules23CHENTJDate - EnteredDateGeneric Edit60
29F15151Building E.P. Caps25CDENTJDate - EnteredDateGeneric Edit60
30F15152Lease E.P. Caps38LCENTJDate - EnteredDateGeneric Edit60
31F151521Lease E.P. Accounts Not Subject to Cap24LOENTJDate - EnteredDateGeneric Edit60
32F15153Lease Cap History43LCENTJDate - EnteredDateGeneric Edit60
33F1521Log Detail Master39NBENTJDate - EnteredDateGeneric Edit60
34F1521DLog Detail Master - Alternate Description11NBENTJDate - EnteredDateGeneric Edit60
35F1523Log Standard Master28OGENTJDate - EnteredDateGeneric Edit60
36F1523DLog Standards Master - Alternate Description11OGENTJDate - EnteredDateGeneric Edit60
37F15302Ledger Type Groups16LTENTJDate - EnteredDateGeneric Edit60
38F15303E.P. Class Expenses History25CHENTJDate - EnteredDateGeneric Edit60
39F1530HExpense Participation Class Master Header20NGENTJDate - EnteredDateGeneric Edit60
40F1530HDE.P. Class Master Alternate Description10HDENTJDate - EnteredDateGeneric Edit60
41F1531Expense Participation Class Adjustment22OMENTJDate - EnteredDateGeneric Edit60
42F1531DExpense Participation Class Adj. - Alternate Description11OMENTJDate - EnteredDateGeneric Edit60
43F1533BTenant Account Exclusions18NMENTJDate - EnteredDateGeneric Edit60
44F1538B1Occupancy Gross Up Audit36GUENTJDate - EnteredDateGeneric Edit60
45F1538B2Exclusion/Redistribution23RDENTJDate - EnteredDateGeneric Edit60
46F1540BSales Report Control66NRENTJDate - EnteredDateGeneric Edit60
47F15410Tenant Weekly Sales37N9ENTJDate - EnteredDateGeneric Edit60
48F1541BTenant Sales History47N8ENTJDate - EnteredDateGeneric Edit60
49F1541BWSales History Work File59OWENTJDate - EnteredDateGeneric Edit60
50F1542Projected Sales51OJENTJDate - EnteredDateGeneric Edit60
51F1544BDSales Analysis Control - Alternate Description12OBENTJDate - EnteredDateGeneric Edit60
52F1547Sales Seasonality28OIENTJDate - EnteredDateGeneric Edit60
53F1549Seasonality Models14OLENTJDate - EnteredDateGeneric Edit60
54F1570Legal Clauses24NDENTJDate - EnteredDateGeneric Edit60
55F15701Legal Clause Options Audit23NKENTJDate - EnteredDateGeneric Edit60
56F157011Lease Option Type Header13NAENTJDate - EnteredDateGeneric Edit60
57F157011DLease Option Type Header - Alternate Description10NAENTJDate - EnteredDateGeneric Edit60
58F157012Lease Option Type Detail19NCENTJDate - EnteredDateGeneric Edit60
59F157012DLease Option Type Detail - Alternate Description11NCENTJDate - EnteredDateGeneric Edit60
60F15702Legal Clause Space Detail23NFENTJDate - EnteredDateGeneric Edit60
61F157021Legal Clause Space Detail Audit21NGENTJDate - EnteredDateGeneric Edit60
62F15702DLegal Clause Space Detail - Alternate Description13NFENTJDate - EnteredDateGeneric Edit60
63F15703Legal Clause Amounts21NIENTJDate - EnteredDateGeneric Edit60
64F159071Market/Potential/Renewal Rent Master21NYENTJDate - EnteredDateGeneric Edit60
65F159071DMarket/Potential/Renewal Rent Master - Alternate Description13NYENTJDate - EnteredDateGeneric Edit60
TOP15L: Adv Real Estate Forecasting
66F15L100AREF Building Constants36BCENTJDate - EnteredDateGeneric Edit60
67F15L1001AREF Building Constants Models36BMENTJDate - EnteredDateGeneric Edit60
68F15L101AREF Unit Master90UMENTJDate - EnteredDateGeneric Edit60
69F15L102AREF Unit Assumptions Master Header35AHENTJDate - EnteredDateGeneric Edit60
70F15L103AREF Sales Overage Rule Header27SHENTJDate - EnteredDateGeneric Edit60
71F15L104AREF E.P. Rules Header18EHENTJDate - EnteredDateGeneric Edit60
72F15L105AREF Growth Pattern File37GPENTJDate - EnteredDateGeneric Edit60
73F15L106AREF Recurring Bill Code Rules Header16RBENTJDate - EnteredDateGeneric Edit60
74F15L107AREF Recycle Assumption Rules22EFENTJDate - EnteredDateGeneric Edit60
75F15L108AREF Base Account Definition39ADENTJDate - EnteredDateGeneric Edit60
76F15L109AREF Budget Results33BRENTJDate - EnteredDateGeneric Edit60
77F15L109WAREF Grown Amounts Work File26GAENTJDate - EnteredDateGeneric Edit60
78F15L110AREF Account Status53ASENTJDate - EnteredDateGeneric Edit60
79F15L111AREF Account Status Detail35ADENTJDate - EnteredDateGeneric Edit60
80F15L112AREF Unit Assumptions Master Detail28ADENTJDate - EnteredDateGeneric Edit60
81F15L113AREF Sales Overage Detail19SDENTJDate - EnteredDateGeneric Edit60
82F15L114AREF E.P. Rules Detail20EDENTJDate - EnteredDateGeneric Edit60
83F15L116AREF Recurring Bill Code Rules Detail18RDENTJDate - EnteredDateGeneric Edit60
84F15L118AREF Base Account Definition Detail33DDENTJDate - EnteredDateGeneric Edit60
85F15L141AREF Gross Lease Occupied Area29GLENTJDate - EnteredDateGeneric Edit60
86F15L301AREF Projected Sales48PSENTJDate - EnteredDateGeneric Edit60
87F15L401AREF Share Factor Denominator Audit42SFENTJDate - EnteredDateGeneric Edit60
88F15L402AREF Tenant Exclusion Rule Audit24SGENTJDate - EnteredDateGeneric Edit60
89F15L403AREF Gross Up Processing Audit35SHENTJDate - EnteredDateGeneric Edit60
TOP42: Sales Management
90F42004Commission Constants File14CMENTJDate - EnteredDateGeneric Edit60
TOP44H: Homebuilder Management
91F4457Takeoff File (World)14JJENTJDate - EnteredDateGeneric Edit60
92F4458Takeoff (World)14JKENTJDate - EnteredDateGeneric Edit60
TOP51F: Advanced Job Forecasting
93F51F100Job Forecast Header10QFENTJDate - EnteredDateGeneric Edit60
94F51F110Job Forecast Details30QGENTJDate - EnteredDateGeneric Edit60
95F51F115Remaining Work Detail11QJENTJDate - EnteredDateGeneric Edit60
96F51F120Job Forecast Header History11QKENTJDate - EnteredDateGeneric Edit60
97F51F125Job Forecast Detail History31QIENTJDate - EnteredDateGeneric Edit60
98F51F90Formula Definition75QNENTJDate - EnteredDateGeneric Edit60
99F51F94User Defined MOC Definition4QUENTJDate - EnteredDateGeneric Edit60
100F51F95User Defined MOC Rules9QTENTJDate - EnteredDateGeneric Edit60
TOP54R: Rental Management
101F54R01Rental Constants32RCENTJDate - EnteredDateGeneric Edit60
102F54R02Action Definition16ADENTJDate - EnteredDateGeneric Edit60
103F54R021Action Details16AAENTJDate - EnteredDateGeneric Edit60
104F54R03Line Type and Action Association Header17LHENTJDate - EnteredDateGeneric Edit60
105F54R031Line Type and Action Association Detail17LDENTJDate - EnteredDateGeneric Edit60
106F54R099Rental Contract Header Ledger82HLENTJDate - EnteredDateGeneric Edit60
107F54R10Rental Contract Header80CHENTJDate - EnteredDateGeneric Edit60
108F54R11Rental Contract Detail57CDENTJDate - EnteredDateGeneric Edit60
109F54R12Purchase Order Receiver Rentals File36RRENTJDate - EnteredDateGeneric Edit60
110F54R199Rental Contract Detail Ledger53DLENTJDate - EnteredDateGeneric Edit60
111F54R20Rental Contract Related Orders20ROENTJDate - EnteredDateGeneric Edit60
112F54R41TRental Item Details Table43RIENTJDate - EnteredDateGeneric Edit60