payments
Payment records linked to ledgers and transactions.
| Name | Type | Nullable | Default Value | Notes |
|---|---|---|---|---|
PKID | integer | Payment ID | ||
fork forks.ID | integer | Fork ID (`null` for base module) | ||
ownergroup groups.ID | integer | Owner group ID (`null`=PUBLIC) | ||
creator | integer | Creator user ID (defaults to authenticated user on creation) | ||
assigneduser users.ID | integer | Assigned user ID | ||
creationdate | bigint | date_part('epoch', now()) | Creation date and time as a Unix timestamp (defaults to current date and time on creation) | |
lastmodified | bigint | date_part('epoch', now()) | Last modification date and time as a Unix timestamp (auto-reset on modification) | |
ledger ledgers.ID | integer | Ledger ID | ||
transaction transactions.ID | integer | Transaction ID; is mutually exclusive to `account` | ||
account accounts.ID | integer | Account ID; is mutually exclusive to `transaction` | ||
date | bigint | date_part('epoch', now()) | Designated date and time as a Unix timestamp (defaults to current date and time on creation) | |
subject | text | '' | Subject (e.g. bank statement or reference number) | |
status | smallint | 0 | Status (`0`=DRAFT, `1`=COMPLETED, `2`=CANCELLED, `3`=BOOKED) | |
amount | double precision | Amount (monetary) | ||
autoadvance | smallint | 0 | Auto-advance to next transaction | |
description | text | '' | Detailed general description |
| Name | Unique | Nulls Distinct | Primary | Partial | Method | Keys |
|---|---|---|---|---|---|---|
| fk_payments_account | btree | account | ||||
| fk_payments_assigneduser | gin | assigneduser | ||||
| fk_payments_fork | gin | fork | ||||
| fk_payments_ledger | gin | ledger | ||||
| fk_payments_ownergroup | gin | ownergroup | ||||
| fk_payments_transaction | btree | transaction | ||||
| i_payments_date | btree | date | ||||
| i_payments_nofork | gin | fork | ||||
| i_payments_noowner | gin | ownergroup | ||||
| pk_payments | btree | ID | ||||
| s_payments_subject | gin | subject |
| Name | Type |
|---|---|
| c_payments_association | check |
| dc_payments_description | check |
| dc_payments_status | check |
| dc_payments_subject | check |
| fk_payments_account | foreign_key |
| fk_payments_assigneduser | foreign_key |
| fk_payments_fork | foreign_key |
| fk_payments_ledger | foreign_key |
| fk_payments_ownergroup | foreign_key |
| fk_payments_transaction | foreign_key |
| pk_payments | primary_key |
| Name | Type | Events | Function | Definition |
|---|---|---|---|---|
| td_payments_transaction | after | delete | ftd_payments_transaction | |
| ti_payments_transaction | after | insert | fti_payments_transaction | |
| tu_payments_transaction | after | update | ftu_payments_transaction |
Loading...