Billing Contracts Input Fields

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

Base Object

This flow uses the Contract Line Item as base object to retrieve Accounting field information. It also uses this object to look up to other Accounting objects to complement the data necessary to generate the Billing Contract Dataset.

Contract Line Item

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

Field	Description
Monthly Recurring Revenue	These fields are imported directly from your Accounting environment. For more information about these fields, see Billing Contract Fields object.
Created Date
Active Contract Line Item
Amount Billed Externally
Annual Recurring Revenue
Billed Externally To
Billed To
Billing Type
Contract Status
Contract Type
Description
End Date
First Bill Date
In Arrears
ID
Name
Pricing Type
Quantity
Revenue Category
Sales Price
Sales Price Override
Start Date
Total Billed
Total Contract Line Value
Unit Price
Created By ID
Mrr Multiplier
Billing Term	We use this field to look up the corresponding Accounting object for the following fields Billing Term
Contract	We use this field to look up the corresponding Accounting object for the following fields Billing Contract
Previous Contract Line Item	We use this field to look up the corresponding Accounting object for the following fields Previous Contract Line Item and Opportunity Line Item
Product Service	We use this field to look up the corresponding Accounting object for the following fields Product

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.

Accounting Object	Lookup Path	Field
Billing Term		ID
		Name
Billing Contract		Created By ID
		Created Date
		Currency Iso Code
		Account
		Active Contract
		Annual Recurring Revenue
		Approval Status
		Company
		Contract Name
		Description
		End Contract Notes
		End Date
		Engagement
		First Bill Date
		Is Renewal Of Previous Contract
		Major Version
		Monthly Recurring Revenue
		Original End Date
		Previous Contract
		Reason For Ending Contract
		Renewal Reminder
		Start Date
		Total Contract Value
		ID
		Name
		Owner ID
	Contract → Account	Billing City
		Billing Country
		Billing State
		Base Date 1
		Base Date 2
		Base Date 3
		Base Date 4
		Credit Limit
		Credit Manager
		Credit Status
		Days Offset 1
		Days Offset 2
		Days Offset 3
		Days Offset 4
		Finance Contact
		Payment Method
		Contact Department
		Contact Email
		Contact Mailing Country
		Contact Name
		Contact Phone
		Contact Title
		ID
		Industry
		Name
		Phone
		Type
		User Name
		Website
	Contract → Company	EC Country Code
		Sales Tax Company Code
		Short Street
		VAT GST Group
		VAT Registration Number
		Year End Mode
		FFA Company ID
		FFA Company Name
		City
Country
Logo URL
State
Street
Validated City
Validated Country
Validated State
Validated Street
Validated Zip
Website
Zip
Contract → Previous Contract	Contract Status
Contract → Next Contract	Contract ID
	Contract Status
Opportunity Line Item	Composite Key	Account ID
		Amount
		Close Date
		Created By ID
		Created Date
		Description
		Company
		Contract
		Contract End Date
		Contract First Bill Date
		Contract Start Date
		Original Opportunity
		Forecast Category
		Forecast Category Name
		Has Open Activity
		Has Opportunity Line Item
		Has Overdue Task
		ID
		Is Closed
		Is Won
		Lead Source
		Name
		Next Step
		Owner Name
		Owner ID
		Probability
		Process Action
		Process Trigger
		Stage Name
		Type
	Original Opportunity (previous)	Opportunity ID
		Opportunity Name
	Opportunity ID (next)	Opportunity ID
		Opportunity Name
		Opportunity Process Action
Product		Sales Tax Rule
		Sales Tax Status
		Tax Code
		Place Of Supply
		Description
		Display URL
		Family
		Billing Type
		Sales Tax Status
		Tax Code
		ID
		Is Active
		Name
		Product Code
		Stock Keeping Unit
Previous Contract Line Item		Annual Recurring Revenue
		Billing Type
		Contract
		Contract Status
		End Date
		Monthly Recurring Revenue
		Quantity
		Sales Price
		Start Date
		Total Contract Line Value
		Unit Price
		ID
		Name
		Next Contract Contract ID
		Next Contract. Contract Status
		Next Contract Left Key
		Temp Next Contract Right Key
		Temp Previous Contract Line Item Left Key
		Temp Previous Contract Right Key
	Temp Previous Contract Item Left Key	Annual Recurring Revenue
		Monthly Recurring Revenue
	Next Contract Left Key	Annual Recurring Revenue
		End Date
		Monthly Recurring Revenue
		Start Date
		Total Contract Line Value
		ID
		Name
		Previous Contract Line Item Next Contract Left Key
		Previous Contract Line Item Temp Next Contract Right Key
		Previous Contract Line Item Temp Previous Contract Line Item Left Key
		Previous Contract Line Item Temp Previous Contract Right Key
		Temp Next Contract Right Key
		Temp Previous Contract Line Item Left Key
		Temp Previous Contract Right Key
		Total Previous Contract Line Item Annual Recurring Revenue
		Total Previous Contract Line Item Monthly Recurring Revenue
	Renewed Contract Line Item Left Key	End Date