If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document.
The RESOURCELIST table stores information about resources (conference rooms, overhead projectors, etc.) that can be scheduled with activities. The information includes the resource name, type of resource (such as equipment), and the coordinator's name. This information is entered into the database by the Admin user in the Infor CRM Windows Client (Tools > Manage > Resources).
|
|
If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
RESOURCEID (PK) |
STANDARDID (12) |
NOT NULL |
RESOURCELIST_RESOURCEID_PK (CA) |
(One) to (Many) |
|
|
NAME |
varchar(64) |
NULLS |
RESOURCELIST_NAME (CA) |
|
|
|
TYPE |
varchar(64) |
NULLS |
|
|
|
|
COORDID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ISLOCATION |
varchar(1) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(255) |
NULLS |
|
|
|