AR Export

This export contains AR data for TrackAbout-generated rental invoices.

Transfer Mechanism

• This export is kicked off at the end of a rental run, typically once a month.

• A file is dropped into a TrackAbout-hosted FTP site in a designated folder.

File Name

The file name is built up of these components separated by underscores.

1 - Prefix

AR

2 - Date

2010.05.03.20.57.16 (This is equivalent to 5/3/2010 20:57:16)

3 - Number of rows

1200

4 - Grand total for "Total" column

$18,051.08

5 - File type

.txt

File Format

• File is a comma delimited ASCII text file

• Fields in file

Field	Example	Format	Notes
Invoice number	8001001	Text, Max 255 char	This is the TrackAbout generated rental invoice number. The format will be worked out in advance with the business system to ensure that the invoice number can be used in the business systems AR. Commonly this is done by giving TrackAbout a number range and/or a prefix. For instance "A 7 digit number with the first number set as 9900001" or "A 6 digit number prefixed with 'R' and starting with R010001".
Customer number	23456	Text, Max 30 char	This is the customer number. It will be the same number and format used by the business system.
Total	100.00	Numeric, Two decimal places	The total amount of the rental invoice including taxes. There is no thousands separator and no currency symbol, just the number.
Invoice Date	04/30/2010	Date in format MM/DD/YYYY	Invoice date
Tax amount	6.50	Numeric, Two decimal places	The total amount of tax on the invoice. Includes all tax levels. There is no thousands separator and no currency symbol, just the number.
Tax region	PA01	Text, Max 25 char	This is the tax region set on the customer. It originates from the business system and so should be in a format that works from the business system.
Due Date	05/30/2010	Date in format MM/DD/YYYY	Due date for invoice.