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
10F4111ILItem Ledger File

812: Top 10 requests

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

103 columns | Print definition?920 | DL02

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006Business Unit Master12MCDL02Description 02StringGeneric Edit300
2F0006DBusiness Unit Alternate Description Master4LJDL02Description 02StringGeneric Edit300
3F0006DZ1Business Unit Alternate Description Z file18SZDL02Description 02StringGeneric Edit300
4F0006SDate Effective Business Unit Master14MCDL02Description 02StringGeneric Edit300
5F0006Z1Cost Center Unedited Transaction Table25SZDL02Description 02StringGeneric Edit300
6F0006Z2Business Unit Master Z File25SZDL02Description 02StringGeneric Edit300
7F0012Automatic Accounting Instructions Master7KGDL02Description 02StringGeneric Edit300
8F0012DAAI Alternate Description Master5LJDL02Description 02StringGeneric Edit300
9F00191Generic Message/Rates5CEDL02Description 02StringGeneric Edit300
TOP05: Time Accounting and HRM Base
10F05005Generic UBE File6GFDL02Description 02StringGeneric Edit300
11F054101Employee Personal Profile Information History Table49EHDL02Description 02StringGeneric Edit300
12F054101WEmployee Personal Profile Information Work Table50EPDL02Description 02StringGeneric Edit300
TOP05A: PeopleSoft HR & PR Foundation
13F060116WEE Master Request File226YADL02Description 02StringGeneric Edit300
14F08096HR Generic Table Headings4H$DL02Description 02StringGeneric Edit300
TOP06: Payroll (old) - Obsolete-do not reuse
15F06210Payroll Cycle Parameters56YDDL02Description 02StringGeneric Edit300
TOP07: Payroll
16F069026Payroll Generic Tables14Y2DL02Description 02StringGeneric Edit300
17F07186Stub Information History Table13Y8DL02Description 02StringGeneric Edit300
18F07352Stub Information File13Y2DL02Description 02StringGeneric Edit300
19F07355Pre-Payroll Error File7Y5DL02Description 02StringGeneric Edit300
20F074001New Hire Reporting Workfile - OneWorld Only83NHDL02Description 02StringGeneric Edit300
21F074001RNew Hire Report Setup - OneWorld Only7NHDL02Description 02StringGeneric Edit300
22F074001WSUI/New Hire Client loader for F074001R7NHDL02Description 02StringGeneric Edit300
23F078504Vertex Geo Code to ADP Code5VADL02Description 02StringGeneric Edit300
24F8907422New Hire Detail File - Massachusetts (22)18MADL02Description 02StringGeneric Edit300
25F8907427New Hire Detail File - Montana (27)14MTDL02Description 02StringGeneric Edit300
26F8907444New Hire Detail File Transfer - Texas (44)16TXDL02Description 02StringGeneric Edit300
TOP08: Human Resources
27F083305Mail Merge Header/Detail27MMDL02Description 02StringGeneric Edit300
28F08391User Program Parameters17B0DL02Description 02StringGeneric Edit300
29F085520Available Plans and Plan Options by Employee History Table9PHDL02Description 02StringGeneric Edit300
TOP08B: Benefits Administration
30F08320DPlan Master Tag Table14PDDL02Description 02StringGeneric Edit300
31F08380WFBatch Enrollment Work File13BEDL02Description 02StringGeneric Edit300
32F08593Retirement Rule Definition4H7DL02Description 02StringGeneric Edit300
TOP08P: Position Control
33F08101Position Master5HPDL02Description 02StringGeneric Edit300
34F08101PPurge - Position Master5HPDL02Description 02StringGeneric Edit300
TOP08R: Recruitment Management - (Appl. Track. & Req.)
35F08102Requisition Information26HNDL02Description 02StringGeneric Edit300
TOP08W: Wage and Salary
36F08830WFCompensation Root Work Table31YNDL02Description 02StringGeneric Edit300
TOP09: General Accounting
37F09UI009Trial Balance Generic Work File - OneWorld ONLY8GBDL02Description 02StringGeneric Edit300
TOP10: Financial Reporting
38F10471Elimination Rules (OW)19ERDL02Description 02StringGeneric Edit300
TOP12: Fixed Assets
39F1201Asset Master File14FADL02Description 02StringGeneric Edit300
40F1201DAsset Master - Alternate Description4LJDL02Description 02StringGeneric Edit300
41F1201PAsset Master Purge Table14FADL02Description 02StringGeneric Edit300
42F1201Z1Unedited Asset Master Transactions27FADL02Description 02StringGeneric Edit300
43F12911ERPost G/L to FA Exceptions Work File13GLDL02Description 02StringGeneric Edit300
TOP13: Plant/Equipment Management
44F3111IGSWO Parts for IGS Integration7IGDL02Description 02StringGeneric Edit300
TOP15: Real Estate Management
45F15012Tenant E.P. Class Master7NSDL02Description 02StringGeneric Edit300
46F15012BTenant E.P. Class Master7NSDL02Description 02StringGeneric Edit300
47F1507Unit Master6NHDL02Description 02StringGeneric Edit300
48F1507DUnit Master - Alternate Description5NHDL02Description 02StringGeneric Edit300
TOP16: Profit Management (EPS)
49F1610Cost Calculation Definitions4CDDL02Description 02StringGeneric Edit300
TOP17: Customer Service Management
50F1720Contract Header14CHDL02Description 02StringGeneric Edit300
TOP31P: Engineer To Order
51F31P10Project Quote Header8PQDL02Description 02StringGeneric Edit300
TOP34: Requirements Planning
52F34UI003MPS Time Series User Index1M8DL02Description 02StringGeneric Edit300
TOP34A: Advanced Planning & Scheduling
53F34A30Order Status Definition Table5N0DL02Description 02StringGeneric Edit300
TOP38: Agreement Management
54F38010Agreement Master4DNDL02Description 02StringGeneric Edit300
TOP40: Inventory/OP Base
55F4090Distribution/Manufacturing - AAI Record Type3MKDL02Description 02StringGeneric Edit300
TOP42I: Outbound Inventory Management
56F42I06Outbound Inventory Agreement Master Change History5OHDL02Description 02StringGeneric Edit300
TOP43: Procurement
57F43092Z1Receipt Routing Unedited Transaction Table53SZDL02Description 02StringGeneric Edit300
TOP44H: Homebuilder Management
58F4451Lot Proceed Detail (World)13JFDL02Description 02StringGeneric Edit300
59F4453Lot Master (World)13JBDL02Description 02StringGeneric Edit300
60F4461Option Master (World)18JNDL02Description 02StringGeneric Edit300
61F44H301Plan Master13PMDL02Description 02StringGeneric Edit300
62F44H401Option Master8OCDL02Description 02StringGeneric Edit300
63F44H4011Option by Community9OCDL02Description 02StringGeneric Edit300
64F44H401WOption Master Work File9OWDL02Description 02StringGeneric Edit300
TOP52: Contract Billing
65F5201Contract Master8G4DL02Description 02StringGeneric Edit300
TOP52G: Proj & Gov Contract Accounting
66F52G01MAdvanced Contracts Modifications13CMDL02Description 02StringGeneric Edit300
TOP53: Change Management
67F53005Job Specific UDC's Master Table5D1DL02Description 02StringGeneric Edit300
68F5302F5302 World Specs8DKDL02Description 02StringGeneric Edit300
TOP74: EMEA Localization
69F74092IVA Balances History - Italy6HBDL02Description 02StringGeneric Edit300
TOP75C: China
70F75C002Electronic Accounting Book18EADL02Description 02StringGeneric Edit300
71F75C007China - Chart of Accounts Set Up15CADL02Description 02StringGeneric Edit300
72F75C010WAP & AR XML Workfile - China -75C27AADL02Description 02StringGeneric Edit300
73F75CUI04China CNAO V2 Fixed Asset XML Work File - CHINA4WFDL02Description 02StringGeneric Edit300
74F75CUI3Financial Reporting Work FIle22CWDL02Description 02StringGeneric Edit300
TOP75I: India
75F75I2213Setoff Temp Table10TTDL02Description 02StringGeneric Edit300
76F75I396BER-69SEDL02Description 02StringGeneric Edit300
77F75I396TER-6 Temp9SEDL02Description 02StringGeneric Edit300
78F75I406State / Branch Plant Cross Reference5SBDL02Description 02StringGeneric Edit300
79F75I407Item Category Relationship7ICDL02Description 02StringGeneric Edit300
TOP76A: Argentina
80F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A51HFDL02Description 02StringGeneric Edit300
81F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A51HFDL02Description 02StringGeneric Edit300
82F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A28DLDL02Description 02StringGeneric Edit300
83F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A28DLDL02Description 02StringGeneric Edit300
84F76A22Credit Invoice Detail - F76A22 - ARG - 03B - 76A14IDDL02Description 02StringGeneric Edit300
85F76A22PCredit Invoice Detail Purge - ARG - 03B - 76A14IDDL02Description 02StringGeneric Edit300
86F76A82A/P Payment Control Group File - ARG - 04 - 76A33C6DL02Description 02StringGeneric Edit300
87F76AUI20Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A51HFDL02Description 02StringGeneric Edit300
88F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A28DLDL02Description 02StringGeneric Edit300
89F76AUI82Draft - Drafts Work File - ARG - 03B - 03B23WFDL02Description 02StringGeneric Edit300
TOP76B: Brazil
90F76B0401Tax Code - 044CTDL02Description 02StringGeneric Edit300
91F76B054Messages Information - SPED Fiscal Brazilian WF - BRA - 76B8WMDL02Description 02StringGeneric Edit300
92F76B0806Messages information - SPED Fiscal Brazilian Workfile6MIDL02Description 02StringGeneric Edit300
93F76B8200IN86-Work Table for Fixed Assets - 125FADL02Description 02StringGeneric Edit300
TOP89: Conversion Programs
94F75I101ATDS Ceritificate Master Tabel Extension19QBDL02Description 02StringGeneric Edit300
TOPH91: Design Tools
95F00085ADaylight Savings Rules25DSDL02Description 02StringGeneric Edit300
96F9801NEWEmployee Information - New Version11AADL02Description 02StringGeneric Edit300
97F9801OLDEmployee Information - Old Version10AADL02Description 02StringGeneric Edit300
98F98TMPLTemplates4TTDL02Description 02StringGeneric Edit300
TOPH92: Interactive Engine/OL
99F98231HOMW Transfer Activity Rule Director - Header5TRDL02Description 02StringGeneric Edit300
TOPH95: Object and Environment Tech
100F0005User Defined Code Values5DRDL02Description 02StringGeneric Edit300
101F0005DUser Defined Codes - Alternate Language Descriptions6DRDL02Description 02StringGeneric Edit300
TOPH96U: Upgrade
102F964725Special Instructions UDC Description6SIDL02Description 02StringGeneric Edit300
103F96710Impact Analysis Results16RADL02Description 02StringGeneric Edit300