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

20 columns | Print definition?812 | EECD | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP05: Time Accounting and HRM Base
1F05400Self-Service Process Flow Settings1PFEECDEnrollment Event CodeStringUDC30
2F05420Workflow Approval Table13WAEECDEnrollment Event CodeStringUDC30
3F05430ESS User Defined Text1UTEECDEnrollment Event CodeStringUDC30
TOP08: Human Resources
4F05401Self-Service Process Flow Director Text1DTEECDEnrollment Event CodeStringUDC30
5F08336BDep/Ben X-Reference Tag Table6E2EECDEnrollment Event CodeStringUDC30
6F08338Primary Care Physician Table10E7EECDEnrollment Event CodeStringUDC30
7F085510Benefit Categories by Enrollment Events1EREECDEnrollment Event CodeStringUDC30
8F085515Workflow Process File4WPEECDEnrollment Event CodeStringUDC30
9F085520Available Plans and Plan Options by Employee History Table12PHEECDEnrollment Event CodeStringUDC30
10F085520WAvailable Plans and Plan Options by Employee Work Table29APEECDEnrollment Event CodeStringUDC30
11F085528ESS History Table Cross Reference4ESEECDEnrollment Event CodeStringUDC30
12F085536Dependent/Beneficiary X-Reference History Table11DHEECDEnrollment Event CodeStringUDC30
13F085536WDependent/Beneficiary X-Reference Work Table11DBEECDEnrollment Event CodeStringUDC30
14F085550Employee Self-Service Personal Information Options1IOEECDEnrollment Event CodeStringUDC30
TOP08B: Benefits Administration
15F08320WFAvailable Plans and Plan Options by Employee Work Table24BVEECDEnrollment Event CodeStringUDC30
16F08330BEmployee Enrollment Tag File5BTEECDEnrollment Event CodeStringUDC30
17F08336WFDependent/Beneficiary X-Ref Work Table12BDEECDEnrollment Event CodeStringUDC30
18F08500Enrollment Event Setup2ESEECDEnrollment Event CodeStringUDC30
19F08510Benefit Categories by Enrollment Events1BCEECDEnrollment Event CodeStringUDC30
20F085518Benefit Confirmation Statement Options1SOEECDEnrollment Event CodeStringUDC30

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 08 / BE (Benefit Enrollment Events) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1       401401(k) Enrollment1N
2       BENChange Your BeneficiariesN
3       CHDChildrenN
4       CURView Current ElectionsY
5       DIVDivorceN
6       MARMarriageN
7       NHRNew HireN
8       OPNOpen Enrollment1N
9       RHRRehireN
10       SP1Special Enrollment 1N
11       SP2Special Enrollment 2N