--- title: "Field dictionary" slug: "factures-dictionnaire-des-champs" updated: 2025-10-27T13:16:51Z published: 2026-01-07T10:04:01Z canonical: "help.frisbii.com/factures-dictionnaire-des-champs" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.frisbii.com/llms.txt > Use this file to discover all available pages before exploring further. # Field dictionary This module explains the utility of the invoice object which is part of our application. You will learn more about the use cases, the implementation and the actions that can be triggered from this object. ![](https://cdn.document360.io/b84e1b5d-2ba6-4465-8c62-fb45a2f31314/Images/Documentation/image-1761570118915.png?sv=2026-02-06&spr=https&st=2026-10-27T23%3A39%3A21Z&se=2026-10-28T00%3A39%3A21Z&sr=c&sp=r&sig=TpDP%2BI%2B%2BgzTLwcnbgYS4C6G0OfLVxJt8sX1Lqjp%2BuzE%3D) ## Invoice Definition Let's go back to the definition we saw in the article [First steps in Frisbii - main objects in Frisbii](/frisbii-app/docs/en/premiers-pas-avec-frisbii-les-objets-principaux). | Object | Description | | --- | --- | | Invoice | An invoice is a general accounting document that proves a purchase or sale. An invoice is proof of a creditor's claim against a debtor, i.e. a customer's debt to a supplier. | ## Relationship with other objects ![](https://cdn.document360.io/b84e1b5d-2ba6-4465-8c62-fb45a2f31314/Images/Documentation/image-U9R2R6XM.png?sv=2026-02-06&spr=https&st=2026-10-27T23%3A39%3A21Z&se=2026-10-28T00%3A39%3A21Z&sr=c&sp=r&sig=TpDP%2BI%2B%2BgzTLwcnbgYS4C6G0OfLVxJt8sX1Lqjp%2BuzE%3D) After this rather technical introduction, we will learn more about the different invoice fields. ### Object fields by section Here is a list of fields by section. ### Details ![](https://cdn.document360.io/b84e1b5d-2ba6-4465-8c62-fb45a2f31314/Images/Documentation/image-WHLGAIJT.png?sv=2026-02-06&spr=https&st=2026-10-27T23%3A39%3A21Z&se=2026-10-28T00%3A39%3A21Z&sr=c&sp=r&sig=TpDP%2BI%2B%2BgzTLwcnbgYS4C6G0OfLVxJt8sX1Lqjp%2BuzE%3D)

Reference

Text

  • Depends on the Invoice Prefix indicated on the Corporate Name tab.
  • Automatically enters a reference for this invoice, if the box is checked in the Administration tab.
  • From the Summer 21 release, this field is not displayed before issuance.
Corporate NameLookup (Corporate Name)
  • Associated with the object Frisbii Corporate name.
  • Displayed on the PDF of the Quotation.

Account

Lookup (Account)

  • The invoice must be linked to an Account.
  • Associated with the Salesforce Account object.
  • Information displayed on the Invoice PDF.
Accounting DataLookup (Accounting data)
  • Accounting billing information of an Account.
  • Associated with the Frisbii Accounting Data object.
ContactLookup (Contact)
  • Associated with the Salesforce Contact object.
  • Information displayed on the Invoice PDF.
  • Required if you want to send the PDF of the Invoice by email.
Payment methodPicklist
  • The agreed payment method for the Invoice.
  • To be customized from the global value set in the list.
Term of payment		Picklist
  • The agreed-upon time period for payment of amounts due.
  • Refers to a set of global values, including:
    • X days net: X days from the start date
    • X days end of month: X days from the last day of the month
  • From the Summer 21 release, the field Custom term allows you to customize the payment term (since the payment terms are very restricted in France)
Invoice dateDate
  • By default, the creation date of the invoice.
  • Used in the billing automation.
  • Displayed on the PDF of the invoice.
Due date Date
  • Date on which the invoice amount becomes due.
Delivery dateDate
  • To be displayed if needed on the Invoice PDF.
TypePicklist
  • Used to distinguish an invoice from a credit note.
SubtypePicklist
  • Allows you to distinguish the possible subtypes of an invoice (Advance payment/ Sold) or a credit note (Refund/ Cancellation/ Discount/ Additional discount). You can add subtypes in the list according to your business needs
  • Depends on the Type field used.
  • Can be displayed on the Invoice PDF.
