# EFS_STAT: Partners' comparative figures - Name: `EFS_STAT` - Catalog: `AccountView` - Label: Partners' comparative figures - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `EFS_STAT` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_NR` | `string(10)` | Account number | ☐ | | | `ACT_CY` | `int64` | Balance current year | ☐ | | | `ACT_PY` | `int64` | Balance prior year | ☐ | | | `COR_CY` | `int64` | Adjustments balance current year | ☐ | | | `COR_PY` | `int64` | Adjustments balance prior year | ☐ | | | `COST_CODE` | `string(10)` | Cost centre code | ☐ | | | `CR_ACT` | `int64` | Credit balance current year | ☐ | | | `CR_COR` | `int64` | Credit balance adjustments current year | ☐ | | | `DR_ACT` | `int64` | Debit balance current year | ☐ | | | `DR_COR` | `int64` | Debit balance adjustments current year | ☐ | | | `PART_CODE` | `string(10)` | Partner code | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PC_CODE` | `string(5)` | Cost type code | ☐ | | | `QTY_CY` | `decimal` | Quantity current year | ☐ | | | `QTY_PY` | `decimal` | Quantity previous year | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `TRN_PER` | `int32` | Period | ☐ | |