	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	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

21 COLUMNS | 4 INDEXES | 812 | H90 | F98811N TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H90: ONEWORLD TOOLS
1	812	F98811N	AT	21	4	Activity Specifications - Net Change	Files	H90: ONEWORLD TOOLS	Control Tables

TOP 812 | H90 | F98811N COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	ATFRMREL	From Release	String	Generic Edit	10	Allow NULL?
2	ATTHRREL	Thru Release	String	Generic Edit	10	Allow NULL?
3	ATPRDTYP	Event Rule Product Type - EnterpriseOne	Identifier (ID)	Generic Edit	11
4	ATAPPLID	Application ID - EnterpriseOne	Identifier (ID)	Generic Edit	11
5	ATFORMID	Event Rules Form ID - EnterpriseOne	Identifier (ID)	Generic Edit	11
6	ATCTRLID	Event Rules Control ID - EnterpriseOne	Identifier (ID)	Generic Edit	11
7	ATWEVENT	Event Rule Word	Numeric	Generic Edit	15	Allow NULL?
8	ATERID3	Event Rule Generic ID - EnterpriseOne	Identifier (ID)	Generic Edit	11
9	ATEVSPEC	Event Rules Specification ID - E1	Identifier (ID)	Generic Edit	11
10	ATEVSK	Event Spec Key	String	Generic Edit	36	Allow NULL?
11	ATERBLOB	Event Rules Blob - EnterpriseOne	Binary (Blob)	Generic Edit	999
12	ATPROCNAME	Process ID	String	Generic Edit	10	Allow NULL?
13	ATACTNAME	Task	String	Generic Edit	10	Allow NULL?
14	ATPROCVER	Workflow Process Version	Numeric	Generic Edit	5	Allow NULL?
15	ATACTUID	Workflow Task Unique ID	String	Generic Edit	64	Allow NULL?
16	ATUSER	User ID	String	Generic Edit	10	Allow NULL?
17	ATPID	Program ID	String	Generic Edit	10	Allow NULL?
18	ATJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
19	ATUPMJ	Date - Updated	Date	Generic Edit	6
20	ATTDAY	Time of Day	Numeric	Generic Edit	6	Allow NULL?
21	ATCHGF	Change Flag	Character	Generic Edit	1	Allow NULL?

Number

Description

FromRelease ThruRelease + (Primary/Unique)

Element	Alias	Description	Sequence
1	FRMREL	From Release	Ascending
2	THRREL	Thru Release	Ascending
3	PRDTYP	Event Rule Product Type - EnterpriseOne	Ascending
4	PROCNAME	Process ID	Ascending
5	PROCVER	Workflow Process Version	Ascending
6	ACTNAME	Task	Ascending
7	WEVENT	Event Rule Word	Ascending

Everstpt ApplicationID +A

Element	Alias	Description	Sequence
1	PRDTYP	Event Rule Product Type - EnterpriseOne	Ascending
2	APPLID	Application ID - EnterpriseOne	Ascending
3	FORMID	Event Rules Form ID - EnterpriseOne	Ascending
4	CTRLID	Event Rules Control ID - EnterpriseOne	Ascending
5	WEVENT	Event Rule Word	Ascending

Everstpt ProcessName +A

Element	Alias	Description	Sequence
1	PRDTYP	Event Rule Product Type - EnterpriseOne	Ascending
2	PROCNAME	Process ID	Ascending
3	PROCVER	Workflow Process Version	Ascending
4	ACTNAME	Task	Ascending
5	WEVENT	Event Rule Word	Ascending

ActivityUniqueID

Element	Alias	Description	Sequence
1	ACTUID	Workflow Task Unique ID	Ascending