| PKID | integer | plain | | | Payment ID |
| fork | integer | plain | | forks.ID | Fork ID (`null` for base module) |
| ownergroup | integer | plain | | groups.ID | Owner group ID (`null`=PUBLIC) |
| creator | integer | plain | | users.ID | Creator user ID (defaults to authenticated user on creation) |
| assigneduser | integer | plain | | users.ID | Assigned user ID |
| creationdate | bigint | plain | | | Default: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation) |
| lastmodified | bigint | plain | | | Default: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification) |
| ledger | integer | plain | | ledgers.ID | Ledger ID |
| transaction | integer | plain | | transactions.ID | Transaction ID; is mutually exclusive to `account` |
| account | integer | plain | | accounts.ID | Account ID; is mutually exclusive to `transaction` |
| date | bigint | plain | | | Default: date_part('epoch', now())Designated date and time as a Unix timestamp (defaults to current date and time on creation) |
| subject | text | main | | | Default: ''Subject (e.g. bank statement or reference number) |
| status | smallint | plain | | | Default: 0Status (`0`=DRAFT, `1`=COMPLETED, `2`=CANCELLED, `3`=BOOKED) |
| amount | double precision | plain | | | Amount (monetary) |
| autoadvance | smallint | plain | | | Default: 0Auto-advance to next transaction |
| description | text | extended | | | Default: ''Detailed general description |