	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

132 COLUMNS | 7 INDEXES | 920 | 17 | F1721 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
17: Customer Service Management
1	920	F1721	CD	132	7	Contract Detail	Master Files	17: Customer Service Management	Business Data

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 CDDOCO, CDDCTO, CDKCOO, CDCOCH, CDLNID, CDDOC1, CDDCT1, CDSKCO, CDOSFX, CDLINN, CDDL01, CDCSDT, CDCDTE, CDCHD, CDCHGST, CDMCUS, CDAID, CDMCU, CDOBJ, CDSUB, CDSBL, CDSBLT, CDCO, CDGLC, CDGLCCV, CDGLCNC, CDLNTY, CDAN8, CDSHAN, CDANOB, CDLANO, CDPEFJ, CDEXR1, CDTXA1, CDTAX1, CDPRODF, CDPRODM, CDNUMB, CDITM, CDLITM, CDAITM, CDLOTN, CDLOTT, CDSERP, CDCOVGR, CDMMCU, CDPRODC, CDCNDJ, CDCNRC, CDCDUR, CDDAYSC, CDBILLF, CDYN, CDADAR, CDBDUR, CDBLFC, CDDOM, CDBUM, CDBTFR, CDBTDT, CDRNWDT, CDDGL, CDUOM4, CDUM, CDU, CDUP, CDFUPC, CDAMTCD, CDAMTCF, CDCANDM, CDCANFN, CDRRBA, CDFRBA, CDAEXP, CDFEA, CDTOTD, CDFOAG, CDDSCT, CDCDSA, CDSTAM, CDATXN, CDATXA, CDAA1, CDAA2, CDUREC, CDUOPN, CDAREC, CDFREC, CDAOPN, CDFOPN, CDMXMET1, CDMXMET2, CDMXMET3, CDDAILY, CDPTC, CDRYIN, CDSSDJ, CDBSUSP, CDCD01, CDCD02, CDCD03, CDCD04, CDCD05, CDRNFLG, CDBSWAR, CDBTF05, CDWRLFL, CDCRR, CDCRCD, CDCRCF, CDCRRD, CDCRRM, CDDSFT, CDDSPC, CDUOM2, CDVR01, CDURCD, CDURDT, CDURAT, CDURAB, CDURRF, CDCRTU, CDPID, CDJOBN, CDUSER, CDUPMJ, CDUPMT, CDASN1, CDASN2, CDPCPR, CDAN8PB, CDADPRF FROM F1721

