CUSTOMEREXTERNALREFERENCE¶
This source table is a linking table between systems. Records in this table link CLASSIC / Back Office Customer records to records in other systems, such as Customers in BOLD / Front Office.
Columns¶
| Column | Data type | Description |
|---|---|---|
BUILDID |
VARCHAR | Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows. |
CDCSTATUS |
VARCHAR | For Avionté internal use only. |
CUSTOMEREXTERNALREFERENCEID |
NUMBER | The identifier for this record, formatted as a GUID. |
CUSTOMERGUID |
VARCHAR | The CLASSIC / Back Office Customer identifier, formatted as a GUID. |
EXTERNALSYSTEMID |
VARCHAR | The identifier for the Customer in a system external to the Avionté CLASSIC / Back Office system. For example, if EXTERNALSYSTMENAME is 'Compas', this field contains the CUSTOMERID from BOLD / Front Office. |
EXTERNALSYSTEMNAME |
VARCHAR | The name of the external system that this record links to. For linking between CLASSIC / Back Office and BOLD / Front Office, this field will contain 'Compas'. |
LASTUPDATEDDATE |
TIMESTAMP_NTZ | The timestamp when the row was last updated. |
OFFSETVALUE |
NUMBER | For Avionté internal use only. |