Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
||||
| CUSTOMER_ID | Unknown | 0 | null |
|
|
||||||
| CUSTOMER_MERGE_LOG_ID | int | 4 | √ | null |
|
|
Merged customer log ID |
||||
| MERGED_CUSTOMER_ID | int | 4 | √ | null |
|
|
The prior ID of the customer that was merged into a different or new customer |
||||
| MERGED_FIRST_NAME | varchar | 50 | √ | null |
|
|
The merged customer’s first name |
||||
| MERGED_LAST_NAME | varchar | 50 | √ | null |
|
|
The merged customer’s last name |
||||
| MERGED_ADDRESS_1 | varchar | 75 | √ | null |
|
|
The merged customer’s address line 1 |
||||
| MERGED_ADDRESS_2 | varchar | 75 | √ | null |
|
|
The merged customer’s address line 2 |
||||
| MERGED_CITY | varchar | 50 | √ | null |
|
|
The merged customer’s city |
||||
| MERGED_STATE | varchar | 15 | √ | null |
|
|
The merged customer’s state |
||||
| MERGED_ZIP_CODE | varchar | 10 | √ | null |
|
|
The merged customer’s zip or postal code |
||||
| MERGED_HOME_PHONE | varchar | 32 | √ | null |
|
|
The merged customer’s home phone number |
||||
| MERGED_WORK_PHONE | varchar | 50 | √ | null |
|
|
The merged customer’s work phone number |
||||
| NEW_CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer that the merged customer was merged in to |
||||
| NEW_CUSTOMER_FIRST_NAME | varchar | 50 | √ | null |
|
|
The new customer first name (at the time of the merge) |
||||
| NEW_CUSTOMER_LAST_NAME | varchar | 50 | √ | null |
|
|
The new customer last name (at the time of the merge) |
||||
| MERGED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the merge occurred |
||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who performed the merge |
||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
||||
| LAST_SYNC_TIME | datetime | 16,3 | (getdate()) |
|
|
Date and time Hub record was last modified |
|||||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
The Hub sync process ID |
||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| CUSTOMER_MERGE_LOG_ACTIVE_HUB_KEY_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| CUSTOMER_MERGE_LOG_CUSTOMER_MERGE_LOG_ID_ORG_ID_UQ | Must be unique | Asc/Asc | CUSTOMER_MERGE_LOG_ID + ORG_ID |
| CUSTOMER_MERGE_LOG_MERGED_CUSTOMER_ID_IX | Performance | Asc | MERGED_CUSTOMER_ID |
| CUSTOMER_MERGE_LOG_MERGED_DATE_TIME_IX | Performance | Asc | MERGED_DATE_TIME |
| CUSTOMER_MERGE_LOG_NEW_CUSTOMER_ID_IX | Performance | Asc | NEW_CUSTOMER_ID |
| CUSTOMER_MERGE_LOG_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| CUSTOMER_MERGE_LOG_SYSTEMUSER_ID_IX | Performance | Asc | SYSTEMUSER_ID |