StatusPicklist
  • Record Status: Draft, Pre-Validated (from Spring'20), Issued.
  • Depending on your business needs you can add values to the selection list.
  • Can be used in automations to avoid processing draft or issued invoices.
StagePicklist
  • Allows you to indicate the actions related to an invoice.
  • Steps proposed by Frisbii: To be validated, Validated, Sent, To be restarted, Cancelled. To be customized according to business needs
  • Can be used in automations.
Origin Picklist
  • Indicates the origin of the invoice (in the context of a subscription)
    • Ex-nihilo : Invoice not generated from a billing schedule, created ex-nihilo.
    • Schedule: Invoice from a billing schedule.
    • Regularisation: Billing Regularisation (please find more information here : Subscriptions - Billing regularisation.
  • Refers to a set of global values.
 ### Presentation ![](https://cdn.document360.io/b84e1b5d-2ba6-4465-8c62-fb45a2f31314/Images/Documentation/image-JCVWB1Z0.png?sv=2026-02-06&spr=https&st=2026-10-27T23%3A39%3A21Z&se=2026-10-28T00%3A39%3A21Z&sr=c&sp=r&sig=TpDP%2BI%2B%2BgzTLwcnbgYS4C6G0OfLVxJt8sX1Lqjp%2BuzE%3D) | **Subject** | Text Field | - To be filled in to be displayed as a title on the Invoice PDF. - Conditional field on the PDF template: if the field is empty, it will not be displayed on the PDF. | | --- | --- | --- | | **Special terms** | Text Area | - Allows you to fill in the special terms of the Invoice in order to display them on the PDF template. | | **Your Ref.** | Text Field | - Reference of the purchase order or signed estimate. | | **Comments** | Text Area | - Conditional field on the PDF template: if the field is empty, it will not be displayed. | | **Other Template** | Lookup | - Allows you to set up a different PDF template for the Invoice than the one entered in the Corporate Name. - This template will only be applied to this Invoice. | | **Show product details** | Checkbox | - Allows you to display the details of the products on the PDF of the Invoice. - **Attention :** the Description field must be filled in the Product linked to the Invoice Line of the concerned Invoice. | | **Show detailed description** | Checkbox | - Allows you to display the details of the products on the PDF of the Invoice. - **Attention :** the *Detailed Description* field must be filled in the Invoice Line of the concerned Invoice | | **Show percentage** | Checkbox | - Displays the percentage applied to the Invoice Lines on the Invoice PDF (this field concerns partial invoicing). | | **Show discount** | Checkbox | - If this box is checked, the Discount Rate is displayed as a column in the main table of the Invoice. - From the Summer 21 release, checked by default for companies based in France, please see also: [Invoices - Mandatory information for invoicing from a french corporate name.](/frisbii-app/docs/en/factures-informations-obligatoires-en-france) | | **Show Bank Details** | Checkbox | - If this box is checked, the bank details entered in the Corporate Name tab will be displayed on the Invoice PDF. - From the Summer 21 release, checked by default for companies based in France, please see also: [Invoices - Mandatory information for invoicing from a french corporate name](/frisbii-app/docs/en/factures-informations-obligatoires-en-france) | ### Amounts, discounts and special conditions ![](https://cdn.document360.io/b84e1b5d-2ba6-4465-8c62-fb45a2f31314/Images/Documentation/image-PHI9YVND.png?sv=2026-02-06&spr=https&st=2026-10-27T23%3A39%3A21Z&se=2026-10-28T00%3A39%3A21Z&sr=c&sp=r&sig=TpDP%2BI%2B%2BgzTLwcnbgYS4C6G0OfLVxJt8sX1Lqjp%2BuzE%3D) | **Amount excl. VAT** | Roll-Up Summary | - Amount of the Invoice Line items, after application of the discounts. - 2 decimals. | | --- | --- | --- | | **Amount incl. VAT** | Formula (currency) | - Amount including VAT after all discounts on the Invoice. - Formula : Total before tax + Total other taxes + VAT amount after discount - 2 decimals. | | **VAT (%)** | Formula (percentage) | - VAT percentage of the Invoice. - The VAT rate is indicated on the Invoice Lines. - VAT amount after discount / VAT amount after discount. | | **VAT amount** | Formula (currency | - Resume the VAT field after any discounts on the Invoice. - If the box *Old VAT calculation* is checked : - VAT amount (rows) * (1-Footer discount rate) | | **Bottom line discount rate** | Text Field | - Indicates the bottom line discount applied on the Invoice | | **Discount reason** | Text Field | - Reason for a discount at the bottom of the page. - Field included in the PDF of the Invoice. - From the Summer 21 release, not displayed if the Bottom line discount rate field is blank. | | **Discount amount** | Formula (currency) | - Sum of the discount defined on the Invoice Line items (line discount + bottom line discount) - 2 decimals. | | **Discount Amount (Lines** | Roll-Up Summary | - Sum of the discount amounts of the Invoice Lines. - 2 decimals. | | **Discount total** | Formula (currency) | - Total discount amount of the Invoice. - Sum of the discount defined on the Invoice Line items and the bottom line discount of the Invoice. - 2 decimals. | | **Discount total (%)** | Formula (percentage) | - Indicates the discount rate taking into account the footer discount and the line discount. - If Amount before all discounts = 0, then 0% is displayed - Otherwise: Total discount/ Amount before all discounts. | | **Amount excl. VAT before discounts** | Roll-Up Summary | - Sum of the amounts of the Invoice Line items before any discount. - 4 decimal places. | | **Amount excl. VAT after discounts** | Formula (currency) | - Amount after discount. - Total amount before all discounts - Total discount - 2 decimals | ### Recovery From Summer '21 release, this tab is only displayed when the invoice is issued. ![](https://cdn.document360.io/b84e1b5d-2ba6-4465-8c62-fb45a2f31314/Images/Documentation/image-ACEZTFJF.png?sv=2026-02-06&spr=https&st=2026-10-27T23%3A39%3A21Z&se=2026-10-28T00%3A39%3A21Z&sr=c&sp=r&sig=TpDP%2BI%2B%2BgzTLwcnbgYS4C6G0OfLVxJt8sX1Lqjp%2BuzE%3D) | **Age** | Formula (number) | - Age of the Invoice. - Takes into account: Date of invoice, Date of last payment, Due date. | | --- | --- | --- | | **% Paid** | Formula (percentage) | - Percentage paid of the invoice amount. - Formula: - If the Omitted box is checked - the percentage paid is considered as 100%. - If the Omitted box is not checked - and the Total including VAT is higher than 0€. - (Cumulative settlements + Cumulative charges)/ Total including VAT - 2 decimals. | | **Force Invoice Balance** | Checkbox | - Allows you to force the balance of an Invoice, independently of the Payments. | | **Reason for Clearing Invoice** | Text Area | - This is why the Invoice is marked as cleared. | | **Omitted** | Checkbox | - If the box is checked, the Invoice or Credit note will not be taken into account in the reports and dashboards. | | **Debt Collection** | Formula (Text) | - Indicates the progress of the payment of the Invoice (progress bar). | | **Balance Due** | Formula (Currency) | - Payment amount expected on the Invoice. - Formula: - If the *Force Invoice Balance* check box is checked - or the invoice is in *draft* - 0€ is displayed - If the check box *Force Invoice Balance* is not checked - and the invoice is *issued* - Total including VAT - Accumulated payments - Accumulated charges | | **Payable Balance Due** | Roll-Up Summary | - Indicates the amount of Payment due on the Invoice. - Sum of the Pending and Due Payment amount | | **Payment Due on** | Date Field | - Date on which the next payment is expected. - Automatically filled in by the due date, if empty when the Invoice is issued. - Value taken into account in the automated dunning process. - Here is an article on this subject: [Automation - Dunning: fields](/frisbii-app/docs/en/automatisation-relance-ajout-des-champs) | | **Last Payment Date** | Roll-Up Summary | - Date of the last payment received for the Invoice. - If the *Pending* box is not checked in the Payment. | | **Next Expected Payment Date** | Roll-Up Summary | - Date of next payment of the Invoice (according to schedule). - If the *Pending* box is checked on the Payment. | | **Last Dunning Date** | Date | - Date of the last reminder on the Invoice. - Field to be filled in by the automatic dunning process. - This field can also be used to store information for manual dunning. | | **Dunning Level** | Picklist | - Indicates the steps of the dunning performed. - By default: - R0 : no incident - R1 : 1st e-mail sent - R2 : 2nd e-mail sent - R3 : 3rd e-mail sent (last reminder before formal notice) - R4 : formal notice - Here is an article on this subject: [Automation - Dunning: fields](/frisbii-app/docs/en/automatisation-relance-ajout-des-champs) | | **Cumulated Payments** | Roll-Up Summary | - Accumulation of Payment on the Invoice. - The *Pending* checkbox is not checked in the Payment. - 2 decimals. | ### Related objects ![](https://cdn.document360.io/b84e1b5d-2ba6-4465-8c62-fb45a2f31314/Images/Documentation/image-MLJVTC4G.png?sv=2026-02-06&spr=https&st=2026-10-27T23%3A39%3A21Z&se=2026-10-28T00%3A39%3A21Z&sr=c&sp=r&sig=TpDP%2BI%2B%2BgzTLwcnbgYS4C6G0OfLVxJt8sX1Lqjp%2BuzE%3D)

Quotation

Lookup

  • Displays the quotation related to this invoice.
OpportunityLookup
  • Displays the opportunity related to this invoice.
Accounting dataLookup
  • Displays the accounting data related to this invoice.
Initial InvoiceLookup
  • Only displayed if the invoice is a credit note
  • The initial invoice links to the invoice on which the credit note was created.
SubscriptionLookup
  • Subscription linked to this invoice.
Start DateDate
  • Start date of the subscription linked to this Invoice.
End DateDate
  • End date of the subscription linked to this Invoice.
 ## Fields to be added on the page layout if needed If you want to add fields in this page, please follow the steps here: [User interface - The new dynamic page layouts and how to change them from Summer '21](/articles/en_US/Knowledge/User-interface-new-dynamic-page-layouts-and-how-to-change-them-from-Summer-21) . | **Accurate amount incl. tax** | Formula (Currency) | - Precise amount including VAT (after any discounts on the Invoice). - 4 decimal places. | | --- | --- | --- | | **Accurate total VAT after all discounts** | Formula (Currency) | - Precise VAT amount (after any discounts on the Invoice). - 4 decimal places. | | **Automatic Issuance** | Checkbox | - Used in the automations. - If the box is checked, the invoice is issued automatically. - Here is an article on this subject: [Automation - Invoices issuance](/frisbii-app/docs/en/automatisation-emission-des-factures) | | **Automatic Dunning** | Checkbox | - Used in the automations. - If the box is checked, the dunning is done on the Invoice. - Here is an article on this subject: [Automation - Dunning: fields](/frisbii-app/docs/en/automatisation-relance-ajout-des-champs) | | **Amount excl. VAT (Lines)** | Roll-Up Summary | - Sum of the amounts of the Invoice Lines. - Before footer discount. - 2 decimals. | | **Coefficient** | Number | - This field is used to calculate the amounts. - If it is a Credit note, the calculation is made with a coefficient of "-1". - If it is an Invoice, the calculation is made with a coefficient of "1". | | **Credit Note?** | Formula (Checkbox) | - Indicates if the Invoice is of type Credit Note. - Useful for filters in list views on the Invoice object. | | **Cumulated Apportionments** | Currency | - The sum of payments that are not pending on the credit. | | **Customer** | Lookup | - Allows you to display a second account on the Invoice / Invoice PDF. - Useful, for example, if you have a final customer and a paying customer. | | **Discount (%)** | Formule (Percent) | - Discount rate applied on the Invoice. - 2 decimal places. | | **Draft Invoice** | Formula (Checkbox) | - Indicates if the Invoice Status is Draft. | | **Duplicate** | Checkbox | - Allows to display on the PDF of the invoice if it is a duplicate (PDF created on an issued invoice). | | **External ID** | Text Field | - If the Invoice is associated with a record in a third party system, you can fill in the Invoice ID from that third party system here. | | **Forecast Invoice Amount excl. VAT** | Formula (Currency) | - Displays the amount before tax if the Invoice is in draft. - Used for the Billing Plan on the Quotation or Opportunity. - 2 decimals. | | **Incl. VAT (Old Calculation)** | Checkbox | - Summary of cumulative amounts before tax after discount, old calculation method less accurate than the one implemented from Spring '20. | | **Index (ID)** | Formula (Text) | - Index identification code, if the Invoice is linked to a Subscription. | | **Index Coefficient to Date** | Number | - Value of the index coefficient, at a specific date. | | **Index date** | Date | - Date used to calculate the index value (index revision). | | **Invoice Date Index** | Lookup | - Index taken into account on the Invoice, at a precise date. | | **Invoicing Period (Days)** | Number | - Number of days of the period during which the Invoice is taken into account. | | **Issueable** | Formula (Checkbox) | - Conditions for issuing the Invoice. - Used in the automations. - Formula: - If the invoice is in draft - and - Either there is no subscription linked to the invoice - Or the subscription is activated | | **Issued Invoice** | Formula (Checkbox) | - Indicates if Invoice Status is Issued. | | **Issued Invoice Amount** | Formula (Currency) | - Displays the amount before tax if the Invoice is issued. - Used for the Billing Plan on the Quotation or Opportunity. - 2 decimals. | | **Language** | Picklist | - By putting this tag *language="{!sofactoapp__Client_Invoices__c..sofactoapp__Language__c}"* in your Invoice template, the language chosen on the Invoice will be applied to PDFs created from this Invoice. - **Attention:** Like VAT, the language can be configured at several levels (inheritance). You can also configure it at the level of the Account, the Accounting Data, the Corporate Name or the Quotation. | | **Late** | Formula (Checkbox) | - Indicates if the Invoice is overdue. - Formula: - If - Either the due date is less than today - Or the expected payment date is less than today - And - The balance was not Forced on the Invoice - The Invoice is issued - The Invoice is not of the Credit type | | **Ledger Entry** | Lookup | - Record the accounting entries related to this Invoice. | | **Locked Invoice** | Checkbox | - Indicates whether the Invoice is locked. | | **Number of Lines with Percentage** | Roll-Up Summary | - Number of Invoice Lines with a percentage applied. - Different from 100% applied. | | **Number of PDF Invoices** | Roll-Up Summary | - Number of Invoice PDFs generated on the Invoice. | | **Other Bank Details** | Lookup | - Allows you to add other bank details than those set by default in the Corporate Name. - These bank details will only be applied to this Invoice. | | **Paid** | Checkbox | - Indicates if the invoice is balanced. - Checked if the balance due is equal to 0. | | **Paid Invoice?** | Formula (Checkbox) | - Indicates if the amount of the Invoice is fully paid. - Checked if the invoice is issued and the balance is 0€. | | **Payment Schedule** | Lookup | - Allows you to link a Payment Schedule. - Here is an article on this subject: [Payment schedule - generating a payment schedule](/frisbii-app/docs/en/echéanciers-générer-un-échéancier-de-règlement) | | **Percentage** | Percent | - Invoiced percentage (of the Invoice). | | **PDF reference** | Lookup | - Registration number of the Invoice PDF. - Automatically filled in after saving the PDF. | | **Price Book** | Lookup | - Displays the price book related to this Invoice. | | **Product Configuration** | Lookup | - Indicates the product configuration possibly applied on the Invoice. | | **Record Name** | Auto Number | - Number used by Frisbii to identify the Invoice. - Chronological numbering. | | **Recurring Invoice** | Formula (Checkbox) | - Indicates whether the Invoice is from a Subscription. | | **Regularise Payments?** | Formula (Checkbox) | - Allows you to update the Payment on the Invoice. - The box is checked if : - Balance not due is different from this accumulation: - Total including VAT - Accumulated settlements - Balance due due - Accumulated charges | | **Show Percentage** | Formula (Checkbox) | - Displays on the Invoice PDF the percentage applied to the Invoice Line items. | | **Unmatured Balance Due** | Roll-Up Summary | - Balance of the invoice still to be paid. - The *Pending* box is checked in Payment. - Payment Due is not checked in Payment. | | **VAT Amount before Discount** | Roll-Up Summary | - VAT amount of the Invoice Line items. 4 decimal places. | | **VAT total after all discounts** | Formula (Currency) | - Total amount of VAT, once discounts are applied. | ### Frisbii API package extension fields These fields are only available if Frisbii Support France has set you up with the Frisbii API extension package in order to use Stripe or Frisbii Payments payment methods. | **Payment URL** | Text area | - Entered by Stripe or Frisbii Pay - [Frisbii Pay - Change your custom Invoice PDF Template](/frisbii-app/docs/en/frisbii-pay-modèles-pdf-de-facture) | | --- | --- | --- |