DRB Processing for Hertz Australia is done using the MQ Series "Near Real-time DRB" submission of closed RAs. The data is interfaced directly into GARS using the GARS Interface Record layout.


Special notes about this program:

Federal "GST" is reported as the main tax on the transactions and is reported in the APAC-tax-pct and APAC-tax-split fields.

State tax (Stamp Duty) is reported in the "APAC-tax-diff" fields.

On ghost RAs, the voucher revenue is reported in the "APAC-itv" fields and is not included in the out of voucher revenue fields.

Note: Vouchers cannot include charges that do not have a named ITV field. Including other charges will cause the RA to be out of balance when transmitted to GARS. At the time of this writing (August, 2005), the list is as follows:

For transmittal of insurance RAs, three records are created for each insurance replacement RA:

A = Those charges to be billed to the insurance company

H = Those charges for which the renter is responsible.

X = The total charges on the RA (sum of A and H.)

The taxable miscellaneous charge fields are used for miscellaneous credits, and the non-taxable miscellaneous charge fields are used for miscellaneous debits.

At the time of this writing, (August 2005) the record layout is as follows:

FIELD NAME

FORMAT


LEN

OFFSET (EXCL. HEADER)

FIELD DESCRIPTION

NOTES (below)

Z=ZONED S=SIGNED

APAC-RA-NBR

CHAR


10

1

Rental Agreement Number



APAC-CUST-NAME

CHAR


30

11

Renter's Name



FILLER



2

41




APAC-NO1-CLUB-NBR

CHAR


8

43

Number 1 Club Number



APAC-HOME-ADDR1

CHAR


30

51

Renter's Address line 1



APAC-HOME-ADDR2

CHAR


30

81

Renter's Address line 2



APAC-HOME-CITY

CHAR


30

111

Renter's City



APAC-HOME-CTRY

CHAR


3

141

Renter's Ctry Code

F


FILLER



15

144




APAC-HOME-STATE

CHAR


2

159

Renter's State/Province Code

G


APAC-HOME-ZIP

CHAR


10

161

Renter's Postal Code



APAC-HOME-PHONE

CHAR


20

171

Renter's Phone



FILLER



80

191




APAC-BIRTH-PLACE

CHAR


20

271

Renter's Birthplace



FILLER



6

291




APAC-PASSPORT-NBR

CHAR


12

297

Passport Number



APAC-PASSPORT-CNTRY

CHAR


20

309

Passport Country(Name, not code)



FILLER



6

329




APAC-DL-NBR

CHAR


26

335

Drivers License(Permit) Number



APAC-DL-CNTRY

CHAR


20

361

Drivers License Country

H


FILLER



12

381




APAC-DL-CTRY-CD

CHAR


2

393

Drivers License Country(State for U.S.)

I


FILLER



10

395




APAC-RMS-DRV-REG

CHAR


20

405

Not used by AU



APAC-RMS-DRV-EMPLOYER

CHAR


30

425

Not used by AU



APAC-BIRTH-CC

INTEGER


2

455

Birthdate - Century

J

Z

APAC-BIRTH-YY

INTEGER


2

457

Birthdate - Year

J

Z

APAC-BIRTH-MM

INTEGER


2

459

Birthdate - Month

J

Z

APAC-BIRTH-DD

INTEGER


2

461

Birthdate - Day

J

Z

APAC-PASSPORT-ISSUE-CC

INTEGER


2

463

Data not recorded in CARS+

J

Z

APAC-PASSPORT-ISSUE-YY

INTEGER


2

465

Data not recorded in CARS+

J

Z

APAC-PASSPORT-ISSUE-MM

INTEGER


2

467

Data not recorded in CARS+

J

Z

APAC-PASSPORT-ISSUE-DD

INTEGER


2

469

Data not recorded in CARS+

J

Z

APAC-DL-ISSUE-CC

INTEGER


2

471

Drivers License Issue - Century

J

Z

APAC-DL-ISSUE-YY

INTEGER


2

473

Drivers License Issue - Year

J

Z

APAC-DL-ISSUE-MM

INTEGER


2

475

Drivers License Issue - Month

J

Z

APAC-DL-ISSUE-DD

INTEGER


2

477

Drivers License Issue - Date

J

Z

APAC-DL-EXP-CC

INTEGER


2

479

Drivers License Expiration - Century

J

Z

APAC-DL-EXP-YY

INTEGER


2

481

Drivers License Expiration - Year

J

Z

APAC-DL-EXP-MM

INTEGER


2

483

Drivers License Expiration - Month

J

Z

APAC-DL-EXP-DD

INTEGER


2

485

Drivers License Expiration - Day

J

Z

FILLER



18

487




APAC-BILL-NAME

CHAR


30

505

Billing Name



APAC-BILL-ADDR1

CHAR


30

535

Bill Address - 1



APAC-BILL-ADDR2

CHAR


30

565

Bill Address - 2



APAC-BILL-CITY

CHAR


30

595

Bill City



APAC-BILL-CTRY

CHAR


3

625

Bill Country

H


FILLER



15

628




APAC-BILL-STATE

CHAR


2

643

Bill State

G


APAC-BILL-ZIP

CHAR


10

645

Bill Postal Code



APAC-METHOD-OF-PAY

CHAR


4

655

Method of Payment

L


APAC-CC-NBR

CHAR


20

659

Billing Account Number(GCC, HCC, etc.)



APAC-CC-EXP-MM

INTEGER


2

679

Credit Card Expiration - Month (GCC)


Z

APAC-CC-EXP-YY

INTEGER


2

681

Credit Card Expiration - Year (GCC)


Z

APAC-CC-VER-CODE

CHAR


6

683

Credit Card Verification or Authorization Code



APAC-CC-CERT-NBR

CHAR


14

689

Credit Card or Certificate Number



APAC-CC-VER-AMOUNT

DECIMAL

9,2

11

703

Credit Card Verification or Authorization Amount


Z,S

FILLER



6

714




APAC-COMPANY-REF

CHAR


36

720

Reservation Company Order - Also mapped to Special Bill 1



APAC-TAX-EXEMPT-NO

CHAR


6

756

Tax Exempt Nbr - Must be present if no tax charged



APAC-TAX-EXEMPT-REASON

CHAR


4

762

Tax Exempt Reason



APAC-LIC-CORPORATE-IND

CHAR


1

766

Licensee/Corporate Indicator

M


FILLER



17

767




APAC-TARIFF-DESC

CHAR


30

784

Rate description



APAC-CURRENCY-CODE

CHAR


4

814

Rental Currency Code



APAC-GCC-CURR-CNVT-IND

CHAR


1

818

Not used in AU



APAC-CC-VER-CC

INTEGER


2

819

Credit Card Verification - Century

J

Z

APAC-CC-VER-YY

INTEGER


2

821

Credit Card Verification - Year

J

Z

APAC-CC-VER-MM

INTEGER


2

823

Credit Card Verification - Month

J

Z

APAC-CC-VER-DD

INTEGER


2

825

Credit Card Verification - Day

J

Z

FILLER



178

827




APAC-EXTEND-VER-CODE

CHAR


6

1005

Verification Code for Post Return or Post Rent



FILLER



6

1011




APAC-EXTEND-VER-AMOUNT

INTEGER


9

1017

Authorization Amount for Post Return or Post Rent


Z

APAC-ADD-VER-CODE

CHAR


6

1026




FILLER



6

1032




APAC-VER-AMOUNT

INTEGER


9

1038

Verification Amount at Rent


Z,S

APAC-ADD-VER-AMOUNT

INTEGER


9

1047

