# Subscriber Tran Import

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

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

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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.navigaglobal.com/circulation-user-manual/14-appendix-b-file-formats/file-mapping-data-elements/subscriber-tran-import.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
