	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

125 COLUMNS | 5 INDEXES | 812 | 40G | F40G03 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
40G: Grower Management
1	812	F40G03	GH	125	5	Grower Harvest	Files	40G: 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 GHWVID, GHBLSCD2, GHHARPER, GHHARSFX, GHHARNAME, GHHARSTS, GHBLUID, GHGRCMPCD, GHAN8GR, GHAN8BR, GHAN8CR, GHCURQLTY, GHTARQLTY, GHCSUPPLY, GHUPLNMAT, GHUCLCMAT, GHUCURDAT, GHCURREST, GHPLNEST, GHSCHQTY, GHRECVQTY, GHUCUTDAT, GHGEOCST, GHGOAID, GHGOAREA, GHAPPID, GHAPPLLAT, GHGREGION, GHGDISTR, GHADDS, GHCOUN, GHVARID, GHVARCODE, GHGRSAREA, GHPLTAREA, GHUPLTDAT, GHMATYP, GHSOILTYP, GHWATERTY, GHIVOL, GHPRUNEMT, GHCLONE, GHROOTSTK, GHROWSPC, GHPLTSPC, GHNOP, GHEXTRRTE, GHCONTUOM, GHQTYLOAD, GHHARVSD, GHHARVED, GHLSTLOAD, GHEXTRCMP, GHQUARANT, GHAN8V, GHAN8FARM, GHFARMCODE, GHFARMTYPE, GHCNTRTID, GHCNTRTDID, GHGPRC, GHHACOST, GHCOSTQTY, GHCSTAREA, GHOMCU, GHSITEC, GHSITEP, GHQTYUOM, GHAREAUOM, GHVOLUM, GHUOM4, GHCRCD, GHWLOTN, GHGROW01, GHGROW02, GHGROW03, GHGROW04, GHGROW05, GHGROW06, GHGROW07, GHGROW08, GHGROW09, GHGROW10, GHGROW11, GHGROW12, GHGROW13, GHGROW14, GHGROW15, GHGROW16, GHCGROW01, GHCGROW02, GHCGROW03, GHCGROW04, GHCGROW05, GHUGDATE01, GHUGDATE02, GHUGDATE03, GHUGDATE04, GHUGDATE05, GHUGDATE06, GHUGDATE07, GHUGDATE08, GHGNUM01, GHGNUM02, GHGNUM03, GHGNUM04, GHGNUM05, GHGNUM06, GHGNUM07, GHDOCO, GHDCTO, GHSFXO, GHKCOO, GHLNID, GHURCD, GHURDT, GHURRF, GHURAB, GHURAT, GHUSER, GHPID, GHJOBN, GHTORG, GHUUPMJ, GHUCEF FROM F40G03

