	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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

85 COLUMNS | 5 INDEXES | 812 | 38 | F38111 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
38: Agreement Management
1	812	F38111	DZ	85	5	Agreements Transaction Ledger	Transaction Files	38: Agreement Management	AS400 Coexistence Tables

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 DZDMCT, DZDMCS, DZDMTC, DZAN8, DZAN8R, DZITM, DZMCU, DZCO, DZLOCN, DZLOT, DZTCAJ, DZTRDJ, DZADJJ, DZDCT, DZDOC, DZKCO, DZJELN, DZDOCO, DZDCTO, DZKCOO, DZLNID, DZVEHI, DZVMCU, DZTRP, DZCMPN, DZDTO, DZDES, DZDESY, DZPSR, DZPSRY, DZSEQ, DZTREX, DZTRQT, DZUOM, DZTEMP, DZSTPU, DZDNTY, DZDNTP, DZDETP, DZDTPU, DZAMBR, DZAMBU, DZVCF, DZSTOK, DZBUM4, DZWGTR, DZBUM5, DZSTUM, DZBUM6, DZPRAS, DZAA, DZCRCD, DZUNCS, DZPAID, DZDGL, DZICU, DZICUT, DZGLPT, DZADZR, DZRCD, DZRECS, DZCRDJ, DZUKID, DZUPGL, DZSVPF, DZSVPD, DZPRTF, DZCRPO, DZCRSO, DZCDMC, DZCAND, DZCANR, DZTV01, DZTV02, DZTV03, DZURCD, DZURDT, DZURAT, DZURAB, DZURRF, DZUSER, DZPID, DZJOBN, DZUPMJ, DZTDAY FROM F38111

TOP 812 | 38 | F38111 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	DZDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
2	DZDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
3	DZDMTC	Agreement Type - Distribution	Character	UDC (38 CV)	1	0	Allow NULL?
4	DZAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
5	DZAN8R	Related - Address Number	Numeric	Generic Edit	8	0	Allow NULL?
6	DZITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
7	DZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
8	DZCO	Company	String	Generic Edit	5	0	Allow NULL?
9	DZLOCN	Location	String	Generic Edit	20	0	Allow NULL?
10	DZLOT	Date - Lot/Receipt	String	Generic Edit	30	0	Allow NULL?
11	DZTCAJ	Type - Agreement Adjustment	Character	UDC (38 CA)	1	0	Allow NULL?
12	DZTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
13	DZADJJ	Date - Adjustment	Date	Generic Edit	6	0
14	DZDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
15	DZDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
16	DZKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
17	DZJELN	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
18	DZDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
19	DZDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
20	DZKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
21	DZLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
22	DZVEHI	Vehicle ID	String	Generic Edit	12	0	Allow NULL?
23	DZVMCU	Depot - Trip	String	Generic Edit	12	0	Allow NULL?
24	DZTRP	Trip Number	Numeric	Generic Edit	8	0	Allow NULL?
25	DZCMPN	Compartment Number	Numeric	Generic Edit	2	0	Allow NULL?
26	DZDTO	Due To	Character	UDC (38 DT)	1	0	Allow NULL?
27	DZDES	Destination	String	Generic Edit	12	0	Allow NULL?
28	DZDESY	Destination Type	String	UDC (38 DY)	2	0	Allow NULL?
29	DZPSR	Source	String	Generic Edit	12	0	Allow NULL?
30	DZPSRY	Source Type	String	UDC (38 DY)	2	0	Allow NULL?
31	DZSEQ	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
32	DZTREX	Explanation - Transaction	String	Generic Edit	30	0	Allow NULL?
33	DZTRQT	Quantity Available	Numeric	Generic Edit	15	2	Allow NULL?
34	DZUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
35	DZTEMP	Temperature	Numeric	Generic Edit	7	2	Allow NULL?
36	DZSTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
37	DZDNTY	Density	Numeric	Generic Edit	7	2	Allow NULL?
38	DZDNTP	Density Type - At Standard Temperature	Character	UDC (41B DT)	1	0	Allow NULL?
39	DZDETP	Density Temperature	Numeric	Generic Edit	7	2	Allow NULL?
40	DZDTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
41	DZAMBR	Volume - Ambient	Numeric	Generic Edit	15	2	Allow NULL?
42	DZAMBU	Unit of Measure - Ambient Volume	String	UDC (00 UM)	2	0	Allow NULL?
43	DZVCF	Volume Correction Factor	Numeric	Generic Edit	7	4	Allow NULL?
44	DZSTOK	Volume - Standard	Numeric	Generic Edit	15	2	Allow NULL?
45	DZBUM4	Unit of Measure 4	String	UDC (00 UM)	2	0	Allow NULL?
46	DZWGTR	Weight Result	Numeric	Generic Edit	15	2	Allow NULL?
47	DZBUM5	Unit of Measure 5	String	UDC (00 UM)	2	0	Allow NULL?
48	DZSTUM	Quantity - Primary Stock Accounting Unit	Numeric	Generic Edit	15	2	Allow NULL?
49	DZBUM6	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
50	DZPRAS	Price at Ambient/Standard/Weight (A S W)	Character	UDC (38 PR)	1	0	Allow NULL?
51	DZAA	Amount	Numeric	Generic Edit	15	2	Allow NULL?
52	DZCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
53	DZUNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
54	DZPAID	Amount - Extended Cost/Price	Numeric	Generic Edit	15	2	Allow NULL?
55	DZDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
56	DZICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
57	DZICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
58	DZGLPT	Category - G/L	String	UDC (41 9)	4	0	Allow NULL?
59	DZADZR	Volume - Adjust to Zero	Character	Generic Edit	1	0	Allow NULL?
60	DZRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
61	DZRECS	Reconciled (Y/N)	Character	UDC (41B RP)	1	0	Allow NULL?
62	DZCRDJ	Date - Created (Julian)	Date	Generic Edit	6	0
63	DZUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
64	DZUPGL	Update General Ledger	Character	Generic Edit	1	0	Allow NULL?
65	DZSVPF	Stock Valuation Posted	Character	Generic Edit	1	0	Allow NULL?
66	DZSVPD	Date - Stock Valuation Posted	Date	Generic Edit	6	0
67	DZPRTF	Printed Flag	Character	UDC (48 PS)	1	0	Allow NULL?
68	DZCRPO	Create P.O.	Character	Generic Edit	1	0	Allow NULL?
69	DZCRSO	Create S.O.	Character	Generic Edit	1	0	Allow NULL?
70	DZCDMC	Close Agreement Flag	Character	Generic Edit	1	0	Allow NULL?
71	DZCAND	Date - Cancellation of Contract	Date	Generic Edit	6	0
72	DZCANR	Cancellation Reason Code	String	UDC (38 CC)	3	0	Allow NULL?
73	DZTV01	Sales Detail Line Origin	Character	Generic Edit	1	0	Allow NULL?
74	DZTV02	Future Use 02	Character	Generic Edit	1	0	Allow NULL?
75	DZTV03	Future Use 03	Character	Generic Edit	1	0	Allow NULL?
76	DZURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
77	DZURDT	User Reserved Date	Date	Generic Edit	6	0
78	DZURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
79	DZURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
80	DZURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
81	DZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
82	DZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
83	DZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
84	DZUPMJ	Date - Updated	Date	Generic Edit	6	0
85	DZTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?

