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	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

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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H95: Tech Resources/Applications
1	812	F8305	R5	62	1	FASTR - Row Specifications Master File	Files	H95: Tech Resources/Applications	Business Data

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	R5PID	Program ID	String	Generic Edit	10	Allow NULL?
2	R5VERS	Version History	String	Generic Edit	10	Allow NULL?
3	R5RNBR	Row Number	String	Generic Edit	4	Allow NULL?
4	R5DSCR	Description - Row	String	Generic Edit	40	Allow NULL?
5	R5DTX1	Description - Descriptive Text 1	String	Generic Edit	75	Allow NULL?
6	R5PRTI	Print Indicator	Character	Generic Edit	1	Allow NULL?
7	R5LT	Ledger Types	String	UDC (09 LT)	2	Allow NULL?
8	R5FIYR	Fiscal Year	String	Generic Edit	2	Allow NULL?
9	R5RINC	Row Type Code	String	UDC	2	Allow NULL?
10	R5OR01	Object Range 01	String	Generic Edit	15	Allow NULL?
11	R5OR02	Object Range 02	String	UDC	15	Allow NULL?
12	R5OR03	Object Range 03	String	Generic Edit	15	Allow NULL?
13	R5OR04	Object Range 04	String	UDC	15	Allow NULL?
14	R5OR05	Object Range 05	String	Generic Edit	15	Allow NULL?
15	R5OR06	Object Range 06	String	UDC	15	Allow NULL?
16	R5OR07	Object Range 07	String	Generic Edit	15	Allow NULL?
17	R5OR08	Object Range 08	String	UDC	15	Allow NULL?
18	R5OR09	Object Range 09	String	Generic Edit	15	Allow NULL?
19	R5OR10	Object Range 10	String	UDC	15	Allow NULL?
20	R5OR11	Object Range 11	String	Generic Edit	15	Allow NULL?
21	R5OR12	Object Range 12	String	UDC	15	Allow NULL?
22	R5OR13	Object Range 13	String	UDC	15	Allow NULL?
23	R5OR14	Object Range 14	String	UDC	15	Allow NULL?
24	R5OR15	Object Range 15	String	UDC	15	Allow NULL?
25	R5OR16	Object Range 16	String	UDC	15	Allow NULL?
26	R5OR17	Object Range 17	String	UDC	15	Allow NULL?
27	R5OR18	Object Range 18	String	UDC	15	Allow NULL?
28	R5OR19	Object Range 19	String	UDC	15	Allow NULL?
29	R5OR20	Object Range 20	String	UDC	15	Allow NULL?
30	R5OR21	Object Range 21	String	UDC	15	Allow NULL?
31	R5OR22	Object Range 22	String	UDC	15	Allow NULL?
32	R5OR23	Object Range 23	String	UDC	15	Allow NULL?
33	R5OR24	Object Range 24	String	UDC	15	Allow NULL?
34	R5OR25	Object Range 25	String	UDC	15	Allow NULL?
35	R5OR26	Object Range 26	String	UDC	15	Allow NULL?
36	R5VA01	*Value 01	String	Generic Edit	12	Allow NULL?
37	R5VA02	*Value 02	String	Generic Edit	12	Allow NULL?
38	R5VA03	*Value 03	String	Generic Edit	12	Allow NULL?
39	R5VA04	*Value 04	String	Generic Edit	12	Allow NULL?
40	R5VA05	*Value 05	String	Generic Edit	12	Allow NULL?
41	R5VA06	*Value 06	String	Generic Edit	12	Allow NULL?
42	R5VA07	*Value 07	String	Generic Edit	12	Allow NULL?
43	R5VA08	*Value 08	String	Generic Edit	12	Allow NULL?
44	R5VA09	*Value 09	String	Generic Edit	12	Allow NULL?
45	R5VA10	*Value 10	String	Generic Edit	12	Allow NULL?
46	R5VA11	*Value 11	String	Generic Edit	12	Allow NULL?
47	R5VA12	*Value 12	String	Generic Edit	12	Allow NULL?
48	R5VA13	*Value 13	String	Generic Edit	12	Allow NULL?
49	R5VA14	*Value 14	String	Generic Edit	12	Allow NULL?
50	R5VA15	*Value 15	String	Generic Edit	12	Allow NULL?
51	R5VA16	*Value 16	String	Generic Edit	12	Allow NULL?
52	R5VA17	*Value 17	String	Generic Edit	12	Allow NULL?
53	R5VA18	*Value 18	String	Generic Edit	12	Allow NULL?
54	R5VA19	*Value 19	String	Generic Edit	12	Allow NULL?
55	R5VA20	*Value 20	String	Generic Edit	12	Allow NULL?
56	R5VA21	*Value 21	String	Generic Edit	12	Allow NULL?
57	R5VA22	*Value 22	String	Generic Edit	12	Allow NULL?
58	R5VA23	*Value 23	String	Generic Edit	12	Allow NULL?
59	R5VA24	*Value 24	String	Generic Edit	12	Allow NULL?
60	R5RSGN	Reverse Sign (Y/N)	Character	Generic Edit	1	Allow NULL?
61	R5DECI	Data Display Decimals	Character	Generic Edit	1	Allow NULL?
62	R5OPTM	Optimized Row Number	Numeric	Generic Edit	9	Allow NULL?

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 | 812 | H95 | F8305 TABLE

TOP 812 | H95 | F8305 COLUMNS

TOP 812 | H95 | F8305 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 | 812 | H95 | F8305 TABLE

TOP812 | H95 | F8305 COLUMNS

TOP812 | H95 | F8305 INDEXES

TOP 812 | H95 | F8305 COLUMNS

TOP 812 | H95 | F8305 INDEXES