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
4F9671SDSoftware Update Detail Table
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F41021LIItem Location File
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
7F03B11RPCustomer Ledger
8F4311PDPurchase Order Detail File
9F4111ILItem Ledger File
10F0411RPAccounts Payable Ledger

812: Top 10 requests

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

52 columns | Print definition?920 | EFT

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00092Supplemental Data11T3EFTDate - EffectiveDateGeneric Edit60
2F00093Flash Messages4FMEFTDate - EffectiveDateGeneric Edit60
3F00692Cost Center Supplemental Data Codes4M2EFTDate - EffectiveDateGeneric Edit60
4F00693Cost Center Supplemental Data Text4M3EFTDate - EffectiveDateGeneric Edit60
5F0087Conversion Constants File for Euro4EUEFTDate - EffectiveDateGeneric Edit60
TOP01: Address Book
6F01092Supplemental Database - Code6A2EFTDate - EffectiveDateGeneric Edit60
7F01093Supplemental Database - Narrative5A3EFTDate - EffectiveDateGeneric Edit60
TOP05: Time Accounting and HRM Base
8F05122Action Plan4APEFTDate - EffectiveDateGeneric Edit60
TOP08: Human Resources
9F0800609Gap Analysis Snapshot3YIEFTDate - EffectiveDateGeneric Edit60
10F08092Human Resources General Description-User Def Codes7JZEFTDate - EffectiveDateGeneric Edit60
11F08093Human Resources General Description - Narration7JYEFTDate - EffectiveDateGeneric Edit60
12F08336BDep/Ben X-Reference Tag Table5E2EFTDate - EffectiveDateGeneric Edit60
13F08338Primary Care Physician Table4E7EFTDate - EffectiveDateGeneric Edit60
14F08338BPrimary Care Physician Tag Table4PTEFTDate - EffectiveDateGeneric Edit60
15F085520Available Plans and Plan Options by Employee History Table10PHEFTDate - EffectiveDateGeneric Edit60
16F085520WAvailable Plans and Plan Options by Employee Work Table22APEFTDate - EffectiveDateGeneric Edit60
17F085530WEmployee Current/Pending Elections Work Table8CPEFTDate - EffectiveDateGeneric Edit60
18F085536Dependent/Beneficiary X-Reference History Table9DHEFTDate - EffectiveDateGeneric Edit60
19F085536WDependent/Beneficiary X-Reference Work Table9DBEFTDate - EffectiveDateGeneric Edit60
20F085537WCurrent Dep/Ben X-Reference Work Table8XBEFTDate - EffectiveDateGeneric Edit60
21F08JDWF2Job Description History Integration Work File26JHEFTDate - EffectiveDateGeneric Edit60
TOP08B: Benefits Administration
22F08320Benefits Plan Master5BAEFTDate - EffectiveDateGeneric Edit60
23F08320WFAvailable Plans and Plan Options by Employee Work Table20BVEFTDate - EffectiveDateGeneric Edit60
24F08330Employee Enrollment3BGEFTDate - EffectiveDateGeneric Edit60
25F08330BEmployee Enrollment Tag File4BTEFTDate - EffectiveDateGeneric Edit60
26F08330CEmployee Enrollment Tag Table C4PCEFTDate - EffectiveDateGeneric Edit60
27F08330WFEmployee Current/Pending Elections Work Table8BREFTDate - EffectiveDateGeneric Edit60
28F08336Dep/Ben to Employee Plan X-Reference9BJEFTDate - EffectiveDateGeneric Edit60
29F08336WFDependent/Beneficiary X-Ref Work Table9BDEFTDate - EffectiveDateGeneric Edit60
30F08346401(K) Elections3B4EFTDate - EffectiveDateGeneric Edit60
31F08351Plans within Benefit Categories5BUEFTDate - EffectiveDateGeneric Edit60
32F08351BPlans within Categories Tag Table5PCEFTDate - EffectiveDateGeneric Edit60
33F08380WFBatch Enrollment Work File7BEEFTDate - EffectiveDateGeneric Edit60
34F08500Enrollment Event Setup3ESEFTDate - EffectiveDateGeneric Edit60
35F08511Employee Pension Activity Detail4HJEFTDate - EffectiveDateGeneric Edit60
TOP08H: Health and Safety
36F086401Injury/Illness Report Header Information4RHEFTDate - EffectiveDateGeneric Edit60
TOP08W: Wage and Salary
37F08818Increase Type Rules4YMEFTDate - EffectiveDateGeneric Edit60
38F08820Increase Guideline Master Table2YTEFTDate - EffectiveDateGeneric Edit60
39F08821Increase Guideline Range Table2YDEFTDate - EffectiveDateGeneric Edit60
TOP11: Multi Currency
40F0015Currency Exchange Rates5CXEFTDate - EffectiveDateGeneric Edit60
41F0015Z1External Currency Exchange Rates27ZEEFTDate - EffectiveDateGeneric Edit60
42F1113Currency Restatement Rates File4C1EFTDate - EffectiveDateGeneric Edit60
TOP12: Fixed Assets
43F12092Fixed Assets Supplemental Data Codes Type4F3EFTDate - EffectiveDateGeneric Edit60
TOP41: Inventory Management
44F41092Item Supplemental Data Base User Defined Codes6T2EFTDate - EffectiveDateGeneric Edit60
TOP41F: Apparel Management
45FCW38Price List Exchange Rate3TREFTDate - EffectiveDateGeneric Edit60
46FCW84Exchange Rate for Outsource Operations2TREFTDate - EffectiveDateGeneric Edit60
TOP74P: Poland
47F74P0001Exchange Table Number - POL - 111ETEFTDate - EffectiveDateGeneric Edit60
TOP75T: Taiwan
48F75T1113Taiwan Exchange Rate Update4TREFTDate - EffectiveDateGeneric Edit60
TOP76A: Argentina
49F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A77HFEFTDate - EffectiveDateGeneric Edit60
50F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A77HFEFTDate - EffectiveDateGeneric Edit60
51F76AUI20Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A77HFEFTDate - EffectiveDateGeneric Edit60
TOP89: Conversion Programs
52F00151Needed for upgrade for XE and below6T1EFTDate - EffectiveDateGeneric Edit60