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
9F0006MCBusiness Unit Master
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
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
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

137 columns | Print definition?812 | EFTB

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F1501Tenant/Lease Master33NEEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP01: Address Book
2F0101Address Book Master22ABEFTBDate - Beginning EffectiveDateGeneric Edit60
3F0101Z2Address Book - Interoperability35SZEFTBDate - Beginning EffectiveDateGeneric Edit60
4F0116Address by Date2ALEFTBDate - Beginning EffectiveDateGeneric Edit60
5F01161Alternate Address3WLEFTBDate - 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
15F069216Workers Compensation Insurance Rates3YBEFTBDate - Beginning EffectiveDateGeneric Edit60
16F069226Unemployment Insurance Rates12YHEFTBDate - Beginning EffectiveDateGeneric Edit60
17F06923Valid Job Type/ Step Constant19YHEFTBDate - Beginning EffectiveDateGeneric Edit60
18F06925Employee/Vendor Cross Reference8YGEFTBDate - Beginning EffectiveDateGeneric Edit60
19F06931Wage Attachment File5J3EFTBDate - Beginning EffectiveDateGeneric Edit60
20F069311Wage Attachment Additional Exemptions4J3EFTBDate - Beginning EffectiveDateGeneric Edit60
21F069312Wage Attachment Exemptions File2J3EFTBDate - Beginning EffectiveDateGeneric Edit60
22F06933Step Progression Parameters3J@EFTBDate - Beginning EffectiveDateGeneric Edit60
23F06936Retro Pay Types Rate8JAEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP05A: OW HR & PR Foundation
24F069056Establishment Constant File8YOEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP05T: Time Entry
25F06918PF - Piece Rate File6JNEFTBDate - Beginning EffectiveDateGeneric Edit60
26F069246Shift Differential Table4Y3EFTBDate - Beginning EffectiveDateGeneric Edit60
TOP06: Payroll (old) - Obsolete-do not reuse
27F060146Employees Pay Rate File8JIEFTBDate - Beginning EffectiveDateGeneric Edit60
28F06210Payroll Cycle Parameters9YDEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP07: Payroll
29F06053Interim Check Parameters File22YWEFTBDate - Beginning EffectiveDateGeneric Edit60
30F0701732Additional Tax Overrides5AOEFTBDate - Beginning EffectiveDateGeneric Edit60
31F07210Pay Cycle Parameters File33YDEFTBDate - Beginning EffectiveDateGeneric Edit60
32F0729Employee DBA Override Instructions34Y9EFTBDate - Beginning EffectiveDateGeneric Edit60
TOP08: Human Resources
33F0800601Organizational Business Unit/Job Cross-Reference4JCEFTBDate - Beginning EffectiveDateGeneric Edit60
34F0800603Job Group Competencies3JCEFTBDate - Beginning EffectiveDateGeneric Edit60
35F0800604Organizational Business Unit Competencies3JCEFTBDate - Beginning EffectiveDateGeneric Edit60
36F0800605Job Type/Step Competencies4JCEFTBDate - Beginning EffectiveDateGeneric Edit60
37F0800606Competency Options - Overrides3JCEFTBDate - Beginning EffectiveDateGeneric Edit60
38F0800607Organizational Competencies3JCEFTBDate - Beginning EffectiveDateGeneric Edit60
39F0800608Date Effective Organizational Structure2JCEFTBDate - Beginning EffectiveDateGeneric Edit60
40F0800610Competencies in Structure and Job5JCEFTBDate - Beginning EffectiveDateGeneric Edit60
41F0800611Job Competency Default - Overrides3JCEFTBDate - Beginning EffectiveDateGeneric Edit60
42F0800612User Defined Job Competency Description Reference4JCEFTBDate - Beginning EffectiveDateGeneric Edit60
43F08006WFJob Competency Default Overrides Work File9JCEFTBDate - Beginning EffectiveDateGeneric Edit60
44F08JDWF1Job Description Changes Integration Work File2JCEFTBDate - Beginning EffectiveDateGeneric Edit60
45F08JDWF2Job Description History Integration Work File14JHEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP08AD: ADP Integration
46F051375ADP Payroll DBA Transaction Constants68ADEFTBDate - Beginning EffectiveDateGeneric Edit60
47F05138ADP - Pay Cycle Review Control4PCEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP08B: Benefits Administration
48F06024Beneficiary/Co-owner File11YJEFTBDate - Beginning EffectiveDateGeneric Edit60
49F083203Plan Master Rates5BGEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP08P: Position Control
50F08001Job information68JMEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP08R: Recruitment Management - (Appl. Track. & Req.)
51F06018Date Parameter Extension5YFEFTBDate - Beginning EffectiveDateGeneric Edit60
52F08102Requisition Information21HNEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP08U: OW HR US
53F08360Nondiscrimination Groups22HEEFTBDate - Beginning EffectiveDateGeneric Edit60
54F08920COBRA Coverage29JSEFTBDate - Beginning EffectiveDateGeneric Edit60
55F08990COBRA General Constants3HWEFTBDate - Beginning EffectiveDateGeneric Edit60
56F089901COBRA General Constants Additional Information3CCEFTBDate - Beginning EffectiveDateGeneric Edit60
57F089902COBRA General Constants - COBRA Notices Information4J2EFTBDate - Beginning EffectiveDateGeneric Edit60
58F08991COBRA Qualifying Event Constant7HDEFTBDate - Beginning EffectiveDateGeneric Edit60
59F08992Qualifying Event Rules Header6QEEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP08W: Wage and Salary
60F08290Pay/Salary Formula File3HGEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP09E: Expense Reimbursment
61F09E110Audit Selection Rules7ASEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP12: Fixed Assets
62F12002Default Accounting Constants24FDEFTBDate - Beginning EffectiveDateGeneric Edit60
63F12003Default Depreciation Constants21FFEFTBDate - Beginning EffectiveDateGeneric Edit60
64F1201Asset Master File64FAEFTBDate - Beginning EffectiveDateGeneric Edit60
65F1201PAsset Master Purge Table64FAEFTBDate - Beginning EffectiveDateGeneric Edit60
66F1201Z1Unedited Asset Master Transactions75FAEFTBDate - Beginning EffectiveDateGeneric Edit60
67F1204Location Tracking Table16FMEFTBDate - Beginning EffectiveDateGeneric Edit60
68F1204PLocation Tracking Purge Table16FMEFTBDate - Beginning EffectiveDateGeneric Edit60
69F1212Parent History3FYEFTBDate - Beginning EffectiveDateGeneric Edit60
70F1212PParent History Purge Table3FYEFTBDate - Beginning EffectiveDateGeneric Edit60
71F12841Revaluation Index1RIEFTBDate - Beginning EffectiveDateGeneric Edit60
72F12851Depreciation Rules8LUEFTBDate - Beginning EffectiveDateGeneric Edit60
73F12851DDemo Depreciation Rules8LUEFTBDate - Beginning EffectiveDateGeneric Edit60
74F12852Annual Depreciation Rules6LVEFTBDate - Beginning EffectiveDateGeneric Edit60
75F12852DDemo Annual Depreciation Rules6LVEFTBDate - Beginning EffectiveDateGeneric Edit60
76F1301Equipment Rates4FGEFTBDate - Beginning EffectiveDateGeneric Edit60
77F1301PEquipment Rates Purge Table4FGEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP13: Plant/Equipment Management
78F1307Status History File3F1EFTBDate - Beginning EffectiveDateGeneric Edit60
79F1307PStatus History Purge Table3F1EFTBDate - Beginning EffectiveDateGeneric Edit60
TOP15: Property Management
80F15012Tenant E.P. Class Master20NSEFTBDate - Beginning EffectiveDateGeneric Edit60
81F15012BTenant E.P. Class Master21NSEFTBDate - Beginning EffectiveDateGeneric Edit60
82F15013BSales Overage Master File7NOEFTBDate - Beginning EffectiveDateGeneric Edit60
83F15014Product Scales Master6NPEFTBDate - Beginning EffectiveDateGeneric Edit60
84F15014BProduct Scales Master8NPEFTBDate - Beginning EffectiveDateGeneric Edit60
85F15015Minimum rent/recoveries Master4NQEFTBDate - Beginning EffectiveDateGeneric Edit60
86F15015BMin/Max Rents And Recoveries Master6NQEFTBDate - Beginning EffectiveDateGeneric Edit60
87F15016Tenant Escalation Master36NUEFTBDate - Beginning EffectiveDateGeneric Edit60
88F15016BTenant Escalation Master37NUEFTBDate - Beginning EffectiveDateGeneric Edit60
89F1501BLease Master Header File25NEEFTBDate - Beginning EffectiveDateGeneric Edit60
90F1502Recurring Billings Master9NFEFTBDate - Beginning EffectiveDateGeneric Edit60
91F1502BRecurring Billings Master9NFEFTBDate - Beginning EffectiveDateGeneric Edit60
92F1502WABRent Increase Amounts7NFEFTBDate - Beginning EffectiveDateGeneric Edit60
93F1502WBEstimated EP Recurring Billing Work File (OneWorld)11N4EFTBDate - Beginning EffectiveDateGeneric Edit60
94F1503Log Standards Master12NBEFTBDate - Beginning EffectiveDateGeneric Edit60
95F1505Management Fee Master6NDEFTBDate - Beginning EffectiveDateGeneric Edit60
96F1505BManagement Fee Master8NDEFTBDate - Beginning EffectiveDateGeneric Edit60
97F15110BExpense Participation Class Account4OBEFTBDate - Beginning EffectiveDateGeneric Edit60
98F1513FASB 13 Lease Control File11O3EFTBDate - Beginning EffectiveDateGeneric Edit60
99F1513BFASB 13 Lease Control File11O3EFTBDate - Beginning EffectiveDateGeneric Edit60
100F1514Area Master12NWEFTBDate - Beginning EffectiveDateGeneric Edit60
101F1514WArea Work File1NWEFTBDate - Beginning EffectiveDateGeneric Edit60
102F1521Log Detail Master11NBEFTBDate - Beginning EffectiveDateGeneric Edit60
103F1525A/R Fee Interest24N0EFTBDate - Beginning EffectiveDateGeneric Edit60
104F1525BA/R Fee and Interest25NMEFTBDate - Beginning EffectiveDateGeneric Edit60
105F1530Expense Participation Class Master10NGEFTBDate - Beginning EffectiveDateGeneric Edit60
106F1531Expense Participation Class Adjustment4OMEFTBDate - Beginning EffectiveDateGeneric Edit60
107F1533Tenant Class Account Exclusions6NMEFTBDate - Beginning EffectiveDateGeneric Edit60
108F1533BTenant Account Exclusions7NMEFTBDate - Beginning EffectiveDateGeneric Edit60
109F1548Escalation Billing Register47N1EFTBDate - Beginning EffectiveDateGeneric Edit60
110F1548BEscalation Billing Register48N1EFTBDate - Beginning EffectiveDateGeneric Edit60
111F1565Security Deposit Master7JFEFTBDate - Beginning EffectiveDateGeneric Edit60
112F1570Legal Clauses8NDEFTBDate - Beginning EffectiveDateGeneric Edit60
113F15703Legal Clause Amounts8NIEFTBDate - Beginning EffectiveDateGeneric Edit60
114F159071Market/Potential/Renewal Rent Master8NYEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP15L: Adv Real Estate Forecasting
115F15L101AREF Unit Master28UMEFTBDate - Beginning EffectiveDateGeneric Edit60
116F15L109AREF Budget Results25BREFTBDate - Beginning EffectiveDateGeneric Edit60
TOP17: Customer Service Management
117F1791Entitlement Dates7EMEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP17C: Call Management
118F1731Installed Base Location History12LQEFTBDate - Beginning EffectiveDateGeneric Edit60
119F1755Customer Call Master118ZAEFTBDate - Beginning EffectiveDateGeneric Edit60
120F1757Task Master15ZAEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP48S: Service Billing
121F48096Billing Rate / Mark up Table3WQEFTBDate - Beginning EffectiveDateGeneric Edit60
122F48127Tax Derivation Information4WOEFTBDate - Beginning EffectiveDateGeneric Edit60
123F4860Component Table Master3AFEFTBDate - Beginning EffectiveDateGeneric Edit60
124F4861Component Table Detail2AFEFTBDate - Beginning EffectiveDateGeneric Edit60
125F4862Component Cross Reference3AFEFTBDate - Beginning EffectiveDateGeneric Edit60
126F48S80Segment Definition2SDEFTBDate - Beginning EffectiveDateGeneric Edit60
127F48S81Burden Computation Method2CMEFTBDate - Beginning EffectiveDateGeneric Edit60
128F48S82Burden Base Rules3BREFTBDate - Beginning EffectiveDateGeneric Edit60
129F48S83Pool Definition2PDEFTBDate - Beginning EffectiveDateGeneric Edit60
130F48S84Pool Grouping Codes2PGEFTBDate - Beginning EffectiveDateGeneric Edit60
131F48S85Burden Rates2RTEFTBDate - Beginning EffectiveDateGeneric Edit60
132F48S95Billing AAI Information4WVEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP55: Reserved for Clients
133F74U0142ACM - Application / Certificate Status History6DHEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP74H: Hungary
134F74H1010Effective EU Tax Identifiers2AEEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP74U: United Kingdom Localizations
135F74U0118Payment Voucher Status History6VHEFTBDate - Beginning EffectiveDateGeneric Edit60
TOP75Z: New Zealand - Reporting System Only
136F75Z0008New Zealand Special Rates3Z8EFTBDate - Beginning EffectiveDateGeneric Edit60
TOPH90: ONEWORLD TOOLS
137F1761Electronic Help JDE Request Log8ZAEFTBDate - Beginning EffectiveDateGeneric Edit60