Subscriber Tran Import

The following data elements can be used with the “SubTranImprt” usage.

Data Element	Description
AAM Column ID	Subscriber’s AAM category.
Account Holder Name	Name on the credit card or bank account.
Account Number	Bank draft subscriber’s bank account number.
Account Type	Bank draft subscriber’s account type (checking or savings).
Adjustment Amount	Subscriber cash payment adjustment; for example, 5.00 for a t-shirt.
Authorization Number	Payment authorization number, typically supplied for credit card payments.
Auto Pay Length	Payment length for auto renew subscriber.
Auto Pay Send Renewal	Flag that determines whether a renewal notice is sent to auto renew subscribers.
Auto Pay Term	Payment term for auto renew subscriber (for example “week”)
Auto Pay Type	Payment type for auto renew subscribers (credit card, bank draft, PayPal, or none)
Bank Client Type	Bank draft auto renew subscriber’s bank client type (business or personal)
Bank Number	Bank number for bank drafts.
Bill Address ID	Address ID of bill-to address.
Billing Method	Subscriber’s billing method.
Billing Period	Subscriber’s auto renew billing group.
Bill Occupant ID	Occupant ID of bill-to occupant.
City Exempt Reason Code	Tax exempt reason code for city tax.
City ID	Address city.
Country Exempt Reason Code	Tax exempt reason code for country tax.
Country ID	Address country.
County Exempt Reason Code	Tax exempt reason code for county tax.
County ID	Address county.
Credit Card Expires	Credit card expire date.
Credit Card Type	The credit card type (Visa, Mastercard, etc.)
Credit Card Vault ID	The vault ID, used only for off-site credit card storage.
Date Last Renewal Sent	Date last renewal notice or invoice was sent to subscriber.
Email Address	Occupant’s email address.
File Date	The date the file was created.
File Record Count	The total number of records in the file.
Filler	Filler fields will be blank.
First Name	Occupant’s first name.
Honorific ID	Occupant’s honorific (name suffix)
Last Name	Occupant’s last name.
Mailing Address ID	ID of the mailing address.
Mailing Occupant ID	ID of the mailing occupant.
Masked Credit Card Number	The credit card number with all but the last four digits masked (replaced with “*”). Used only for off-site credit card storage.
Middle Initial	Occupant’s middle initial.
Number of Renewals Sent	Number of renewal notices or invoices sent to the subscriber so far in the current subscription period.
Occupant Salutation ID	Occupant’s title, such as “Mr.”
Purchase Number	Purchase number entered with transaction.
Rate Code ID	Subscriber’s rate.
Receive Bonus Days	Bonus day flag for subscriber (yes/no).
Record Identifier**	Field that identifies the record type, for example “D” to indicate a detail record.
Remarks	Remarks entered with transaction.
Renewal Delivery Method	Method of delivering subscriber’s renewal (carrier, mail, ebill)
Send Invoice, Send Renewal	Send invoice and renewal flags, entered during starts or billing changes (yes/no).
State Exempt Reason Code	Tax exempt reason code for state tax.
State ID	Address state.
Subscription ID*	Subscriber’s subscription ID.
Tip Amount	Auto renew tip amount.
Tran Date	Transaction date for subscriber transaction.
ZIP Code, ZIP Extension	Address Zip code and Zip code + 4.

* Field is required

** Field is required if a record identifier is entered on the record type setup screen.