| PKID | bigint | plain | | | Price ID |
| creator | integer | plain | | users.ID | Creator user ID (defaults to authenticated user on creation) |
| creationdate | bigint | plain | | | Default: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation) |
| lastmodified | bigint | plain | | | Default: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification) |
| item | integer | plain | | items.ID | Item ID (**dependency**) |
| pricelist | integer | plain | | pricelists.ID | Price list ID (**dependency**) |
| price | double precision | plain | | | Price per unit (`null`=`item.sellingprice` for billing or `null`=`item.purchaseprice` for procurement) |
| rebate | double precision | plain | | | Default: 0Absolute rebate per unit (applied before `discount`) |
| discount | double precision | plain | | | Relative discount in percent (applied after `rebate`; `null`=`pricelist.discount`) |
| minamount | double precision | plain | | | Default: 0Minimum amount (quantity) |
| costprice | double precision | plain | | | Cost price per unit (`null`=`item.purchaseprice` for billing) |