While this table does not have a field defined as a primary key, the INTEGRATIONID field should be unique and considered a primary key.
Added in Version 8.1
The INTEGRATION table maintains a list of third party applications that provide a means of synchronization with Infor CRM.
|
|
While this table does not have a field defined as a primary key, the INTEGRATIONID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
INTEGRATIONID |
STANDARDID |
NOT NULL |
INTEGRATION_PRIMARY (AK) |
(One) to (Many) |
|
|
(One) to (Many) |
BACKOFFICE.INTEGRATIONID | ||||
| (One) to (Many) | |||||
|
(One) to (Many) |
INTEGRATIONCONFIGGROUP.INTEGRATIONID | ||||
|
(One) to (Many) |
|||||
|
(Many) to (One) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
CREATEUSER (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
| NAME |
varchar (128) |
NULLS |
|||
| AUTHTYPE |
varchar (64) |
NULLS |
|||
| ENABLED |
varchar (1) |
NULLS |
|||
| SYNCABLE |
varchar (1) |
NULLS |
|||
| SUPPORTSSCHEMAREQUEST |
varchar (1) |
NULLS |
|||
| SYNCHANDLER |
varchar (128) |
NULLS |
|||
| SYNCMETHOD |
varchar (64) |
NULLS |
|||
| LINKTYPE |
varchar (32) |
NULLS |
|||
| SYNCINTERVAL |
Int |
NULLS |
|||
| SYNCSTARTTIME |
datetime |
NULLS |
|||
| SYNCENDTIME |
datetime |
NULLS |
|||
| SYNCORDER |
Smallint |
NULLS |
|||
| VERSION |
varchar (32) |
NULLS |
|||
| ADMINEMAILADDRESS |
varchar (128) |
NULLS |
|||
| ADMINEMAILPASSWORD |
varchar (128) |
NULLS |
|||
| ADMINUSERNAME |
varchar (64) |
NULLS |
|||
| DOMAIN |
varchar (64) |
NULLS |