# View: dt_abacus_sync_account_lambda

**View Name:** dt_abacus_sync_account_lambda
**Table Source:** `Derived from: Prod.Vw_Dim_Abacus_Account, Prod.Vw_Dim_Abacus_Ar_Vendor, Royalty_Accounting, Royalty_Accounting.Prod, Royalty_Accounting_Reporting + 1 more`
**File Path:** `views/dt_abacus_sync_account_lambda.view.lkml`

## Overview

- **File Size:** 1258 bytes
- **Lines of Code:** 58
- **Dimensions:** 6
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `vendor_id` | string |
| `vendor_name` | string |
| `vendor_status` | string |
| `date_created` | string |
| `last_modified_at` | string |
| `last_modified_by` | string |

## Derived Table

```sql
sql:
        SELECT
            v.vendor_id,
            v.name as vendor_name,
            v.owner,
            v.status as vendor_status,
            v.date_created,
            v.last_update as last_modified_at,
            last_modified_by
        FROM
            royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v
        WHERE
            v.MIGRATED_TO_ABACUS = 1
            and not EXISTS (
                SELECT
                    ACCOUNT_ID
                FROM
                    ROYALTY_ACCOUNTING.PROD.VW_DIM_ABACUS_ACCOUNT da
                where
                    da.ACCOUNT_ID = v.VENDOR_ID
            )
            AND v.VENDOR_ID > 791414;;
```