Custom-Reports: Difference between revisions

Jump to navigation Jump to search
← Older editNewer edit →
Lesley (talk | contribs)
3,970 edits
Lesley (talk | contribs)
3,970 edits
Line 551: Line 551:
| Last Night
| Last Night
| Last night booked
| Last night booked
|-
| Nights
| Number of nights
|-
| Title
| Guest title
|-
| First Name
| Guest First name
|-
| Last Name
| Guest last name
|-
| Full Name
| Guest full name
|-
| Guest Comments
| Guest Comments
|-
| Notes
| Notes (Summary tab)
|-
| Arrival Time
| Guest arrival time
|-
| Adults
| Number of Adults
|-
| Children
| Number of Children
|-
| Guests
| Total number of guests
|-
| Telephone
| Guest telephone number
|-
| Mobile
| Guest mobile number
|-
| Fax
| Guest fax number
|-
| Company
| Guest Company details
|-
| Address
| Guest Address
|-
| City
| Guest City
|-
| State
| Guest State
|-
| Postcode
| Guest Postcode
|-
| Country (selector)
| Guest Country from the selector
|-
| Country (text)
| Guest Country text, manually entered
|-
! scope="col"| Detail Tab
|-
| Message
| Guest Message
|-
| Custom Question 1-10
| Answer to Custom question 1-10
|-
| Reference
| content of the booking reference field
|-
| Quantity
| Number of rooms booked
|-
| Flag
| Latest flag set in the booking
|-
| Status Code
| Status Code can be used for your own purposes and for triggering auto actions.
|-
| Original Referrer
| Original referrer
|-
| Channel Ref
| Channel booking reference
|-
| Referrer
| Referrer
|-
| Booking Date
| booking date
|-
| Booking IP
| Ip address of the computer used to make the booking
|-
| API Message
| Channel booking information
|-
Mail & Action Tab
| Email
| Guest email address
|-
| Language
| Guest language
|-
! scope="col"| Charges & Payments Tab
|-
| Charge Item Description
| Charge Item Description
|-
| Charge Item Qty
| Charge Item Qty
|-
| Charge Item Price
| Charge Item Price
|-
| Charge Item Net
| Charge Item Net
|-
| Charge Item Total
| Charge Item Total
|-
| Charge Item Status
| Charge Item Status
|-
| Charge Item Vat %
| Charge Item Vat %
|-
| Charge Item Vat
| Charge Item Vat
|-
| Charge Item Date
| Charge Item Date
|-
| Charge Item Invoicee Name
| Charge Item Invoicee Name
|-
| Charge Item Invoicee Code
| Charge Item Invoicee Code
|-
| Payment Item Description
| Payment Item Description
|-
| Payment Item Amount
| Payment Item Amount
|-
| Payment Item Status
| Payment Item Status
|-
| Payment Item Date
| Payment Item Date
|-
| Payment Item Invoicee Name
| Payment Item Invoicee Name
|-
| Payment Item Invoicee Code
| Payment Item Invoicee Code
|-
| Pending Payment Item Description
| Pending Payment Item Description
|-
| Pending Payment Item Amount
| Pending Payment Item Amount
|-
| Pending Payment Item Status
| Pending Payment Item Status
|-
| Pending Payment Item Due
| Pending Payment Item Due
|-
| Pending Payment Item Invoicee Name
| Pending Payment Item Invoicee Name
|-
| Pending Payment Item Invoicee Code
| Pending Payment Item Invoicee Code
|-
| Pending Payment Item Rule
| Pending Payment Item Rule
|-
| Invoicee
| Invoicee code assigned to booking
|-
| Offer
| Offer number booked
|-
| Price
| Indicative price information at time of booking, not recalculated
|-
| Tax
| Indicative tax information at time of booking, not recalculated
|-
| Deposit
| Indicative Deposit information at time of booking, not recalculated
|-
| Commission
| Indicative Commission information at time of booking, not recalculated
|-
| Discount Voucher Code
| discount voucher code entered by the guest at the time of booking
|-
| Rate Description
| description of the rate that was quoted at time of booking
|-
! scope="col"| Invoice Tab
|-
| Invoice Charges Value
| Invoice Charges Value
|-
| Invoice Balance Value
| Invoice Balance Value
|-
| Invoice Payments Value
| Invoice Payments Value
|-
| Invoice Vat Value
| Invoice Vat Value
|-
| Invoice Vat by Percentage
| Invoice Vat by Percentage
|-
| Invoice Description Values
| Invoice Description Values
|-
| Invoice Status Values
| Invoice Status Values
|-
| Invoice Item Description
| Invoice Item Description
|-
| Invoice Item Qty
| Invoice Item Qty
|-
| Invoice Item Price
| Invoice Item Price
|-
| Invoice Item Net
| Invoice Item Net
|-
| Invoice Item Total
| Invoice Item Total
|-
| Invoice Item Status
| Invoice Item Status
|-
| Invoice Item Vat %
| Invoice Item Vat %
|-
| Invoice Item Vat
| Invoice Item Vat
|-
| Invoice Item Date
| Invoice Item Date
|-
| Invoice Item Invoicee Name
| Invoice Item Invoicee Name
|-
| Invoice Item Invoicee Code
| Invoice Item Invoicee Code
|-
| Invoice Item Booking Ref
| Invoice Item Booking Ref
|-
| Invoice Number
| Invoice Number
|-
| Invoice Date
| Invoice Date
|-
| First Invoice Item Charge Value
| First Invoice Item Charge Value
|-
| Second Invoice Item Charge Value
| Second Invoice Item Charge Value
|-
| Third Invoice Item Charge Value
| Third Invoice Item Charge Value
|-
| Fourth Invoice Item Charge Value
| Fourth Invoice Item Charge Value
|-
| Fifth Invoice Item Charge Value
| Fifth Invoice Item Charge Value
|-
| Sixth Invoice Item Charge Value
| Sixth Invoice Item Charge Value
|-
| Extra Invoice Item 1-20 Value
| Extra Invoice Item 1-20 Value
|-
| Extra Invoice Item 1-20 Qty
| Extra Invoice Item 1-20 Qty
|-
| Extra Invoice Item 1-20 VAT
| Extra Invoice Item 1-20 VAT
|-
| Extra Invoice Manual Value
| Extra Invoice Manual Value
|-
| Extra Invoice Manual Qty
| Extra Invoice Manual Qty
|-
| Extra Invoice Manual VAT
| Extra Invoice Manual VAT
|-
| Print Invoice
| Icon to print Invoice
|-
| Assign Invoice Number
| Icon to Assign Invoice number
|-
| Invoicee Code
| Invoicee Code - Guest Management > Invoicee
|-
| Invoicee Name
| Invoicee Name assigned to the booking
|-
| Invoicee Currency
| Invoicee Currency - Guest Management > Invoicee
|-
| Invoicee Template 1-8
| Invoicee Template 1-8 - Guest Management > Invoicee
|-
| Base Value
| Lodging Price (Accommodation price)
|-
| Base Qty
| Lodging quantity (Accommodation)
|-
| Upsell 1-20 Value
| Upsell items Value added to the booking
|-
| Upsell 1-20 Qty
| Upsell items Qty added to the booking
|-
| Upsell 1-20 VAT
| Upsell items VAT added to the booking
|-
! scope="col"| Calculated Fields
|-
| Price less Commission
| Calculation - Price field - Commission field
|-
| Price less Tax
| Calculation - Price field - Tax field
|-
| Price less Commission and Tax
| Calculation - Commission field - Tax field
|-
| Cancel Date
| Cancelled date
|-
| Modified Date
| Modified date
|-
| Booked Days In Advance
| Number of days between booking and check-in
|-
| Price per Day
| Average price, booking price / number of nights
|-
| People Nights
| Number of people x number of nights
|-
| Adult Nights
| Number of adults x number of nights
|-
| Child Nights
| Number of children x number of nights
|-
| Bookings in Group
| Number of bookings in the group
|-
! scope="col"| General Fields
|-
| Guests Ids
| Guest id from Guest database
|-
| Guests Names
| Guest Names (Group booking guest names)
|-
| Guests First Names
| Guest First Names (Group booking guest names)
|-
| Guests Last Names
| Guest Last Names (Group booking guest names)
|-
| Group Notes
| Notes for group bookings
|-
| Account
| Account id of the booked property
|-
| Random 1
| a 1 digit random number seeded from the booking number
|-
| Random 2
| a 2 digit random number seeded from the booking number
|-
| Random 3
| a 3 digit random number seeded from the booking number
|-
| Random 4
| a 4 digit random number seeded from the booking number
|-
| Random 5
| a 5 digit random number seeded from the booking number
|-
| Random 6
| a 6 digit random number seeded from the booking number
|-
| Random 7
| a 7 digit random number seeded from the booking number
|-
| Random 8
| a 8 digit random number seeded from the booking number
|-
| Bedding
| Displays bedding info codes
|-
| Currency
| Property Currency
|-
| Room Template 1-8
| Properties > Setup > Rooms > Room Template 1-8
|-
| Property Template 1-8
| Properties > Description > Property Template 1-8
|-
| Room Id
| Room id assigned for the booking
|-
| Property Id
| Property id of booking
|-
|-
Retrieved from "https://wiki.beds24.com/index.php/Custom-Reports"