Cashflow Exposure Summaries

patch

https://app.financekey.com/OData/CashflowExposureSummaries({key})

The CashflowExposureSummary table provides a comprehensive overview of cash flow exposures across various dimensions within the Cashflow package. It aggregates and summarizes financial data related to incoming and outgoing cash flows, highlighting key metrics such as net cash flow, exposure variance, and historical trends. This table enables users to assess liquidity risks, identify potential cash shortfalls or surpluses, and make informed financial decisions based on cash flow projections. Its structured format allows for quick insights into cash management performance, facilitating effective monitoring and strategic planning.

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Path Params

key

string

required

Body Params

cashflowExposureSummaryId

int32

This field, CashflowExposureSummaryId, is an identity integer that uniquely identifies each record in the CashflowExposureSummary table. It serves as the primary key, providing a distinct reference for cash flow exposure summaries, facilitating efficient data retrieval and management within the database.

cashflowTagId

string

required

length between 1 and 32

CashflowTagId: A unique identifier for categorizing or tagging cash flow entries, represented as a variable character string (nvarchar) with a maximum length of 32 characters. This field facilitates the organization and filtering of cash flow data by specific tags, enabling enhanced reporting and analysis within the CashflowExposureSummary table.

amount

double

required

The 'Amount' field in the 'CashflowExposureSummary' table represents the financial value associated with cash flow exposures. This field is stored as a decimal data type to accurately capture and display monetary amounts, allowing for precise financial analysis and reporting. The values in this field can include both positive and negative figures, reflecting inflows and outflows relevant to cash flow assessments.

tagLevel

int32

The TagLevel field stores an integer value representing the hierarchical level of tags associated with cash flow exposures. This field is used to categorize and prioritize cash flow items based on their significance or relevance within the overall cash flow analysis.

cashflowCount

int32

CashflowCount: An integer value representing the total number of cash flow entries associated with the financial exposure summary, used to quantify and track the frequency of cash flow transactions within the dataset.

priorAmount

double

required

The PriorAmount field represents the amount of cash flow exposure recorded prior to the current reporting period. It is stored as a decimal to accommodate precise monetary values, allowing for accurate financial analysis and reporting. This field is essential for tracking historical cash flow data and understanding trends in cash flow management.

priorCashflowCount

int32

PriorCashflowCount: An integer that represents the total number of cash flows recorded prior to the current assessment period within the Cashflow Exposure Summary. This field is used to provide insight into historical cash flow activity and trends for analytical and reporting purposes.

interval

string | null

The 'Interval' field in the 'CashflowExposureSummary' table is designed to store time intervals represented as strings, with a maximum length of 16 characters. This field allows for the input of various time periods, such as 'Daily', 'Weekly', 'Monthly', or custom intervals in a human-readable format, facilitating flexible reporting and data analysis related to cash flow exposures over specified durations.

tagList

string | null

The TagList field in the CashflowExposureSummary table is an nvarchar data type designed to store a list of tags associated with cash flow exposures. It has a maximum length of 450 characters, allowing for the inclusion of multiple tags or keywords that provide context or categorization for the related cash flow entries. This field enables enhanced data organization and searchability, facilitating better analysis and reporting of cash flow performance.

openingBalanceAmount

double | null

The OpeningBalanceAmount field in the CashflowExposureSummary table represents the initial balance of cash or cash equivalents at the start of a specified period. This value is stored as a decimal to allow for precision in financial calculations and reflects the total amount available for cash flow activities before any transactions are processed within that period.

start

date-time | null

The 'Start' field in the table 'CashflowExposureSummary' represents the initial date and time marking the beginning of a specific cash flow exposure period. It is stored as a datetime2 data type, allowing for high precision in capturing both date and time values. This field is crucial for tracking when cash flow events commence and is essential for accurate financial analysis and reporting within the cash flow exposure summary.

end

date-time | null

The 'End of Data' field, of type datetime2, in the CashflowExposureSummary table represents the specific date and time at which the cash flow exposure data is deemed to be complete or finalized. This timestamp indicates the cutoff point for the recorded cash flows, marking the end of the analysis period for the associated financial data. It ensures accurate historical tracking and reporting of cash flow exposures over time.

parentCashflowTagId

string | null

ParentCashflowTagId: A string identifier (nvarchar, maximum length of 32 characters) used to associate and categorize cash flow entries with their respective parent tags, facilitating the organization and retrieval of related cash flow data within the CashflowExposureSummary table.

floatAmount

double | null

FloatAmount: This field represents the monetary value associated with float activities within the cash flow exposure summary. It is stored as a decimal to ensure precision in financial calculations, allowing for the accurate representation of amounts that may include cents.

matchedAmount

double

required

MatchedAmount: A decimal value representing the amount of cash flow that has been matched to specific exposures within the cash flow summary, indicating the degree to which cash inflows and outflows align with projected financial positions.

matchedCount

int32

MatchedCount: An integer field that represents the number of cash flow records that have been successfully matched against predetermined criteria or benchmarks within the CashflowExposureSummary table. This count aids in assessing the alignment of cash flow items with expected financial patterns or risk assessments.

unmatchedAmount

double

required

UnmatchedAmount: This field represents the total monetary value of cash flows that have not been reconciled or matched against corresponding entries, allowing for the identification of discrepancies and the management of financial exposure within the cash flow analysis. The data type is decimal to ensure precision in recording and processing financial figures.

unmatchedCount

int32

UnmatchedCount: An integer value representing the total number of cash flow records that do not have a corresponding match in associated datasets, indicating discrepancies or pending reconciliations within the cash flow exposures summarized in this table.

closingBalanceAmount

double | null

ClosingBalanceAmount: A decimal field representing the final balance of cash flows at the end of a specified period. This value reflects the total cash remaining after all inflows and outflows have been accounted for, providing insight into the overall liquidity position of the entity for the period summarized in the CashflowExposureSummary table.

Headers

content-type

string

enum

Defaults to application/json;odata.metadata=minimal;odata.streaming=true

Generated from available request content types

Response

200

Language

URL

Loading…

Response

Click Try It! to start a request and see the response here!