Cashflow Exposure

The CashflowExposure table in the Cashflow package is designed to capture and analyze the exposure of cash flows within an organization. It includes detailed records of incoming and outgoing cash flows, identifying potential risks and opportunities associated with varying cash flow scenarios. Key columns may include exposure categories, cash flow amounts, associated dates, and risk assessments, allowing for comprehensive insights into liquidity positions and financial health. This table serves as a critical tool for financial analysts and decision-makers to monitor cash flow dynamics, enhancing strategic planning and risk management efforts.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Path Params
string
required
Body Params
string
required
length between 1 and 32

CashflowTagId: A unique identifier for categorizing cash flow entries within the CashflowExposure table, represented as a string of up to 32 Unicode characters. This field is used to associate specific cash flow records with relevant tags, facilitating data organization and retrieval.

string
required
length between 1 and 256

Description: This field stores descriptive text related to cash flow exposures, allowing for a maximum length of 256 characters. It is designed to capture detailed information, comments, or notes that provide context or clarify the cash flow exposure entries, ensuring clarity and understanding in financial reporting and analysis.

string | null

The TagLevel field is a varchar data type with a maximum length of 7 characters, designed to categorize the risk or importance level of cash flow exposures. This field allows for the entry of short, alphanumeric tags that identify the severity or priority of the exposure, facilitating efficient data classification and reporting within the CashflowExposure table.

string | null

Interval (nvarchar, max length 4000): This field captures textual representations of time periods or intervals relevant to cash flow analysis. It may include various formats such as 'Q1 2023', '2023-2024', or 'Monthly from Jan to Dec', allowing for flexible entry of date ranges or specified time frames. The maximum length of 4000 characters accommodates detailed descriptions or multiple intervals as necessary.

double
required

The IntervalAmount field represents a decimal value that specifies the monetary amount associated with a specific time interval in the cash flow analysis. This field allows for precise financial calculations and is crucial for evaluating exposure over defined periods, enabling accurate forecasting and risk assessment in cash flow management.

int32

IntervalCount: An integer field that represents the number of intervals or time periods associated with cash flow exposure calculations. This field is used to quantify the granularity of the cash flow analysis, indicating how many segments of time are being considered in the financial modeling or forecasting process.

double
required

PreviousAmount: A decimal field representing the monetary value of cash flow exposure from the previous reporting period. This field captures the amount of cash flow that was recognized prior to the current period, allowing for financial analysis and comparison of cash flow changes over time.

int32

The PreviousCount field is an integer primary key in the CashflowExposure table, uniquely identifying each record. It represents the cumulative count of cash flow exposures prior to the current entry, serving as a crucial reference for tracking historical data trends and ensuring data integrity. As a primary key, PreviousCount must contain unique values, meaning no two records can have the same count, thereby facilitating efficient indexing and retrieval of cash flow exposure information.

string | null

ViewUrl: A string value that stores the URL link to the visual representation or external resource related to cash flow exposure details. This field supports Unicode characters, allowing for international URLs, and can hold a maximum length of 4,000 characters.

string | null

The 'NameHtml' field in the 'CashflowExposure' table is an nvarchar data type with a maximum length of 82 characters. It is designed to store the HTML representation of a name, allowing for the inclusion of formatted text and special characters. This field is intended to enhance the display of names in web applications, providing flexibility in styling and presentation while ensuring that the content remains within the specified character limit.

string | null

The TotalHtml field is designed to store a maximum of 4000 characters of HTML-formatted content related to cash flow exposure entries. This nvarchar field accommodates diverse formatting options, allowing for the inclusion of various HTML elements to enhance presentation and information visibility. It is intended for use in applications where a rich text format is required, enabling users to embed links, images, or other HTML components as needed.

string | null

SingleLineHtml: A field that stores HTML content as a single line of text. This field is defined as nvarchar with a maximum length of 4000 characters, allowing for the inclusion of various HTML elements and attributes while ensuring that the content remains in a single-line format for ease of processing and display within the CashflowExposure table.

string | null

ParentCashflowTagId: This field represents a unique identifier associated with the parent cash flow tag. It is of data type nvarchar, allowing for a maximum length of 32 characters. This identifier is used to link or categorize specific cash flow entries under a common parent tag, facilitating structured cash flow analysis and reporting within the CashflowExposure table.

string | null

FloatLineHtml is a field in the CashflowExposure table designed to store HTML-formatted text related to floating line items. This field is of type nvarchar with a maximum length of 4000 characters, allowing for the inclusion of rich text, links, and other HTML elements to enhance the presentation of cash flow data. It is intended for use in scenarios where dynamic or formatted content needs to be displayed, providing users with a visually appealing representation of the floating line details within the cash flow exposure context.

double | null

FloatAmount: A decimal field representing the fluctuating monetary value associated with cash flow exposure, allowing for precise financial calculations and assessments. This field captures amounts that may vary over time, facilitating effective cash management and financial analysis.

int32

MatchedCount: An integer representing the number of cash flow items that have been successfully matched or reconciled within the CashflowExposure table, reflecting the accuracy and completeness of cash flow data analysis.

int32

UnmatchedCount: An integer value representing the total number of cash flow items that do not have a corresponding match or pairing within the dataset. This field is used to track discrepancies and ensure the accuracy of cash flow records by identifying items that require further investigation or reconciliation.

double
required

MatchedAmount: A decimal value representing the monetary amount that has been matched against outstanding obligations or exposures within the cash flow analysis. This field is used to quantify the extent to which cash inflows correspond to cash outflows, aiding in the assessment of liquidity and financial risk.

double
required

UnmatchedAmount: Represents the monetary value of cash flow exposures that are not aligned or reconciled with corresponding records, indicating discrepancies in expected versus actual cash movements. This field captures the difference in amounts that require investigation or resolution to ensure accurate financial reporting and risk management.

string | null

Description: The DateLineHtml field in the CashflowExposure table is a VARCHAR data type that stores HTML-formatted strings representing date-related information. This field is designed to contain visually formatted date entries, allowing for the incorporation of HTML elements such as styling, links, or additional attributes to enhance presentation in applications displaying cash flow exposure data. The content should adhere to standard HTML conventions, ensuring it is properly rendered when displayed in web contexts.

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

Generated from available request content types

Response
200

OK

Language
URL
LoadingLoading…
Response
Click Try It! to start a request and see the response here!