Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
|||||||
| SAVED_CREDIT_CARD_ID | int | 4 | √ | null |
|
|
Saved credit card ID |
|||||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
The customer ID that the payment information belongs to |
|||||||
| COMPANY_ID | int | 4 | √ | null |
|
|
The company ID that the payment information belongs to |
|||||||
| SAVED_CARD_NAME | varchar | 100 | √ | null |
|
|
Saved name for the saved credit card or electronic payment information |
|||||||
| CARD_TYPE_ID | int | 4 | √ | null |
|
|
Type ID of credit card (if known) |
|||||||
| CARD_NUMBER | varchar | 20 | √ | null |
|
|
Masked credit card account number |
|||||||
| CARD_EXPIRATION | varchar | 10 | √ | null |
|
|
Credit card expiration date |
|||||||
| BANK_ACCOUNT_TYPE | varchar | 1 | √ | null |
|
|
Bank account type for ECP payments |
|||||||
| BANK_ROUTING_NUMBER | varchar | 50 | √ | null |
|
|
Masked bank routing number for ECP payments |
|||||||
| BANK_ACCOUNT_NUMBER | varchar | 50 | √ | null |
|
|
Masked bank account number for ECP payments |
|||||||
| IS_SECONDARY_PAYMENT | varchar | 5 | √ | null |
|
|
Whether this payment information is designated as the backup payment type (Yes/No) |
|||||||
| LAST_UPDATED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The last updated date and time |
|||||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who last updated the payment information |
|||||||
| WORKSTATION_ID | int | 4 | √ | null |
|
|
The ID of the workstation where the payment information was last updated |
|||||||
| EXCLUDE_CREDIT_CARD | varchar | 5 | √ | null |
|
|
Whether this payment information should be excluded from display on payment screens (Yes/No) |
|||||||
| IS_RETIRED | varchar | 5 | √ | null |
|
|
Whether this payment information has been retired from further use (Yes/No) |
|||||||
| UNKNOWN_WALLET_ACCOUNT | varchar | 5 | √ | null |
|
|
Whether the unmasked payment information has been purged from the saved wallet in the payment processing system (Yes/No) |
|||||||
| AUTO_UPDATES_DISABLED | varchar | 5 | √ | null |
|
|
Whether automatic updates of credit card number and expiration date have been suspended for this saved payment information (Yes/No) |
|||||||
| AUTO_UPDATES_DISABLED_REASON | varchar | 50 | √ | null |
|
|
The reason that automatic updates of credit card number and expiration date have been suspended for this saved payment information |
|||||||
| 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) |
|---|---|---|---|
| SAVED_CREDIT_CARDS_ACTIVE_HUB_KEY_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| SAVED_CREDIT_CARDS_COMPANY_ID_IX | Performance | Asc | COMPANY_ID |
| SAVED_CREDIT_CARDS_CUSTOMER_ID_IX | Performance | Asc | CUSTOMER_ID |
| SAVED_CREDIT_CARDS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| SAVED_CREDIT_CARDS_SAVED_CREDIT_CARD_ID_ORG_ID_UQ | Must be unique | Asc/Asc | SAVED_CREDIT_CARD_ID + ORG_ID |
| SAVED_CREDIT_CARDS_SYSTEMUSER_ID_IX | Performance | Asc | SYSTEMUSER_ID |
| SAVED_CREDIT_CARDS_WORKSTATION_ID_IX | Performance | Asc | WORKSTATION_ID |