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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

82 COLUMNS | 1 INDEXES | Print definition?920 | 51F | F51F90 TABLE

51F: Advanced Job Forecasting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F51F90QN821Formula DefinitionFiles51F: Advanced Job Forecasting
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 QN51FFN, QN51FFD, QN51FC1, QN51FCT1, QN51FC2, QN51FCT2, QN51FC3, QN51FCT3, QN51FC4, QN51FCT4, QN51FC5, QN51FCT5, QN51FC6, QN51FCT6, QN51FC7, QN51FCT7, QN51FC8, QN51FCT8, QN51FC9, QN51FCT9, QN51FC10, QN51FCT10, QN51FC11, QN51FCT11, QN51FC12, QN51FCT12, QN51FC13, QN51FCT13, QN51FC14, QN51FCT14, QN51FC15, QN51FCT15, QN51FC16, QN51FCT16, QN51FC17, QN51FCT17, QN51FC18, QN51FCT18, QN51FC19, QN51FCT19, QN51FC20, QN51FCT20, QN51FC21, QN51FCT21, QN51FC22, QN51FCT22, QN51FC23, QN51FCT23, QN51FC24, QN51FCT24, QN51FO1, QN51FO2, QN51FO3, QN51FO4, QN51FO5, QN51FO6, QN51FO7, QN51FO8, QN51FO9, QN51FO10, QN51FO11, QN51FO12, QN51FO13, QN51FO14, QN51FO15, QN51FO16, QN51FO17, QN51FO18, QN51FO19, QN51FO20, QN51FO21, QN51FO22, QN51FO23, QN51FFRM, QNENTJ, QNTENT, QNUSER, QNUPMJ, QNUPMT, QNJOBN, QNPID, QNMKEY FROM F51F90

