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 (formerly PCI Wallet), 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.

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

Other

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.

  • paymentAccount.type.checking - Bank Account
  • paymentAccount.type.checking - 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


How did we do?


Powered by HelpDocs (opens in a new tab)