Verification Amount at Return


Z,S

APAC-PREV-EXTEND-VER-CODE

CHAR


6

1056




FILLER



6

1062




APAC-PREV-EXTEND-VER-AMT

INTEGER


9

1068



Z

FILLER



22

1077




APAC-STORE-NBR

CHAR


4

1099

Store Number



APAC-TERM-ID

CHAR


4

1103

Terminal Identification



FILLER



34

1107




APAC-SAVE-FINAL-MOP

CHAR


4

1141

Final Method of Payment



FILLER



4

1145




APAC-SPEC-BILLING-1

CHAR


25

1149

Should contain Reservation Company Order number



FILLER



25

1174




APAC-SPEC-BILLING-2

CHAR


25

1199

Booking Reference Number



APAC-EXTEND-VER-CC

INTEGER


2

1224

Extension verification - Century


Z

APAC-EXTEND-VER-YY

INTEGER


2

1226

Extension verification - Year


Z

APAC-EXTEND-VER-MM

INTEGER


2

1228

Extension verification - Month


Z

APAC-EXTEND-VER-DD

INTEGER


2

1230

Extension verification - Day


Z

APAC-ADD-VER-CC

INTEGER


2

1232

Additional verification - Century


Z

APAC-ADD-VER-YY

INTEGER


2

1234

Additional verification - Year


Z

APAC-ADD-VER-MM

INTEGER


2

1236

Additional verification - Month


Z

APAC-ADD-VER-DD

INTEGER


2

1238

Additional verification - Day


Z

APAC-PREV-EXTEND-VER-CC

INTEGER


2

1240

Previous extension accumulation - Century


Z

APAC-PREV-EXTEND-VER-YY

INTEGER


2

1242

Previous extension accumulation - Year


Z

APAC-PREV-EXTEND-VER-MM

INTEGER


2

1244

Previous extension accumulation - Month


Z

APAC-PREV-EXTEND-VER-DD

INTEGER


2

1246

Previous extension accumulation - Day


Z

FILLER



1

1248




APAC-CDP-PAR-NBR

INTEGER


10

1249

Corporate Discount Plan Parent Number


Z

FILLER



16

1259




APAC-CDP-CONTRACT-TYPE

CHAR


4

1275

CDP Contract Type



APAC-CDP-SAC-IND

CHAR


2

1279

CDP Small Account Indicator



APAC-CDPID-NBR

INTEGER


10

1281

Corporate Discount Plan ID Number


Z

FILLER



2

1291




APAC-COMPANY-NAME

CHAR


30

1293

Corporate Name



FILLER



2

1323




APAC-RATE-CODE-CNT

INTEGER


2

1325

Number of rate codes tied to CDP


Z

APAC-RATE-CODES(1-75)

CHAR


150

1327

Occurrence of 75 2-digit rate codes



FILLER



416

1477




APAC-RENTAL-HOURS

INTEGER


2

1893

Rental Time - Hours

O

Z

APAC-RENTAL-MINUTES

INTEGER


2

1895

Rental Time - Minutes

O

Z

FILLER



6

1897




APAC-RENT-LOC-1-2(WWD)

CHAR


2

1903

Rental Location - ISO country

P


APAC-RENT-LOC-3-7(WWD)

CHAR


5

1905

Rental Location - City and Location (CCCLL)

P


FILLER



7

1910




APAC-RENT-AREA-NBR

INTEGER


5

1917

Rental Location - Numeric Area

Q

Z

APAC-RENT-LOC-NBR

INTEGER


2

1922

Rental Location - Location Code (same as LL above)

Q

Z

FILLER



1

1924




APAC-RENT-CC

INTEGER


2

1925

Rental Date - Century

J

Z

APAC-RENT-YY

INTEGER


2

1927

Rental Date - Year

J

Z

APAC-RENT-MM

INTEGER


2

1929

Rental Date - Month

J

Z

APAC-RENT-DD

INTEGER


2

1931

Rental Date - Day

J

Z

FILLER



92

1933




APAC-RTRN-HOURS

INTEGER


2

2025

Return Time - Hours

O

Z

APAC-RTRN-MINUTES

INTEGER


2

2027

Return Time - Minutes

O

Z

FILLER



6

2029




APAC-RTRN-LOC-1-2

CHAR


2

2035

Return Location - ISO country

P


APAC-RTRN-LOC-3-7

CHAR


5

2037

Return Location - City and Location (CCCLL)

P


FILLER



7

2042




APAC-RTRN-AREA-NBR

INTEGER


5

2049

Return Location - Numeric Area

Q

Z

APAC-RTRN-LOC-NBR

INTEGER


2

2054

Return Location - Location Code (same as LL above)

Q

Z

FILLER



1

2056




APAC-RTRN-CC

INTEGER


2

2057

Return Date - Century

J

Z

APAC-RTRN-YY

INTEGER


2

2059

Return Date - Year

J

Z

APAC-RTRN-MM

INTEGER


2

2061

Return Date - Month

J

Z

APAC-RTRN-DD

INTEGER


2

2063

Return Date - Day

J

Z

FILLER



259

2065




APAC-TAX-DIFF-INCL-IND

CHAR


1

2274

Stamp Duty Inclusive Indicator



APAC-TAX-INCL-IND

CHAR


1

2275

Tax Inclusive Indicator

R


FILLER



1

2276




APAC-CDW-IND

CHAR


1

2276

CDW Option Ind (AER)

S


APAC-PAI-IND

CHAR


1

2277

PAI/PEC Option Ind

T


APAC-OWN-IND

CHAR


1

2278

N/A - default to N



FILLER

CHAR


2

2279




APAC-LDI-PART-IND

CHAR


1

2281

N/A - default to N



FILLER

CHAR


1

2282




APAC-RMS-RES-IND

CHAR


1

2283

Not used in AU



FILLER



1

2284




APAC-ADD-SRV-IND

CHAR


1

2285

Additional Service Indicator



FILLER



2

2286




APAC-FIVE-STAR-IND

CHAR


1

2288

Five Star Indicator



APAC-PLATINUM-IND

CHAR


1

2289

Platinum Indicator



FILLER



2

2290




APAC-RENT-TYPE-IND

CHAR


1

2292

Business(B) or Leisure(L) indicator

U


FILLER



1

2293




APAC-RATE-ENGINE-IND

CHAR


1

2294

Rate Engine Indicator - this will be set to "T"

V


FILLER



1

2295




APAC-DEL-IND

CHAR


1

2296

Delivery Indicator

W


APAC-COLL-IND

CHAR


1

2297

Collection Indicator

W


APAC-AP-ROYALTY-IND

CHAR


1

2298

ACFR indicator



FILLER



6

2299




APAC-UPSELL-TYPE

CHAR


1

2305

Y if Upsell Charged



FILLER



17

2306




APAC-PRINT-INVOICE

CHAR


1

2323

Print override flag????



FILLER



38

2324




APAC-STATUS-FLAG

CHAR


2

2362

Will be IN or IP for closed RA



FILLER



2

2364




APAC-NBR-VOUCHERS-FLAG

INTEGER


1

2366

Number of vouchers present (0 or 1)


Z

FILLER



1

2367




APAC-COMPANY-INVOICE-FLAG

CHAR


1

2368

Tax Liable Indicator????



APAC-VOID-REASON-CODE

CHAR


2

2369

Void Reason code



APAC-BEST-DEAL-DONE

CHAR


1

2371

Best Deal Done indicator



APAC-INST-RTRN-IND

CHAR


1

2372

Instant return Indicator



FILLER



3

2373




APAC-CAR-OR-VAN-IND

