Skip to main content
Skip table of contents

Dashboard templates in the Infront Portfolio Manager

Dashboard templates are templates that cannot be edited by the "Infront Portfolio Manager" user, as they can only be uploaded unchanged to . Dashboard templates (template category "Customer Account") are grayed out in the list of templates. These templates can be opened in the Infront Portfolio Manager, but cannot be changed or saved. If necessary, use the "Save as..." command to create your own tables based on these templates.

In the Infront Portfolio Manager you will find the following tabular dashboard evaluations:

  • Customer Account - Assets

    Columns/data in the "Customer Account - Assets" table

    • Keycloak_UUIDS
    • Type
    • Name
    • Number
    • ReferenceNumber
    • Currency
    • Risk_Limit
    • IBAN
    • Custodian Name
    • BIC
    • Bank_Sort_Code
    • Branch
  • Customer Account - Stocks

    The columns in the "Customer Account - Stocks" table

    • ACCOUNT_NUMBER
    • ACCRUED_INTEREST
    • ANALYSIS_CURRENCY
    • ANALYSIS_EXCHANGE_RATE
    • ANALYSIS_EXCHANGE_RATE_FROM_CURRENCY
    • ANALYSIS_EXCHANGE_RATE_TO_CURRENCY
    • CASHACCOUNT_IBAN
    • CASHACCOUNT_REFERENCE_ID
    • CUSDOTIAN_BIC
    • DISPLAY_NAME
    • EARNINGS
    • EXTERNAL_ID
    • EXTERNAL_REFERENCE
    • EXTERNAL_REFERENCE_SOURCE
    • INSTRUMENT_REFERENCE_ID
    • INTERIM_PROFIT
    • INVESTMENT_CURRENCY
    • MARKET_VALUE_IN_ANALYSIS_CURRENCY
    • MARKET_VALUE_IN_INVESTMENT_CURRENCY
    • PORTFOLIO_NUMBER
    • PORTFOLIO_REFERENCE_ID
    • POSITION_TYPE
    • PURCHASE_EXCHANGE_RATE
    • PURCHASE_EXCHANGE_RATE_FROM_CURRENCY
    • PURCHASE_EXCHANGE_RATE_TO_CURRENCY
    • PURCHASE_PRICE_AMOUNT
    • PURCHASE_PRICE_DATE
    • PURCHASE_PRICE_TYPE
    • PURCHASE_VALUE_IN_ANALYSIS_CURRENCY
    • PURCHASE_VALUE_IN_INVESTMENT_CURRENCY
    • QUANTITY_AMOUNT
    • QUANTITY_TYPE
    • SECACCOUNT_REFERENCE_ID
    • SECURITY_IDENTIFIER_DEWKN
    • SECURITY_IDENTIFIER_ISIN
    • SECURITY_IDENTIFIER_VALOR
    • UNREALIZED_CURRENCY_PROFIT
    • UNREALIZED_PRICE_PROFIT
    • UNREALIZED_PROFIT
    • UNREALIZED_PROFIT_PERCENTAGE
    • VALUATION_PRICE_AMOUNT
    • VALUATION_PRICE_DATE
    • VALUATION_PRICE_TYPE
    • VALUE_SHARE_PERCENTAGE


  • Customer Account - Cash flow forecast

    Columns/data in the "Customer Account - Cash Flow Forecast" table

    • External_Identifier
    • Position_Identifier
    • Cashflow_Date
    • Cashflow_Type
    • Portfolio_ID
    • Position_Name
    • Gross_Cashflow_In_Position_Currency
    • Cashflow_Currency
    • Gross_Cashflow_Of_The_Transaction_In_Portfolio_Currency
    • Portfolio_Currency
  • Customer Account - Income statement

    Columns/data in the "Customer Account - Income Statement" table

    • ID
    • Transaction_ID
    • Position_Name
    • Position_Identifier
    • Posting_Date
    • Value_Date
    • Transaction_Date
    • Income
    • Taxable_Income
    • Deductible_Withholding_Tax
    • Refundable_Withholding_Tax
    • Notional_Withholding_Tax
    • Investment_Income_Tax
    • Solidarity_Surcharge
    • Church_Tax
    • Church_Tax_Spouse
    • Anticipatory_Tax
    • Stamp_Duty
    • French_Transaction_Tax
    • Italian_Transaction_Tax
    • Valuation_Exchange_Rate
    • Valuation_Currency
    • Securities_Account_Number
    • Securities_Account_BIC
    • Cash_Account_Number
    • Cash_Account_BIC
    • Portfolio_ID
  • Customer Account - Revenue

    Columns/data in the "Customer Account - Income" table

    • Portfolio_Number
    • Keycloak_UUIDS
    • /* MMASCII v1.5 seq=true */
    • 2 - WP reference
    • 3 - ExDate
    • 4 - Coupon type
    • 5 - Cash flow
    • 6 - Nominal value
    • 7 - Course
    • 8 - KOSt
    • 9 - Capital gains tax
    • 10 - ZASt
    • 11 - SolZ
    • 12 - Withholding tax anr+erst
    • 13 - Withholding tax only
    • 14 - Coupon date
    • 15 - Currency
    • 16 - Exchange rate
    • 17 - Expenses
    • 18 - External expenses
    • 19 - Fees
    • 20 - Remark
    • 21 - Account reference
    • 22 - Transaction number
    • 23 - Cancellation
    • 24 - Dividend share
    • 25 - Account currency
    • 26 - AccountBLZ
    • 27 - Fictitious withholding tax
    • 28 - Tax-free amount
    • 29 - Accumulation
    • 30 - Cost value correction
    • 31 - Value date
    • 32 - WP Reference type
    • 33 - Depot BLZ
    • 34 - Tax currency
    • 35 - Tax exchange rate
    • 36 - KiSt
    • 37 - KiSt spouse
    • 38 - Assessment basis
    • 39 - Depot BIC
    • 40 - Depot branch number
    • 41 - Account BIC
    • 42 - Account IBAN
    • 43 - Account branch number
    • 44 - Index ratio
    • End
  • Customer Account - ESG

    Columns/data in the "Customer Account - ESG" table

    • Instrument_Identifier_Type
    • Instrument_Identifier
    • Category_Name
    • Date
    • ESG_Data_Provider
  • Customer Account - Money market instruments

    Columns/data in the "Customer Account - Money Market Instruments" table

    • ASSET_CLASS
    • BONUS_LEVEL_AMOUNT
    • BONUS_LEVEL_CURRENCY
    • CAP_AMOUNT
    • CAP_CURRENCY
    • CFI_TYPE
    • CONTRACT_AMOUNT
    • CONTRACT_AMOUNT_CURRENCY
    • EXERCISE_RATIO
    • EXERCISE_TYPE
    • EXTERNAL_REFERENCE
    • EXTERNAL_REFERENCE_SOURCE
    • FUND_ACCUMULATION
    • FX_INFLOW_AMOUNT
    • FX_INFLOW_CURRENCY
    • FX_OUTFLOW_AMOUNT
    • FX_OUTFLOW_CURRENCY
    • INTEREST
    • INTEREST_CALCULATION_METHOD
    • ISIN
    • LAST_TRADING_DAY
    • MATURITY
    • MM_SECURITY_ID
    • NAME
    • NEW_SHARES
    • OPTION_TYPE
    • PAYMENT_DATE
    • REGION
    • RISK_CLASS
    • SECTOR
    • STRIKE_AMOUNT
    • STRIKE_CURRENCY
    • TYPE
    • VALOR
    • WKN
  • Customer Account - Profits and losses

    Columns/data in the "Customer Account - Profits and Losses" table

    • ID
    • Transaction_ID
    • Posting_Date
    • Value_Date
    • Portfolio_ID
    • Securities_Account_Number
    • Security_Account_BIC
    • Cash_Account_Number
    • Cash_Account_BIC
    • Position_Name
    • Position_Identifier
    • Transaction_Type
    • Gross_Amount_In_Trading_Currency
    • Trading_Currency
    • Trading_Exchange_Rate
    • Gross_Amount_In_Valuation_Currency
    • Valuation_Currency
    • Cash_Flow_In_Valuation_Currency
    • Cash_Flow_In_Cash_Account_Currency
    • Cash_Account_Currency
    • Cash_Account_Exchange_Rate
    • Purchase_Price
    • Purchase_Currency
    • Sales_Price
    • Sales_Currency
    • Realized_Profits_And_Losses_In_Purchase_Currency
    • Realized_Profits_And_Losses_In_Valuation_Currency
    • Total_Fees_In_Valuation_Currency
    • Total_Taxes_Paid_In_Valuation_Currency
  • Customer Account - Instruments

    Columns/data in the "Customer Account - Instruments" table

    • Name
    • ISIN
    • WKN
    • Valor
    • MM_Security_ID
    • Type
    • CFI_Type
    • Region
    • Sector
    • Maturity
    • Asset_Class
    • Interest
    • Strike_Amount
    • Strike_Currency
    • Bonus_Level_Amount
    • Bonus_Level_Currency
    • Cap_Amount
    • Cap_Currency
    • Option_Type
    • Exercise_Type
    • Exercise_Ratio
    • New_Shares
    • Fund_Accumulation
    • Payment_Date
    • Last_Trading_Day
    • Risk_Class
  • Customer Account - Account postings

    Columns/data in the "Customer Account - Account postings" table

    • Portfolio_Number
    • Keycloak_UUIDS
    • /* MMASCII v1.5 seq=true */
    • 2 - Booking type
    • 3 - Amount
    • 4 - Value date
    • 5 - Booking date
    • 6 - Booking time
    • 7 - Currency
    • 8 - Exchange rate
    • 9 - ZASt
    • 10 - SolZ
    • 11 - Remark
    • 12 - Transaction no
    • 13 - Cancellation
    • 14 - Account currency
    • 15 - Account BLZ
    • 16 - Due date
    • 17 - Interest rate
    • 18 - Interest rate type
    • 19 - Advance warning days
    • 20 - Target account number
    • 21 - Reference number
    • 22 - Capital gains tax
    • 23 - Withholding tax anr+erst
    • 24 - Withholding tax only
    • 25 - Assessment basis
    • 26 - Tax currency
    • 27 - Tax exchange rate
    • 28 - KiSt
    • 29 - KiStPartner
    • 30 - Fictitious withholding tax
    • 31 - Account BIC
    • 32 - Account IBAN
    • 33 - Account branch number
    • 34 - VAT
    • End
  • Customer Account - Performance

    Columns/data in the "Customer Account - Performance" table

    • Date
    • Keycloak_UUIDS
    • Portfolio_Number
    • Performance
    • Currency
    • Performance_Perc
    • Taxespaid
    • Deliveries
    • Deposits
  • Customer Account - Risk

    Columns/data in the "Customer Account - Risk" table

    • Portfolio

    • Date
    • Portfolio_Currency
    • Volatility
    • Maximum_Drawdown_In_Percent
    • Value_At_Risk_In_Portfolio_Currency
    • Value_At_Risk_In_Percent
  • Customer Account - Securities transactions

    Columns/data in the "Customer Account - Securities Transactions" table

    • Portfolio_Number
    • Keycloak_UUIDS
    • /* MMASCII v1.5 seq=true */
    • 2 - Securities reference
    • 3 - Order date

    • 4 - Order type
    • 5 - Cash flow
    • 6 - Nominal value
    • 7 - Course
    • 8 - Account reference
    • 9 - Value date
    • 10 - Order time
    • 11 - Trading currency
    • 12 - Exchange rate
    • 13 - Brokerage fee
    • 14 - Expenses
    • 15 - External expenses
    • 16 - Fees
    • 17 - Remark
    • 18 - Interim profit
    • 19 - ZASt
    • 20 - SolZ
    • 21 - Transaction number
    • 22 - WP reference 2
    • 23 - Nominal value 2
    • 24 - Cancellation
    • 25 - Accrued interest
    • 26 - Security name
    • 27 - Bonus
    • 28 - Account currency
    • 29 - BLZ
    • 30 - Historical course
    • 31 - Historical date
    • 32 - Historical exchange rate
    • 33 - Historic interim profit
    • 34 - Logic reversal
    • 35 - F&O Basic WP reference
    • 36 - Basic type option
    • 37 - Option type
    • 38 - F&O term
    • 39 - Future short/long
    • 40 - Security type
    • 41 - Listing
    • 42 - WP reference type
    • 43 - WKN
    • 44 - ISIN
    • 45 - Security number
    • 46 - Depot BLZ
    • 47 - Bearing position abbreviation
    • 48 - Bearing point designation
    • 49 - Car bookings
    • 50 - Order reference
    • 51 - Future Opening Course
    • 52 - Pool factor
    • 53 - Lock
    • 54 - VAT
    • 55 - Withholding tax
    • 56 - Trading center
    • 57 - BID
    • 58 - Issue premium
    • 59 - Reimbursement
    • 60 - KeSt
    • 61 - Exogen
    • 62 - Order book number
    • 63 - Trading center type
    • 64 - Assessment basis
    • 65 - Tax currency
    • 66 - Tax exchange rate
    • 67 - KiSt
    • 68 - KiSt spouse
    • 69 - Withholding tax refundable
    • 70 - Fictitious withholding tax
    • 71 - Profit subject to tax
    • 72 - Stamp duty
    • 73 - FOBasisWPRefType
    • 74 - Depot BIC
    • 75 - Depot branch number
    • 76 - Account BIC
    • 77 - Account branch number
    • 78 - Account IBAN
    • 79 - Index ratio
    • 80 - Fee currency
    • 81 - Block order number
    • 82 - Type of corporate action
    • 83 - WPRef Old genus
    • END

In the individual person properties, you define for which persons the upload of templates for is permitted. Please also read the section Personal characteristics.

In addition to the tables listed above, monitoring templates are also available. Use this to check your data before uploading:

  • Monitoring customer account persons
    With this evaluation, you always have an overview of the current status of the linked persons.
  • Monitoring customer account IDs
    Use this table to check that all objects are assigned unique IDs.
  • Monitoring customer account assets
    This table allows you to check the master data of the securities account assets for completeness and correctness before each upload.


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.