Billing Documents 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 Billing Document 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 Documents Dataset.

Billing Document

These are the main fields retrieved from the Billing Document object in Accounting.

Field	Description
Analysis Item 1	These fields are imported directly from your Accounting environment. For more information about these fields, see Billing Document Fieldsobject.
Analysis Item 2
Analysis Item 3
Analysis Item 4
Billing Period End Date
Billing Period Start Date
Discount Total
General Ledger Account
ID
Line Description
Name
Net Value
Net Value Before Discount
Net Value Override
Plan
Quantity
Reporting Net Value Number
Reporting Tax Value 1
Reporting Tax Value 2
Reporting Tax Value 3
Reporting Tax Value Total
Reporting Total Value
Tax Rate 1
Tax Rate 2
Tax Rate 3
Tax Rate Total
Tax Value 1
Tax Value 2
Tax Value 3
Tax Value Total
Total Value
Unit Price
Billing Document	We use this field to look up the corresponding Accounting object for the following fields Billing Document
Contract Line Item	We use this field to look up the corresponding Accounting object for the following fields Contract 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 Document		Document Rate
		Dual Rate
		Match Type
		Outstanding Value
		Payment Status
		Period Override
		Posting Error
		Posting Status
		Transaction
		Year
		Currency ISO Code
		Contract
		Is Consolidated
		Totaled On Contract
		Account
		Billing Account Name
		Billing City
		Billing Country
		Billing Postal Code
		Billing State
		Billing Street
		Company
		Customer Reference
		Date Issued
		Document Date
		Document Due Date
		Document Status
		Document Type
		Document Type Prefix
		External Document Number
		Footer Text
		Header Text
		Is Billing Address Validated
		Is Complete
		Is Shipping Address Validated
		Related Document
		Shipping Account Name
		Shipping City
		Shipping Country
		Shipping Postal Code
		Shipping State
		Shipping Street
		Name
		GLA ID
	Related Document	Name
	Company	msg_link_ffa_id__c
		Name
	Company → FFA Company	User
	Contract	Name
	Account	Name
Product		CODA Sales Revenue Account
		Name
Contract Line Item		Contract Status
		Contract Type
		Name
General Ledger Account	Billing Document → GLA ID	Name