SECTIONSBilling 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.
Standard Items
Here is a description of the Billing Document Line Item fields and buttons that are part of Foundations.
Key: * – Mandatory field; R – Read-only.
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 External Tax Status | R | External Tax Status of the 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. | ||
| Derived Unit Price |
Average price charged per unit before tax. For more information about how Billing Central uses this field, see Billing Document Line Item Fields. |
||
|
Description |
255 |
Description of the billing document line item. |
|
| Discount Total |
The total discount for this billing document line item. For more information about how Billing Central uses this field, see Billing Document Line Item Fields. |
||
| 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 Net Value Override is set, then Net Value is set to the override value. For more information about how Billing Central uses this field, see Billing Document Line Item Fields. |
||
| Net Value Before Discount |
The net value of the billing document line item before the discounts are applied. For more information about how Billing Central uses this field, see Billing Document Line Item Fields. |
||
| Net Value Override |
Contains the value that the Net Value is overridden with. For more information about how Billing Central uses this field, see Billing Document Line Item Fields. |
||
|
Product or Service |
* |
Lookup to the Salesforce product or service to which this billing document line item relates. For more information about how Billing Central uses this field, see Billing Document Line Item Fields. |
|
|
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 Business 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. 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. |
||
|
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. For more information about how Billing Central uses this field, see Billing Document Line Item Fields. |
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.
|
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. |
|
Tax Value 1-3 |
M |
Tax value calculated from the corresponding tax rate using the formula: Net Value * (Tax Rate / 100). |
Applications That Add Fields to the Billing Document Line Item Object
Several Certinia applications add fields to the Billing Document Line Item object. For more information about how other Certinia applications use this object, follow the relevant links.
|
Application |
Further Information |
|---|---|
| Accounting | Billing Document Fields |
| Billing Central | Billing Document Line Item Fields |
| Order and Inventory Management | Billing Document Line Item Fields |
| PSA | Billing Document Line Item Fields |
| Revenue Management | Billing Document Line Item Fields |