---
title: "CRS_TRLB (AccountView)"
description: "Reporting"
language: es
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/es/datamodels/vismaaccountview/AccountView..CRS_TRLB
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..CRS_TRLB
updated: 2026-11-16T21:13:20Z
license: https://documentation.invantive.eu/es/
---

# CRS_TRLB: AccountView Reporting

`read only` `per partition`

- Catálogo: `AccountView`
- Label: Reporting

Solo puede recuperar datos.

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `CRS_TRLB`. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACCT_NR` | `varchar2(10)` | General ledger account | [ ] |  |  |
| `BAL_AAC_CY` | `int64` | Balance sheet CY credit | [ ] |  |  |
| `BAL_AAC_PY` | `int64` | Balance sheet PY credit | [ ] |  |  |
| `BAL_AAD_CY` | `int64` | Balance sheet CY debit | [ ] |  |  |
| `BAL_AAD_PY` | `int64` | Balance sheet PY debit | [ ] |  |  |
| `BAL_AAN_CY` | `int64` | Balance sheet CY | [ ] |  |  |
| `BAL_AAN_PY` | `int64` | Balance sheet PY | [ ] |  |  |
| `BAL_ABC_CY` | `int64` | Net balance sheet CY credit | [ ] |  |  |
| `BAL_ABD_CY` | `int64` | Net balance sheet CY debit | [ ] |  |  |
| `BAL_AQN_CY` | `decimal` | Balance sheet CY qty | [ ] |  |  |
| `BAL_AQN_PY` | `decimal` | Balance sheet PY qty | [ ] |  |  |
| `BAL_DAN_YY` | `int64` | Balance sheet CY - PY | [ ] |  |  |
| `BAL_DQN_YY` | `decimal` | Balance sheet CY - PY qty | [ ] |  |  |
| `BAL_PAN_YY` | `decimal` | Balance sheet CY - PY % | [ ] |  |  |
| `BAL_PQN_YY` | `decimal` | Balance sheet CY - PY qty % | [ ] |  |  |
| `BUD_EMP_NR` | `varchar2(10)` | Budget holder | [ ] |  |  |
| `COR_AAC_CY` | `int64` | Adjustment CY credit | [ ] |  |  |
| `COR_AAC_PY` | `int64` | Adjustments PY credit | [ ] |  |  |
| `COR_AAD_CY` | `int64` | Adjustments CY debit | [ ] |  |  |
| `COR_AAD_PY` | `int64` | Adjustments PY debit | [ ] |  |  |
| `COR_AAN_CY` | `int64` | Adjustment CY | [ ] |  |  |
| `COR_AAN_PY` | `int64` | Adjustments PY | [ ] |  |  |
| `COR_AQN_CY` | `decimal` | Adjustments CY qty | [ ] |  |  |
| `COR_AQN_PY` | `decimal` | Adjustments PY qty | [ ] |  |  |
| `COR_DAN_YY` | `int64` | Adjustments CY - PY | [ ] |  |  |
| `COR_DQN_YY` | `decimal` | Adjustments CY - PY qty | [ ] |  |  |
| `COR_PAN_YY` | `decimal` | Adjustments CY - PY % | [ ] |  |  |
| `COR_PQN_YY` | `decimal` | Adjustments CY - PY qty % | [ ] |  |  |
| `COST_CODE` | `varchar2(10)` | Cost centre code | [ ] |  |  |
| `DIM_KEY` | `varchar2(100)` | Dimension key | [ ] |  |  |
| `DSP_FMT` | `varchar2(1)` | Line format | [ ] |  |  |
| `FCT_AAN_CY` | `int64` | Forecast CY | [ ] |  |  |
| `FCT_AQN_CY` | `decimal` | Forecast CY qty | [ ] |  |  |
| `FCT_DAN_CY` | `int64` | Forecast CY - Budget Year-end CY | [ ] |  |  |
| `FCT_DQN_CY` | `decimal` | Forecast CY - Budget Year-end CY qty | [ ] |  |  |
| `FCT_PAN_CY` | `decimal` | Forecast CY - Budget Year-end CY % | [ ] |  |  |
| `FCT_PQN_CY` | `decimal` | Forecast CY - Budget Year-end CY qty % | [ ] |  |  |
| `INC_AAC_CY` | `int64` | P&L CY credit | [ ] |  |  |
| `INC_AAC_PY` | `int64` | P&L PY credit | [ ] |  |  |
| `INC_AAD_CY` | `int64` | P&L CY debit | [ ] |  |  |
| `INC_AAD_PY` | `int64` | P&L PY debit | [ ] |  |  |
| `INC_AAN_CY` | `int64` | P&L CY | [ ] |  |  |
| `INC_AAN_PY` | `int64` | P&L PY | [ ] |  |  |
| `INC_ABC_CY` | `int64` | Net P&L CY credit | [ ] |  |  |
| `INC_ABD_CY` | `int64` | Net P&L CY debit | [ ] |  |  |
| `INC_AQN_CY` | `decimal` | P&L CY qty | [ ] |  |  |
| `INC_AQN_PY` | `decimal` | P&L PY qty | [ ] |  |  |
| `INC_DAN_YY` | `int64` | P&L CY - PY | [ ] |  |  |
| `INC_DQN_YY` | `decimal` | P&L CY - PY qty | [ ] |  |  |
| `INC_PAN_YY` | `decimal` | P&L CY - PY % | [ ] |  |  |
| `INC_PQN_YY` | `decimal` | P&L CY - PY qty % | [ ] |  |  |
| `IND_LVL` | `int32` | Indentation level | [ ] |  |  |
| `LINE_BOLD` | `char` | Bold line | [ ] |  |  |
| `LINE_DESC` | `varchar2(60)` | Line description | [ ] |  |  |
| `LINE_LVL` | `int32` | Level | [ ] |  |  |
| `LINE_TYPE` | `int32` | Line type | [ ] |  |  |
| `MND_PER` | `int32` | Months | [ ] |  |  |
| `MUT_AAC_CY` | `int64` | Movements CY credit | [ ] |  |  |
| `MUT_AAC_PY` | `int64` | Movements PY credit | [ ] |  |  |
| `MUT_AAD_CY` | `int64` | Movements CY debit | [ ] |  |  |
| `MUT_AAD_PY` | `int64` | Movements PY debit | [ ] |  |  |
| `MUT_AAN_CY` | `int64` | Movements CY | [ ] |  |  |
| `MUT_AAN_PY` | `int64` | Movements PY | [ ] |  |  |
| `MUT_AQN_CY` | `decimal` | Movements CY qty | [ ] |  |  |
| `MUT_AQN_PY` | `decimal` | Movements PY qty | [ ] |  |  |
| `MUT_DAN_YY` | `int64` | Movements CY - PY | [ ] |  |  |
| `MUT_DQN_YY` | `decimal` | Movements CY - PY qty | [ ] |  |  |
| `MUT_PAN_YY` | `decimal` | Movements CY - PY % | [ ] |  |  |
| `MUT_PQN_YY` | `decimal` | Movements CY - PY qty % | [ ] |  |  |
| `OPN_AAC_CY` | `int64` | Opening balance CY credit | [ ] |  |  |
| `OPN_AAC_PY` | `int64` | Opening balance PY credit | [ ] |  |  |
| `OPN_AAD_CY` | `int64` | Opening balance CY debit | [ ] |  |  |
| `OPN_AAD_PY` | `int64` | Opening balance PY debit | [ ] |  |  |
| `OPN_AAN_CY` | `int64` | Opening balance CY | [ ] |  |  |
| `OPN_AAN_PY` | `int64` | Opening balance PY | [ ] |  |  |
| `OPN_AQN_CY` | `decimal` | Opening balance CY qty | [ ] |  |  |
| `OPN_AQN_PY` | `decimal` | Opening balance PY qty | [ ] |  |  |
| `OPN_CAC_CY` | `int64` | Opening balance CY credit net | [ ] |  |  |
| `OPN_CAD_CY` | `int64` | Opening balance CY debit net | [ ] |  |  |
| `OPN_DAN_YY` | `int64` | Opening balance CY - PY | [ ] |  |  |
| `OPN_DQN_YY` | `decimal` | Opening balance CY - PY qty | [ ] |  |  |
| `OPN_PAN_YY` | `decimal` | Opening balance CY - PY % | [ ] |  |  |
| `OPN_PQN_YY` | `decimal` | Opening balance CY - PY qty % | [ ] |  |  |
| `PA_CODE` | `varchar2(10)` | Partner | [ ] |  |  |
| `PAGE_BREAK` | `char` | Page break | [ ] |  |  |
| `PARENT_ID` | `varchar2(10)` | Parent element | [ ] |  |  |
| `PART_RNG` | `varchar2(20)` | Partner as dimension | [ ] |  |  |
| `partition_code` | `varchar2` | Partition code | [x] |  |  |
| `partition_name` | `varchar2` | Partition name | [x] |  |  |
| `PC_CODE` | `varchar2(5)` | Cost type | [ ] |  |  |
| `PER_AAC_CY` | `int64` | Period CY credit | [ ] |  |  |
| `PER_AAC_PY` | `int64` | Period PY credit | [ ] |  |  |
| `PER_AAD_CY` | `int64` | Period CY debit | [ ] |  |  |
| `PER_AAD_PY` | `int64` | Period PY debit | [ ] |  |  |
| `PER_AAN_CY` | `int64` | Period CY | [ ] |  |  |
| `PER_AAN_PY` | `int64` | Period PY | [ ] |  |  |
| `PER_AAP_CY` | `decimal` | Period 100% CY | [ ] |  |  |
| `PER_AAP_PY` | `decimal` | Period 100% PY | [ ] |  |  |
| `PER_ABC_CY` | `int64` | Net period CY credit | [ ] |  |  |
| `PER_ABD_CY` | `int64` | Net period CY debit | [ ] |  |  |
| `PER_AQN_CY` | `decimal` | Period CY qty | [ ] |  |  |
| `PER_AQN_PY` | `decimal` | Period PY qty | [ ] |  |  |
| `PER_AQP_CY` | `decimal` | Period 100% CY qty | [ ] |  |  |
| `PER_AQP_PY` | `decimal` | Period 100% PY qty | [ ] |  |  |
| `PER_BAN_CY` | `int64` | Budget period CY | [ ] |  |  |
| `PER_BAN_PY` | `int64` | Budget period PY | [ ] |  |  |
| `PER_BAN_YY` | `int64` | Budget period CY - PY | [ ] |  |  |
| `PER_BAP_YY` | `decimal` | Budget period CY - PY % | [ ] |  |  |
| `PER_BQN_CY` | `decimal` | Budget period CY qty | [ ] |  |  |
| `PER_BQN_PY` | `decimal` | Budget period PY qty | [ ] |  |  |
| `PER_BQN_YY` | `decimal` | Budget period CY - PY qty | [ ] |  |  |
| `PER_BQP_YY` | `decimal` | Budget period CY - PY qty % | [ ] |  |  |
| `PER_DAN_CY` | `int64` | Period CY - Budget period CY | [ ] |  |  |
| `PER_DAN_PY` | `int64` | Period PY - Budget period PY | [ ] |  |  |
| `PER_DAN_YY` | `int64` | Period CY - PY | [ ] |  |  |
| `PER_DQN_CY` | `decimal` | Period CY - Budget period CY qty | [ ] |  |  |
| `PER_DQN_PY` | `decimal` | Period PY - Budget period PY qty | [ ] |  |  |
| `PER_DQN_YY` | `decimal` | Period CY - PY qty | [ ] |  |  |
| `PER_PAN_CY` | `decimal` | Period CY - Budget period CY % | [ ] |  |  |
| `PER_PAN_PY` | `decimal` | Period PY - Budget period PY % | [ ] |  |  |
| `PER_PAN_YY` | `decimal` | Period CY - PY % | [ ] |  |  |
| `PER_PQN_CY` | `decimal` | Period CY - Budget period CY qty % | [ ] |  |  |
| `PER_PQN_PY` | `decimal` | Period PY - Budget period PY qty % | [ ] |  |  |
| `PER_PQN_YY` | `decimal` | Period CY - PY qty % | [ ] |  |  |
| `PROJ_CODE` | `varchar2(10)` | Project code | [ ] |  |  |
| `QTR_PER` | `int32` | Quarters | [ ] |  |  |
| `REC_ID` | `varchar2(10)` | Unique code | [ ] |  |  |
| `REC_KEY` | `varchar2(20)` | Source key | [ ] |  |  |
| `RNG_CODE` | `varchar2(10)` | Partner administration | [ ] |  |  |
| `RST_BAN_CY` | `int64` | Remaining budget CY | [ ] |  |  |
| `RST_BQN_CY` | `decimal` | Remaining budget CY qty | [ ] |  |  |
| `SHOW_ICON` | `int32` | Icon | [ ] |  |  |
| `SHOW_LINE` | `char` | Show total line | [ ] |  |  |
| `SHOW_REC` | `char` | Show line | [ ] |  |  |
| `TAX_ID` | `varchar2(10)` | Element code | [ ] |  |  |
| `TIL_AAC_CY` | `int64` | Up to period CY credit | [ ] |  |  |
| `TIL_AAC_PY` | `int64` | Up to period PY credit | [ ] |  |  |
| `TIL_AAD_CY` | `int64` | Up to period CY debit | [ ] |  |  |
| `TIL_AAD_PY` | `int64` | Up to period PY debit | [ ] |  |  |
| `TIL_AAN_CY` | `int64` | Up to period CY | [ ] |  |  |
| `TIL_AAN_PY` | `int64` | Up to period PY | [ ] |  |  |
| `TIL_AAP_CY` | `decimal` | Up to period 100% CY | [ ] |  |  |
| `TIL_AAP_PY` | `decimal` | Up to period 100% PY | [ ] |  |  |
| `TIL_ABC_CY` | `int64` | Net up to period CY credit | [ ] |  |  |
| `TIL_ABC_PY` | `int64` | Net up to period PY credit | [ ] |  |  |
| `TIL_ABD_CY` | `int64` | Net up to period CY debit | [ ] |  |  |
| `TIL_ABD_PY` | `int64` | Net up to period PY debit | [ ] |  |  |
| `TIL_AQN_CY` | `decimal` | Up to period CY qty | [ ] |  |  |
| `TIL_AQN_PY` | `decimal` | Up to period PY qty | [ ] |  |  |
| `TIL_AQP_CY` | `decimal` | Up to period 100% CY qty | [ ] |  |  |
| `TIL_AQP_PY` | `decimal` | Up to period 100% PY qty | [ ] |  |  |
| `TIL_BAN_CY` | `int64` | Budget up to period CY | [ ] |  |  |
| `TIL_BAN_PY` | `int64` | Budget up to period PY | [ ] |  |  |
| `TIL_BAN_YY` | `int64` | Budget up to period CY - PY | [ ] |  |  |
| `TIL_BAP_YY` | `decimal` | Budget up to period CY - PY % | [ ] |  |  |
| `TIL_BQN_CY` | `decimal` | Budget up to period CY qty | [ ] |  |  |
| `TIL_BQN_PY` | `decimal` | Budget up to period PY qty | [ ] |  |  |
| `TIL_BQN_YY` | `decimal` | Budget up to period CY - PY qty | [ ] |  |  |
| `TIL_BQP_YY` | `decimal` | Budget up to period CY - PY qty % | [ ] |  |  |
| `TIL_DAN_CY` | `int64` | Up to period CY - Budget up to period CY | [ ] |  |  |
| `TIL_DAN_PY` | `int64` | Up to period PY - Budget up to period PY | [ ] |  |  |
| `TIL_DAN_YY` | `int64` | Up to period CY - PY | [ ] |  |  |
| `TIL_DQN_CY` | `decimal` | Up to period CY - Budget up to period CY qty | [ ] |  |  |
| `TIL_DQN_PY` | `decimal` | Up to period PY - Budget up to period PY qty | [ ] |  |  |
| `TIL_DQN_YY` | `decimal` | Up to period CY - PY qty | [ ] |  |  |
| `TIL_PAN_CY` | `decimal` | Up to period CY - Budget up to period CY % | [ ] |  |  |
| `TIL_PAN_PY` | `decimal` | Up to period PY - Budget up to period PY % | [ ] |  |  |
| `TIL_PAN_YY` | `decimal` | Up to period CY - PY % | [ ] |  |  |
| `TIL_PQN_CY` | `decimal` | Up to period CY - Budget up to period CY qty % | [ ] |  |  |
| `TIL_PQN_PY` | `decimal` | Up to period PY - Budget up to period PY qty % | [ ] |  |  |
| `TIL_PQN_YY` | `decimal` | Up to period CY - PY qty % | [ ] |  |  |
| `TOT_AAC_CY` | `int64` | Actual CY credit | [ ] |  |  |
| `TOT_AAC_PY` | `int64` | Actual PY credit | [ ] |  |  |
| `TOT_AAD_CY` | `int64` | Actual CY debit | [ ] |  |  |
| `TOT_AAD_PY` | `int64` | Actual PY debit | [ ] |  |  |
| `TOT_AAN_CY` | `int64` | Actual CY | [ ] |  |  |
| `TOT_AAN_PY` | `int64` | Actual PY | [ ] |  |  |
| `TOT_AAP_CY` | `decimal` | Actual 100% CY | [ ] |  |  |
| `TOT_AAP_PY` | `decimal` | Actual 100% PY | [ ] |  |  |
| `TOT_ABC_CY` | `int64` | Net actual CY credit | [ ] |  |  |
| `TOT_ABD_CY` | `int64` | Net actual CY debit | [ ] |  |  |
| `TOT_AQN_CY` | `decimal` | Actual CY qty | [ ] |  |  |
| `TOT_AQN_PY` | `decimal` | Actual PY qty | [ ] |  |  |
| `TOT_AQP_CY` | `decimal` | Actual 100% CY qty | [ ] |  |  |
| `TOT_AQP_PY` | `decimal` | Actual 100% PY qty | [ ] |  |  |
| `TOT_BAN_CY` | `int64` | Budget CY | [ ] |  |  |
| `TOT_BAN_PY` | `int64` | Budget PY | [ ] |  |  |
| `TOT_BAN_YY` | `int64` | Budget CY - PY | [ ] |  |  |
| `TOT_BAP_CY` | `decimal` | Budget 100% CY | [ ] |  |  |
| `TOT_BAP_PY` | `decimal` | Budget 100% PY | [ ] |  |  |
| `TOT_BAP_YY` | `decimal` | Budget CY - PY % | [ ] |  |  |
| `TOT_BQN_CY` | `decimal` | Budget CY qty | [ ] |  |  |
| `TOT_BQN_PY` | `decimal` | Budget PY qty | [ ] |  |  |
| `TOT_BQN_YY` | `decimal` | Budget CY - PY qty | [ ] |  |  |
| `TOT_BQP_CY` | `decimal` | Budget 100% CY qty | [ ] |  |  |
| `TOT_BQP_PY` | `decimal` | Budget 100% PY qty | [ ] |  |  |
| `TOT_BQP_YY` | `decimal` | Budget CY - PY qty % | [ ] |  |  |
| `TOT_DAN_CY` | `int64` | Actual CY - Budget CY | [ ] |  |  |
| `TOT_DAN_PY` | `int64` | Actual PY - Budget PY | [ ] |  |  |
| `TOT_DAN_YY` | `int64` | Actual CY - PY | [ ] |  |  |
| `TOT_DQN_CY` | `decimal` | Actual CY - Budget CY qty | [ ] |  |  |
| `TOT_DQN_PY` | `decimal` | Actual PY - Budget PY qty | [ ] |  |  |
| `TOT_DQN_YY` | `decimal` | Actual CY - PY qty | [ ] |  |  |
| `TOT_PAN_CY` | `decimal` | Actual CY - Budget CY % | [ ] |  |  |
| `TOT_PAN_PY` | `decimal` | Actual PY - Budget PY % | [ ] |  |  |
| `TOT_PAN_YY` | `decimal` | Actual CY - PY % | [ ] |  |  |
| `TOT_PQN_CY` | `decimal` | Actual CY - Budget CY qty % | [ ] |  |  |
| `TOT_PQN_PY` | `decimal` | Actual PY - Budget PY qty % | [ ] |  |  |
| `TOT_PQN_YY` | `decimal` | Actual CY - PY qty % | [ ] |  |  |
| `TRN_PER` | `int32` | Period | [ ] |  |  |
| `ULT_AAC_PY` | `int64` | Year-end PY credit | [ ] |  |  |
| `ULT_AAD_PY` | `int64` | Year-end PY debit | [ ] |  |  |
| `ULT_AAN_PY` | `int64` | Year-end PY | [ ] |  |  |
| `ULT_AAP_PY` | `decimal` | Year-end 100% PY | [ ] |  |  |
| `ULT_AQN_PY` | `decimal` | Year-end PY qty | [ ] |  |  |
| `ULT_AQP_PY` | `decimal` | Year-end 100% PY qty | [ ] |  |  |
| `ULT_BAN_CY` | `int64` | Budget year-end CY | [ ] |  |  |
| `ULT_BAN_PY` | `int64` | Budget year-end PY | [ ] |  |  |
| `ULT_BQN_CY` | `decimal` | Year-end budget CY qty | [ ] |  |  |
| `ULT_BQN_PY` | `decimal` | Budget year-end PY qty | [ ] |  |  |
| `ULT_DAN_PY` | `int64` | Year-end PY - Budget year-end PY | [ ] |  |  |
| `ULT_DQN_PY` | `decimal` | Year-end PY - Budget year-end PY qty | [ ] |  |  |
| `ULT_PAN_PY` | `decimal` | Year-end PY - Budget year-end PY % | [ ] |  |  |
| `ULT_PQN_PY` | `decimal` | Year-end PY - Budget year-end PY qty % | [ ] |  |  |
