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
4F0411RPAccounts Payable Ledger
5F4311PDPurchase Order Detail File
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

50 columns | Print definition?920 | ANPA

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006Business Unit Master92MCANPASupervisorNumericGeneric Edit80
2F0006SDate Effective Business Unit Master94MCANPASupervisorNumericGeneric Edit80
3F0006Z1Cost Center Unedited Transaction Table105SZANPASupervisorNumericGeneric Edit80
4F0006Z2Business Unit Master Z File105SZANPASupervisorNumericGeneric Edit80
TOP05: Time Accounting and HRM Base
5F05102Goal Master8SMANPASupervisorNumericGeneric Edit80
TOP05A: PeopleSoft HR & PR Foundation
6F05840Employee/Supervisor Relationship Level4SRANPASupervisorNumericGeneric Edit80
7F05842Employee/Supervisor Approval History2ATANPASupervisorNumericGeneric Edit80
8F060116Employee Master Information150YAANPASupervisorNumericGeneric Edit80
9F0601161Point-In-Time Employee Master152PTANPASupervisorNumericGeneric Edit80
10F060116WEE Master Request File150YAANPASupervisorNumericGeneric Edit80
11F060116ZUnedited Quick Hire Transaction File24SZANPASupervisorNumericGeneric Edit80
12F060119Employee Jobs History File22YEANPASupervisorNumericGeneric Edit80
TOP05T: Time Entry
13F051126Managers Delegates Setup File1Y6ANPASupervisorNumericGeneric Edit80
14F06116Z1Employee Transactions - Batch File188VLANPASupervisorNumericGeneric Edit80
15F06116Z2ESS Timecard History188VMANPASupervisorNumericGeneric Edit80
TOP06: Payroll (old) - Obsolete-do not reuse
16F060118Employee Jobs21YEANPASupervisorNumericGeneric Edit80
TOP08: Human Resources
17F08710Employee Setup Master23ESANPASupervisorNumericGeneric Edit80
18F08720Employee Status Change3SCANPASupervisorNumericGeneric Edit80
19F08740Manager's Self Service Reports1MRANPASupervisorNumericGeneric Edit80
20F08750Managers Delegates1MDANPASupervisorNumericGeneric Edit80
21F087711CBPA Appraisal Header2XJANPASupervisorNumericGeneric Edit80
22F087711ACBPA Appraisal Header Tag Table2XJANPASupervisorNumericGeneric Edit80
23F087721CBPA Appraisal Creation Work File2XPANPASupervisorNumericGeneric Edit80
TOP08AD: ADP Integration
24F05137ADP Employee Master Information27ADANPASupervisorNumericGeneric Edit80
TOP08H: Health and Safety
25F08601Injury/Illness Case Master11HLANPASupervisorNumericGeneric Edit80
TOP08W: Wage and Salary
26F08201Salary Review Workfile8HRANPASupervisorNumericGeneric Edit80
27F08830WFCompensation Root Work Table8YNANPASupervisorNumericGeneric Edit80
TOP13: Plant/Equipment Management
28F13411PM Projections29RXANPASupervisorNumericGeneric Edit80
TOP13R: Resource Assignments
29F48310Resource Master10RMANPASupervisorNumericGeneric Edit80
30F48311Resource Assignments63RAANPASupervisorNumericGeneric Edit80
31F48311SPurge - Resource Assignments63RAANPASupervisorNumericGeneric Edit80
32F48315Maintenance Schedule Metrics5WSANPASupervisorNumericGeneric Edit80
33F48316Maintenance Rescheduling Metrics9RSANPASupervisorNumericGeneric Edit80
TOP17: Customer Service Management
34F4801Z2Warranty Claim/Supplier Recovery processing44WSANPASupervisorNumericGeneric Edit80
TOP17C: Call Management
35F1797S/WM Address Book Information8CSANPASupervisorNumericGeneric Edit80
TOP30: Product Data Management
36F3003Z1Routing Transactions File87SZANPASupervisorNumericGeneric Edit80
TOP31: Shop Floor Control
37F3112Work Order Routing107WLANPASupervisorNumericGeneric Edit80
38F3112SPurge Shop Floor Control Routing Instructions107WLANPASupervisorNumericGeneric Edit80
39F3112Z1Outbound Work Order Routings121SZANPASupervisorNumericGeneric Edit80
TOP40: Inventory/OP Base
40F3003Routing Master File73IRANPASupervisorNumericGeneric Edit80
TOP41F: Apparel Management
41FCW65Work Order Header for Style Items26OFANPASupervisorNumericGeneric Edit80
TOP48: Work Order Processing
42F48001Work Order Default Coding File5WEANPASupervisorNumericGeneric Edit80
43F4801Work Order Master File25WAANPASupervisorNumericGeneric Edit80
44F4801SPurge - Work Order Master file25WAANPASupervisorNumericGeneric Edit80
45F4801Z1Outbound Work Order Header44SYANPASupervisorNumericGeneric Edit80
46F48710Work Order Mass Update Template Table33WTANPASupervisorNumericGeneric Edit80
47F48UI001X4801 Master Business Function Workfile28WAANPASupervisorNumericGeneric Edit80
TOP51X: In-Memory Project Management
48F51X10Project Advisor Console Worktable70EXANPASupervisorNumericGeneric Edit80
TOP54HS: Health & Safety Incident Mgt
49F54HS02Incident People29S2ANPASupervisorNumericGeneric Edit80
50F54HS02MIncident People Change History32I2ANPASupervisorNumericGeneric Edit80