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

94 columns | Print definition?812 | HMCU

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