Table Definitions: Credit Card Transactions

column	type	null	unique	references	referenced_by	since_version	description
pkey	pkey	false	true		transactions.credit_card_transaction	1.29	the unique ID of this transaction
processor_id	string	false	false	credit_card_processors.provider_id		1.29	the name of the processor used for this transaction
accounting	accounting	false	false	businesses.accounting		1.29	the accounting code for the source of this transaction
group_name	string	true	false			1.29	the application-provided grouping for this transaction
test_mode	boolean	false	false			1.29	indicates this is a test transaction
duplicate_window	int	false	false			1.29	the number of seconds for duplicate transaction detection
order_number	string	true	false			1.29	the merchant-provided order number for this transaction
amount	money	false	false			1.83.0	the amount of the transaction
taxAmount	money	true	false			1.83.0	the tax amount of the transaction
tax_exempt	boolean	false	false			1.29	the taxExempt flag for this transaction
shippingAmount	money	true	false			1.83.0	the shipping amount for this transaction
dutyAmount	money	true	false			1.83.0	the duty amount for this transaction
shipping_first_name	string	true	false			1.29	the shipping first name
shipping_last_name	string	true	false			1.29	the shipping last name
shipping_company_name	string	true	false			1.29	the shipping company name
shipping_street_address1	string	true	false			1.29	the shipping address line 1
shipping_street_address2	string	true	false			1.29	the shipping address line 2
shipping_city	string	true	false			1.69	the shipping city
shipping_state	string	true	false			1.69	the shipping state
shipping_postal_code	string	true	false			1.69	the shipping postal code
shipping_country_code	string	true	false	country_codes.code		1.69	the shipping two-digit ISO 3166-1 alpha-2 country code
email_customer	boolean	false	false			1.29	the flag indicating the API should generate an email to the customer
merchant_email	email	true	false			1.29	the email address of the merchant
invoice_number	string	true	false			1.29	the merchant-provided invoice number
purchase_order_number	string	true	false			1.29	the merchant-provided purchase order number
description	string	true	false			1.29	the merchant-provided description of this transaction
credit_card_created_by	username	false	false	business_administrators.username		1.29	the business administrator account that provided this credit card
credit_card_principal_name	string	true	false			1.29	the application-provided principal who provided this credit card
credit_card_accounting	accounting	false	false	businesses.accounting		1.29	the accounting code of the business that provided this credit card
credit_card_group_name	string	true	false			1.29	any application-specific grouping
credit_card_provider_unique_id	string	true	false			1.29	the unique ID provided by the merchant services provider storage mechanism
credit_card_masked_card_number	string	false	false			1.29	the masked card number
creditCard.expirationMonth	short	true	false			1.82.0	the card expiration month
creditCard.expirationYear	short	true	false			1.82.0	the card expiration year
credit_card_first_name	string	false	false			1.29	the first name of the card holder
credit_card_last_name	string	false	false			1.29	the last name of the card holder
credit_card_company_name	string	true	false			1.29	the company name for the credit card
credit_card_email	email	true	false			1.29	the email address of the card holder
credit_card_phone	phone	true	false			1.29	the phone number of the card holder
credit_card_fax	phone	true	false			1.29	the fax number of the card holder
creditCard.customerId	string	true	false			1.82.1	the merchant-specific unique customer ID
credit_card_customer_tax_id	string	true	false			1.29	the tax ID of the card holder
credit_card_street_address1	string	false	false			1.29	the street address of the card holder (line 1)
credit_card_street_address2	string	true	false			1.29	the street address of the card holder (line 2)
credit_card_city	string	false	false			1.69	the city of the card holder
credit_card_state	string	true	false			1.69	the state/province/prefecture of the card holder
credit_card_postal_code	string	true	false			1.69	the postal code of the card holder
credit_card_country_code	string	false	false	country_codes.code		1.69	the two-digit ISO 3166-1 alpha-2 country code of the card holder
credit_card_comments	string	true	false			1.29	any comments associated with the credit card
authorization_time	time	false	false			1.29	the time the authorization was attempted
authorization_username	username	false	false	business_administrators.username		1.29	the username of the business_administrator account that processed the transaction
authorization_principal_name	string	true	false			1.29	an application-provided identity of the user who initiated the transaction
authorization_communication_result	string	true	false			1.29	the authorization communication result
authorization_provider_error_code	string	true	false			1.29	the provider-specific error code
authorization_error_code	string	true	false			1.29	the provider-neutral error code
authorization_provider_error_message	string	true	false			1.29	the provider-specific error message
authorization_provider_unique_id	string	true	false			1.29	the per-provider unique ID
authorizationResult.providerReplacementMaskedCardNumber	string	true	false			1.82.0	the provider-specific replacement masked card number
authorizationResult.replacementMaskedCardNumber	string	true	false			1.82.0	the replacement masked card number
authorizationResult.providerReplacementExpiration	string	true	false			1.82.0	the provider-specific replacement expiration date
authorizationResult.replacementExpirationMonth	short	true	false			1.82.0	the replacement card expiration month
authorizationResult.replacementExpirationYear	short	true	false			1.82.0	the replacement card expiration year
authorization_provider_approval_result	string	true	false			1.29	the provider-specific approval result
authorization_approval_result	string	true	false			1.29	the provider-neutral approval result
authorization_provider_decline_reason	string	true	false			1.29	the provider-specific decline reason
authorization_decline_reason	string	true	false			1.29	the provider-neutral decline reason
authorization_provider_review_reason	string	true	false			1.29	the provider-specific review reason
authorization_review_reason	string	true	false			1.29	the provider-neutral review reason
authorization_provider_cvv_result	string	true	false			1.29	the provider-specific CVV result
authorization_cvv_result	string	true	false			1.29	the provider-neutral CVV result
authorization_provider_avs_result	string	true	false			1.29	the provider-specific AVS result
authorization_avs_result	string	true	false			1.29	the provider-neutral AVS result
authorization_approval_code	string	true	false			1.29	the approval code
capture_time	time	true	false			1.29	the time the capture was attempted
capture_username	username	true	false	business_administrators.username		1.29	the username of the business_administrator account that processed the capture
capture_principal_name	string	true	false			1.29	an application-provided identity of the user who initiated the capture
capture_communication_result	string	true	false			1.29	the capture communication result
capture_provider_error_code	string	true	false			1.29	the provider-specific error code
capture_error_code	string	true	false			1.29	the provider-neutral error code
capture_provider_error_message	string	true	false			1.29	the provider-specific error message
capture_provider_unique_id	string	true	false			1.29	the per-provider unique ID
void_time	time	true	false			1.29	the time the void was attempted
void_username	username	true	false	business_administrators.username		1.29	the username of the business_administrator account that processed the void
void_principal_name	string	true	false			1.29	an application-provided identity of the user who initiated the void
void_communication_result	string	true	false			1.29	the void communication result
void_provider_error_code	string	true	false			1.29	the provider-specific error code
void_error_code	string	true	false			1.29	the provider-neutral error code
void_provider_error_message	string	true	false			1.29	the provider-specific error message
void_provider_unique_id	string	true	false			1.29	the per-provider unique ID
status	string	false	false			1.29	the status of the transaction

TABLE NAME

DESCRIPTION

COLUMNS