Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 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 |
|||||||
| 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 |
|||||||
| 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_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_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 |
|||||||
| LAST_UPDATED_DATE_ONLY | date | 20 | √ | null |
|
|
The last updated date (date only) |
|||||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who last updated the payment information |
|||||||
| SYSTEM_USER_NAME | varchar | 511 | null |
|
|
The name 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 |
|||||||
| WORKSTATION_NAME | varchar | 45 | √ | null |
|
|
The name 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 |
|||||||
| 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 |