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.

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

The columns in the "Customer Account - Stocks" table

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

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

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

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

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

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

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

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

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

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

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