orders

source

What was bought, when, and for how much.

Definition

The operational order header — one row per order. `total_amount` plus the lifecycle `status` (cancelled/refunded vs. revenue-eligible) feed every revenue rollup downstream. Cancellation and refunds are excluded from revenue by convention across all certified metrics.

8 of 8

Column

Description

Tests · PII

order_id

Primary key — BIGSERIAL on the source.

customer +3 PII2 tests

customer_id

FK to `customers.customer_id`. NOT NULL on the source.

customer +18 PII1 test

order_date

Timestamp the order was placed (TIMESTAMPTZ). Renamed to `order_at` + derived `order_day` in staging.

status

Order lifecycle state. Revenue rollups exclude `cancelled` and `refunded`.

1 test

currency

ISO-4217 currency code of `total_amount`. Defaults to `USD`.

total_amount

Order grand total in `currency`. NUMERIC(12,2). Sums to revenue when status is a revenue state.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.