Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
|
| CREDITCARD_UPDATE_ID | int | 4 | null |
|
|
Credit Card update ID |
||
| AR_SCHEDULE_HEADER_ID | int | 4 | √ | null |
|
|
The ID of the payment plan that this payment or refund is related to |
|
| MEMBERSHIP_ID | int | 4 | √ | null |
|
|
The ID of the membership that this payment or refund is related to |
|
| CAMPAIGN_DONATION_ID | int | 4 | √ | null |
|
|
The ID of the scheduled campaign donation that this payment or refund is related to |
|
| AMS_ACCOUNT_ID | varchar | 100 | √ | null |
|
|
Internal ID locator for the credit card |
|
| CC_NUMBER | varchar | 20 | √ | null |
|
|
Last four of the old credit card |
|
| CC_EXPIRY | varchar | 10 | √ | null |
|
|
Expiry of the old credit card |
|
| CC_TYPE | varchar | 10 | √ | null |
|
|
Credit Card type |
|
| AMS_SENT | varchar | 10 | √ | null |
|
|
Was the updated credit card information sent to AMS |
|
| AMS_SENT_ON | datetime | 16,3 | √ | null |
|
|
Date on which updated credit card information was sent to AMS |
|
| UPDATED_CC_NUMBER | varchar | 20 | √ | null |
|
|
Last four of the new credit card |
|
| UPDATED_CC_EXPIRY | varchar | 10 | √ | null |
|
|
Expiry of the new credit card |
|
| UPDATED_CC_TYPE | varchar | 10 | √ | null |
|
|
Updated credit card type |
|
| UPDATED_STATUS | varchar | 2000 | √ | null |
|
|
Status of the update |
|
| UPDATED_ON | datetime | 16,3 | √ | null |
|
|
Date and time credit card was updated |
|
| UPDATED_ACTION_TYPE | varchar | 2 | √ | null |
|
|
Updated credit card action type |
|
| CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer that the payment or refund authorization request was for |
|
| COMPANY_ID | int | 4 | √ | null |
|
|
The ID of the company that the payment or refund authorization request was for |
|
| INSERTED_ON | datetime | 16,3 | √ | null |
|
|
Date and time when the record was inserted into the table |
|
| 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 |
||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CREDITCARD_UPDATES | Primary key | Asc/Asc | CREDITCARD_UPDATE_ID + ORG_ID |
| CREDITCARD_UPDATES_CREDITCARD_UPDATE_ID_IX | Performance | Asc | CREDITCARD_UPDATE_ID |