CHAR


1

2376

Inv-type-code



FILLER



6

2377




APAC-INIT-STATUS-IND

CHAR


2

2383

???



FILLER



59

2385




APAC-REFERRAL-SOURCE

CHAR


2

2444

Reservation Country



APAC-TRAV-AGENT-NBR

CHAR


8

2446

IATA number for TACO lookup



APAC-PROMOTION-CODE

CHAR


6

2454

Promotion Code



APAC-AGENT-REF

CHAR


16

2460

Referred By



FILLER



33

2476




APAC-IBM-COMM-IND

CHAR


2

2509

N/A



FILLER



100

2511




APAC-RATE-PLAN-IN

CHAR


6

2611

Rate Plan - Checkin



FILLER



2

2617




APAC-RATE-IN-CTGY-CD

CHAR


2

2619

RA-Type



APAC-RATE-IN-TYPE-CD

CHAR


2

2621

RA-Type



APAC-RATE-IN-FMLY-CD

CHAR


2

2623

RA-Type



FILLER



2

2625




APAC-RATE-PLAN-OUT

CHAR


6

2627

Rate Plan - Checkout



FILLER



20

2633




APAC-DLY-RATE

DECIMAL

9,2

11

2653

Daily Charge Rate


Z,S

APAC-WKLY-RATE

DECIMAL

9,2

11

2664

Weekly Charge Rate


Z,S

APAC-MNTHLY-RATE

DECIMAL

9,2

11

2675

Monthly Charge Rate


Z,S

FILLER



11

2686




APAC-EX-DAY-RATE

DECIMAL

9,2

11

2697

Extra Day Rate


Z,S

APAC-EX-HR-RATE

DECIMAL

9,2

11

2708

Extra Hour Rate


Z,S

FILLER



22

2719




APAC-MILEAGE-RATE

DECIMAL

9,2

11

2741

Rate for Kilometres Charged


Z,S

APAC-CDW-RATE

DECIMAL

9,2

11

2752

Daily AER Rate


Z,S

APAC-PAI-RATE

DECIMAL

9,2

11

2763

Daily PAI/PEC Rate


Z,S

APAC-TP-RATE

DECIMAL

9,2

11

2774

