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

92 COLUMNS | 4 INDEXES | Print definition?920 | 08W | F08830WF TABLE

08W: Wage and Salary
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F08830WFYN924Compensation Root Work TableWork Files08W: Wage and SalaryBusiness 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 YNMNAME, YNMTYPC, YNMDL01, YNMOWNR, YNRWTYP, YNAN8, YNALPH, YNANPA, YNSPRVN, YNDST, YNCO, YNHMCU, YNEST, YNPAST, YNUN, YNSALY, YNCOIHR, YNFTE, YNIH, YNPHRT, YNCASAL, YNCMPA, YNJBCX, YNCPDT, YNSAL, YNSLOC, YNPOS, YNDL01, YNCDIJ, YNJBCD, YNDL02, YNJBST, YNPGRD, YNPGRS, YNTIJM, YNTIPM, YNLISM, YNDR, YNLSRD, YNNSRD, YNCOCHG, YNBUCHG, YNPSCHG, YNUNCHG, YNLOCHG, YNPCCHG, YNCSCHG, YNCCCHG, YNCPCHG, YNPDCHG, YNJDCHG, YNSPCHG, YNCJTCHG, YNCJSCHG, YNCPGCHG, YNCPSCHG, YNLRDCHG, YNNSEFTO, YNNAS, YNNSOR, YNNCR, YNNPOS, YNNEJT, YNNHRR, YNNSALY, YNNPDL01, YNNJT, YNNJTDL, YNNJS, YNNPGR, YNNPST, YNPFRQ, YNFLSA, YNNUN, YNDIVC, YNJTTRS, YNPAPL, YNDATRVW, YNTIRNK, YNTRNKD, YNJBPCTRQD, YNLTJCRW, YNTBAM, YNTIAM, YNAPPST, YNANAB, YNLARD, YNUSER, YNPID, YNUPMJ, YNUPMT, YNJOBN FROM F08830WF

