V_QUERY_GROUPSALESDEFAULT
Provides the ability to query group sales default information.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| DEPOSITREQUIRED | bit | Deposit required | |
| DEPOSITTIMEVALUE | smallint | Deposit time value | |
| DEPOSITTIME | nvarchar(25) | yes | Deposit time |
| DEPOSITTYPE | nvarchar(7) | yes | Deposit type |
| DEPOSITAMOUNT | money | Deposit amount | |
| DEPOSITPERCENT | decimal(5, 2) | Deposit percent | |
| CONTRACTREQUIRED | bit | Contract required | |
| CONTRACTTIMEVALUE | smallint | Contract time value | |
| CONTRACTTIME | nvarchar(25) | yes | Contract time |
| CONTRACTRESERVATIONATTACHMENTTYPECODEID_TRANSLATION | nvarchar(100) | yes | Contract attachment type |
| CONTRACTLETTERTEMPLATEID | uniqueidentifier | yes | Contract letter template record ID |
| CONTRACTLETTERTEMPLATENAME | nvarchar(100) | yes | Contract letter template name |
| CONTRACTLETTERTEMPLATETYPE | nvarchar(28) | yes | Contract letter template type |
| CONTRACTLETTERTEMPLATEFILENAME | nvarchar(255) | yes | Contract letter template file name |
| FINALCOUNTREQUIRED | bit | Final count required | |
| FINALCOUNTTIMEVALUE | smallint | Final count time value | |
| FINALCOUNTTIME | nvarchar(25) | yes | Final count time |
| FINALTIMEVALUE | smallint | Order balance time value | |
| FINALTIME | nvarchar(25) | yes | Order balance time |
| MAXIMUMCAPACITY | int | Maximum capacity | |
| USEFLATRATEPRICING | bit | Use flat rate pricing | |
| 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 |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:35:47 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_GROUPSALESDEFAULT AS
select
GROUPSALESDEFAULT.ID,
GROUPSALESDEFAULT.DEPOSITREQUIRED,
GROUPSALESDEFAULT.DEPOSITTIMEVALUE,
GROUPSALESDEFAULT.DEPOSITTIME,
GROUPSALESDEFAULT.DEPOSITTYPE,
GROUPSALESDEFAULT.DEPOSITAMOUNT,
GROUPSALESDEFAULT.DEPOSITPERCENT,
GROUPSALESDEFAULT.CONTRACTREQUIRED,
GROUPSALESDEFAULT.CONTRACTTIMEVALUE,
GROUPSALESDEFAULT.CONTRACTTIME,
RESERVATIONATTACHMENTTYPECODE.DESCRIPTION as [CONTRACTRESERVATIONATTACHMENTTYPECODEID_TRANSLATION],
GROUPSALESDEFAULT.CONTRACTLETTERTEMPLATEID,
LETTERTEMPLATE.NAME as [CONTRACTLETTERTEMPLATENAME],
LETTERTEMPLATE.LETTERTEMPLATETYPE as [CONTRACTLETTERTEMPLATETYPE],
LETTERTEMPLATE.LETTERFILENAME as [CONTRACTLETTERTEMPLATEFILENAME],
GROUPSALESDEFAULT.FINALCOUNTREQUIRED,
GROUPSALESDEFAULT.FINALCOUNTTIMEVALUE,
GROUPSALESDEFAULT.FINALCOUNTTIME,
GROUPSALESDEFAULT.FINALTIMEVALUE,
GROUPSALESDEFAULT.FINALTIME,
GROUPSALESDEFAULT.MAXIMUMCAPACITY,
GROUPSALESDEFAULT.USEFLATRATEPRICING,
isnull([ADDEDBY].APPLICATIONNAME, '') as [ADDEDBY_APPLICATION],
isnull([ADDEDBY].USERNAME, '') as [ADDEDBY_USERNAME],
isnull([CHANGEDBY].APPLICATIONNAME, '') as [CHANGEDBY_APPLICATION],
isnull([CHANGEDBY].USERNAME, '') as [CHANGEDBY_USERNAME],
GROUPSALESDEFAULT.DATEADDED,
GROUPSALESDEFAULT.DATECHANGED,
GROUPSALESDEFAULT.TSLONG
/*#EXTENSION*/
from
dbo.GROUPSALESDEFAULT
left outer join
dbo.RESERVATIONATTACHMENTTYPECODE on GROUPSALESDEFAULT.CONTRACTRESERVATIONATTACHMENTTYPECODEID = RESERVATIONATTACHMENTTYPECODE.ID
left outer join
dbo.LETTERTEMPLATE on GROUPSALESDEFAULT.CONTRACTLETTERTEMPLATEID = LETTERTEMPLATE.ID
left outer join
dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = GROUPSALESDEFAULT.ADDEDBYID
left outer join
dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = GROUPSALESDEFAULT.CHANGEDBYID