V_QUERY_RESERVATION
Provides the ability to query reservation information.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(100) | Name | |
| ARRIVALDATE | date | Arrival date | |
| ARRIVALTIME | UDT_HOURMINUTE | Arrival time | |
| STARTDATETIME | datetime | yes | Start date and time |
| ENDDATETIME | datetime | yes | End date and time |
| NUMBEROFBUSES | smallint | Number of buses | |
| ARRIVALAREACODEID_TRANSLATION | nvarchar(100) | yes | Arrival area |
| ARRIVALNOTES | nvarchar(255) | Arrival notes | |
| DRIVERNAME | nvarchar(100) | Driver name | |
| DRIVERPHONENUMBER | nvarchar(100) | Driver phone number | |
| PRICING | nvarchar(10) | yes | Pricing structure |
| DEPOSITREQUIRED | bit | Deposit required | |
| DEPOSITAMOUNT | money | Deposit amount | |
| DEPOSITDUEDATE | date | yes | Deposit due date |
| CONTRACTREQUIRED | bit | Contract required | |
| CONTRACTDUEDATE | date | yes | Contract due date |
| CONTRACTSENT | bit | Contract sent | |
| CONTRACTRECEIVED | bit | Contract received | |
| FINALCOUNTREQUIRED | bit | Final count required | |
| FINALCOUNTDUEDATE | date | yes | Final count due date |
| FINALCOUNTRECEIVED | bit | Final count received | |
| FINALDUEDATE | date | Order balance due | |
| SALESORDERRECIPIENTID | uniqueidentifier | yes | SALESORDERRECIPIENTID |
| SALESORDERADDRESSID | uniqueidentifier | yes | SALESORDERADDRESSID |
| SALESORDERPHONEID | uniqueidentifier | yes | SALESORDERPHONEID |
| SALESORDEREMAILADDRESSID | uniqueidentifier | yes | SALESORDEREMAILADDRESSID |
| ADDEDBY_APPLICATION | nvarchar(200) | Added by application | |
| ADDEDBY_USERNAME | nvarchar(128) | Added by user name | |
| CHANGEDBY_APPLICATION | nvarchar(200) | Changed by application | |
| CHANGEDBY_USERNAME | nvarchar(128) | Changed by user name | |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| ORDERBALANCESENT | bit | Order balance sent | |
| SECURITYDEPOSITREQUIRED | bit | Security deposit required | |
| SECURITYDEPOSITAMOUNT | money | Security deposit amount | |
| SECURITYDEPOSITDUEDATE | date | yes | Security deposit due date |
| IMPORTANTNOTES | nvarchar(1000) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:17:11 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RESERVATION AS
select
RESERVATION.ID,
RESERVATION.NAME,
RESERVATION.ARRIVALDATE,
RESERVATION.ARRIVALTIME,
RESERVATION.STARTDATETIME,
RESERVATION.ENDDATETIME,
RESERVATION.NUMBEROFBUSES,
ARRIVALAREACODE.DESCRIPTION as [ARRIVALAREACODEID_TRANSLATION],
RESERVATION.ARRIVALNOTES,
RESERVATION.DRIVERNAME,
RESERVATION.DRIVERPHONENUMBER,
RESERVATION.PRICING,
RESERVATION.DEPOSITREQUIRED,
RESERVATION.DEPOSITAMOUNT,
RESERVATION.DEPOSITDUEDATE,
RESERVATION.CONTRACTREQUIRED,
RESERVATION.CONTRACTDUEDATE,
RESERVATION.CONTRACTSENT,
RESERVATION.CONTRACTRECEIVED,
RESERVATION.FINALCOUNTREQUIRED,
RESERVATION.FINALCOUNTDUEDATE,
RESERVATION.FINALCOUNTRECEIVED,
RESERVATION.FINALDUEDATE,
SALESORDER.RECIPIENTID as [SALESORDERRECIPIENTID],
CONTACTRECORDS.ADDRESSID as [SALESORDERADDRESSID],
CONTACTRECORDS.PHONEID as [SALESORDERPHONEID],
CONTACTRECORDS.EMAILADDRESSID as [SALESORDEREMAILADDRESSID],
isnull([ADDEDBY].APPLICATIONNAME, '') as [ADDEDBY_APPLICATION],
isnull([ADDEDBY].USERNAME, '') as [ADDEDBY_USERNAME],
isnull([CHANGEDBY].APPLICATIONNAME, '') as [CHANGEDBY_APPLICATION],
isnull([CHANGEDBY].USERNAME, '') as [CHANGEDBY_USERNAME],
RESERVATION.DATEADDED,
RESERVATION.DATECHANGED,
RESERVATION.TSLONG,
RESERVATION.ORDERBALANCESENT,
RESERVATION.SECURITYDEPOSITREQUIRED,
RESERVATION.SECURITYDEPOSITAMOUNT,
RESERVATION.SECURITYDEPOSITDUEDATE,
SALESORDER.COMMENTS as [IMPORTANTNOTES]
/*#EXTENSION*/
from
dbo.RESERVATION
left outer join
dbo.SALESORDER on RESERVATION.ID = SALESORDER.ID
left outer join
dbo.ARRIVALAREACODE on RESERVATION.ARRIVALAREACODEID = ARRIVALAREACODE.ID
left outer join
dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = RESERVATION.ADDEDBYID
left outer join
dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = RESERVATION.CHANGEDBYID
outer apply
dbo.UFN_SALESORDER_CONTACTRECORDS(RESERVATION.ID) as CONTACTRECORDS