# View: dt_ledger_account_contract_integrity

**View Name:** dt_ledger_account_contract_integrity
**Table Source:** `Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Royalty_Accounting_Royalty_Accounting, Prod_Royalty_Accounting_Royalty_Accounting.Ledger_Account_Contract`
**File Path:** `views/dt_ledger_account_contract_integrity.view.lkml`

## Overview

- **File Size:** 2413 bytes
- **Lines of Code:** 77
- **Dimensions:** 7
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `ledger_account_contract_id` | number |
| `contract_id` | number |
| `currency_amount` | string |
| `previous_balance` | string |
| `current_balance` | string |
| `previous_balance_diff` | string |
| `current_balance_diff` | string |

## Derived Table

```sql
sql:
      SELECT
          lac.LEDGER_ACCOUNT_CONTRACT_ID,
          lac.CONTRACT_ID,
          lac.CURRENCY_AMOUNT,
          lac.PREVIOUS_BALANCE,
          lac.CURRENT_BALANCE,
          (lac.PREVIOUS_BALANCE - LEAD(lac.CURRENT_BALANCE) OVER (PARTITION BY lac.CONTRACT_ID ORDER BY lac.LEDGER_ACCOUNT_CONTRACT_ID DESC)) AS PREVIOUS_BALANCE_DIFF,
          NULL AS CURRENT_BALANCE_DIFF
      FROM ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.LEDGER_ACCOUNT_CONTRACT lac
      QUALIFY ABS(PREVIOUS_BALANCE_DIFF) > 0
      UNION ALL
      SELECT
          lac.LEDGER_ACCOUNT_CONTRACT_ID,
          lac.CONTRACT_ID,
          lac.CURRENCY_AMOUNT,
          lac.PREVIOUS_BALANCE,
          lac.CURRENT_BALANCE,
          NULL AS PREVIOUS_BALANCE_DIFF,
          (lac.CURRENT_BALANCE - (lac.PREVIOUS_BALANCE + lac.CURRENCY_AMOUNT)) AS CURRENT_BALANCE_DIFF
      FROM ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.LEDGER_ACCOUNT_CONTRACT lac
      WHERE ABS(CURRENT_BALANCE_DIFF) > 0
      ORDER BY CONTRACT_ID, LEDGER_ACCOUNT_CONTRACT_ID DESC
    ;;
```