	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

28 COLUMNS | 4 INDEXES | 920 | H97 | F97224 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H97: Benchmarking/Performance
1	920	F97224	RE	28	4	Autopilot Test Script Executions	Files	H97: Benchmarking/Performance	System Tables

TOP 920 | H97 | F97224 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	RESCREXID	Script Execution ID	Numeric	Generic Edit	9	Allow NULL?
2	RETESTID	Identifies week of Autopilot tests	Numeric	Generic Edit	9	Allow NULL?
3	RETESTBATC	Test Batch	String	Generic Edit	30	Allow NULL?
4	RESCRID	AutoPilot Script ID	String	Generic Edit	50	Allow NULL?
5	RESCRNM	AutoPilot Script Name	String	Generic Edit	50	Allow NULL?
6	RESCREXID2	Parent Script Execution ID	Numeric	Generic Edit	9	Allow NULL?
7	RETESTTYPE	Autopilot test type	Character	UDC (H97 TT)	1	Allow NULL?
8	REVERTICL	Script Vertical	String	UDC (H97 VE)	4	Allow NULL?
9	RESY	Product Code	String	UDC (98 SY)	4	Allow NULL?
10	REDTSTART	Start Date	Date	Generic Edit	6
11	RETMSTART	Start Time	Numeric	Generic Edit	6	Allow NULL?
12	REEXECDUR	Length of test script execution	Numeric	Generic Edit	6	Allow NULL?
13	REMUSE	User ID	String	Generic Edit	10	Allow NULL?
14	REENHV	Environment Name	String	Generic Edit	10	Allow NULL?
15	REMKEY	Machine Key	String	Generic Edit	15	Allow NULL?
16	RERPTID	AutoPilot Report ID	Numeric	Generic Edit	9	Allow NULL?
17	REQPF	Pass/Fail (P/F)	Character	Generic Edit	1	Allow NULL?
18	REFAILCODE	Reason for script failure	String	UDC (H97 FC)	3	Allow NULL?
19	REFAILEXPL	Explanation of failure	Variable String	Generic Edit	255	Allow NULL?
20	REFUTAUTOB	For future Autopilot use	Character	Generic Edit	1	Allow NULL?
21	REFUTAUTOC	For future Autopilot use	String	Generic Edit	10	Allow NULL?
22	REFUTAUTOD	For future Autopilot use	Numeric	Generic Edit	8	Allow NULL?
23	REFUTAUTOE	For future Autopilot use	String	Generic Edit	4	Allow NULL?
24	REUSER	User ID	String	Generic Edit	10	Allow NULL?
25	REPID	Program ID	String	Generic Edit	10	Allow NULL?
26	REUPMJ	Date - Updated	Date	Generic Edit	6
27	REJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
28	REUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

TOP 920 | H97 | F97224 INDEXES

Number

Description

F97224_1 (Primary/Unique)

Element	Alias	Description	Sequence
1	SCREXID	Script Execution ID	Ascending

F97224_2

Element	Alias	Description	Sequence
1	TESTID	Identifies week of Autopilot tests	Ascending

F97224_3

Element	Alias	Description	Sequence
1	SCREXID2	Parent Script Execution ID	Ascending

VERTICL SY SCRNM QPF

Element	Alias	Description	Sequence
1	VERTICL	Script Vertical	Ascending
2	SY	Product Code	Ascending
3	SCRNM	AutoPilot Script Name	Ascending
4	QPF	Pass/Fail (P/F)	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

28 COLUMNS | 4 INDEXES | 920 | H97 | F97224 TABLE

TOP 920 | H97 | F97224 COLUMNS

TOP 920 | H97 | F97224 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

28 COLUMNS | 4 INDEXES | 920 | H97 | F97224 TABLE

TOP920 | H97 | F97224 COLUMNS

TOP920 | H97 | F97224 INDEXES

TOP 920 | H97 | F97224 COLUMNS

TOP 920 | H97 | F97224 INDEXES