Overdue Deposits

Report Parameters

Field

Description

Report Name

The name of the report.

Sample Report

A picture containing text

Description automatically generated

Report Fields

Field

Description

Name

The last name and first name of the guest added to the reservation.

Resv.#

The confirmation number of the reservation.

ID

Unique ID of the user who created the reservation.

Date Made

The date on which the reservation was created.

Paid

The amount paid by the guest.

Dep Nights

The number of nights for which the reservation is made.

Deposit was due on

The date by which the deposit must be paid by the guest.

Amount Due

The amount that must be paid by the guest.

Remaining Amount Due

The difference of the amount due and paid amount.

Addr

The address of the guest.

Home

The home phone number of the guest.

Work

The work phone number of the guest.

VIP

The code that identifies the VIP type of the guest at the property.

Company

The name of the company to which the guest belongs.

BOOKID

A unique ID to identify the reservation.

GRP

Group code associated with the reservation.

GTD

Indicates whether the guest reservation is guaranteed.

Status

The status of the reservation.

Arr

The arrival date of the guest.

Dep

The departure date of the guest.

#NTS

Number of nights of stay.

RmType

The room type selected for the reservation.

Rm#

The room number of the guest.

Rate

The rate of the room type selected for the reservation.

#Rms

Number of rooms associated with the reservation.

Guest Type

The guest type selected when creating the reservation.

Segment 1

The segment 1 code selected when creating the reservation.

Segment 2

The segment 2 code selected when creating the reservation.

Tariff

The tariff of the preferred room type.

Plan

Name of the package offer reserved by the guest.

Pay Type

The payment method used by the guest to settle the bill.

IATA

The IATA number of a travel agent associated to the company.

Travel

The name of the travel agency.

C/L#

The account number of the city leger associated with the revenue centre for which the deposit revenue posting is made.

Comments

Comments entered by the user, if any.

Adult

The number of adults on the reservation.

Youth

The number of youths on the reservation.

Child1

Number of children in the child 1 age category.

Child2

Number of children in the child 2 age category.

Child3

Number of children in the child 3 age category.