TOP 920 | 17 | F1721 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	CDDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	CDDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
3	CDKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
4	CDCOCH	Contract Change Number	String	Generic Edit	3	0	Allow NULL?
5	CDLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
6	CDDOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
7	CDDCT1	Close Document Type	String	UDC (00 DT)	2	0	Allow NULL?
8	CDSKCO	Document Company (Sales Order)	String	Generic Edit	5	0	Allow NULL?
9	CDOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
10	CDLINN	Line Number	Numeric	Generic Edit	7	3	Allow NULL?
11	CDDL01	Description	String	Generic Edit	30	0	Allow NULL?
12	CDCSDT	Contract Start Date	Date	Generic Edit	6	0
13	CDCDTE	Contract Completion Date	Date	Generic Edit	6	0
14	CDCHD	Change Date	Date	Generic Edit	6	0
15	CDCHGST	Change Status	String	UDC (17 CH)	2	0	Allow NULL?
16	CDMCUS	Business Unit - Subsequent	String	Generic Edit	12	0	Allow NULL?
17	CDAID	Account ID	String	Generic Edit	8	0	Allow NULL?
18	CDMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
19	CDOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
20	CDSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
21	CDSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
22	CDSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
23	CDCO	Company	String	Generic Edit	5	0	Allow NULL?
24	CDGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
25	CDGLCCV	Category - G/L Covered	String	UDC (41 9)	4	0	Allow NULL?
26	CDGLCNC	Category - G/L Non-Covered	String	UDC (41 9)	4	0	Allow NULL?
27	CDLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
28	CDAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
29	CDSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
30	CDANOB	Address Number - Owner Billing	Numeric	Generic Edit	8	0	Allow NULL?
31	CDLANO	Address Number - Lessor/Rentor/Mortgagor	Numeric	Generic Edit	8	0	Allow NULL?
32	CDPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
33	CDEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
34	CDTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
35	CDTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
36	CDPRODF	Product Family	String	UDC (17 PA)	8	0	Allow NULL?
37	CDPRODM	Product Model	String	UDC (17 PM)	8	0	Allow NULL?
38	CDNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
39	CDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
40	CDLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
41	CDAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
42	CDLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
43	CDLOTT	Lot	String	Generic Edit	30	0	Allow NULL?
44	CDSERP	Service Package	String	Generic Edit	8	0	Allow NULL?
45	CDCOVGR	Coverage Group	String	UDC (17 CG)	8	0	Allow NULL?
46	CDMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
47	CDPRODC	Product Component	String	UDC (17 PC)	10	0	Allow NULL?
48	CDCNDJ	Date - Cancel	Date	Generic Edit	6	0
49	CDCNRC	Cancellation Reason Code	String	UDC (17 CN)	3	0	Allow NULL?
50	CDCDUR	Non-Billable Duration	Numeric	Generic Edit	7	2	Allow NULL?
51	CDDAYSC	Number Days In Contract	Numeric	Generic Edit	5	0	Allow NULL?
52	CDBILLF	Billed Flag (Y/N)	Character	UDC (17 YN)	1	0	Allow NULL?
53	CDYN	Yes or No Entry	Character	Generic Edit	1	0	Allow NULL?
54	CDADAR	Billing In Advance/Arrears	Character	UDC (17 AA)	1	0	Allow NULL?
55	CDBDUR	Billing Duration	Numeric	Generic Edit	7	2	Allow NULL?
56	CDBLFC	Billing Frequency Code	Character	UDC	1	0	Allow NULL?
57	CDDOM	Day of the Month	Numeric	Generic Edit	2	0	Allow NULL?
58	CDBUM	Unit of Measure - Billed	String	UDC (00 UM)	2	0	Allow NULL?
59	CDBTFR	Date - Bill From	Date	Generic Edit	6	0
60	CDBTDT	Billed Through	Date	Generic Edit	6	0
61	CDRNWDT	Renewal Date	Date	Generic Edit	6	0
62	CDDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
63	CDUOM4	Unit of Measure - Pricing	String	UDC (00 UM)	2	0	Allow NULL?
64	CDUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
65	CDU	Units	Numeric	Generic Edit	15	2	Allow NULL?
66	CDUP	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
67	CDFUPC	Amount - Price per Unit - Foreign	Numeric	Generic Edit	15	4	Allow NULL?
68	CDAMTCD	Domestic Credit Amount	Numeric	Generic Edit	15	2	Allow NULL?
69	CDAMTCF	Foreign Credit Amount	Numeric	Generic Edit	15	2	Allow NULL?
70	CDCANDM	Domestic Cancel Amount	Numeric	Generic Edit	15	2	Allow NULL?
71	CDCANFN	Foreign Cancel Amount	Numeric	Generic Edit	15	2	Allow NULL?
72	CDRRBA	Recurring Billing Amount	Numeric	Generic Edit	15	2	Allow NULL?
73	CDFRBA	Recurring Billing Amount - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
74	CDAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
75	CDFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
76	CDTOTD	Total Dollars	Numeric	Generic Edit	15	2	Allow NULL?
77	CDFOAG	Amount - Foreign Original Gross	Numeric	Generic Edit	15	2	Allow NULL?
78	CDDSCT	Discount Amount	Numeric	Generic Edit	15	2	Allow NULL?
79	CDCDSA	Amount - Foreign Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
80	CDSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
81	CDATXN	Amount - Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
82	CDATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
83	CDAA1	Amount	Numeric	Generic Edit	15	2	Allow NULL?
84	CDAA2	Amount	Numeric	Generic Edit	15	2	Allow NULL?
85	CDUREC	Units - Received	Numeric	Generic Edit	15	0	Allow NULL?
86	CDUOPN	Units - Open	Numeric	Generic Edit	15	0	Allow NULL?
87	CDAREC	Amount - Received	Numeric	Generic Edit	15	2	Allow NULL?
88	CDFREC	Amount - Received Foreign	Numeric	Generic Edit	15	2	Allow NULL?
89	CDAOPN	Amount - Open	Numeric	Generic Edit	15	2	Allow NULL?
90	CDFOPN	Amount Open - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
91	CDMXMET1	Meter Reading 1	Numeric	Generic Edit	15	2	Allow NULL?
92	CDMXMET2	Meter Reading 2	Numeric	Generic Edit	15	2	Allow NULL?
93	CDMXMET3	Meter Reading 3	Numeric	Generic Edit	15	2	Allow NULL?
94	CDDAILY	Daily Amortization Amount	Numeric	Generic Edit	15	4	Allow NULL?
95	CDPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
96	CDRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
97	CDSSDJ	Date - Suspend	Date	Generic Edit	6	0
98	CDBSUSP	Bill Suspend Flag	Character	UDC (17 BS)	1	0	Allow NULL?
99	CDCD01	Category Code 01 - Contract Detail	String	UDC (17 D1)	8	0	Allow NULL?
100	CDCD02	Category Code 02 - Contract Detail	String	UDC (17 D2)	8	0	Allow NULL?
101	CDCD03	Category Code 03 - Contract Detail	String	UDC (17 D3)	10	0	Allow NULL?
102	CDCD04	Category Code 04 - Contract Detail	String	UDC (17 D4)	10	0	Allow NULL?
103	CDCD05	Category Code 05 - Contract Detail	String	UDC (17 D5)	10	0	Allow NULL?
104	CDRNFLG	Renewal Flag	Character	UDC (17 YN)	1	0	Allow NULL?
105	CDBSWAR	Base Warranty Flag	Character	UDC (17 YN)	1	0	Allow NULL?
106	CDBTF05	Free Contract	Character	UDC (17 TF)	1	0	Allow NULL?
107	CDWRLFL	Warranty Float In Days	Numeric	Generic Edit	6	0	Allow NULL?
108	CDCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
109	CDCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
110	CDCRCF	Currency Code - Origin	String	Generic Edit	3	0	Allow NULL?
111	CDCRRD	Currency Conversion Rate - Divisor	Numeric	Generic Edit	15	0	Allow NULL?
112	CDCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
113	CDDSFT	Discount Factor Type - $ or % (D/P)	Character	UDC (H41 DS)	1	0	Allow NULL?
114	CDDSPC	Discount Percent	Numeric	Generic Edit	8	3	Allow NULL?
115	CDUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
116	CDVR01	Reference	String	Generic Edit	25	0	Allow NULL?
117	CDURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
118	CDURDT	User Reserved Date	Date	Generic Edit	6	0
119	CDURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
120	CDURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
121	CDURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
122	CDCRTU	Created by user	String	Generic Edit	10	0	Allow NULL?
123	CDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
124	CDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
125	CDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
126	CDUPMJ	Date - Updated	Date	Generic Edit	6	0
127	CDUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
128	CDASN1	Price and Adjustment Schedule-Contract	String	UDC (40 AS)	8	0	Allow NULL?
129	CDASN2	Price and Adjustment Schedule-Service	String	UDC (40 AS)	8	0	Allow NULL?
130	CDPCPR	Price Cap Percentage	Numeric	Generic Edit	7	4	Allow NULL?
131	CDAN8PB	Address Number - Price By	Numeric	Generic Edit	8	0	Allow NULL?
132	CDADPRF	Advance Price Flag	Character	UDC (17 YN)	1	0	Allow NULL?

