JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

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

160 columns | Print definition?920 | EFTB

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP01: Address Book
1F0101Address Book Master22ABEFTBDate - Beginning EffectiveDateGeneric Edit60
2F0101Z2Address Book - Interoperability35SZEFTBDate - Beginning EffectiveDateGeneric Edit60
3F0116Address by Date2ALEFTBDate - Beginning EffectiveDateGeneric Edit60
4F01161Alternate Address3WLEFTBDate - Beginning EffectiveDateGeneric Edit60
5F01161DWCustomer Alternate Address Export4DWEFTBDate - Beginning EffectiveDateGeneric Edit60
6F01161Z1Batch - Alternative Address16LBEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP03: Accounts Receivable
7F03012ADate Effective Category Codes3A2EFTBDate - Beginning EffectiveDateGeneric Edit60
TOP03B: Enhanced Accounts Receivable
8F03B27A/R Delinquency Policy Detail - Fees3RMEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP05: Time Accounting and HRM Base
9F06005Batch Processing Parameters9JEEFTBDate - Beginning EffectiveDateGeneric Edit60
10F0625Change Code History File12JBEFTBDate - Beginning EffectiveDateGeneric Edit60
11F06251Step Progression Rate History File6JBEFTBDate - Beginning EffectiveDateGeneric Edit60
12F0627Workers Compensation Summary History7JHEFTBDate - Beginning EffectiveDateGeneric Edit60
13F069116Payroll Transaction Constants66YCEFTBDate - Beginning EffectiveDateGeneric Edit60
14F069126Union Rates File3YLEFTBDate - Beginning EffectiveDateGeneric Edit60
15F0691261Additional Union Rates3YLEFTBDate - Beginning EffectiveDateGeneric Edit60
16F069216Workers Compensation Insurance Rates3YBEFTBDate - Beginning EffectiveDateGeneric Edit60
17F069226Unemployment Insurance Rates12YHEFTBDate - Beginning EffectiveDateGeneric Edit60
18F06923Valid Job Type/ Step Constant19YHEFTBDate - Beginning EffectiveDateGeneric Edit60
19F06925Employee/Vendor Cross Reference8YGEFTBDate - Beginning EffectiveDateGeneric Edit60
20F06931Wage Attachment File5J3EFTBDate - Beginning EffectiveDateGeneric Edit60
21F069311Wage Attachment Additional Exemptions4J3EFTBDate - Beginning EffectiveDateGeneric Edit60
22F069312Wage Attachment Exemptions File2J3EFTBDate - Beginning EffectiveDateGeneric Edit60
23F06933Step Progression Parameters3J@EFTBDate - Beginning EffectiveDateGeneric Edit60
24F06936Retro Pay Types Rate8JAEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP05A: PeopleSoft HR & PR Foundation
25F069056Establishment Constant File8YOEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP05T: Time Entry
26F05601Component Pay Instructions3CPEFTBDate - Beginning EffectiveDateGeneric Edit60
27F06918PF - Piece Rate File6JNEFTBDate - Beginning EffectiveDateGeneric Edit60
28F069246Shift Differential Table4Y3EFTBDate - Beginning EffectiveDateGeneric Edit60
TOP06: Payroll (old) - Obsolete-do not reuse
29F060146Employees Pay Rate File8JIEFTBDate - Beginning EffectiveDateGeneric Edit60
30F06210Payroll Cycle Parameters9YDEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP07: Payroll
31F06053Interim Check Parameters File22YWEFTBDate - Beginning EffectiveDateGeneric Edit60
32F0701732Additional Tax Overrides5AOEFTBDate - Beginning EffectiveDateGeneric Edit60
33F07210Pay Cycle Parameters File33YDEFTBDate - Beginning EffectiveDateGeneric Edit60
34F0729Employee DBA Override Instructions34Y9EFTBDate - Beginning EffectiveDateGeneric Edit60
35F079320Wage Attachment Exemptions by Pay Frequency3WXEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP08: Human Resources
36F0800601Organizational Business Unit/Job Cross-Reference4JCEFTBDate - Beginning EffectiveDateGeneric Edit60
37F0800603Job Group Competencies3JCEFTBDate - Beginning EffectiveDateGeneric Edit60
38F0800604Organizational Business Unit Competencies3JCEFTBDate - Beginning EffectiveDateGeneric Edit60
39F0800605Job Type/Step Competencies4JCEFTBDate - Beginning EffectiveDateGeneric Edit60
40F0800606Competency Options - Overrides3JCEFTBDate - Beginning EffectiveDateGeneric Edit60
41F0800607Organizational Competencies3JCEFTBDate - Beginning EffectiveDateGeneric Edit60
42F0800608Date Effective Organizational Structure2JCEFTBDate - Beginning EffectiveDateGeneric Edit60
43F0800610Competencies in Structure and Job5JCEFTBDate - Beginning EffectiveDateGeneric Edit60
44F0800611Job Competency Default - Overrides3JCEFTBDate - Beginning EffectiveDateGeneric Edit60
45F0800612User Defined Job Competency Description Reference4JCEFTBDate - Beginning EffectiveDateGeneric Edit60
46F08006WFJob Competency Default Overrides Work File9JCEFTBDate - Beginning EffectiveDateGeneric Edit60
47F08JDWF1Job Description Changes Integration Work File2JCEFTBDate - Beginning EffectiveDateGeneric Edit60
48F08JDWF2Job Description History Integration Work File14JHEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP08AD: ADP Integration
49F051375ADP Payroll DBA Transaction Constants68ADEFTBDate - Beginning EffectiveDateGeneric Edit60
50F05138ADP - Pay Cycle Review Control4PCEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP08B: Benefits Administration
51F06024Beneficiary/Co-owner File11YJEFTBDate - Beginning EffectiveDateGeneric Edit60
52F083203Plan Master Rates5BGEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP08P: Position Control
53F08001Job information68JMEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP08R: Recruitment Management - (Appl. Track. & Req.)
54F06018Date Parameter Extension5YFEFTBDate - Beginning EffectiveDateGeneric Edit60
55F08102Requisition Information21HNEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP08U: PeopleSoft HR US
56F08360Nondiscrimination Groups22HEEFTBDate - Beginning EffectiveDateGeneric Edit60
57F08920COBRA Coverage29JSEFTBDate - Beginning EffectiveDateGeneric Edit60
58F08990COBRA General Constants3HWEFTBDate - Beginning EffectiveDateGeneric Edit60
59F089901COBRA General Constants Additional Information3CCEFTBDate - Beginning EffectiveDateGeneric Edit60
60F089902COBRA General Constants - COBRA Notices Information4J2EFTBDate - Beginning EffectiveDateGeneric Edit60
61F08991COBRA Qualifying Event Constant7HDEFTBDate - Beginning EffectiveDateGeneric Edit60
62F08992Qualifying Event Rules Header6QEEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP08W: Wage and Salary
63F08290Pay/Salary Formula File3HGEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP09: General Accounting
64F48S80Segment Definition2SDEFTBDate - Beginning EffectiveDateGeneric Edit60
65F48S81Burden Computation Method2CMEFTBDate - Beginning EffectiveDateGeneric Edit60
66F48S82Burden Base Rules3BREFTBDate - Beginning EffectiveDateGeneric Edit60
67F48S83Pool Definition2PDEFTBDate - Beginning EffectiveDateGeneric Edit60
68F48S84Pool Grouping Codes2PGEFTBDate - Beginning EffectiveDateGeneric Edit60
69F48S85Burden Rates2RTEFTBDate - Beginning EffectiveDateGeneric Edit60
70F52G32WPool Grouping Selection Workfile3PGEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP09E: Expense Reimbursment
71F09E110Audit Selection Rules7ASEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP12: Fixed Assets
72F12002Default Accounting Constants24FDEFTBDate - Beginning EffectiveDateGeneric Edit60
73F12003Default Depreciation Constants21FFEFTBDate - Beginning EffectiveDateGeneric Edit60
74F1201Asset Master File64FAEFTBDate - Beginning EffectiveDateGeneric Edit60
75F1201PAsset Master Purge Table64FAEFTBDate - Beginning EffectiveDateGeneric Edit60
76F1201Z1Unedited Asset Master Transactions75FAEFTBDate - Beginning EffectiveDateGeneric Edit60
77F1204Location Tracking Table16FMEFTBDate - Beginning EffectiveDateGeneric Edit60
78F1204PLocation Tracking Purge Table16FMEFTBDate - Beginning EffectiveDateGeneric Edit60
79F1212Parent History3FYEFTBDate - Beginning EffectiveDateGeneric Edit60
80F1212PParent History Purge Table3FYEFTBDate - Beginning EffectiveDateGeneric Edit60
81F12841Revaluation Index1RIEFTBDate - Beginning EffectiveDateGeneric Edit60
82F12851Depreciation Rules8LUEFTBDate - Beginning EffectiveDateGeneric Edit60
83F12851DDemo Depreciation Rules8LUEFTBDate - Beginning EffectiveDateGeneric Edit60
84F12852Annual Depreciation Rules6LVEFTBDate - Beginning EffectiveDateGeneric Edit60
85F12852DDemo Annual Depreciation Rules6LVEFTBDate - Beginning EffectiveDateGeneric Edit60
86F1301Equipment Rates4FGEFTBDate - Beginning EffectiveDateGeneric Edit60
87F1301PEquipment Rates Purge Table4FGEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP13: Plant/Equipment Management
88F1307Status History File3F1EFTBDate - Beginning EffectiveDateGeneric Edit60
89F1307PStatus History Purge Table3F1EFTBDate - Beginning EffectiveDateGeneric Edit60
TOP15: Real Estate Management
90F1501Tenant/Lease Master33NEEFTBDate - Beginning EffectiveDateGeneric Edit60
91F15012Tenant E.P. Class Master20NSEFTBDate - Beginning EffectiveDateGeneric Edit60
92F15012BTenant E.P. Class Master22NSEFTBDate - Beginning EffectiveDateGeneric Edit60
93F15013BSales Overage Master File7NOEFTBDate - Beginning EffectiveDateGeneric Edit60
94F15014Product Scales Master6NPEFTBDate - Beginning EffectiveDateGeneric Edit60
95F15014BProduct Scales Master8NPEFTBDate - Beginning EffectiveDateGeneric Edit60
96F15015Minimum rent/recoveries Master4NQEFTBDate - Beginning EffectiveDateGeneric Edit60
97F15015BMin/Max Rents And Recoveries Master6NQEFTBDate - Beginning EffectiveDateGeneric Edit60
98F15016Tenant Escalation Master36NUEFTBDate - Beginning EffectiveDateGeneric Edit60
99F15016BTenant Escalation Master37NUEFTBDate - Beginning EffectiveDateGeneric Edit60
100F1501BLease Master Header25NEEFTBDate - Beginning EffectiveDateGeneric Edit60
101F1502Recurring Billings Master9NFEFTBDate - Beginning EffectiveDateGeneric Edit60
102F1502BRecurring Billings Master9NFEFTBDate - Beginning EffectiveDateGeneric Edit60
103F1502WABRent Increase Amounts7NFEFTBDate - Beginning EffectiveDateGeneric Edit60
104F1502WBEstimated EP Recurring Billings11N4EFTBDate - Beginning EffectiveDateGeneric Edit60
105F1503Log Standards Master12NBEFTBDate - Beginning EffectiveDateGeneric Edit60
106F1505Management Fee Master6NDEFTBDate - Beginning EffectiveDateGeneric Edit60
107F1505BManagement Fee Master8NDEFTBDate - Beginning EffectiveDateGeneric Edit60
108F15110BExpense Participation Class Account4OBEFTBDate - Beginning EffectiveDateGeneric Edit60
109F1513FASB 13 Lease Control File11O3EFTBDate - Beginning EffectiveDateGeneric Edit60
110F1513BFASB 13 Lease Control11O3EFTBDate - Beginning EffectiveDateGeneric Edit60
111F1514Area Master12NWEFTBDate - Beginning EffectiveDateGeneric Edit60
112F1514WArea Work File1NWEFTBDate - Beginning EffectiveDateGeneric Edit60
113F1521Log Detail Master11NBEFTBDate - Beginning EffectiveDateGeneric Edit60
114F1525A/R Fee Interest24N0EFTBDate - Beginning EffectiveDateGeneric Edit60
115F1525BFees and Interest25NMEFTBDate - Beginning EffectiveDateGeneric Edit60
116F1530Expense Participation Class Master10NGEFTBDate - Beginning EffectiveDateGeneric Edit60
117F15301E.P. Class Account Overrides5AOEFTBDate - Beginning EffectiveDateGeneric Edit60
118F1531Expense Participation Class Adjustment4OMEFTBDate - Beginning EffectiveDateGeneric Edit60
119F1533Tenant Class Account Exclusions6NMEFTBDate - Beginning EffectiveDateGeneric Edit60
120F1533BTenant Account Exclusions7NMEFTBDate - Beginning EffectiveDateGeneric Edit60
121F1538B1Occupancy Gross Up Audit37GUEFTBDate - Beginning EffectiveDateGeneric Edit60
122F1539EEP Billing Account Exclusions Audit9AUEFTBDate - Beginning EffectiveDateGeneric Edit60
123F1539FCEP Billing Adj Factor EP Class Audit8AUEFTBDate - Beginning EffectiveDateGeneric Edit60
124F1539FLEP Billing Adj Factor Lease Audit8AUEFTBDate - Beginning EffectiveDateGeneric Edit60
125F1548Escalation Billing Register47N1EFTBDate - Beginning EffectiveDateGeneric Edit60
126F1548BEscalation Billing Register48N1EFTBDate - Beginning EffectiveDateGeneric Edit60
127F1565Security Deposit Master7JFEFTBDate - Beginning EffectiveDateGeneric Edit60
128F1570Legal Clauses8NDEFTBDate - Beginning EffectiveDateGeneric Edit60
129F15703Legal Clause Amounts8NIEFTBDate - Beginning EffectiveDateGeneric Edit60
130F159071Market/Potential/Renewal Rent Master8NYEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP15L: Adv Real Estate Forecasting
131F15L101AREF Unit Master28UMEFTBDate - Beginning EffectiveDateGeneric Edit60
132F15L109AREF Budget Results25BREFTBDate - Beginning EffectiveDateGeneric Edit60
133F15L401AREF Share Factor Denominator Audit46SFEFTBDate - Beginning EffectiveDateGeneric Edit60
134F15L402AREF Tenant Exclusion Rule Audit7SGEFTBDate - Beginning EffectiveDateGeneric Edit60
135F15L403AREF Gross Up Processing Audit27SHEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP17: Customer Service Management
136F1791Entitlement Dates7EMEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP17C: Call Management
137F1731Equipment Master Location History12LQEFTBDate - Beginning EffectiveDateGeneric Edit60
138F1755Case Master118ZAEFTBDate - Beginning EffectiveDateGeneric Edit60
139F1757Task Master15ZAEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP43: Procurement
140F74U0142ACM - Application / Certificate Status History6DHEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP48S: Service Billing
141F48096Billing Rate / Mark up Table3WQEFTBDate - Beginning EffectiveDateGeneric Edit60
142F48127Tax Derivation Information4WOEFTBDate - Beginning EffectiveDateGeneric Edit60
143F4860Component Table Master3AFEFTBDate - Beginning EffectiveDateGeneric Edit60
144F4861Component Table Detail2AFEFTBDate - Beginning EffectiveDateGeneric Edit60
145F4862Component Cross Reference3AFEFTBDate - Beginning EffectiveDateGeneric Edit60
146F48S95Billing AAI Information4WVEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP51X: In-Memory Project Management
147F51X30Project Advisor Results Header101PBEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP52G: Proj & Gov Contract Accounting
148F52G21Contract Specific Labor Category Cross Reference7LREFTBDate - Beginning EffectiveDateGeneric Edit60
TOP74H: Hungary
149F74H1010Effective EU Tax Identifiers - HUN - 002AEEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP74U: United Kingdom Localizations
150F74U0118Payment Voucher Status History - 046VHEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP75A: Australia
151F75A0500AU Bonus and Back Pay Tax Workfile7BPEFTBDate - Beginning EffectiveDateGeneric Edit60
152F75A0501AU Bonus and Back Pay Tax History7THEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP75Z: New Zealand
153F75Z0008New Zealand Special Rates3Z8EFTBDate - Beginning EffectiveDateGeneric Edit60
TOP76B: Brazil
154F76B040ePIS COFINS Job Header - BRA - 76B5PHEFTBDate - Beginning EffectiveDateGeneric Edit60
155F76B0510Electronic Reporting Process Header - BR -4PHEFTBDate - Beginning EffectiveDateGeneric Edit60
156F76B0740Ato Cotepe Process - BR - 005PHEFTBDate - Beginning EffectiveDateGeneric Edit60
157F76B839FCONT Jobs Periodicity - 76B3JPEFTBDate - Beginning EffectiveDateGeneric Edit60
158F76B940SPED Jobs -BR - 0913SJEFTBDate - Beginning EffectiveDateGeneric Edit60
159F76B944SPED Job Batches - BR - 094SBEFTBDate - Beginning EffectiveDateGeneric Edit60
TOPH90: EnterpriseOne TOOLS
160F1761Electronic Help JDE Request Log8ZAEFTBDate - Beginning EffectiveDateGeneric Edit60