payments

source 1 PII columns

Money in / money back per order.

Definition

Per-order payment event stream. One order may have multiple rows: an auth, then a capture, then optional refunds/voids. Revenue = `transaction_type='capture' AND status='succeeded'` — summing `amount` blindly double-counts auth+capture. Joined to `payment_methods` and `orders` downstream.

10 of 10

Column

Description

Tests · PII

payment_id

Primary key — BIGSERIAL on the source.

2 tests

order_id

FK to `orders.order_id`. NOT NULL. ON DELETE CASCADE on the source.

customer +2 PII1 test

payment_method_id

FK to `payment_methods.payment_method_id`. Nullable — vendor failures may not carry a method.

transaction_type

`auth` / `capture` / `refund` / `void`.

1 test

status

`succeeded` / `failed` / `pending`.

1 test

amount

Transaction amount. NUMERIC(12,2). Per-row, NOT a customer total.

currency

ISO-4217 currency code.

failure_reason

Vendor diagnostic on failure. Nullable. Behavioural PII.

PII

processed_at

When the vendor processed the txn.

created_at

Row insert timestamp in the source DB.