TOP920 | 08W | F08830WF COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1YNMNAMEModel NameStringGeneric Edit100 Allow NULL? 
2YNMTYPCCompensation Model Type CodeCharacterGeneric Edit10 Allow NULL? 
3YNMDL01Model DescriptionStringGeneric Edit300 Allow NULL? 
4YNMOWNRModel OwnerNumericGeneric Edit80 Allow NULL? 
5YNRWTYPReview TypeCharacterUDC (05 RY)10 Allow NULL? 
6YNAN8Address NumberNumericGeneric Edit80 Allow NULL? 
7YNALPHName - AlphaStringGeneric Edit400 Allow NULL? 
8YNANPASupervisorNumericGeneric Edit80 Allow NULL? 
9YNSPRVNSupervisor NameStringGeneric Edit300 Allow NULL? 
10YNDSTDate StartedDateGeneric Edit60
11YNCOCompanyStringGeneric Edit50 Allow NULL? 
12YNHMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
13YNESTEmployment StatusCharacterUDC (06 ES)10 Allow NULL? 
14YNPASTEmployee Pay StatusCharacterUDC (06 PS)10 Allow NULL? 
15YNUNUnion CodeStringUDC (06 UN)60 Allow NULL? 
16YNSALYPay Class (H/S/P)CharacterUDC (05A PK)10 Allow NULL? 
17YNCOIHRCompany Std Hours/YearNumericGeneric Edit92 Allow NULL? 
18YNFTEFull Time EquivalentsNumericGeneric Edit92 Allow NULL? 
19YNIHHours per Standard YearNumericGeneric Edit72 Allow NULL? 
20YNPHRTRate - HourlyNumericGeneric Edit93 Allow NULL? 
21YNCASALCurrent Annualized SalaryNumericGeneric Edit112 Allow NULL? 
22YNCMPACompa-RatioNumericGeneric Edit52 Allow NULL? 
23YNJBCXJob TitleStringGeneric Edit300 Allow NULL? 
24YNCPDTDate - Current PositionDateGeneric Edit60
25YNSALRate - Salary AnnualNumericGeneric Edit112 Allow NULL? 
26YNSLOCSalary Data LocalityStringUDC (06 SL)80 Allow NULL? 
27YNPOSPosition IDStringGeneric Edit80 Allow NULL? 
28YNDL01DescriptionStringGeneric Edit300 Allow NULL? 
29YNCDIJDate in Current JobDateGeneric Edit60
30YNJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
31YNDL02Description 02StringGeneric Edit300 Allow NULL? 
32YNJBSTJob StepStringUDC (06 GS)40 Allow NULL? 
33YNPGRDPay GradeStringGeneric Edit60 Allow NULL? 
34YNPGRSPay Grade StepStringGeneric Edit40 Allow NULL? 
35YNTIJMTime in Job (month)NumericGeneric Edit30 Allow NULL? 
36YNTIPMTime in Position(month)NumericGeneric Edit30 Allow NULL? 
37YNLISMLength in service(month)NumericGeneric Edit30 Allow NULL? 
38YNDRDate - Last RaiseDateGeneric Edit60
39YNLSRDLast Compensation Review DateDateGeneric Edit60
40YNNSRDNext Compensation Review DateDateGeneric Edit60
41YNCOCHGCompany changeCharacterGeneric Edit10 Allow NULL? 
42YNBUCHGBU changeCharacterGeneric Edit10 Allow NULL? 
43YNPSCHGPay Status changeCharacterGeneric Edit10 Allow NULL? 
44YNUNCHGUnion changeCharacterGeneric Edit10 Allow NULL? 
45YNLOCHGLocality ChangeCharacterGeneric Edit10 Allow NULL? 
46YNPCCHGPay Class ChangeCharacterGeneric Edit10 Allow NULL? 
47YNCSCHGCurrent Salary ChangeCharacterGeneric Edit10 Allow NULL? 
48YNCCCHGCurrent Compa ChangeCharacterGeneric Edit10 Allow NULL? 
49YNCPCHGCurrent Position ChangeCharacterGeneric Edit10 Allow NULL? 
50YNPDCHGPosition Date changeCharacterGeneric Edit10 Allow NULL? 
51YNJDCHGJob Date changeCharacterGeneric Edit10 Allow NULL? 
52YNSPCHGSupervisorChangeCharacterGeneric Edit10 Allow NULL? 
53YNCJTCHGCurrent Job Type ChangeCharacterGeneric Edit10 Allow NULL? 
54YNCJSCHGCurrent Job Step ChangeCharacterGeneric Edit10 Allow NULL? 
55YNCPGCHGCurrent Pay Grade ChangeCharacterGeneric Edit10 Allow NULL? 
56YNCPSCHGCurrent Pay Step ChangeCharacterGeneric Edit10 Allow NULL? 
57YNLRDCHGLast Raise Date ChangeCharacterGeneric Edit10 Allow NULL? 
58YNNSEFTONew Salary Effective DateDateGeneric Edit60
59YNNASNew Annualized SalaryNumericGeneric Edit112 Allow NULL? 
60YNNSORNew Salary Outside rangeCharacterGeneric Edit10 Allow NULL? 
61YNNCRNew Compa RatioNumericGeneric Edit52 Allow NULL? 
62YNNPOSNew PositionStringGeneric Edit80 Allow NULL? 
63YNNEJTNew External Job TitleStringGeneric Edit300 Allow NULL? 
64YNNHRRNew Hourly RateNumericGeneric Edit93 Allow NULL? 
65YNNSALYNew Pay Class (H/S/P)CharacterUDC (05A PK)10 Allow NULL? 
66YNNPDL01New Position DescriptionStringGeneric Edit300 Allow NULL? 
67YNNJTNew Job TypeStringGeneric Edit60 Allow NULL? 
68YNNJTDLNew Job Type DescriptionStringGeneric Edit300 Allow NULL? 
69YNNJSNew Job StepStringGeneric Edit40 Allow NULL? 
70YNNPGRNew Pay GradeStringGeneric Edit60 Allow NULL? 
71YNNPSTNew Pay StepStringGeneric Edit40 Allow NULL? 
72YNPFRQPay FrequencyCharacterUDC (06 PF)10 Allow NULL? 
73YNFLSAFLSA Exempt Y/NCharacterUDC (05 FL)10 Allow NULL? 
74YNNUNNew Union CodeStringGeneric Edit60 Allow NULL? 
75YNDIVCBenefit GroupStringGeneric Edit60 Allow NULL? 
76YNJTTRSSubmit Reports Status FlagStringGeneric Edit30 Allow NULL? 
77YNPAPLPerformance Appraisal LevelNumericGeneric Edit63 Allow NULL? 
78YNDATRVWDate Last ReviewedDateGeneric Edit60
79YNTIRNKTier/RankingNumericGeneric Edit50 Allow NULL? 
80YNTRNKDLast Tier/Rank dateDateGeneric Edit60
81YNJBPCTRQDTotal Job Competency Percent AchievedNumericGeneric Edit152 Allow NULL? 
82YNLTJCRWLast Total Job Competency review dateDateGeneric Edit60
83YNTBAMTotal Budget AmountNumericGeneric Edit112 Allow NULL? 
84YNTIAMTotal Increase AmountNumericGeneric Edit112 Allow NULL? 
85YNAPPSTApproval StatusCharacterGeneric Edit10 Allow NULL? 
86YNANABResponding SupervisorNumericGeneric Edit80 Allow NULL? 
87YNLARDLast Approved/Rejected DateDateGeneric Edit60
88YNUSERUser IDStringGeneric Edit100 Allow NULL? 
89YNPIDProgram IDStringGeneric Edit100 Allow NULL? 
90YNUPMJDate - UpdatedDateGeneric Edit60
91YNUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
92YNJOBNWork Station IDStringGeneric Edit100 Allow NULL? 

TOP920 | 08W | F08830WF INDEXES

NumberDescription
1Model RevType EE# Ownr +A (Primary/Unique)
ElementAliasDescriptionSequence
1MNAMEModel NameAscending
2RWTYPReview TypeAscending
3AN8Address NumberAscending
4MOWNRModel OwnerAscending
3ModelName RevType AlphaName
ElementAliasDescriptionSequence
1MNAMEModel NameAscending
2RWTYPReview TypeAscending
3ALPHName - AlphaAscending
4Model RevType EE#
ElementAliasDescriptionSequence
1MNAMEModel NameAscending
2RWTYPReview TypeAscending
3AN8Address NumberAscending
5Model RevType Alpha Ownr
ElementAliasDescriptionSequence
1MNAMEModel NameAscending
2RWTYPReview TypeAscending
3ALPHName - AlphaAscending
4MOWNRModel OwnerAscending