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

61 COLUMNS | 2 INDEXES | Print definition?910 | 40G | F40G01 TABLE

40G: Grower Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F40G01GF612Grower FarmFiles40G: Grower 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 GFAN8FARM, GFFARMCODE, GFFARMNAME, GFOWNID, GFFARMTYPE, GFOMCU, GFFSTATUS, GFGRCMPCD, GFAN8GR, GFAN8BR, GFAN8CR, GFGEOCST, GFGOAID, GFAPPID, GFGREGION, GFGDISTR, GFSITEC, GFSITEP, GFCONTUOM, GFAPPLLAT, GFGOAREA, GFQTYLOAD, GFFARM01, GFFARM02, GFFARM03, GFFARM04, GFFARM05, GFFARM06, GFFARM07, GFFARM08, GFFARM09, GFFARM10, GFFARM11, GFFARM12, GFFARM13, GFFARM14, GFFARM15, GFCFARM01, GFCFARM02, GFCFARM03, GFCFARM04, GFCFARM05, GFFNUM01, GFFNUM02, GFFNUM03, GFFNUM04, GFFNUM05, GFFDATE1, GFFDATE2, GFFDATE3, GFFDATE4, GFURCD, GFURDT, GFURRF, GFURAT, GFURAB, GFPID, GFTORG, GFUSER, GFJOBN, GFUUPMJ FROM F40G01

TOP910 | 40G | F40G01 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1GFAN8FARMFarm Address Book NumberNumericGeneric Edit80 Allow NULL? 
2GFFARMCODEFarm CodeStringGeneric Edit80 Allow NULL? 
3GFFARMNAMEFarm NameStringGeneric Edit400 Allow NULL? 
4GFOWNIDOwner IdentifierCharacterGeneric Edit10 Allow NULL? 
5GFFARMTYPEFarm TypeCharacterUDC (40G FT)10 Allow NULL? 
6GFOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
7GFFSTATUSFarm Status CodeCharacterUDC (40G SC)10 Allow NULL? 
8GFGRCMPCDGrower Composition CodeStringUDC (40G GC)100 Allow NULL? 
9GFAN8GRGrower RepresentativeNumericGeneric Edit80 Allow NULL? 
10GFAN8BRBlend RepresentativeNumericGeneric Edit80 Allow NULL? 
11GFAN8CRContract RepresentativeNumericGeneric Edit80 Allow NULL? 
12GFGEOCSTGeographic IDStringUDC (40G GI)30 Allow NULL? 
13GFGOAIDGeographic Area IDNumericGeneric Edit80 Allow NULL? 
14GFAPPIDAppellation IDNumericGeneric Edit80 Allow NULL? 
15GFGREGIONGrowing RegionStringUDC (40G GR)100 Allow NULL? 
16GFGDISTRGrowing DistrictStringUDC (40G GD)100 Allow NULL? 
17GFSITECCrush SiteStringGeneric Edit120 Allow NULL? 
18GFSITEPProduced SiteStringGeneric Edit120 Allow NULL? 
19GFCONTUOMContainer Type UomStringUDC (00 UM)20 Allow NULL? 
20GFAPPLLATCode - AppellationStringGeneric Edit80 Allow NULL? 
21GFGOAREACode - Geographic AreaStringGeneric Edit40 Allow NULL? 
22GFQTYLOADQuantity Per LoadNumericGeneric Edit154 Allow NULL? 
23GFFARM01Farm Attribute 1StringUDC (40G F1)30 Allow NULL? 
24GFFARM02Farm Attribute 2StringUDC (40G F2)30 Allow NULL? 
25GFFARM03Farm Atttribute 3StringUDC (40G F3)30 Allow NULL? 
26GFFARM04Farm Attribute 4StringUDC (40G F4)30 Allow NULL? 
27GFFARM05Farm Attribute 5StringUDC (40G F5)30 Allow NULL? 
28GFFARM06Farm Attribute 6StringUDC (40G F6)80 Allow NULL? 
29GFFARM07Farm Attribute 7StringUDC (40G F7)80 Allow NULL? 
30GFFARM08Farm Attribute 8StringUDC (40G F8)80 Allow NULL? 
31GFFARM09Farm Attribute 9StringUDC (40G F9)80 Allow NULL? 
32GFFARM10Farm Attribute 10StringUDC (40G 0F)80 Allow NULL? 
33GFFARM11Farm Attribute 11StringUDC (40G 1F)100 Allow NULL? 
34GFFARM12Farm Attribute 12StringUDC (40G 2F)100 Allow NULL? 
35GFFARM13Farm Attribute 13StringUDC (40G 3F)100 Allow NULL? 
36GFFARM14Farm Attribute 14StringUDC (40G 4F)100 Allow NULL? 
37GFFARM15Farm Attribute 15StringUDC (40G 5F)100 Allow NULL? 
38GFCFARM01Farm Checkbox 01CharacterGeneric Edit10 Allow NULL? 
39GFCFARM02Farm Checkbox 02CharacterGeneric Edit10 Allow NULL? 
40GFCFARM03Farm Checkbox 03CharacterGeneric Edit10 Allow NULL? 
41GFCFARM04Farm Checkbox 04CharacterGeneric Edit10 Allow NULL? 
42GFCFARM05Farm Checkbox 05CharacterGeneric Edit10 Allow NULL? 
43GFFNUM01Farm Numeric 01NumericGeneric Edit157 Allow NULL? 
44GFFNUM02Farm Numeric 02NumericGeneric Edit157 Allow NULL? 
45GFFNUM03Farm Numeric 03NumericGeneric Edit157 Allow NULL? 
46GFFNUM04Farm Numeric 04NumericGeneric Edit157 Allow NULL? 
47GFFNUM05Farm Numeric 05NumericGeneric Edit157 Allow NULL? 
48GFFDATE1Farm Generic Date 1JDE UTimeGeneric Edit110
49GFFDATE2Farm Generic Date 2JDE UTimeGeneric Edit110
50GFFDATE3Farm Generic Date 3JDE UTimeGeneric Edit110
51GFFDATE4Farm Generic Date 4JDE UTimeGeneric Edit110
52GFURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
53GFURDTUser Reserved DateDateGeneric Edit60
54GFURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
55GFURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
56GFURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
57GFPIDProgram IDStringGeneric Edit100 Allow NULL? 
58GFTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
59GFUSERUser IDStringGeneric Edit100 Allow NULL? 
60GFJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
61GFUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110

TOP910 | 40G | F40G01 INDEXES

NumberDescription
1FARMNO (Primary/Unique)
ElementAliasDescriptionSequence
1AN8FARMFarm Address Book NumberAscending
2FARMCODE
ElementAliasDescriptionSequence
1FARMCODEFarm CodeAscending