	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	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
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

67 COLUMNS | 3 INDEXES | 812 | 40G | F40G150 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
40G: Grower Management
1	812	F40G150	CP	67	3	Crush and Purchase Report Details	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 CPWVID, CPWTNUM, CPWASDT, CPITM, CPBLACT, CPMATYP, CPMCU, CPWCFGID, CPTPCD, CPSPAFLG, CPBLUID, CPBLSCD2, CPHARPER, CPHARSFX, CPVARID, CPVARCODE, CPVARLNAME, CPGDISTR, CPAN8V, CPPURCHCAT, CPCRPRDTL, CPRESELL, CPREPURCH, CPEXTCRUSH, CPCRUSHSVC, CPQTRC, CPWVUM, CPPURERQ, CPNMFRVAL, CPAN8, CPSPASPR, CPUOM, CPCDQTRC, CPCDWVUM, CPCDNFRVAL, CPPDQTRC, CPPDWVUM, CPPDPRQTRC, CPNONRRQTY, CPPURENRRQ, CPUPRC, CPUOM3, CPAMIN, CPAMAX, CPADJUPRC, CPALQTRG, CPALMIN, CPALMAX, CPAREC, CPAPTD, CPPDFRVAL, CPDSTLMRQ, CPDMWVUM, CPPUREDMRQ, CPDMPDAREC, CPDMPDAPDT, CPDMPDRVAL, CPURCD, CPURDT, CPURRF, CPURAT, CPURAB, CPPID, CPTORG, CPUSER, CPMKEY, CPUUPMJ FROM F40G150

