This table contains all orders and sales.
| 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. |
| orderid | int32 | ||
| customerid | int32 | NULL-able | ID of the customer connected to this order. |
| soldby | string:64 | NULL-able | User name of the user who entered it into the system. "_web" for the online system. |
| invoiceaddress | int64 | NULL-able | If not null: the address the invoice goes to. |
| deliveryaddress | int64 | NULL-able | If not null: the address the delivery goes to. If null: assumed to be identical to invoiceaddress. |
| status | enum32 | Status the order is in right now. | |
| ordertime | int64 | When the order was created | |
| senttime | int64 | NULL-able | When the order was sent to the customer |
| comments | text | NULL-able | comments made on web form (eg. "urgently needed for dads birthday") |
| amountpaid | int32 | NULL-able | how much has been paid already (including used vouchers); this is for comparison with the price fields in ticket and voucher tables |
| shippingcosts | int32 | NULL-able default="0" | shipping price; this is not re-imbursed for orders that have been sent and then cancelled |
| shippingtype | int32 | NULL-able | pointer to shipping type (none per default, programmatic default is in config) |
| tags | string | NULL-able | additional tags for this order, can be used by scripts |
| couponid | string:32 | NULL-able | Optional coupon code used on this order. |
| paytype | string:64 | NULL-able Foreign-Key=paymenttype(paytype) | |
| paydata | string | NULL-able |