vendors

source 7 PII columns

Who we buy from and where we pay them.

Definition

Vendor master for the `vendor` data subject. Carries the primary-contact identity/contact, tax id, remit-to address, and bank last4. The identity surface a vendor DSAR erases.

18 of 18

Column

Description

Tests · PII

vendor_id

Primary key — BIGSERIAL on the source.

vendor PII2 tests

vendor_code

Short unique vendor code.

2 tests

legal_name

Vendor legal name (business name; not a natural-person identifier on its own).

primary_contact_name

Named contact at the vendor. Identity PII. Nullable.

PII

primary_contact_email

Contact email. Contact PII. Nullable.

PII

tax_id

Vendor tax id. Financial PII. Nullable.

PII

remit_to_line1

Remit-to street line. Location PII. Nullable.

PII

remit_to_city

Remit-to city. Location PII. Nullable.

PII

remit_to_region

Remit-to state / province. Nullable.

remit_to_postal_code

Remit-to postal code. Location PII. Nullable.

PII

remit_to_country

Remit-to country (normalised uppercase).

payment_terms

Terms — `net_15` / `net_30` / `net_60` / `due_on_receipt`.

1 test

default_currency

Default billing currency.

bank_account_last4

Last 4 of vendor payout bank account. Financial PII. Nullable.

PII

is_1099

True if a US 1099 vendor.

is_active

True for active vendors.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.