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

157 columns | Print definition?920 | EFTE

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00092Supplemental Data15T3EFTEDate - Ending EffectiveDateGeneric Edit60
2F00692Cost Center Supplemental Data Codes5M2EFTEDate - Ending EffectiveDateGeneric Edit60
TOP01: Address Book
3F01092Supplemental Database - Code7A2EFTEDate - Ending EffectiveDateGeneric Edit60
TOP03B: Enhanced Accounts Receivable
4F03B27A/R Delinquency Policy Detail - Fees4RMEFTEDate - Ending EffectiveDateGeneric Edit60
TOP05: Time Accounting and HRM Base
5F06005Batch Processing Parameters10JEEFTEDate - Ending EffectiveDateGeneric Edit60
6F069116Payroll Transaction Constants67YCEFTEDate - Ending EffectiveDateGeneric Edit60
7F069126Union Rates File4YLEFTEDate - Ending EffectiveDateGeneric Edit60
8F0691261Additional Union Rates4YLEFTEDate - Ending EffectiveDateGeneric Edit60
9F069216Workers Compensation Insurance Rates4YBEFTEDate - Ending EffectiveDateGeneric Edit60
10F069226Unemployment Insurance Rates13YHEFTEDate - Ending EffectiveDateGeneric Edit60
11F06923Valid Job Type/ Step Constant20YHEFTEDate - Ending EffectiveDateGeneric Edit60
12F06925Employee/Vendor Cross Reference9YGEFTEDate - Ending EffectiveDateGeneric Edit60
13F06931Wage Attachment File6J3EFTEDate - Ending EffectiveDateGeneric Edit60
14F069311Wage Attachment Additional Exemptions5J3EFTEDate - Ending EffectiveDateGeneric Edit60
15F069312Wage Attachment Exemptions File3J3EFTEDate - Ending EffectiveDateGeneric Edit60
16F06933Step Progression Parameters4J@EFTEDate - Ending EffectiveDateGeneric Edit60
17F06936Retro Pay Types Rate9JAEFTEDate - Ending EffectiveDateGeneric Edit60
TOP05A: PeopleSoft HR & PR Foundation
18F069056Establishment Constant File9YOEFTEDate - Ending EffectiveDateGeneric Edit60
TOP05T: Time Entry
19F051126Managers Delegates Setup File4Y6EFTEDate - Ending EffectiveDateGeneric Edit60
20F05601Component Pay Instructions4CPEFTEDate - Ending EffectiveDateGeneric Edit60
21F06022Employee Piecerate File21JAEFTEDate - Ending EffectiveDateGeneric Edit60
22F06918PF - Piece Rate File7JNEFTEDate - Ending EffectiveDateGeneric Edit60
23F069246Shift Differential Table5Y3EFTEDate - Ending EffectiveDateGeneric Edit60
TOP06: Payroll (old) - Obsolete-do not reuse
24F060146Employees Pay Rate File9JIEFTEDate - Ending EffectiveDateGeneric Edit60
25F06210Payroll Cycle Parameters10YDEFTEDate - Ending EffectiveDateGeneric Edit60
TOP07: Payroll
26F06053Interim Check Parameters File23YWEFTEDate - Ending EffectiveDateGeneric Edit60
27F0701732Additional Tax Overrides6AOEFTEDate - Ending EffectiveDateGeneric Edit60
28F07210Pay Cycle Parameters File34YDEFTEDate - Ending EffectiveDateGeneric Edit60
29F0729Employee DBA Override Instructions35Y9EFTEDate - Ending EffectiveDateGeneric Edit60
30F079320Wage Attachment Exemptions by Pay Frequency4WXEFTEDate - Ending EffectiveDateGeneric Edit60
TOP08: Human Resources
31F0800601Organizational Business Unit/Job Cross-Reference5JCEFTEDate - Ending EffectiveDateGeneric Edit60
32F0800603Job Group Competencies4JCEFTEDate - Ending EffectiveDateGeneric Edit60
33F0800604Organizational Business Unit Competencies4JCEFTEDate - Ending EffectiveDateGeneric Edit60
34F0800605Job Type/Step Competencies5JCEFTEDate - Ending EffectiveDateGeneric Edit60
35F0800606Competency Options - Overrides4JCEFTEDate - Ending EffectiveDateGeneric Edit60
36F0800607Organizational Competencies4JCEFTEDate - Ending EffectiveDateGeneric Edit60
37F0800608Date Effective Organizational Structure3JCEFTEDate - Ending EffectiveDateGeneric Edit60
38F0800610Competencies in Structure and Job6JCEFTEDate - Ending EffectiveDateGeneric Edit60
39F0800611Job Competency Default - Overrides4JCEFTEDate - Ending EffectiveDateGeneric Edit60
40F0800612User Defined Job Competency Description Reference5JCEFTEDate - Ending EffectiveDateGeneric Edit60
41F08006WFJob Competency Default Overrides Work File10JCEFTEDate - Ending EffectiveDateGeneric Edit60
42F08092Human Resources General Description-User Def Codes8JZEFTEDate - Ending EffectiveDateGeneric Edit60
43F08338Primary Care Physician Table5E7EFTEDate - Ending EffectiveDateGeneric Edit60
44F085520Available Plans and Plan Options by Employee History Table11PHEFTEDate - Ending EffectiveDateGeneric Edit60
45F085520WAvailable Plans and Plan Options by Employee Work Table23APEFTEDate - Ending EffectiveDateGeneric Edit60
46F085530WEmployee Current/Pending Elections Work Table9CPEFTEDate - Ending EffectiveDateGeneric Edit60
47F085536Dependent/Beneficiary X-Reference History Table10DHEFTEDate - Ending EffectiveDateGeneric Edit60
48F085536WDependent/Beneficiary X-Reference Work Table10DBEFTEDate - Ending EffectiveDateGeneric Edit60
49F085537WCurrent Dep/Ben X-Reference Work Table9XBEFTEDate - Ending EffectiveDateGeneric Edit60
50F08750Managers Delegates4MDEFTEDate - Ending EffectiveDateGeneric Edit60
51F08JDWF1Job Description Changes Integration Work File3JCEFTEDate - Ending EffectiveDateGeneric Edit60
52F08JDWF2Job Description History Integration Work File15JHEFTEDate - Ending EffectiveDateGeneric Edit60
TOP08AD: ADP Integration
53F051375ADP Payroll DBA Transaction Constants69ADEFTEDate - Ending EffectiveDateGeneric Edit60
54F05138ADP - Pay Cycle Review Control5PCEFTEDate - Ending EffectiveDateGeneric Edit60
TOP08B: Benefits Administration
55F06024Beneficiary/Co-owner File10YJEFTEDate - Ending EffectiveDateGeneric Edit60
56F08320Benefits Plan Master6BAEFTEDate - Ending EffectiveDateGeneric Edit60
57F083203Plan Master Rates6BGEFTEDate - Ending EffectiveDateGeneric Edit60
58F08320WFAvailable Plans and Plan Options by Employee Work Table23BVEFTEDate - Ending EffectiveDateGeneric Edit60
59F08330Employee Enrollment4BGEFTEDate - Ending EffectiveDateGeneric Edit60
60F08336Dep/Ben to Employee Plan X-Reference10BJEFTEDate - Ending EffectiveDateGeneric Edit60
61F08336WFDependent/Beneficiary X-Ref Work Table11BDEFTEDate - Ending EffectiveDateGeneric Edit60
62F08346401(K) Elections5B4EFTEDate - Ending EffectiveDateGeneric Edit60
63F08351Plans within Benefit Categories6BUEFTEDate - Ending EffectiveDateGeneric Edit60
64F08380WFBatch Enrollment Work File8BEEFTEDate - Ending EffectiveDateGeneric Edit60
65F08500Enrollment Event Setup4ESEFTEDate - Ending EffectiveDateGeneric Edit60
66F08511Employee Pension Activity Detail5HJEFTEDate - Ending EffectiveDateGeneric Edit60
TOP08H: Health and Safety
67F086401Injury/Illness Report Header Information5RHEFTEDate - Ending EffectiveDateGeneric Edit60
TOP08P: Position Control
68F08001Job information69JMEFTEDate - Ending EffectiveDateGeneric Edit60
TOP08R: Recruitment Management - (Appl. Track. & Req.)
69F06018Date Parameter Extension6YFEFTEDate - Ending EffectiveDateGeneric Edit60
TOP08U: PeopleSoft HR US
70F08360Nondiscrimination Groups23HEEFTEDate - Ending EffectiveDateGeneric Edit60
71F08920COBRA Coverage30JSEFTEDate - Ending EffectiveDateGeneric Edit60
72F08990COBRA General Constants4HWEFTEDate - Ending EffectiveDateGeneric Edit60
73F089901COBRA General Constants Additional Information4CCEFTEDate - Ending EffectiveDateGeneric Edit60
74F089902COBRA General Constants - COBRA Notices Information5J2EFTEDate - Ending EffectiveDateGeneric Edit60
75F08991COBRA Qualifying Event Constant6HDEFTEDate - Ending EffectiveDateGeneric Edit60
76F08992Qualifying Event Rules Header7QEEFTEDate - Ending EffectiveDateGeneric Edit60
TOP08W: Wage and Salary
77F08818Increase Type Rules5YMEFTEDate - Ending EffectiveDateGeneric Edit60
78F08820Increase Guideline Master Table3YTEFTEDate - Ending EffectiveDateGeneric Edit60
79F08821Increase Guideline Range Table4YDEFTEDate - Ending EffectiveDateGeneric Edit60
TOP09: General Accounting
80F48S83Pool Definition3PDEFTEDate - Ending EffectiveDateGeneric Edit60
81F48S84Pool Grouping Codes11PGEFTEDate - Ending EffectiveDateGeneric Edit60
82F52G32WPool Grouping Selection Workfile4PGEFTEDate - Ending EffectiveDateGeneric Edit60
TOP12: Fixed Assets
83F12002Default Accounting Constants25FDEFTEDate - Ending EffectiveDateGeneric Edit60
84F12003Default Depreciation Constants22FFEFTEDate - Ending EffectiveDateGeneric Edit60
85F12092Fixed Assets Supplemental Data Codes Type5F3EFTEDate - Ending EffectiveDateGeneric Edit60
86F1212Parent History4FYEFTEDate - Ending EffectiveDateGeneric Edit60
87F1212PParent History Purge Table4FYEFTEDate - Ending EffectiveDateGeneric Edit60
88F12851Depreciation Rules9LUEFTEDate - Ending EffectiveDateGeneric Edit60
89F12851DDemo Depreciation Rules9LUEFTEDate - Ending EffectiveDateGeneric Edit60
90F1301Equipment Rates5FGEFTEDate - Ending EffectiveDateGeneric Edit60
91F1301PEquipment Rates Purge Table5FGEFTEDate - Ending EffectiveDateGeneric Edit60
TOP13: Plant/Equipment Management
92F1307Status History File7F1EFTEDate - Ending EffectiveDateGeneric Edit60
93F1307PStatus History Purge Table7F1EFTEDate - Ending EffectiveDateGeneric Edit60
TOP15: Real Estate Management
94F1501Tenant/Lease Master34NEEFTEDate - Ending EffectiveDateGeneric Edit60
95F15012Tenant E.P. Class Master21NSEFTEDate - Ending EffectiveDateGeneric Edit60
96F15012BTenant E.P. Class Master23NSEFTEDate - Ending EffectiveDateGeneric Edit60
97F15013BSales Overage Master File6NOEFTEDate - Ending EffectiveDateGeneric Edit60
98F15014Product Scales Master7NPEFTEDate - Ending EffectiveDateGeneric Edit60
99F15014BProduct Scales Master18NPEFTEDate - Ending EffectiveDateGeneric Edit60
100F15015Minimum rent/recoveries Master5NQEFTEDate - Ending EffectiveDateGeneric Edit60
101F15015BMin/Max Rents And Recoveries Master14NQEFTEDate - Ending EffectiveDateGeneric Edit60
102F15016Tenant Escalation Master37NUEFTEDate - Ending EffectiveDateGeneric Edit60
103F15016BTenant Escalation Master38NUEFTEDate - Ending EffectiveDateGeneric Edit60
104F1501BLease Master Header27NEEFTEDate - Ending EffectiveDateGeneric Edit60
105F1502Recurring Billings Master10NFEFTEDate - Ending EffectiveDateGeneric Edit60
106F1502BRecurring Billings Master10NFEFTEDate - Ending EffectiveDateGeneric Edit60
107F1502WABRent Increase Amounts8NFEFTEDate - Ending EffectiveDateGeneric Edit60
108F1502WBEstimated EP Recurring Billings12N4EFTEDate - Ending EffectiveDateGeneric Edit60
109F1505Management Fee Master7NDEFTEDate - Ending EffectiveDateGeneric Edit60
110F1505BManagement Fee Master9NDEFTEDate - Ending EffectiveDateGeneric Edit60
111F15110BExpense Participation Class Account5OBEFTEDate - Ending EffectiveDateGeneric Edit60
112F1514Area Master13NWEFTEDate - Ending EffectiveDateGeneric Edit60
113F1514WArea Work File2NWEFTEDate - Ending EffectiveDateGeneric Edit60
114F1525A/R Fee Interest25N0EFTEDate - Ending EffectiveDateGeneric Edit60
115F1525BFees and Interest26NMEFTEDate - Ending EffectiveDateGeneric Edit60
116F1530Expense Participation Class Master11NGEFTEDate - Ending EffectiveDateGeneric Edit60
117F15301E.P. Class Account Overrides6AOEFTEDate - Ending EffectiveDateGeneric Edit60
118F1531Expense Participation Class Adjustment5OMEFTEDate - Ending EffectiveDateGeneric Edit60
119F1533Tenant Class Account Exclusions7NMEFTEDate - Ending EffectiveDateGeneric Edit60
120F1533BTenant Account Exclusions8NMEFTEDate - Ending EffectiveDateGeneric Edit60
121F1538B1Occupancy Gross Up Audit38GUEFTEDate - Ending EffectiveDateGeneric Edit60
122F1539EEP Billing Account Exclusions Audit10AUEFTEDate - Ending EffectiveDateGeneric Edit60
123F1539FCEP Billing Adj Factor EP Class Audit9AUEFTEDate - Ending EffectiveDateGeneric Edit60
124F1539FLEP Billing Adj Factor Lease Audit9AUEFTEDate - Ending EffectiveDateGeneric Edit60
125F1565Security Deposit Master8JFEFTEDate - Ending EffectiveDateGeneric Edit60
126F1570Legal Clauses9NDEFTEDate - Ending EffectiveDateGeneric Edit60
127F15703Legal Clause Amounts9NIEFTEDate - Ending EffectiveDateGeneric Edit60
128F159071Market/Potential/Renewal Rent Master9NYEFTEDate - Ending EffectiveDateGeneric Edit60
TOP15L: Adv Real Estate Forecasting
129F15L101AREF Unit Master29UMEFTEDate - Ending EffectiveDateGeneric Edit60
130F15L109AREF Budget Results26BREFTEDate - Ending EffectiveDateGeneric Edit60
131F15L401AREF Share Factor Denominator Audit47SFEFTEDate - Ending EffectiveDateGeneric Edit60
132F15L402AREF Tenant Exclusion Rule Audit8SGEFTEDate - Ending EffectiveDateGeneric Edit60
133F15L403AREF Gross Up Processing Audit28SHEFTEDate - Ending EffectiveDateGeneric Edit60
TOP39: Advanced Stock Valuation
134F3908Item Pool Valuation Cost Master5CSEFTEDate - Ending EffectiveDateGeneric Edit60
TOP41: Inventory Management
135F41092Item Supplemental Data Base User Defined Codes7T2EFTEDate - Ending EffectiveDateGeneric Edit60
TOP43: Procurement
136F74U0142ACM - Application / Certificate Status History11DHEFTEDate - Ending EffectiveDateGeneric Edit60
TOP48S: Service Billing
137F48096Billing Rate / Mark up Table4WQEFTEDate - Ending EffectiveDateGeneric Edit60
138F48127Tax Derivation Information5WOEFTEDate - Ending EffectiveDateGeneric Edit60
139F4860Component Table Master4AFEFTEDate - Ending EffectiveDateGeneric Edit60
140F48S95Billing AAI Information5WVEFTEDate - Ending EffectiveDateGeneric Edit60
TOP51X: In-Memory Project Management
141F51X30Project Advisor Results Header102PBEFTEDate - Ending EffectiveDateGeneric Edit60
TOP52G: Proj & Gov Contract Accounting
142F52G21Contract Specific Labor Category Cross Reference8LREFTEDate - Ending EffectiveDateGeneric Edit60
TOP74U: United Kingdom Localizations
143F74U0118Payment Voucher Status History - 0410VHEFTEDate - Ending EffectiveDateGeneric Edit60
144F74U4314SPC - Purchase Order Retention - UK - 436SDEFTEDate - Ending EffectiveDateGeneric Edit60
145F74U4318SPC - Purchase Order Line Retention - UK - 437SDEFTEDate - Ending EffectiveDateGeneric Edit60
TOP75A: Australia
146F75A0500AU Bonus and Back Pay Tax Workfile8BPEFTEDate - Ending EffectiveDateGeneric Edit60
147F75A0501AU Bonus and Back Pay Tax History8THEFTEDate - Ending EffectiveDateGeneric Edit60
TOP75Z: New Zealand
148F75Z0008New Zealand Special Rates4Z8EFTEDate - Ending EffectiveDateGeneric Edit60
TOP76A: Argentina
149F76A396Item Valuation Cost Master - 76A5CSEFTEDate - Ending EffectiveDateGeneric Edit60
TOP76B: Brazil
150F76B040ePIS COFINS Job Header - BRA - 76B6PHEFTEDate - Ending EffectiveDateGeneric Edit60
151F76B0510Electronic Reporting Process Header - BR -5PHEFTEDate - Ending EffectiveDateGeneric Edit60
152F76B0740Ato Cotepe Process - BR - 006PHEFTEDate - Ending EffectiveDateGeneric Edit60
153F76B61Packing and Raw Material Table - IN68 - 309IEEFTEDate - Ending EffectiveDateGeneric Edit60
154F76B839FCONT Jobs Periodicity - 76B4JPEFTEDate - Ending EffectiveDateGeneric Edit60
155F76B940SPED Jobs -BR - 0914SJEFTEDate - Ending EffectiveDateGeneric Edit60
156F76B944SPED Job Batches - BR - 095SBEFTEDate - Ending EffectiveDateGeneric Edit60
TOP76P: Peru
157F76P503Regional Constants by Asset Number - PER - 12 - 76P2RCEFTEDate - Ending EffectiveDateGeneric Edit60