Financial 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 Transaction Line Item and Reporting Balance as base objects to extract Accounting field information. It also uses these objects to look up to other Accounting objects to complement the data necessary to generate the Financial Transactions Dataset.

Transaction Line Item

These are the main fields retrieved from the Transaction Line Item object in Accounting.

Field

Description

Account Outstanding Value

These fields are extracted directly from your Accounting environment. For more information about these fields, see Transaction Fields.

Account Type
Account Value
As of Age
As of Age Band
As of Date
As of Dual Value
As of Home Value
As of Name
Bank Account Value
Bank Reconciliation
Bank Reconciliation Status
Cash Flow Category
Cash Flow Line Summary
Date Canceled
Days Overdue
Dimension 1 Value
Dimension 2 Value
Dimension 3 Value
Dimension 4 Value
Discount Account Value 1
Discount Account Value 2
Discount Account Value 3
Discount Account Value 4
Discount Document Value 1
Discount Document Value 2
Discount Document Value 3
Discount Document Value 4
Document Outstanding Value
Document Rate
Document Tax Total
Document Tax Value
Document Tax Value 2
Document Tax Value 3
Document Taxable Value
Document Value
Dual Outstanding Value
Dual Rate
Dual Value
Due Date
Exclude from Cash Flow
General Ledger Account Value
Home Outstanding Value
Home Tax Total
Home Tax Value
Home Tax Value 2
Home Tax Value 3
Home Taxable Value
Home Value
Income Tax Type
Is Output VAT Tax
Last Customer Statement Date
Last Reminder Date
Line Description
Line ID
Line Number
Line Reference
Line Type
Local GLA Value
Matching Status
On Hold
Original Account
Process Status
Reclassify Profits
Record ID
Severity
Statement Date
Tax Group
Transaction Reconciliation Date
Transaction Reconciliation Status
Version
Account We use this field to look up the corresponding Accounting object for the following fields Account
Accounting Currency We use this field to look up the corresponding Accounting object for the following fields Accounting Currencies
Archive Set

We use this field to look up the corresponding Accounting object for the following fields Archive Set.

Bank Account We use this field to look up the corresponding Accounting object for the following fields Bank Account
Company We use this field to look up the corresponding Accounting object for the following fields Company
Dimension 1 We use this field to look up the corresponding Accounting object for the following fields Dimension 1-4
Dimension 2
Dimension 3
Dimension 4
Document Currency We use this field to look up the corresponding Accounting object for the following fields Document
Dual Currency We use this field to look up the corresponding Accounting object for the following fields Dual Currency / Company
Expense We use this field to look up the corresponding Accounting object for the following fields Expense
General Ledger Account We use this field to look up the corresponding Accounting object for the following fields General Ledger Account
Home Currency We use this field to look up the corresponding Accounting object for the following fields Home Currency / Company
Intercompany Transfer We use this field to look up the corresponding Accounting object for the following fields Intercompany Transfer
Local GLA We use this field to look up the corresponding Accounting object for the following fields Local GLA
Product We use this field to look up the corresponding Accounting object for the following fields Product
Reverse Charge Tax Code We use this field to look up the corresponding Accounting object for the following fields Reverse Charge Tax Code
Tax Code 1 We use this field to look up the corresponding Accounting object for the following fields Tax Code 1-3
Tax Code 2
Tax Code 3
Transaction Number We use this field to look up the corresponding Accounting object for the following fields Transaction
Transaction Reconciliation We use this field to look up the corresponding Accounting object for the following fields Transaction Reconciliation

Reporting Balance

These are the main fields retrieved from the Reporting Balance object in Accounting.

Field

Description

Cash Flow Category

These fields are extracted directly from your Accounting environment. For more information about these fields, see the Reporting Balance Fields object.

Cash Flow Line Summary
Dual Value
Home Value
Owner ID
Reclassify Profits
Record ID
Type
Account We use this field to look up the corresponding Accounting object for the following fields Account
Accounting Book We use this field to look up the corresponding Accounting object for the following fields Accounting Book
Bank Account We use this field to look up the corresponding Accounting object for the following fields Bank Account
Company We use this field to look up the corresponding Accounting object for the following fields Company
Dimension 1 We use this field to look up the corresponding Accounting object for the following fields Dimension 1-4
Dimension 2
Dimension 3
Dimension 4
General Ledger Account We use this field to look up the corresponding Accounting object for the following fields General Ledger Account
Intersect Definition We use this field to look up the corresponding Accounting object for the following fields Intersect Definition
Local GLA We use this field to look up the corresponding Accounting object for the following fields Local GLA
Period We use this field to look up the corresponding Accounting object for the following fields Period
Product We use this field to look up the corresponding Accounting object for the following fields Product

Fixed Asset

These are the main fields retrieved from the Fixed Asset object in Fixed Asset Management.

Field

Description

Deployed Department

These fields are extracted directly from your Fixed Asset Management environment. For more information, see the Fixed Asset Fields

Fixed Asset Cost
Fixed Asset Date in Service
Fixed Asset Description
Fixed Asset Manufacturer
Fixed Asset Manufacturer Serial Number
Fixed Asset Name
Fixed Asset Status
Fixed Asset Group We use this field to look up the corresponding Fixed Asset Management object for the following fields Asset Group
Fixed Asset Sub-Group We use this field to look up the corresponding Fixed Asset Management object for the following fields Asset Sub-Group

Augmented Fields

