Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 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
 ATTEMPTMAX int   Default = 0
 ATTEMPTCOUNT int   Default = 0
 AUTHORIZEDCOUNT int   Default = 0
 REJECTEDCOUNT int   Default = 0
 PROVISIONALCOUNT int   Default = 0
 PERMANENTCOUNT int   Default = 0
 RETRYBATCHNUMBER nvarchar(100)   Default = ''
 DATEADDED datetime   Default = getdate()
 DATECHANGED datetime   Default = getdate()
 TS timestamp  
 TSLONG bigint (Computed) CONVERT(bigint, TS)
 ORIGINALBATCHNUMBER nvarchar(100)   Default = ''
 EXPORTEDROWCOUNT int   Default = 0
 NEWBATCHCREATED bit   Default = 0
 BATCHSUPPORTSREJECTIONHANDLING bit   Default = 0
 PREVIOUSLYAUTHORIZEDCOUNT int   Default = 0

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   CREDITCARDPROCESSINGSTATUS.ID
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID

Index Name Field(s) Unique Primary Clustered
 IX_CREDITCARDPROCESSINGTRANSACTIONOUTCOME_DATEADDED DATEADDED    
 IX_CREDITCARDPROCESSINGTRANSACTIONOUTCOME_DATECHANGED DATECHANGED      
 PK_CREDITCARDPROCESSINGTRANSACTIONOUTCOME ID  

Trigger Name Description
 TR_CREDITCARDPROCESSINGTRANSACTIONOUTCOME_AUDIT_UPDATE
 TR_CREDITCARDPROCESSINGTRANSACTIONOUTCOME_AUDIT_DELETE

Entity-Relationship diagram of this table