Functions on accounts
Account.AllPersonLinks[Level only]→List(person link)
OnlyLevel (Boolean[False]): If this parameter is "True", only the links at the "Account" level are delivered.
Result: The function AllPersonLinks function returns all person links of the account (across all times). The function therefore returns the currently valid personal links of the account, but also the personal links that were previously valid and, if applicable, those that are not yet valid (contracts that have been concluded but are not yet running).
"Infront Advisory Solution consulting process" module or "People management" module
Account.createdOn→Date
Result: The CreatedOn function returns the investment date according to the account master data ("Created on" field).
Account.exclusionTax→Boolean
Result: The ExcludeTax function returns "True" if the account is to be excluded from the tax calculation. In combination with the "Tax exclusion" parameter of the DepotErtrag function, the accounts and securities accounts marked in this way are ignored in the DepotErtrag function.
Account.bank→Bank
Result: The Bank function returns the bank assigned to the account in the account properties.
Account.bankAddress→Address
Result: The BankAddress function returns the address of the bank.
Account.remark→String
Result: The Comment function provides the comment for the account.
Account.name→String
Result: The Name function returns the name of the account.
Account.BIC→String
Result: The BIC function returns the BIC (Business or Bank Identifier Code) of the bank.
Account.BookEntries[From;To;Canceled]→List(Transaction)
From (date [current date]).
To (date [current date minus 30 days]).
Canceled (Boolean[False]).
Result: The BookEntries function provides the list of all transactions (BookEntries) in the account between "From" and "To".
Account.DeactivatedOn→Date
Result: The DeactivatedOn function provides the date from which the account is considered deactivated and is hidden in the Explorer.
Account.deposit→List(deposit)
Result: The Securities account function provides a list of all securities accounts to which the account is assigned as a reference account.
Account.fixed-term deposit[date;currency]→number
Date (Date[Current date]).
Currency (Currency [account currency]).
Result: n/a. The fixed-term deposit function is obsolete, as fixed-term deposits are treated as part of special investments.
Account.branch.number→String
Result: The Branch number function returns the alphanumeric branch number of the bank branch.
Account.IBAN→String
Result: The IBAN function provides the IBAN (International Bank Account Number) of the bank.
Account.identifier→String
Result: The Identifier function provides a character string for external identification of the account consisting of account number, bank code and currency.
Account.holder→holder
Result: The Owner function returns the owner of the account.
Account.IsDeactivatedAt[Date]→Boolean
Date (date).
Result: The IsDeactivatedAt function checks whether the account is considered closed at<date>.
Account.actualDaily allowance→Boolean
Result: The Actual call money function returns "True" if it is a call money account according to the master data.
Account→Account
Result: The Account function returns the account itself.
Account.account_bank→String
Result: The Konto_Bank function returns the name of the bank.
Account.account_BLZ→String
Result: The Konto_BLZ function returns the bank sort code.
Account.accountForeignCurrency[currency;evaluation date]→number
Currency (Currency).
Evaluation date (date).
Result: The AccountForeignExchangeRate function returns the foreign exchange rate on the account on the specified date.
Account.accountForeign exchange gain[currency;start date;evaluation date]→number
Currency (Currency).
Start date (date [start of year]).
Evaluation date (Date [Current date]).
Result: The Account foreign exchange gain function returns the foreign exchange gain of an account on the <evaluation date> compared to the <start date>.
Account.accountCurrency_gain_realized[currency;start date;evaluation date]→number
Result: The function KontoDevisengewinn_Realisiert returns the realized foreign exchange gain within the specified time period on the account.
Account.account_foreign_exchange_gain_unrealized[currency;evaluation date]→number
Result: The AccountForeignExchangeGain_Unrealized function returns the unrealized foreign exchange gain on the specified date on the account.
Account.account.number→String
Result: The Account number function returns the alphanumeric account number (external key).
Account.account.accrued.interest[currency;evaluation.date]→number
Currency (Currency [account currency]).
Evaluation date (Date [Current date]).
Result: The Accrued interest on account function returns the accrued interest on an account on the <evaluation date> in<currency>.
Account.name→String
Result: The Name function returns the name of the account.
Account.PersonLinks[Date;Level only]→List(person links)
Date (Date[Current date]).
OnlyLevel (Boolean[False]): If this parameter is "True", only the links at the "Account" level are delivered.
Result: The function PersonLinks function returns the list of all person links of the account for<date>.
"Infront Advisory Solution consulting process" module or "People management" module
Account.portfolio→Portfolio
Result: The Portfolio function returns the portfolio to which the account is assigned.
Account.balance[date;value date]→number
Date (Date[Current date]),
Value date (Boolean[False]).
Result: The Balance function returns the account balance for the date in account currency.
Account.TransactionList[From;To;Canceled;ToCombinedLevel]→List(Transaction)
From (date [beginning of year]).
Until (date [current date]).
Canceled (Boolean[False]).
OnCombiLevel (Boolean[False]).
Result: If the parameter "ToCombiLevel" = "False", then the TransactionList function returns all base transactions; otherwise it also returns all combined transactions for this account between "From" and "To". If the parameter "Canceled" = "True", then the canceled transactions are also included.
Account.VerificationDate→Date
Result: The VerificationDate function returns the date of the last change to the data status of the account.
Account.VerificationDate_SpecialAssets→Date
Result: The VerificationDate_SpecialAssets function returns the date of the last change to the data status of the special assets.
Account.VerificationStatus→VerificationStatus
Result: The VerificationStatus function returns the data status (verification status) stored in the account properties.
Account.VerificationStatus_SpecialAssets→VerificationStatus
Result: The VerificationStatus_SpecialAssets function returns the data status (verification status) stored in the account properties for the special assets.
Account.currency→Currency
Result: The Currency function returns the currency in which the account is managed.
Account.interest[date]→number
Date (Date[Current date]).
Result: The Interest function returns the interest rate for the specified date from the interest history created for the account.
Account.interesthistory→History
Result: The Interest history function provides the interest history of the account.
Account.interest.method→Period.formula.type
Result: The Interest method function provides the interest calculation method used to determine the interest on the account.
