Recognition Transactions Flow Input Fields

The input fields are the foundation of every dataset in Financial Management Analytics. These fields are extracted from your org environment by the dataflow when you create the Analytics app, the data is then processed to populate your apps' datasets.

Base Objects

This flow uses Revenue Recognition Transaction as base object to extract Revenue Management field information. It also uses this objects to look up to other Accounting and Revenue Management objects to complement the data necessary to generate the Recognition Transactions Dataset.

Revenue Recognition Transaction

This are the main fields retrieved from the Revenue Recognition Transaction object in Revenue Management.

Field

Description

Created By ID These fields are extracted directly from your Revenue Management environment. For more information about these fields, see the Recognition Transaction Fields object.
Account Type
Actual Vs Forecast Relationship
Amortized Opening Balance
Amortized Opening Balance Dual
Amortized Opening Balance Home
Amount Amortized
Amount Amortized Dual
Amount Amortized Home
Amount Recognized Dual
Amount Recognized Home
Analysis Item 1
Analysis Item 2
Analysis Item 3
Analysis Item 4
Cost Account
Cost Amended
Cost Center
Cost Cost Center
Currency
Document Currency Rate
Dual Currency
Dual Currency Rate
Home Currency
Internal Amortized Amount
Internal Amount
Journal Amortized Amount
Journal Amortized Dual Amount
Journal Amortized Home Amount
Journal Amount
Journal Amount Dual
Journal Amount Home
Level 3 Object Record Name
Level 4 Object Record Name
Performance Obligation
Period
Primary Object Record Name
Recognized Date
Recognized Opening Balance
Recognized Opening Balance Dual
Recognized Opening Balance Home
Recognized Record ID
Revenue Amended
Revenue Contract
Salesforce Account
Secondary Object Record Name
Template
ID
Last Modified By ID
Name
Account We use this field to look up the corresponding object for the following fields Account
Company We use this field to look up the corresponding object for the following fields Company
Product We use this field to look up the corresponding object for the following fields Product
Revenue Recognition Master We use this field to look up the corresponding Revenue Management object for the following fields Revenue Recognition Transaction Master

Augmented Fields

The augment fields complement the data imported from the base objects allowing you to have a deeper visualization of your data.

Note:

These fields are imported directly from your org. For more information about these fields, see the field reference page for the relevant object.

Key: → — Lookup path between objects; * — Calculated in field in the dataflow.

Accounting Object

Lookup Path

Fields

 

Revenue Recognition Transaction Master N/A Currency  
Description  
Error  
Error Log  
Errors Manager  
Grouped By  
Legislation Type  
Originating Process  
Period  
Recognition Period  
Recognized Date  
Status  
Total Amortized Balance Sheet  
Total Amortized Income Statement  
Total Balance Sheet  
Total Failed Lines  
Total Income Statement  
Total Line Amortized Balance Sheet  
Total Line Amortized Income Statement  
Total Line Balance Sheet  
Total Line Income Statement  
Total Summary Amortized Balance Sheet  
Total Summary Amortized Income Statement  
Total Summary Balance Sheet  
Total Summary Income Statement  
Total Transaction Lines  
ID  
Name  
Account N/A Name  
Product N/A Name  
Company N/A ID  
FFACompanyId User