maiven gateway · online··
manifest · 2d ago
Sign in
Back to catalog
MAIVENmodelstaging

stg_postgres__vendors

staging view 7 PII columns

Vendors, cleaned.

Definition

Vendor master for the `vendor` data subject. Contact / financial / location PII tagged so masking fires downstream; the identity surface a vendor DSAR erases.

19 of 19
Column
Description
Tests · PII
vendor_id
Primary key — UInt64.
vendor PII4 tests
vendor_code
Short unique vendor code.
2 tests
legal_name
Vendor legal (business) name.
primary_contact_name
Named contact. Identity PII. Nullable.
PII
primary_contact_email
Lowercased 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, uppercased.
payment_terms
Terms — net_15 / net_30 / net_60 / due_on_receipt.
1 test
default_currency
Default billing currency, uppercased.
bank_account_last4
Last 4 of payout bank account. Financial PII. Nullable.
PII
is_1099
True if a US 1099 vendor.
is_active
True for active vendors.
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 the loader extracted this row from postgres-source.