At the time of this writing, there are 2 similar formats in use. The only difference in the formats is how the Area and Location numbers are listed. In one format, the area and location number are combined in one column with a hyphen between them, such as " 12345-01". In the second format, the area number is in one column and the location number is in another column. The CSV file includes columns with BOTH formats. Prior to submitting the Excel file to OKC, be sure to delete the column(s) that don't meet the OKC Excel template format required for your operation.

Locations not operating their system in USD currency:
There must be a record in Edit Exchange Rates with an effective date that is in effect for the data being transmitted. The Exchange record must have "USD" in Field 1 (From Curr Code) and the currency code from the Location File (as entered on Page 3, field 3) in Field 2 (To Curr Code). An example is shown below.

OPTION: EDIT EXCHANGE RATES 1 From Curr Code USD 2 To Curr Code ARS 3 Posting Company 4 Net Vchr Code 5 Effective Date 01-22-13 6 Effective Time 0600 7 Divide by Rate .202839 8 Multiply by Rate 2.000000 1BEGIN 2NEXT 3ERASE 4PREVIOUS 5BACKUP 6 7HELP 8

The TACO File Creation program searches the Exchange Rate file for an effective record as described above. If a valid exchange record is not found, the amounts will not be converted to USD.

The Excel template used by licensees is as follows:

AREA	LOC	TA NUMBER	CKOT DATE	PREPAID IND	RA NUMBER	CX/NS	REV AMT USD	DISC INC	RATE CODE	RES ID	RNTR LAST NAME	RNTR FIRST NAME
4 or 5 digits	2 digits	8 digits	"m/d/yyyy" format only	"Y" or "N" or blank	alphanumeric, no spaces or dashes	"CX", "NS" or blank	must be in $USD	"Y" or "N" or blank	must be an acceptable rate code	alphanumeric, no spaces or dashes	Alpha	Alpha
TEXT	TEXT	TEXT	CUSTOM	TEXT	TEXT	TEXT	GENERAL	TEXT	TEXT	TEXT	TEXT	TEXT

To access the TACO File Creation program, type TACOFILE (RET) at any menu "OPTION:" field or the appropriate line number on the Hertz Data Transmissions Menu. The screen will then display:

OPTION: VENDOR COMMISSIONS TACO FILE 1 Start Date 07-01-09 2 Start Time 0000 3 End Date 07-01-09 4 End Time 2359 5 Location ALL 6 Open or Close Loc O 7 Start Vendor FIRST 8 End Vendor LAST 9 Unposted Only? B 10 Do Posting? Y 11 Detail/Summary D 12 Separate Page(s) Y 13 Print/Display P /dev/tty 14 Group Selection ALL 15 Write Flat File? Y 16 Transmit File? N 17 Res Flag C (C=Central Only, L=Local res's, B=both 18 Rate Reduction Pct 1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8

This program is very similar to the Vendor Commission Report found on the Month End Menu. Refer to that chapter for general information and details on the various fields.

This report contains a calculation of rental length called "DBR Days" (or just "Days"). One of two possible formulas are used in CARS+ to calculate this figure. To chose the formula to be used in this as well as over fifty other CARS+ reports, go to Page 5, Field 3 of Edit Miscellaneous Control Fields.