The TICKETAREAOWNER table stores the user assignments for the Area pick list for tickets. For example, suppose your system contains two choices in the Area pick list; Hardware and Software. Selecting Hardware as the area offers Monitor, Mouse, Keyboard, and CPU as the choices in the Category pick list. Selecting Software offers Word, Outlook, and FrontPage as the choices in the Category pick list. You might be able to add the choice Peripherals to the Area pick list options, but a user who selects it will see no Category pick list, because the pick list table has not been created in the database. This has to be done through the Infor CRM Windows Client. Users who are assigned add, edit, and delete security privileges must understand how the area, category, and issue pick lists differ from other pick lists in Infor CRM. Because of the hierarchical nature of the area, category, and issue pick lists, they should never be set to allow multiple selections.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
TICKETAREAOWNERID (PK) |
STANDARDID(12) |
NOT NULL |
TICKETAREAOWNER_PK (CA) |
|
|
|
OWNERID (FK) |
STANDARDID(12) |
NOT NULL |
|
(Many) to (One) |
|
|
AREA |
varchar(64) |
NOT NULL |
|
|
|
|
CATEGORY |
varchar(64) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |