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
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

68 tables910 | 80D

80D: Plant Manager Dashboard
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F80D010SF391Sales Order FactFiles80D: Plant Manager Dashboard
2910F80D020GL161G/L Balances Fact TableFiles80D: Plant Manager Dashboard
3910F80D021FR181Financial Ratios Amount Dimensions TableFiles80D: Plant Manager Dashboard
4910F80D100DD145PMD - Date DimensionsFiles80D: Plant Manager Dashboard
5910F80D101PU112PMD - UBE TimestampFiles80D: Plant Manager Dashboard
6910F80D104AL111Address Book ListFiles80D: Plant Manager Dashboard
7910F80D105BL111Business Unit ListFiles80D: Plant Manager Dashboard
8910F80D106PL111Product Group ListFiles80D: Plant Manager Dashboard
9910F80D107GD191Goals DefinitionFiles80D: Plant Manager Dashboard
10910F80D107AGT191Goals Definition TagFiles80D: Plant Manager Dashboard
11910F80D108GK161Goals Definition Cross ReferenceFiles80D: Plant Manager Dashboard
12910F80D110SQ191PMD Search By Saved QueryFiles80D: Plant Manager Dashboard
13910F80D111FQ181FMD Default Search By QueryFiles80D: Plant Manager Dashboard
14910F80D112SR132SOD RulesFiles80D: Plant Manager Dashboard
15910F80D113PM171SOD Process MasterFiles80D: Plant Manager Dashboard
16910F80D114GM121SOD Group MasterFiles80D: Plant Manager Dashboard
17910F80D120SV193SOD ViolationsFiles80D: Plant Manager Dashboard
18910F80D130CM201Compliance Alert MasterFiles80D: Plant Manager Dashboard
19910F80D131CI471Compliance Instance DetailFiles80D: Plant Manager Dashboard
20910F80D135SM112SOD Alert MasterFiles80D: Plant Manager Dashboard
21910F80D136SD161SOD Alert DetailFiles80D: Plant Manager Dashboard
22910F80D150RL151Whistle Blower Recipient ListsFiles80D: Plant Manager Dashboard
23910F80D200DS151Days Sales Outstanding Aggregate TableFiles80D: Plant Manager Dashboard
24910F80D201PA141Days Payable Outstanding AggregateFiles80D: Plant Manager Dashboard
25910F80D202CC151Cash to Cash Cycle Time AggregateFiles80D: Plant Manager Dashboard
26910F80D203FC141Forecasted Cash Flow AggregateFiles80D: Plant Manager Dashboard
27910F80D210CR161On Time Shipment Customer Request Date Aggregate TableFiles80D: Plant Manager Dashboard
28910F80D211PS161On Time Shipment Promise Ship Date Aggregate TableFiles80D: Plant Manager Dashboard
29910F80D212PD141Past Due Aggregate TableFiles80D: Plant Manager Dashboard
30910F80D213BO141Back Order Aggregate TableFiles80D: Plant Manager Dashboard
31910F80D214VR141Variance TableFiles80D: Plant Manager Dashboard
32910F80D215BS131Book To Ship Aggregate TableFiles80D: Plant Manager Dashboard
33910F80D220IN151Inventory Aggregate TableFiles80D: Plant Manager Dashboard
34910F80D221GL131General Ledger Aggregate TableFiles80D: Plant Manager Dashboard
35910F80D230OT161F80D230 On Time Manufacturing Work Order CompletionsFiles80D: Plant Manager Dashboard
36910F80D231PC171F380D231 Manufacturing Production CostingsFiles80D: Plant Manager Dashboard
37910F80D240BO141Booked Orders AggregateFiles80D: Plant Manager Dashboard
38910F80D241SO141Shipped Orders AggregateFiles80D: Plant Manager Dashboard
39910F80D242PR141Projected Revenue AggregateFiles80D: Plant Manager Dashboard
40910F80D243BC131Backlog AggregateFiles80D: Plant Manager Dashboard
41910F80D250PS151Supplier On-Time Delivery AggregateFiles80D: Plant Manager Dashboard
42910F80D251PL171Material Lead-Time Exception AggregateFiles80D: Plant Manager Dashboard
43910F80D252PQ151Supplier Pass Quality AggregateFiles80D: Plant Manager Dashboard
44910F80D253CA151AP Daily Counts and AmountsFiles80D: Plant Manager Dashboard
45910F80D254DI151AP Discount Information AggregateFiles80D: Plant Manager Dashboard
46910F80D255OP151AP Open Payables AggregateFiles80D: Plant Manager Dashboard
47910F80D256VP131AP Voucher Paid Late AggregateFiles80D: Plant Manager Dashboard
48910F80D272PC131Most Profitable Customers AggregateFiles80D: Plant Manager Dashboard
49910F80D273PP131Most Profitable Products AggregateFiles80D: Plant Manager Dashboard
50910F80D274PB131Most Profitable Brands AggregateFiles80D: Plant Manager Dashboard
51910F80D280AG151AR Daily Counts and Amts AggrFiles80D: Plant Manager Dashboard
52910F80D281DI151A/R Delinquency Info AggregateFiles80D: Plant Manager Dashboard
53910F80D282DI171AR Discount Information AggegrateFiles80D: Plant Manager Dashboard
54910F80D283OC131AR Open Chargeback AggregateFiles80D: Plant Manager Dashboard
55910F80D284OR131AR Open Receivables AggegrateFiles80D: Plant Manager Dashboard
56910F80D285TC131AR Total Chargeback AggregateFiles80D: Plant Manager Dashboard
57910F80D300DB141Dashboard ConstantsFiles80D: Plant Manager Dashboard
58910F80D301DM111Dashboard Code Metric Cross ReferenceFiles80D: Plant Manager Dashboard
59910F80D302CR111Metric ID Time Dimension Cross ReferenceFiles80D: Plant Manager Dashboard
60910F80D303MD221Metric DefinitionFiles80D: Plant Manager Dashboard
61910F80D304VD163Variant DefinitionFiles80D: Plant Manager Dashboard
62910F80D305HD132Hierarchy DefinitionFiles80D: Plant Manager Dashboard
63910F80D310AAT131Alert Definition Tag TableFiles80D: Plant Manager Dashboard
64910F80D311AI143Alert InstanceFiles80D: Plant Manager Dashboard
65910F80D311AAJ132Alert Instance Tag TableFiles80D: Plant Manager Dashboard
66910F80D315AS122Alert Instance StatusFiles80D: Plant Manager Dashboard
67910F80D320DC121Dashboard ConfigurationFiles80D: Plant Manager Dashboard
68910F80D701UT131Unposted Transactions AggregateFiles80D: Plant Manager Dashboard