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
40G: Grower Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F40G0300HU1711Grower Harvest Update ProfileFiles40G: 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 HUHRUPID, HUHRUPDESC, HUUHARNAME, HUHARNAME, HUUHARSTS, HUHARSTS, HUUGRCMPCD, HUGRCMPCD, HUUAN8GR, HUAN8GR, HUUAN8BR, HUAN8BR, HUUAN8CR, HUAN8CR, HUUCURQLTY, HUCURQLTY, HUUTARQLTY, HUTARQLTY, HUUCSUPPLY, HUCSUPPLY, HUUUPLNMAT, HUUPLNMAT, HUUUCUTDAT, HUUCUTDAT, HUUPLNEST, HUPLNEST, HUUCURREST, HUCURREST, HUUUCURDAT, HUUCURDAT, HUUSCHQTY, HUSCHQTY, HUURECVQTY, HURECVQTY, HUUGOAREA, HUGOAREA, HUUAPPLLAT, HUAPPLLAT, HUUVARCODE, HUVARCODE, HUUGDISTR, HUGDISTR, HUUGREGION, HUGREGION, HUUCOUN, HUCOUN, HUUADDS, HUADDS, HUUMATYP, HUMATYP, HUUWATERTY, HUWATERTY, HUUIVOL, HUIVOL, HUUPRUNEMT, HUPRUNEMT, HUUSOILTYP, HUSOILTYP, HUUCLONE, HUCLONE, HUUROOTSTK, HUROOTSTK, HUUROWSPC, HUROWSPC, HUUPLTSPC, HUPLTSPC, HUUPDNOP, HUNOP, HUUPLTAREA, HUPLTAREA, HUUGRSAREA, HUGRSAREA, HUUUPLTDAT, HUUPLTDAT, HUUEXTRRTE, HUEXTRRTE, HUUCONTUOM, HUCONTUOM, HUUQTYLOAD, HUQTYLOAD, HUULSTLOAD, HULSTLOAD, HUUEXTRCMP, HUEXTRCMP, HUUQUARANT, HUQUARANT, HUUGROW01, HUGROW01, HUUGROW02, HUGROW02, HUUGROW03, HUGROW03, HUUGROW04, HUGROW04, HUUGROW05, HUGROW05, HUUGROW06, HUGROW06, HUUGROW07, HUGROW07, HUUGROW08, HUGROW08, HUUGROW09, HUGROW09, HUUGROW10, HUGROW10, HUUGROW11, HUGROW11, HUUGROW12, HUGROW12, HUUGROW13, HUGROW13, HUUGROW14, HUGROW14, HUUGROW15, HUGROW15, HUUUGDAT01, HUUGDATE01, HUUUGDAT02, HUUGDATE02, HUUUGDAT03, HUUGDATE03, HUUUGDAT04, HUUGDATE04, HUUUGDAT05, HUUGDATE05, HUUUGDAT06, HUUGDATE06, HUUUGDAT07, HUUGDATE07, HUUUGDAT08, HUUGDATE08, HUUGNUM01, HUGNUM01, HUUGNUM02, HUGNUM02, HUUGNUM03, HUGNUM03, HUUGNUM04, HUGNUM04, HUUGNUM05, HUGNUM05, HUUGNUM06, HUGNUM06, HUUCGROW01, HUCGROW01, HUUCGROW02, HUCGROW02, HUUCGROW03, HUCGROW03, HUUCGROW04, HUCGROW04, HUUCGROW05, HUCGROW05, HUUGPRC, HUGPRC, HUUAN8V, HUAN8V, HUUPTMATNM, HUMATCALID, HURECALMAT, HUURCD, HUURDT, HUURRF, HUURAB, HUURAT, HUTORG, HUUSER, HUPID, HUJOBN, HUUUPMJ FROM F40G0300

