	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 | 5 INDEXES | 910 | 31B | F31B25 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
31B: Blend Management
1	910	F31B25	TR	28	5	QA History Results Workfile	Files	31B: Blend Management

TOP 910 | 31B | F31B25 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	TRJOBS	Job Number	Numeric	Generic Edit	8	Allow NULL?
2	TRRT1	User Defined Codes	String	Generic Edit	2	Allow NULL?
3	TRTSRT	Test Sort Sequence Number	Numeric	Generic Edit	5	Allow NULL?
4	TRTSTRSNM	Test Result Name	String	Generic Edit	30	Allow NULL?
5	TRWOPID	Operation ID	Integer	Generic Edit	11	Allow NULL?
6	TRWFTF	From To Flag	Character	Generic Edit	1	Allow NULL?
7	TRWOPN	Operation Number	Numeric	Generic Edit	8	Allow NULL?
8	TRWBOPCD	Base Operation Short Code	String	Generic Edit	10	Allow NULL?
9	TRWCOPCD	Configured Operation Short Code	String	Generic Edit	10	Allow NULL?
10	TRWCDL01	Configured Operation Description	String	Generic Edit	30	Allow NULL?
11	TRMCU	Business Unit	String	Generic Edit	12	Allow NULL?
12	TRRSSTS	Result Status	Character	UDC (37 RS)	1	Allow NULL?
13	TRWVNUM	Vessel Number	String	Generic Edit	30	Allow NULL?
14	TRWALOTN	After Blend Lot	String	Generic Edit	30	Allow NULL?
15	TRWBLOTN	Before Blend Lot	String	Generic Edit	30	Allow NULL?
16	TRWVTY	Vessel Class	Character	Generic Edit	1	Allow NULL?
17	TRWBID	Blend ID	String	Generic Edit	30	Allow NULL?
18	TRWSD	Workflow Status Name	String	Generic Edit	30	Allow NULL?
19	TRWSDT	Instructed Start Date	JDE UTime	Generic Edit	11
20	TRQTST	Test ID	String	Generic Edit	25	Allow NULL?
21	TRQVAL	Test Value	String	Generic Edit	15	Allow NULL?
22	TRQPF	Pass/Fail (P/F)	Character	Generic Edit	1	Allow NULL?
23	TRCNTF	Count Field	Numeric	Generic Edit	15	Allow NULL?
24	TREV01	J.D. EnterpriseOne Event Point 01	Character	Generic Edit	1	Allow NULL?
25	TRWEDT	Instructed End Date	JDE UTime	Generic Edit	11
26	TRWASDT	Actual Start Date	JDE UTime	Generic Edit	11
27	TRWAEDT	WIM Actual End Date	JDE UTime	Generic Edit	11
28	TRWOPST	Operation Status	String	UDC (31B WF)	10	Allow NULL?

TOP 910 | 31B | F31B25 INDEXES

Number

Description

JOBS OPID WFT RT1 TSRT TSTRSNM (Primary/Unique)

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	WOPID	Operation ID	Descending
3	RT1	User Defined Codes	Ascending
4	TSRT	Test Sort Sequence Number	Ascending
5	TSTRSNM	Test Result Name	Ascending
6	WFTF	From To Flag	Ascending

JOBS WALOTN RT1 TSRT TSTRSNM

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	WALOTN	After Blend Lot	Descending
3	RT1	User Defined Codes	Ascending
4	TSRT	Test Sort Sequence Number	Ascending
5	TSTRSNM	Test Result Name	Ascending

JOBS RT1 TSRT

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	RT1	User Defined Codes	Ascending
3	TSRT	Test Sort Sequence Number	Ascending

JOBS CNTF WALOTN

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	CNTF	Count Field	Ascending
3	WALOTN	After Blend Lot	Ascending

JOBS WASDT OPID WFT RT1 TSRT

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	WASDT	Actual Start Date	Descending
3	WOPID	Operation ID	Descending
4	RT1	User Defined Codes	Ascending
5	TSRT	Test Sort Sequence Number	Ascending
6	TSTRSNM	Test Result Name	Ascending
7	WFTF	From To Flag	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 | 5 INDEXES | 910 | 31B | F31B25 TABLE

TOP 910 | 31B | F31B25 COLUMNS

TOP 910 | 31B | F31B25 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 | 5 INDEXES | 910 | 31B | F31B25 TABLE

TOP910 | 31B | F31B25 COLUMNS

TOP910 | 31B | F31B25 INDEXES

TOP 910 | 31B | F31B25 COLUMNS

TOP 910 | 31B | F31B25 INDEXES