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_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the payment information was updated or deleted (date only) |
||||
| UPDATED_SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who updated or deleted the payment information |
||||
| UPDATED_SYSTEM_USER_NAME | varchar | 511 | √ | null |
|
|
The name 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 |
||||
| UPDATED_WORKSTATION_NAME | varchar | 45 | √ | null |
|
|
The name 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 |
||||
| CUSTOMER_NAME | varchar | 511 | √ | null |
|
|
The name of the customer that the payment information belongs to |
||||
| CUSTOMER_NAME_LAST_FIRST | varchar | 512 | √ | null |
|
|
The name of the customer that the payment information belongs to (last name, first name) |
||||
| COMPANY_ID | int | 4 | √ | null |
|
|
The company ID that the payment information belongs to |
||||
| COMPANY_NAME | varchar | 255 | √ | null |
|
|
The name of the company that the payment information belongs to |
||||
| CARD_TYPE_ID | int | 4 | √ | null |
|
|
Type ID of credit card (if known) |
||||
| CARD_TYPE | varchar | 50 | √ | null |
|
|
Type 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_DATE_ONLY | date | 20 | √ | null |
|
|
The last updated date (date only) |
||||
| LAST_UPDATED_SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who last updated the payment information |
||||
| LAST_UPDATED_SYSTEM_USER_NAME | varchar | 511 | √ | null |
|
|
The name 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 |
||||
| LAST_UPDATED_WORKSTATION_NAME | varchar | 45 | √ | null |
|
|
The name of the workstation where the payment information was last updated |
||||
| 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 |