TOP920 | 40G | F40G0300 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1HUHRUPIDHarvest Update Profile IDNumericGeneric Edit80 Allow NULL? 
2HUHRUPDESCHarvest Update Profile DescriptionStringGeneric Edit400 Allow NULL? 
3HUUHARNAMEUpdate Harvest NameCharacterGeneric Edit10 Allow NULL? 
4HUHARNAMEHarvest NameStringGeneric Edit400 Allow NULL? 
5HUUHARSTSUpdate Harvest StatusCharacterGeneric Edit10 Allow NULL? 
6HUHARSTSHarvest Status CodeCharacterUDC (40G HT)10 Allow NULL? 
7HUUGRCMPCDUpdate Grower Composition CodeCharacterGeneric Edit10 Allow NULL? 
8HUGRCMPCDGrower Composition CodeStringUDC (40G GC)100 Allow NULL? 
9HUUAN8GRUpdate Grower RepresentativeCharacterGeneric Edit10 Allow NULL? 
10HUAN8GRGrower RepresentativeNumericGeneric Edit80 Allow NULL? 
11HUUAN8BRUpdate Blend RepresentativeCharacterGeneric Edit10 Allow NULL? 
12HUAN8BRBlend RepresentativeNumericGeneric Edit80 Allow NULL? 
13HUUAN8CRUpdate Contract RepresentativeCharacterGeneric Edit10 Allow NULL? 
14HUAN8CRContract RepresentativeNumericGeneric Edit80 Allow NULL? 
15HUUCURQLTYUpdate Current QualityCharacterGeneric Edit10 Allow NULL? 
16HUCURQLTYCurrent QualityCharacterUDC (40G QL)10 Allow NULL? 
17HUUTARQLTYUpdate Target QualityCharacterGeneric Edit10 Allow NULL? 
18HUTARQLTYTarget QualityCharacterUDC (40G QL)10 Allow NULL? 
19HUUCSUPPLYUpdate Confidence Of SupplyCharacterGeneric Edit10 Allow NULL? 
20HUCSUPPLYConfidence Of SupplyNumericGeneric Edit70 Allow NULL? 
21HUUUPLNMATUpdate Planned Maturity DateCharacterGeneric Edit10 Allow NULL? 
22HUUPLNMATDate - Planned MaturityJDE UTimeGeneric Edit110
23HUUUCUTDATUpdate Cut DateCharacterGeneric Edit10 Allow NULL? 
24HUUCUTDATCut DateJDE UTimeGeneric Edit110
25HUUPLNESTUpdate Planned EstimateCharacterGeneric Edit10 Allow NULL? 
26HUPLNESTPlanned EstimateNumericGeneric Edit154 Allow NULL? 
27HUUCURRESTUpdate Current EstimateCharacterGeneric Edit10 Allow NULL? 
28HUCURRESTCurrent EstimateNumericGeneric Edit150 Allow NULL? 
29HUUUCURDATUpdate Current Estimate DateCharacterGeneric Edit10 Allow NULL? 
30HUUCURDATCurrent Estimate DateJDE UTimeGeneric Edit110
31HUUSCHQTYUpdate Scheduled QuantityCharacterGeneric Edit10 Allow NULL? 
32HUSCHQTYScheduled QuantityNumericGeneric Edit154 Allow NULL? 
33HUURECVQTYUpdate Received QuantityCharacterGeneric Edit10 Allow NULL? 
34HURECVQTYReceived QuantityNumericGeneric Edit154 Allow NULL? 
35HUUGOAREAUpdate Growing AreaCharacterGeneric Edit10 Allow NULL? 
36HUGOAREACode - Geographic AreaStringGeneric Edit40 Allow NULL? 
37HUUAPPLLATUpdate AppellationCharacterGeneric Edit10 Allow NULL? 
38HUAPPLLATCode - AppellationStringGeneric Edit80 Allow NULL? 
39HUUVARCODEUpdate Variety CodeCharacterGeneric Edit10 Allow NULL? 
40HUVARCODECode - VarietyStringGeneric Edit50 Allow NULL? 
41HUUGDISTRUpdate DistrictCharacterGeneric Edit10 Allow NULL? 
42HUGDISTRGrowing DistrictStringUDC (40G GD)100 Allow NULL? 
43HUUGREGIONUpdate RegionCharacterGeneric Edit10 Allow NULL? 
44HUGREGIONGrowing RegionStringUDC (40G GR)100 Allow NULL? 
45HUUCOUNUpdate CountyCharacterGeneric Edit10 Allow NULL? 
46HUCOUNCountyStringUDC (00 CT)250 Allow NULL? 
47HUUADDSUpdate StateCharacterGeneric Edit10 Allow NULL? 
48HUADDSStateStringUDC (00 S)30 Allow NULL? 
49HUUMATYPUpdate Material TypeCharacterGeneric Edit10 Allow NULL? 
50HUMATYPMaterial Type CodeStringGeneric Edit40 Allow NULL? 
51HUUWATERTYUpdate Irrigation TypeCharacterGeneric Edit10 Allow NULL? 
52HUWATERTYIrrigation TypeStringUDC (40G IT)20 Allow NULL? 
53HUUIVOLUpdate Irrigation VolumeCharacterGeneric Edit10 Allow NULL? 
54HUIVOLIrrigation VolumeNumericGeneric Edit152 Allow NULL? 
55HUUPRUNEMTUpdate Pruning MethodCharacterGeneric Edit10 Allow NULL? 
56HUPRUNEMTPruning MethodStringUDC (40G PM)20 Allow NULL? 
57HUUSOILTYPUpdate Soil TypeCharacterGeneric Edit10 Allow NULL? 
58HUSOILTYPSoil TypeStringUDC (40G ST)20 Allow NULL? 
59HUUCLONEUpdate CloneCharacterGeneric Edit10 Allow NULL? 
60HUCLONECloneStringUDC (40G CL)20 Allow NULL? 
61HUUROOTSTKUpdate Root StockCharacterGeneric Edit10 Allow NULL? 
62HUROOTSTKRoot StockStringUDC (40G RS)20 Allow NULL? 
63HUUROWSPCUpdate Row SpacingCharacterGeneric Edit10 Allow NULL? 
64HUROWSPCRow SpacingStringUDC (40G RW)20 Allow NULL? 
65HUUPLTSPCUpdate Plant SpacingCharacterGeneric Edit10 Allow NULL? 
66HUPLTSPCPlant SpacingStringUDC (40G PL)20 Allow NULL? 
67HUUPDNOPUpdate Number Of PlantsCharacterGeneric Edit10 Allow NULL? 
68HUNOPNumber of PlantsNumericGeneric Edit80 Allow NULL? 
69HUUPLTAREAUpdate Planted AreaCharacterGeneric Edit10 Allow NULL? 
70HUPLTAREAPlanted AreaNumericGeneric Edit154 Allow NULL? 
71HUUGRSAREAUpdate Gross AreaCharacterGeneric Edit10 Allow NULL? 
72HUGRSAREAGross AreaNumericGeneric Edit154 Allow NULL? 
73HUUUPLTDATUpdate Planted DateCharacterGeneric Edit10 Allow NULL? 
74HUUPLTDATPlanted DateJDE UTimeGeneric Edit110
75HUUEXTRRTEUpdate Extraction RateCharacterGeneric Edit10 Allow NULL? 
76HUEXTRRTEExtraction RateNumericGeneric Edit100 Allow NULL? 
77HUUCONTUOMUpdate Container TypeCharacterGeneric Edit10 Allow NULL? 
78HUCONTUOMContainer Type UomStringUDC (00 UM)20 Allow NULL? 
79HUUQTYLOADUpdate Quantity Per LoadCharacterGeneric Edit10 Allow NULL? 
80HUQTYLOADQuantity Per LoadNumericGeneric Edit154 Allow NULL? 
81HUULSTLOADUpdate Last LoadCharacterGeneric Edit10 Allow NULL? 
82HULSTLOADLast LoadCharacterGeneric Edit10 Allow NULL? 
83HUUEXTRCMPUpdate Extraction CompleteCharacterGeneric Edit10 Allow NULL? 
84HUEXTRCMPExtraction CompleteCharacterGeneric Edit10 Allow NULL? 
85HUUQUARANTUpdate Quarantined FlagCharacterGeneric Edit10 Allow NULL? 
86HUQUARANTQuarantined FlagCharacterGeneric Edit10 Allow NULL? 
87HUUGROW01Update Grower Attribute 01CharacterGeneric Edit10 Allow NULL? 
88HUGROW01Grower Attribute 01StringUDC (40G 01)30 Allow NULL? 
89HUUGROW02Update Grower Attribute 02CharacterGeneric Edit10 Allow NULL? 
90HUGROW02Grower Attribute 02StringUDC (40G 02)30 Allow NULL? 
91HUUGROW03Update Grower Attribute 03CharacterGeneric Edit10 Allow NULL? 
92HUGROW03Grower Attribute 03StringUDC (40G 03)30 Allow NULL? 
93HUUGROW04Update Grower Attribute 04CharacterGeneric Edit10 Allow NULL? 
94HUGROW04Grower Attribute 04StringUDC (40G 04)30 Allow NULL? 
95HUUGROW05Update Grower Attribute 05CharacterGeneric Edit10 Allow NULL? 
96HUGROW05Grower Attribute 05StringUDC (40G 05)30 Allow NULL? 
97HUUGROW06Update Grower Attribute 06CharacterGeneric Edit10 Allow NULL? 
98HUGROW06Grower Attribute 06StringUDC (40G 06)80 Allow NULL? 
99HUUGROW07Update Grower Attribute 07CharacterGeneric Edit10 Allow NULL? 
100HUGROW07Grower Attribute 07StringUDC (40G 07)80 Allow NULL? 
101HUUGROW08Update Grower Attribute 08CharacterGeneric Edit10 Allow NULL? 
102HUGROW08Grower Attribute 08StringUDC (40G 08)80 Allow NULL? 
103HUUGROW09Update Grower Attribute 09CharacterGeneric Edit10 Allow NULL? 
104HUGROW09Grower Attribute 09StringUDC (40G 09)80 Allow NULL? 
105HUUGROW10Update Grower Attribute 10CharacterGeneric Edit10 Allow NULL? 
106HUGROW10Grower Attribute 10StringUDC (40G 10)80 Allow NULL? 
107HUUGROW11Update Grower Attribute 11CharacterGeneric Edit10 Allow NULL? 
108HUGROW11Grower Attribute 11StringUDC (40G 11)100 Allow NULL? 
109HUUGROW12Update Grower Attribute 12CharacterGeneric Edit10 Allow NULL? 
110HUGROW12Grower Attribute 12StringUDC (40G 12)100 Allow NULL? 
111HUUGROW13Update Grower Attribute 13CharacterGeneric Edit10 Allow NULL? 
112HUGROW13Grower Attribute 13StringUDC (40G 13)100 Allow NULL? 
113HUUGROW14Update Grower Attribute 14CharacterGeneric Edit10 Allow NULL? 
114HUGROW14Grower Attribute 14StringUDC (40G 14)100 Allow NULL? 
115HUUGROW15Update Grower Attribute 15CharacterGeneric Edit10 Allow NULL? 
116HUGROW15Grower Attribute 15StringUDC (40G 15)100 Allow NULL? 
117HUUUGDAT01Update Grower Date 01CharacterGeneric Edit10 Allow NULL? 
118HUUGDATE01Date - Grower 01JDE UTimeGeneric Edit110
119HUUUGDAT02Update Grower Date 02CharacterGeneric Edit10 Allow NULL? 
120HUUGDATE02Date - Grower 02JDE UTimeGeneric Edit110
121HUUUGDAT03Update Grower Date 03CharacterGeneric Edit10 Allow NULL? 
122HUUGDATE03Date - Grower 03JDE UTimeGeneric Edit110
123HUUUGDAT04Update Grower Date 04CharacterGeneric Edit10 Allow NULL? 
124HUUGDATE04Date - Grower 04JDE UTimeGeneric Edit110
125HUUUGDAT05Update Grower Date 05CharacterGeneric Edit10 Allow NULL? 
126HUUGDATE05Date - Grower 05JDE UTimeGeneric Edit110
127HUUUGDAT06Update Grower Date 06CharacterGeneric Edit10 Allow NULL? 
128HUUGDATE06Date - Grower 06JDE UTimeGeneric Edit110
129HUUUGDAT07Update Grower Date 07CharacterGeneric Edit10 Allow NULL? 
130HUUGDATE07Date - Grower 07JDE UTimeGeneric Edit110
131HUUUGDAT08Update Grower Date 08CharacterGeneric Edit10 Allow NULL? 
132HUUGDATE08Date - Grower 08JDE UTimeGeneric Edit110
133HUUGNUM01Update Grower Numeric 01CharacterGeneric Edit10 Allow NULL? 
134HUGNUM01Grower Numeric 01NumericGeneric Edit157 Allow NULL? 
135HUUGNUM02Update Grower Numeric 02CharacterGeneric Edit10 Allow NULL? 
136HUGNUM02Grower Numeric 02NumericGeneric Edit157 Allow NULL? 
137HUUGNUM03Update Grower Numeric 03CharacterGeneric Edit10 Allow NULL? 
138HUGNUM03Grower Numeric 03NumericGeneric Edit157 Allow NULL? 
139HUUGNUM04Update Grower Numeric 04CharacterGeneric Edit10 Allow NULL? 
140HUGNUM04Grower Numeric 04NumericGeneric Edit157 Allow NULL? 
141HUUGNUM05Update Grower Numeric 05CharacterGeneric Edit10 Allow NULL? 
142HUGNUM05Grower Numeric 05NumericGeneric Edit157 Allow NULL? 
143HUUGNUM06Update Grower Numeric 06CharacterGeneric Edit10 Allow NULL? 
144HUGNUM06Grower Numeric 06NumericGeneric Edit157 Allow NULL? 
145HUUCGROW01Update Grower Checkbox 01CharacterGeneric Edit10 Allow NULL? 
146HUCGROW01Grower Checkbox 01CharacterGeneric Edit10 Allow NULL? 
147HUUCGROW02Update Grower Checkbox 02CharacterGeneric Edit10 Allow NULL? 
148HUCGROW02Grower Checkbox 02CharacterGeneric Edit10 Allow NULL? 
149HUUCGROW03Update Grower Checkbox 03CharacterGeneric Edit10 Allow NULL? 
150HUCGROW03Grower Checkbox 03CharacterGeneric Edit10 Allow NULL? 
151HUUCGROW04Update Grower Checkbox 04CharacterGeneric Edit10 Allow NULL? 
152HUCGROW04Grower Checkbox 04CharacterGeneric Edit10 Allow NULL? 
153HUUCGROW05Update Grower Checkbox 05CharacterGeneric Edit10 Allow NULL? 
154HUCGROW05Grower Checkbox 05CharacterGeneric Edit10 Allow NULL? 
155HUUGPRCUpdate Default PriceCharacterGeneric Edit10 Allow NULL? 
156HUGPRCGrower Default PriceNumericGeneric Edit154 Allow NULL? 
157HUUAN8VUpdate Supplier NumberCharacterGeneric Edit10 Allow NULL? 
158HUAN8VAddress Number - SupplierNumericGeneric Edit80 Allow NULL? 
159HUUPTMATNMUpdate Maturity Calculation Name FlagCharacterGeneric Edit10 Allow NULL? 
160HUMATCALIDMaturity Calculation IDIntegerGeneric Edit110 Allow NULL? 
161HURECALMATRecalculate Maturity Date FlagCharacterGeneric Edit10 Allow NULL? 
162HUURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
163HUURDTUser Reserved DateDateGeneric Edit60
164HUURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
165HUURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
166HUURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
167HUTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
168HUUSERUser IDStringGeneric Edit100 Allow NULL? 
169HUPIDProgram IDStringGeneric Edit100 Allow NULL? 
170HUJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
171HUUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110

TOP920 | 40G | F40G0300 INDEXES

NumberDescription
1UpdateProfileID (Primary/Unique)
ElementAliasDescriptionSequence
1HRUPIDHarvest Update Profile IDAscending