Column Name | Type | Properties | Docu |
auditid | seq64 | Primary-Key | additional primary key for auditing |
audittime | int64 | NULL-able | Time at which the change was made. |
audituname | string:64 | NULL-able | The user name of the user who made the change. |
audittransaction | string:64 | NULL-able | The transaction name under which the change was made. |
voucherid | string:32 | | a 8-32 char code (code39: case-insensitive letters+digits) for the voucher |
price | int32 | | price of the voucher (0 if cancelled) |
orderid | int32 | | order this voucher belongs to |
isused | bool | NULL-able default="false" | marker: voucher has been used to pay something |
value | int32 | | remaining value in cents (0 for cancelled) |
tags | string | NULL-able | additional tags for this voucher, can be used by scripts |
validtime | int64 | NULL-able | time till which the voucher is valid or NULL if it is valid indefinitely |
comment | string | NULL-able | |