| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 USERDEFINEDID |
nvarchar(60) | Default = '' | User defined identification number | |
| TYPECODE |
tinyint | Default = 101 | Transaction type | |
| AMOUNT |
money | Default = 0 | Amount of transaction | |
| DATE |
date | Date of transaction | ||
| 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. |
| DESCRIPTION |
nvarchar(100) | Default = '' | User defined description for a transaction. | |
| TYPE |
nvarchar(19) (Computed) | |
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'Payment' WHEN 106 THEN N'Credit' END | Provides a translation for the 'TYPECODE' field. |
| POSTDATE |
date | |
Post date of transaction | |
| POSTSTATUSCODE |
tinyint | Default = 1 | Post status | |
| POSTSTATUS |
nvarchar(11) (Computed) | |
CASE [POSTSTATUSCODE] WHEN 1 THEN N'Not posted' WHEN 2 THEN N'Posted' WHEN 3 THEN N'Do not post' END | Provides a translation for the 'POSTSTATUSCODE' field. |
| DELETEDON |
datetime | |
Date and time of when the transaction was deleted |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 CONSTITUENTID |
uniqueidentifier | |
CONSTITUENT.LOCALID | Foreign Key to the Constituent Table |
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| PARENTID |
uniqueidentifier | |
FINANCIALTRANSACTION.ID | Points to the parent transaction we are adjusting |
| TRANSACTIONCURRENCYID |
uniqueidentifier | CURRENCY.ID | FK to CURRENCY | |
| BASEEXCHANGERATEID |
uniqueidentifier | |
CURRENCYEXCHANGERATE.ID | FK to CURRENCYEXCHANGERATE |
| ORGEXCHANGERATEID |
uniqueidentifier | |
CURRENCYEXCHANGERATE.ID | FK to CURRENCYEXCHANGERATE |
| PDACCOUNTSYSTEMID |
uniqueidentifier | PDACCOUNTSYSTEM.ID | FK to PDACCOUNTSYSTEM |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_FINANCIALTRANSACTION_CONSTITUENTID |
CONSTITUENTID | |||
| IX_FINANCIALTRANSACTION_DATE |
DATE | |||
 IX_FINANCIALTRANSACTION_DATEADDED |
DATEADDED | |
||
| IX_FINANCIALTRANSACTION_DATECHANGED |
DATECHANGED | |||
| IX_FINANCIALTRANSACTION_USERDEFINEDID |
USERDEFINEDID | |||
| PK_FINANCIALTRANSACTION |
ID | |
|
|
| UIX_FINANCIALTRANSACTION_PARENTID |
PARENTID | |
| Trigger Name | Description |
|---|---|
 TR_FINANCIALTRANSACTION_AUDIT_UPDATE |
|
| TR_FINANCIALTRANSACTION_AUDIT_DELETE |
|
| TR_FINANCIALTRANSACTION_INSERT_UPDATE |
|
| TR_FINANCIALTRANSACTION_UPDATE |
|
| TR_FINANCIALTRANSACTION_DELETE |
| Referenced by | Field |
|---|---|
 CHARGE |
ID |
| CREDITMEMO |
ID |
| DISBURSEMENT |
ID |
| DISBURSEMENTHISTORY |
FINANCIALTRANSACTIONID |
| DISBURSEMENTHISTORY |
FUTUREFINANCIALTRANSACTIONID |
| DISBURSEMENTPROCESSDISBURSEMENT |
ID |
| FINANCIALTRANSACTION1099DISTRIBUTION |
FINANCIALTRANSACTIONID |
| FINANCIALTRANSACTIONAPPLICATION |
FINANCIALTRANSACTIONID |
| FINANCIALTRANSACTIONATTACHMENT |
FINANCIALTRANSACTIONID |
| FINANCIALTRANSACTIONLINEITEM |
FINANCIALTRANSACTIONID |
| FINANCIALTRANSACTIONMEDIALINK |
FINANCIALTRANSACTIONID |
| FINANCIALTRANSACTIONNOTE |
FINANCIALTRANSACTIONID |
| FINANCIALTRANSACTIONSCHEDULE |
FINANCIALTRANSACTIONID |
| INVOICE |
ID |
| JOURNALENTRY |
BATCHID |
| JOURNALENTRYBATCH |
ID |
| RECEIVABLECREDIT |
ID |
| RECEIVABLEPAYMENT |
ID |
Entity-Relationship diagram of this table (RECEIVABLECREDIT-RECEIVABLEPAYMENT)