This program produces an ASCII file of Tax Document data in the layout described at the end of this chapter.
To access the Post Tax Document program, type POSTTAX (RET) at any menu "OPTION:" field or the appropriate line number on the Rental Accounting menu. The screen will then display:
| OPTION: __ POST TAX DOCUMENTS 1 Start Tax Doc FIRST 2 End Tax Doc LAST 3 Start Date 03-30-16 4 End Date 03-30-16 5 Print Location ALL 1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8 |
Enter data as follows:
|
1. START TAX DOCUMENT NUMBER |
Enter up to 8 numeric characters for the starting tax document to be exported or press RET to default to the FIRST document on file. EXAMPLE: Press (RET). WARNING: Unlike other CARS+ posting programs, this program does NOT flag records as having been posted. Therefore, unless you restrict a FIRST to LAST request by a date range in fields 3 and 4 all records even those previously exported will be sent. |
|
2. END TAX DOCUMENT NUMBER |
Enter up to 8 numeric characters for the ending tax document to be exported or press RET to default to the LAST document on file. EXAMPLE: Press (RET) |
|
3. START DATE |
Enter the starting invoice date. Press RET to default to yesterday's date. EXAMPLE: Type 033016 (RET) |
|
4. END DATE |
Enter the ending invoice date. Press RET to default to yesterday's date. EXAMPLE: Type 033016 (RET) |
|
5. PRINT LOCATION |
Enter the Location Code for the rental location whose tax documents are to be exported or press RET to default to ALL locations. EXAMPLE: Type TUS (RET) |
The screen will then display:
| OPTION: __ POST TAX DOCUMENTS 1 Start Tax Doc FIRST 2 End Tax Doc LAST 3 Start Date 03-30-16 4 End Date 03-30-16 5 Print Location ALL 1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8 |
THE EXPORT FILE
The file created is a comma delimited, ASCII text file. A single Tax Document will produce the record types listed below.
When there is a wholesale voucher on the RA, there are 2 sets of records:
One set is in the name of the tour operator and shows the revenue included in the voucher.
The other set is in the name of the renter and includes all out of voucher revenue and renter payments.
|
Record Type |
Description | Notes |
|
1 |
Customer data |
This is the individual or company the document was issued to |
|
2 |
Tax Document data |
|
|
3 |
Rental Agreement data |
|
|
4 |
Payments data |
One type 4 record is created for each unique form of payment (for example, two Visa payments will be added together) |
| 5 |
Charge revenue data |
One type 5 record is created for each charge on the rental that the individual in the Type 1 record was responsible for |
| 6 |
Commissionable vendor data |
|
| 7 |
Vehicle Exchanges |
One type 7 record is created for each exchange that occurred on the rental |
| Column |
Field |
CARS+ Data |
Notes |
Record Type 1 |
Customer |
|
|
| B |
Cus-id |
Nf-cus-no |
|
| C |
Last-name |
Cust-last-name of Nf-cus-no |
Extended name of Nf-cus-no if the GVT EXTNAME exists |
| D |
First-name |
Cust-first-name of nf-cus-no |
|
| E |
Cust-type |
Cust-type of Nf-cus-no |
|
| F |
State Inscription |
Cust-state-tax-id of Nf-cus-no |
|
| G |
Municipal inscription |
Cust-fed-id of Nf-cus-no |
|
| H |
Billing-address |
Adr-street of billing address record of Nf-cus-no |
|
| I |
Billing-city |
Adr-city of billing address record of Nf-cus-no |
|
| J |
Billing-state |
Adr-state of billing address record of Nf-cus-no |
|
| K |
Billing-zip |
Adr-post-code of billing address record of Nf-cus-no |
|
| L |
Billing-phone |
blank |
|
| M |
Home-address1 |
blank |
|
| N |
Home-address2 |
Adr-street of home address record of Nf-cus-no |
|
| O |
Home-city |
Adr-city of home address record of Nf-cus-no |
|
| P |
Home-state |
Adr-state of home address record of Nf-cus-no |
|
| Q |
Home-zip |
Adr-post-code of home address record of Nf-cus-no |
|
| R |
Home-phone |
Cust-phone of Nf-cus-no |
|
| S |
Dob |
Cust-birth-date of Nf-cus-no |
|
| T |
Fed-tax-id |
Cust-fed-tax-id of Nf-cus-no |
|
| U |
Type |
“J” if the above field is 14 characters long, if 11 characters “F”, else “E” |
|
| V |
Credit-limit |
Cust-credit-limit of Nf-cus-no |
|
| W |
Last-rental |
Cust-last-activity-date of nf-cus-no |
|
| X |
Bill-town |
Adr-town of billing address record of Nf-cus-no |
|
| Y |
Customer-country |
Adr-country of home address of nf-cus-no |
|
| Z |
Bill-country |
Adr-country of billing address record of Nf-cus-no |
|
| AA |
Customer-contact |
Adr-county of home address of nf-cus-no |
|
| AB |
Bill-contact |
Adr-county of billing address record of Nf-cus-no |
|
| AC |
Email-address |
Cust-email-addr of nf-cus-no |
|
| AD |
Dob |
Cust-birth-date of Nf-cus-no |
|
| AE |
Other-id |
Cust-uperrez-no of nf-cus-no |
|
| AF |
Commission-plan |
Ven-comm-plan of the linked vendor record to the nf-cus-no |
|
| AG |
IATA |
Ven-no of the linked vendor record to the nf-cus-no |
|
| AH |
CDPID |
Cust-corp-rate-id of nf-cus-no |
|
| AI |
Running Total |
Terms code |
|
| AJ |
Licensee-running-total |
Cust-running-total of nf-cus-no |
|
| AK |
Note1 |
Nts-line-1 of the NTSFIL record attached to nf-cus-no |
|
| AL |
Note2 |
Nts-line-2 of the NTSFIL record attached to nf-cus-no |
|
| AM |
Note3 |
Nts-line-3 of the NTSFIL record attached to nf-cus-no |
|
| AN |
Note4 |
Nts-line-4 of the NTSFIL record attached to nf-cus-no |
|
| AO |
Entry-date |
Cust-enty-date of nf-cus-no |
|
| AP |
Mod-empl |
Cust-mod-empl of Nf-cus-no |
|
| AQ |
Mod-date |
Cust-mod-date of nf-cus-no |
|
| AR |
Bank-no |
Cust-bank-no of Nf-cus-no |
|
| AS |
Agency-no |
Cust-agency-no of Nf-cus-no |
|
| AT |
Agency-check-digit |
Cust-adency-check-digit of Nf-cus-no |
|
| AU |
Account-no |
Cust-acct-no of Nf-cus-no |
|
| AV |
Account-check-digit |
Cust-acct-chk-digit of Nf-cus-no |
|
| AW |
SPED Country |
Nbr-ctry-sped-code from Adr-country of nf-cus-no |
|
| AX |
City Code |
Adr-city of Nf-cus-no |
|
|
|
Record Type 2 |
Tax Document |
|
| B |
Tax-doc-number |
Nf-number |
|
| C |
Tax-doc-location |
RA-loc-out of Nfra-no |
|
| D |
Tax-doc-print-loc |
Nf-location |
|
| E |
Cust-id |
Nf-cus-no |
|
| F |
Bond-id |
“Nf-location – Nf-number” |
|
| G |
Print-date |
Nf-date-printed |
|
| H |
Due Date |
Nf-due-date |
|
| I |
Agent-ID |
RA-vend-no of Nfra-no |
|
| J |
Tax-doc-amt |
Nf-total |
|
| K |
Tax-perc |
Nf-tax-percent |
|
| L |
Issue-amt |
Nf-tax-amount |
|
| M |
Discount-amt |
Nf-discount-amt |
|
| N |
Tax-doc-status |
“C” if Nf-cancel-date is not blank |
|
| O |
Record-date |
Sys-date |
|
| P |
Record-time |
Sys-time |
|
| Q |
Taxable-total |
Nf-taxable-total |
|
| R |
Cancel-date |
Nf-cancel-date |
|
| S |
Profit-center |
Loc-profit-center of RA-loc-out |
If not running in Hertz Brazil mode |
| T |
Doc-type |
If Nf-type = “F” then “FT” else “BV” |
If not running in Hertz Brazil mode |
Record Type 3 |
Rental agreement |
|
|
| B |
Tax-doc-no |
Nf-number |
|
| C |
RA-no |
Nfra-ra-no |
|
| D |
Vehicle-id |
RA-veh-no of Nfra-ra-no |
|
| E |
RA-date-out |
RA-date-out of Nfra-ra-no |
|
| F |
RA-date-in |
RA-date-in of Nfra-ra-no |
|
| G |
Master-Contract-ID |
RA-lease-no of Nfra-ra-no |
|
| H |
RA-vendor-no |
RA-vend-no |
|
| I |
Vendor-cus-no |
Cust-no of the record linked to RA-vend-no of Nfra-ra-no |
|
| J |
Fed-tax-id |
Cust-fed-tax-id of Cust-no of the record linked to RA-vend-no of Nfra-ra-no |
|
| K |
Vendor-cust-name |
Extended-name of Cust-no of the record linked to RA-vend-no of Nr-ra-no |
|
| L |
Commission-total |
Calculated from the following 2 fields |
|
| M |
Commission-pct |
RA-comm-pct of Nfra-ra-no |
|
| N |
Commission-amt |
RA-comm-amt of Nfra-ra-no |
|
| O |
Vendor cust-bill-to |
Cust-bill-to-no of Cust-no of the record linked to RA-vend-no of Nfra-ra-no |
|
| P |
Vendor cust-bill-to IATA |
Vend-no of Cust-bill-to-no of Cust-no of the record linked to RA-vend-no of Nfra-ra-no |
|
| Q |
Vend-cust-bill-to-tax-id |
Cust-fed-tax-id of Cust-bill-to-no of Cust-no of the record linked to RA-vend-no of Nfra-ra-no |
|
| R |
RA-cust-no |
RA-cust-no of Nfra-ra-no |
|
| S |
Renter’s name |
Extend-name of RA-cust-no of Nfra-ra-no |
|
| T |
RA CDPID |
RA-cdpid-no pf Nfra-ra-no |
|
| U |
RA CDPID-name |
RA-corp-rate-name of Nfra-ra-no |
|
| V |
RA rate product |
RA-rt-prod of Nfra-ra-no |
|
| W |
Res no |
RA-res-no of Nfra-ra-no |
|
| X |
Conf-no |
Res-conf-no of Ra-res-no of Nfra-ra-no |
|
| Y |
Commission-flag |
“D” if RA-ven-no equals Cust-vend-no of Nf-cus-no and Nf-discount is not zero. |
|
| Z |
Project PCO |
RA-project-pco of Nfra-ra-no |
|
| AA |
PO# |
RA-po-no of Nfra-ra-no |
|
| AB |
Print-location |
Nf-location |
|
| AC |
Odometer out |
RA-odom-out of Nfra-ra-no |
|
| AD |
Odometer in |
RA-odom-in of Nfra-ra-no |
|
| AE |
Time out |
RA-time-out of Nfra-ra-no |
|
| AF |
Time in |
RA-time-in of Nfra-ra-no |
|
| AG |
Drivers License Number |
Cust-dl-no of RA-cust-no of Nfra-ra-no |
|
| AH |
Ven Pay Code |
RA-ven-paycode of Nfra-ra-no |
|
| AI |
Veh-make |
Inv-make of RA-veh-no |
If not running in Hertz Brazil mode |
| AJ |
Veh-model |
Inv-model of RA-veh-no |
If not running in Hertz Brazil mode |
| AK |
Veh-license |
Inv-license of RA-veh-no |
If not running in Hertz Brazil mode |
Record Type 4 |
Payments |
|
|
| B |
Tax-doc-no |
Nf-number |
|
| C |
RA-no |
Nfra-ra-no |
|
| D |
Type |
Dep-fop |
|
| E |
Pymt-amt |
Dep-amt |
|
| F |
G/L-acct |
Cust-gl-acct of the Dep-fop |
If Nbr-flg-expanded-gl = “Y” use Acct-post-acct |
| G |
G/L descr |
Acct-descr |
|
| H |
Pymt-status |
Dep-cancel-flag |
|
| I |
Card-no |
Dep-voucher (masked) |
|
| J |
Security-id |
blank |
|
| K |
Expire-date |
Dep-exp-date |
|
| L |
Auth-no |
Dep-auth-no |
|
| M |
Slip-no |
Dep-slip-no |
|
| N |
Slip-date |
Dep-slip-date |
|
| O |
Batch-no |
Dep-batch-no |
|
| P |
Batch-date |
Dep-batch-date |
|
| Q |
Installments |
Dep-instal-no |
|
| R |
NF print location |
Nf-loc |
|
Record Type 5 |
Revenue |
|
|
| B |
RA-no |
Nfra-ra-no |
|
| C |
G/L-acct |
G/L account-no |
If Nbr-flg-expanded-gl = “Y” use Acct-post-acct |
| D |
G/L-descr |
Acct-descr |
|
| E |
Amt |
Rachrg-charge |
|
| F |
Qty |
Rachrg-object-qty |
|
| G |
Status |
“C” if RACHRG row is cancelled |
|
| H |
Tax doc # |
Nf-number |
|
| I |
Option Code |
Rachrg-opt0code |
|
| J |
Nf-location |
Nf-location |
|
| K |
Short-desc |
Opt-short-desc of Rachrg-opt-code |
If not running in Hertz Brazil mode |
| L |
Unit-price |
Rachrg-primary-rate |
If not running in Hertz Brazil mode |
| M |
Unit |
“%” if Optrte-cal-mth = “P” “dia” if Optrte-calc-meth = “D”, “T” or “C” “KM” if Optrte-calc-meth = “M”, “R” or “G” |
If not running in Hertz Brazil mode |
Record Type 6 |
Vendor |
|
|
| B |
vendor |
RA-vend-no of Nfra-ra-no |
|
| C |
Vendor’s Customer |
Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
| D |
Vendor’s customer last name |
Cust-last-name of Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
| E |
Vendor’s customer expanded name |
Cust-expand-name of Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
| F |
Vendor’s customer Fed Tax ID |
Cust-fed-tax-id of Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
| G |
Vendor’s customer street |
Adr-street of Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
| H |
Vendor’s customer town |
Cust-phone of Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
| I |
Vendor’s customer city |
Adr-city of Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
| J |
Vendor’s customer state |
Adr-state of Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
| K |
Vendor’s customer post code |
Adr-post-code of Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
| L |
Vendor’s customer phone |
Cust-phone of Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
| M |
Vendor’s customer email |
Cust-email of Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
| N |
Vendor Customer’s bank number |
Cust-bank-no of Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
| O |
Vendor Customer’s agency number |
Cust-agency-no of Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
| P |
Vendor Customer’s agency check digit |
Cust-agency-chk-digit of Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
| Q |
Vendor Customer’s account number |
Cust-acct-no of Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
| R |
Vendor Customer’s account check digit |
Cust-acct-chk-digit of Ven-cust-no of RA-vend-no of Nfra-ra-no |
|
Record Type 7 |
Exchanges |
|
|
| B |
RA number |
Nfra-ra-no |
|
| C |
Veh-number returning |
Exch-veh-in of Nfra-ra-no |
|
| D |
License number returning |
Inv-license of Exch-veh-in of Nfra-ra-no |
|
| E |
Date out |
Date of the original rent of this vehicle |
|
| F |
Time out |
Time of the original rent of this vehicle |
|
| G |
Date In |
Exch-date of Nfra-ra-no |
|
| H |
Time in |
Exch-time of Nfra-ra-no |
|
| I |
Odometer Out |
Exch-prev-odom-out od Nfra-ra-no |
|
| J |
Odometer In |
Exch-odom-in of Nfra-ra-no |
|
| K |
Tank Out |
Exch-prev-tank-out of Nfra-ra-no |
|
| L |
Tank In |
Exch-tank-in od Nfra-ra-no |
|
| M |
RA Loc out |
Location of the original rent of this vehicle |
|
| N |
Exchange Loc |
Exch-loc of Nfra-ra-no |
|
FILE NAMING CONVENTION
The resulting csv file is placed in the directory intnn where nn is the Company number of the posting company being posted.
The file is named INTmmddyyyynn.csv, where the date is the system date when the posting occurred and nn is the posting company code.