Billing Document Line Item Fields

Products and services are applied to billing documents as billing document line items. The Billing Document Line Item object is a core component of FinancialForce Foundations. Other FinancialForce applications use this object and add fields, buttons and functionality to it. Here is a description of the Billing Document Line Item fields and buttons grouped by the FinancialForce product to which they belong.

FinancialForce Foundations

Here is a description of the Billing Document Line Item fields and buttons that are part of FinancialForce Foundations.

Key: * – Mandatory field; R – Read-only in all contexts.

The number indicates the number of characters that are allowed in this text field, where appropriate.

Field Name			Description
Analysis Item 1-4			Used to sub-analyze billing document lines for reporting purposes. Analysis items can be used to represent a number of different business concepts, for example, Region, Group or Project.
Billing Document			Billing document to which this billing document line item belongs.
Billing Document Status	R		Status of the billing document to which this billing document line item belongs.
Company Site			Company site to which this billing document line item relates, representing the location the product is shipped from. The site must be a child of the company specified on the related billing document and contain complete address details.
Description		255	Description of the billing document line item.
Discount Total			The total discount for this billing document line item. If the related contract line item has a percentage discount, this field is calculated using the formula Percentage Discount x Net Value Before Discount. If the related contract line item has a fixed value discount: If the Net Value Before Discount is greater than the Fixed Value Discount, this field equals the Fixed Value Discount. If the Net Value Before Discount is less than the Fixed Value Discount, this field equals the Net Value Before Discount. If there is no discount on the line, this field contains zero.
Document Line			Number of this billing document line item.
Enter Shipping Address Manually			Indicates that you want to enter and maintain the shipping address manually. If deselected and a shipping account is specified, the account shipping address is saved to the line. For more information, see Specifying Addresses on Billing Document Line Items.
Invalid Company Site			Indicates that the selected company site is not a child of the billing document company. This checkbox is populated automatically when you make a change to the billing document that results in an invalid company site on the line item.
Invalid Shipping Account			Indicates that the selected shipping account is not a valid descendant of the billing document account. Valid descendants include records up to five relationships deep in the hierarchy. This checkbox is populated automatically when you make a change to the billing document that results in an invalid shipping account on the line item.
Net Value			Total value of this billing document line item before tax to two decimal places. If the Total Discount is greater than the Net Value Before Discount, this field is zero. If the Total Discount is less than the Net Value Before Discount, this field is calculated using the formula Net Value Before Discount - Total Discount.
Net Value Before Discount			The net value of the billing document line item before the discounts are applied. If the related contract line item has no pricing structure, this field is calculated using the formula Unit Price x Quantity. If the related contract line item has a pricing structure, this field is calculated using that pricing structure and the usage records or quantity associated with that contract line item. This field contains a value regardless of whether there is a discount on the related contract line item.
Net Value Override			Contains the value that the Net Value is overridden with. This field contains a value if the product belongs to a tiered pricing structure. Additionally, you can enter a value to override the Net Value. See Net Value.
Product or Service	*		Lookup to the Salesforce product or service to which this billing document line item relates. If this billing document was created from a billing event (via the Billing Events Integration) this field will contain the product "Professional Services" if the field on the corresponding billing event item was blank.
Quantity	*	12.6	Number of items included in this billing document line item to six decimal places. This is used to calculate the Total Value of the billing document line item.
Reporting Net Value	R		Total Value of this billing document line item before tax based on the Document Type of the billing document. If the billing document is an invoice, the value is the same as the Net Value. If the document is a credit note, the value is calculated using the formula: Net Value * -1.
Reporting Net Value Number	R		Contains the Reporting Net Value as a number to 2 decimal places. This field is used by FinancialForceBusiness Analytics.
Reporting Tax Value Total	R		Total tax for the billing document line item based on the Document Type of the billing document. If the billing document is an invoice, the value is the same as the Tax Value Total. If the document is a credit note, the value is calculated using the formula: Tax Value Total * -1.
Reporting Total Value	R		Total Value of this billing document line item including tax based on the Document Type of the billing document. If the billing document is an invoice, the value is the same as the Total Value. If the document is a credit note, the value is calculated using the formula: Total Value * -1.
Shipping Account	*		Salesforce account to which this billing document line item relates, representing the location the product is shipped to. The account must be a descendant of the account specified on the related billing document and contain complete address details. Valid descendants include records up to five relationships deep in the hierarchy. Tip: We recommend that you derive shipping address details from a related account record. However, if your Billing Document Line Item object contains a lookup to Contact with the API name Ship_To__c, it is possible to use the contact to populate shipping address details. The following rules apply when you specify a contact and no shipping account and deselect Enter Shipping Address Manually: Shipping address details are populated from the mailing address on the contact when you save the record The mailing address on the contact must be complete For more information, see Specifying Addresses on Billing Document Line Items.
Shipping Street			Shipping address for this billing document line item, which can be entered and maintained manually or automatically populated from the shipping account. For more information, see Specifying Addresses on Billing Document Line Items.
Shipping City
Shipping State/Province
Shipping Zip/Postal Code
Shipping Country
Tax Rate Total			Total tax rate for the billing document line item.
Tax Value Total			Total tax for the billing document line item to two decimal places. On the enhanced Billing Document Detail page, click this field to open a dialog box showing the breakdown of tax on the line.
Total Value			Total Value of this billing document line item including tax to two decimal places. The formula used to calculate this is Net Value + Tax Value Total.
Unit Price	*		Price of one item for the billing document line item to nine decimal places. This is used to calculate the Total Value of the billing document line item. Note: The Unit Price Field is field ignored if Net Value Override contains a value. In this scenario, the value in the Unit Price field is shown with a line through it. See Net Value Override.

