	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

87 COLUMNS | 3 INDEXES | 920 | 43C | F43C11 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
43C: Contracts
1	920	F43C11	CD	87	3	Contract Detail	Files	43C: Contracts

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 CDCNTRTID, CDCNTRTDID, CDBLUID, CDMCU, CDITM, CDLITM, CDAITM, CDCNTRTSD, CDCNTRTED, CDRNWSTE, CDCNTRTDF, CDCMDCDE, CDCNTRTQTY, CDUOM, CDQCONTROL, CDMINQTY, CDMAXQTY, CDPRICEAPP, CDCNTRTPT, CDUOM3, CDPRLEVL, CDCNTRPRG, CDPRICEOVR, CDOVRCOMM, CDMINPRICE, CDMAXPRICE, CDMEMPRICE, CDPRICELVL, CDPTC, CDASN, CDWVID, CDELADV, CDFLPD, CDCNTRAB01, CDCNTRAB02, CDCNTRAB03, CDCNTRAB04, CDCNTRAB05, CDCNTRAB06, CDCNTRAB07, CDCNTRAB08, CDCNTRAB09, CDCNTRAB10, CDCNTRAB11, CDCNTRAB12, CDCNTRT01, CDCNTRT02, CDCNTRT03, CDCNTRT04, CDCNTRT05, CDCNTRT06, CDCNTRT07, CDCNTRT08, CDCNTRT09, CDCNTRT10, CDCNTRT11, CDCNTRT12, CDCNTRT13, CDCNTRT14, CDCNTRT15, CDCNTRTDT1, CDCNTRTDT2, CDCNTRTDT3, CDCNTRTDT4, CDCNTRTDT5, CDCNTRTDT6, CDCNTRPT01, CDCNTRPT02, CDCNTRPT03, CDCNTRPT04, CDCNTRPT05, CDCNTRPT06, CDURCD, CDURDT, CDURAT, CDURAB, CDURRF, CDTORG, CDUSER, CDPID, CDJOBN, CDUUPMJ, CDPOPPOOL, CDGEQTYP, CDGEQPCT, CDPOPASN, CDPOPPTC FROM F43C11

