Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 TRANSACTIONID uniqueidentifier ID for the transaction that generated the error
 TRANSACTIONTYPECODE tinyint   Default = 1 Type of transaction
 ERRORMESSAGE nvarchar(4000)   Default = '' Error message returned from account mapping function
 MAPPEDVALUES xml UDT_MAPPEDVALUESFORGETACCOUNTS_2 values that were used to determine the mapping
 DELETED bit   Default = 0 Row deletion indicator
 ADDRESSED bit   Default = 0 Indicator for marking the row addressed
 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.
 TRANSACTIONTYPE nvarchar(31) (Computed) CASE [TRANSACTIONTYPECODE] WHEN 0 THEN N'Payment' WHEN 1 THEN N'Pledge' WHEN 2 THEN N'Recurring gift' WHEN 3 THEN N'Matching gift claim' WHEN 4 THEN N'Planned gift' WHEN 5 THEN N'Order' WHEN 6 THEN N'Grant award' WHEN 7 THEN N'Auction donation' WHEN 8 THEN N'Donor challenge claim' WHEN 9 THEN N'Pending gift' WHEN 100 THEN N'Bank account adjustment' WHEN 101 THEN N'Bank account deposit correction' WHEN 102 THEN N'Bank account deposit' WHEN 103 THEN N'Refund' END

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 GLACCOUNTMAPPINGERRORUPDATEPROCESSID uniqueidentifier GLACCOUNTMAPPINGERRORUPDATEPROCESS.ID

Index Name Field(s) Unique Primary Clustered
 IX_GLACCOUNTMAPPINGERROR_DATEADDED DATEADDED    
 IX_GLACCOUNTMAPPINGERROR_DATECHANGED DATECHANGED      
 PK_GLACCOUNTMAPPINGERROR ID  

Trigger Name Description
 TR_GLACCOUNTMAPPINGERROR_AUDIT_UPDATE
 TR_GLACCOUNTMAPPINGERROR_AUDIT_DELETE

Entity-Relationship diagram of this table