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

60 COLUMNS | 5 INDEXES | Print definition?920 | 05A | F060119 TABLE

05A: PeopleSoft HR & PR Foundation
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F060119YE605Employee Jobs History FileMaster Files05A: PeopleSoft HR & PR FoundationBusiness 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, YESEQ#, 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 F060119

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

TOP920 | 05A | F060119 INDEXES

NumberDescription
1Address Number Home BU +A (Primary/Unique)
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2HMCUBusiness Unit - HomeAscending
3JBCDJob Type (Craft) CodeAscending
4JBSTJob StepAscending
5EFTODate - Effective OnAscending
6TRSChange ReasonAscending
7SEQ#Sequence Number for ViewAscending
2Address Number Prim Job +A
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2EJPFPrimary Job FlagDescending
3Address Number Home BU +B
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2HMCUBusiness Unit - HomeAscending
3JBCDJob Type (Craft) CodeAscending
4JBSTJob StepAscending
5PTDTDate - Pay StopsAscending
4Address Number Prim Job +B
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2EJPFPrimary Job FlagDescending
3HMCUBusiness Unit - HomeAscending
4JBCDJob Type (Craft) CodeAscending
5JBSTJob StepAscending
6EFTODate - Effective OnDescending
6Address Number DateEffective
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2EFTODate - Effective OnAscending
3SEQ#Sequence Number for ViewDescending