TOP 920 | 17 | F1721 INDEXES

Number

Description

Contract Chg # Line # (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	COCH	Contract Change Number	Ascending
3	LNID	Line Number	Ascending

Customer # Line Type

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	LNTY	Line Type	Ascending

Installed Base #

Element	Alias	Description	Sequence
1	LNTY	Line Type	Ascending
2	NUMB	Asset Item Number	Ascending

Site # Line Type

Element	Alias	Description	Sequence
1	LANO	Address Number - Lessor/Rentor/Mortgagor	Ascending
2	LNTY	Line Type	Ascending

Contract Chg # Line#(D)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	COCH	Contract Change Number	Ascending
3	LNID	Line Number	Descending

Customer # Doc Type

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DCTO	Order Type	Ascending

Asset Item No

Element	Alias	Description	Sequence
1	NUMB	Asset Item Number	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

132 COLUMNS | 7 INDEXES | 920 | 17 | F1721 TABLE

TOP 920 | 17 | F1721 COLUMNS

TOP 920 | 17 | F1721 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

132 COLUMNS | 7 INDEXES | 920 | 17 | F1721 TABLE

TOP920 | 17 | F1721 COLUMNS

TOP920 | 17 | F1721 INDEXES

TOP 920 | 17 | F1721 COLUMNS

TOP 920 | 17 | F1721 INDEXES