All registered payments with their important information. Please note the corrections of existing payments are represented chronologycally as separate payments.
Fields
| Field name | Type | Description/Notes |
| id | INTEGER | Unique identifier of the payment across the entire Clock PMS+ ecosystem* |
| account_id | INTEGER | Identification of the account owning the . Reference to accounts table* |
| folio_id | INTEGER | Containing folio id. Reference to folios table* |
| text | STRING | Payment description (Text) provided by the payment provider or filled by the user |
| revenue_date | DATE | The affected by the charge revenue date* |
| created_at | TIMESTAMP | Time created (Date and time in UTC)* |
| updated_at | TIMESTAMP | Time lastly updated (Date and time in UTC)* |
| number | STRING | Number out of configured number sequence. For cash payments only. |
| gl_code | STRING | GL payment code if configured. |
| reference | STRING | Reference number provided by the payment provider |
| currency | STRING | Currency of the payment ISO 4217 currency codes* |
| value_cents | INTEGER | Payment value in cents (10EUR = 1000 cents)* |
| balance_value_cents | INTEGER | Payment value recalculated in the folio currency* |
| balance_currency | STRING | Currency of the folio ISO 4217 currency codes* |
| user_created | STRING | Name of the Clock PMS+ user created the payment* |
| user_updated | STRING | Name of the Clock PMS+ user updated the payment* |
| voided_at | TIMESTAMP | Time voided (Date and time in UTC) |
| void_reason | STRING | Reason for the void added by the operator |
| payment_type | STRING | Payment type.* Payment types are fixed: cash, card, bank, debit, on-line, check, vaucher, other, transfer, cross_account_transfer |
| payment_sub_type | STRING | Name of the payment sub-type (optional, user configurable). The payment sub-type is a segmentation of the payment type |
| custom_field_xyz** | STRING |
* Field will have value for every record
** All fields after source_type field depend on the Clock PMS+ account configuration and would differ for he different customers!