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