Ac customer payment info

Overview

Customer Payment Info

Accounting Tables

Name	Description	Datatype	Notes
cpi_key	Unique Key	av_key
cpi_cst_key	Customer	av_key
cpi_apm_key	Payment Method	av_key
cpi_cc_number	Credit Card Number	nvarchar(80)
cpi_cc_number_display	Credit Card Display	nvarchar(20)
cpi_cc_expire	Credit Card Expiration Date	nvarchar(7)
cpi_cc_cardholder_name	Credit Card Holder Name	nvarchar(150)
cpi_cc_security_code	Credit Card Security Code	nvarchar(10)
cpi_check_number	Check Number	nvarchar(20)
cpi_name_on_check	Name on Check	nvarchar(150)
cpi_eft_routing_number	Routing Number	nvarchar(20)
cpi_eft_account_number	Account Number	nvarchar(80)
cpi_eft_account_number_display	Account Number Display	nvarchar(20)
cpi_eft_account_type	Bank Account Type	nvarchar(1)
cpi_street	Credit Card/Check Street Address	nvarchar(75)
cpi_city	Credit Card/Check City	nvarchar(40)
cpi_state	Credit Card/Check State	nvarchar(40)
cpi_zip	Credit Card/Check Zip Code	nvarchar(20)
cpi_enc_version	Encryption Version	av_integer
cpi_add_user	Add User	av_user
cpi_add_date	Add Date	av_date
cpi_change_user	Change User	av_user
cpi_change_date	Change Date	av_date
cpi_delete_flag	Delete Flag	av_delete_flag
cpi_entity_key	Entity Key	av_key
cpi_other_preauth_ref_number	Authorization Reference Number	nvarchar	Added in 2008.01
cpi_vault_account	Vault Payment Account ²⁰¹¹	nvarchar(25)	Vault account name. See also `co_customer.cst_vault_account` and `ac_payment_info.pin_vault_account`.

Parent Table	Parent Key	Child Key	Join
`co_customer`	cst_key	cpi_cst_key	cpi_cst_key = cst_key