POS
Store sales, returns, settlements and stock movements.
251
Source rows at Day-0
29
Populated tables
47
Exported tables
Collections
Stores3
Company-owned and franchise stores.
Sales4
Retail sales by receipt. Lines, tenders and status history appear inside each.
Returns2
Returns against an original sale.
Settlements2
A store day's takings, and whether ERP has posted them.
Store Days2
A store's trading day — opened, closed, and summarised for settlement. SCN-X05's evidence.
Franchise Sync Batches2
A franchise store's offline batch, and whether the centre has acknowledged it. SCN-X06's evidence.
Stock Movements7
Store stock receipts, sales and returns.
Representative records
What these records become
Retail Transaction ×4 · Location ×3
Canonical records projected from POS source records. A source record's own page links to the canonical record it resolves or projects to.
Cross-system journeys
Technical schema — 47 exported tables in pos_src
- approval2
- audit_event75
- barcode0
- cash_count0
- cash_movement0
- coupon0
- customer_ref0
- daily_inventory_summary2
- daily_sales_summary0
- exchange0
- franchise_sync_batch2
- franchise_sync_record6
- goods_receipt_ref0
- idempotency_key75
- loyalty_account0
- loyalty_transaction0
- operator11
- operator_role13
- outbox_event8
- payment_reconciliation0
- price2
- price_book2
- product_ref2
- promotion0
- promotion_rule0
- refund1
- register2
- return_line2
- return_txn2
- role6
- sale4
- sale_line4
- sale_line_discount0
- sale_status_history4
- sale_tax0
- sale_void1
- settlement_batch2
- settlement_line4
- shift2
- stock_balance2
- stock_count0
- stock_count_line0
- stock_movement7
- store3
- store_day2
- tender3
- tender_adjustment0