Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the parameter set.
 DESCRIPTION nvarchar(255)   Default = '' The description of the parameter set.
 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.
 ISRECONCILEDPROCESS bit   Default = 0 Indicates whether this is the reconciled payments process.
 GROUPBYDATE bit   Default = 0 Indicates whether this process will have separate deposits by day when multiple days are being processed.
 DEPOSITDATEOPTIONCODE tinyint   Default = 0
 DEPOSITDATEOPTION nvarchar(12) (Computed) CASE [DEPOSITDATEOPTIONCODE] WHEN 0 THEN N'Sales date' WHEN 1 THEN N'Today' WHEN 2 THEN N'Yesterday' WHEN 3 THEN N'Specific day' END
 DEPOSITDATE date
 PAYMENTDATEOPTIONCODE tinyint   Default = 1
 PAYMENTDATEOPTION nvarchar(12) (Computed) CASE [PAYMENTDATEOPTIONCODE] WHEN 0 THEN N'Today' WHEN 1 THEN N'Yesterday' WHEN 2 THEN N'Specific day' END
 PAYMENTDATE date

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

Index Name Field(s) Unique Primary Clustered
 IX_SALESDEPOSITPROCESS_DATEADDED DATEADDED    
 IX_SALESDEPOSITPROCESS_DATECHANGED DATECHANGED      
 PK_SALESDEPOSITPROCESS ID  
 UC_SALESDEPOSITPROCESS_NAME NAME    

Trigger Name Description
 TR_SALESDEPOSITPROCESS_AUDIT_UPDATE
 TR_SALESDEPOSITPROCESS_AUDIT_DELETE

Referenced by Field
 SALESDEPOSITPROCESSEXPORTFORMAT PARAMETERSETID
 SALESDEPOSITPROCESSSTATUS PARAMETERSETID
 SALESDEPOSITTEMPLATE SALESDEPOSITPROCESSID

Entity-Relationship diagram of this table