Skip to content

Invoice Line Item

API Name: InvoiceLineItem__c

The invoice line item object is used to store information about the billable items in an invoice. Invoice line items are in a master-detail relationship to an invoice.

Label API Name Type Description
No Name AutoNumber
Order Discount Amount AEDiscountAmount__c Currency(16, 2) The order discount amount reduces the invoice line item price by the specified amount.
Applied Tax Rule AppliedTaxRule__c Text(255) The tax rule identified as applicable for this invoice line item.
Base Quantity BaseQuantity__c Number(13, 5) The original quantity, which has been used to select the price tier.
Billed Opportunity Object BilledOpportunityObject__c Text(18) Holds the ID of an opportunity product or opportunity product schedule to mark them as billed.
Billed Opportunity BilledOpportunity__c Text(18) The ID of the opportunity that has been (partially) billed with this invoice line item.
Billing Factor BillingFactor__c Number(13, 5) Factor resulting from the billing period and the billing unit. The billing unit Month combined with the billing period 3 results in a billing factor of 3, that is, the item is invoiced every 3 months with the price multiplied by 3.
Billing Unit BillingUnit__c Picklist Defines the time unit for the billing period (Day or Month), which is used for the price calculation of the billing period.
Calculated Billing Factor CalculatedBillingFactor__c Number(13, 5) Corrects the billing factor to 1.0 to avoid multiplication with zero.
Calculated Commission CalculatedCommission__c Percent(16, 2) Corrects the commission to 1.0 to avoid multiplication with zero.
Calculated Factor CalculatedFactor__c Number(13, 5) Corrects the quantity unit factor to 1.0 to avoid division by zero.
Calculated Quantity CalculatedQuantity__c Number(13, 5) Corrects the quantity by the factor of the quantity unit.
Calculated Tax CalculatedTax__c Currency(16, 2) The tax calculated based on the discounted invoice line item price and the tax rate.
Center Center__c Text(255) The cost center or profit center for this invoice line item, used for financial accounting.
Commission Tier Price CommissionTierPrice__c Currency(13, 5) The price (sales volume) that determines the commission tier. Only used for internal purposes during the invoice creation.
Commission Commission__c Percent(3, 2) The commission (percentage value) to apply to the unit price.
Decimal Places for Quantity DecimalPlacesForQuantity__c Number(2, 0) The number of decimal places for the quantity as displayed on the invoice.
Decimal Places for Unit Price DecimalPlacesForUnitPrice__c Number(2, 0) The number of decimal places for the unit price as displayed on the invoice.
Description Description__c LongTextArea(32768) The long description for the invoice line item.
Discount Amount DiscountAmount__c Currency(16, 2) The discount amount reduces the invoice line item price by the specified amount. The discount amount is applied if the discount field is empty.
Discount Discount__c Percent(3, 2) Specifies a percentage discount rate that is applied to the invoice line item price.
Display Quantity DisplayQuantity__c Number(13, 5) Displays the actual quantity when using scaled prices.
Display Subtotal After This Item DisplaySubtotalAfter__c Checkbox Defines whether a subtotal is displayed after this invoice line item.
Factor Factor__c Number(13, 5) The factor is provided by the quantity unit (custom setting). The actual quantity is divided by the factor.
GL Account 2 GLAccount2__c Text(255) Additional general ledger account for this invoice line item, used for financial accounting. The usage depends on the business process.
GL Account GLAccount__c Text(255) The general ledger account for this invoice line item, used for financial accounting.
Gross Line Item GrossInvoice__c Checkbox Controls whether the unit price is considered a gross value (checked) or net value (unchecked). This affects the invoice line item values for net, tax and gross amounts.
Has Precalculated Tax HasPrecalculatedTax__c Checkbox Determines whether the precalculated tax field is filled.
Ignore Placeholders IgnorePlaceholders__c Checkbox When checked the rendering of placeholders will be disabled for this line item.
Invoice Criterion InvoiceCriterion__c Text(255) Defines the criterion for distributing the invoice line item to multiple invoices.
Invoice Invoice__c MasterDetail(Invoice__c) The invoice to which this invoice line item is associated.
Discount Empty IsDiscountEmpty__c Checkbox Determines whether the discount percentage field is filled.
Is Final IsFinal__c Checkbox Controls whether the invoice line item is set final. If so, it is not touched by the continuous invoice run.
Is Tax Delta IsTaxDelta__c Checkbox Determines whether this line item is a tax delta item used to clear tax rounding differences when calculating invoice line item totals.
Item Item__c Lookup(Item__c) The item based on which this invoice line item has been created.
Pos Price Calculated PosPriceCalc__c Currency(13, 5) The net or gross invoice line item price multiplied with quantity, factor and billing factor.
Pos Price Discounted (w/o Order Disc.) PosPriceDiscountedNoAE__c Currency(13, 5) The net or gross invoice line item price corrected by all discount values, except for the order discount.
Pos Price Discounted PosPriceDiscounted__c Currency(13, 5) The net or gross invoice line item price corrected by all discount values.
Pos. Total (gross) PosTotalGross__c Currency(16, 2) The invoice line item total gross value including all discounts.
Pos. Total (net, w/o Order Discount) PosTotalNetNoAE__c Currency(16, 2) The invoice line item total net value without the order discount.
Pos. Total (net) PosTotalNet__c Currency(16, 2) The invoice line item total net value including all discounts.
Pos. Total (tax) PosTotalTax__c Currency(16, 2) The final tax amount.
Precalculated Tax PrecalculatedTax__c Currency(16, 2) The absolute tax amount calculated internally or by a third party system.
Price Tier Quantity PriceTierQuantity__c Number(15, 3) The quantity that determines the price tier. Only used for internal purposes during the invoice creation.
Product Code ProductCode__c Text(255) The product code of the applicable pricebook entry for the product based on which this invoice line item has been created.
Product Group ProductGroup__c Text(255) The product group of this invoice line item.
Product Tax Class ProductTaxClass__c Text(255) Corresponds to the custom field ON_TaxClass__c of a Product2, like (tax)free / reduced / full / luxury.
Product Tax Rate ProductTaxRate__c Percent(3, 3) Corresponds to the custom field ON_TaxRate__c of a Product2.
Quantity Quantity__c Number(13, 5) The quantity to be billed for this invoice line item.
Quota Quantity QuotaQuantity__c Number(13, 5) The minimum quota.
Recognition Rule RecognitionRule__c Picklist Specifies how line items are distributed onto different booking periods.
Related Invoice RelatedInvoice__c Lookup(Invoice__c) Shows the specific invoice to which this invoice line item is related.
Related Line Item RelatedLineItem__c Lookup(InvoiceLineItem__c) Shows the related line item, used to determine the refundable amount for credit memos.
Sequence Sequence__c Number(18, 0) Determines the position of this invoice line item in the invoice line item table.
Serialized Transaction SerializedTransaction__c LongTextArea(32768) The serialized transaction that has been used to create this invoice line item. Is reused during the continuous invoice run.
Service Period End ServicePeriodEnd__c Date Specifies the end date of the service period (billing cycle).
Service Period Start ServicePeriodStart__c Date Specifies the start date of the service period (billing cycle).
Status Status__c Text Specifies the main invoice status, either Draft, Open, Paid or Settled.
Tax Code TaxCode__c Text(255) The tax code of the applied tax rule.
Tax Provider TaxProvider__c Picklist The provider that calculates the tax detail.
Tax Rate TaxRate__c Percent(3, 3) The tax rate that applies to this invoice line item as defined via tax rules. Can be overwritten manually.
Tax Type TaxType__c Text(255) The type of the tax rate (e.g., VAT, HST). Only applicable if there are no tax details.
Title Title__c Text(255) The name or short description of the invoice line item.
Transaction Criterion TransactionCriterion__c Text(255) The criterion for aggregating transactions to create a single invoice line item.
Type Type__c Picklist Specifies the invoice line item type, which is relevant for subtotals, e.g., Product, Shipping Fees, Handling Fees.
Unit Price UnitPriceCalc__c Currency(13, 5) The net or gross unit price multiplied with the commission.
Unit Price UnitPrice__c Currency(13, 5) The net or gross price (depending on the gross invoice setting of the invoice) of one unit of this item.
Unit Unit__c Picklist The invoiced unit that applies for this invoice line item, like h (hours), pc (pieces), etc.