maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
The typed returns ledger. `return_status` runs requested → approved → received → refunded (or rejected); `refund_amount` is non-zero only once `refunded`, so return-rate analytics must distinguish requested volume from realised refunds. `return_day` (toDate of requested_at) is the partition-friendly date for daily rollups.
16 of 16
Column
Description
Tests · PII
return_id
Primary key — UInt64.
2 tests
order_item_id
FK to the order line returned. UInt64.
1 test
product_id
FK to `stg_postgres__products.product_id`. Denormalised for category rollups.
2 tests
customer_id
FK to `stg_postgres__customers.customer_id`. The data-subject join key (table-level PII).
customer +18 PII1 test
return_reason
Why the item was returned.
1 test
return_status
Return lifecycle state. `refund_amount` is non-zero only when `refunded`.
1 test
quantity
Units returned on this line. UInt32.
1 test
refund_amount
Amount refunded in the order currency. Decimal(12,2); 0 until `refunded`.
1 test
requested_at
When the return was requested. DateTime64(6).
1 test
return_day
`toDate(requested_at)` — the grouping date for daily marts.
1 test
resolved_at
Terminal-state timestamp (received/refunded/rejected). Nullable while in flight.
restocked
Whether the returned unit went back into sellable inventory. Bool.
source_created_at
Row insert timestamp from the source DB. DateTime64(6).
source_updated_at
Row update timestamp from the source DB. DateTime64(6).
airbyte_extracted_at
When Airbyte extracted this row from postgres-source.