models:
- name: label_lookback
  description: This model provides a comprehensive financial overview for vendors,
    including revenue, expenses, and contractual details. It calculates key financial
    metrics such as net cash position and tax-adjusted metrics, offering insights
    into vendor performance and financial health.
  columns:
  - name: vendor_id
    description: Unique identifier for the vendor.
  - name: vendor
    description: Name of the vendor.
  - name: brand_name
    description: Brand name associated with the vendor.
  - name: owner
    description: Owner of the brand.
  - name: service_tier_name
    description: Service tier name for the vendor.
  - name: closer
    description: List of closers associated with the vendor.
  - name: label_start_date
    description: Start date of the vendor's contract.
  - name: contract_end_date
    description: End date of the vendor's contract, if applicable.
  - name: gross_revenue
    description: Total gross revenue for the vendor, adjusted for currency exchange.
  - name: distro_fee
    description: Distribution fee for the vendor, adjusted for currency exchange.
  - name: advance_paid
    description: Total advance paid to the vendor, adjusted for currency exchange.
  - name: payment
    description: Total payment made to the vendor, adjusted for currency exchange.
  - name: net_revenue
    description: Net revenue for the vendor, adjusted for currency exchange.
  - name: expenses
    description: Total expenses for the vendor, adjusted for currency exchange.
  - name: adjustments
    description: Total adjustments for the vendor, adjusted for currency exchange.
  - name: current_outstanding_balance
    description: Current outstanding balance for the vendor, adjusted for currency
      exchange.
  - name: net_cash_position
    description: Net cash position for the vendor, calculated as current outstanding
      balance minus distribution fee.
  - name: tax_adjusted_net_cash_position
    description: Tax-adjusted net cash position for the vendor, calculated as current
      outstanding balance minus 76% of the distribution fee.
  - name: moic
    description: Multiple on invested capital for the vendor, calculated based on
      advance paid and current outstanding balance.
  - name: tax_adjusted_moic
    description: Tax-adjusted multiple on invested capital for the vendor, calculated
      based on advance paid and current outstanding balance.

  config: 
    access: public