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
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

26 columns | Print definition?812 | PROCNAME

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP05: Time Accounting and HRM Base
1F05420Workflow Approval Table3WAPROCNAMEProcess IDStringGeneric Edit100
TOP08: Human Resources
2F085515Workflow Process File2WPPROCNAMEProcess IDStringGeneric Edit100
3F087103Setup Task Details17TDPROCNAMEProcess IDStringGeneric Edit100
TOP40R: Demand Scheduling
4F40R22Demand Workflow4DWPROCNAMEProcess IDStringGeneric Edit100
TOP43: Procurement
5F43E09F43E09 - Approvals Activity Table2AAPROCNAMEProcess IDStringGeneric Edit100
TOPH90: ONEWORLD TOOLS
6F98800Process Master1PMPROCNAMEProcess IDStringGeneric Edit100
7F98800DProcess Master Alternate Description1PKPROCNAMEProcess IDStringGeneric Edit100
8F98800DNProcess Master Alternate Description - Net Change3PKPROCNAMEProcess IDStringGeneric Edit100
9F98800NProcess Master - Net Change3PMPROCNAMEProcess IDStringGeneric Edit100
10F98800TProcess Master Supplemental Information1PTPROCNAMEProcess IDStringGeneric Edit100
11F98800TNProcess Master Supplemental Information - Net Change3PTPROCNAMEProcess IDStringGeneric Edit100
12F98810Activity Master1AMPROCNAMEProcess IDStringGeneric Edit100
13F98810DActivity Master Alternate Description1AKPROCNAMEProcess IDStringGeneric Edit100
14F98810DNActivity Master Alternate Description - Net Change3AKPROCNAMEProcess IDStringGeneric Edit100
15F98810NActivity Master - Net Change3AMPROCNAMEProcess IDStringGeneric Edit100
16F98811Activity Specifications10ATPROCNAMEProcess IDStringGeneric Edit100
17F98811NActivity Specifications - Net Change12ATPROCNAMEProcess IDStringGeneric Edit100
18F98830Process Activity Associations1ARPROCNAMEProcess IDStringGeneric Edit100
19F98830NProcess Activity Associations - Net Change3ARPROCNAMEProcess IDStringGeneric Edit100
20F98845Organizational Structure Rule1ORPROCNAMEProcess IDStringGeneric Edit100
21F98845NOrganizational Structure Rule - Net Change3ORPROCNAMEProcess IDStringGeneric Edit100
22F98860Process Instance1PIPROCNAMEProcess IDStringGeneric Edit100
23F98865Activity Instance1AIPROCNAMEProcess IDStringGeneric Edit100
24F98885Composer Industry and Geographical Regions2GIPROCNAMEProcess IDStringGeneric Edit100
25F98890Composer Tag File1CMPROCNAMEProcess IDStringGeneric Edit100
TOPH91: Design Tools
26F91300Schedule Job Master5SJPROCNAMEProcess IDStringGeneric Edit100