TOP 812 | 38 | F38111 INDEXES

Number

Description

Unique Key ID Internal (Primary/Unique)

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending

ContNum ContSuppl +a

Element	Alias	Description	Sequence
1	DMCT	Agreement Number - Distribution	Ascending
2	DMCS	Agreement Supplement - Distribution	Ascending
3	SEQ	Sequence Number	Ascending
4	PSR	Source	Ascending
5	PSRY	Source Type	Ascending
6	TRDJ	Date - Order/Transaction	Ascending

Cost Center ShortItem +a

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	ITM	Item Number - Short	Ascending
3	TRDJ	Date - Order/Transaction	Ascending

DocVoucher DocType +a

Element	Alias	Description	Sequence
1	DOC	Document (Voucher Invoice etc.)	Ascending
2	DCT	Document Type	Ascending
3	KCO	Document Company	Ascending
4	JELN	Journal Entry Line Number	Ascending

CO Date Stock Val Update GL

Element	Alias	Description	Sequence
1	CO	Company	Ascending
2	DGL	Date - For G/L (and Voucher)	Ascending
3	SVPF	Stock Valuation Posted	Ascending
4	SVPD	Date - Stock Valuation Posted	Ascending
5	UPGL	Update General Ledger	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

85 COLUMNS | 5 INDEXES | 812 | 38 | F38111 TABLE

TOP 812 | 38 | F38111 COLUMNS

TOP 812 | 38 | F38111 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

85 COLUMNS | 5 INDEXES | 812 | 38 | F38111 TABLE

TOP812 | 38 | F38111 COLUMNS

TOP812 | 38 | F38111 INDEXES

TOP 812 | 38 | F38111 COLUMNS

TOP 812 | 38 | F38111 INDEXES