Saltar al contenido

app.partner_agreements

TablaSeguridad a nivel de fila activa

Wholesale terms of a partner org (Section 4.6.1): the platform bills the partner at list price less the discount. Recorded by the platform with the service role; partners read their own.

Clave primaria: id

Columnas de app.partner_agreements
ColumnaTipoAdmite nulosDescripción
iduuidNoPrimary key, UUID v7.
org_iduuidNoOwning org. A row never moves to another org.Hace referencia a app.organizations.id
wholesale_discount_bpsintegerNoDiscount off list price in basis points (2000 is 20 percent).
currency_codecharacter(3)NoCurrency the partner is billed in.Hace referencia a private.currencies.currency_code
signed_ondateNoDate the partner agreement was signed.
created_attimestamp with time zoneNoWhen the row was inserted. Set by the database.
created_byuuidSíPerson who inserted the row, or null for a platform process. Set by the database.Hace referencia a app.people.id
updated_attimestamp with time zoneNoWhen the row last changed. Set by the database.
updated_byuuidSíPerson who last changed the row, or null for a platform process. Set by the database.Hace referencia a app.people.id
deleted_attimestamp with time zoneSíSoft delete time. A row with deleted_at set is ignored by every access helper.