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

is JDE Date
Home | 812 | 15
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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail 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

103 tables812 | 15

15: Property Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F15011NK231Billings Generation Control MasterBalance Files15: Property ManagementAS400 Coexistence Tables
2812F15011BNK711OW BIllings Generation Control MasterBalance Files15: Property ManagementNo
3812F15012NS691Tenant E.P. Class MasterSecondary Master Files15: Property ManagementAS400 Coexistence Tables
4812F150120NW161Tenant Exclusion HeaderFiles15: Property ManagementBusiness Data
5812F150120DNW101Tenant Exclusion - Alternate DescriptionExtra Features Files15: Property Management
6812F150121NX251Tenant Exclusion DetailFiles15: Property ManagementBusiness Data
7812F150122NY181Share Factor Denominator HeaderFiles15: Property ManagementBusiness Data
8812F150122DNY101Share Factor Denominator - Alternate DescriptionExtra Features Files15: Property Management
9812F150123NZ151Share Factor Denominator DetailFiles15: Property ManagementBusiness Data
10812F15012BNS896Tenant E.P. Class MasterSecondary Master Files15: Property ManagementNo
11812F15013NO681Sales Overage MasterSecondary Master Files15: Property ManagementAS400 Coexistence Tables
12812F15013BNO896Sales Overage Master FileSecondary Master Files15: Property ManagementNo
13812F15014NP361Product Scales MasterSecondary Master Files15: Property ManagementAS400 Coexistence Tables
14812F15014BNP559Product Scales MasterSecondary Master Files15: Property ManagementNo
15812F15015NQ401Minimum rent/recoveries MasterSecondary Master Files15: Property ManagementAS400 Coexistence Tables
16812F15015BNQ545Min/Max Rents And Recoveries MasterSecondary Master Files15: Property ManagementNo
17812F15016NU701Tenant Escalation MasterSecondary Master Files15: Property ManagementAS400 Coexistence Tables
18812F15016BNU824Tenant Escalation MasterSecondary Master Files15: Property ManagementNo
19812F15017NW576Lease Master Detail FileBalance Files15: Property ManagementNo
20812F15019DNL101Billing Frequency - Alternate DescriptionExtra Features Files15: Property Management
21812F1501BNE618Lease Master Header FileMaster Files15: Property ManagementNo
22812F1501BDNE111Lease Master Header - Alternate DescriptionExtra Features Files15: Property Management
23812F1502NF711Recurring Billings MasterSecondary Master Files15: Property ManagementAS400 Coexistence Tables
24812F15020NN624Extended Billings Master FileMaster Files15: Property ManagementNo
25812F1502BNF8212Recurring Billings MasterSecondary Master Files15: Property ManagementNo
26812F1502BDNF111Recurring Billings Master - Alternate DescriptionExtra Features Files15: Property Management
27812F1502WABNF221Rent Increase AmountsRegular Work Files15: Property ManagementNo
28812F1502WBN4841Estimated EP Recurring Billing Work File (OneWorld)Regular Work Files15: Property ManagementNo
29812F1503NB341Log Standards MasterTransaction Files15: Property ManagementAS400 Coexistence Tables
30812F1504NC141Log Standards Text MasterTransaction Files15: Property ManagementAS400 Coexistence Tables
31812F1505ND491Management Fee MasterSecondary Master Files15: Property ManagementAS400 Coexistence Tables
32812F1505BND608Management Fee MasterSecondary Master Files15: Property ManagementNo
33812F1505HOK121Revenue Fee Generation HistoryHistory Files15: Property ManagementAS400 Coexistence Tables
34812F1505HBOK201Revenue Fee Generation HistoryHistory Files15: Property ManagementNo
35812F1506OP181Floor Master FileMaster Files15: Property ManagementAS400 Coexistence Tables
36812F1506DOP131Floor Master - Alternate DescriptionExtra Features Files15: Property Management
37812F1507NH604Unit Master FileMaster Files15: Property ManagementAS400 Coexistence Tables
38812F1507DNH151Unit Master - Alternate DescriptionExtra Features Files15: Property Management
39812F1510OE361Property Management ConstantsConstants Files15: Property ManagementAS400 Coexistence Tables
40812F1510BOE431Property Management ConstantsConstants Files15: Property ManagementNo
41812F1511NJ871Tenant/Lease Billings DetailTransaction Files15: Property ManagementAS400 Coexistence Tables
42812F15110BOB183Expense Participation Class AccountRegular Work Files15: Property ManagementNo
43812F1511BNJ9512Tenant/Lease Billings Detail MasterTransaction Files15: Property ManagementNo
44812F1511B1NW151Billings Detail Batch SummaryFiles15: Property ManagementNo
45812F1511HN#861Tenant/Lease Billings Detail HistoryHistory Files15: Property ManagementAS400 Coexistence Tables
46812F1511HBNC936Tenant/Lease Billings Detail HistoryHistory Files15: Property ManagementNo
47812F1512NA324Billing Code ExtensionConstants Files15: Property ManagementAS400 Coexistence Tables
48812F1512DNA111Billing Code Extension - Alternate DescriptionExtra Features Files15: Property Management
49812F1513O3591FASB 13 Lease Control FileTransaction Files15: Property ManagementAS400 Coexistence Tables
50812F1513BO3692FASB 13 Lease Control FileTransaction Files15: Property ManagementNo
51812F1514NW254Area MasterSecondary Master Files15: Property ManagementNo
52812F15141NC263Gross Lease Occupied AreasFiles15: Property ManagementBusiness Data
53812F1514DNW161Area Master - Alternate DescriptionExtra Features Files15: Property Management
54812F1514WNW81Area Work FileWork Files15: Property ManagementNo
55812F1516NX91Extended Invoice TextFiles15: Property ManagementNo
56812F151991NB201G/L Transaction A/R Application Work FileWork Files15: Property ManagementNo
57812F15199WNB133G/L Transaction Summarization Work FileWork Files15: Property ManagementNo
58812F1521NB4013Log Detail MasterSecondary Master Files15: Property ManagementNo
59812F1521DNB111Log Detail Master - Alternate DescriptionExtra Features Files15: Property Management
60812F1523OG282Log Standard MasterSecondary Master Files15: Property ManagementNo
61812F1523DOG111Log Standards Master - Alternate DescriptionExtra Features Files15: Property Management
62812F1525N0371A/R Fee InterestSecondary Master Files15: Property ManagementAS400 Coexistence Tables
63812F1525BNM453A/R Fee and InterestSecondary Master Files15: Property ManagementNo
64812F1530NG172Expense Participation Class MasterSecondary Master Files15: Property ManagementAS400 Coexistence Tables
65812F1531OM141Expense Participation Class AdjustmentSecondary Master Files15: Property ManagementAS400 Coexistence Tables
66812F1531DOM111Expense Participation Class Adj. - Alternate DescriptionFiles15: Property Management
67812F1532BNT294Expense Participation Audit FileHistory Files15: Property ManagementNo
68812F1533NM121Tenant Class Account ExclusionsTransaction Files15: Property ManagementAS400 Coexistence Tables
69812F1533BNM291Tenant Account ExclusionsMaster Files15: Property ManagementNo
70812F1538NZ851WF - Expence Participation RegisterSecondary Master Files15: Property ManagementAS400 Coexistence Tables
71812F1538BNZ1193EP Billing Register Work FileRegular Work Files15: Property ManagementNo
72812F1540NR411Sales Report Control FileTransaction Files15: Property ManagementAS400 Coexistence Tables
73812F1540BNR677Sales Report Control FileTransaction Files15: Property ManagementNo
74812F1541N8341Tenant Sales HistoryHistory Files15: Property ManagementAS400 Coexistence Tables
75812F15410N9401Tenant Weekly Sales FileHistory Files15: Property ManagementNo
76812F1541BN8504Tenant Sales History FileHistory Files15: Property ManagementNo
77812F1541BWOW621Sales History Work FileFiles15: Property ManagementBusiness Data
78812F1542OJ512Projected SalesFiles15: Property ManagementBusiness Data
79812F1543BOA792Tenant Sales Analysis Reporting FileBalance Files15: Property ManagementNo
80812F1544OB351Sales Analysis Control FileSecondary Master Files15: Property ManagementAS400 Coexistence Tables
81812F1544BOB481Sales Analysis Control FileSecondary Master Files15: Property ManagementNo
82812F1544BDOB121Sales Analysis Control - Alternate DescriptionExtra Features Files15: Property Management
83812F1547OI281Sales SeasonalityFiles15: Property ManagementBusiness Data
84812F1548N1611Escalation Billing RegisterTransaction Files15: Property ManagementAS400 Coexistence Tables
85812F1548BN1721Escalation Billing RegisterTransaction Files15: Property ManagementNo
86812F1549OL141Seasonality ModelsFiles15: Property ManagementBusiness Data
87812F1550NV221Escalation Index MasterSecondary Master Files15: Property ManagementAS400 Coexistence Tables
88812F15525WRT591PM Statements Credit/Cash Build WorkfileWork Files15: Property ManagementNo
89812F1565JF405Security Deposit MasterSecondary Master Files15: Property ManagementNo
90812F1570ND252Legal ClausesMaster Files15: Property ManagementBusiness Data
91812F15701NK253Legal Clause Options AuditSecondary Master Files15: Property ManagementBusiness Data
92812F157011NA141Lease Option Type HeaderMaster Files15: Property ManagementBusiness Data
93812F157011DNA101Lease Option Type Header - Alternate DescriptionExtra Features Files15: Property Management
94812F157012NC201Lease Option Type DetailMaster Files15: Property ManagementBusiness Data
95812F157012DNC111Lease Option Type Detail - Alternate DescriptionExtra Features Files15: Property Management
96812F15702NF242Legal Clause Space DetailSecondary Master Files15: Property ManagementBusiness Data
97812F157021NG223Legal Clause Space Detail AuditSecondary Master Files15: Property ManagementBusiness Data
98812F15702DNF131Legal Clause Space Detail - Alternate DescriptionExtra Features Files15: Property Management
99812F15703NI243Legal Clause AmountsSecondary Master Files15: Property ManagementBusiness Data
100812F159071NY242Market/Potential/Renewal Rent MasterSecondary Master Files15: Property ManagementNo
101812F159071DNY131Market/Potential/Renewal Rent Master - Alternate DescriptionExtra Features Files15: Property Management
102812F8915CV1N7161Property Management Table Conversion Master AuditWork Files15: Property ManagementNo
103812F8915CV2N991Property Management Table Conversion Detail AuditWork Files15: Property ManagementNo

All references to JDE, JD Edwards and Oracle logos are trademarks of Oracle Corporation USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the Oracle Corporation or any of its affiliates.
About :: Terms :: Privacy