# CRS_TRLB: Reporting - Name: `CRS_TRLB` - Catalog: `AccountView` - Label: Reporting - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `CRS_TRLB` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_NR` | `string(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` | `string(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` | `string(10)` | Cost centre code | ☐ | | | `DIM_KEY` | `string(100)` | Dimension key | ☐ | | | `DSP_FMT` | `string(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` | `boolean` | Bold line | ☐ | | | `LINE_DESC` | `string(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` | `string(10)` | Partner | ☐ | | | `PAGE_BREAK` | `boolean` | Page break | ☐ | | | `PARENT_ID` | `string(10)` | Parent element | ☐ | | | `PART_RNG` | `string(20)` | Partner as dimension | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PC_CODE` | `string(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` | `string(10)` | Project code | ☐ | | | `QTR_PER` | `int32` | Quarters | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `REC_KEY` | `string(20)` | Source key | ☐ | | | `RNG_CODE` | `string(10)` | Partner administration | ☐ | | | `RST_BAN_CY` | `int64` | Remaining budget CY | ☐ | | | `RST_BQN_CY` | `decimal` | Remaining budget CY qty | ☐ | | | `SHOW_ICON` | `int32` | Icon | ☐ | | | `SHOW_LINE` | `boolean` | Show total line | ☐ | | | `SHOW_REC` | `boolean` | Show line | ☐ | | | `TAX_ID` | `string(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 % | ☐ | |