This program is used to export Payback data to American Express from posted RAs. It also writes the number of points awarded to a field in the RA file. The Frequent Traveler Report will show the number of points awarded on each RA.

Refer to the chapter Overview - American Express Payback Program for details on how the Payback program logic in CARS+.

To access the Payback Data Export program, type PAYBCK (RET) at any menu "OPTION:"field or the appropriate line number on the Hertz Mexico Menu. The screen will then display:

OPTION: __ PAYBACK DATA EXPORT

1 Location ALL
2 Start Date 02-01-14
3 End Date 02-28-14
4 New records only Y






1SAVE 2NEXT 3ERASE 4DELETE 5BACKUP 6 7HELP 8

Enter data as follows:

1. LOCATION

Enter:

1. Up to 6 alphanumeric characters to select a single opening location.

2. A Group Name representing several opening locations (see the Chapter Edit Group Names for a discussion on location groups). Remember, the first character of a Group Name is the plus sign "+".

3. Press RETURN to default to ALL locations.

EXAMPLE: Press (RET)

2. START DATE

Using your selected date format, enter the starting DBR Date. Press RET to default to the first day of the previous month.

EXAMPLE: Press (RET)

3. END DATE

Using your selected date format, enter the ending DBR Date. Press RET to default to the last day of the previous month.

EXAMPLE: Press (RET)

4. NEW RECORDS ONLY

 When the RA is written to the text file, (see section below) the frequent traveler flag is marked as posted. Enter:
Y = Select RAs whose frequent traveler data has not been posted.
N = Select RAs whether or not the frequent traveler data has been posted.

EXAMPLE: Type Y (RET).

CAUTION: When selecting "N" and running this program for a date range when there was a different points percentage in place will cause the Award Points field of the RAs closed during that date range to be updated with a points calculation based on the percentages currently in place. The percentages are set in the Edit Payback Partner Codes control file.


The screen will then display:

OPTION: __ PAYBACK DATA EXPORT

1 Location ALL
2 Start Date 02-01-14
3 End Date 02-28-14
4 New records only Y




1SAVE 2NEXT 3ERASE 4DELETE 5BACKUP 6 7HELP 8

PRESS "F1" AT "OPTION" TO SAVE THE RECORD.


The program sends data from posted RAs with the Payback frequent traveler code (as designated in the Edit Payback Partner Codes file) which were opened at the requested locations and have a DBR date that is within the date range.


Points Calculation:

The base for point calculation is as follows:

Unbundled Time (both voucher and out of voucher)
Plus: any mileage/km charge
Less: Discount, Customer Service Adjustment, and Promos

Result = Net amount

The Net Amount is then multiplied by the Points % as defined in Edit Payback Partner Codes:

If the card number is designated as issued by your own organization, the "Own Points %" is used.

If the card number is designated as not issued by your organization, the "Other Points %" is used.

If the resulting points are less than the minimum defined in Edit Payback Partner Code, the minimum points will be used.

The number of points awarded will also be written to a field in the RA file. The Frequent Traveler Report will show the number of points awarded on each RA. Please see the CAUTION regarding the potential updating of the amount in the RA file in the discussion of field 4 (New Records Only) above.


Marking as posted:

When the RA is written to the text file, the frequent traveler data is marked as "posted". (Refer to the New Records Only field above.)


RA data is written to the following fixed length text files:

NOTE: In the tables below, "Nbr-pb-xxxx" refers to the value of the field "xxxx" in the Edit Payback Partner Codes control file.

A. Header record

AX field

Size

CARS+ data

Header type

1

“H”

File Type

3

“TRX”

File version

12


Partner Code

10

Nbr-pb-partner-code

Business Unit Code

10


Branch Code

10


File Number

9

A sequancially generated number starting at 1

File source

50

Nbr-pb-source

Creation date

YYYY-MM-DDTHH:MM:SS

Sysdate/time

Number of Root records

9

Number of RAs to be reported


B. An Event record will be written for each RA

AX field

Size

CARS+ data

Record type

1

“E”

File number

9

Sequence number from header

Sequence number

10

Sequence number of the RAs within this batch

Partner code

10

Nbr-pb-partner-code

Business unit code

10


Branch code

10

RA-loc-out

Terminal number

36

RA-empl-out

Alias number

60

RA-ff-no

Alias type

1

“C”

Effective date

YYYY-MM-DDTHH:MM:SS

RA-date/time-out

Collect event type

3

“001”

Event cancellation type

1

“0”

Communication channel

2

“01”

Turnover amount including VAT

22 (18 char decimal 3 char)

Total unbundled discounted T&K plus the VAT amount calculated below

Rewardable amount including VAT

22 (18 char decimal 3 char)

Total unbundled discounted T&K

VAT amount

22 (18 char decimal 3 char)

VAT calculated on the unbundled, discounted T&K above

Currency

3

Nbr-pb-curr-code

Payment type

2

“99”

Receipt number

36

RA-no

Reference receipt number

36

blank

Partner customer number

36

blank

Number of following records

4

“0002”

Error code

250

blank


C. A Transaction record will be written for each RA:

AX field

Size

CARS+ data

Record type

1

“T”

Parent sequence number

10

RA sequence number from Event record

Sequence number

4

“0002”

Transaction type

3

“100”

Marketing code

20

blank

Coupon code

36

blank

Total points amount

22 (18 char decimal 3 char)

Calculated points – see notes below

Total points currency

3

Nbr-pb-pts-curr

Points blocked until

25

blank

Vat Rate

5

blank


D. An Item record will be written for each RA:

AX field

size

CARS+ data

Record type

1

“I”

Parent Sequence Number

10

RA sequence number from Event record

Sequence Number

4

“0001”

Points amount

22 (18 char decimal 3 char)

Calculated points – see notes below

Points currency

3

Nbr-pb-pts-curr

Marketing code

20

blank

Article number

36

RA-veh-no

Article description

60

blank

Article ean code

30

blank

Partner product group code

30

RA-veh-class

Partner product group name

30

blank

Partner product category code

30

Inv-type of RA-veh-no

Partner product category name

30

blank

Department code

30

blank

Department name

30

blank

Supplier code

30

RA-source

Supplier article number

36

RA-rte-prod

Single turnover amount

22 (18 char decimal 3 char)

Rachrg-primary-rate of TIME (bundled TIME)

Quantity

13 (9 char decimal 3 char)

RA-elapsed-days

Quantity unit code

30

“RENTAL”

Total turnover amount

22 (18 char decimal 3 char)

Same as reported on Event record

Total rewardable amount

22 (18 char decimal 3 char)

Same as reported on Event record

Vat amount

22 (18 char decimal 3 char)

Same as reported on Event record

Vat Rate

5

blank

Currency

3

Nbr-pb-curr-code


Naming convention for the file

Files will be placed in the directory paybck/ under the CARS+ base installation directory. The file name is composed of the following segments:

  1. The Partner Code as specified in the Edit Payback Partner Codes control file
  2. The system date in the format DDMMYYYY
  3. The letter "T"
  4. The system time in the format HHMM
  5. .txt

Example: paybck/hertz_mx19022014T0215.txt