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

29 COLUMNS | 1 INDEXES | Print definition?920 | 74 | F74UI92 TABLE

74: EMEA Localization
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F74UI92CV291WF - Account Cell Value - EMEA - 74Files74: EMEA Localization
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 CVJOBS, CVE74RENA, CVE74RSN, CVE74RRN, CVE74ASEQ, CVE74CNO, CVE74VIS, CVE74RA, CVE74FUNC, CVFYOF, CVPNOF, CVE74LT, CVCRCD, CVE74LT01, CVE74RA01, CVE74LT02, CVE74RA02, CVE74LT03, CVE74RA03, CVE74LT04, CVE74RA04, CVE74CALC, CVCTRY, CVFY, CVPN, CVE74FORM, CVE74FACT, CVE74FDLE, CVE74CSTO FROM F74UI92

TOP920 | 74 | F74UI92 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1CVJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
2CVE74RENAReport NameStringGeneric Edit200 Allow NULL? 
3CVE74RSNReport Section NumberNumericGeneric Edit30 Allow NULL? 
4CVE74RRNReport Row NumberNumericGeneric Edit40 Allow NULL? 
5CVE74ASEQAccount SequenceNumericGeneric Edit60 Allow NULL? 
6CVE74CNOColumn NumberStringGeneric Edit20 Allow NULL? 
7CVE74VISVisibleCharacterGeneric Edit10 Allow NULL? 
8CVE74RAReport AmountNumericGeneric Edit152 Allow NULL? 
9CVE74FUNCFunction To ApplyStringUDC (74 FA)100 Allow NULL? 
10CVFYOFFiscal Year OffsetStringGeneric Edit30 Allow NULL? 
11CVPNOFPeriod Number OffsetStringGeneric Edit30 Allow NULL? 
12CVE74LTLedger TypeStringUDC (09 LT)20 Allow NULL? 
13CVCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
14CVE74LT01Ledger Type 01StringUDC (09 LT)20 Allow NULL? 
15CVE74RA01Report Amount 01NumericGeneric Edit152 Allow NULL? 
16CVE74LT02Ledger Type 02StringUDC (09 LT)20 Allow NULL? 
17CVE74RA02Report Amount 02NumericGeneric Edit152 Allow NULL? 
18CVE74LT03Ledger Type 03StringUDC (09 LT)20 Allow NULL? 
19CVE74RA03Report Amount 03NumericGeneric Edit152 Allow NULL? 
20CVE74LT04Ledger Type 04StringUDC (09 LT)20 Allow NULL? 
21CVE74RA04Report Amount 04NumericGeneric Edit152 Allow NULL? 
22CVE74CALCCell CalculatedCharacterGeneric Edit10 Allow NULL? 
23CVCTRYCenturyNumericGeneric Edit20 Allow NULL? 
24CVFYFiscal YearNumericGeneric Edit20 Allow NULL? 
25CVPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
26CVE74FORMFormula To ApplyStringGeneric Edit2400 Allow NULL? 
27CVE74FACTFactor To ApplyCharacterUDC (74 FR)10 Allow NULL? 
28CVE74FDLEFunction Definition LevelCharacterGeneric Edit10 Allow NULL? 
29CVE74CSTOColumn Show TotalCharacterGeneric Edit10 Allow NULL? 

TOP920 | 74 | F74UI92 INDEXES

NumberDescription
1JOBS RENA RSN RRN ASEQ CNO (Primary/Unique)
ElementAliasDescriptionSequence
1JOBSJob NumberAscending
2E74RENAReport NameAscending
3E74RSNReport Section NumberAscending
4E74RRNReport Row NumberAscending
5E74ASEQAccount SequenceAscending
6E74CNOColumn NumberAscending