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.
 POSTINGOPTIONCODE tinyint   Default = 0 Code to indicate the posting option selected by the user for the non-deposit revenue section.
 MARKASPOSTED bit   Default = 0 Determines whether to mark the revenue records as posted.
 CREATEOUTPUTIDSET bit   Default = 0 Designates whether or not an ID set should be created as a result of the post process.
 OUTPUTIDSETNAME nvarchar(100)   Default = '' The name of the outpue ID set to be created by the receipting process.
 OVERWRITEOUTPUTIDSET bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.
 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.
 DEPOSITPOSTINGOPTIONCODE tinyint   Default = 0 Code to indicate the posting option selected by the user for the deposit section.
 ADJUSTMENTPOSTINGOPTIONCODE tinyint   Default = 0 Code to indicate the posting option selected by the user for the bank account adjustment section.
 ISACTIVE bit   Default = 1 Indicates that this process is active.
 ADJUSTMENTPOSTINGOPTION nvarchar(41) (Computed) CASE [ADJUSTMENTPOSTINGOPTIONCODE] WHEN 0 THEN N'All ''Not posted'' bank account adjustments' WHEN 1 THEN N'Selected bank account adjustment records' WHEN 2 THEN N'None' END
 POSTDATEUPTOCODE tinyint   Default = 0
 POSTDATEUPTO nvarchar(18) (Computed) CASE [POSTDATEUPTOCODE] WHEN 0 THEN N'Today' WHEN 1 THEN N'Yesterday' WHEN 2 THEN N'End of last week' WHEN 3 THEN N'End of this week' WHEN 4 THEN N'End of last period' WHEN 5 THEN N'End of this period' WHEN 6 THEN N'Specific date' END
 SPECIFICPOSTDATEUPTO date
 DEPOSITPOSTINGOPTION nvarchar(26) (Computed) CASE [DEPOSITPOSTINGOPTIONCODE] WHEN 0 THEN N'All ''Not posted'' deposits' WHEN 1 THEN N'Selected deposit records' WHEN 2 THEN N'None' WHEN 3 THEN N'Specific bank accounts' WHEN 4 THEN N'Specific deposit templates' END
 POSTINGOPTION nvarchar(50) (Computed) CASE [POSTINGOPTIONCODE] WHEN 0 THEN N'All ''Not posted'' revenue and adjustments/reversals' WHEN 1 THEN N'Selected revenue records' WHEN 2 THEN N'''Not posted'' adjustments and reversals only' WHEN 3 THEN N'None' WHEN 4 THEN N'Specific transaction types' END

Foreign Key Field Type Null Notes Description
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID A foreign key to the ID set used to filter the records included in the post process.
 BUSINESSPROCESSVIEWID uniqueidentifier   BUSINESSPROCESSVIEW.ID A foreign key to the view to use as output for the parameter set.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 DEPOSITIDSETREGISTERID uniqueidentifier IDSETREGISTER.ID A foreign key to the ID set used to filter the records included in the post process.
 ADJUSTMENTIDSETREGISTERID uniqueidentifier IDSETREGISTER.ID A foreign key to the ID set used to filter the records included in the post process.
 PDACCOUNTSYSTEMID uniqueidentifier PDACCOUNTSYSTEM.ID Foreign key to the account system.

Index Name Field(s) Unique Primary Clustered
 IX_POSTTOGLPROCESS_DATEADDED DATEADDED    
 IX_POSTTOGLPROCESS_DATECHANGED DATECHANGED      
 PK_POSTTOGLPROCESS ID  
 UC_POSTTOGLPROCESS_NAME NAME    

Trigger Name Description
 TR_POSTTOGLPROCESS_INSERT
 TR_POSTTOGLPROCESS_AUDIT_UPDATE
 TR_POSTTOGLPROCESS_AUDIT_DELETE

Referenced by Field
 POSTTOGLPROCESSBANKACCOUNTFILTER POSTTOGLPROCESSID
 POSTTOGLPROCESSDEPOSITTEMPLATESFILTER POSTTOGLPROCESSID
 POSTTOGLPROCESSDETAIL ID
 POSTTOGLPROCESSEXPORTFORMAT PARAMETERSETID
 POSTTOGLPROCESSSTATUS PARAMETERSETID
 POSTTOGLPROCESSTRANSACTIONTYPEFILTER POSTTOGLPROCESSID

Entity-Relationship diagram of this table