GLACCOUNTMAPPINGERROR
Log file for errors generated for default account mapping
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| TRANSACTIONID |
uniqueidentifier |
yes |
|
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 |
yes |
|
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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| TRANSACTIONTYPE |
nvarchar(31) (Computed) |
yes |
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 15 THEN N'Membership installment plan' 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 Keys
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_GLACCOUNTMAPPINGERROR_DATEADDED |
DATEADDED |
|
|
yes |
| IX_GLACCOUNTMAPPINGERROR_DATECHANGED |
DATECHANGED |
|
|
|
| PK_GLACCOUNTMAPPINGERROR |
ID |
yes |
yes |
|
Triggers