Schema
PayOSCommerce

OrderItem

Line item on any order. Links to MenuItem catalogue. Pennies.

10 fields3 relationships

Fields

NameTypeReqDescription
idstringyesUUID (Zion) or uid (Square — unique within order).
order_idstringyesParent order ref.
namestringyesItem name at order time.
quantitynumberyesQuantity ordered.
pricepenniesBase price per unit.
net_amountpenniesLine total post-tax/discount.
item_typeenumfood | drink | modifier | fee.
notestringGuest note (no ice etc.).
variation_namestringVariant (Large, Vegan).
payment_statusenumunpaid | paid | refunded.

Relationships

Outbound (1)
Inbound (2)