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

76 COLUMNS | 12 INDEXES | Print definition?812 | 08P | F08001 TABLE

08P: Position Control
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F08001JM7612Job informationMaster Files08P: Position ControlAS400 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 JMJGRP, JMJBCD, JMJBST, JMDL01, JMSALY, JMPGRD, JMPFRQ, JMEEOJ, JMWCMP, JMWET, JMFLSA, JMDIVC, JMUN, JMEMET, JMEVD, JMEPNT, JMD001, JMD002, JMD003, JMD004, JMD005, JMD006, JMD007, JMD008, JMD009, JMD010, JMPT01, JMPT02, JMPT03, JMPT04, JMPT05, JMPT06, JMPT07, JMPT08, JMPT09, JMPT10, JMP001, JMP002, JMP003, JMP004, JMP005, JMP006, JMP007, JMP008, JMP009, JMP010, JMFE01, JMFE02, JMFE03, JMFE04, JMFE05, JMFE06, JMFE07, JMFE08, JMFE09, JMFE10, JMFW01, JMFW02, JMFW03, JMFW04, JMFW05, JMFW06, JMFW07, JMFW08, JMFW09, JMFW10, JMJSTA, JMEFTB, JMEFTE, JMUSER, JMPID, JMJOBN, JMUPMJ, JMPGRS, JMCENC, JMSTCR FROM F08001

