Financial Balances 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 and 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 Balances dataset.

If you use Planning, the information is also extracted from the Tag object. Tag records contain information about budgets, as well as associated records.

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 the Transaction Fields object.
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
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

This 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

Tag

These are the main fields retrieved from the Tag object in Planning.

Field	Description
Dimension Name	These fields are added to the dataset and are extracted directly from your Planning environment from the associated field of the Tag object. For more information, see the Tag Fields.
Boolean 1
Dimension Page Header
End
External Id
Label Name
Name
Start
Status
StatusChangeDate
Tag Label
Tag1Name
Tag2Name
Tag3Name
Tag4Name
Tag5Name
Tag6Name
Tag7Name
Tag8Name
Tag9Name
Text1
Text2
Text3
Text4
Text5
Currency
Decimal1
Decimal2
Decimal3
Created By	We use this field to look up the corresponding Planning object for the following fields Created By
Dimension	We use this field to look up the corresponding Planning object for the following fields Dimension
Last Modified By	We use this field to look up the corresponding Planning object for the following fields Last Modified By
Owner	We use this field to look up the corresponding Planning object for the following fields Owner
Price Book	We use this field to look up the corresponding Planning object for the following fields Price Book
Product	We use this field to look up the corresponding Planning object for the following fields Product
Tag1	We use this field to look up the corresponding Planning object for the following fields Tag1
Tag2	We use this field to look up the corresponding Planning object for the following fields Tag2
Tag3	We use this field to look up the corresponding Planning object for the following fields Tag3
Tag4	We use this field to look up the corresponding Planning object for the following fields Tag4
Tag5	We use this field to look up the corresponding Planning object for the following fields Tag5
Tag6	We use this field to look up the corresponding Planning object for the following fields Tag6
Tag7	We use this field to look up the corresponding Planning object for the following fields Tag7
Tag8	We use this field to look up the corresponding Planning object for the following fields Tag8
Tag9	We use this field to look up the corresponding Planning object for the following fields Tag9

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

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
		Billing Document
		Cash Entry
		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
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
		Final Close
		Description
		End Date
		Period Number
		Start Date
		Year Name
		Name
		Period as Special	*
		Period Number (Measure)	*
		Year Name (Measure)	*
		Year Period	*
		Year Period (Measure)	*
		Days in Period	*
		Quarter	*
	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 → Contact	Name
	Account → Currency	Name
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)
Created By	Created By → Budgets	Created by ID
	Created By → Budget App Amount
Dimension	Dimension → Budgets	Dimension ID
	Dimension → Budget App Amount
Last Modified By	Last Modified By → Budgets	Last Modified By
	Last Modified By → Budget App Amount
Owner	Owner → Budgets	Owner ID from Details
	Owner → Budget App Amount
Tag1	Tag1 → Budgets	Parent Budget Title
	Tag1 → Budget App Amount	Budget Name
Tag2	Tag2 → Budgets	Template Type
	Tag2 → Budget App Amount	General Ledger Account Name
Tag3	Tag3 → Budgets	Budget Year
	Tag3 → Budget App Amount	Period
Tag4	Tag4 → Budgets	Company Name
	Tag4 → Budget App Amount	Employee Name
Tag5	Tag5 → Budget App Amount	Rates name/description
Tag6	Tag6 → Budget App Amount	Dimension 1
Tag7	Tag7 → Budget App Amount	Dimension 2
Tag8	Tag8 → Budget App Amount	Dimension 3
Tag9	Tag9 → Budget App Amount	Dimension 4
Price Book	Price Book → Budget App Amount	Price Book reference of Template Quantity-Rate
Product	Product → Budget App Amount	Product reference of Template Quantity Rate
Asset Group	Fixed Asset → Asset Group	Asset Group Name
Asset Sub-Group	Fixed Asset → Asset Sub- Group	Asset Sub-Group Name

Fixed Asset Management Object	Lookup Path	Fields
Asset Group	Fixed Asset → Asset Group	Asset Group Name
Asset Sub-Group	Fixed Asset → Asset Sub- Group	Asset Sub-Group Name