TOP 812 | 40G | F40G03 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	GHWVID	Vessel ID	Numeric	Generic Edit	8	0	Allow NULL?
2	GHBLSCD2	Block Code	String	Generic Edit	10	0	Allow NULL?
3	GHHARPER	Harvest Period	String	Generic Edit	6	0	Allow NULL?
4	GHHARSFX	Harvest Suffix	String	Generic Edit	10	0	Allow NULL?
5	GHHARNAME	Harvest Name	String	Generic Edit	40	0	Allow NULL?
6	GHHARSTS	Harvest Status Code	Character	UDC (40G HT)	1	0	Allow NULL?
7	GHBLUID	Block Identifier	Numeric	Generic Edit	8	0	Allow NULL?
8	GHGRCMPCD	Grower Composition Code	String	UDC (40G GC)	10	0	Allow NULL?
9	GHAN8GR	Grower Representative	Numeric	Generic Edit	8	0	Allow NULL?
10	GHAN8BR	Blend Representative	Numeric	Generic Edit	8	0	Allow NULL?
11	GHAN8CR	Contract Representative	Numeric	Generic Edit	8	0	Allow NULL?
12	GHCURQLTY	Current Quality	Character	UDC (40G QL)	1	0	Allow NULL?
13	GHTARQLTY	Target Quality	Character	UDC (40G QL)	1	0	Allow NULL?
14	GHCSUPPLY	Confidence Of Supply	Numeric	Generic Edit	7	0	Allow NULL?
15	GHUPLNMAT	Date - Planned Maturity	JDE UTime	Generic Edit	11	0
16	GHUCLCMAT	Date - Calculated Maturity	JDE UTime	Generic Edit	11	0
17	GHUCURDAT	Current Estimate Date	JDE UTime	Generic Edit	11	0
18	GHCURREST	Current Estimate	Numeric	Generic Edit	15	0	Allow NULL?
19	GHPLNEST	Planned Estimate	Numeric	Generic Edit	15	4	Allow NULL?
20	GHSCHQTY	Scheduled Quantity	Numeric	Generic Edit	15	4	Allow NULL?
21	GHRECVQTY	Received Quantity	Numeric	Generic Edit	15	4	Allow NULL?
22	GHUCUTDAT	Cut Date	JDE UTime	Generic Edit	11	0
23	GHGEOCST	Geographic ID	String	UDC (40G GI)	3	0	Allow NULL?
24	GHGOAID	Geographic Area ID	Numeric	Generic Edit	8	0	Allow NULL?
25	GHGOAREA	Code - Geographic Area	String	Generic Edit	4	0	Allow NULL?
26	GHAPPID	Appellation ID	Numeric	Generic Edit	8	0	Allow NULL?
27	GHAPPLLAT	Code - Appellation	String	Generic Edit	8	0	Allow NULL?
28	GHGREGION	Growing Region	String	UDC (40G GR)	10	0	Allow NULL?
29	GHGDISTR	Growing District	String	UDC (40G GD)	10	0	Allow NULL?
30	GHADDS	State	String	UDC (00 S)	3	0	Allow NULL?
31	GHCOUN	County	String	UDC (00 CT)	25	0	Allow NULL?
32	GHVARID	Variety ID	Numeric	Generic Edit	4	0	Allow NULL?
33	GHVARCODE	Code - Variety	String	Generic Edit	5	0	Allow NULL?
34	GHGRSAREA	Gross Area	Numeric	Generic Edit	10	0	Allow NULL?
35	GHPLTAREA	Planted Area	Numeric	Generic Edit	10	0	Allow NULL?
36	GHUPLTDAT	Planted Date	JDE UTime	Generic Edit	11	0
37	GHMATYP	Material Type Code	String	Generic Edit	4	0	Allow NULL?
38	GHSOILTYP	Soil Type	String	UDC (40G ST)	2	0	Allow NULL?
39	GHWATERTY	Irrigation Type	String	UDC (40G IT)	2	0	Allow NULL?
40	GHIVOL	Irrigation Volume	Numeric	Generic Edit	15	2	Allow NULL?
41	GHPRUNEMT	Pruning Method	String	UDC (40G PM)	2	0	Allow NULL?
42	GHCLONE	Clone	String	UDC (40G CL)	2	0	Allow NULL?
43	GHROOTSTK	Root Stock	String	UDC (40G RS)	2	0	Allow NULL?
44	GHROWSPC	Row Spacing	String	UDC (40G RW)	2	0	Allow NULL?
45	GHPLTSPC	Plant Spacing	String	UDC (40G PL)	2	0	Allow NULL?
46	GHNOP	Number of Plants	Numeric	Generic Edit	8	0	Allow NULL?
47	GHEXTRRTE	Extraction Rate	Numeric	Generic Edit	10	0	Allow NULL?
48	GHCONTUOM	Container Type Uom	String	UDC (00 UM)	2	0	Allow NULL?
49	GHQTYLOAD	Quantity Per Load	Numeric	Generic Edit	15	4	Allow NULL?
50	GHHARVSD	Harvest Start Date	JDE UTime	Generic Edit	11	0
51	GHHARVED	Harvest End Date	JDE UTime	Generic Edit	11	0
52	GHLSTLOAD	Last Load	Character	Generic Edit	1	0	Allow NULL?
53	GHEXTRCMP	Extraction Complete	Character	Generic Edit	1	0	Allow NULL?
54	GHQUARANT	Quarantined Flag	Character	Generic Edit	1	0	Allow NULL?
55	GHAN8V	Address Number - Supplier	Numeric	Generic Edit	8	0	Allow NULL?
56	GHAN8FARM	Farm Address Book Number	Numeric	Generic Edit	8	0	Allow NULL?
57	GHFARMCODE	Farm Code	String	Generic Edit	8	0	Allow NULL?
58	GHFARMTYPE	Farm Type	Character	UDC (40G FT)	1	0	Allow NULL?
59	GHCNTRTID	Contract ID	Numeric	Generic Edit	8	0	Allow NULL?
60	GHCNTRTDID	Contract Detail ID	Numeric	Generic Edit	15	0	Allow NULL?
61	GHGPRC	Grower Default Price	Numeric	Generic Edit	15	4	Allow NULL?
62	GHHACOST	Amount - Operational Cost Harvest	Numeric	Generic Edit	15	4	Allow NULL?
63	GHCOSTQTY	Amount - Cost Per Quantity Uom	Numeric	Generic Edit	15	4	Allow NULL?
64	GHCSTAREA	Amount - Cost Per Area Uom	Numeric	Generic Edit	15	4	Allow NULL?
65	GHOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
66	GHSITEC	Crush Site	String	Generic Edit	12	0	Allow NULL?
67	GHSITEP	Produced Site	String	Generic Edit	12	0	Allow NULL?
68	GHQTYUOM	Quantity Unit Of Measure	String	UDC (00 UM)	2	0	Allow NULL?
69	GHAREAUOM	Area Unit Of Measure	String	UDC (00 UM)	2	0	Allow NULL?
70	GHVOLUM	Volume Unit Of Measure	String	UDC (00 UM)	2	0	Allow NULL?
71	GHUOM4	Unit of Measure - Pricing	String	UDC (00 UM)	2	0	Allow NULL?
72	GHCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
73	GHWLOTN	Blend Lot Number	String	Generic Edit	30	0	Allow NULL?
74	GHGROW01	Grower Attribute 01	String	UDC (40G 01)	3	0	Allow NULL?
75	GHGROW02	Grower Attribute 02	String	UDC (40G 02)	3	0	Allow NULL?
76	GHGROW03	Grower Attribute 03	String	UDC (40G 03)	3	0	Allow NULL?
77	GHGROW04	Grower Attribute 04	String	UDC (40G 04)	3	0	Allow NULL?
78	GHGROW05	Grower Attribute 05	String	UDC (40G 05)	3	0	Allow NULL?
79	GHGROW06	Grower Attribute 06	String	UDC (40G 06)	8	0	Allow NULL?
80	GHGROW07	Grower Attribute 07	String	UDC (40G 07)	8	0	Allow NULL?
81	GHGROW08	Grower Attribute 08	String	UDC (40G 08)	8	0	Allow NULL?
82	GHGROW09	Grower Attribute 09	String	UDC (40G 09)	8	0	Allow NULL?
83	GHGROW10	Grower Attribute 10	String	UDC (40G 10)	8	0	Allow NULL?
84	GHGROW11	Grower Attribute 11	String	UDC (40G 11)	10	0	Allow NULL?
85	GHGROW12	Grower Attribute 12	String	UDC (40G 12)	10	0	Allow NULL?
86	GHGROW13	Grower Attribute 13	String	UDC (40G 13)	10	0	Allow NULL?
87	GHGROW14	Grower Attribute 14	String	UDC (40G 14)	10	0	Allow NULL?
88	GHGROW15	Grower Attribute 15	String	UDC (40G 15)	10	0	Allow NULL?
89	GHGROW16	Grower Attribute 16	String	UDC (40G 16)	10	0	Allow NULL?
90	GHCGROW01	Grower Checkbox 01	Character	Generic Edit	1	0	Allow NULL?
91	GHCGROW02	Grower Checkbox 02	Character	Generic Edit	1	0	Allow NULL?
92	GHCGROW03	Grower Checkbox 03	Character	Generic Edit	1	0	Allow NULL?
93	GHCGROW04	Grower Checkbox 04	Character	Generic Edit	1	0	Allow NULL?
94	GHCGROW05	Grower Checkbox 05	Character	Generic Edit	1	0	Allow NULL?
95	GHUGDATE01	Date - Grower 01	JDE UTime	Generic Edit	11	0
96	GHUGDATE02	Date - Grower 02	JDE UTime	Generic Edit	11	0
97	GHUGDATE03	Date - Grower 03	JDE UTime	Generic Edit	11	0
98	GHUGDATE04	Date - Grower 04	JDE UTime	Generic Edit	11	0
99	GHUGDATE05	Date - Grower 05	JDE UTime	Generic Edit	11	0
100	GHUGDATE06	Date - Grower 06	JDE UTime	Generic Edit	11	0
101	GHUGDATE07	Date - Grower 07	JDE UTime	Generic Edit	11	0
102	GHUGDATE08	Date - Grower 08	JDE UTime	Generic Edit	11	0
103	GHGNUM01	Grower Numeric 01	Numeric	Generic Edit	15	7	Allow NULL?
104	GHGNUM02	Grower Numeric 02	Numeric	Generic Edit	15	7	Allow NULL?
105	GHGNUM03	Grower Numeric 03	Numeric	Generic Edit	15	7	Allow NULL?
106	GHGNUM04	Grower Numeric 04	Numeric	Generic Edit	15	7	Allow NULL?
107	GHGNUM05	Grower Numeric 05	Numeric	Generic Edit	15	7	Allow NULL?
108	GHGNUM06	Grower Numeric 06	Numeric	Generic Edit	15	7	Allow NULL?
109	GHGNUM07	Grower Numeric 07	Numeric	Generic Edit	15	7	Allow NULL?
110	GHDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
111	GHDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
112	GHSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
113	GHKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
114	GHLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
115	GHURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
116	GHURDT	User Reserved Date	Date	Generic Edit	6	0
117	GHURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
118	GHURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
119	GHURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
120	GHUSER	User ID	String	Generic Edit	10	0	Allow NULL?
121	GHPID	Program ID	String	Generic Edit	10	0	Allow NULL?
122	GHJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
123	GHTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
124	GHUUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
125	GHUCEF	Use Continuous Estimates	Character	Generic Edit	1	0	Allow NULL?

