Domain - External References

Domain description

This domain represents the links between entities like Movements or Operations and extra information stored in Third-Party systems.

1 record = 1 external reference in the external system linked to a SecuTix's operation or movement. Also deleted entities will be recorded temporarily in the domain for delta building.

A record is identified in a unique way by means of the attribute: T_EXTERNAL_REF_ID. 

The attribute DELETED notes if the record is present in the system ('F') or it has been deleted ('T'). In case of deleted external references, only the attribute T_EXTERNAL_REF_ID, LAST_UPDATE, and DELETED will remain. LAST_UPDATE shows the deletion date of those records flagged as deleted.

The records in deleted state will be removed once per week in the regular full refresh of the domains. 

This domain is available since Bishorn V1.5.

Domain's columns description

The following link contains more information on the data of the domain: D_TICKET_EXTERNAL_REFERENCES