# GL_STAT: Comparative annual figures - Name: `GL_STAT` - Catalog: `AccountView` - Label: Comparative annual figures - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `GL_STAT` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_NR` | `string(10)` | Account number | ☐ | | | `ACT_CRCY` | `int64` | Credit balance current year | ☐ | | | `ACT_CRPY` | `int64` | Credit balance prior year | ☐ | | | `ACT_CY` | `int64` | Balance current year | ☐ | | | `ACT_DRCY` | `int64` | Debit balance current year | ☐ | | | `ACT_DRPY` | `int64` | Debit balance prior year | ☐ | | | `ACT_PY` | `int64` | Balance prior year | ☐ | | | `CNG_DATE` | `datetime` | Last transaction date | ☐ | | | `COR_CRCY` | `int64` | Credit balance adjustments current year | ☐ | | | `COR_CRPY` | `int64` | Credit balance adjustments prior year | ☐ | | | `COR_CY` | `int64` | Adjustments balance current year | ☐ | | | `COR_DRCY` | `int64` | Debit balance adjustments current year | ☐ | | | `COR_DRPY` | `int64` | Debit balance adjustments prior year | ☐ | | | `COR_PY` | `int64` | Adjustments balance prior year | ☐ | | | `COR_QCY` | `decimal` | Number of adjustments current year | ☐ | | | `COR_QPY` | `decimal` | Number of adjustments prior year | ☐ | | | `COST_CODE` | `string(10)` | Cost centre code | ☐ | | | `FIN_ATTR` | `string(100)` | Financial dimensions | ☐ | | | `MND_PER` | `int32` | Months | ☐ | | | `PA_CODE` | `string(10)` | Partner code | ☐ | | | `PART_RNG` | `string(20)` | Partner as dimension | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PC_CODE` | `string(5)` | Cost type code | ☐ | | | `PROJ_CODE` | `string(10)` | Project code | ☐ | | | `QTR_PER` | `int32` | Quarters | ☐ | | | `QTY_CRCY` | `decimal` | Credit quantity current year | ☐ | | | `QTY_CRPY` | `decimal` | Credit quantity prior year | ☐ | | | `QTY_CY` | `decimal` | Quantity current year | ☐ | | | `QTY_DRCY` | `decimal` | Debit quantity current year | ☐ | | | `QTY_DRPY` | `decimal` | Debit quantity prior year | ☐ | | | `QTY_PY` | `decimal` | Quantity previous year | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `RNG_CODE` | `string(10)` | Partner administration | ☐ | | | `TRN_PER` | `int32` | Period | ☐ | |