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 SecCode table stores security information for Infor CRM users. As shown in Table 2, the database contains 3 default records. Then, as you add users and teams, a record is created. Teams can be based on region, territory, type of account, or department.
The SECCODE table corresponds to the OWNER entity in the entity model.
|
|
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 | Values | Relationship | Related Table and Field |
|---|---|---|---|---|---|---|
|
SECCODEID (PK) |
STANDARDID(12) |
NOT NULL |
SECCODE_SECCODEID (AK) |
|
(One) to (Many) |
|
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many)* limited to 1:1 by application |
||||||
|
SECCODEDESC |
varchar(64) |
NULLS |
SECCODE_SECCODEDESC (CA) |
|
|
|
|
SECCODETYPE |
BOOLEAN(1) |
NULLS |
|
U=Users and Templates, G=Team, D=Department, S=System |
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
|
(Many) to (One) |
Table 2
| SECCODEID | SECCODEDESC | SECCODETYPE |
|---|---|---|
|
SYST00000001 |
Everyone |
S |
|
SYST00000002 |
Everyone (View Only) |
S |
|
N6UJ9A000000 |
IS |
D |