Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 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) 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) 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) 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.
 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.

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_GROUPSALESPAYMENTDEFAULT_DATEADDED DATEADDED    
 IX_GROUPSALESPAYMENTDEFAULT_DATECHANGED DATECHANGED      
 PK_GROUPSALESPAYMENTDEFAULT ID  

Trigger Name Description
 TR_GROUPSALESPAYMENTDEFAULT_AUDIT_UPDATE
 TR_GROUPSALESPAYMENTDEFAULT_AUDIT_DELETE