TOP 812 | 40G | F40G03 INDEXES

Number

Description

WVID (Primary/Unique)

Element	Alias	Description	Sequence
1	WVID	Vessel ID	Ascending

BLSCD2 HARPER HARSFX

Element	Alias	Description	Sequence
1	BLSCD2	Block Code	Ascending
2	HARPER	Harvest Period	Ascending
3	HARSFX	Harvest Suffix	Ascending

GEOCST HARPER BLSCD2 HARSFX

Element	Alias	Description	Sequence
1	GEOCST	Geographic ID	Ascending
2	HARPER	Harvest Period	Ascending
3	BLSCD2	Block Code	Ascending
4	HARSFX	Harvest Suffix	Ascending

CNTRTID CNTRTDID

Element	Alias	Description	Sequence
1	CNTRTID	Contract ID	Ascending
2	CNTRTDID	Contract Detail ID	Ascending

BLUID HARPER HARSFX

Element	Alias	Description	Sequence
1	BLUID	Block Identifier	Ascending
2	HARPER	Harvest Period	Ascending
3	HARSFX	Harvest Suffix	Ascending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

125 COLUMNS | 5 INDEXES | 812 | 40G | F40G03 TABLE

TOP 812 | 40G | F40G03 COLUMNS

TOP 812 | 40G | F40G03 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

125 COLUMNS | 5 INDEXES | 812 | 40G | F40G03 TABLE

TOP812 | 40G | F40G03 COLUMNS

TOP812 | 40G | F40G03 INDEXES

TOP 812 | 40G | F40G03 COLUMNS

TOP 812 | 40G | F40G03 INDEXES