Account Statement Export

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

Data Element	Description
Account Group Address Line (1-6)	Address associated with the account group.
Account Group ID	The account group to which the account belongs.
Account ID	The ID of the account.
Age Balance	The balance due for an aging period.
Age Current	The current balance due.
Age Periods 1-4	Up to four aging periods can be included.
Age Unapplied	The unapplied amount for an aging period.
Area Code	Area code portion of the account’s phone number.
Area ID	The ID of the bill area.
Balance Type	Indicates if the account has a credit, debit, or zero balance.
Bill Source ID	The bill source (group of accounts being billed together, such as Carrier, Dealer, NIE).
Building	The building identifier, such as “Building 212”.
Charges Detail (Parent Element)	Details about a charge (parent element). Also from the following child elements: Account ID, Amount, Bill Batch ID, Carrier ID, Charge Batch ID, Charge Code ID, Charge Date, Charge Type ID, Delivery Route ID, Delivery Schedule ID, Description, Entity ID, Entity Type, GL Account ID, Line Feed, Literal Value, Product ID, Quantity, Rate Code ID, Remarks, Retail Amount, Reversal, Route ID, Route Name, Transportation GL Account ID, and Unit Rate.
City ID	The city.
CollectorID	ID of the collector assigned to the account.
Company ID	The ID of the company.
Complex	The name of the complex, such as “Oak Park Apartments”.
Country ID	The country.
County ID	The county.
Credit Card On File	Indicates whether the account has a credit card number on file.
Distrib Zone ID	ID of the distribution zone.
District ID	ID of the district.
Drop Order	Drop order.
Extension	The local extension of the phone number.
First Name	The first name on the account.
Historical Aging Detail	Aging detail (parent element). Also choose from the following child elements: Account ID, Age Balance, Age Current, Age Period 1-12, Age Unapplied, Bill Date, Bill Source ID, Company ID, Last Bill Amount, Last Bill Date, Line Feed, and Literal Value.
Honorific ID	Occupant’s honorific (name suffix)
House Number	The house number for this address, such as “103” for the address “103 Main Street”.
House Number Modifier	Modifier of the house number, like “½” in the address “103 ½ Main St”.
Invoice Detail	Invoice detail (parent element). Also choose from the following child elements: Account ID, Balance Due, Bill Batch ID, Bill Source ID, Company ID, Discount Amount, Discount Date, Due Date, Invoice Date, Invoice Number, Line Feed, Literal Value, and Original Amount.
Last Name	The account’s last name.
Line Feed	A line feed to start a new line.
Literal Value	A literal value.
Location	Description of the location.
Middle Initial	Occupant’s middle initial.
Name Address Lines 1-6	Up to six lines of name and address information in an unparsed format.
Occupant Salutation ID	Occupant’s title, such as “Mr.”
Other Name	Account’s other name
Other Name Usage	Account’s other name usage
Payment Detail	Details about a payment (parent element). Also select from the following child elements: Account ID, Adjustment Amount, Adjustment ID, Bank ID, Bill Batch ID, Bill Source ID, Cash Amount, Cash Batch ID, Check Number, Company ID, Discount Amount, Invoice Number, Line Feed, Literal Value, Lockbox ID, Payment Amount, Payment Date, Payment Method, Tran Type, and Unapplied Amount.
Phone	The account’s phone number.
Post Directional	Street name post-modifier, such as the “N” in “Main St N”.
Pre Directional	Street name pre-modifier, such as the “N” in “N Main St”.
Product ID	ID of the product.
Region ID	ID of the region.
Remit To Address Lines 1-7	The remit-to address.
Route ID	ID of the route.
Route Name	Name of the route.
Run Date	Date of the export.
State ID	The state.
Street Name	Street name for this address, such as “Main” for the “103 Main Street” address. This will be the PO box if the address has one.
Street Suffix ID	The suffix street direction, such as “N” in “1234 Main St N”.
Truck ID	ID of the truck.
Truck Name	Name of the truck.
Truck Sequence ID	ID of the truck sequence.
Unit Designator ID	Enter the type of unit, such as Apt, Lot, Room, Suite.
Unit Number	The number of the unit, such as the “20” in “Apt 20”.
ZIP Bar Code, ZIP Code, ZIP Extension	Zip code, Zip code + 4, and Zip bar code.