	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

39 COLUMNS | 5 INDEXES | 812 | H90 | F98810N TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H90: ONEWORLD TOOLS
1	812	F98810N	AM	39	5	Activity Master - Net Change	Files	H90: ONEWORLD TOOLS	Control Tables

TOP 812 | H90 | F98810N COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	AMFRMREL	From Release	String	Generic Edit	10	Allow NULL?
2	AMTHRREL	Thru Release	String	Generic Edit	10	Allow NULL?
3	AMPROCNAME	Process ID	String	Generic Edit	10	Allow NULL?
4	AMPROCVER	Workflow Process Version	Numeric	Generic Edit	5	Allow NULL?
5	AMACTNAME	Task	String	Generic Edit	10	Allow NULL?
6	AMACTDESC	Workflow Task Description	String	Generic Edit	40	Allow NULL?
7	AMACTTYPE	Workflow Task Type	String	UDC (98 AT)	2	Allow NULL?
8	AMNXTACTIST	Next Task Instance	Numeric	Generic Edit	8	Allow NULL?
9	AMWFPTH	Workflow Icon Path	String	Generic Edit	120	Allow NULL?
10	AMGENLNG	Generid Long ID - EnterpriseOne	Identifier (ID)	Generic Edit	11
11	AMTRANATB	Transition Attribute	String	Generic Edit	10	Allow NULL?
12	AMTRANFUN	Transition Function	String	Generic Edit	32	Allow NULL?
13	AMTRANJON	Transition And Join (Y/N)	Character	Generic Edit	1	Allow NULL?
14	AMSTRCATB	Structure Attribute	String	Generic Edit	10	Allow NULL?
15	AMSTRCFUN	Structure Function	String	Generic Edit	32	Allow NULL?
16	AMACTCD1	Task Category Code 1	String	UDC (98 1A)	6	Allow NULL?
17	AMACTCD2	Task Category Code 2	String	UDC (98 2A)	6	Allow NULL?
18	AMACTCD3	Task Category Code 3	String	UDC (98 3A)	6	Allow NULL?
19	AMUSER	User ID	String	Generic Edit	10	Allow NULL?
20	AMPID	Program ID	String	Generic Edit	10	Allow NULL?
21	AMJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
22	AMUPMJ	Date - Updated	Date	Generic Edit	6
23	AMTDAY	Time of Day	Numeric	Generic Edit	6	Allow NULL?
24	AMEXPACT	Expiration Task	Character	Generic Edit	1	Allow NULL?
25	AMEXPHR	Expiration Minutes	Numeric	Generic Edit	7	Allow NULL?
26	AMDAEXP	Date Expired	Date	Generic Edit	6
27	AMTIEXP	Time Expired	Numeric	Generic Edit	7	Allow NULL?
28	AMCOPMOV	Copy/Move	Character	Generic Edit	1	Allow NULL?
29	AMACTFU1	Future Use 1	Character	Generic Edit	1	Allow NULL?
30	AMACTFU2	Future Use 2	String	Generic Edit	3	Allow NULL?
31	AMACTFU3	Future Use 3	String	Generic Edit	3	Allow NULL?
32	AMACTFU4	Future Use 4	String	Generic Edit	20	Allow NULL?
33	AMACTFU5	Future Use 5	String	Generic Edit	20	Allow NULL?
34	AMACTUID	Workflow Task Unique ID	String	Generic Edit	64	Allow NULL?
35	AMPROCUID	Process Unique ID	String	Generic Edit	64	Allow NULL?
36	AMSPNAME	Sub Process Name	String	Generic Edit	256	Allow NULL?
37	AMENGUID	Workflow Engine Unique ID	String	Generic Edit	64	Allow NULL?
38	AMSPCALL	Sub Process Call	String	UDC (98 SP)	2	Allow NULL?
39	AMCHGF	Change Flag	Character	Generic Edit	1	Allow NULL?

TOP 812 | H90 | F98810N INDEXES

Number

Description

Process Activity (Primary/Unique)

Element	Alias	Description	Sequence
1	FRMREL	From Release	Ascending
2	THRREL	Thru Release	Ascending
3	PROCNAME	Process ID	Ascending
4	PROCVER	Workflow Process Version	Ascending
5	ACTNAME	Task	Ascending

Process Version +A

Element	Alias	Description	Sequence
1	PROCNAME	Process ID	Ascending
2	PROCVER	Workflow Process Version	Ascending
3	ACTTYPE	Workflow Task Type	Ascending

Activity Type Activity

Element	Alias	Description	Sequence
1	ACTTYPE	Workflow Task Type	Ascending
2	ACTNAME	Task	Ascending

ProcessUniqueID

Element	Alias	Description	Sequence
1	PROCUID	Process Unique ID	Ascending

ActivityUniqueID

Element	Alias	Description	Sequence
1	ACTUID	Workflow Task Unique 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

39 COLUMNS | 5 INDEXES | 812 | H90 | F98810N TABLE

TOP 812 | H90 | F98810N COLUMNS

TOP 812 | H90 | F98810N 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

39 COLUMNS | 5 INDEXES | 812 | H90 | F98810N TABLE

TOP812 | H90 | F98810N COLUMNS

TOP812 | H90 | F98810N INDEXES

TOP 812 | H90 | F98810N COLUMNS

TOP 812 | H90 | F98810N INDEXES