Cash flow dimensions

CFDCASHFLOW

This dimension includes the user-defined cash flow accounts that are used by each customer individually.

CFDCONFIG_CASHFLOW

This dimension includes the cash flow configuration elements, TYPE and WEIGHT.

The dimension contains this structure:

  • TYPE: There are four cash flow account types that are used to categorize cash flow positions and to assign cash flow accounts in Budgeting & Planning. The first three cash flow account types are automatically calculated:
    • Schedule Detail: The calculation for a specific cash flow account is based on a combination of balance sheet account and schedule detail. The value that is written back to the database for this cash flow account type is 1.
    • Closing Balance: One or more balance sheet and profit & loss accounts are stated. The calculation looks up the individual accounts and writes back the closing balance of all accounts to the cash flow position. The value that is written back to the database for this cash flow account type is 2.
    • Change Previous Year: One or more balance sheet and/or profit & loss accounts are chosen to calculate the cash flow position. Only the difference to last year is transferred to the cash flow cube. The value that is written back to the database for this cash flow account type is 3.
    • Manual: The value that is written back to the database for this cash flow account type is 4.
  • WEIGHT (1 or -1): This element is used to increase or decrease the cash flow.