Tax Breakdown

Key: A – If you enter a value, the Tax Rate and Tax Value are calculated from the tax code; M – You can enter values manually, but when you do so these fields are no longer calculated.

Note:

Tax is calculated against the Net Value, not the Net Value Before Discount.

Field Name		Description
Reporting Tax Value 1-3		Tax value of the corresponding tax rate based on the document type of the billing document. If the billing document is an invoice, the value is the same as tax value 1. If the document is a credit note, the value is calculated using the formula: Tax Value 1 * -1.
Tax Code 1-3	A	Tax code to use when calculating tax for this billing document line item. You can use these to represent the state, county, and city tax authorities.
Tax Rate 1-3	M	Tax rate to use when calculating tax for this billing document line item. Tip: Leave the field blank if you want this to be calculated using the tax code.
Tax Value 1-3	M	Tax value calculated from the corresponding tax rate using the formula: Net Value * (Tax Rate / 100). Note: Changing the tax value does not change the tax rate. Tip: Leave the field blank if you want this to be calculated using the tax code.

Billing Central

Here is a description of the fields that FinancialForceBilling Central adds to the Billing Document Line Item object.

Key: R – Read-only in all contexts; C – Only available on the Salesforce Billing Document Detail page.

The number indicates the number of characters that are allowed in this text field, where appropriate.

Field Name			Description
Contract Line Item		C	Lookup to the contract line item to which this billing document line item relates. This field is populated when the billing document is complete and is used to calculate the Total Billed field of the related contract line item.
Contract Status	R	C	Formula field containing the status of the contract to which this billing document line item belongs.
Contract Type		C	Type of contract to which this billing document line item belongs.
Document Date	R	C	Formula field containing the document date of the billing document to which this billing document line item belongs.
End of Period			Last day of the billing period for this billing document line item. Editable if the billing document's status is "Draft".
Original Billing Document			Lookup to the original billing document that this line came from before consolidation.
Plan Name		C	Lookup to the plan to which this billing document line item belongs.
Start of Period			First day of the billing period for this billing document line item. Editable if the billing document's status is "Draft".
Unit of Measure		C	Lookup to the unit of measure used to determine customer usage on this billing document line item.

FinancialForce Accounting

Here is a description of the fields and field sets that FinancialForce Accounting adds to the Billing Document Line Item object. They are only available if you are using the integration between Billing Central and Accounting.

Note:

These fields are only available if they have been added to the billing document line item page layout.


Field Name	Description
Match Type	Match Type of the FinancialForce Accounting transaction to which this billing document line item relates.
Outstanding Value	Outstanding Value of the FinancialForce Accounting transaction to which this billing document line item relates.
Product GLA Override	Lookup to a FinancialForce Accounting general ledger account to use on this product line. If this field is left blank, the sales revenue account on the product is used.

Field Sets

Field Set Name	Description	Default Fields	Object
Community Printed Document Fields	Contains additional billing document line item fields to appear on billing documents when printed from FM Communities.	Net Value Quantity Tax Rate Total Tax Value Total	Billing Document Line Item

Field Set Name

Description

Default Fields

Object

Community Printed Document Fields

Contains additional billing document line item fields to appear on billing documents when printed from FM Communities.

Net Value
Quantity

Tax Rate Total

Tax Value Total

Billing Document Line Item

PSA

Here is a description of the fields that FinancialForce PSA adds to the Billing Document Line Item object for use with the Billing Events integration.

Field Name	Description
Billing Event Item	Lookup to the PSA Billing Event Item from which this billing document line item was created.
Billing Event Item Correlation ID	A unique ID used internally to correlate messages between the billing event item and billing document line item.
Project	The project on the associated billing event item.
Summary	The summary information on the associated billing event item.

Revenue Management

Here is a description of the fields that Revenue Management adds to the Billing Document Line Item object when the integration between Revenue Management and Billing Central is enabled.

Revenue Management fields on Billing Document Line Item
Field Name	Description
Include in Revenue Recognition	Indicates whether or not the billing document line item is included for revenue recognition. Selected automatically if the parent billing document's type is "Invoice" and status is "Complete" and the related contract line item has the billing type "Recurring Variable".
Recognized To Date	Stores the amount that has been recognized to date for the billing document line item. The value updates each time revenue recognition transactions are committed for the document line item.
Revenue Recognition Complete	A checkbox that is automatically set by the revenue recognition process when the billing document line item is fully recognized (and fully amortized). The document line item is then ignored by future revenue recognition processes.
Revenue Recognition Template	Lookup to the template used to recognize revenue for the billing document line item.