Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of this process.
 DESCRIPTION nvarchar(255)   Default = '' The description of this process.
 MERCHANTACCOUNTID uniqueidentifier Indicates the merchant account to use for processing the credit card transactions.
 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.
 DUEDATETYPECODE tinyint   Default = 0 Designates whether to use the date this process runs or a number of days after this process runs or a specific date in the process as the cutoff date.
 DUEDATETYPE nvarchar(30) (Computed) CASE [DUEDATETYPECODE] WHEN 0 THEN N'Date this process runs' WHEN 1 THEN N'Specific date' WHEN 2 THEN N'X days after this process runs' END Provides a translation for the 'DUEDATETYPECODE' field.
 CUTOFFDATE datetime Specifies the cut-off date for transactions to be included in the process.
 DAYSAFTER int   Default = 1 Number of days after this process runs that will be used to calculate the cutoff date
 TRANSACTIONTYPECODE tinyint   Default = 0 Specifies the type of transactions to generate.
 TRANSACTIONTYPE nvarchar(32) (Computed) CASE [TRANSACTIONTYPECODE] WHEN 0 THEN N'Pledge & Recurring Gift Payments' WHEN 1 THEN N'Pledge Payments' WHEN 2 THEN N'Recurring Gift Payments' END Provides a translation for the 'TRANSACTIONTYPECODE' field.
 BATCHINSTANCESETFORRESUME bit   Default = 0 Indicates if the batch instance is only set to support resuming an interrupted batch.
 CONSOLIDATEPAYMENTS bit   Default = 0
 PERMANENTREJECTIONBEHAVIORTYPECODE tinyint   Default = 0
 PERMANENTREJECTIONBEHAVIORTYPE nvarchar(28) (Computed) CASE [PERMANENTREJECTIONBEHAVIORTYPECODE] WHEN 0 THEN N'No special action' WHEN 1 THEN N'Export and remove from batch' END
 PROVISIONALREJECTIONBEHAVIORTYPECODE tinyint   Default = 0
 PROVISIONALREJECTIONBEHAVIORTYPE nvarchar(28) (Computed) CASE [PROVISIONALREJECTIONBEHAVIORTYPECODE] WHEN 0 THEN N'No special action' WHEN 1 THEN N'Treat as permanent rejection' WHEN 2 THEN N'Create retry batch' END
 CREATEPERMANENTREJECTIONIDSET bit   Default = 0
 PERMANENTREJECTIONIDSETNAME nvarchar(100)   Default = ''
 OVERWRITEPERMANENTREJECTIONIDSET bit   Default = 0
 PROVISIONALREJECTIONMAXATTEMPTS tinyint   Default = 2
 VALIDATEPROJECTEDBATCHTOTALS bit   Default = 0

Foreign Key Field Type Null Notes Description
 BATCHID uniqueidentifier BATCH.ID Indicates the batch that contains the credit card transactions to process.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID Indicates the IDSETREGISTER to use filter records included in the process.
 BATCHTEMPLATEID uniqueidentifier BATCHTEMPLATE.ID Specifies the batch instance to be used to create the batch to hold the transactions.
 OWNERID uniqueidentifier APPUSER.ID The user who will be the owner of the batch once it is created by the process.
 PDACCOUNTSYSTEMID uniqueidentifier PDACCOUNTSYSTEM.ID Foreign key to the account system.
 PERMANENTREJECTIONEXPORTDEFINITIONID uniqueidentifier EXPORTDEFINITION.ID

Index Name Field(s) Unique Primary Clustered
 IX_CREDITCARDPROCESSING_DATEADDED DATEADDED    
 IX_CREDITCARDPROCESSING_DATECHANGED DATECHANGED      
 PK_CREDITCARDPROCESSING ID  
 UC_CREDITCARDPROCESSING_NAME NAME    

Trigger Name Description
 TR_CREDITCARDPROCESSING_AUDIT_UPDATE
 TR_CREDITCARDPROCESSING_AUDIT_DELETE

Referenced by Field
 CREDITCARDPROCESSINGEXPORTFORMAT PARAMETERSETID
 CREDITCARDPROCESSINGMERCHANTACCOUNT CREDITCARDPROCESSINGID
 CREDITCARDPROCESSINGSTATUS PARAMETERSETID

Entity-Relationship diagram of this table