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
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

100 columns | Print definition?910 | HMCU

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0911Account Ledger92GLHMCUBusiness Unit - HomeStringGeneric Edit120
TOP05: Time Accounting and HRM Base
2F050116WEmployee Master Integrations Work File3EMHMCUBusiness Unit - HomeStringGeneric Edit120
3F051124Director Text Setup File2Y4HMCUBusiness Unit - HomeStringGeneric Edit120
4F051402Search Constants2SCHMCUBusiness Unit - HomeStringGeneric Edit120
5F054101Employee Personal Profile Information History Table9EHHMCUBusiness Unit - HomeStringGeneric Edit120
6F054101WEmployee Personal Profile Information Work Table9EPHMCUBusiness Unit - HomeStringGeneric Edit120
7F06106Employee Pay Instructions103YMHMCUBusiness Unit - HomeStringGeneric Edit120
8F0618Employee Transaction History9YTHMCUBusiness Unit - HomeStringGeneric Edit120
TOP05A: OW HR & PR Foundation
9F05844Approval Hierarchy Table2AHHMCUBusiness Unit - HomeStringGeneric Edit120
10F060116Employee Master Information23YAHMCUBusiness Unit - HomeStringGeneric Edit120
11F0601161Point-In-Time Employee Master25PTHMCUBusiness Unit - HomeStringGeneric Edit120
12F060116WEE Master Request File23YAHMCUBusiness Unit - HomeStringGeneric Edit120
13F060116ZUnedited Quick Hire Transaction File23SZHMCUBusiness Unit - HomeStringGeneric Edit120
14F060119Employee Jobs History File2YEHMCUBusiness Unit - HomeStringGeneric Edit120
15F06345Historical Payroll Register7JLHMCUBusiness Unit - HomeStringGeneric Edit120
TOP05T: Time Entry
16F051123Self Service Time Entry Layout Setup File2Y3HMCUBusiness Unit - HomeStringGeneric Edit120
17F06116Employee Transaction Detail File9YTHMCUBusiness Unit - HomeStringGeneric Edit120
18F06116Z1Employee Transactions - Batch File26VLHMCUBusiness Unit - HomeStringGeneric Edit120
19F06116Z2ESS Timecard History26VMHMCUBusiness Unit - HomeStringGeneric Edit120
20F06278Retro Timecard Detail File12YTHMCUBusiness Unit - HomeStringGeneric Edit120
21F063951Payroll Journal (Compressed) File29GLHMCUBusiness Unit - HomeStringGeneric Edit120
TOP06: Payroll (old) - Obsolete-do not reuse
22F060118Employee Jobs2YEHMCUBusiness Unit - HomeStringGeneric Edit120
TOP07: Payroll
23F05290WF - Payroll Journal (Detail)29JRHMCUBusiness Unit - HomeStringGeneric Edit120
24F06156Pay Check History Summary28YUHMCUBusiness Unit - HomeStringGeneric Edit120
25F06270Retro Processing Parameter37JPHMCUBusiness Unit - HomeStringGeneric Edit120
26F063106Deduction/Benefit Work File5Y7HMCUBusiness Unit - HomeStringGeneric Edit120
27F06350IWF - Paycheck (Interims)37Y4HMCUBusiness Unit - HomeStringGeneric Edit120
28F06490Payroll/Accounts Payable Ledger Detail8JRHMCUBusiness Unit - HomeStringGeneric Edit120
29F0716701Employee Assignment T/E Template Information27EAHMCUBusiness Unit - HomeStringGeneric Edit120
30F0716709Employee Assignment T/E Template Info History27EAHMCUBusiness Unit - HomeStringGeneric Edit120
31F0717ROE Summary History37JFHMCUBusiness Unit - HomeStringGeneric Edit120
32F07235Auto Deposit Bank Workfile5Y6HMCUBusiness Unit - HomeStringGeneric Edit120
33F07236Auto Deposit Tape File Setup2Y6HMCUBusiness Unit - HomeStringGeneric Edit120
34F07236TAuto Deposit Tape File Setup (Additional)2Y6HMCUBusiness Unit - HomeStringGeneric Edit120
35F07350Payment File12Y0HMCUBusiness Unit - HomeStringGeneric Edit120
36F07355Pre-Payroll Error File25Y5HMCUBusiness Unit - HomeStringGeneric Edit120
37F07490Payroll - Accounts Payable Detail (One World)8JRHMCUBusiness Unit - HomeStringGeneric Edit120
38F07727Canadian Pension Information4J7HMCUBusiness Unit - HomeStringGeneric Edit120
39F07822Company Federal Control Table11JIHMCUBusiness Unit - HomeStringGeneric Edit120
40F07830Employee Federal Control Table61Y0HMCUBusiness Unit - HomeStringGeneric Edit120
41F07831Employee State/Local Control Table37YBHMCUBusiness Unit - HomeStringGeneric Edit120
42F07832Employee Special Handling Control Table23YHHMCUBusiness Unit - HomeStringGeneric Edit120
43F07850Group Fund Setup4FGHMCUBusiness Unit - HomeStringGeneric Edit120
44F07UI200Timecard History Work File12THHMCUBusiness Unit - HomeStringGeneric Edit120
TOP08: Human Resources
45F082003Grade/Step Progression Detail File4YWHMCUBusiness Unit - HomeStringGeneric Edit120
46F083305Mail Merge Header/Detail21MMHMCUBusiness Unit - HomeStringGeneric Edit120
TOP08AD: ADP Integration
47F05137ADP Employee Master Information11ADHMCUBusiness Unit - HomeStringGeneric Edit120
48F051371ADP Employee DBA Instructions108ADHMCUBusiness Unit - HomeStringGeneric Edit120
49F051372ADP Employee Job Master Information5ADHMCUBusiness Unit - HomeStringGeneric Edit120
50F051373ADP Employee Auto Deposit Instructions5ADHMCUBusiness Unit - HomeStringGeneric Edit120
51F051374ADP Employee Tax Withholding/Override Instructions5ADHMCUBusiness Unit - HomeStringGeneric Edit120
TOP08B: Benefits Administration
52F0833WFBenefit Statement Work file18WFHMCUBusiness Unit - HomeStringGeneric Edit120
TOP08H: Health and Safety
53F08601Injury/Illness Case Master10HLHMCUBusiness Unit - HomeStringGeneric Edit120
TOP08P: Position Control
54F08005Business Unit/ Job Id. X-Ref1JVHMCUBusiness Unit - HomeStringGeneric Edit120
55F08101Position Master26HPHMCUBusiness Unit - HomeStringGeneric Edit120
56F081012Position Accounts2HCHMCUBusiness Unit - HomeStringGeneric Edit120
57F08101PPurge - Position Master26HPHMCUBusiness Unit - HomeStringGeneric Edit120
58F08111Position Budget Detail19HQHMCUBusiness Unit - HomeStringGeneric Edit120
59F08111PPurge - Position Budget Detail19HQHMCUBusiness Unit - HomeStringGeneric Edit120
TOP08R: Recruitment Management - (Appl. Track. & Req.)
60F08102Requisition Information37HNHMCUBusiness Unit - HomeStringGeneric Edit120
61F08401Applicant Master43HAHMCUBusiness Unit - HomeStringGeneric Edit120
62F08401WFApplicant Work File44XNHMCUBusiness Unit - HomeStringGeneric Edit120
TOP08U: OW HR US
63F08910COBRA Qualified Beneficiary File27J1HMCUBusiness Unit - HomeStringGeneric Edit120
64F08990COBRA General Constants2HWHMCUBusiness Unit - HomeStringGeneric Edit120
65F089901COBRA General Constants Additional Information2CCHMCUBusiness Unit - HomeStringGeneric Edit120
66F089902COBRA General Constants - COBRA Notices Information2J2HMCUBusiness Unit - HomeStringGeneric Edit120
67F08991COBRA Qualifying Event Constant5HDHMCUBusiness Unit - HomeStringGeneric Edit120
68F08992Qualifying Event Rules Header4QEHMCUBusiness Unit - HomeStringGeneric Edit120
TOP08W: Wage and Salary
69F08201Salary Review Workfile7HRHMCUBusiness Unit - HomeStringGeneric Edit120
70F08818Increase Type Rules3YMHMCUBusiness Unit - HomeStringGeneric Edit120
71F08830WFCompensation Root Work Table12YNHMCUBusiness Unit - HomeStringGeneric Edit120
TOP09: General Accounting
72F0911PPurge - Account Ledger92GLHMCUBusiness Unit - HomeStringGeneric Edit120
73F0911Z1Journal Entry Transactions - Batch File109VNHMCUBusiness Unit - HomeStringGeneric Edit120
74F0911Z4F0911 Interoperability Table114SZHMCUBusiness Unit - HomeStringGeneric Edit120
75F0917Bank Statement Detail42GDHMCUBusiness Unit - HomeStringGeneric Edit120
76F09UI015Indexed Computations Multi-Tiered Entries92GLHMCUBusiness Unit - HomeStringGeneric Edit120
TOP09E: Expense Reimbursment
77F20111Expense Report Header35EHHMCUBusiness Unit - HomeStringGeneric Edit120
TOP17C: Call Management
78F1755Case Master99ZAHMCUBusiness Unit - HomeStringGeneric Edit120
79F1760Time Entry17ZBHMCUBusiness Unit - HomeStringGeneric Edit120
80F1797S/WM Address Book Information20CSHMCUBusiness Unit - HomeStringGeneric Edit120
TOP18: Resource Scheduling
81F186602Labor Rules Tag File23TFHMCUBusiness Unit - HomeStringGeneric Edit120
TOP37: Quality Management
82F3711Test Results19TRHMCUBusiness Unit - HomeStringGeneric Edit120
83F3711Z1Test Results Unedited Transaction Table32SZHMCUBusiness Unit - HomeStringGeneric Edit120
84F37900Certificate of Analysis (COA) Extract19TRHMCUBusiness Unit - HomeStringGeneric Edit120
TOP42: Sales Management
85F42800GSales Update G Batch Workfile23SGHMCUBusiness Unit - HomeStringGeneric Edit120
TOP48S: Service Billing
86F48096Billing Rate / Mark up Table17WQHMCUBusiness Unit - HomeStringGeneric Edit120
87F4812Billing Detail Workfile44WDHMCUBusiness Unit - HomeStringGeneric Edit120
88F4812HBilling Workfile History44WDHMCUBusiness Unit - HomeStringGeneric Edit120
89F4812HSBilling Workfile History Purged Save44WDHMCUBusiness Unit - HomeStringGeneric Edit120
90F48S0618Payroll Reclassification Workfile9YTHMCUBusiness Unit - HomeStringGeneric Edit120
91F48S910Billing Detail Journal Workfile50W2HMCUBusiness Unit - HomeStringGeneric Edit120
92F48S911Summarized Journal Workfile41W3HMCUBusiness Unit - HomeStringGeneric Edit120
93F48SUI01Billing Detail Print Workfile44WDHMCUBusiness Unit - HomeStringGeneric Edit120
TOP52: Contract Billing
94F5212T and M - Unit Price and Lumpsum Cross Reference Accounts19G5HMCUBusiness Unit - HomeStringGeneric Edit120
95F5280WContract Revenue Summary Work File26GYHMCUBusiness Unit - HomeStringGeneric Edit120
TOP52G: Government Contracting
96F52G21Contract Specific Labor Category Cross Reference13LRHMCUBusiness Unit - HomeStringGeneric Edit120
TOP54HS: Health & Safety Incident Mgt
97F54HS02Incident People18S2HMCUBusiness Unit - HomeStringGeneric Edit120
98F54HS02MIncident People Change History21I2HMCUBusiness Unit - HomeStringGeneric Edit120
TOP75A: Australia - Reporting System Only
99F75A0301Superannuation Payment4SAHMCUBusiness Unit - HomeStringGeneric Edit120
TOP77: Payroll (Canadian)
100F77200Canadian Employee Year-End Form Header - F7720012J5HMCUBusiness Unit - HomeStringGeneric Edit120