Table : transactions

Raw table description

Fields

id id

{
  "name": "id",
  "type": "primaryKey"
}

transactionGroupId M  → transactionGroups

{
  "name": "transactionGroupId",
  "type": "foreignKey",
  "table": "transactionGroups",
  "mandatory": "true"
}

bankAccountId  → bankAccounts

{
  "name": "bankAccountId",
  "type": "foreignKey",
  "table": "bankAccounts"
}

transactionDate

{
  "name": "transactionDate",
  "type": "date"
}

amount $$

{
  "name": "amount",
  "type": "money"
}

comment   (Private comment will not be printed)

{
  "name": "comment",
  "type": "text",
  "note": "Private comment will not be printed"
}

description   (Public, will be printed)

{
  "name": "description",
  "type": "text",
  "note": "Public, will be printed"
}

updatedDate

{
  "name": "updatedDate",
  "type": "updated"
}