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

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

06: Payroll (old) - Obsolete-do not reuse
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F060118YE594Employee JobsMaster Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
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

TOP920 | 06 | F060118 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1YEAN8Address NumberNumericGeneric Edit80 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

TOP920 | 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