Table item_audit

A sold item other than a ticket or voucher.

Column NameTypePropertiesDocu
auditidseq64Primary-Key additional primary key for auditing
audittimeint64NULL-able Time at which the change was made.
auditunamestring:64NULL-able The user name of the user who made the change.
audittransactionstring:64NULL-able The transaction name under which the change was made.
itemidint64
productidint32
orderidint32
amountint32
totalpriceint32
tagsstringNULL-able additional tags for this item, can be used by scripts