FINANCIALSYSTEMTRANSACTIONTYPE
Ties financial systems with their transaction types
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| TYPECODE |
tinyint |
|
Default = 101 |
Transaction type |
| 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. |
| TYPE |
nvarchar(21) (Computed) |
yes |
CASE [TYPECODE] WHEN 101 THEN N'Invoice' WHEN 102 THEN N'Credit memo' WHEN 255 THEN N'System Transaction' WHEN 103 THEN N'Journal entry batch' WHEN 254 THEN N'Reversal' WHEN 104 THEN N'Charge' WHEN 105 THEN N'AP Payment' WHEN 106 THEN N'Credit' 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' END |
|
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| FINANCIALSYSTEMID |
uniqueidentifier |
yes |
FINANCIALSYSTEM.ID
|
Financial System |
| ADDEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| CHANGEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_FINANCIALSYSTEMTRANSACTIONTYPE_DATEADDED |
DATEADDED |
|
|
yes |
| IX_FINANCIALSYSTEMTRANSACTIONTYPE_DATECHANGED |
DATECHANGED |
|
|
|
| PK_FINANCIALSYSTEMTRANSACTIONTYPE |
ID |
yes |
yes |
|
Triggers
Referenced by