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

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
10F4111ILItem Ledger File

812: Top 10 requests

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

23 columns | Print definition?920 | 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
4F085590Disability and Veteran Status History Table13DSEECDEnrollment Event CodeStringUDC30
5F085590WDisability Status Work Table5DSEECDEnrollment Event CodeStringUDC30
6F085605WVeteran Status Work Table7VSEECDEnrollment Event CodeStringUDC30
TOP08: Human Resources
7F05401Self-Service Process Flow Director Text1DTEECDEnrollment Event CodeStringUDC30
8F08336BDep/Ben X-Reference Tag Table6E2EECDEnrollment Event CodeStringUDC30
9F08338Primary Care Physician Table10E7EECDEnrollment Event CodeStringUDC30
10F085510Benefit Categories by Enrollment Events1EREECDEnrollment Event CodeStringUDC30
11F085515Workflow Process File4WPEECDEnrollment Event CodeStringUDC30
12F085520Available Plans and Plan Options by Employee History Table12PHEECDEnrollment Event CodeStringUDC30
13F085520WAvailable Plans and Plan Options by Employee Work Table29APEECDEnrollment Event CodeStringUDC30
14F085528ESS History Table Cross Reference4ESEECDEnrollment Event CodeStringUDC30
15F085536Dependent/Beneficiary X-Reference History Table11DHEECDEnrollment Event CodeStringUDC30
16F085536WDependent/Beneficiary X-Reference Work Table11DBEECDEnrollment Event CodeStringUDC30
17F085550Employee Self-Service Personal Information Options1IOEECDEnrollment Event CodeStringUDC30
TOP08B: Benefits Administration
18F08320WFAvailable Plans and Plan Options by Employee Work Table24BVEECDEnrollment Event CodeStringUDC30
19F08330BEmployee Enrollment Tag File5BTEECDEnrollment Event CodeStringUDC30
20F08336WFDependent/Beneficiary X-Ref Work Table12BDEECDEnrollment Event CodeStringUDC30
21F08500Enrollment Event Setup2ESEECDEnrollment Event CodeStringUDC30
22F08510Benefit Categories by Enrollment Events1BCEECDEnrollment Event CodeStringUDC30
23F085518Benefit 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) Enrollment1Y
2       BENChange Your Beneficiaries Y
3       CHDChildren Y
4       CURView Current Elections Y
5       DIVDivorce Y
6       DTHDependent Death Y
7       ECEmergency Contact N
8       MARMarriage Y
9       MOVMoving Y
10       NHRNew Hire Y
11       OPNOpen Enrollment1Y
12       PIPersonal Information N
13       RHRRehire Y
14       SP1Special Enrollment 1 Y
15       SP2Special Enrollment 2 Y
16       TETime Entry Y
17       W4W4 Changes N