While this table does not have a field defined as a primary key, the SYNCRESULTSID field should be unique and considered a primary key.
Added in version 7.5.4
The SYNCRESULT table stores the results from a target endpoint when the endpoint attempts to apply changes. The table is used for accounting integration functionality.
|
|
While this table does not have a field defined as a primary key, the SYNCRESULTSID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
SYNCRESULTSID |
char(12) |
NOT NULL |
SYNCRESULTS_PRIMARY (AK) |
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
GLOBALSYNCID |
varchar(36) |
NULLS |
|
|
|
|
APPID (FK) |
varchar(12) |
NULLS |
|
(Many) to (One) |
|
|
ERRORSEQUENCE |
int |
NULLS |
|
|
|
|
RESOURCETYPE |
varchar(255) |
NULLS |
|
|
|
|
STAMP |
datetime |
NULLS |
|
|
|
|
DIAGNOSISCODE |
varchar(255) |
NULLS |
|
|
|
|
APPLICATIONCODE |
varchar(255) |
NULLS |
|
|
|
|
ERRORMESSAGE |
varchar(255) |
NULLS |
|
|
|
|
STACKTRACE |
text |
NULLS |
|
|
|
|
PAYLOADPATH |
varchar(255) |
NULLS |
|
|
|
|
HTTPSTATUS |
varchar(255) |
NULLS |
|
|
|
|
SEVERITY |
varchar(64) |
NULLS |
|
|
|
|
RUNNAME |
varchar(64) |
NULLS |
|
|
|
|
ENTRYINFO |
text |
NULLS |
|
|
|
|
ENTITIYID |
char(12) | NULLS |
|
|
|
|
ENTITYTYPE |
varchar(64) |
NULLS |
|
|
|
|
ENTITYVALUE |
varchar(128) |
NULLS |
|
|
|
|
JOBID |
char(12) | NULLS |
|
|
|
|
SYNCEDFROMID |
char(12) | NULLS |
|
|
|
|
SECCODEID |
char(12) | NULLS |
|
|
|
|
USERID |
char(12) | NULLS |
|
|
|
|
ACTION |
varchar(64) |
NULLS |