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
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

42 columns | Print definition?920 | OPPID

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP01: Address Book
1F01301Activity Master56AMOPPIDOpportunity NumberNumericGeneric Edit150
2F01301DActivity Detail56ADOPPIDOpportunity NumberNumericGeneric Edit150
TOP15: Real Estate Management
3F1506Floor Master13OPPIDProgram IDStringGeneric Edit100
4F1506DFloor Master - Alternate Description8OPPIDProgram IDStringGeneric Edit100
TOP18: Timecard Automation
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
TOP89: Conversion Programs
24F89CB06CTable - Opportunity_For_FCST_ID - Opportunity Lookup Table2TCOPPIDOpportunity NumberNumericGeneric Edit150
TOP90CA: CRM Foundation
25F90CA002F90CB02E Mirror table for sync filtering.1OMOPPIDOpportunity NumberNumericGeneric Edit150
26F90CA61EActivity Opportunity Associative Table (FOR CRM UPGRADE)2ACOPPIDOpportunity NumberNumericGeneric Edit150
TOP90CB: CRM Sales Force Automation
27F90CB020Opportunity Table1OTOPPIDOpportunity NumberNumericGeneric Edit150
28F90CB02COpportunity_Competitor Table1OCOPPIDOpportunity NumberNumericGeneric Edit150
29F90CB02DOpportunity_Contact Table1ODOPPIDOpportunity NumberNumericGeneric Edit150
30F90CB02EOpportunity_Employee Table1OEOPPIDOpportunity NumberNumericGeneric Edit150
31F90CB02GOpportunity_Partner Table2OGOPPIDOpportunity NumberNumericGeneric Edit150
32F90CB02IOpportunity_Item Table1OIOPPIDOpportunity NumberNumericGeneric Edit150
33F90CB02JOpportunity_Sales_Cycle Table1OJOPPIDOpportunity NumberNumericGeneric Edit150
34F90CB02MCost Table2OMOPPIDOpportunity NumberNumericGeneric Edit150
35F90CB043Qualification_Object Table13QOOPPIDOpportunity NumberNumericGeneric Edit150
36F90CB05ASales_Cycle Table34OPPIDProgram IDStringGeneric Edit100
37F90CB05BSale_Driver Table4ONOPPIDOpportunity NumberNumericGeneric Edit150
38F90CB05CSales_Cycle_Notification_Ledger Table1NLOPPIDOpportunity NumberNumericGeneric Edit150
39F90CB06AForecast Opportunity2FOOPPIDOpportunity NumberNumericGeneric Edit150
40F90CB06BOpportunity_For_Forecast Table2OFOPPIDOpportunity NumberNumericGeneric Edit150
41F90CB06COpportunity_Item_For_Forecast Table2OHOPPIDOpportunity NumberNumericGeneric Edit150
42F90CB06ZOpportunity for Forecast WTF2ZFOPPIDOpportunity NumberNumericGeneric Edit150