Database – Customer Payment Profile Information (payment_account_entity)
Description
This table holds information about payment accounts that are linked to customers. Each account is associated with a payment profile. Primary payment profile data is stored in Secure Payments and payment profiles are referenced through tokens. Payment profile tokens are not held in this table, but this table can be linked to the credit_card_entity or checking_account_entity tables through an ID in this table. LoanPro will never show full credit card numbers, nor is there a database location where bank account numbers can be retrieved consistently. For information on updating payment profiles using the API, see API - Update Payment Profile.
Common Uses
This table is commonly used to find:
- Customer payment account IDs
- Payment profile priority (primary, secondary)
Column | Data Type | Column Info | Value Notes |
id | int(11) | The ID of the payment account. This is the ID for the record in this table but is not the ID in Secure Payments. | |
entity_id | int(11) | This is the ID of the associated entity. Payment accounts should be associated with customers. Customers can be found in the customer_entity table. | |
entity_type | varchar(100) | This is the type of the associated entity. Payment accounts should be associated with customers so, most of the time, the value of this field will be Entity.Customer. | |
import_id | varchar(15) | If payment accounts were imported into LoanPro, and an import ID was assigned, this field holds that ID. | |
title | varchar(100) | This is the title or name of the payment method. | |
credit_card_id | int(11) | This is the ID of the associated credit or debit card. Credit and debit cards can be found in the credit_card_entity table. The credit_card_entity table contains the Secure Payments token for the profile but won't give card details. | |
checking_account_id | int(11) | This is the ID of the associated bank account. Bank accounts can be found in the checking_account_entity table. The checking_account_entity table contains the Secure Payments token for the profile but won't give account details. | |
type | varchar(100) | This is the payment account type of either bank account or credit/debit card. |
|
deleted | tinyint(4) | This shows whether the payment account has been marked as deleted. | 1 - yes, 0 - no |
created | timestamp | This is a timestamp of when the payment account was created. | |
lastUpdated | timestamp | This is a timestamp of when the payment account was last updated. | |
is_primary | tinyint(1) | This shows whether this payment account is marked as the customer's primary payment account. | 1 - yes, 0 - no |
is_secondary | tinyint(1) | This shows whether this payment account is marked as the customer's secondary payment account. | 1 - yes, 0 - no |
active | tinyint(1) | This shows whether this record is active. | 1 - yes, 0 - no |
visible | tinyint(1) | This field shows whether the payment profile is visible or not. | 1 - yes, 0 - no |