Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
||||
| MERGED_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the merge occurred (date only) |
||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who performed the merge |
||||
| SYSTEM_USER_NAME | varchar | 511 | null |
|
|
The name of the system user who performed the merge |
|||||
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||
| LAST_SYNC_TIME | datetime | 16,3 | null |
|
|
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 |