The augmented 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.

Object

Lookup Path

Fields

 

Intersect Definition Reporting Balance → Intersect Definition Core Accounting Code  
Dimension 1  
Dimension 2  
Dimension 3  
Dimension 4  
Entity  
Full Accounting Code  
General Ledger Account  
Local GLA  
Record ID  
Intersect Definition Name  
Transaction Transaction Line Item → Transaction Account  
Accounting Book  
Allocation  
Archive Set  
Billing Document  
Cash Entry  
CreatedDate  
Currency Revaluation  
Document Description  
Document Number  
Hierarchy Reference  
Journal  
Company  
Payable Credit Note  
Payable Invoice  
Period  
Reverse Reason  
Reverse Transaction Number  
Sales Credit Note  
Sales Invoice  
Transaction Date  
Transaction Type  
Year  
Record ID  
Transaction Number  
Owner ID  
Consolidation Hierarchy Line Company  
Consolidation Hierarchy  
Level 01 Company  
Level 02 Company  
Level 03 Company  
Level 04 Company  
Level 05 Company  
Level 06 Company  
Level 07 Company  
Level 08 Company  
Level 09 Company  
Level 10 Company  
Level 11 Company  
Level 12 Company  
Level 13 Company  
Level 14 Company  
Level 15 Company  
Level 16 Company  
Level 17 Company  
Level 18 Company  
Level 19 Company  
Level 20 Company  
Currency Revaluation Name  
Allocation Name  
Cash Entry Type  
Reverse Transaction Number Name  
Archive Set Transaction Line Item → Archive Set Archive Set Number  
Dual Currency / Company Transaction Line Item / Company → Dual Currency Dual Currency Name  
Home Currency / Company Transaction Line Item / Currency → Home Currency Home Currency Name  
Period N/A AP  
AR  
Cash  
Days in Period *
Description  
End Date  
Final Close  
Name  
Period as Special *
Period Number  
Period Number (Measure) *
Quarter *
Reporting Period (s) *
Reporting Period  
Reporting Year (s) *
Reporting Year and Period (s) (Measure) *
Reporting Year and Period (s) (Dimension) *
Reporting Year  
Reporting Year/Period (s) *
Start Date  
Year Name  
Year Name (Measure) *
Year Period *
Year Period (Measure) *
Reporting Balance → Period → Year Status  
Year End Date  
Year End Mode  
Year Start Date  
Company N/A City  
Country  
Tax Country Code  
Street  
Tax Registration Number  
Zip/Postal Code  
Name  
General Ledger Account N/A Reclassify Profits  
Balance Sheet 1  
Balance Sheet 2  
Balance Sheet 3  
Cash Flow Category  
Cash Flow Line Summary  
Chart of Accounts Structure  
GLA Group  
Local Balance Sheet 1  
Local Balance Sheet 2  
Local Balance Sheet 3  
Local Balance Sheet 4  
Local Balance Sheet Order 1  
Local Balance Sheet Order 2  
Local Balance Sheet Order 3  
Local Balance Sheet Order 4  
Localization  
Local Trial Balance 1  
Local Trial Balance 2  
Local Trial Balance 3  
Local Trial Balance 4  
Reporting Code  
Trial Balance 1  
Trial Balance 2  
Trial Balance 3  
Trial Balance 4  
Type  
Name  
Name (Without code prefix)  
GLA → Chart of Accounts Structure Name  
Account N/A Account Number  
Billing City  
Billing Country  
Billing Zip/Postal Code  
Billing State/Province  
Billing Street  
Accounts Payable Control  
Accounts Receivable Control  
Bank Account Number  
Bank SWIFT Number  
Tax Country Code  
Tax Registration Number  
Collections On Hold  
Collections On Hold Reason  
Fax  
Industry  
Name  
Phone  
Shipping City  
Shipping Country  
Shipping Zip/Postal Code  
Shipping Street  
SIC Code  
SIC Description  
Website  
Account → Parent Account ID  
Name  
Account → Account Owner Name  
Account → Contact Name  
Account → Currency Name  
Accounting Currencies Accounting Currencies → Reporting Currency Reporting Value  
Reporting Outstanding Value  
Reporting Rate  
Reporting Value (Matching)  
Reporting Outstanding Value (Matching)  
Reporting Outstanding Value (s) *
Reporting Value (s) *
Dimension 1-4 N/A Name  
Dimension → Currency Name  
Product N/A Name  
Family  
Bank Account N/A Account Name  
Account Number  
Bank Account Currency  
Bank Name  
City  
Country  
IBAN  
Reporting Code  
Sort Code  
State/Province  
Street  
SWIFT Number  
Zip/Postal Code  
Bank Account Name  
Bank Account → Currency Name  
Tax Code 1-3 N/A Description  
Parent  
Tax Group  
Tax Code  
Tax Code → General Ledger Account GLA Group  
Reporting Code  
Document Document → Currency Name  
Reverse Charge Tax Code N/A Parent  
Tax Group  
Name  
Transaction Reconciliation N/A Name  
Local GLA Local GLA → Currency Name  
N/A Name  
Expense N/A Name  
Accounting Book N/A Primary Book  
Name  
Intercompany Transfer N/A Name  
User Company N/A User (Multi-lookup)  
Asset Group Fixed Asset → Asset Group Asset Group Name  
Asset Sub-Group Fixed Asset → Asset Sub- Group Asset Sub-Group Name