This table contains group sales setup defaults.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
CONTRACTREQUIRED
|
bit
|
false
|
|
Indicates whether a contract is required by default on a reservation
|
|
CONTRACTTIMEVALUE
|
smallint
|
false
|
|
The amount of time before the contract is required.
|
|
CONTRACTTIMECODE
|
tinyint
|
false
|
|
The reference for time the value in CONTRACTTIMEVALUE represents.
|
|
CONTRACTTIME
|
nvarchar(25) (Computed)
|
true
|
|
Provides a translation for the 'CONTRACTTIMECODE' field.
|
|
FINALCOUNTREQUIRED
|
bit
|
false
|
|
Indicates whether a final count of visitors is required by default on a reservation
|
|
FINALCOUNTTIMEVALUE
|
smallint
|
false
|
|
The amount of time before the final count is required.
|
|
FINALCOUNTTIMECODE
|
tinyint
|
false
|
|
The reference for time the value in FINALCOUNTTIMEVALUE represents.
|
|
FINALCOUNTTIME
|
nvarchar(25) (Computed)
|
true
|
|
Provides a translation for the 'FINALCOUNTTIMECODE' field.
|
|
DEPOSITREQUIRED
|
bit
|
false
|
|
Indicates whether a deposit is required by default on a reservation.
|
|
DEPOSITTIMEVALUE
|
smallint
|
false
|
|
The amount of time before a deposit is due.
|
|
DEPOSITTIMECODE
|
tinyint
|
false
|
|
The reference for time the value in DEPOSITTIMEVALUE represents
|
|
DEPOSITTIME
|
nvarchar(25) (Computed)
|
true
|
|
Provides a translation for the 'DEPOSITTIMECODE' field.
|
|
DEPOSITTYPECODE
|
tinyint
|
false
|
|
The type of amount for the default deposit: 0 - Amount, 1 - Percent.
|
|
DEPOSITTYPE
|
nvarchar(7) (Computed)
|
true
|
|
Provides a translation for the 'DEPOSITTYPECODE' field.
|
|
DEPOSITAMOUNT
|
money
|
false
|
|
The amount of the deposit
|
|
DEPOSITPERCENT
|
decimal(5, 2)
|
false
|
|
The percent value of the deposit.
|
|
FINALTIMEVALUE
|
smallint
|
false
|
|
The amount of time before the final payment is due.
|
|
FINALTIMECODE
|
tinyint
|
false
|
|
The reference for time the value in FINALTIMEVALUE represents
|
|
FINALTIME
|
nvarchar(25) (Computed)
|
true
|
|
Provides a translation for the 'FINALTIMECODE' field.
|
|
MAXIMUMCAPACITY
|
int
|
false
|
|
Maximum capacity allowed for group sales.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
USEFLATRATEPRICING
|
bit
|
false
|
|
Indicates whether a reservation defaults to flat rate pricing.
|
|
ITEMARRIVALTIME
|
UDT_HOURMINUTE
|
false
|
|
The default daily admission arrival (start) time for use when creating a quick itinerary.
|
|
ITEMDEPARTURETIME
|
UDT_HOURMINUTE
|
false
|
|
The default daily admission departure (end) time for use when creating a quick itinerary.
|
|
SECURITYDEPOSITREQUIRED
|
bit
|
false
|
|
Indicates whether a security deposit is required by default on a reservation.
|
|
SECURITYDEPOSITTIMEVALUE
|
smallint
|
false
|
|
The amount of time before a security deposit is due.
|
|
SECURITYDEPOSITTIMECODE
|
tinyint
|
false
|
|
The reference for time the value in SECURITYDEPOSITTIMEVALUE represents
|
|
SECURITYDEPOSITTIME
|
nvarchar(25) (Computed)
|
true
|
|
Provides a translation for the 'SECURITYDEPOSITTIMECODE' field.
|
|
SECURITYDEPOSITTYPECODE
|
tinyint
|
false
|
|
The type of amount for the default security deposit: 0 - Amount, 1 - Percent.
|
|
SECURITYDEPOSITTYPE
|
nvarchar(7) (Computed)
|
true
|
|
Provides a translation for the 'SECURITYDEPOSITTYPECODE' field.
|
|
SECURITYDEPOSITAMOUNT
|
money
|
false
|
|
The amount of the security deposit
|
|
SECURITYDEPOSITPERCENT
|
decimal(5, 2)
|
false
|
|
The percent value of the security deposit.
|
