GLOBALCHANGETRACKING Table

Added in Version 8.1

The GLOBALCHANGETRACKING table stores the history for all changes made to specific tables by the triggers on those tables. Used by Outlook sync functionality to retrieve any changes (Inserts, Updates, or Deletes) that were made to Infor CRM.

While this table does not have a field defined as a primary key, the TABLENAME, ENTITYID, CHANGETYPE, and USERID fields should be unique and together should be considered a primary key.
If an index entry appears in multiple table columns, then it is a composite index. A composite index requires multiple columns in order to create a unique index.

Legend

Field	Datatype (Length)	Allow Nulls	Indexes	Relationship	Related Table and Field
CHANGEKEY	varchar (36)	NOT NULL
TABLENAME	varchar (32)	NOT NULL	GLOBALCHANGETRACKING_COMP_KEY (AK)
ENTITIYID	varchar (12)	NOT NULL	GLOBALCHANGETRACKING_ENTITYID (IE) GLOBALCHANGETRACKING_COMP_KEY (AK)
CHANGETYPE	Integer	NOT NULL	GLOBALCHANGETRACKING_COMP_KEY (AK) GLOBALCHANGETRACKING_CHGTYPE
USERID	varchar (12)	NULLS	GLOBALCHANGETRACKING_COMP_KEY (AK)
APPID	varchar (12)	NULLS		(Many) to (One)	APPIDMAPPING.APPID
DIGESTTICK	Int	NULLS
CREATEDATE	datetime	NULLS
GLOBALSYNCID	varchar (36)	NULLS


TICK	Integer	NOT NULL