Sales Orders Data Model
Sales Orders represent a confirmed intent by a Customer to purchase products or services.
Entity Relationship Diagram
Core Entities
Order (com.sureink.cloudmsa.model.order.Order)
The header record for a transaction.
- Key Fields:
name: Order reference (e.g., PO Number).customerCode: The buyer.status: State of the order (e.g., Pending, Completed, Cancelled).totalAmount: The final billable amount.paymentType: Method of payment (e.g., Credit Card, Invoice).
Order Item (com.sureink.cloudmsa.model.order.OrderItem)
Line items detailing specific products.
- Key Fields:
quantity: Number of units.unitPrice: Cost per unit.
Relationships
Order -> Order Item
- Type: One-to-Many
- Description: An Order is composed of one or more items.
Order -> Subscription
- Type: Many-to-One
- Description: Orders are often linked to a Subscription, especially for renewals or add-ons.