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.
 POSTINGOPTION nvarchar(54) (Computed) CASE [POSTINGOPTIONCODE] WHEN 0 THEN N'All ''Not yet posted'' revenue and adjustments/reversals' WHEN 1 THEN N'Selected revenue records' WHEN 2 THEN N'''Not yet posted'' adjustments and reversals only' WHEN 3 THEN N'None' END Provides a translation for the 'POSTINGOPTIONCODE' field.
 DEPOSITPOSTINGOPTIONCODE tinyint   Default = 0 Code to indicate the posting option selected by the user for the deposit section.
 DEPOSITPOSTINGOPTION nvarchar(29) (Computed) CASE [DEPOSITPOSTINGOPTIONCODE] WHEN 0 THEN N'All ''Not yet posted'' deposits' WHEN 1 THEN N'Selected deposit records' WHEN 2 THEN N'None' END Provides a translation for the 'DEPOSITPOSTINGOPTIONCODE' field.
 ADJUSTMENTPOSTINGOPTIONCODE tinyint   Default = 0 Code to indicate the posting option selected by the user for the bank account adjustment section.
 ADJUSTMENTPOSTINGOPTION nvarchar(45) (Computed) CASE [ADJUSTMENTPOSTINGOPTIONCODE] WHEN 0 THEN N'All ''Not yet posted'' bank account adjustments' WHEN 1 THEN N'Selected bank account adjustment records' WHEN 2 THEN N'None' END Provides a translation for the 'ADJUSTMENTPOSTINGOPTIONCODE' field.
 ISACTIVE bit   Default = 1 Indicates that this process is active.

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_AUDIT_UPDATE
 TR_POSTTOGLPROCESS_AUDIT_DELETE
 TR_POSTTOGLPROCESS_INSERT

Referenced by Field
 POSTTOGLPROCESSDETAIL ID
 POSTTOGLPROCESSEXPORTFORMAT PARAMETERSETID
 POSTTOGLPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table