Payments
Fields
| Field alias | Description | Data type | Editable |
|---|---|---|---|
| amount | amount | currency | yes |
| canWrite | write permission | boolean | |
| conversionRate | number | number | |
| created | date created | datetime | |
| currencyId | currency id | number | yes |
| id | id | number | |
| orderReference | order reference | string | yes |
| paymentMethod | payment method | string | yes |
| transactionId | transaction id | string | yes |
Common expressions
| Expression | Description | Data type |
|---|---|---|
| trim(payment.orderReference + if(isEmpty(payment.paymentMethod), "", " - " + payment.paymentMethod) + if(isEmpty(payment.transactionId), "", " - " + payment.transactionId)) | name | string |
Relations
| Relationship | Relationshiop description |
|---|---|
| Has one currency | Used currency |
| Has many and belongs to invoices | Invoices |
| Has many orders | Orders |