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

43 columns | Print definition?910 | OPPID

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP01: Address Book
1F01301Activity Master56AMOPPIDOpportunity NumberNumericGeneric Edit150
2F01301DActivity Detail56ADOPPIDOpportunity NumberNumericGeneric Edit150
TOP15: Property Management
3F1506Floor Master13OPPIDProgram IDStringGeneric Edit100
4F1506DFloor Master - Alternate Description8OPPIDProgram IDStringGeneric Edit100
TOP18: Resource Scheduling
5F186411Overtime Pay Type Exclusion Lists17OPPIDProgram IDStringGeneric Edit100
TOP40: Inventory/OP Base
6F40316Preference Profile - Order Preparation22OPPIDProgram IDStringGeneric Edit100
7F40316RPreference Resolution Ledger - Order Preparation Days24OPPIDProgram IDStringGeneric Edit100
8F4201Z1Sales Order Header Unedited Transaction File140SYOPPIDOpportunity NumberNumericGeneric Edit150
TOP42: Sales Management
9F4201Sales Order Header File127SHOPPIDOpportunity NumberNumericGeneric Edit150
10F42019Sales Order Header History File127SHOPPIDOpportunity NumberNumericGeneric Edit150
11F4211Sales Order Detail File251SDOPPIDOpportunity NumberNumericGeneric Edit150
12F42119Sales Order History File251SDOPPIDOpportunity NumberNumericGeneric Edit150
13F42199S.O. Detail Ledger File251SLOPPIDOpportunity NumberNumericGeneric Edit150
14F42A012Opportunity40OPPIDProgram IDStringGeneric Edit100
15F42UI01SO Header Cache File (MBF)166ZHOPPIDOpportunity NumberNumericGeneric Edit150
16F42UI11SO Detail Cache File (MBF)182ZDOPPIDOpportunity NumberNumericGeneric Edit150
TOP42B: Sales Order Entry
17F4211CZ1Sales Order Detail Unedited Transaction File - CRM19CZOPPIDOpportunity NumberNumericGeneric Edit150
18F42420Audit Log Transaction111ALOPPIDOpportunity NumberNumericGeneric Edit150
19F47012TEDI Purchase Order Detail Tag - Inbound66UZOPPIDOpportunity NumberNumericGeneric Edit150
20F47132TEDI Purchase Order Change Detail Tag - Inbound66UZOPPIDOpportunity NumberNumericGeneric Edit150
TOP44H: Homebuilder Management
21F44H403Option Preferences21OPPIDProgram IDStringGeneric Edit100
TOP47: Electronic Commerce
22F47011EDI Purchase Order Header - Inbound143SYOPPIDOpportunity NumberNumericGeneric Edit150
23F47131EDI Purchase Order Change Header - Inbound140SYOPPIDOpportunity NumberNumericGeneric Edit150
TOP80D: Plant Manager Dashboard
24F80D255AP Open Payables Aggregate8OPPIDProgram IDStringGeneric Edit100
TOP89: Conversion Programs
25F89CB06CTable - Opportunity_For_FCST_ID - Opportunity Lookup Table2TCOPPIDOpportunity NumberNumericGeneric Edit150
TOP90CA: CRM Foundation
26F90CA002F90CB02E Mirror table for sync filtering.1OMOPPIDOpportunity NumberNumericGeneric Edit150
27F90CA61EActivity Opportunity Associative Table (FOR CRM UPGRADE)2ACOPPIDOpportunity NumberNumericGeneric Edit150
TOP90CB: CRM Sales Force Automation
28F90CB020Opportunity Table1OTOPPIDOpportunity NumberNumericGeneric Edit150
29F90CB02COpportunity_Competitor Table1OCOPPIDOpportunity NumberNumericGeneric Edit150
30F90CB02DOpportunity_Contact Table1ODOPPIDOpportunity NumberNumericGeneric Edit150
31F90CB02EOpportunity_Employee Table1OEOPPIDOpportunity NumberNumericGeneric Edit150
32F90CB02GOpportunity_Partner Table2OGOPPIDOpportunity NumberNumericGeneric Edit150
33F90CB02IOpportunity_Item Table1OIOPPIDOpportunity NumberNumericGeneric Edit150
34F90CB02JOpportunity_Sales_Cycle Table1OJOPPIDOpportunity NumberNumericGeneric Edit150
35F90CB02MCost Table2OMOPPIDOpportunity NumberNumericGeneric Edit150
36F90CB043Qualification_Object Table13QOOPPIDOpportunity NumberNumericGeneric Edit150
37F90CB05ASales_Cycle Table34OPPIDProgram IDStringGeneric Edit100
38F90CB05BSale_Driver Table4ONOPPIDOpportunity NumberNumericGeneric Edit150
39F90CB05CSales_Cycle_Notification_Ledger Table1NLOPPIDOpportunity NumberNumericGeneric Edit150
40F90CB06AForecast Opportunity2FOOPPIDOpportunity NumberNumericGeneric Edit150
41F90CB06BOpportunity_For_Forecast Table2OFOPPIDOpportunity NumberNumericGeneric Edit150
42F90CB06COpportunity_Item_For_Forecast Table2OHOPPIDOpportunity NumberNumericGeneric Edit150
43F90CB06ZOpportunity for Forecast WTF2ZFOPPIDOpportunity NumberNumericGeneric Edit150