public-data-docs

Table: VOUCHERS_INVOICE_APPLIED_CONSTRAINT_VOUCHERS

Description:

Records per-invoice voucher and promotion rebate applications. Each row links an invoice to either an applied constraint voucher or an applied promotion voucherable, capturing the rebate amount.

🔑 Primary Key

id

Field Name	Data Type	Description
id	NUMBER	Surrogate (auto-generated) unique identifier for the rebate application record.
created_at	TIMESTAMP_TZ	Timestamp when the rebate application was created.
amount_gross	NUMBER	Gross rebate amount applied (including taxes).
amount_net	NUMBER	Net rebate amount applied (excluding taxes).
applied_constraint_voucher_id	NUMBER	References vouchers.id; the constraint voucher applied. NULL if a promotion was applied instead.
applied_promotion_voucherable_id	NUMBER	References voucherables.id; the promotion voucherable applied. NULL if a voucher was applied instead.
guser_id	NUMBER	User ID the rebate application is associated with.
invoice_id	NUMBER	Identifier of the invoice the rebate was applied to.
_snowflake_inserted_at	TIMESTAMP_NTZ	System timestamp when the record was inserted into Snowflake.
_snowflake_updated_at	TIMESTAMP_NTZ	System timestamp when the record was last updated in Snowflake.
_snowflake_deleted	BOOLEAN	True if the record was deleted in the source.