Subscriber Tran Import
The following data elements can be used with the “SubTranImprt” usage.
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
Yes/No flag to set the 'AutoRenewSubscription.SendStatement' flag
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.
Last updated