TOP920 | 51F | F51F90 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1QN51FFNFormula NameStringGeneric Edit60 Allow NULL? 
2QN51FFDFormula DescriptionStringGeneric Edit300 Allow NULL? 
3QN51FC1Formula Component 1StringGeneric Edit60 Allow NULL? 
4QN51FCT1Formula Component Type 1CharacterUDC (51F CT)10 Allow NULL? 
5QN51FC2Formula Component 2StringGeneric Edit60 Allow NULL? 
6QN51FCT2Formula Component Type 2CharacterUDC (51F CT)10 Allow NULL? 
7QN51FC3Formula Component 3StringGeneric Edit60 Allow NULL? 
8QN51FCT3Formula Component Type 3CharacterUDC (51F CT)10 Allow NULL? 
9QN51FC4Formula Component 4StringGeneric Edit60 Allow NULL? 
10QN51FCT4Formula Component Type 4CharacterUDC (51F CT)10 Allow NULL? 
11QN51FC5Formula Component 5StringGeneric Edit60 Allow NULL? 
12QN51FCT5Formula Component Type 5CharacterUDC (51F CT)10 Allow NULL? 
13QN51FC6Formula Component 6StringGeneric Edit60 Allow NULL? 
14QN51FCT6Formula Component Type 6CharacterUDC (51F CT)10 Allow NULL? 
15QN51FC7Formula Component 7StringGeneric Edit60 Allow NULL? 
16QN51FCT7Formula Component Type 7CharacterUDC (51F CT)10 Allow NULL? 
17QN51FC8Formula Component 8StringGeneric Edit60 Allow NULL? 
18QN51FCT8Formula Component Type 8CharacterUDC (51F CT)10 Allow NULL? 
19QN51FC9Formula Component 9StringGeneric Edit60 Allow NULL? 
20QN51FCT9Formula Component Type 9CharacterUDC (51F CT)10 Allow NULL? 
21QN51FC10Formula Component 10StringGeneric Edit60 Allow NULL? 
22QN51FCT10Formula Component Type 10CharacterUDC (51F CT)10 Allow NULL? 
23QN51FC11Formula Component 11StringGeneric Edit60 Allow NULL? 
24QN51FCT11Formula Component Type 11CharacterUDC (51F CT)10 Allow NULL? 
25QN51FC12Formula Component 12StringGeneric Edit60 Allow NULL? 
26QN51FCT12Formula Component Type 12CharacterUDC (51F CT)10 Allow NULL? 
27QN51FC13Formula Component 13StringGeneric Edit60 Allow NULL? 
28QN51FCT13Formula Component Type 13CharacterUDC (51F CT)10 Allow NULL? 
29QN51FC14Formula Component 14StringGeneric Edit60 Allow NULL? 
30QN51FCT14Formula Component Type 14CharacterUDC (51F CT)10 Allow NULL? 
31QN51FC15Formula Component 15StringGeneric Edit60 Allow NULL? 
32QN51FCT15Formula Component Type 15CharacterUDC (51F CT)10 Allow NULL? 
33QN51FC16Formula Component 16StringGeneric Edit60 Allow NULL? 
34QN51FCT16Formula Component Type 16CharacterUDC (51F CT)10 Allow NULL? 
35QN51FC17Formula Component 17StringGeneric Edit60 Allow NULL? 
36QN51FCT17Formula Component Type 17CharacterUDC (51F CT)10 Allow NULL? 
37QN51FC18Formula Component 18StringGeneric Edit60 Allow NULL? 
38QN51FCT18Formula Component Type 18CharacterUDC (51F CT)10 Allow NULL? 
39QN51FC19Formula Component 19StringGeneric Edit60 Allow NULL? 
40QN51FCT19Formula Component Type 19CharacterUDC (51F CT)10 Allow NULL? 
41QN51FC20Formula Component 20StringGeneric Edit60 Allow NULL? 
42QN51FCT20Formula Component Type 20CharacterUDC (51F CT)10 Allow NULL? 
43QN51FC21Formula Component 21StringGeneric Edit60 Allow NULL? 
44QN51FCT21Formula Component Type 21CharacterUDC (51F CT)10 Allow NULL? 
45QN51FC22Formula Component 22StringGeneric Edit60 Allow NULL? 
46QN51FCT22Formula Component Type 22CharacterUDC (51F CT)10 Allow NULL? 
47QN51FC23Formula Component 23StringGeneric Edit60 Allow NULL? 
48QN51FCT23Formula Component Type 23CharacterUDC (51F CT)10 Allow NULL? 
49QN51FC24Formula Component 24StringGeneric Edit60 Allow NULL? 
50QN51FCT24Formula Component Type 24CharacterUDC (51F CT)10 Allow NULL? 
51QN51FO1Formula Operator 1CharacterUDC (51F OP)10 Allow NULL? 
52QN51FO2Formula Operator 2CharacterUDC (51F OP)10 Allow NULL? 
53QN51FO3Formula Operator 3CharacterUDC (51F OP)10 Allow NULL? 
54QN51FO4Formula Operator 4CharacterUDC (51F OP)10 Allow NULL? 
55QN51FO5Formula Operator 5CharacterUDC (51F OP)10 Allow NULL? 
56QN51FO6Formula Operator 6CharacterUDC (51F OP)10 Allow NULL? 
57QN51FO7Formula Operator 7CharacterUDC (51F OP)10 Allow NULL? 
58QN51FO8Formula Operator 8CharacterUDC (51F OP)10 Allow NULL? 
59QN51FO9Formula Operator 9CharacterUDC (51F OP)10 Allow NULL? 
60QN51FO10Formula Operator 10CharacterUDC (51F OP)10 Allow NULL? 
61QN51FO11Formula Operator 11CharacterUDC (51F OP)10 Allow NULL? 
62QN51FO12Formula Operator 12CharacterUDC (51F OP)10 Allow NULL? 
63QN51FO13Formula Operator 13CharacterUDC (51F OP)10 Allow NULL? 
64QN51FO14Formula Operator 14CharacterUDC (51F OP)10 Allow NULL? 
65QN51FO15Formula Operator 15CharacterUDC (51F OP)10 Allow NULL? 
66QN51FO16Formula Operator 16CharacterUDC (51F OP)10 Allow NULL? 
67QN51FO17Formula Operator 17CharacterUDC (51F OP)10 Allow NULL? 
68QN51FO18Formula Operator 18CharacterUDC (51F OP)10 Allow NULL? 
69QN51FO19Formula Operator 19CharacterUDC (51F OP)10 Allow NULL? 
70QN51FO20Formula Operator 20CharacterUDC (51F OP)10 Allow NULL? 
71QN51FO21Formula Operator 21CharacterUDC (51F OP)10 Allow NULL? 
72QN51FO22Formula Operator 22CharacterUDC (51F OP)10 Allow NULL? 
73QN51FO23Formula Operator 23CharacterUDC (51F OP)10 Allow NULL? 
74QN51FFRMFormulaStringGeneric Edit800 Allow NULL? 
75QNENTJDate - EnteredDateGeneric Edit60
76QNTENTTime EnteredNumericGeneric Edit60 Allow NULL? 
77QNUSERUser IDStringGeneric Edit100 Allow NULL? 
78QNUPMJDate - UpdatedDateGeneric Edit60
79QNUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
80QNJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
81QNPIDProgram IDStringGeneric Edit100 Allow NULL? 
82QNMKEYMachine KeyStringGeneric Edit150 Allow NULL? 

TOP920 | 51F | F51F90 INDEXES

NumberDescription
1FormulaName (Primary/Unique)
ElementAliasDescriptionSequence
151FFNFormula NameAscending