SECTIONSFinancial Transactions - Intelligence Input Fields
Input fields are the foundation of the Financial Transactions - Intelligence dataset. These fields are extracted from your org, existing Financial Analytics datasets, and Einstein Discovery by the recipe when you create the Intelligence Analytics app. The data is then processed to populate your app's dataset.
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.
Data Sources
This dataset uses the following data sources as input data:
- Financial Matching dataset
- Financial Transactions dataset
- Prediction definition from Einstein Discovery
For more information about all the input fields available in the Financial Transactions dataset, see Financial Transactions Flow Input Fields.
The Intelligence Analytics recipe also combines data from several Accounting, Billing Central, and Foundations objects with data from the data sources mentioned above to extract field information.
The following Accounting objects are imported:
- Accounting Company
- Accounting Currency
- Bank Account
- Bank Reconciliation
The following Billing Central objects are imported:
- Billing Contract
- Billing Contract Line Item
- Billing Schedule
The Foundations Company object is imported.
The recipe also imports the Salesforce Account object.
Accounting Company
The Intelligence Analytics recipe imports the Accounting Accounting Company object.
|
Field Label |
Field API Name |
Description |
|---|---|---|
| Company | c2g__OwnerCompany__c | We use this field along with the to populate the Company ID field in the resulting dataset. |
Accounting Currency
The Intelligence Analytics recipe imports the Accounting 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 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
|
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. |
Billing Contract and Billing Contract Line Item
The Intelligence Analytics recipe imports the Billing Contract and Billing Contract Line Item objects from Billing Central.
|
Field Label |
Field API Name |
Description |
|---|---|---|
| Account | ffbc__Account__c | We use this field to link the billing contract to the related account. We also use this field to populate the Account ID field in the resulting dataset. |
| Company | ffbc__Company__c | We use this field to link the billing contract to the related company. We also use this field to populate the Company field in the resulting dataset. |
| Contract | ffbc__Contract__c | We use this field to populate the Billing Contract ID field in the resulting dataset. |
| Contract Line Item Number | Name | We use this field to populate the Billing Contract Line Item Number field in the resulting dataset. |
| Contract Name | ffbc__ContractName__c | We use this field to populate the Billing Contract Name field in the resulting dataset. |
| Contract Number | Name | We use this field to populate the Billing Contract Number field in the resulting dataset. |
| Status | ffbc__Status__c | We use this field to match only bank contracts with the status of "Active". |
| Record ID | Id | We use this field to link the billing contract to the related billing schedule. We also use this field to populate the Record ID field in the resulting dataset. |
Billing Schedule
The Intelligence Analytics recipe imports the Billing Central Billing Contract object.
|
Field Label |
Field API Name |
Description |
|---|---|---|
| Billing Contract | ffbc__BillingContract__c | We use this field to link the billing schedule to the related billing contract. |
| Billing Date | ffbc__BillingDate__c | We use this field to populate the Due Date field in the resulting dataset. |
| Billing Document Line Item | ffbc__BillingDocumentLineItem__c | We use this field to match only billing schedules that are not linked to a billing document line item. |
| Billing Schedule Name | Name | We use this field to populate the Billing Schedule Name field in the resulting dataset. |
| Currency ISO Code | CurrencyISOCode | We use this field to populate the Home Currency field in the resulting dataset. |
| Record ID | Id | We use this field to populate the Record ID field in the resulting dataset. |
| Value | ffbc__Value__c | We use this field to populate the Home Outstanding Value field in the resulting dataset. |
Foundations Company
The Intelligence Analytics recipe imports the Foundations Company object.
|
Field Label |
Field API Name |
Description |
|---|---|---|
| Accounting Company | c2g__msg_link_ffa_id__c | We use this field to link the company to the related accounting company. We also use this field to populate the Company ID field in the resulting dataset. |
| Company Name | Name | We use this field to populate the Company Name field in the resulting dataset. |
| Record ID | Id | We use this field to link the company to the related billing contract. We also use this field to populate the Company ID field in the resulting dataset. |
Account Object
These are the fields retrieved from the Account object. This is a standard Salesforce object. For more information about this field, see the Salesforce Help.
|
Field Label |
Field API Name |
Description |
|---|---|---|
| Account Name | Name | We use this field to populate the Account Name field in the resulting dataset. |
| Record ID | ID | We use this field to link the account to the related billing contract. |
Financial Transactions Dataset
These are the fields retrieved from the Financial Transactions dataset.
|
Field Label |
Field API Name |
Description |
|---|---|---|
| Account ID | AccountId | These fields are extracted directly from the Financial Transactions dataset and available in the Financial Transactions - Intelligence dataset. They are also used to calculate other fields. For more information, see Calculated Fields and Financial Transactions - Intelligence Output Fields. |
| Company ID | CompanyId | |
| Company Name | CompanyName | |
| Dual Outstanding Value | ValueDualOutstanding | |
| Due Date | DueDate | |
| Home Currency | CurrencyHome | |
| Home Outstanding Value | ValueHomeOutstanding | |
| Line Type | LineType | |
| Record ID | RecordId | |
| Transaction Type | TransactionType |