Finance Dimension 12 Dim

Created by Robert Cross, Modified on Wed, 9 Jul, 2025 at 7:52 AM by Robert Cross

Finance Dimension 12 Dim

This dimension captures detailed financial classification data that supports company-wide reporting and analytics within the Infor Birst Data Warehouse. It includes key financial dimension identifiers, descriptive labels, hierarchical level, timestamps for data currency, and deletion flags to ensure data integrity and relevance.

Output Column	Database Logic	Description
Finance Dimension 12 Key	Unique identifier key for the Finance Dimension 12 record	This is the unique key that identifies each specific financial classification within Finance Dimension 12, enabling accurate tracking and referencing across financial reports.
Company	Company code associated with the Finance Dimension record	Indicates the company to which the financial classification belongs, allowing differentiation and analysis by legal or operational entities.
Finance Dimension 12	Code representing the specific financial segment in Finance Dimension 12	Represents the code or identifier for the particular financial segment captured in this dimension, facilitating segmented financial reporting.
Finance Dimension 12 Description	Textual description of the Finance Dimension 12 segment	Provides a clear, readable description of what the financial segment represents for ease of understanding by business users.
Level	Hierarchy level within the Finance Dimension	Shows the depth or tier level within the financial classification hierarchy, helping to understand its level of aggregation or detail.
Last Modified Datetime	Timestamp of the most recent update to the Finance Dimension record	Reflects the last date and time when the financial dimension information was updated, ensuring the currency of the data.
Deleted	Flag indicating if the record has been marked as deleted	Shows whether the financial dimension record is currently active or marked for deletion, which impacts the data's usage in reporting.