TOP 920 | 43C | F43C11 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	CDCNTRTID	Contract ID	Numeric	Generic Edit	8	0	Allow NULL?
2	CDCNTRTDID	Contract Detail ID	Numeric	Generic Edit	15	0	Allow NULL?
3	CDBLUID	Block Identifier	Numeric	Generic Edit	8	0	Allow NULL?
4	CDMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
5	CDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
6	CDLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
7	CDAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
8	CDCNTRTSD	Start Date	JDE UTime	Generic Edit	11	0
9	CDCNTRTED	End Date	JDE UTime	Generic Edit	11	0
10	CDRNWSTE	Renew State	String	UDC (43C RS)	3	0	Allow NULL?
11	CDCNTRTDF	Delivery Form	String	UDC (43C DF)	3	0	Allow NULL?
12	CDCMDCDE	Commodity Code	String	Generic Edit	15	0	Allow NULL?
13	CDCNTRTQTY	Contracted Quantity	Numeric	Generic Edit	15	0	Allow NULL?
14	CDUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
15	CDQCONTROL	Disallow Over Receipt	Character	Generic Edit	1	0	Allow NULL?
16	CDMINQTY	Minimum Quantity	Numeric	Generic Edit	15	0	Allow NULL?
17	CDMAXQTY	Maximum Quantity	Numeric	Generic Edit	15	0	Allow NULL?
18	CDPRICEAPP	Price Approved	Character	Generic Edit	1	0	Allow NULL?
19	CDCNTRTPT	Price Type	String	UDC (43C PT)	3	0	Allow NULL?
20	CDUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
21	CDPRLEVL	Price Level	String	UDC (45 PL)	10	0	Allow NULL?
22	CDCNTRPRG	Price Group	String	UDC (43C PG)	8	0	Allow NULL?
23	CDPRICEOVR	Price Override	Numeric	Generic Edit	15	4	Allow NULL?
24	CDOVRCOMM	Price Override Comment	String	Generic Edit	30	0	Allow NULL?
25	CDMINPRICE	Minimum Price	Numeric	Generic Edit	15	4	Allow NULL?
26	CDMAXPRICE	Maximum Price	Numeric	Generic Edit	15	4	Allow NULL?
27	CDMEMPRICE	Memo Price	Numeric	Generic Edit	15	4	Allow NULL?
28	CDPRICELVL	Memo Price Level	String	UDC (45 PL)	10	0	Allow NULL?
29	CDPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
30	CDASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
31	CDWVID	Vessel ID	Numeric	Generic Edit	8	0	Allow NULL?
32	CDELADV	Eligible For Advance	Character	Generic Edit	1	0	Allow NULL?
33	CDFLPD	Fully Paid	Character	Generic Edit	1	0	Allow NULL?
34	CDCNTRAB01	Contract Address Book Number 01	Numeric	Generic Edit	8	0	Allow NULL?
35	CDCNTRAB02	Contract Address Book Number 02	Numeric	Generic Edit	8	0	Allow NULL?
36	CDCNTRAB03	Contract Address Book Number 03	Numeric	Generic Edit	8	0	Allow NULL?
37	CDCNTRAB04	Contract Address Book Number 04	Numeric	Generic Edit	8	0	Allow NULL?
38	CDCNTRAB05	Contract Address Book Number 05	Numeric	Generic Edit	8	0	Allow NULL?
39	CDCNTRAB06	Contract Address Book Number 06	Numeric	Generic Edit	8	0	Allow NULL?
40	CDCNTRAB07	Contract Address Book Number 07	Numeric	Generic Edit	8	0	Allow NULL?
41	CDCNTRAB08	Contract Address Book Number 08	Numeric	Generic Edit	8	0	Allow NULL?
42	CDCNTRAB09	Contract Address Book Number 09	Numeric	Generic Edit	8	0	Allow NULL?
43	CDCNTRAB10	Contract Address Book Number 10	Numeric	Generic Edit	8	0	Allow NULL?
44	CDCNTRAB11	Contract Address Book Number 11	Numeric	Generic Edit	8	0	Allow NULL?
45	CDCNTRAB12	Contract Address Book Number 12	Numeric	Generic Edit	8	0	Allow NULL?
46	CDCNTRT01	Contract Code 01	String	UDC (43C 01)	3	0	Allow NULL?
47	CDCNTRT02	Contract Code 02	String	UDC (43C 02)	3	0	Allow NULL?
48	CDCNTRT03	Contract Code 03	String	UDC (43C 03)	3	0	Allow NULL?
49	CDCNTRT04	Contract Code 04	String	UDC (43C 04)	3	0	Allow NULL?
50	CDCNTRT05	Contract Code 05	String	UDC (43C 05)	3	0	Allow NULL?
51	CDCNTRT06	Contract Code 06	String	UDC (43C 06)	8	0	Allow NULL?
52	CDCNTRT07	Contract Code 07	String	UDC (43C 07)	8	0	Allow NULL?
53	CDCNTRT08	Contract Code 08	String	UDC (43C 08)	8	0	Allow NULL?
54	CDCNTRT09	Contract Code 09	String	UDC (43C 09)	8	0	Allow NULL?
55	CDCNTRT10	Contract Code 10	String	UDC (43C 10)	8	0	Allow NULL?
56	CDCNTRT11	Contract Code 11	String	UDC (43C 11)	10	0	Allow NULL?
57	CDCNTRT12	Contract Code 12	String	UDC (43C 12)	10	0	Allow NULL?
58	CDCNTRT13	Contract Code 13	String	UDC (43C 13)	10	0	Allow NULL?
59	CDCNTRT14	Contract Code 14	String	UDC (43C 14)	10	0	Allow NULL?
60	CDCNTRT15	Contract Code 15	String	UDC (43C 15)	10	0	Allow NULL?
61	CDCNTRTDT1	Contract Date 01	Date	Generic Edit	6	0
62	CDCNTRTDT2	Contract Date 02	Date	Generic Edit	6	0
63	CDCNTRTDT3	Contract Date 03	Date	Generic Edit	6	0
64	CDCNTRTDT4	Contract Date 04	Date	Generic Edit	6	0
65	CDCNTRTDT5	Contract Date 05	Date	Generic Edit	6	0
66	CDCNTRTDT6	Contract Date 06	Date	Generic Edit	6	0
67	CDCNTRPT01	Contract Property 01	Character	Generic Edit	1	0	Allow NULL?
68	CDCNTRPT02	Contract Property 02	Character	Generic Edit	1	0	Allow NULL?
69	CDCNTRPT03	Contract Property 03	Character	Generic Edit	1	0	Allow NULL?
70	CDCNTRPT04	Contract Property 04	Character	Generic Edit	1	0	Allow NULL?
71	CDCNTRPT05	Contract Property 05	Character	Generic Edit	1	0	Allow NULL?
72	CDCNTRPT06	Contract Property 06	Character	Generic Edit	1	0	Allow NULL?
73	CDURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
74	CDURDT	User Reserved Date	Date	Generic Edit	6	0
75	CDURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
76	CDURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
77	CDURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
78	CDTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
79	CDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
80	CDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
81	CDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
82	CDUUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
83	CDPOPPOOL	Pay On Proceeds Pool	String	UDC (43C PP)	8	0	Allow NULL?
84	CDGEQTYP	Grower Equity Type	String	UDC (43C ET)	8	0	Allow NULL?
85	CDGEQPCT	Grower Equity Percent	Numeric	Generic Edit	9	6	Allow NULL?
86	CDPOPASN	Pay On Proceeds Pricing Schedule	String	UDC (40 AS)	8	0	Allow NULL?
87	CDPOPPTC	Pay On Proceeds Payment Terms	String	Generic Edit	3	0	Allow NULL?

TOP 920 | 43C | F43C11 INDEXES

Number

Description

ContractID Contract DetailID (Primary/Unique)

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

ContractID BlockID

Element	Alias	Description	Sequence
1	BLUID	Block Identifier	Ascending
2	CNTRTID	Contract ID	Ascending

HarvestID

Element	Alias	Description	Sequence
1	WVID	Vessel ID	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

87 COLUMNS | 3 INDEXES | 920 | 43C | F43C11 TABLE

TOP 920 | 43C | F43C11 COLUMNS

TOP 920 | 43C | F43C11 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

87 COLUMNS | 3 INDEXES | 920 | 43C | F43C11 TABLE

TOP920 | 43C | F43C11 COLUMNS

TOP920 | 43C | F43C11 INDEXES

TOP 920 | 43C | F43C11 COLUMNS

TOP 920 | 43C | F43C11 INDEXES