Schema
PayOSCommerce

SquareOrder

Live POS order via Square integration. Real-time table spend during service. All amounts in pennies.

5 fields5 relationships

Fields

NameTypeReqDescription
order_idstringyesSquare order ID.
stateenumyesOPEN | COMPLETED | CANCELED | DRAFT.
total_moneypenniesTotal inc. tax/tips.
created_atdatetimeyesOpened on POS. Indexed.
closed_atdatetimePaid or cancelled.

Relationships

Outbound (2)
Inbound (3)
  • Customer[:PLACED_ORDER]SquareOrder
  • Customer[:CONTRIBUTED_TO]SquareOrderamount (pennies), status, is_lead, payment_method
  • Booking[:HAS_NEO_ORDER]SquareOrder