	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

36 COLUMNS | 9 INDEXES | 910 | H90 | F9001 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H90: ONEWORLD TOOLS
1	910	F9001	TR	36	9	Task Relationships	Files	H90: ONEWORLD TOOLS	Control Tables

TOP 910 | H90 | F9001 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	TRRLTYPE	Task View ID	String	Generic Edit	5	Allow NULL?
2	TRFRMREL	From Release	String	Generic Edit	10	Allow NULL?
3	TRTHRREL	Thru Release	String	Generic Edit	10	Allow NULL?
4	TRPARNTTSK	Parent Task ID	String	Generic Edit	36	Allow NULL?
5	TRCHILDTSK	Child Task ID	String	Generic Edit	36	Allow NULL?
6	TRPRSSEQ	Presentation Sequence	Numeric	Generic Edit	6	Allow NULL?
7	TRRULEID	Qualifier Rule Name	String	Generic Edit	15	Allow NULL?
8	TRPARCNGRP	Parent Child Relationship	Numeric	Generic Edit	11	Allow NULL?
9	TROVHRS	Override Units	Numeric	Generic Edit	11	Allow NULL?
10	TROVRSC	Override Resource Address Number	String	Generic Edit	8	Allow NULL?
11	TRUNITOFMS	Unit of Measure	String	Generic Edit	2	Allow NULL?
12	TRRELACTIVE	Active	Character	Generic Edit	1	Allow NULL?
13	TRREQOPTFG	Required/Optional	Character	Generic Edit	1	Allow NULL?
14	TRACTIVAFG	Activator Type	Character	Generic Edit	1	Allow NULL?
15	TRBPMED	BPM Event Description	String	Generic Edit	40	Allow NULL?
16	TRBPMR	BPM Role	String	Generic Edit	40	Allow NULL?
17	TRLKRTREL	Link To Task View	String	Generic Edit	5	Allow NULL?
18	TRLKPTREL	Link To Parent Task	String	Generic Edit	36	Allow NULL?
19	TRLKCTREL	Link To Child Task	String	Generic Edit	36	Allow NULL?
20	TRLKFRREL	Link To From Release	String	Generic Edit	10	Allow NULL?
21	TRLKTRREL	Link To Through Release	String	Generic Edit	10	Allow NULL?
22	TRDATAPASS	Auto Data Passing	Character	Generic Edit	1	Allow NULL?
23	TRCOMPLETE	Complete	Character	UDC (H90 CO)	1	Allow NULL?
24	TRUSER	User ID	String	Generic Edit	10	Allow NULL?
25	TRPID	Program ID	String	Generic Edit	10	Allow NULL?
26	TRJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
27	TRUPMJ	Date - Updated	Date	Generic Edit	6
28	TRUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
29	TRFUFREL1	Form Mode Override	Character	Generic Edit	1	Allow NULL?
30	TRFUFREL2	Future Use Relationship 2	String	Generic Edit	3	Allow NULL?
31	TRFUFREL3	Future Use Relationship 3	String	Generic Edit	3	Allow NULL?
32	TRFUFREL4	Future Use Relationship 4	String	Generic Edit	10	Allow NULL?
33	TRFUFREL5	Future Use Relationship 5	String	Generic Edit	10	Allow NULL?
34	TRFUFREL6	Link To Variant	String	Generic Edit	20	Allow NULL?
35	TRFUFREL7	Future Use Relationship 7	String	Generic Edit	40	Allow NULL?
36	TRFUFREL8	Future Use Relationship 8	String	Generic Edit	80	Allow NULL?

TOP 910 | H90 | F9001 INDEXES

Number

Description

Relationship Primary (Primary/Unique)

Element	Alias	Description	Sequence
1	RLTYPE	Task View ID	Ascending
2	FRMREL	From Release	Ascending
3	THRREL	Thru Release	Ascending
4	PARNTTSK	Parent Task ID	Ascending
5	CHILDTSK	Child Task ID	Ascending
6	PRSSEQ	Presentation Sequence	Ascending

Child

Element	Alias	Description	Sequence
1	CHILDTSK	Child Task ID	Ascending

Parent Sequence

Element	Alias	Description	Sequence
1	RLTYPE	Task View ID	Ascending
2	FRMREL	From Release	Ascending
3	THRREL	Thru Release	Ascending
4	PARNTTSK	Parent Task ID	Ascending
5	PRSSEQ	Presentation Sequence	Ascending

Relationship Type Parent +

Element	Alias	Description	Sequence
1	RLTYPE	Task View ID	Ascending
2	PARNTTSK	Parent Task ID	Ascending
3	CHILDTSK	Child Task ID	Ascending
4	PRSSEQ	Presentation Sequence	Ascending
5	FRMREL	From Release	Ascending
6	THRREL	Thru Release	Ascending

Qualifier Rule ID

Element	Alias	Description	Sequence
1	RULEID	Qualifier Rule Name	Ascending

Parent

Element	Alias	Description	Sequence
1	PARNTTSK	Parent Task ID	Ascending

Relationship Type Child +

Element	Alias	Description	Sequence
1	RLTYPE	Task View ID	Ascending
2	CHILDTSK	Child Task ID	Ascending
3	FRMREL	From Release	Ascending
4	THRREL	Thru Release	Ascending

Active

Element	Alias	Description	Sequence
1	RELACTIVE	Active	Ascending
2	PARNTTSK	Parent Task ID	Ascending
3	CHILDTSK	Child Task ID	Ascending
4	RLTYPE	Task View ID	Ascending
5	FRMREL	From Release	Ascending
6	THRREL	Thru Release	Ascending

Parent +

Element	Alias	Description	Sequence
1	RLTYPE	Task View ID	Ascending
2	FRMREL	From Release	Ascending
3	THRREL	Thru Release	Ascending
4	PARNTTSK	Parent 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

36 COLUMNS | 9 INDEXES | 910 | H90 | F9001 TABLE

TOP 910 | H90 | F9001 COLUMNS

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

36 COLUMNS | 9 INDEXES | 910 | H90 | F9001 TABLE

TOP910 | H90 | F9001 COLUMNS

TOP910 | H90 | F9001 INDEXES

TOP 910 | H90 | F9001 COLUMNS

TOP 910 | H90 | F9001 INDEXES