TOP 812 | 40G | F40G150 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	CPWVID	Vessel ID	Numeric	Generic Edit	8	0	Allow NULL?
2	CPWTNUM	Weigh Tag Number	String	Generic Edit	30	0	Allow NULL?
3	CPWASDT	Actual Start Date	JDE UTime	Generic Edit	11	0
4	CPITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
5	CPBLACT	Blend Not Active	Character	Generic Edit	1	0	Allow NULL?
6	CPMATYP	Material Type Code	String	Generic Edit	4	0	Allow NULL?
7	CPMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
8	CPWCFGID	Configured Operation ID	Integer	Generic Edit	11	0	Allow NULL?
9	CPTPCD	Third Party Code	Character	Generic Edit	1	0	Allow NULL?
10	CPSPAFLG	Special Assessment Flag	Character	Generic Edit	1	0	Allow NULL?
11	CPBLUID	Block Identifier	Numeric	Generic Edit	8	0	Allow NULL?
12	CPBLSCD2	Block Code	String	Generic Edit	10	0	Allow NULL?
13	CPHARPER	Harvest Period	String	Generic Edit	6	0	Allow NULL?
14	CPHARSFX	Harvest Suffix	String	Generic Edit	10	0	Allow NULL?
15	CPVARID	Variety ID	Numeric	Generic Edit	4	0	Allow NULL?
16	CPVARCODE	Code - Variety	String	Generic Edit	5	0	Allow NULL?
17	CPVARLNAME	Name - Variety Long	String	Generic Edit	30	0	Allow NULL?
18	CPGDISTR	Growing District	String	UDC (40G GD)	10	0	Allow NULL?
19	CPAN8V	Address Number - Supplier	Numeric	Generic Edit	8	0	Allow NULL?
20	CPPURCHCAT	Purchase Category	Character	UDC (40G PC)	1	0	Allow NULL?
21	CPCRPRDTL	Crush and Purchase Detail	Character	Generic Edit	1	0	Allow NULL?
22	CPRESELL	Resell	Character	Generic Edit	1	0	Allow NULL?
23	CPREPURCH	Repurchase	Character	Generic Edit	1	0	Allow NULL?
24	CPEXTCRUSH	External Crush	Character	Generic Edit	1	0	Allow NULL?
25	CPCRUSHSVC	Crush Service	Character	Generic Edit	1	0	Allow NULL?
26	CPQTRC	Quantity - Received	Numeric	Generic Edit	15	4	Allow NULL?
27	CPWVUM	Quantity UOM	String	UDC (31B UM)	3	0	Allow NULL?
28	CPPURERQ	Pure Receipt Quantity	Numeric	Generic Edit	15	4	Allow NULL?
29	CPNMFRVAL	Numeric Result Value	Numeric	Generic Edit	15	2	Allow NULL?
30	CPAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
31	CPSPASPR	Special Assessment Price	Numeric	Generic Edit	15	4	Allow NULL?
32	CPUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
33	CPCDQTRC	Crush Detail Receipt Quantity	Numeric	Generic Edit	15	4	Allow NULL?
34	CPCDWVUM	Crush Detail Quantity UOM	String	UDC (31B UM)	3	0	Allow NULL?
35	CPCDNFRVAL	Crush Detail Numeric Result Value	Numeric	Generic Edit	15	2	Allow NULL?
36	CPPDQTRC	Purchase Detail Receipt Quantity	Numeric	Generic Edit	15	4	Allow NULL?
37	CPPDWVUM	Purchase Detail Quantity UOM	String	UDC (31B UM)	3	0	Allow NULL?
38	CPPDPRQTRC	Purchase Detail Pure Receipt Quantity	Numeric	Generic Edit	15	4	Allow NULL?
39	CPNONRRQTY	Non-Related Receipt Quantity	Numeric	Generic Edit	15	4	Allow NULL?
40	CPPURENRRQ	Pure Non-Related Receipt Quantity	Numeric	Generic Edit	15	4	Allow NULL?
41	CPUPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
42	CPUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
43	CPAMIN	Allowed Minimum Value	String	Generic Edit	15	0	Allow NULL?
44	CPAMAX	Allowed Maximum Value	String	Generic Edit	15	0	Allow NULL?
45	CPADJUPRC	Total Adjustment Amount Per Unit	Numeric	Generic Edit	15	4	Allow NULL?
46	CPALQTRG	Adjustment Limit - Target Value	String	Generic Edit	15	0	Allow NULL?
47	CPALMIN	Adjustment Limit - Minimum Value	String	Generic Edit	15	0	Allow NULL?
48	CPALMAX	Adjustment Limit - Maximum Value	String	Generic Edit	15	0	Allow NULL?
49	CPAREC	Amount - Received	Numeric	Generic Edit	15	2	Allow NULL?
50	CPAPTD	Amount - Paid to Date	Numeric	Generic Edit	15	2	Allow NULL?
51	CPPDFRVAL	Purchase Detail Numeric Result Value	Numeric	Generic Edit	15	2	Allow NULL?
52	CPDSTLMRQ	Distilling Material Receipt Quantity	Numeric	Generic Edit	15	4	Allow NULL?
53	CPDMWVUM	Distilling Material Quantity UOM	String	Generic Edit	3	0	Allow NULL?
54	CPPUREDMRQ	Pure Distilling Material Receipt Qty	Numeric	Generic Edit	15	4	Allow NULL?
55	CPDMPDAREC	Distilling Material Extend Amt Received	Numeric	Generic Edit	15	2	Allow NULL?
56	CPDMPDAPDT	Distilling Material Amount Paid To Date	Numeric	Generic Edit	15	2	Allow NULL?
57	CPDMPDRVAL	Distilling Material Result Value	Numeric	Generic Edit	15	2	Allow NULL?
58	CPURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
59	CPURDT	User Reserved Date	Date	Generic Edit	6	0
60	CPURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
61	CPURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
62	CPURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
63	CPPID	Program ID	String	Generic Edit	10	0	Allow NULL?
64	CPTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
65	CPUSER	User ID	String	Generic Edit	10	0	Allow NULL?
66	CPMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
67	CPUUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0

TOP 812 | 40G | F40G150 INDEXES

Number

Description

VesselID (Primary/Unique)

Element	Alias	Description	Sequence
1	WVID	Vessel ID	Ascending

VarietyLongName GrowingDist +

Element	Alias	Description	Sequence
1	VARLNAME	Name - Variety Long	Ascending
2	GDISTR	Growing District	Ascending
3	WVID	Vessel ID	Ascending

VarietyID GrowingDist +

Element	Alias	Description	Sequence
1	VARID	Variety ID	Ascending
2	GDISTR	Growing District	Ascending
3	UPRC	Amount - Price per Unit	Ascending
4	AMIN	Allowed Minimum Value	Ascending
5	AMAX	Allowed Maximum Value	Ascending
6	ADJUPRC	Total Adjustment Amount Per Unit	Ascending
7	ALQTRG	Adjustment Limit - Target Value	Ascending
8	ALMIN	Adjustment Limit - Minimum Value	Ascending
9	ALMAX	Adjustment Limit - Maximum Value	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

67 COLUMNS | 3 INDEXES | 812 | 40G | F40G150 TABLE

TOP 812 | 40G | F40G150 COLUMNS

TOP 812 | 40G | F40G150 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

67 COLUMNS | 3 INDEXES | 812 | 40G | F40G150 TABLE

TOP812 | 40G | F40G150 COLUMNS

TOP812 | 40G | F40G150 INDEXES

TOP 812 | 40G | F40G150 COLUMNS

TOP 812 | 40G | F40G150 INDEXES