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	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
48: Work Order Processing
1	812	F4826	GE	22	1	W.O. Status Action Table	Constants Files	48: Work Order Processing	AS400 Coexistence Tables

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	GEDCTO	Order Type	String	UDC (00 DT)	2	Allow NULL?
2	GETYPS	Type - W.O.	Character	UDC (00 TY)	1	Allow NULL?
3	GESRST	Status Code W.O.	String	UDC (00 SS)	2	Allow NULL?
4	GENTST	Next Status - W.O.	String	UDC (00 SS)	2	Allow NULL?
5	GEA1ST	Allowed Status Code 1	String	UDC (00 SS)	2	Allow NULL?
6	GEA2ST	Allowed Status Code 2	String	UDC (00 SS)	2	Allow NULL?
7	GEA3ST	Allowed Status Code 3	String	UDC (00 SS)	2	Allow NULL?
8	GEA4ST	Allowed Status Code 4	String	UDC (00 SS)	2	Allow NULL?
9	GEA5ST	Allowed Status Code 5	String	UDC (00 SS)	2	Allow NULL?
10	GEMSTS	Maintenance Status	String	UDC (12 MS)	2	Allow NULL?
11	GEIVCM	Inventory Commitment Flag	Character	UDC (13 IC)	1	Allow NULL?
12	GESBLI	Subledger Inactive Code	Character	UDC (00 SI)	1	Allow NULL?
13	GEEQW1	Capacity Flag	Character	UDC (13 CF)	1	Allow NULL?
14	GEEQW2	Work Order Lock Flag	Character	UDC (13 LF)	1	Allow NULL?
15	GEEQW3	Eq. W.O. Future Constant 3	Character	Generic Edit	1	Allow NULL?
16	GEEQW4	Alert Status	Character	UDC (13 AS)	1	Allow NULL?
17	GEEQW5	Edit Authority	Character	UDC (17 EA)	1	Allow NULL?
18	GEBUDG	Budget Approval (Y/N)	Character	UDC (13 BA)	1	Allow NULL?
19	GEUSER	User ID	String	Generic Edit	10	Allow NULL?
20	GEPID	Program ID	String	Generic Edit	10	Allow NULL?
21	GEUPMJ	Date - Updated	Date	Generic Edit	6
22	GEJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?