TOP812 | 08P | F08001 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1JMJGRPJob GroupStringUDC (08 JG)60 Allow NULL? 
2JMJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
3JMJBSTJob StepStringUDC (06 GS)40 Allow NULL? 
4JMDL01DescriptionStringGeneric Edit300 Allow NULL? 
5JMSALYPay Class (H/S/P)CharacterUDC (05A PK)10 Allow NULL? 
6JMPGRDPay GradeStringGeneric Edit60 Allow NULL? 
7JMPFRQPay FrequencyCharacterUDC (06 PF)10 Allow NULL? 
8JMEEOJJob Category (EEO)StringUDC (06 J)30 Allow NULL? 
9JMWCMPWorker's Comp. Insurance CodeStringUDC (00 W)40 Allow NULL? 
10JMWETSub Class - Workers CompCharacterUDC (07 WH)10 Allow NULL? 
11JMFLSAFLSA Exempt Y/NCharacterUDC (05 FL)10 Allow NULL? 
12JMDIVCBenefit GroupStringGeneric Edit60 Allow NULL? 
13JMUNUnion CodeStringUDC (06 UN)60 Allow NULL? 
14JMEMETJob Evaluation MethodStringUDC (08 EM)40 Allow NULL? 
15JMEVDDate - Job Evaluation (Julian)DateGeneric Edit60
16JMEPNTJob Evaluation PointsNumericGeneric Edit50 Allow NULL? 
17JMD001Job Evaluation Factor-Points in Degr 001NumericGeneric Edit50 Allow NULL? 
18JMD002Job Evaluation Factor-Points in Degr 002NumericGeneric Edit50 Allow NULL? 
19JMD003Job Evaluation Factor-Points in Degr 003NumericGeneric Edit50 Allow NULL? 
20JMD004Job Evaluation Factor-Points in Degr 004NumericGeneric Edit50 Allow NULL? 
21JMD005Job Evaluation Factor-Points in Degr 005NumericGeneric Edit50 Allow NULL? 
22JMD006Job Evaluation Factor-Points in Degr 006NumericGeneric Edit50 Allow NULL? 
23JMD007Job Evaluation Factor-Points in Degr 007NumericGeneric Edit50 Allow NULL? 
24JMD008Job Evaluation Factor-Points in Degr 008NumericGeneric Edit50 Allow NULL? 
25JMD009Job Evaluation Factor-Points in Degr 009NumericGeneric Edit50 Allow NULL? 
26JMD010Job Evaluation Factor-Points in Degr 010NumericGeneric Edit50 Allow NULL? 
27JMPT01Job Evaluation Points per Factor 01NumericGeneric Edit50 Allow NULL? 
28JMPT02Job Evaluation Points per Factor 02NumericGeneric Edit50 Allow NULL? 
29JMPT03Job Evaluation Points per Factor 03NumericGeneric Edit50 Allow NULL? 
30JMPT04Job Evaluation Points per Factor 04NumericGeneric Edit50 Allow NULL? 
31JMPT05Job Evaluation Points per Factor 05NumericGeneric Edit50 Allow NULL? 
32JMPT06Job Evaluation Points per Factor 06NumericGeneric Edit50 Allow NULL? 
33JMPT07Job Evaluation Points per Factor 07NumericGeneric Edit50 Allow NULL? 
34JMPT08Job Evaluation Points per Factor 08NumericGeneric Edit50 Allow NULL? 
35JMPT09Job Evaluation Points per Factor 09NumericGeneric Edit50 Allow NULL? 
36JMPT10Job Evaluation Points per Factor 10NumericGeneric Edit50 Allow NULL? 
37JMP001Category Codes - Payroll1StringUDC (06 01)30 Allow NULL? 
38JMP002Category Codes - Payroll2StringUDC (06 02)30 Allow NULL? 
39JMP003Category Codes - Payroll3StringUDC (06 03)30 Allow NULL? 
40JMP004Category Codes - Payroll4StringUDC (06 04)30 Allow NULL? 
41JMP005Category Codes - Payroll5StringUDC (06 05)30 Allow NULL? 
42JMP006Category Codes - Payroll6StringUDC (06 06)30 Allow NULL? 
43JMP007Category Codes - Payroll7StringUDC (06 07)30 Allow NULL? 
44JMP008Category Codes - Payroll8StringUDC (06 08)30 Allow NULL? 
45JMP009Category Codes - Payroll9StringUDC (06 09)30 Allow NULL? 
46JMP010Category Codes - Payroll10StringUDC (06 10)30 Allow NULL? 
47JMFE01Factor Evaluation Code 1StringGeneric Edit100 Allow NULL? 
48JMFE02Factor Evaluation Code 2StringGeneric Edit100 Allow NULL? 
49JMFE03Factor Evaluation Code 3StringGeneric Edit100 Allow NULL? 
50JMFE04Factor Evaluation Code 4StringGeneric Edit100 Allow NULL? 
51JMFE05Factor Evaluation Code 5StringGeneric Edit100 Allow NULL? 
52JMFE06Factor Evaluation Code 6StringGeneric Edit100 Allow NULL? 
53JMFE07Factor Evaluation Code 7StringGeneric Edit100 Allow NULL? 
54JMFE08Factor Evaluation Code 8StringGeneric Edit100 Allow NULL? 
55JMFE09Factor Evaluation Code 9StringGeneric Edit100 Allow NULL? 
56JMFE10Factor Evaluation Code 10StringGeneric Edit100 Allow NULL? 
57JMFW01Factor Weight % 1NumericGeneric Edit52 Allow NULL? 
58JMFW02Factor Weight % 2NumericGeneric Edit52 Allow NULL? 
59JMFW03Factor Weight % 3NumericGeneric Edit52 Allow NULL? 
60JMFW04Factor Weight % 4NumericGeneric Edit52 Allow NULL? 
61JMFW05Factor Weight % 5NumericGeneric Edit52 Allow NULL? 
62JMFW06Factor Weight % 6NumericGeneric Edit52 Allow NULL? 
63JMFW07Factor Weight % 7NumericGeneric Edit52 Allow NULL? 
64JMFW08Factor Weight % 8NumericGeneric Edit52 Allow NULL? 
65JMFW09Factor Weight % 9NumericGeneric Edit52 Allow NULL? 
66JMFW10Factor Weight % 10NumericGeneric Edit52 Allow NULL? 
67JMJSTAJob Status CodeStringUDC (08 JS)30 Allow NULL? 
68JMEFTBDate - Beginning EffectiveDateGeneric Edit60
69JMEFTEDate - Ending EffectiveDateGeneric Edit60
70JMUSERUser IDStringGeneric Edit100 Allow NULL? 
71JMPIDProgram IDStringGeneric Edit100 Allow NULL? 
72JMJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
73JMUPMJDate - UpdatedDateGeneric Edit60
74JMPGRSPay Grade StepStringGeneric Edit40 Allow NULL? 
75JMCENCNOC - Can Emp EquityStringUDC (05 NC)40 Allow NULL? 
76JMSTCRStatus Change ReasonStringUDC (08 JC)30 Allow NULL? 

