A sold item other than a ticket or voucher.
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. |
itemid | int64 | ||
productid | int32 | ||
orderid | int32 | ||
amount | int32 | ||
totalprice | int32 | ||
tags | string | NULL-able | additional tags for this item, can be used by scripts |