JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

59 COLUMNS | 4 INDEXES | Print definition?812 | 06 | F060118 TABLE

06: Payroll (old) - Obsolete-do not reuse
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F060118YE594Employee JobsMaster Files06: Payroll (old) - Obsolete-do not reuseAS400 Coexistence Tables
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT YEAN8, YEHMCU, YEJBCD, YEJBST, YEPOS, YEEJPF, YEPSDT, YEPTDT, YEUN, YESAL, YEPHRT, YEATPY, YESLOC, YESHFT, YEWCMP, YEWET, YEPGRD, YEPGRS, YEFLSA, YEEEOJ, YEANPA, YEEST, YECMPA, YESALY, YENRVW, YETINC, YEP001, YEP002, YEP003, YEP004, YEP005, YEP006, YEP007, YEP008, YEP009, YEP010, YEED01, YEED02, YEED03, YEED04, YEED05, YEED06, YEED07, YEED08, YEED09, YEED10, YEFTE, YESMOY, YEIH, YESTDD, YESDYY, YESTDH, YEDTSF, YETRS, YEUSER, YEPID, YEJOBN, YEUPMJ, YEEFTO FROM F060118

TOP812 | 06 | F060118 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1YEAN8Address NumberNumericUDC80 Allow NULL? 
2YEHMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
3YEJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
4YEJBSTJob StepStringUDC (06 GS)40 Allow NULL? 
5YEPOSPosition IDStringGeneric Edit80 Allow NULL? 
6YEEJPFPrimary Job FlagCharacterGeneric Edit10 Allow NULL? 
7YEPSDTDate - Pay StartsDateGeneric Edit60
8YEPTDTDate - Pay StopsDateGeneric Edit60
9YEUNUnion CodeStringUDC (06 UN)60 Allow NULL? 
10YESALRate - Salary AnnualNumericGeneric Edit112 Allow NULL? 
11YEPHRTRate - HourlyNumericGeneric Edit93 Allow NULL? 
12YEATPYPayroll Autopay PaytypeNumericUDC (06 20)30 Allow NULL? 
13YESLOCSalary Data LocalityStringUDC (06 SL)80 Allow NULL? 
14YESHFTShift CodeCharacterUDC (06 SH)10 Allow NULL? 
15YEWCMPWorker's Comp. Insurance CodeStringUDC (00 W)40 Allow NULL? 
16YEWETSub Class - Workers CompCharacterUDC (07 WH)10 Allow NULL? 
17YEPGRDPay GradeStringGeneric Edit60 Allow NULL? 
18YEPGRSPay Grade StepStringGeneric Edit40 Allow NULL? 
19YEFLSAFLSA Exempt Y/NCharacterUDC (05 FL)10 Allow NULL? 
20YEEEOJJob Category (EEO)StringUDC (06 J)30 Allow NULL? 
21YEANPASupervisorNumericGeneric Edit80 Allow NULL? 
22YEESTEmployment StatusCharacterUDC (06 ES)10 Allow NULL? 
23YECMPACompa-RatioNumericGeneric Edit52 Allow NULL? 
24YESALYPay Class (H/S/P)CharacterUDC (05A PK)10 Allow NULL? 
25YENRVWDate - Next ReviewDateGeneric Edit60
26YETINCType of Increase Next ReviewCharacterUDC (06 RV)10 Allow NULL? 
27YEP001Category Codes - Payroll1StringUDC (06 01)30 Allow NULL? 
28YEP002Category Codes - Payroll2StringUDC (06 02)30 Allow NULL? 
29YEP003Category Codes - Payroll3StringUDC (06 03)30 Allow NULL? 
30YEP004Category Codes - Payroll4StringUDC (06 04)30 Allow NULL? 
31YEP005Category Codes - Payroll5StringUDC (06 05)30 Allow NULL? 
32YEP006Category Codes - Payroll6StringUDC (06 06)30 Allow NULL? 
33YEP007Category Codes - Payroll7StringUDC (06 07)30 Allow NULL? 
34YEP008Category Codes - Payroll8StringUDC (06 08)30 Allow NULL? 
35YEP009Category Codes - Payroll9StringUDC (06 09)30 Allow NULL? 
36YEP010Category Codes - Payroll10StringUDC (06 10)30 Allow NULL? 
37YEED01Date - User Defined1DateGeneric Edit60
38YEED02Date - User Defined2DateGeneric Edit60
39YEED03Date - User Defined3DateGeneric Edit60
40YEED04Date - User Defined4DateGeneric Edit60
41YEED05Date - User Defined5DateGeneric Edit60
42YEED06Date - User Defined6DateGeneric Edit60
43YEED07Date - User Defined7DateGeneric Edit60
44YEED08Date - User Defined8DateGeneric Edit60
45YEED09Date - User Defined9DateGeneric Edit60
46YEED10Date - User Defined10DateGeneric Edit60
47YEFTEFull Time EquivalentsNumericGeneric Edit92 Allow NULL? 
48YESMOYPeriods Paid Per YearNumericGeneric Edit52 Allow NULL? 
49YEIHHours per Standard YearNumericGeneric Edit72 Allow NULL? 
50YESTDDHours - Standard per DayNumericGeneric Edit52 Allow NULL? 
51YESDYYDays - Standard per YearNumericGeneric Edit52 Allow NULL? 
52YESTDHHours - Standard per PayperiodNumericGeneric Edit52 Allow NULL? 
53YEDTSFSalary Forecast Change DateDateGeneric Edit60
54YETRSChange ReasonStringUDC (06 T)30 Allow NULL? 
55YEUSERUser IDStringGeneric Edit100 Allow NULL? 
56YEPIDProgram IDStringGeneric Edit100 Allow NULL? 
57YEJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
58YEUPMJDate - UpdatedDateGeneric Edit60
59YEEFTODate - Effective OnDateGeneric Edit60

TOP812 | 06 | F060118 INDEXES

NumberDescription
1Address Number Home BU +A (Primary/Unique)
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2HMCUBusiness Unit - HomeAscending
3JBCDJob Type (Craft) CodeAscending
4JBSTJob StepAscending
5PTDTDate - Pay StopsAscending
2Address Number Primary Job Fl
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2EJPFPrimary Job FlagDescending
3Address Number Job Code +A
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2JBCDJob Type (Craft) CodeAscending
3JBSTJob StepAscending
4Address Number Home BU +B
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2HMCUBusiness Unit - HomeAscending
3POSPosition IDAscending