WARNING: The TrackAbout MetaWiki has been deprecated and is no longer being updated.
Please visit our new TrackAbout Knowledge Base at https://supportkb.trackabout.com for the most-up-to-date documentation on TrackAbout and TrackAbout Mobile.
Difference between revisions of "AR Export"
Jump to navigation
Jump to search
(Created page with '=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 onc…') |
|||
| Line 7: | Line 7: | ||
== File Name == | == File Name == | ||
| + | Here is an example file name: AR_2010.05.03.20.57.16_1200_18051.08.txt | ||
| + | |||
The file name is built up of these components separated by underscore delimeters: | The file name is built up of these components separated by underscore delimeters: | ||
| − | |||
*Prefix: AR | *Prefix: AR | ||
| − | *Date: 2010.05.03.20.57.16 (This is equivalent to 5/3/2010 20:57:16 | + | *Date: 2010.05.03.20.57.16 (This is equivalent to 5/3/2010 20:57:16) |
*Number of rows: 1200 | *Number of rows: 1200 | ||
*Grand total for "Total" column: $18,051.08 | *Grand total for "Total" column: $18,051.08 | ||
*File type: .txt | *File type: .txt | ||
| − | + | This creates a unique file name and also provides total fields that can be used by the business system to ensure that it read in all rows in the file. | |
| + | |||
== File Format == | == File Format == | ||
* File is a comma delimited ASCII text file | * File is a comma delimited ASCII text file | ||
| − | + | * Fields in file | |
| − | |||
{| class="wikitable" border="1" cellpadding="5" cellspacing="0" | {| class="wikitable" border="1" cellpadding="5" cellspacing="0" | ||
| Line 65: | Line 66: | ||
|} | |} | ||
| − | Example rows in file | + | == Example Data == |
| + | Here is an example of the rows in the file. | ||
R409063,10024,90.08,04/30/2010,7.14,LABF,05/30/2010 | R409063,10024,90.08,04/30/2010,7.14,LABF,05/30/2010 | ||
R409064,10043,1080.00,04/30/2010,.00,TXGC,05/30/2010 | R409064,10043,1080.00,04/30/2010,.00,TXGC,05/30/2010 | ||
Revision as of 14:00, 7 May 2010
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
Here is an example file name: AR_2010.05.03.20.57.16_1200_18051.08.txt
The file name is built up of these components separated by underscore delimeters:
- Prefix: AR
- Date: 2010.05.03.20.57.16 (This is equivalent to 5/3/2010 20:57:16)
- Number of rows: 1200
- Grand total for "Total" column: $18,051.08
- File type: .txt
This creates a unique file name and also provides total fields that can be used by the business system to ensure that it read in all rows in the file.
File Format
- File is a comma delimited ASCII text file
- Fields in file
| Field | Example | Format | Notes |
|---|---|---|---|
| Invoice number | R123456 | 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 | 123456 | 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 | TRAX | 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. |
Example Data
Here is an example of the rows in the file.
R409063,10024,90.08,04/30/2010,7.14,LABF,05/30/2010 R409064,10043,1080.00,04/30/2010,.00,TXGC,05/30/2010 R409065,10056,85.74,04/30/2010,7.44,LADC,05/30/2010 R409066,10058,19.00,04/30/2010,1.60,LACQ,05/30/2010 R409067,10070,37.92,04/30/2010,3.12,LACG,05/30/2010