# LEAD: Categories - Name: `LEAD` - Catalog: `AccountView` - Label: Categories - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `LEAD` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_FROM` | `string(2)` | Account number from | ☐ | | | `ACCT_NR1` | `string(10)` | Account number from | ☐ | | | `ACCT_NR2` | `string(10)` | Account number up to and including | ☐ | | | `ACCT_TO` | `string(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` | `string(20)` | Employee last modified | ☐ | | | `HINT_LIST` | `string(4)` | Recognition codes | ☐ | | | `HINT_ORDER` | `decimal` | Recognition order of application | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `LEAD_CODE` | `string(10)` | Category code | ☐ | | | `LEAD_DESC` | `string(40)` | Category description | ☐ | | | `LEAD_FO` | `string(10)` | Category code Financial Overview | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `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` | `string(5)` | Ratio group | ☐ | | | `USE_HINT` | `boolean` | Use recognition codes | ☐ | |