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.
 CREATEOUTPUTIDSET bit   Default = 0 Designates whether or not an ID set should be created as a result of the receipting 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.
 MARKRECEIPTED bit   Default = 0 Indicates whether or not receipts for this process should be marked as receipted.
 RECEIPTDATETYPECODE tinyint   Default = 0 Designates whether to use today's date or a specific date in the receipting process as the receipt date.
 RECEIPTDATE datetime This date is used as the receipt date when marking records as receipted.
 LETTERFILENAME nvarchar(255)   Default = '' The original file name for the letter template.
 LETTERFILE varbinary The actual file to use for the letter template.
 LABELFILENAME nvarchar(255)   Default = '' The original file name for the label template.
 LABELFILE varbinary The actual file for the label template.
 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.
 CUSTOMPARAMETERDATAFORMITEM xml Custom parameters for the process.
 RECEIPTTYPECODE tinyint   Default = 0 The receipt type of payments to include in this process.
 RECEIPTDATETYPE nvarchar(13) (Computed) CASE [RECEIPTDATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N'Specific date' END Provides a translation for the 'RECEIPTDATETYPECODE' field.
 RECEIPTTYPE nvarchar(12) (Computed) CASE [RECEIPTTYPECODE] WHEN 0 THEN N'Per payment' WHEN 1 THEN N'Consolidated' END Provides a translation for the 'RECEIPTTYPECODE' field.
 RERECEIPTSAMENUMBER bit   Default = 1 Indicates whether or not receipts to reissue should be included.
 RERECEIPTNEWNUMBER bit   Default = 1 Indicates whether or not receipts to rereceipt should be included.
 DUPLICATENUMBERACTIONCODE tinyint   Default = 1 Indicates the action to take upon running into a duplicate receipt number.
 STARTINGNUMBERCREATESGAPACTIONCODE tinyint   Default = 0 Indicates the action to take if the entered starting number will cause gaps in receipt numbering.
 STARTINGNUMBERCREATESGAPACTION nvarchar(42) (Computed) CASE [STARTINGNUMBERCREATESGAPACTIONCODE] WHEN 0 THEN N'Use starting receipt number as entered' WHEN 1 THEN N'Use next available starting receipt number' END Provides a translation for the 'STARTINGNUMBERCREATESGAPACTIONCODE' field.
 DUPLICATENUMBERACTION nvarchar(27) (Computed) CASE [DUPLICATENUMBERACTIONCODE] WHEN 0 THEN N'Use next available number' WHEN 1 THEN N'Use duplicate number anyway' END Provides a translation for the 'DUPLICATENUMBERACTIONCODE' field.

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 receipting process.
 OUTPUTIDSETRECORDTYPEID uniqueidentifier RECORDTYPE.ID A foreign key to the record type of the output ID set to be created by the receipting 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.
 EXPORTDEFINITIONID uniqueidentifier EXPORTDEFINITION.ID FK to EXPORTDEFINITION
 RECEIPTSTACKINFOID uniqueidentifier RECEIPTSTACKINFO.ID A foreign key to the RECEIPTSTACKINFO table that corresponds to the receipt stack used for this receipt.

Index Name Field(s) Unique Primary Clustered
 IX_RECEIPTINGPROCESS_DATEADDED DATEADDED    
 IX_RECEIPTINGPROCESS_DATECHANGED DATECHANGED      
 PK_RECEIPTINGPROCESS ID  
 UC_RECEIPTINGPROCESS_NAME NAME    

Trigger Name Description
 TR_RECEIPTINGPROCESS_INSERT
 TR_RECEIPTINGPROCESS_DELETE_BUSINESSPROCESSINSTANCE
 TR_RECEIPTINGPROCESS_AUDIT_UPDATE
 TR_RECEIPTINGPROCESS_AUDIT_DELETE

Referenced by Field
 RECEIPTINGPROCESSEXPORTFORMAT PARAMETERSETID
 RECEIPTINGPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table