---
title: "LEAD (AccountView)"
description: "Categories"
language: es
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/es/datamodels/vismaaccountview/AccountView..LEAD
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..LEAD
updated: 2026-11-16T21:14:06Z
license: https://documentation.invantive.eu/es/
---

# LEAD: AccountView Categories

`read only` `per partition`

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

Solo puede recuperar datos.

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `LEAD`. 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_FROM` | `varchar2(2)` | Account number from | [ ] |  |  |
| `ACCT_NR1` | `varchar2(10)` | Account number from | [ ] |  |  |
| `ACCT_NR2` | `varchar2(10)` | Account number up to and including | [ ] |  |  |
| `ACCT_TO` | `varchar2(2)` | Account number up to and including | [ ] |  |  |
| `ACCT_TYPE` | `int32` | Account type | [ ] |  |  |
| `BAL_CY` | `int64` | Current financial year | [ ] |  |  |
| `BAL_PY` | `int64` | Previous financial year | [ ] |  |  |
| `BUD_CY` | `int64` | Total budget current financial year | [ ] |  |  |
| `BUD_CY_0` | `int64` | Budget period 0 current year | [ ] |  |  |
| `BUD_CY_1` | `int64` | Budget period 1 current year | [ ] |  |  |
| `BUD_CY_10` | `int64` | Budget period 10 current year | [ ] |  |  |
| `BUD_CY_11` | `int64` | Budget period 11 current year | [ ] |  |  |
| `BUD_CY_12` | `int64` | Budget period 12 current year | [ ] |  |  |
| `BUD_CY_13` | `int64` | Budget period 13 current year | [ ] |  |  |
| `BUD_CY_14` | `int64` | Budget period 14 current year | [ ] |  |  |
| `BUD_CY_2` | `int64` | Budget period 2 current year | [ ] |  |  |
| `BUD_CY_3` | `int64` | Budget period 3 current year | [ ] |  |  |
| `BUD_CY_4` | `int64` | Budget period 4 current year | [ ] |  |  |
| `BUD_CY_5` | `int64` | Budget period 5 current year | [ ] |  |  |
| `BUD_CY_6` | `int64` | Budget period 6 current year | [ ] |  |  |
| `BUD_CY_7` | `int64` | Budget period 7 current year | [ ] |  |  |
| `BUD_CY_8` | `int64` | Budget period 8 current year | [ ] |  |  |
| `BUD_CY_9` | `int64` | Budget period 9 current year | [ ] |  |  |
| `BUD_PY` | `int64` | Total budget previous financial year | [ ] |  |  |
| `BUD_PY_0` | `int64` | Budget period 0 prior year | [ ] |  |  |
| `BUD_PY_1` | `int64` | Budget period 1 prior year | [ ] |  |  |
| `BUD_PY_10` | `int64` | Budget period 10 prior year | [ ] |  |  |
| `BUD_PY_11` | `int64` | Budget period 11 prior year | [ ] |  |  |
| `BUD_PY_12` | `int64` | Budget period 12 prior year | [ ] |  |  |
| `BUD_PY_13` | `int64` | Budget period 13 prior year | [ ] |  |  |
| `BUD_PY_14` | `int64` | Budget period 14 prior year | [ ] |  |  |
| `BUD_PY_2` | `int64` | Budget period 2 prior year | [ ] |  |  |
| `BUD_PY_3` | `int64` | Budget period 3 prior year | [ ] |  |  |
| `BUD_PY_4` | `int64` | Budget period 4 prior year | [ ] |  |  |
| `BUD_PY_5` | `int64` | Budget period 5 prior year | [ ] |  |  |
| `BUD_PY_6` | `int64` | Budget period 6 prior year | [ ] |  |  |
| `BUD_PY_7` | `int64` | Budget period 7 prior year | [ ] |  |  |
| `BUD_PY_8` | `int64` | Budget period 8 prior year | [ ] |  |  |
| `BUD_PY_9` | `int64` | Budget period 9 prior year | [ ] |  |  |
| `CHK_ABAL` | `decimal` | Linked account check | [ ] |  |  |
| `CHK_ATYP` | `decimal` | Check account type | [ ] |  |  |
| `CHK_LBAL` | `decimal` | Check category balance | [ ] |  |  |
| `CNG_DATE` | `datetime` | Date modified | [ ] |  |  |
| `CNG_NR` | `int32` | Change number | [ ] |  |  |
| `CNG_USR` | `varchar2(20)` | Employee last modified | [ ] |  |  |
| `HINT_LIST` | `varchar2(4)` | Recognition codes | [ ] |  |  |
| `HINT_ORDER` | `decimal` | Recognition order of application | [ ] |  |  |
| `INP_DATE` | `datetime` | Entry date | [ ] |  |  |
| `INP_USR` | `varchar2(20)` | Entered by employee | [ ] |  |  |
| `LEAD_CODE` | `varchar2(10)` | Category code | [ ] |  |  |
| `LEAD_DESC` | `varchar2(40)` | Category description | [ ] |  |  |
| `LEAD_FO` | `varchar2(10)` | Category code Financial Overview | [ ] |  |  |
| `partition_code` | `varchar2` | Partition code | [x] |  |  |
| `partition_name` | `varchar2` | Partition name | [x] |  |  |
| `PER_CY_0` | `int64` | Period 0 current financial year | [ ] |  |  |
| `PER_CY_1` | `int64` | Period 1 current financial year | [ ] |  |  |
| `PER_CY_10` | `int64` | Period 10 current financial year | [ ] |  |  |
| `PER_CY_11` | `int64` | Period 11 current financial year | [ ] |  |  |
| `PER_CY_12` | `int64` | Period 12 current financial year | [ ] |  |  |
| `PER_CY_13` | `int64` | Period 13 current financial year | [ ] |  |  |
| `PER_CY_14` | `int64` | Period 14 current financial year | [ ] |  |  |
| `PER_CY_2` | `int64` | Period 2 current financial year | [ ] |  |  |
| `PER_CY_3` | `int64` | Period 3 current financial year | [ ] |  |  |
| `PER_CY_4` | `int64` | Period 4 current financial year | [ ] |  |  |
| `PER_CY_5` | `int64` | Period 5 current financial year | [ ] |  |  |
| `PER_CY_6` | `int64` | Period 6 current financial year | [ ] |  |  |
| `PER_CY_7` | `int64` | Period 7 current financial year | [ ] |  |  |
| `PER_CY_8` | `int64` | Period 8 current financial year | [ ] |  |  |
| `PER_CY_9` | `int64` | Period 9 current financial year | [ ] |  |  |
| `PER_PY_0` | `int64` | Period 0 prior year | [ ] |  |  |
| `PER_PY_1` | `int64` | Period 1 prior financial year | [ ] |  |  |
| `PER_PY_10` | `int64` | Period 10 prior financial year | [ ] |  |  |
| `PER_PY_11` | `int64` | Period 11 prior financial year | [ ] |  |  |
| `PER_PY_12` | `int64` | Period 12 prior financial year | [ ] |  |  |
| `PER_PY_13` | `int64` | Period 13 prior financial year | [ ] |  |  |
| `PER_PY_14` | `int64` | Period 14 prior financial year | [ ] |  |  |
| `PER_PY_2` | `int64` | Period 2 prior financial year | [ ] |  |  |
| `PER_PY_3` | `int64` | Period 3 prior financial year | [ ] |  |  |
| `PER_PY_4` | `int64` | Period 4 prior financial year | [ ] |  |  |
| `PER_PY_5` | `int64` | Period 5 prior financial year | [ ] |  |  |
| `PER_PY_6` | `int64` | Period 6 prior financial year | [ ] |  |  |
| `PER_PY_7` | `int64` | Period 7 prior financial year | [ ] |  |  |
| `PER_PY_8` | `int64` | Period 8 prior financial year | [ ] |  |  |
| `PER_PY_9` | `int64` | Period 9 prior financial year | [ ] |  |  |
| `RAT_GRP` | `varchar2(5)` | Ratio group | [ ] |  |  |
| `USE_HINT` | `char` | Use recognition codes | [ ] |  |  |
