| 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. |
| CONTRACTTIME |
nvarchar(25) (Computed) |
yes |
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. |
| 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. |
| FINALCOUNTTIME |
nvarchar(25) (Computed) |
yes |
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. |
| 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 |
| DEPOSITTIME |
nvarchar(25) (Computed) |
yes |
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. |
| DEPOSITTYPECODE |
tinyint |
|
Default = 0 |
The type of amount for the default deposit: 0 - Amount, 1 - Percent. |
| DEPOSITTYPE |
nvarchar(7) (Computed) |
yes |
CASE [DEPOSITTYPECODE] WHEN 0 THEN N'Amount' WHEN 1 THEN N'Percent' END |
Provides a translation for the 'DEPOSITTYPECODE' field. |
| 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 |
| FINALTIME |
nvarchar(25) (Computed) |
yes |
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. |
| 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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| USEFLATRATEPRICING |
bit |
|
Default = 0 |
Indicates whether a reservation defaults to flat rate pricing. |
| 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) |
yes |
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) |
yes |
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. |