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
F30L: DFM Line Design
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910FF30L910LH216Mixed Model Line Design HeaderFilesF30L: DFM Line Design
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 LHLNDSID, LHDFLNID, LHFSCID, LHLNDSNA, LHLDDD, LHLDACT, LHPMAPID, LHDS01, LHDTYPE, LHDFLDTY, LHDFLDSC, LHDFDMP, LHURCD, LHURDT, LHURAT, LHURAB, LHURRF, LHUSER, LHMKEY, LHPID, LHUUPMJ FROM FF30L910

TOP910 | F30L | FF30L910 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1LHLNDSIDDFM Line Design IDNumericGeneric Edit150 Allow NULL? 
2LHDFLNIDDFM Line IDNumericGeneric Edit150 Allow NULL? 
3LHFSCIDScenario IDNumericGeneric Edit150 Allow NULL? 
4LHLNDSNADFM Line Design NameStringGeneric Edit300 Allow NULL? 
5LHLDDDDate Last CalculatedJDE UTimeGeneric Edit110
6LHLDACTLine Design StatusCharacterUDC (F30L AC)10 Allow NULL? 
7LHPMAPIDProcess Map IdentifierNumericGeneric Edit150 Allow NULL? 
8LHDS01DescriptionStringGeneric Edit800 Allow NULL? 
9LHDTYPEDemand TypeStringUDC (F30L DT)20 Allow NULL? 
10LHDFLDTYLine Design TypeCharacterUDC (F30L TY)10 Allow NULL? 
11LHDFLDSCSequencing CapabilityStringUDC (F30L SQ)20 Allow NULL? 
12LHDFDMPDaily Mix PercentNumericGeneric Edit152 Allow NULL? 
13LHURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
14LHURDTUser Reserved DateDateGeneric Edit60
15LHURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
16LHURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
17LHURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
18LHUSERUser IDStringGeneric Edit100 Allow NULL? 
19LHMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
20LHPIDProgram IDStringGeneric Edit100 Allow NULL? 
21LHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110

TOP910 | F30L | FF30L910 INDEXES

NumberDescription
1LineDesignID (Primary/Unique)
ElementAliasDescriptionSequence
1LNDSIDDFM Line Design IDAscending
2Scenario LineDesignName (Unique)
ElementAliasDescriptionSequence
1FSCIDScenario IDAscending
2LNDSNADFM Line Design NameAscending
3Scenario
ElementAliasDescriptionSequence
1FSCIDScenario IDAscending
4LineDesignStatus
ElementAliasDescriptionSequence
1DFLNIDDFM Line IDAscending
2LDACTLine Design StatusAscending
5LineID LineDesignID (Unique)
ElementAliasDescriptionSequence
1LNDSIDDFM Line Design IDAscending
2DFLNIDDFM Line IDAscending
6Scenario ProcessMapID
ElementAliasDescriptionSequence
1FSCIDScenario IDAscending
2PMAPIDProcess Map IdentifierAscending