Skip to main content
The B2B enriched layer provides 8 denormalized views organized into four logical groups. Each view is self-contained for common queries, but foreign key columns allow you to join across views when needed.
These views mirror the data available through the B2B REST API. Column names and structures are designed to be compatible across both access methods.
Every view includes:
  • A primary key column (e.g., buyer_id, invoice_id)
  • A last_updated timestamp for incremental loading
  • A vetcove_corporate_id for corporate group identification
  • An is_deleted flag for soft-delete awareness

​
Buyers and Budgets

The buyer is the foundational entity in the B2B model, representing a purchasing location. Budget views track configured spend targets and actual spend at monthly and weekly granularity.

​
Orders

Supplier order views covering order headers and line items. Orders are placed by buyers and fulfilled by suppliers.

​
Invoices

Invoice views covering supplier invoice headers and line items. Invoices are associated with buyers and may reference supplier orders.

​
Prescriptions

Third-party pharmacy prescription requests, including patient, medication, and retailer details.