	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

52 COLUMNS | 9 INDEXES | 910 | H90 | F9000 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H90: ONEWORLD TOOLS
1	910	F9000	TM	52	9	Task Master	Files	H90: ONEWORLD TOOLS	Control Tables

TOP 910 | H90 | F9000 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	TMTASKID	Internal Task ID	String	Generic Edit	36	Allow NULL?
2	TMTASKNM	Task ID	String	Generic Edit	40	Allow NULL?
3	TMLNGTASK	Task Name	String	Generic Edit	80	Allow NULL?
4	TMTASKTYPE	Task Type	String	UDC (H90 TT)	2	Allow NULL?
5	TMRULEID	Qualifier Rule Name	String	Generic Edit	15	Allow NULL?
6	TMOBNM	Object Name	String	Generic Edit	10	Allow NULL?
7	TMVER	Version	String	Generic Edit	10	Allow NULL?
8	TMFMNM	Form Name	String	Generic Edit	10	Allow NULL?
9	TMSYAO	Jargon	String	UDC (98 SY)	4	Allow NULL?
10	TMOPCD	Option Code	Character	UDC (98 CD)	1	Allow NULL?
11	TMCMMDPATH	URL	String	Generic Edit	256	Allow NULL?
12	TMEXEPARMS	Executable Parameters	String	Generic Edit	256	Allow NULL?
13	TMWRKDIR	Working Directory	String	Generic Edit	256	Allow NULL?
14	TMQUESTYP	Rough Cut Question Type	String	Generic Edit	5	Allow NULL?
15	TMRCCODE	UDC Product Code	String	Generic Edit	4	Allow NULL?
16	TMRCCODETP	UDC Code Type	String	Generic Edit	2	Allow NULL?
17	TMICNI	Icon Identifier	Identifier (ID)	Generic Edit	11
18	TMPTH	Path	String	Generic Edit	120	Allow NULL?
19	TMSY	Product Code	String	UDC (98 SY)	4	Allow NULL?
20	TMSYR	Product Code/Reporting	String	UDC (98 SY)	4	Allow NULL?
21	TMBASEHRS	BaseUnits	Numeric	Generic Edit	11	Allow NULL?
22	TMBASERSC	Base Resource	String	Generic Edit	8	Allow NULL?
23	TMUNITOFMS	Unit of Measure	String	Generic Edit	2	Allow NULL?
24	TMTASCKACT	Active	Character	Generic Edit	1	Allow NULL?
25	TMREQOPTFG	Required/Optional	Character	Generic Edit	1	Allow NULL?
26	TMACTIVAFG	Activator Type	Character	Generic Edit	1	Allow NULL?
27	TMBPMR	BPM Role	String	Generic Edit	40	Allow NULL?
28	TMLKRT	Link To Task View	String	Generic Edit	5	Allow NULL?
29	TMLKPT	Link To Parent Task	String	Generic Edit	36	Allow NULL?
30	TMLKCT	Link To Child Task	String	Generic Edit	36	Allow NULL?
31	TMLKFR	Link To From Release	String	Generic Edit	10	Allow NULL?
32	TMLKTR	Link To Through Release	String	Generic Edit	10	Allow NULL?
33	TMPOOPTID	PO Option ID	String	Generic Edit	36	Allow NULL?
34	TMPOTASKID	PO Link Task ID	String	Generic Edit	36	Allow NULL?
35	TMTASKCAT1	Task Category Code 1	String	Generic Edit	6	Allow NULL?
36	TMTASKCAT2	Task Category Code 2	String	Generic Edit	6	Allow NULL?
37	TMTASKCAT3	Task Category Code 3	String	Generic Edit	6	Allow NULL?
38	TMTASKCAT4	Task Category Code 4	String	Generic Edit	6	Allow NULL?
39	TMTASKCAT5	Task Category Code 5	String	Generic Edit	6	Allow NULL?
40	TMUSER	User ID	String	Generic Edit	10	Allow NULL?
41	TMPID	Program ID	String	Generic Edit	10	Allow NULL?
42	TMJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
43	TMUPMJ	Date - Updated	Date	Generic Edit	6
44	TMUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
45	TMFUFTASK1	Form Mode	Character	Generic Edit	1	Allow NULL?
46	TMFUFTASK2	Client Platforms	String	Generic Edit	3	Allow NULL?
47	TMFUFTASK3	Future Use Task 3	String	Generic Edit	3	Allow NULL?
48	TMFUFTASK4	Country Code	String	Generic Edit	10	Allow NULL?
49	TMFUFTASK5	Application Type	String	Generic Edit	10	Allow NULL?
50	TMFUFTASK6	Link To Variant	String	Generic Edit	20	Allow NULL?
51	TMFUFTASK7	BPM Model ID	String	Generic Edit	40	Allow NULL?
52	TMFUFTASK8	Report Name	String	Generic Edit	80	Allow NULL?

TOP 910 | H90 | F9000 INDEXES

Number

Description

TaskID (Primary/Unique)

Element	Alias	Description	Sequence
1	TASKID	Internal Task ID	Ascending

TaskName99 (Unique)

Element	Alias	Description	Sequence
1	TASKNM	Task ID	Ascending

Object Version Form

Element	Alias	Description	Sequence
1	OBNM	Object Name	Ascending
2	VER	Version	Ascending
3	FMNM	Form Name	Ascending

Task Type

Element	Alias	Description	Sequence
1	TASKTYPE	Task Type	Ascending

Qualifier Rule ID

Element	Alias	Description	Sequence
1	RULEID	Qualifier Rule Name	Ascending

Index for R9000

Element	Alias	Description	Sequence
1	FUFTASK4	Country Code	Ascending

Index for R9000 2

Element	Alias	Description	Sequence
1	FUFTASK4	Country Code	Ascending
2	FUFTASK6	Link To Variant	Ascending

FUFTASK7

Element	Alias	Description	Sequence
1	FUFTASK7	BPM Model ID	Ascending

ProductCode Active TaskID

Element	Alias	Description	Sequence
1	SY	Product Code	Ascending
2	TASCKACT	Active	Ascending
3	TASKID	Internal Task ID	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

52 COLUMNS | 9 INDEXES | 910 | H90 | F9000 TABLE

TOP 910 | H90 | F9000 COLUMNS

TOP 910 | H90 | F9000 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

52 COLUMNS | 9 INDEXES | 910 | H90 | F9000 TABLE

TOP910 | H90 | F9000 COLUMNS

TOP910 | H90 | F9000 INDEXES

TOP 910 | H90 | F9000 COLUMNS

TOP 910 | H90 | F9000 INDEXES