Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| SAVED_CREDIT_CARD_HISTORY_ID | int | 4 | null |
|
|
Saved credit card history ID |
|||||
| SAVED_CREDIT_CARD_ID | int | 4 | √ | null |
|
|
Saved credit card ID |
||||
| UPDATED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the payment information was updated or deleted |
||||
| UPDATED_SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who updated or deleted the payment information |
||||
| UPDATED_WORKSTATION_ID | int | 4 | √ | null |
|
|
The ID of the workstation where the payment information was updated or deleted |
||||
| IS_DELETED | varchar | 5 | √ | null |
|
|
Whether this payment information has been deleted and is no longer saved for further use (Yes/No) |
||||
| 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 |
||||
| 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_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_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 |
||||
| LAST_UPDATED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The last updated date and time |
||||
| LAST_UPDATED_SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who last updated the payment information |
||||
| LAST_UPDATED_WORKSTATION_ID | int | 4 | √ | null |
|
|
The ID of the workstation where the payment information was last updated |
||||
| 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_CARD_HISTORY_SAVED_CREDIT_CARD_HISTORY_ID_ORG_ID_PK | Primary key | Asc/Asc | SAVED_CREDIT_CARD_HISTORY_ID + ORG_ID |
| SAVED_CREDIT_CARD_HISTORY_CARD_TYPE_ID_IX | Performance | Asc | CARD_TYPE_ID |
| SAVED_CREDIT_CARD_HISTORY_COMPANY_ID_IX | Performance | Asc | COMPANY_ID |
| SAVED_CREDIT_CARD_HISTORY_CUSTOMER_ID_IX | Performance | Asc | CUSTOMER_ID |
| SAVED_CREDIT_CARD_HISTORY_LAST_UPDATED_SYSTEMUSER_ID_IX | Performance | Asc | LAST_UPDATED_SYSTEMUSER_ID |
| SAVED_CREDIT_CARD_HISTORY_LAST_UPDATED_WORKSTATION_ID_IX | Performance | Asc | LAST_UPDATED_WORKSTATION_ID |
| SAVED_CREDIT_CARD_HISTORY_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| SAVED_CREDIT_CARD_HISTORY_SAVED_CREDIT_CARD_ID_IX | Performance | Asc | SAVED_CREDIT_CARD_ID |
| SAVED_CREDIT_CARD_HISTORY_UPDATED_SYSTEMUSER_ID_IX | Performance | Asc | UPDATED_SYSTEMUSER_ID |
| SAVED_CREDIT_CARD_HISTORY_UPDATED_WORKSTATION_ID_IX | Performance | Asc | UPDATED_WORKSTATION_ID |