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 Foundations. Other Certinia applications use this object and add fields, buttons and functionality to it.

This page explains how Billing Central uses standard Billing Document Line Item fields, and describes the fields that Billing Central adds to the object. For information about other fields on the object, see Billing Document Line Item Fields.

How Billing Central Uses Standard Fields on the Billing Document Line Item

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

Billing Document Line Item Fields that Billing Central Adds Functionality To
Field Name Description
Derived Unit Price

Average price charged per unit before tax. This might be different from Unit Price because it takes account of adjustments such as proration and discounts that are applied to the line as a whole rather than to individual units. It is calculated using the formula: Net Value / Quantity

If Net Value is zero, this field is also zero. If Quantity is zero when Net Value is not zero, this field is blank.

This field can be used for integrating with systems that only allow unit price and quantity with no other adjustments, or when you want the unit price to accurately reflect what is being charged.

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.
Note:

If proration or charge terms are in use, the value in this field is adjusted to take account of how many full and partial periods are being billed.

Net Value

Net value of this billing document line item. If Net Value Override is set, Net Value uses the override value. If Net Value Override is not set, this field is calculated using the formula Unit Price x Quantity.

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.

Note:

If proration or charge terms are in use, the value in this field is adjusted to take account of how many full and partial periods are being billed.

Net Value Override Contains the value that the Net Value is overridden with. Billing Central populates this field if the product belongs to a tiered pricing structure, and if proration, charge terms, or discounts apply. You can manually enter a value to override the 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) and the corresponding billing event item was blank, this field contains the product Professional Services.

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:

If Net Value Override contains a value, the Unit Price is ignored.

Fields Billing Central Adds to the Billing Document Line Item Object

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

Key: R – Read-only;

Field Name

 

Description

Charge Term R

Formula field containing the charge term of the contract line item to which this billing document line item relates. If no charge term was set on the contract line item, this field is blank.

Contract Line Item   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 Formula field containing the status of the contract to which this billing document line item belongs.
Contract Type   Type of contract to which this billing document line item belongs.
Document Date R 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".
Ends Later Than Contract Line R For internal use only. This checkbox is selected when the billing period end date falls after the contract line item's end date, or when the contract line item is canceled.
Original Billing Document   Lookup to the original billing document that this line came from before consolidation.

Plan Name

 

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

 

Lookup to the unit of measure used to determine customer usage on this billing document line item.