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

126 tables920 | 15

15: Real Estate Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F1501NE723Tenant/Lease MasterMaster Files15: Real Estate ManagementBusiness Data
2920F15011NK231Billings Generation Control MasterBalance Files15: Real Estate ManagementBusiness Data
3920F15011BNK711BIllings Generation ControlBalance Files15: Real Estate ManagementBusiness Data
4920F15012NS691Tenant E.P. Class MasterSecondary Master Files15: Real Estate ManagementBusiness Data
5920F150120NW171Tenant Exclusion HeaderFiles15: Real Estate ManagementBusiness Data
6920F150120DNW101Tenant Exclusion - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
7920F150121NX251Tenant Exclusion DetailFiles15: Real Estate ManagementBusiness Data
8920F150122NY191Share Factor Denominator HeaderFiles15: Real Estate ManagementBusiness Data
9920F150122ASA241Share Factor Denominator AuditFiles15: Real Estate ManagementBusiness Data
10920F150122DNY101Share Factor Denominator - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
11920F150123NZ151Share Factor Denominator DetailFiles15: Real Estate ManagementBusiness Data
12920F15012BNS978Tenant E.P. Class MasterSecondary Master Files15: Real Estate ManagementBusiness Data
13920F15013NO681Sales Overage MasterSecondary Master Files15: Real Estate ManagementBusiness Data
14920F15013BNO896Sales Overage Master FileSecondary Master Files15: Real Estate ManagementBusiness Data
15920F15014NP361Product Scales MasterSecondary Master Files15: Real Estate ManagementBusiness Data
16920F15014BNP559Product Scales MasterSecondary Master Files15: Real Estate ManagementBusiness Data
17920F15015NQ401Minimum rent/recoveries MasterSecondary Master Files15: Real Estate ManagementBusiness Data
18920F15015BNQ545Min/Max Rents And Recoveries MasterSecondary Master Files15: Real Estate ManagementBusiness Data
19920F15016NU701Tenant Escalation MasterSecondary Master Files15: Real Estate ManagementBusiness Data
20920F15016BNU824Tenant Escalation MasterSecondary Master Files15: Real Estate ManagementBusiness Data
21920F15017NW576Lease Master DetailBalance Files15: Real Estate ManagementBusiness Data
22920F15019DNL101Billing Frequency - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
23920F1501BNE618Lease Master HeaderMaster Files15: Real Estate ManagementBusiness Data
24920F1501BDNE111Lease Master Header - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
25920F1502NF711Recurring Billings MasterSecondary Master Files15: Real Estate ManagementBusiness Data
26920F15020NN624Extended Billings MasterMaster Files15: Real Estate ManagementBusiness Data
27920F1502BNF8212Recurring Billings MasterSecondary Master Files15: Real Estate ManagementBusiness Data
28920F1502BDNF111Recurring Billings Master - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
29920F1502WABNF221Rent Increase AmountsRegular Work Files15: Real Estate ManagementBusiness Data
30920F1502WBN4841Estimated EP Recurring BillingsRegular Work Files15: Real Estate ManagementBusiness Data
31920F1503NB341Log Standards MasterTransaction Files15: Real Estate ManagementBusiness Data
32920F1504NC141Log Standards Text MasterTransaction Files15: Real Estate ManagementBusiness Data
33920F1505ND491Management Fee MasterSecondary Master Files15: Real Estate ManagementBusiness Data
34920F1505BND608Management Fee MasterSecondary Master Files15: Real Estate ManagementBusiness Data
35920F1505HOK121Revenue Fee Generation HistoryHistory Files15: Real Estate ManagementBusiness Data
36920F1505HBOK201Revenue Fee Generation HistoryHistory Files15: Real Estate ManagementBusiness Data
37920F1506OP181Floor MasterMaster Files15: Real Estate ManagementBusiness Data
38920F1506DOP131Floor Master - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
39920F1507NH604Unit MasterMaster Files15: Real Estate ManagementBusiness Data
40920F1507DNH151Unit Master - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
41920F1510OE361Property Management ConstantsConstants Files15: Real Estate ManagementBusiness Data
42920F1510BOE431Real Estate Management ConstantsConstants Files15: Real Estate ManagementBusiness Data
43920F1511NJ871Tenant/Lease Billings DetailTransaction Files15: Real Estate ManagementBusiness Data
44920F15110BOB183Expense Participation Class AccountRegular Work Files15: Real Estate ManagementBusiness Data
45920F1511BNJ9512Lease Billings MasterTransaction Files15: Real Estate ManagementBusiness Data
46920F1511B1NW151Billing Batches SummaryFiles15: Real Estate ManagementBusiness Data
47920F1511HN#861Tenant/Lease Billings Detail HistoryHistory Files15: Real Estate ManagementBusiness Data
48920F1511HBNC936Lease Billings HistoryHistory Files15: Real Estate ManagementBusiness Data
49920F1512NA324Billing Code ExtensionConstants Files15: Real Estate ManagementBusiness Data
50920F1512DNA111Billing Code Extension - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
51920F1513O3591FASB 13 Lease Control FileTransaction Files15: Real Estate ManagementBusiness Data
52920F1513BO3692FASB 13 Lease ControlTransaction Files15: Real Estate ManagementBusiness Data
53920F1514NW254Area MasterSecondary Master Files15: Real Estate ManagementBusiness Data
54920F15141NC293Gross Lease Occupied AreasFiles15: Real Estate ManagementBusiness Data
55920F15142NV251Area DefinitionsMaster Files15: Real Estate ManagementBusiness Data
56920F1514DNW161Area Master - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
57920F1514WNW81Area Work FileWork Files15: Real Estate ManagementBusiness Data
58920F1515CH231E.P. Cap RulesFiles15: Real Estate ManagementBusiness Data
59920F15151CD281Building E.P. CapsFiles15: Real Estate ManagementBusiness Data
60920F15152LC381Lease E.P. CapsSecondary Master Files15: Real Estate ManagementBusiness Data
61920F151521LO241Lease E.P. Accounts Not Subject to CapFiles15: Real Estate ManagementBusiness Data
62920F15153LC434Lease Cap HistoryFiles15: Real Estate ManagementBusiness Data
63920F1516NX91Extended Invoice TextFiles15: Real Estate ManagementBusiness Data
64920F151991NB201G/L Transaction A/R Application Work FileWork Files15: Real Estate ManagementBusiness Data
65920F15199WNB133G/L Transaction Summarization Work FileWork Files15: Real Estate ManagementBusiness Data
66920F1521NB4013Log Detail MasterSecondary Master Files15: Real Estate ManagementBusiness Data
67920F15211AT1491Real Estate AttributesFiles15: Real Estate Management
68920F1521DNB111Log Detail Master - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
69920F1522UT191Unit Attribute Template NameFiles15: Real Estate Management
70920F15221UF122Unit Attribute Template FieldsFiles15: Real Estate Management
71920F1523OG282Log Standard MasterSecondary Master Files15: Real Estate ManagementBusiness Data
72920F1523DOG111Log Standards Master - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
73920F1525N0371A/R Fee InterestSecondary Master Files15: Real Estate ManagementBusiness Data
74920F1525BNM453Fees and InterestSecondary Master Files15: Real Estate ManagementBusiness Data
75920F1530NG342Expense Participation Class MasterSecondary Master Files15: Real Estate ManagementBusiness Data
76920F15301AO352E.P. Class Account OverridesFiles15: Real Estate ManagementBusiness Data
77920F15302LT161Ledger Type GroupsFiles15: Real Estate ManagementBusiness Data
78920F15303CH312E.P. Class Expenses HistoryHistory Files15: Real Estate ManagementBusiness Data
79920F1530HNG201Expense Participation Class Master HeaderMaster Files15: Real Estate ManagementBusiness Data
80920F1530HDHD101E.P. Class Master Alternate DescriptionFiles15: Real Estate ManagementBusiness Data
81920F1531OM283Expense Participation Class AdjustmentSecondary Master Files15: Real Estate ManagementBusiness Data
82920F1531DOM111Expense Participation Class Adj. - Alternate DescriptionFiles15: Real Estate ManagementBusiness Data
83920F1532BNT345Expense Participation Audit FileHistory Files15: Real Estate ManagementBusiness Data
84920F1533NM121Tenant Class Account ExclusionsTransaction Files15: Real Estate ManagementBusiness Data
85920F1533BNM521Tenant Account ExclusionsMaster Files15: Real Estate ManagementBusiness Data
86920F1538NZ851WF - Expence Participation RegisterSecondary Master Files15: Real Estate ManagementBusiness Data
87920F1538BNZ1523EP Billing RegisterRegular Work Files15: Real Estate ManagementBusiness Data
88920F1538B1GU391Occupancy Gross Up AuditTransaction Files15: Real Estate ManagementBusiness Data
89920F1538B2RD271Exclusion/RedistributionFiles15: Real Estate ManagementBusiness Data
90920F1539AAU331EP Billing Account Adjustments AuditFiles15: Real Estate ManagementBusiness Data
91920F1539CAU281EP Billing Class Adjustments Audit FileFiles15: Real Estate ManagementBusiness Data
92920F1539EAU341EP Billing Account Exclusions AuditFiles15: Real Estate ManagementBusiness Data
93920F1539FCAU271EP Billing Adj Factor EP Class AuditFiles15: Real Estate ManagementBusiness Data
94920F1539FLAU331EP Billing Adj Factor Lease AuditFiles15: Real Estate ManagementBusiness Data
95920F1540NR411Sales Report Control FileTransaction Files15: Real Estate ManagementBusiness Data
96920F1540BNR677Sales Report ControlTransaction Files15: Real Estate ManagementBusiness Data
97920F1541N8341Tenant Sales HistoryHistory Files15: Real Estate ManagementBusiness Data
98920F15410N9401Tenant Weekly SalesHistory Files15: Real Estate ManagementBusiness Data
99920F1541BN8504Tenant Sales HistoryHistory Files15: Real Estate ManagementBusiness Data
100920F1541BWOW621Sales History Work FileFiles15: Real Estate ManagementBusiness Data
101920F1542OJ512Projected SalesFiles15: Real Estate ManagementBusiness Data
102920F1543BOA792Tenant Sales Analysis Reporting FileBalance Files15: Real Estate ManagementBusiness Data
103920F1544OB351Sales Analysis Control FileSecondary Master Files15: Real Estate ManagementBusiness Data
104920F1544BOB481Sales Analysis ControlSecondary Master Files15: Real Estate ManagementBusiness Data
105920F1544BDOB121Sales Analysis Control - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
106920F1547OI281Sales SeasonalityFiles15: Real Estate ManagementBusiness Data
107920F1548N1611Escalation Billing RegisterTransaction Files15: Real Estate ManagementBusiness Data
108920F1548BN1721Escalation Billing RegisterTransaction Files15: Real Estate ManagementBusiness Data
109920F1549OL141Seasonality ModelsFiles15: Real Estate ManagementBusiness Data
110920F1550NV221Escalation Index MasterSecondary Master Files15: Real Estate ManagementBusiness Data
111920F15525WRT591PM Statements Credit/Cash Build WorkfileWork Files15: Real Estate ManagementBusiness Data
112920F1565JF405Security Deposit MasterSecondary Master Files15: Real Estate ManagementBusiness Data
113920F1570ND252Legal ClausesMaster Files15: Real Estate ManagementBusiness Data
114920F15701NK253Legal Clause Options AuditSecondary Master Files15: Real Estate ManagementBusiness Data
115920F157011NA141Lease Option Type HeaderMaster Files15: Real Estate ManagementBusiness Data
116920F157011DNA101Lease Option Type Header - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
117920F157012NC201Lease Option Type DetailMaster Files15: Real Estate ManagementBusiness Data
118920F157012DNC111Lease Option Type Detail - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
119920F15702NF242Legal Clause Space DetailSecondary Master Files15: Real Estate ManagementBusiness Data
120920F157021NG223Legal Clause Space Detail AuditSecondary Master Files15: Real Estate ManagementBusiness Data
121920F15702DNF131Legal Clause Space Detail - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
122920F15703NI243Legal Clause AmountsSecondary Master Files15: Real Estate ManagementBusiness Data
123920F159071NY242Market/Potential/Renewal Rent MasterSecondary Master Files15: Real Estate ManagementBusiness Data
124920F159071DNY131Market/Potential/Renewal Rent Master - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
125920F8915CV1N7161Property Management Table Conversion Master AuditWork Files15: Real Estate ManagementBusiness Data
126920F8915CV2N991Property Management Table Conversion Detail AuditWork Files15: Real Estate ManagementBusiness Data