TOP812 | 08P | F08001 INDEXES

NumberDescription
1Job Type Job Step (Primary/Unique)
ElementAliasDescriptionSequence
1JBCDJob Type (Craft) CodeAscending
2JBSTJob StepDescending
2Job Eval Mthd Job Cat A+
ElementAliasDescriptionSequence
1EMETJob Evaluation MethodAscending
2JBCDJob Type (Craft) CodeAscending
3JBSTJob StepDescending
3Job Eval Mthd Job Eval001 A+
ElementAliasDescriptionSequence
1EMETJob Evaluation MethodAscending
2PT01Job Evaluation Points per Factor 01Descending
3JBCDJob Type (Craft) CodeAscending
4JBSTJob StepDescending
4Job Eval Mthd Job Eval002 B+
ElementAliasDescriptionSequence
1EMETJob Evaluation MethodAscending
2PT02Job Evaluation Points per Factor 02Descending
3JBCDJob Type (Craft) CodeAscending
4JBSTJob StepDescending
5Job Eval Mthd Job Eval003 C+
ElementAliasDescriptionSequence
1EMETJob Evaluation MethodAscending
2PT03Job Evaluation Points per Factor 03Descending
3JBCDJob Type (Craft) CodeAscending
4JBSTJob StepDescending
6Job Eval Mthd Job Eval004 D+
ElementAliasDescriptionSequence
1EMETJob Evaluation MethodAscending
2PT04Job Evaluation Points per Factor 04Descending
3JBCDJob Type (Craft) CodeAscending
4JBSTJob StepDescending
7Job Eval Mthd Job Eval005 E+
ElementAliasDescriptionSequence
1EMETJob Evaluation MethodAscending
2PT05Job Evaluation Points per Factor 05Descending
3JBCDJob Type (Craft) CodeAscending
4JBSTJob StepDescending
8Job Eval Mthd Job Eval006 F+
ElementAliasDescriptionSequence
1EMETJob Evaluation MethodAscending
2PT06Job Evaluation Points per Factor 06Descending
3JBCDJob Type (Craft) CodeAscending
4JBSTJob StepDescending
9Job Eval Mthd Job Eval007 G+
ElementAliasDescriptionSequence
1EMETJob Evaluation MethodAscending
2PT07Job Evaluation Points per Factor 07Descending
3JBCDJob Type (Craft) CodeAscending
4JBSTJob StepDescending
10Job Eval Mthd Job Eval008 H+
ElementAliasDescriptionSequence
1EMETJob Evaluation MethodAscending
2PT08Job Evaluation Points per Factor 08Descending
3JBCDJob Type (Craft) CodeAscending
4JBSTJob StepDescending
11Job Eval Mthd Job Eval009 I+
ElementAliasDescriptionSequence
1EMETJob Evaluation MethodAscending
2PT09Job Evaluation Points per Factor 09Descending
3JBCDJob Type (Craft) CodeAscending
4JBSTJob StepDescending
12Job Eval Mthd Job Eval010 J+
ElementAliasDescriptionSequence
1EMETJob Evaluation MethodAscending
2PT10Job Evaluation Points per Factor 10Descending
3JBCDJob Type (Craft) CodeDescending
4JBSTJob StepAscending