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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

21 COLUMNS | 2 INDEXES | Print definition?920 | 41F | FCW06 TABLE

41F: Apparel Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920FCW06CH212Collection HeaderFiles41F: Apparel Management
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 CHC9COLL, CHC9SEAC, CHC9SEAY, CHC9DSC1, CHC9CST, CHC9PRDJ, CHC9RFDJ1, CHC9EADJ1, CHC9LTDJ1, CHC9RFDJ2, CHC9EADJ2, CHC9LTDJ2, CHC9RFDJ3, CHC9EADJ3, CHC9LTDJ3, CHC9RFDJ4, CHC9EADJ4, CHC9LTDJ4, CHC9RFDJ5, CHC9EADJ5, CHC9LTDJ5 FROM FCW06

TOP920 | 41F | FCW06 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1CHC9COLLCollectionStringGeneric Edit100 Allow NULL? 
2CHC9SEACSeason CodeStringUDC (41F SE)20 Allow NULL? 
3CHC9SEAYSeason YearStringUDC (41F SY)40 Allow NULL? 
4CHC9DSC1Description Line 1StringGeneric Edit300 Allow NULL? 
5CHC9CSTCollection StructureStringUDC (41F CS)30 Allow NULL? 
6CHC9PRDJDate - Price ReferenceDateGeneric Edit60
7CHC9RFDJ1Date - Reference 1DateGeneric Edit60
8CHC9EADJ1Effective DateDateGeneric Edit60
9CHC9LTDJ1Date - Later 1DateGeneric Edit60
10CHC9RFDJ2Date - Reference 2DateGeneric Edit60
11CHC9EADJ2Expiration DateDateGeneric Edit60
12CHC9LTDJ2Date - Later 2DateGeneric Edit60
13CHC9RFDJ3Date - Reference 3DateGeneric Edit60
14CHC9EADJ3Date Earlier 3DateGeneric Edit60
15CHC9LTDJ3Date - Later 3DateGeneric Edit60
16CHC9RFDJ4Date - Reference 4DateGeneric Edit60
17CHC9EADJ4Date Earlier 4DateGeneric Edit60
18CHC9LTDJ4Date - Later 4DateGeneric Edit60
19CHC9RFDJ5Date - Reference 5DateGeneric Edit60
20CHC9EADJ5Date Earlyer 5DateGeneric Edit60
21CHC9LTDJ5Date - Later 5DateGeneric Edit60

TOP920 | 41F | FCW06 INDEXES

NumberDescription
1C9COLL/C9SEAC/C9SEAY (Primary/Unique)
ElementAliasDescriptionSequence
1C9COLLCollectionAscending
2C9SEACSeason CodeAscending
3C9SEAYSeason YearAscending
2C9COLL/C9CST
ElementAliasDescriptionSequence
1C9COLLCollectionAscending
2C9CSTCollection StructureAscending