While this table does not have a field defined as a primary key, the SYNCJOBID field should be unique and considered a primary key.
Added in Version 7.5.4
The SYNCJOB table stores information specific to the instance of an executed synchronization cycle. Added for accounting integration functionality. The table is used for accounting integration functionality.
|
|
While this table does not have a field defined as a primary key, the SYNCJOBID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
SYNCJOBID |
char(12) |
NOT NULL |
SYNCJOB_PRIMARY (AK) |
(One) to (Many) |
|
|
|
|||||
|
JOBNAME |
varchar(64) |
NULLS |
|
|
|
|
RESOURCEKIND |
varchar(32) |
NULLS |
|
|
|
|
ENDPOINT |
varchar(256) |
NULLS |
|
|
|
|
STARTTIME |
datetime |
NULLS |
|
|
|
|
ENDTIME |
datetime |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
INTEGRATIONID (FK) |
char(12) |
NULLS |
|
(Many) to (One)
|
|
|
STATUS |
varchar(64) |
NULLS |
|
|
|