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