While this table does not have a field defined as a primary key, the SLXCONTRACTSYNCLOGID field should be unique and considered a primary key.
Added in version 7.5.4
The SLXCONTRACTSYNCLOG table stores the values for accounting integration that indicate which records have been deleted since the last synchronization.
|
|
While this table does not have a field defined as a primary key, the SLXCONTRACTSYNCLOGID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
SLXCONTRACTSYNCLOGID |
varchar(38) |
NOT NULL |
SLXCONTRACTSYNCLOG_PRIMARY (AK) |
|
|
|
CREATEUSER |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
RESOURCETYPE |
varchar(64) |
NULLS |
|
|
|
|
KEYVALUE1 (FK) |
varchar(12) |
NULLS |
|
(Many) to (One) |
depends on value of RESOURCETYPE. For example, if it equals ACCOUNT, then the related table and field are ACCOUNT.ACCOUNTID |
|
KEYVALUE2 (FK) |
varchar(12) |
NULLS |
|
(Many) to (One) |
used for resource types with composite keys, this relates to the second key column |
|
ACTIONTYPE |
smallint |
NULLS |
|
|
|
|
MODIFYUSER |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
GLOBALDYNCID |
varchar(36) |
NULLS |
|
|
|
|
APPID (FK) |
varchar(12) |
NULLS |
|
(Many) to (One) |
|
|
TICK |
int |
NULL |
SLXCONTRACTSYNCLOG_TICK (IE) |
|
|