Daily TP Rate (Thieft Protection - doesn't apply)


Z,S

APAC-INIT-MLS-ALLOWED

INTEGER


4

2785

Number of kilometers allowed at rental time


Z,S

FILLER



4

2789




APAC-MLS-ALLOWED

INTEGER


4

2793

Total number of kilometers allowed during the rental


Z,S

APAC-MINIMUM-DYS

INTEGER


2

2797

Minimum days


Z,S

FILLER



4

2799




APAC-DISCOUNT

DECIMAL

2,2

4

2803

Discount percentage


Z

FILLER



4

2807




APAC-CONT-RATE-PLAN

CHAR


4

2811

Contract rate plan



FILLER



104

2815




APAC-TAX-PCT

DECIMAL

2,4

6

2919

GST tax percentage

E

Z,S

FILLER



24

2925




APAC-TAX-SPLIT

DECIMAL

9,2

11

2949

GST tax amount


Z,S

FILLER



44

2960




APAC-TANDM-CODE

INTEGER


1

3004

Time and Mileage tax code

A

Z

APAC-DEL-CODE

INTEGER


1

3005

Delivery tax code

A

Z

APAC-COLL-CODE

INTEGER


1

3006

Collection tax code

A

Z

APAC-CDW-CODE

INTEGER


1

3007

AER tax code

A

Z

APAC-PAI-CODE

INTEGER


1

3008

PAI/PEC tax code

A

Z

FILLER



1

3009


A

Z

APAC-FUEL-CODE

INTEGER


1

3010

Fuel Charges tax code

A

Z

APAC-AP-ROYALTY-CODE

INTEGER


1

3011

ACFR tax code

A

Z

APAC-REFUEL-CHG-CODE

INTEGER


1

3012

Refuel Service Chg tax code

A

Z

FILLER



1

3013


A

Z

APAC-TAX-NBR

CHAR


26

3014

Vat register number (N/A)



FILLER



1

3040


A

Z

APAC-ADD-DRV-CODE

INTEGER


1

3041

Additional Driver tax code

A

Z

APAC-UNDER25-CODE

INTEGER


1

3042

Under 25 driver charge tax code

A

Z

APAC-RIHLIT-CODE

INTEGER


1

3043

OWR tax code

A

Z

APAC-UPSELL-CODE

INTEGER


1

3044

N/A


Z

APAC-VLF-CODE

INTEGER


1

3045

Vehicle Rego tax code

A

Z

FILLER



94

3046




APAC-CDW-DYS

INTEGER


2

3140

Number of AER days charged


Z,S

APAC-PAI-DYS

INTEGER


2

3142

Number of PAI/PEC days charged


Z,S

FILLER

CHAR


2

3144



Z,S

APAC-RENTAL-DYS

INTEGER


2

3146

Number of days charged at daily rate


Z,S

APAC-RENTAL-MNTHS

INTEGER


2

3148

Number of months charged at monthly rate


Z,S

APAC-RENTAL-WKS

INTEGER


2

3150

Number of weeks charged at weekly rate


Z,S

FILLER



2

3152




APAC-RENT-EX-HRS

INTEGER


2

3154

Number of Extra hours charged at extra hourly rate


Z,S

APAC-RENT-EX-DYS

INTEGER


2

3156

Number of Extra days charged at extra days rate


Z,S

APAC-RENT-EX-WKS

INTEGER


2

3158

Number of Extra weeks charged at extra weeks rate


Z,S

APAC-ELAPSED-DYS

INTEGER


2

3160

Days elapsed during rental


Z,S

FILLER



21

3162




APAC-FUEL-LEVEL-IN

INTEGER


1

3183

Fuel level on return


Z,S

APAC-FUEL-LEVEL-OUT

INTEGER


1

3184

Fuel level on checkout


Z,S

FILLER



3

3185




APAC-KMS-MLS-IND

CHAR


1

3188

K=Kilometers; M=miles



APAC-FUEL-TYPE

CHAR


1

3189

Fuel type



APAC-LITRES

DECIMAL

3,1

4

3190

Litres of fuel pumped


Z,S

FILLER



4

3194




APAC-MILEAGE-CHARGED

INTEGER


5

3198

Kilometres charged


Z,S

FILLER



30

3203




APAC-REFUEL-CHART

CHAR


1

3233

Refuel chart



FILLER



46

3234




APAC-UPSELL-DLY-RATE

DECIMAL

9,2

11

3280

Upsell daily rate


Z

APAC-AP-ROYALTY-PCT

DECIMAL

2,4

6

3291

ACFR percentage


Z,S

APAC-AP-TNM-FG

CHAR


1

3297

Y=Time and kilometers in basis for ACFR



APAC-AP-LDW-FG

CHAR


1

3298

N/A, should be N



APAC-AP-PAI-FG

CHAR


1

3299

Y=PAI/PEC in basis for ACFR



FILLER



1

3300




APAC-AP-AGE-DIFF-FG

CHAR


1

3301

Y=Age diff charge for ACFR



APAC-AP-ADDL-OPR-FG

CHAR


1

3302

Y=Additional Driver charge in basis for ACFR



APAC-AP-COLL-CHG-FG

CHAR


1

3303

Y=Collection charge in basis for ACFR



APAC-AP-DELV-CHG-FG

CHAR


1

3304

Y=Delivery charge in basis for ACFR



FILLER



3

3305




APAC-AP-REFUEL-FG

CHAR


1

3308

Y=Fuel charges in basis for ACFR



APAC-AP-REFL-SVC-FG

CHAR


1

3309

Y=Refuel/FPO in basis for ACFR



FILLER



1

3310




APAC-AP-RIHLIT-FG

CHAR


1

3311

Y=OWR in basis for ACFR



APAC-AP-VLF-RDTAX-FG

CHAR


1

3312

Y=Vehicle Rego Recovery in basis for ACFR



FILLER



154

3313




APAC-LITRES-CHARGED

DECIMAL

5,2

7

3467

Number of litres of fuel charged


Z,S

FILLER



17

3474




APAC-DLY-TTL

DECIMAL

9,2

11

3491

Daily charges


Z,S

APAC-WKLY-TTL

DECIMAL

9,2

11

3502

Weekly charges


Z,S

APAC-MNTHLY-TTL

DECIMAL

9,2

11

3513

Monthly charges


Z,S

FILLER



11

3524




APAC-EX-HR-TTL

DECIMAL

9,2

11

3535

Extra Hour charges


Z,S

APAC-EX-DAY-TTL

DECIMAL

9,2

11

3546

Extra Day charges


Z,S

APAC-EX-WK-TTL

DECIMAL

9,2

11

3557

Extra Week charges


Z,S

FILLER



22

3568




APAC-AP-ROYALTY-CHG

DECIMAL

9,2

11

3590

Airport Concession Fee Recovery


Z,S

APAC-TANDM-TTL

DECIMAL

9,2

11

3601

Time and Mileage Total

AA

Z,S

APAC-CDW-TTL

DECIMAL

9,2

11

3612

CDW(AER) charges


Z,S

APAC-PAI-TTL

DECIMAL

9,2

11

3623

PAI/PEC charges


Z,S

FILLER



11

3634



Z,S

APAC-FUEL-TTL

DECIMAL

9,2

11

3645

Fuel Charges


Z,S

APAC-DISCOUNT-TTL

DECIMAL

9,2

11

3656

Discount amt


Z,S

APAC-DEL-TTL

DECIMAL

9,2

11

3667

Delivery charges


Z,S

APAC-COLL-TTL

DECIMAL

9,2

11

3678

Collection charges


Z,S

APAC-TAX-TTL

DECIMAL

9,2

11

3689

GST total


Z,S

APAC-MILEAGE-TTL

DECIMAL

9,2

11

3700

Charges for kilometers driven


Z,S

APAC-VOUCHER-TTL

DECIMAL

9,2

11

3711

Voucher total


Z,S

APAC-MISC-CHG-TTL

DECIMAL

9,2

11

3722

Total of misc taxable charges(GST)

BB

Z,S

APAC-MISC-DED-TTL

DECIMAL

9,2

11

3733

Total of misc nontaxable charges(GST)

CC

Z,S

APAC-TTL-CHARGE

DECIMAL

9,2

11

3744

Total charges

DD

Z,S

APAC-DEPOSIT-REFUND

DECIMAL

9,2

11

3755

Deposit refund amount


Z,S

APAC-DEPOSIT-AMT

DECIMAL

9,2

11

3766

Deposit amount


Z,S

FILLER



11

3777




APAC-CASH-PAID

DECIMAL

9,2

11

3788

Partial cash payment at counter


Z,S

APAC-NET-DUE

DECIMAL

9,2

11

3799

Net Due for renter (Last Net Due)

EE

Z,S

APAC-AGE-DIFF-TTL

DECIMAL

9,2

11

3810

Driver under 25 surcharge


Z,S

FILLER



11

3821




APAC-REFUEL-CHG-AMT

DECIMAL

9,2

11

3832

Refuel Service charge amt/FPO amt

FF

Z,S

APAC-NW-EXCESS-AMT

DECIMAL

9,2

11

3843

Non-waivable excess amt


Z,S

APAC-AP-ROYALTY-TAX

DECIMAL

9,2

11

3854

N/A


Z,S

APAC-RIH-LIT-CHG-AMT

DECIMAL

9,2

11

3865

OWR (Repositioning) charge amt


Z,S

FILLER



11

3876




APAC-EX-WEEK-RATE

DECIMAL

9,2

11

3887

Extra Week rate


Z,S

FILLER

CHAR


11

3898



Z,S

APAC-COST-PER-LITRE-USED

DECIMAL

9,2

11

3909

Fuel cost per liter


Z,S

FILLER



11

3920




APAC-MISC-D-AP-IND(1)

CHAR


1

3931

Misc nontaxable - Indicates if Airport Concessionable

JJ


APAC-MISC-D-ACODE(1)

CHAR


4

3932

Misc nontaxable - Oracle GL acct code



APAC-MISC-D-SUBACODE(1)

CHAR


5

3936

Misc nontaxable - Oracle GL subacct code

GG


APAC-MISC-D-AP-IND(2)

CHAR


1

3941

Misc nontaxable - Indicates if Airport Concessionable

JJ


APAC-MISC-D-ACODE(2)

CHAR


4

3942

Misc nontaxable - Oracle GL acct code



APAC-MISC-D-SUBACODE(2)

CHAR


5

3946

Misc nontaxable - Oracle GL subacct code

GG


APAC-MISC-D-AP-IND(3)

CHAR


1

3951

Misc nontaxable - Indicates if Airport Concessionable

JJ


APAC-MISC-D-ACODE(3)

CHAR


4

3952

Misc nontaxable - Oracle GL acct code



APAC-MISC-D-SUBACODE(3)

CHAR


5

3956

Misc nontaxable - Oracle GL subacct code

GG


APAC-MISC-D-AP-IND(4)

CHAR


1

3961

Misc nontaxable - Indicates if Airport Concessionable

JJ


APAC-MISC-D-ACODE(4)

CHAR


4

3962

Misc nontaxable - Oracle GL acct code



APAC-MISC-D-SUBACODE(4)

CHAR


5

3966

Misc nontaxable - Oracle GL subacct code

GG


APAC-MISC-D-AP-IND(5)

CHAR


1

3971

Misc nontaxable - Indicates if Airport Concessionable

JJ


APAC-MISC-D-ACODE(5)

CHAR


4

3972

Misc nontaxable - Oracle GL acct code



APAC-MISC-D-SUBACODE(5)

CHAR


5

3976

Misc nontaxable - Oracle GL subacct code

GG


APAC-MISC-D-AMT(1)

DECIMAL

9,2

11

3981

Misc nontaxable amt


Z,S

APAC-MISC-D-AMT(2)

DECIMAL

9,2

11

3992

Misc nontaxable amt


Z,S

APAC-MISC-D-AMT(3)

DECIMAL

9,2

11

4003

Misc nontaxable amt


Z,S

APAC-MISC-D-AMT(4)

DECIMAL

9,2

11

4014

Misc nontaxable amt


Z,S

APAC-MISC-D-AMT(5)

DECIMAL

9,2

11

4025

Misc nontaxable amt


Z,S

APAC-MISC-D-TCODE(1)

INTEGER


1

4036

Should be 0, but could be 1 if Stamp Duty assessed on this charge

A


APAC-MISC-D-TCODE(2)

INTEGER


1

4037

Should be 0, but could be 1 if Stamp Duty assessed on this charge

A


APAC-MISC-D-TCODE(3)

INTEGER


1

4038

Should be 0, but could be 1 if Stamp Duty assessed on this charge

A


APAC-MISC-D-TCODE(4)

INTEGER


1

4039

Should be 0, but could be 1 if Stamp Duty assessed on this charge

A


APAC-MISC-D-TCODE(5)

INTEGER


1

4040

Should be 0, but could be 1 if Stamp Duty assessed on this charge

A


FILLER



1

4041




APAC-MISC-A-AP-IND(1)

CHAR


1

4042

Misc taxable - Indicates if Airport Concessionable

JJ


APAC-MISC-A-ACODE(1)

CHAR


4

4043

Misc taxable - Oracle acct code



APAC-MISC-A-SUBACODE(1)

CHAR


5

4047

Misc taxable - Oracle subacct code

GG


APAC-MISC-A-AP-IND(2)

CHAR


1

4052

Misc taxable - Indicates if Airport Concessionable

JJ


APAC-MISC-A-ACODE(2)

CHAR


4

4053

Misc taxable - Oracle acct code



APAC-MISC-A-SUBACODE(2)

CHAR


5

4057

Misc taxable - Oracle subacct code

GG


APAC-MISC-A-AP-IND(3)

CHAR


1

4062

Misc taxable - Indicates if Airport Concessionable

JJ


APAC-MISC-A-ACODE(3)

CHAR


4

4063

Misc taxable - Oracle acct code



APAC-MISC-A-SUBACODE(3)

CHAR


5

4067

Misc taxable - Oracle subacct code

GG


APAC-MISC-A-AP-IND(4)

CHAR


1

4072

Misc taxable - Indicates if Airport Concessionable

JJ


APAC-MISC-A-ACODE(4)

CHAR


4

4073

Misc taxable - Oracle acct code



APAC-MISC-A-SUBACODE(4)

CHAR


5

4077

Misc taxable - Oracle subacct code

GG


APAC-MISC-A-AP-IND(5)

CHAR


1

4082

Misc taxable - Indicates if Airport Concessionable

JJ


APAC-MISC-A-ACODE(5)

CHAR


4

4083

Misc taxable - Oracle acct code



APAC-MISC-A-SUBACODE(5)

CHAR


5

4087

Misc taxable - Oracle subacct code

GG


APAC-MISC-A-AP-IND(6)

CHAR


1

4092

Misc taxable - Indicates if Airport Concessionable

JJ


APAC-MISC-A-ACODE(6)

CHAR


4

4093

Misc taxable - Oracle acct code



APAC-MISC-A-SUBACODE(6)

CHAR


5

4097

Misc taxable - Oracle subacct code

GG


APAC-MISC-A-AP-IND(7)

CHAR


1

4102

Misc taxable - Indicates if Airport Concessionable

JJ


APAC-MISC-A-ACODE(7)

CHAR


4

4103

Misc taxable - Oracle acct code



APAC-MISC-A-SUBACODE(7)

CHAR


5

4107

Misc taxable - Oracle subacct code

GG


APAC-MISC-A-AP-IND(8)

CHAR


1

4112

Misc taxable - Indicates if Airport Concessionable

JJ


APAC-MISC-A-ACODE(8)

CHAR


4

4113

Misc taxable - Oracle acct code



APAC-MISC-A-SUBACODE(8)

CHAR


5

4117

Misc taxable - Oracle subacct code

GG


APAC-MISC-A-AP-IND(9)

CHAR


1

4122

Misc taxable - Indicates if Airport Concessionable

JJ


APAC-MISC-A-ACODE(9)

CHAR


4

4123

Misc taxable - Oracle acct code



APAC-MISC-A-SUBACODE(9)

CHAR


5

4127

Misc taxable - Oracle subacct code

GG


APAC-MISC-A-AP-IND(10)

CHAR


1

4132

Misc taxable - Indicates if Airport Concessionable

JJ


APAC-MISC-A-ACODE(10)

CHAR


4

4133

Misc taxable - Oracle acct code



APAC-MISC-A-SUBACODE(10)

CHAR


5

4137

Misc taxable - Oracle subacct code

GG


APAC-MISC-A-AP-IND(11)

CHAR


1

4142

Misc taxable - Indicates if Airport Concessionable

JJ


APAC-MISC-A-ACODE(11)

CHAR


4

4143

Misc taxable - Oracle acct code



APAC-MISC-A-SUBACODE(11)

CHAR


5

4147

Misc taxable - Oracle subacct code

GG


APAC-MISC-A-AMT(1)

DECIMAL

9,2

11

4152

Misc taxable amount


Z,S

APAC-MISC-A-AMT(2)

DECIMAL

9,2

11

4163

Misc taxable amount


Z,S

APAC-MISC-A-AMT(3)

DECIMAL

9,2

11

4174

Misc taxable amount


Z,S

APAC-MISC-A-AMT(4)

DECIMAL

9,2

11

4185

Misc taxable amount


Z,S

APAC-MISC-A-AMT(5)

DECIMAL

9,2

11

4196

Misc taxable amount


Z,S

APAC-MISC-A-AMT(6)

DECIMAL

9,2

11

4207

Misc taxable amount


Z,S

APAC-MISC-A-AMT(7)

DECIMAL

9,2

11

4218

Misc taxable amount


Z,S

APAC-MISC-A-AMT(8)

DECIMAL

9,2

11

4229

Misc taxable amount


Z,S

APAC-MISC-A-AMT(9)

DECIMAL

9,2

11

4240

Misc taxable amount


Z,S

APAC-MISC-A-AMT(10)

DECIMAL

9,2

11

4251

Misc taxable amount


Z,S

APAC-MISC-A-AMT(11)

DECIMAL

9,2

11

4262

Misc taxable amount


Z,S

APAC-MISC-A-TCODE(1)

INTEGER


1

4273

Misc tax code - should be 2 if GST only or 3 if GST and Stamp Duty

A


APAC-MISC-A-TCODE(2)

INTEGER


1

4274

Misc tax code - should be 2 if GST only or 3 if GST and Stamp Duty

A


APAC-MISC-A-TCODE(3)

INTEGER


1

4275

Misc tax code - should be 2 if GST only or 3 if GST and Stamp Duty

A


APAC-MISC-A-TCODE(4)

INTEGER


1

4276

Misc tax code - should be 2 if GST only or 3 if GST and Stamp Duty

A


APAC-MISC-A-TCODE(5)

INTEGER


1

4277

Misc tax code - should be 2 if GST only or 3 if GST and Stamp Duty

A


APAC-MISC-A-TCODE(6)

INTEGER


1

4278

Misc tax code - should be 2 if GST only or 3 if GST and Stamp Duty

A


APAC-MISC-A-TCODE(7)

INTEGER


1

4279

Misc tax code - should be 2 if GST only or 3 if GST and Stamp Duty

A


APAC-MISC-A-TCODE(8)

INTEGER


1

4280

Misc tax code - should be 2 if GST only or 3 if GST and Stamp Duty

A


APAC-MISC-A-TCODE(9)

INTEGER


1

4281

Misc tax code - should be 2 if GST only or 3 if GST and Stamp Duty

A


APAC-MISC-A-TCODE(10)

INTEGER


1

4282

Misc tax code - should be 2 if GST only or 3 if GST and Stamp Duty

A


APAC-MISC-A-TCODE(11)

INTEGER


1

4283

Misc tax code - should be 2 if GST only or 3 if GST and Stamp Duty

A


FILLER



1

4284




APAC-UPSELL-TTL-AMT



11

4285

Upsell amount (above 2nd sub)



FILLER



77

4296




APAC-UNBND-CDW-TTL



11

4373

AER amount inclusive to Rate



APAC-UNBND-PAI-TTL



11

4384

PAI/PEC amount inclusive to rate



APAC-UNBND-TP-TTL



11

4395

N/A



FILLER



11

4406




APAC-GOV-SURCHG-TTL

DECIMAL

9,2

11

4417

Government Surcharge Total - currently N/A



APAC-GOV-SURCHG-RT

DECIMAL

9,2

11

4428

Government surcharge Rate - currently N/A



APAC-GOV-SURCHG-DAYS

INTEGER


2

4439

Government Surcharge Days charged - currently N/A



APAC-REVENUE-ADJ

DECIMAL

9,2

11

4441

Revenue adjustment



FILLER



216

4452




APAC-VEH-NBR

CHAR


8

4668

Vehicle Unit Number



FILLER



10

4676




APAC-VEH-MODEL

CHAR


6

4686

Vehicle Model



APAC-VEH-COLOR

CHAR


4

4692

Vehicle Color



APAC-VEH-LIC-NBR

CHAR


10

4696

Vehicle License Tag Number



APAC-VEH-LIC-STATE

CHAR


2

4706

State (or country) of license tag issue



APAC-OWN-CTRY

CHAR


2

4708

Vehicle owner ISO country code

P


APAC-OWN-LIC-LOC

CHAR


5

4710

Vehicle owner city and location code(CCCLL)

P


FILLER



9

4715




APAC-NBR-OF-VEH-EXCHANGES

INTEGER


2

4724

Number of vehicle exchanges


Z,S

APAC-VEH-MDL-DESC

CHAR


16

4726

Vehicle model description



APAC-ENGINE-CAP

CHAR


4

4742

Engine size



APAC-CAR-VALUE

DECIMAL

9,2

11

4746

Value of Vehicle rented



FILLER



85

4757




APAC-ADD-DRV-NAME

CHAR


30

4842

Additional Driver Name



APAC-ADD-DRV-DL-NBR

CHAR


26

4872

Additional Driver Drivers License Number



APAC-ADD-DRV-CTRY

CHAR


20

4898

Additional driver Country

H


FILLER



18

4918




APAC-ADD-DRV-BIRTH-PLACE

CHAR


20

4936

Additional Driver Birthplace



APAC-ADD-DRV-CTRY-CD

CHAR


2

4956

Additional Driver Country Code

I


APAC-ADD-DRV-CHG-FLAG

CHAR


2

4958

= Y if Additional Driver charges present



APAC-ADD-DRV-DLY-RT

DECIMAL

9,2

11

4960

Additional Driver daily rate



APAC-ADD-DRV-MAX-AMT

DECIMAL

9,2

11

4971

Additional Driver Maximum charges



APAC-ADD-DRV-TTL

DECIMAL

9,2

11

4982

Additional Driver charges



APAC-ADL-ISSUE-CC

INTEGER


2

4993

Additional Driver Driver's License Issue Date - Century

J


APAC-ADL-ISSUE-YY

INTEGER


2

4995

Additional Driver Driver's License Issue Date - Year

J


APAC-ADL-ISSUE-MM

INTEGER


2

4997

Additional Driver Driver's License Issue Date - Month

J


APAC-ADL-ISSUE-DD

INTEGER


2

4999

Additional Driver Driver's License Issue Date - Day

J


APAC-ADL-EXP-CC

INTEGER


2

5001

Additional Driver Drivers License Expiration - Century

J


APAC-ADL-EXP-YY

INTEGER


2

5003

Additional Driver Drivers License Expiration - Year

J


APAC-ADL-EXP-MM

INTEGER


2

5005

Additional Driver Drivers License Expiration - Month

J


APAC-ADL-EXP-DD

INTEGER


2

5007

Additional Driver Drivers License Expiration - Day

J


APAC-ADD-DRV-CC

INTEGER


2

5009

Additional Driver Date of Birth - Century

J


APAC-ADD-DRV-YY

INTEGER


2

5011

Additional Driver Date of Birth - Year

J


APAC-ADD-DRV-MM

INTEGER


2

5013

Additional Driver Date of Birth - Month

J


APAC-ADD-DRV-DD

INTEGER


2

5015

Additional Driver Date of Birth - Day

J


FILLER



76

5017




APAC-RES-ID-NBR

CHAR


12

5093

Reservation ID number



APAC-BOOKING-SOURCE

CHAR


2

5105

Reservation Country



FILLER



28

5107




APAC-GOLD-RENT-FLAG

CHAR


1

5135

Gold Rent Flags



APAC-GOLD-GS-FLAG

CHAR


1

5136

Gold Rent Flags



APAC-GOLD-GA-FLAG

CHAR


1

5137

Gold Rent Flags



APAC-GOLD-PS-FLAG

CHAR


1

5138

Gold Rent Flags



APAC-AIRLINE-CD

CHAR


2

5139

Airline Code



APAC-AIRLINE-FLT-NBR

CHAR


4

5141

Airline Flight Nbr



FILLER



4

5145




APAC-SPEC-SRV-CODE

CHAR


6

5149

Service indicator - retrieved from Number 1 club number



FILLER



6

5155




APAC-BOOKING-TIME

INTEGER


4

5161

Reservation Time - HHMM format

O

Z

APAC-RA-FT-PREFIX

CHAR


3

5165

Frequent Traveler Code Prefix



APAC-RA-FT-NUMERIC

CHAR


18

5168

Frequent Traveler Code Numeric Part



FILLER



1

5186




APAC-FT-INFO-2

CHAR


22

5187

Hotel Number - Frequent Traveller Plan



APAC-VENDOR-NBR

CHAR


20

5209

Not used in AU



APAC-BOOKING-CC

INTEGER


2

5229

Booking date - Century

J

Z

APAC-BOOKING-YY

INTEGER


2

5231

Booking date - Year

J

Z

APAC-BOOKING-MM

INTEGER


2

5233

Booking date - Month

J

Z

APAC-BOOKING-DD

INTEGER


2

5235

Booking date - Day

J

Z

FILLER



50

5237




APAC-REMARK1

CHAR


30

5287

Remarks



APAC-REMARK2

CHAR


30

5317

Remarks



APAC-REMARK3

CHAR


30

5347

Remarks



APAC-PUB-RATE-PLAN-OUT

CHAR


6

5377

Published rate plan - Checkout



APAC-PUB-RATE-PLAN-IN

CHAR


6

5383

Published rate plan - Checkin



APAC-RATE-CLASS-NEW

CHAR


4

5389

Rate Class



APAC-VEH-CLASS-NEW

CHAR


4

5393

Vehicle Class



APAC-RES-VEH-CLASS-NEW

CHAR


4

5397

Reservation Vehicle Class



FILLER



66

5401




APAC-UPSELL-CLASS-NEW

CHAR


4

5467

Upsell Vehicle Class



FILLER



6

5471




APAC-USER-PREP-ORIG

CHAR


10

5477

Counter Agent - Check out



APAC-USER-PREP

CHAR


10

5487

Post processing agent - Check out



APAC-TERM-LDN-PREP

INTEGER


4

5497

Terminal Printer - Check out


Z,S

APAC-USER-COMP

CHAR


10

5501

Post processing agent - Check in



APAC-TERM-LDN-COMP

INTEGER


4

5511

Terminal Printer - Check in


Z,S

APAC-USER-COMP-ORIG

CHAR


10

5515

Counter Agent - Check in



APAC-FORMS-CTL-NBR

INTEGER


10

5525

Check out Form Number


Z

APAC-NBR-COPIES-RNT

INTEGER


2

5535

Number of copies @ checkout


Z,S

APAC-NBR-COPIES-RTN

INTEGER


2

5537

Number of copies @ checkin


Z,S

FILLER



64

5539




APAC-VERSION-NBR

INTEGER


4

5603

incremented by sending system each time rental is transmitted

!!!

Z

FILLER



6

5607




APAC-TM-POSTED

INTEGER


4

5613

Time Posted HHMM



FILLER



10

5617




APAC-ORIG-RENT-DATE-TIME



12

5627

Original Rent date-time (if not = current return Time)CCMMDDYYHHNN



APAC-DT-POSTED-CC

INTEGER


2

5639

Date Posted - century

J


APAC-DT-POSTED-YY

INTEGER


2

5641

Date Posted - Year

J


APAC-DT-POSTED-MM

INTEGER


2

5643

Date Posted - Month

J


APAC-DT-POSTED-DD

INTEGER


2

5645

Date Posted - Day

J


APAC-ORIG-RTRN-DATE-TIME

INTEGER


12

5647

Original Return date-time (if not = current return Time)CCMMDDYYHHNN



FILLER



260

5659




APAC-CUST-NBR

CHAR


10

5919

Customer number



APAC-INS-NBR

CHAR


6

5929

Insurance Number



APAC-INS-NBR-1

CHAR


10

5935

Insurance Number -1



APAC-INS-NBR-2

CHAR


10

5945

Insurance Number -2



APAC-TARIFF-CODE

CHAR


10

5955

Insurance tariff code



FILLER



28

5965




APAC-TRANSMITTAL-ID

CHAR


12

5993

GCC Transmittal ID



FILLER



88

6005




APAC-MILEAGE-IN-6

INTEGER


6

6093

Kilometers reading - checkout


Z,S

APAC-MILEAGE-OUT-6

INTEGER


6

6099

Kilometers reading - return


Z,S

FILLER



26

6105




APAC-MLS-DRIVEN-6

INTEGER


6

6131

Kilometers driven (difference of above 2 fields)


Z,S

APAC-RMS-CUST-ORD-NBR

CHAR


20

6137

Not used in AU



APAC-CSR-REASON-CD-1

CHAR


2

6157

Inc-prob-code



APAC-CSR-ACTION-CD-1

CHAR


1

6159

Inc-action-code



APAC-CSR-SATISF-LV-1

CHAR


1

6160

Inc-satisfaction-level



APAC-CSR-AMOUNT-1

DECIMAL

3,2

5

6161

Inc-amt


Z,S

APAC-CSR-FCN-CD-1

CHAR


2

6166

Inc-occurance-code



APAC-CSR-USER-ID-1

CHAR


4

6168

Last four characters of Inc-empl-code



APAC-CSR-REASON-CD-2

CHAR


2

6172

Inc-prob-code



APAC-CSR-ACTION-CD-2

CHAR


1

6174

Inc-action-code



APAC-CSR-SATISF-LV-2

CHAR


1

6175

Inc-satisfaction-level



APAC-CSR-AMOUNT-2

DECIMAL

3,2

5

6176

Inc-amt


Z,S

APAC-CSR-FCN-CD-2

CHAR


2

6181

Inc-occurance-code



APAC-CSR-USER-ID-2

CHAR


4

6183

Last four characters of Inc-empl-code



APAC-CSR-REASON-CD-3

CHAR


2

6187

Inc-prob-code



APAC-CSR-ACTION-CD-3

CHAR


1

6189

Inc-action-code



APAC-CSR-SATISF-LV-3

CHAR


1

6190

Inc-satisfaction-level



APAC-CSR-AMOUNT-3

DECIMAL

3,2

5

6191

Nc-amt


Z,S

APAC-CSR-FCN-CD-3

CHAR


2

6196

Inc-occurance-code



APAC-CSR-USER-ID-3

CHAR


4

6198

Last four characters of Inc-empl-code



APAC-VAT-ID-NBR

CHAR


26

6202

VAT fields - need to see if applies to AU



FILLER



168

6228




APAC-TAS-CTRY-CURR-CODE

CHAR


3

6396




APAC-DYN-EXCHANGE-RATE

INTEGER

6,7

13

6399



Z

APAC-DYN-CURR-CODE

CHAR


3

6412




APAC-DYN-VER-AMOUNT

DECIMAL

9,2

11

6415



Z,S

APAC-DYN-EXTEND-VER-AMOUNT

INTEGER


9

6426



Z

APAC-DYN-ADD-VER-AMOUNT

INTEGER


9

6435



Z

APAC-DYN-PREV-EXTEND-VER-AMT

INTEGER


9

6444



Z

APAC-DYN-TTL-CHARGE

DECIMAL

9,2

11

6453



Z

FILLER



213

6464




APAC-IT-NBR

CHAR


12

6677

Inclusive Tour Number - Required for ITV MOP (Ghosted voucher)



APAC-VOUCHER-HCC-NO

CHAR


20

6689

Travel Agent HCC number



APAC-VOUCHER-BILL-NAME

CHAR


30

6709




APAC-VOUCHER-BILL-ADDR1

CHAR


30

6739




APAC-VOUCHER-BILL-ADDR2

CHAR


30

6769




APAC-VOUCHER-BILL-CITY

CHAR


30

6799




APAC-VOUCHER-BILL-CTRY

CHAR


3

6829




FILLER



15

6832




APAC-VOUCHER-BILL-STATE

CHAR


2

6847




APAC-VOUCHER-BILL-ZIP

CHAR


10

6849




FILLER



12

6859




APAC-VOUCHER-AGENT-REF

CHAR


10

6871

Voucher Agent - Referred By



FILLER



40

6881




APAC-VOUCHER-CLASS

CHAR


4

6921

Voucher Class



FILLER



16

6925




APAC-VOUCHER-TYPE

CHAR


6

6941

Voucher Type (ITV or RCV)



FILLER



24

6947




APAC-VOUCHER-NBR

CHAR


20

6971

Voucher Number



FILLER



130

6991




APAC-VOUCHER-VALUE

DECIMAL

9,2

11

7121

Voucher Amount - (Coupon value)


Z,S

FILLER



44

7132




APAC-ITV-TANDM-VALUE

DECIMAL

9,2

11

7176

Time and kilometers charges paid by travel agent - incl. tour vchr


Z,S

APAC-ITV-CDW-VALUE

DECIMAL

9,2

11

7187

AER charges paid by travel agent - incl. tour vchr


Z,S

APAC-ITV-PAI-VALUE

DECIMAL

9,2

11

7198

PAI/PEC paid by travel agent - incl. tour vchr


Z,S

APAC-ITV-PKG-VALUE

DECIMAL

9,2

11

7209

PKG paid by travel agent


Z,S

APAC-ITV-TAX-VALUE

DECIMAL

9,2

11

7220

GST paid by travel agent - does not include GST on commission


Z,S

APAC-VOUCHER-DYS

INTEGER


2

7231

number of voucher days


Z

APAC-ITV-ADE-VALUE

DECIMAL

9,2

11

7233

ADE paid by travel agent


Z,S

APAC-ITV-VLF-VALUE

DECIMAL

9,2

11

7244

Vehicle Rego recovery paid by travel agent - incl tour vchr


Z,S

FILLER



172

7255




APAC-CR-INVOICE-NBR

INTEGER


10

7427

Petty cash Check nbr (not common)


Z

FILLER



544

7437




APAC-DRB-CTRY

CHAR


2

7981

DRB ISO Ctry

P,HH


APAC-DRB-CITY-LOC

CHAR


5

7983

DRB City LOC(CCCLL)

P,HH


FILLER



1

7988




APAC-DRB-DATE-CC

INTEGER


2

7989

DRB Date -Century

J,HH

Z

APAC-DRB-DATE-YY

INTEGER


2

7991

DRB Date - Year

J,HH

Z

APAC-DRB-DATE-MM

INTEGER


2

7993

DRB Date - Month

J,HH

Z

APAC-DRB-DATE-DD

INTEGER


2

7995

DRB Date - Day

J,HH

Z

APAC-DRB-TIME

INTEGER


4

7997

DRB Time - HHMM

O,HH

Z

FILLER



2000

8001




APAC-AP-PKG-AER-FG

CHAR


1

10001

Y=PKG or AER in basis for ACFR



APAC-AP-ADE-FG

CHAR


1

10002

obsolete



APAC-AP-TDIFF-FG

CHAR


1

10003

Y=STAMP DUTY in basis for ACFR



APAC-PKG-TTL

DECIMAL

11,2

13

10004

PKG amt total


Z,S

APAC-PKG-CODE

INTEGER


1

10017

PKG tax code

A

Z

APAC-PKG-RATE

DECIMAL

11,2

13

10018

PKG daily rate


Z,S

APAC-PKG-DAYS

INTEGER


4

10031

PKG days charged


Z,S

APAC-PKG-IND

CHAR


1

10035

PKG option indicator

B


APAC-ADE-TTL

DECIMAL

11,2

13

10036

obsolete


Z,S

APAC-ADE-CODE

INTEGER


1

10049

obsolete

A

Z

APAC-ADE-RATE

DECIMAL

11,2

13

10050

obsolete


Z,S

APAC-ADE-DAYS

CHAR


4

10063

obsolete


Z,S

APAC-ADE-IND

CHAR


1

10067

obsolete

B


APAC-TOLL-CHG-TTL

DECIMAL

11,2

13

10068

Toll charges amt total


Z,S

APAC-TOLL-CODE

INTEGER


1

10081

Toll charges tax code

A

Z

APAC-TOLL-IND

CHAR


1

10082

Toll charges indicator

C


APAC-VLF-AMT

DECIMAL

11,2

13

10083

Vehicle Rego Recovery amount


Z,S

APAC-VLF-DAILY-RATE

DECIMAL

11,2

13

10096

Vehicle Rego Recovery daily rate


Z,S

APAC-VLF-DAYS

INTEGER


4

10109

Vehicle Rego Recovery days charged


Z,S

APAC-TRANS-FEE-INC-IND

CHAR


1

10113

Vehicle Rego inclusive indicator

D


APAC-TAX-DIFF-AMT

DECIMAL

11,2

13

10114

Stamp Duty tax amt


Z,S

APAC-TAX-DIFF-CODE

INTEGER


1

10127

Stamp Duty tax code

A

Z

APAC-TAX-DIFF-PCT

DECIMAL

3,5

8

10128

Stamp Duty tax percentage

E

Z,S

APAC-TAX-DIFF-TAXABLE

DECIMAL

11,2

13

10136

Stamp Duty taxable subtotal


Z,S

APAC-TAXABLE-TOTAL

DECIMAL

11,2

13

10149

GST taxable subtotal


Z,S

APAC-ITV-RIHLIT-VALUE

DECIMAL

11,2

13

10162

ITV OWR(Repositioning) amount


Z,S

APAC-ITV-STAMP-VALUE

DECIMAL

11,2

13

10175

ITV Stamp Duty amount


Z,S

APAC-FUEL-CARD-NBR

CHAR


20

10188

Fuel Card Nbr



APAC-LOC-SVC-CHG-AMT

DECIMAL

9,2

11

10208

Location Service Charge Amt


Z,S

APAC-LOC-SVC-CHG-RATE

DECIMAL

5,6

11

10219

Location Service Charge Percentage or Daily Rate


Z,S

APAC-LOC-SVC-CHG-CODE

INTEGER


1

10240

Location Service Charge Tax Code

A

Z

APAC-LOC-SVC-CHG-BASIS

DECIMAL

9,2

11

10241

Basis of Location Service Charge - either number of days if a daily rate or subtotal if percentage


Z,S

APAC-LOC-SVC-CHG-CALC-IND

CHAR


1

10252

indicates how service charge was calculated;

K


APAC-LOC-SVC-CHG-IND

CHAR


1

10253


C


















FILLER

CHAR


746

10254












NOTES:








A: indicates which taxes are assessed against this field; 0=Nontaxable, 1= Stamp Duty, 2=GST, 3=Both SD and GST








B: option indicator; I = inclusive(rate or tour), Y=amount present, N=amount not present








C: addtl/misc indicator; A=above total charges(taxable) M=below total charges(nontaxable)








D: inclusive indicator; Y=inclusive(rate or tour) N=non-inclusive








E: tax percentage format - 10.5% should be loaded as 010.50000 not 000.10500 (applies to all percentages in buffer)








F: 2 digit ISO country code








G: Required for US and Canada addresses, also required for Australia addresses?????








H: Country Name, State for US








I: Should be State for US, country code for all others








J: Date formats - If date is completely unknown, use 00010101. If CCYYMM is known, but not DD, use max for that month if date is expiration date, use 01 for any other unknown day.
















K: D=Daily rate * days ; P = subtotal * percentage; A = fixed amount








L: See Intranet for valid MOP(method of payment) values








M: L= licensee; C = Corporate
















O: Rental and Return times format: HHMM, 24-hour format; Midnight = 0000; 6:30am =0630; 6:30pm = 1830; 11:59pm = 2359








P: Alpha location(WWD) = CCTTTLL; CC = ISO Ctry code; TTT = Hertz City Code; LL = Location. Ex. AUMEL01








Q: Numeric location = 5 digit numeric area + 2 digit location code








R: Y = inclusive, N = noniclusive; inclusive means Rate-inclusive or Tour-inclusive








S: CDW(AER) Option Indicator: Y=present, I = Inclusive(rate or tour), W = Waived, M = MAX, N = None








T: Option Indicator: Y=present, I = Inclusive(rate or tour), W = Waived, N = None








U: Required if CDP number present








V: R= Rate Engine Calculation T = TAS Calculation








W: F = Free; Y = Applied; N = None
































AA: Time & Mileage total = All time and mileage charges + Upsell + Revenue Adjustment








BB: Total of misc charges (or deductions) that are GST taxable (regardless of Stamp Duty)








CC: Total of misc charges (or deductions) that are not GST taxable (regardless of Stamp Duty)








DD: Total Charges = Subtotal 2 + Delivery + Collection + Addl. Driver + Fuel charges and Service charges + Insurances + OWR + Age Diff + Veh Rego + Stamp Duty + Misc items that are GST taxable








EE: Net Due = Total Charges + Misc items that are not GST taxable - Voucher Total - Deposit + Refund - Cash Paid








FF: Option B = FPO(Fuel Purchase Option)








GG: Subacct codes: Per Oracle if they exist, default to 00000 if not. If occurrence amount = 0, should be spaces








HH: See intranet for DRB location assignment rules








JJ: C = Airport Concessionable; N = Not concessionable








!!!: Only 1 should be sent while data is sent by batch file transfer; only applies to real-time counter updates








ABBREVIATIONS:








LDW/CDW = Loss Damage Waiver/Collision Damage Waiver - Equivalent to AER = Accident Excess Reduction








TP = Theft Protection Insurance (probably doesn't apply to AU)








PAI/PEC = Personal Accident Insurance/Person Effects Coverage








SDW or SCDW = Super CDW (May be comparable to MAX PKG, but we are not treating it as such unless we can confirm)








RIHLIT or Intercity = Rent It Here Leave It There - Equivalent to OWR (Repositioning)








VLF = Vehicle License Fee - Equivalent to Vehicle Rego Recovery








RMS = ??? Researching - will update later