Financial Transactions - Intelligence Output Fields

Each row of the Financial Transactions - Intelligence dataset represents a single source record. For your financial data that comes from Accounting directly or through Financial Analytics, the source record is a transaction line item or a bank reconciliation. For your subscription billing data that comes from Billing Central, the source record is a billing schedule.

Note:

Billing Central data is only available if you have Billing Central installed.

This dataset contains the same fields as the Financial Transactions dataset. For more information about all the output fields available in the Financial Transactions dataset, see Financial Transactions Flow Input Fields.

This dataset also contains the fields described in the following table, grouped by their type within Analytics.

Key: H - Hidden field; BC - Field only available if Billing Central is installed.

Dataset Fields
Field Type Field Label Field API Name   Description
Measure Bank Reconciliation Closing Balance BankReconciliationClosingBalance   The closing balance, as shown in the bank statement related to the bank reconciliation.
Bank Reconciliation Opening Balance BankReconciliationOpeningBalance   The opening balance, as shown in the bank statement related to the bank reconciliation. This value is taken from the previous reconciliation's closing balance.
Days to Pay after Improvement DaysToPayAfterImprovement   Estimated Days to Pay after performing the action suggested to improve the Days to Pay prediction outcome.
Dual Outstanding Value ValueDualOutstanding  

The outstanding amount of the source record in the dual currency. This is set to:

  • Zero for billing schedules
  • Dual Outstanding Value for transaction line items
Home Outstanding Value ValueHomeOutstanding  

The outstanding amount in the home currency of the source record. This is set to:

  • Value for billing schedules
  • Home Outstanding Value for transaction line items
Predicted Days to Pay

PredictedDaysToPay

  

The estimated number of days the customer takes to pay each transaction line item of sales and payable documents.
Dimension Account ID AccountId  

The ID of the account record that relates to the source object. This is set to:

  • Account for billing schedules
  • Account ID for transaction line items
Actionable Field Name ActionableFieldName   The field selected as an actionable variable when you deploy your Einstein Discovery model.
Actionable Field Value ActionableFieldValue   The value of the actionable field suggested to improve the outcome for Days to Pay.
Bank Account Currency Name CurrencyBankAccount   The name of the currency that relates to the bank account.
Bank Account Name BankAccountName   The name of the bank account that relates to the bank reconciliation.
Bank Reconciliation ID BankReconciliationId   The ID of the bank reconciliation.
Bank Reconciliation Reference BankReconciliationReference   The name of the bank reconciliation that relates to the transaction.
Billing Contract ID BillingContractId BC

The ID of the billing contract record that relates to the billing schedule.
Billing Contract Line Item Number BillingContractLineItemNumber BC The number of the billing contract line item record that relates to the billing record associated with the billing schedule.
Billing Contract Name BillingContractName BC The name of the billing contract that relates to the billing schedule.
Billing Contract Number BillingContractNumber BC The number of the billing contract that relates to the billing schedule.
Billing Schedule Name BillingScheduleName BC The name of the billing schedule.
Company ID CompanyId  

The ID of the company record that relates to the source record. This is set to:

  • Company for bank reconciliations
  • Accounting Company for billing schedules
  • Company ID for transaction line items
Company Name CompanyName  

The name of the company that relates to the source record. This is set to:

  • Name for bank reconciliations
  • Company Name for billing schedules
  • Company Name for transaction line items
Home Currency CurrencyHome  

The ISO code of the accounting currency related to the source record. This is set to:

  • Currency ISO Code for billing schedules
  • Home Currency for transaction line items
Line Type LineType  

Type of the source record. If the source record is a billing schedule, the value is "Billing Schedule". If the source record is a transaction line item the possible values are:

  • "Account"
  • "Analysis"
  • "Tax"
Note:

The "Billing Schedule" value is only available if you have Billing Central installed.
Record ID RecordId  

The ID of the source record that the dataset row relates to. This is set to:

  • Record ID for billing schedules
  • Record ID for transaction line items
Transaction Type TransactionType  

Type of the source record. If the source record is a billing schedule, the value is "Billing Schedule". If the source record is a transaction line item, the possible values are:

  • "Cash"
  • "Invoice"
  • "Journal"
  • "Purchase Invoice"
Note:

The "Billing Schedule" value is only available if you have Billing Central installed.
User UserCompanySecurity.c2g__User_c H Related to the security predicate implementation.
Date Bank Statement Date BankStatementDate   The date of the bank statement related to the bank reconciliation.
Due Date DueDate  

When the source record is a transaction line item, this is the date when the transaction line item is due. When the source record is a billing document, this is the date when the billing document is due to be created. This is set to:

  • Billing Date for billing schedules
  • Due Date for transaction line items
Predicted Payment Date PredictedPaymentDate  

The estimated payment date for each transaction line item of sales and payable documents.
Note:

By default, the Financial Transactions - Intelligence dataset has a security predicate which ensures that users can only view data for the Accounting companies that they have access to. You must ensure that each user of the dashboards that use the dataset has the appropriate user company records defined for them in Accounting and Billing Central. Alternatively, you can remove the security predicate for the dataset.