920: Top 10 requests

	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

910: Top 10 requests

	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

812: Top 10 requests

	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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H95: Object and Environment Tech
1	920	F82100	A1	62	1	World Writer Query Header	Files	H95: Object and Environment Tech

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	A1QRYG	Query Group	String	UDC	10	Allow NULL?
2	A1QRYN	Query Name	String	Generic Edit	10	Allow NULL?
3	A1JD	Version Title	String	Generic Edit	50	Allow NULL?
4	A1EXCL	User Exclusive (0/1/2/3/4)	Character	UDC (H98 EX)	1	Allow NULL?
5	A1DEST	Output Destination	Character	UDC	1	Allow NULL?
6	A1USER	User ID	String	Generic Edit	10	Allow NULL?
7	A1VCD	Date - Last Changed	Date	Generic Edit	6
8	A1VED	Date - Last Executed	Date	Generic Edit	6
9	A1PTSP	Print Specifications Cover Page (Y/N)	Character	Generic Edit	1	Allow NULL?
10	A1HJBQ	Hold on Job Queue	Character	Generic Edit	1	Allow NULL?
11	A1QTL1	Query Version Title Line 1	String	Generic Edit	50	Allow NULL?
12	A1QTL2	Query Version Title Line 2	String	Generic Edit	50	Allow NULL?
13	A1QTL3	Query Version Title Line 3	String	Generic Edit	50	Allow NULL?
14	A1DTTL	Prompt - Details or Totals	Character	UDC	1	Allow NULL?
15	A1JOBQ	Batch Job Queue	String	Generic Edit	10	Allow NULL?
16	A1DFLS	Default Line Spacing	Numeric	Generic Edit	2	Allow NULL?
17	A1DFCS	Default Column Spacing	Numeric	Generic Edit	2	Allow NULL?
18	A1WRAP	Query Line Wrap Option	Character	Generic Edit	1	Allow NULL?
19	A1TCOL	Total Report columns	Numeric	Generic Edit	5	Allow NULL?
20	A1MAXR	Maximum records to Query	Numeric	Generic Edit	15	Allow NULL?
21	A1OLPP	Prompt - One Line Per Page	Character	UDC	1	Allow NULL?
22	A1OVTF	Override to File Name	String	Generic Edit	10	Allow NULL?
23	A1PRTQ	Print Queue	String	Generic Edit	10	Allow NULL?
24	A1LPI	Lines Per Inch	String	UDC	3	Allow NULL?
25	A1CPI	Characters Per Inch	String	UDC	4	Allow NULL?
26	A1RCOP	Number of Report Copies	Numeric	Generic Edit	3	Allow NULL?
27	A1DLIN	Number of Lines Between Detail	Numeric	Generic Edit	1	Allow NULL?
28	A1HLDQ	Hold on Print Queue	Character	UDC (H98 HL)	1	Allow NULL?
29	A1WDTH	Maximum Form Width	Numeric	Generic Edit	3	Allow NULL?
30	A1LNTH	Maximum Form Length	Numeric	Generic Edit	3	Allow NULL?
31	A1OVRF	Location of Page Overflow	Numeric	Generic Edit	3	Allow NULL?
32	A1FMTP	Form Type	String	Generic Edit	10	Allow NULL?
33	A1OAPG	Align Page	Character	Generic Edit	1	Allow NULL?
34	A1SDRW	Source Drawer	String	UDC	3	Allow NULL?
35	A1FNID	Font Identification	String	Generic Edit	10	Allow NULL?
36	A1FMFD	Form Feed	String	Generic Edit	8	Allow NULL?
37	A1PTQT	Print Quality	String	Generic Edit	6	Allow NULL?
38	A1CCHR	Control Character	String	Generic Edit	5	Allow NULL?
39	A1GCHR	Graphic Character Set	String	Generic Edit	7	Allow NULL?
40	A1CDPG	Code Page	String	Generic Edit	6	Allow NULL?
41	A1PROT	Page Rotation	String	Generic Edit	5	Allow NULL?
42	A1PGFT	Print Text	String	Generic Edit	30	Allow NULL?
43	A1HJUS	Justification	String	Generic Edit	6	Allow NULL?
44	A1SEPP	Separator Pages	Character	Generic Edit	1	Allow NULL?
45	A1OUTP	Output Priority	Character	Generic Edit	1	Allow NULL?
46	A1OFIL	Output File	String	Generic Edit	10	Allow NULL?
47	A1OLBR	Output Library	String	Generic Edit	10	Allow NULL?
48	A1OMBR	Output Member	String	Generic Edit	10	Allow NULL?
49	A1LNKG	Link Query Group	String	UDC	10	Allow NULL?
50	A1LNKN	Link Query Name	String	Generic Edit	10	Allow NULL?
51	A1SVDL	Save or Delete	Character	Generic Edit	1	Allow NULL?
52	A1DUPL	Duplex Output	Character	UDC (H98 DU)	1	Allow NULL?
53	A1USRD	User Data	String	Generic Edit	10	Allow NULL?
54	A1SAVE	Save Spool File	Character	Generic Edit	1	Allow NULL?
55	A1SPLF	Spool File Name	String	Generic Edit	10	Allow NULL?
56	A1PDN	Printer Device Name	String	Generic Edit	10	Allow NULL?
57	A1IPDS	Intelligent Printer Data Stream	Character	Generic Edit	1	Allow NULL?
58	A1DBAT	Include Double-Byte Character Data (Y/N)	Character	Generic Edit	1	Allow NULL?
59	A1DBEC	Process Double-Byte Extension Char (Y/N)	Character	Generic Edit	1	Allow NULL?
60	A1DBRT	Rotate Double-Byte Characters (Y/N)	Character	Generic Edit	1	Allow NULL?
61	A1DBCD	Double-Byte Character Density	String	UDC (H98 DB)	3	Allow NULL?
62	A1DBPC	Print Double-Byte Characters (Y/N)	Character	UDC (H98 DC)	1	Allow NULL?

Su	Mo	Tu	We	Th	Fr	Sa
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30

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

62 COLUMNS | 1 INDEXES | 920 | H95 | F82100 TABLE

TOP 920 | H95 | F82100 COLUMNS

TOP 920 | H95 | F82100 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

62 COLUMNS | 1 INDEXES | 920 | H95 | F82100 TABLE

TOP920 | H95 | F82100 COLUMNS

TOP920 | H95 | F82100 INDEXES

TOP 920 | H95 | F82100 COLUMNS

TOP 920 | H95 | F82100 INDEXES