CCH Tagetik · Schema

Financial Record

A financial data record returned by the CCH Tagetik OData API

AnalyticsBudgetingCorporate Performance ManagementESGFinancial CloseFinancial ConsolidationFinancial PlanningODataReporting

Properties

Name	Type	Description
Year	integer	Fiscal year (e.g., 2025)
Period	string	Reporting period code (e.g., M01, Q1, H1, YTD, FY)
Account	string	Account code from the chart of accounts
AccountDescription	string	Human-readable account name or description
Entity	string	Legal entity, business unit, or cost center code
EntityDescription	string	Human-readable entity name or description
Currency	string	ISO 4217 currency code (e.g., USD, EUR, GBP)
Amount	number	Financial amount in the group/reporting currency
AmountLC	number	Financial amount in local entity currency
Scenario	string	Data scenario classification
DataType	string	Data type or classification within the model
Flow	string	Cash flow or movement type
Interco	string	Intercompany entity code for elimination purposes
Dimension1	string	Custom dimension 1 (e.g., product, region, project)
Dimension2	string	Custom dimension 2
Dimension3	string	Custom dimension 3
ConsolidationStatus	string	Consolidation workflow status
AuditTrail	string	Audit trail or source system identifier

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://tagetik.com/schemas/financial-record",
  "title": "Financial Record",
  "description": "A financial data record returned by the CCH Tagetik OData API",
  "type": "object",
  "properties": {
    "Year": {
      "type": "integer",
      "description": "Fiscal year (e.g., 2025)"
    },
    "Period": {
      "type": "string",
      "description": "Reporting period code (e.g., M01, Q1, H1, YTD, FY)"
    },
    "Account": {
      "type": "string",
      "description": "Account code from the chart of accounts"
    },
    "AccountDescription": {
      "type": "string",
      "description": "Human-readable account name or description"
    },
    "Entity": {
      "type": "string",
      "description": "Legal entity, business unit, or cost center code"
    },
    "EntityDescription": {
      "type": "string",
      "description": "Human-readable entity name or description"
    },
    "Currency": {
      "type": "string",
      "minLength": 3,
      "maxLength": 3,
      "description": "ISO 4217 currency code (e.g., USD, EUR, GBP)"
    },
    "Amount": {
      "type": "number",
      "description": "Financial amount in the group/reporting currency"
    },
    "AmountLC": {
      "type": "number",
      "description": "Financial amount in local entity currency"
    },
    "Scenario": {
      "type": "string",
      "enum": ["Actual", "Budget", "Forecast", "Reforecast"],
      "description": "Data scenario classification"
    },
    "DataType": {
      "type": "string",
      "description": "Data type or classification within the model"
    },
    "Flow": {
      "type": "string",
      "description": "Cash flow or movement type"
    },
    "Interco": {
      "type": "string",
      "description": "Intercompany entity code for elimination purposes"
    },
    "Dimension1": {
      "type": "string",
      "description": "Custom dimension 1 (e.g., product, region, project)"
    },
    "Dimension2": {
      "type": "string",
      "description": "Custom dimension 2"
    },
    "Dimension3": {
      "type": "string",
      "description": "Custom dimension 3"
    },
    "ConsolidationStatus": {
      "type": "string",
      "description": "Consolidation workflow status"
    },
    "AuditTrail": {
      "type": "string",
      "description": "Audit trail or source system identifier"
    }
  },
  "required": ["Year", "Account", "Entity", "Amount"]
}