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
4F4211SDSales Order Detail File
5F4311PDPurchase 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

97 columns | Print definition?812 | DL02

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006Business Unit Master12MCDL02Description 02StringGeneric Edit300
2F0006DBusiness Unit Alternate Description Master4LJDL02Description 02StringGeneric Edit300
3F0006SDate Effective Business Unit Master14MCDL02Description 02StringGeneric Edit300
4F0006Z1Cost Center Unedited Transaction Table25SZDL02Description 02StringGeneric Edit300
5F0012Automatic Accounting Instructions Master7KGDL02Description 02StringGeneric Edit300
6F0012DAAI Alternate Description Master5LJDL02Description 02StringGeneric Edit300
7F00191Generic Message/Rates5CEDL02Description 02StringGeneric Edit300
TOP05: Time Accounting and HRM Base
8F05005Generic UBE File6GFDL02Description 02StringGeneric Edit300
9F054101Employee Personal Profile Information History Table49EHDL02Description 02StringGeneric Edit300
10F054101WEmployee Personal Profile Information Work Table50EPDL02Description 02StringGeneric Edit300
TOP05A: OW HR & PR Foundation
11F060116WEE Master Request File226YADL02Description 02StringGeneric Edit300
12F08096HR Generic Table Headings4H$DL02Description 02StringGeneric Edit300
TOP06: Payroll (old) - Obsolete-do not reuse
13F06210Payroll Cycle Parameters56YDDL02Description 02StringGeneric Edit300
TOP07: Payroll
14F069026Payroll Generic Tables14Y2DL02Description 02StringGeneric Edit300
15F07186Stub Information History Table13Y8DL02Description 02StringGeneric Edit300
16F07352Stub Information File13Y2DL02Description 02StringGeneric Edit300
17F07355Pre-Payroll Error File7Y5DL02Description 02StringGeneric Edit300
18F074001New Hire Reporting Workfile - OneWorld Only83NHDL02Description 02StringGeneric Edit300
19F074001RNew Hire Report Setup - OneWorld Only7NHDL02Description 02StringGeneric Edit300
20F078504Vertex Geo Code to ADP Code4VADL02Description 02StringGeneric Edit300
21F8907422New Hire Detail File - Massachusetts (22)18MADL02Description 02StringGeneric Edit300
22F8907427New Hire Detail File - Montana (27)14MTDL02Description 02StringGeneric Edit300
23F8907444New Hire Detail File Transfer - Texas (44)16TXDL02Description 02StringGeneric Edit300
TOP08: Human Resources
24F083305Mail Merge Header/Detail27MMDL02Description 02StringGeneric Edit300
25F08391User Program Parameters17B0DL02Description 02StringGeneric Edit300
26F085520Available Plans and Plan Options by Employee History Table9PHDL02Description 02StringGeneric Edit300
TOP08A: eRecruit
27F08471Job Posting Competencies9PCDL02Description 02StringGeneric Edit300
TOP08B: Benefits Administration
28F08320DPlan Master Tag Table14PDDL02Description 02StringGeneric Edit300
29F08380WFBatch Enrollment Work File13BEDL02Description 02StringGeneric Edit300
30F08593Retirement Rule Definition4H7DL02Description 02StringGeneric Edit300
TOP08P: Position Control
31F08101Position Master5HPDL02Description 02StringGeneric Edit300
32F08101PPurge - Position Master5HPDL02Description 02StringGeneric Edit300
TOP08R: Recruitment Management - (Appl. Track. & Req.)
33F08102Requisition Information26HNDL02Description 02StringGeneric Edit300
TOP08W: Wage and Salary
34F08830WFCompensation Root Work Table31YNDL02Description 02StringGeneric Edit300
TOP09: General Accounting
35F09UI009Trial Balance Generic Work File - OneWorld ONLY8GBDL02Description 02StringGeneric Edit300
TOP10: Financial Reporting
36F10471Elimination Rules (OW)19ERDL02Description 02StringGeneric Edit300
TOP12: Fixed Assets
37F1201Asset Master File14FADL02Description 02StringGeneric Edit300
38F1201DAsset Master - Alternate Description4LJDL02Description 02StringGeneric Edit300
39F1201PAsset Master Purge Table14FADL02Description 02StringGeneric Edit300
40F1201Z1Unedited Asset Master Transactions27FADL02Description 02StringGeneric Edit300
41F12911ERPost G/L to FA Exceptions Work File13GLDL02Description 02StringGeneric Edit300
TOP13: Plant/Equipment Management
42F3111IGSWO Parts for IGS Integration7IGDL02Description 02StringGeneric Edit300
TOP15: Property Management
43F15012Tenant E.P. Class Master7NSDL02Description 02StringGeneric Edit300
44F15012BTenant E.P. Class Master7NSDL02Description 02StringGeneric Edit300
45F1507Unit Master File6NHDL02Description 02StringGeneric Edit300
46F1507DUnit Master - Alternate Description5NHDL02Description 02StringGeneric Edit300
TOP16: Profit Management (EPS)
47F1610Cost Calculation Definitions4CDDL02Description 02StringGeneric Edit300
TOP17: Customer Service Management
48F1720Contract Header14CHDL02Description 02StringGeneric Edit300
TOP31P: Engineer To Order
49F31P10Project Quote Header8PQDL02Description 02StringGeneric Edit300
TOP34: Requirements Planning
50F34UI003MPS Time Series User Index1M8DL02Description 02StringGeneric Edit300
TOP34A: Advanced Planning & Scheduling
51F34A30Order Status Definition Table5N0DL02Description 02StringGeneric Edit300
TOP38: Agreement Management
52F38010Agreement Master4DNDL02Description 02StringGeneric Edit300
TOP40: Inventory/OP Base
53F4090Distribution/Manufacturing - AAI Record Type3MKDL02Description 02StringGeneric Edit300
TOP43: Procurement
54F43092Z1Receipt Routing Unedited Transaction Table53SZDL02Description 02StringGeneric Edit300
TOP44H: Homebuilder Management
55F4451Lot Proceed Detail (World)13JFDL02Description 02StringGeneric Edit300
56F4453Lot Master (World)13JBDL02Description 02StringGeneric Edit300
57F4461Option Master (World)18JNDL02Description 02StringGeneric Edit300
58F44H301Plan Master13PMDL02Description 02StringGeneric Edit300
59F44H401Option Master8OCDL02Description 02StringGeneric Edit300
60F44H4011Option by Community9OCDL02Description 02StringGeneric Edit300
61F44H401WOption Master Work File9OWDL02Description 02StringGeneric Edit300
TOP52: Contract Billing
62F5201Contract Master File8G4DL02Description 02StringGeneric Edit300
TOP53: Change Management
63F53005Job Specific UDC's Master Table5D1DL02Description 02StringGeneric Edit300
64F5302F5302 World Specs8DKDL02Description 02StringGeneric Edit300
TOP55: Reserved for Clients
65F5574T14New Credit Analysis Report -BO17CADL02Description 02StringGeneric Edit300
66F55IF311As Of26RPDL02Description 02StringGeneric Edit300
67F55IF421Sales Order per BO215SDDL02Description 02StringGeneric Edit300
68F55IF425Sales Order per BO - 2005215SDDL02Description 02StringGeneric Edit300
69F55IFALBEsportazione provvigioni da F421121PRDL02Description 02StringGeneric Edit300
70F55PROVVEsportazione provvigioni da F421121PRDL02Description 02StringGeneric Edit300
71F74H1050Invoicing Workfile Header - New17IHDL02Description 02StringGeneric Edit300
72F74H1056Invoicing Additional References4ARDL02Description 02StringGeneric Edit300
73F59BN01Garanti Bankasi Cek/Senet Entegrasyon Tablosu16BNDL02Description 02StringGeneric Edit300
74F59W0007JDE Transaction Result Table14TRDL02Description 02StringGeneric Edit300
TOP74: EMEA Localization
75F74092IVA Balances History - Italy6HBDL02Description 02StringGeneric Edit300
TOP76A: Argentina
76F76A0209Header and Footer Invoice/ShipmentNote History WF - ARG - 76A51HFDL02Description 02StringGeneric Edit300
77F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A51HFDL02Description 02StringGeneric Edit300
78F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A28DLDL02Description 02StringGeneric Edit300
79F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A28DLDL02Description 02StringGeneric Edit300
80F76A22Credit Invoice Detail - F76A22 - ARG - 03B - 76A14IDDL02Description 02StringGeneric Edit300
81F76A22PCredit Invoice Detail Purge - ARG - 03B - 76A14IDDL02Description 02StringGeneric Edit300
82F76A82A/P Payment Control Group File - ARG - 04 - 76A33C6DL02Description 02StringGeneric Edit300
83F76AUI20Header and Footer Invoice/ShipmentNote Workfile - ARG - - 0051HFDL02Description 02StringGeneric Edit300
84F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 0028DLDL02Description 02StringGeneric Edit300
85F76AUI82Draft - Drafts Work File - ARG - 03B - 03B23WFDL02Description 02StringGeneric Edit300
TOP76B: Brazil - Reporting System Only
86F76B0401Tax Code - 044CTDL02Description 02StringGeneric Edit300
87F76B8200IN86-Work Table for Fixed Assets - 125FADL02Description 02StringGeneric Edit300
TOP89: Conversion Programs
88F074001WSUI/New Hire Client loader for F074001R7NHDL02Description 02StringGeneric Edit300
TOPH91: Design Tools
89F00085ADaylight Savings Rules25DSDL02Description 02StringGeneric Edit300
90F9801NEWEmployee Information - New Version11AADL02Description 02StringGeneric Edit300
91F9801OLDEmployee Information - Old Version10AADL02Description 02StringGeneric Edit300
92F98TMPLTemplates4TTDL02Description 02StringGeneric Edit300
TOPH92: Interactive Engine/OL
93F98231HOMW Transfer Activity Rule Director - Header5TRDL02Description 02StringGeneric Edit300
TOPH95: Tech Resources/Applications
94F0005User Defined Codes5DRDL02Description 02StringGeneric Edit300
95F0005DUser Defined Codes - Alternate Language Descriptions6DRDL02Description 02StringGeneric Edit300
TOPH96U: Upgrade
96F964725Special Instructions UDC Description6SIDL02Description 02StringGeneric Edit300
97F96710Impact Analysis Results16RADL02Description 02StringGeneric Edit300