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

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