Financial Transactions - Intelligence Input Fields

This dataset uses the following as input data:

  • Financial Matching dataset
  • Financial Transactions dataset
  • Prediction definition
  • Accounting Company object
  • Accounting Accounting Currency object
  • Accounting Bank Account object
  • Accounting Bank Reconciliation object

For more information about all the input fields available in the Financial Transactions dataset, see Financial Transactions Flow Input Fields.

Accounting Company

The Intelligence Analytics recipe imports the Accounting Accounting Company object.

Fields Retrieved from the Accounting Currency Object

Field Label

Field API Name

Description
Company c2g__OwnerCompany__c We use this field to populate the Company ID field in the resulting dataset.

Accounting Currency

The Intelligence Analytics recipe imports the Accounting Accounting Currency object.

Field Retrieved from the Accounting Currency Object

Field Label

Field API Name

Description
Bank Account Currency Name c2g__BankAccountCurrency__c We use this field to populate the Bank Account Currency Name field in the resulting dataset.

Bank Account

The Intelligence Analytics recipe imports the Accounting Bank Account object.

Field Retrieved from the Bank Account Object

Field Label

Field API Name

Description
Bank Account Name BankAccount.Name We use this field to populate the Bank Account Name field in the resulting dataset.

Bank Reconciliation

Fields Retrieved from the Bank Reconciliation Object

Field Label

Field API Name

Description
Bank Account c2g__BankAccount_c We use this field to link the bank reconciliation to the related bank account. We also use this field to populate the Bank Account Name in the resulting dataset.
Bank Reconciliation Reference Name We use this field to populate the Bank Reconciliation Reference field in the resulting dataset.
Closing Balance c2g__ClosingBalance__c

We use this field to populate the Bank Reconciliation Closing Balance field in the resulting dataset.
Company c2g__OwnerCompany__c We use this field to populate the Company ID field in the resulting dataset.
Opening Balance c2g__OpeningBalance__c

We use this field along with the Payments This Period/Quarter and Collections This Period/Quarter KPIs values to calculate the value of the Estimated Closing Balance KPI on the Summary chart of the Cash Flow Forecast - Intelligence dashboard.

We also use this field to populate the Bank Reconciliation Opening Balance field in the resulting dataset.
Reconciliation Status c2g__ReconciliationStatus__c We use this field to match only bank reconciliations with a status of "Complete".
Statement Date c2g__StatementDate__c We use this field to populate the Bank Statement Date field in the resulting dataset.