Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name given to the reservation.
 ARRIVALDATE date   The date that the entire group will be visiting.
 ARRIVALTIME UDT_HOURMINUTE   Default = '' The arrival time of the entire group on the reservation.
 NUMBEROFBUSES smallint   Default = ((0)) The number of buses that will be arriving.
 ARRIVALNOTES nvarchar(255)   Default = '' Notes specific to the group's arrival.
 DRIVERNAME nvarchar(100)   Default = '' Name of a bus driver who may be contacted.
 DRIVERPHONENUMBER nvarchar(100)   Default = '' Phone number of the driver who may be contacted.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 DEPOSITREQUIRED bit   Default = 0 Indicates whether a deposit is required on the reservation.
 DEPOSITAMOUNT money   Default = 0 Indicates the amount due for the deposit.
 DEPOSITDUEDATE date If a deposit is required, the date it is due by.
 FINALDUEDATE date   The date the final payment for a reservation is due.
 FINALCOUNTREQUIRED bit   Default = 0 Indicates whether a final count of visitors is required on a reservation
 FINALCOUNTDUEDATE date The date the final count of visitors for a reservation is due.
 FINALCOUNTRECEIVED bit   Default = 0 Indicates whether a final count of visitors has been received for a reservation
 CONTRACTREQUIRED bit   Default = 0 Indicates whether a contract is required on a reservation
 CONTRACTDUEDATE date The date the contract for a reservation is due.
 CONTRACTRECEIVED bit   Default = 0 Indicates whether a contract has been received.
 CONTRACTSENT bit   Default = 0 Indicates whether a contract has been sent.
 FINALCOUNTRECEIVEDDATE date The date in which the final count was received.
 PRICINGCODE tinyint   Default = 0 The pricing structure to use for the reservation.
 PRICING nvarchar(10) (Computed) CASE [PRICINGCODE] WHEN 0 THEN N'Per ticket' WHEN 1 THEN N'Flat rate' END Provides a translation for the 'PRICINGCODE' field.
 ORDERBALANCESENT bit   Default = 0 Indicates whether the order invoice has been sent.
 SECURITYDEPOSITREQUIRED bit   Default = 0 Indicates whether a security deposit is required on the reservation.
 SECURITYDEPOSITAMOUNT money   Default = 0 Indicates the amount due for the security deposit.
 SECURITYDEPOSITDUEDATE date If a security deposit is required, the date it is due by.
 SECURITYDEPOSITSTATUSCODE tinyint   Default = 0 The status of security deposit.
 SECURITYDEPOSITSTATUS nvarchar(18) (Computed) CASE [SECURITYDEPOSITSTATUSCODE] WHEN 0 THEN N'Not paid' WHEN 1 THEN N'Paid' WHEN 2 THEN N'Refunded' WHEN 3 THEN N'Withheld' WHEN 4 THEN N'Partially refunded' END Provides a translation for the 'SECURITYDEPOSITSTATUSCODE' field.
 STARTDATETIME datetime (Computed) dbo.UFN_RESERVATION_STARTDATETIME(ID)
 ENDDATETIME datetime (Computed) dbo.UFN_RESERVATION_ENDDATETIME(ID)

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   SALESORDER.ID Primary Key.
 ARRIVALAREACODEID uniqueidentifier ARRIVALAREACODE.ID The location where the buses will arrive.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 SECURITYDEPOSITWITHHOLDREASONCODEID uniqueidentifier RESERVATIONSECURITYDEPOSITWITHHOLDREASONCODE.ID The reason why withhold or partially refund the security deposit.

Index Name Field(s) Unique Primary Clustered
 IX_RESERVATION_DATEADDED DATEADDED    
 IX_RESERVATION_DATECHANGED DATECHANGED      
 PK_RESERVATION ID  

Trigger Name Description
 TR_RESERVATION_AUDIT_UPDATE
 TR_RESERVATION_AUDIT_DELETE

Referenced by Field
 ITINERARY RESERVATIONID
 RESERVATIONATTACHMENT RESERVATIONID
 RESERVATIONMEDIALINK RESERVATIONID
 RESERVATIONNOTE RESERVATIONID
 RESERVATIONRATESCALE ID
 RESERVATIONSECURITYDEPOSITPAYMENT RESERVATIONID
 RESERVATIONSTATUSHISTORY RESERVATIONID

Entity-Relationship diagram of this table