Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 CONTRACTREQUIRED bit   Default = 0 Indicates whether a contract is required by default on a reservation
 CONTRACTTIMEVALUE smallint   Default = ((0)) The amount of time before the contract is required.
 CONTRACTTIMECODE tinyint   Default = 0 The reference for time the value in CONTRACTTIMEVALUE represents.
 FINALCOUNTREQUIRED bit   Default = 0 Indicates whether a final count of visitors is required by default on a reservation
 FINALCOUNTTIMEVALUE smallint   Default = ((0)) The amount of time before the final count is required.
 FINALCOUNTTIMECODE tinyint   Default = 0 The reference for time the value in FINALCOUNTTIMEVALUE represents.
 DEPOSITREQUIRED bit   Default = 0 Indicates whether a deposit is required by default on a reservation.
 DEPOSITTIMEVALUE smallint   Default = ((0)) The amount of time before a deposit is due.
 DEPOSITTIMECODE tinyint   Default = 0 The reference for time the value in DEPOSITTIMEVALUE represents
 DEPOSITTYPECODE tinyint   Default = 0 The type of amount for the default deposit: 0 - Amount, 1 - Percent.
 DEPOSITAMOUNT money   Default = 0 The amount of the deposit
 DEPOSITPERCENT decimal(5, 2)   Default = 0 The percent value of the deposit.
 FINALTIMEVALUE smallint   Default = ((0)) The amount of time before the final payment is due.
 FINALTIMECODE tinyint   Default = 0 The reference for time the value in FINALTIMEVALUE represents
 MAXIMUMCAPACITY int   Default = 0 Maximum capacity allowed for group sales.
 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.
 USEFLATRATEPRICING bit   Default = 0 Indicates whether a reservation defaults to flat rate pricing.
 CONTRACTTIME nvarchar(25) (Computed) CASE [CONTRACTTIMECODE] WHEN 0 THEN N'Days before visit' WHEN 1 THEN N'Days after order creation' END Provides a translation for the 'CONTRACTTIMECODE' field.
 FINALCOUNTTIME nvarchar(25) (Computed) CASE [FINALCOUNTTIMECODE] WHEN 0 THEN N'Days before visit' WHEN 1 THEN N'Days after order creation' END Provides a translation for the 'FINALCOUNTTIMECODE' field.
 DEPOSITTIME nvarchar(25) (Computed) CASE [DEPOSITTIMECODE] WHEN 0 THEN N'Days before visit' WHEN 1 THEN N'Days after order creation' END Provides a translation for the 'DEPOSITTIMECODE' field.
 DEPOSITTYPE nvarchar(7) (Computed) CASE [DEPOSITTYPECODE] WHEN 0 THEN N'Amount' WHEN 1 THEN N'Percent' END Provides a translation for the 'DEPOSITTYPECODE' field.
 FINALTIME nvarchar(25) (Computed) CASE [FINALTIMECODE] WHEN 0 THEN N'Days before visit' WHEN 1 THEN N'Days after order creation' WHEN 2 THEN N'Days after deposit is due' END Provides a translation for the 'FINALTIMECODE' field.
 ITEMARRIVALTIME UDT_HOURMINUTE   Default = '' The default daily admission arrival (start) time for use when creating a quick itinerary.
 ITEMDEPARTURETIME UDT_HOURMINUTE   Default = '' The default daily admission departure (end) time for use when creating a quick itinerary.
 SECURITYDEPOSITREQUIRED bit   Default = 0 Indicates whether a security deposit is required by default on a reservation.
 SECURITYDEPOSITTIMEVALUE smallint   Default = ((0)) The amount of time before a security deposit is due.
 SECURITYDEPOSITTIMECODE tinyint   Default = 0 The reference for time the value in SECURITYDEPOSITTIMEVALUE represents
 SECURITYDEPOSITTIME nvarchar(25) (Computed) CASE [SECURITYDEPOSITTIMECODE] WHEN 0 THEN N'Days before visit' WHEN 1 THEN N'Days after order creation' END Provides a translation for the 'SECURITYDEPOSITTIMECODE' field.
 SECURITYDEPOSITTYPECODE tinyint   Default = 0 The type of amount for the default security deposit: 0 - Amount, 1 - Percent.
 SECURITYDEPOSITTYPE nvarchar(7) (Computed) CASE [SECURITYDEPOSITTYPECODE] WHEN 0 THEN N'Amount' WHEN 1 THEN N'Percent' END Provides a translation for the 'SECURITYDEPOSITTYPECODE' field.
 SECURITYDEPOSITAMOUNT money   Default = 0 The amount of the security deposit
 SECURITYDEPOSITPERCENT decimal(5, 2)   Default = 0 The percent value of the security deposit.

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CONTRACTLETTERTEMPLATEID uniqueidentifier LETTERTEMPLATE.ID The default letter template to be used for group sales contracts.
 CONTRACTRESERVATIONATTACHMENTTYPECODEID uniqueidentifier RESERVATIONATTACHMENTTYPECODE.ID The default attachment type to be used for group sales contract attachments.

Index Name Field(s) Unique Primary Clustered
 IX_GROUPSALESDEFAULT_DATEADDED DATEADDED    
 IX_GROUPSALESDEFAULT_DATECHANGED DATECHANGED      
 PK_GROUPSALESDEFAULT ID  

Trigger Name Description
 TR_GROUPSALESDEFAULT_AUDIT_UPDATE
 TR_GROUPSALESDEFAULT_AUDIT_DELETE

Entity-Relationship diagram of this table