# View: manual_adjustment

**View Name:** manual_adjustment
**Table Source:** `ROYALTY_ACCOUNTING.PROD.VW_ABACUS_MANUAL_ADJUSTMENT`
**File Path:** `manual_adjustment.view.lkml`

## Overview

- **File Size:** 3102 bytes
- **Lines of Code:** 142
- **Dimensions:** 17
- **Measures:** 4
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- sql: IFF(${booked_vendor_contract_snapshot.currency_id} = 1, ${TABLE}.amount, ${TABLE}.AMOUNT_IN_ORIGINAL_CURRENCY*${booked_vendor_contract_snapshot.exchange_rate}) ;;
- sql: IFF(${booked_vendor_contract_snapshot.currency_id} = 1, ${TABLE}.amount, ${TABLE}.AMOUNT_IN_ORIGINAL_CURRENCY*bvcs_exchange_rates.exchange_rate);;

## Dimensions

| Name | Type |
|------|------|
| `id` | number |
| `parent_type` | string |
| `parent_id` | number |
| `date_added` | string |
| `created_by` | number |
| `adjust_for_year` | number |
| `adjust_for_quarter` | number |
| `apply_to_year` | number |
| `apply_to_quarter` | number |
| `comment` | string |
| `category` | string |
| `category_id` | number |
| `adjust_for_period_id` | number |
| `apply_to_period_id` | number |
| `currencies_id` | number |
| `attachment_location` | string |
| `updated_timestamp` | string |

## Measures

| Name | Type |
|------|------|
| `count` | count |
| `amount` | sum |
| `amount_in_original_currency` | sum |
| `amount_in_reporting_currency` | sum |