Custom field mapping

Prev Next

The XML invoice is generated from values contained in the sofactoapp__ or fiix__ fields, when these come from the Frisbii e-invoice extension package.

If your business needs require custom fields to store business information that appears on your invoices, you can use the Frisbii mapping interface to configure custom mappings. This mapping feeds the CII tags with your own Salesforce fields.

Accessing the configuration page

From the Salesforce App Launcher, search for and open EInvoicing Mappings.

Here are the prerequisites for accessing the mapping interface:

  • Have a Frisbii Admin license

  • Be a Salesforce System Admin for the org or have the following necessary permissions:

    • At the profile level or within a set of permissions, have the system permission “Customize Application,” which requires the system permissions “View Setup and Configuration,” “Manage Translation,” and “Manage Custom Permissions.”

How to configure a mapping

  1. Identify the tag you want to customize by its XML Key or BT-Code (e.g., BT-22 for the invoice note).

  2. Click the magnifying glass next to the relevant row to search for your custom Salesforce field. Next to the magnifying glass, the default-mapped sofactoapp__ or fiix__ field is shown.

  3. Search for and select the field from the results list. You can traverse up to 5 objects to find your custom field.

  4. Check Active to enable the mapping.

  5. Repeat for each tag you want to customize.

  6. Click Save.

Additional information:

The "Fixed value" column lets you enter a hardcoded value into the XML. This value will always be used in your XML invoices.

The icon shows details about the standard mapping.

The icon shows the XML Xpath. This is useful for testing the content of your e-invoices.

💡 This table should only be used for specific needs — to cover CII tags not mapped by default, or to override the default values assigned by the sofactoapp__ or fiix__ fields.

Field correspondence table: CII ↔ Frisbii

This table lists all fields covered by Frisbii e-invoice in the CII (Cross Industry Invoice) Extended XML format. It's the reference for understanding where each piece of data in the XML file comes from, validating your tests, and configuring custom mappings via EInvoicing Mappings.

Column legend:

  • Used by Frisbii: the field is mapped by default via sofactoapp__ or fiix__ fields

  • Mapping possible: the field can be overridden with your own custom fields via the EInvoicing Mappings page

  • Duplication possible: the field can appear multiple times in the same XML file (e.g., multiple notes, multiple item attributes)

  • Required by standard: the field is mandatory under the EN 16931 standard / DGFiP specifications

  • Packaged version: the version of the Frisbii e-invoice package from which the field is available

EXCHANGED DOCUMENT CONTEXT

ID

Business terms

Description

Used by Frisbii

Mapping possible

Duplication possible

Required by standard

Frisbii object

Frisbii fields

XPath

Version

Comments

BT-1

Invoice number

Unique reference of the Invoice

Yes

Yes

-

Yes

Invoice

sofactoapp__Reference__c

/rsm:CrossIndustryInvoice /rsm:ExchangedDocument /ram:ID

0.1

BT-3

Type de facture en code

Code identifying the document type

Yes

Yes

-

Yes

-

Frisbii covers: 380: Commercial invoice / 381: Credit note / 386: Down payment invoice

/rsm:CrossIndustryInvoice /rsm:ExchangedDocument /ram:TypeCode

0.1

389: Self-billing invoice / 261: Self-billing credit note - to be covered via custom mapping

BT-2

Invoice issue date

Yes

-

-

Yes

-

Invoice date: sofactoapp__Date_de_facture__c

/rsm:CrossIndustryInvoice /rsm:ExchangedDocument /ram:IssueDateTime

0.1

BT-21

Invoice note subject code

Coded note subject

Yes

Yes

Yes

-

-

Default value AAI for General information

/rsm:CrossIndustryInvoice /rsm:ExchangedDocument /ram:IncludedNote /ram:SubjectCode

0.15

Can be duplicated. List of codes: https://service.unece.org/trade/untdid/d24a/tred/tred4451.htm

BT-22

Invoice note*

Unstructured comment relating to the invoice as a whole

Yes

Yes

Yes

Yes

Invoice

sofactoapp__Commentaires__c

/rsm:CrossIndustryInvoice /rsm:ExchangedDocument /ram:IncludedNote /ram:Content

0.15

Eco-participation fee, eco-contribution, etc. Can be duplicated

BT-23

Business process type identifier

Identifies the business process context. Allows the Buyer to process the Invoice appropriately.

Yes

Yes

-

Yes

-

Default value S1: Submission of a service invoice

/rsm:CrossIndustryInvoice /rsm:ExchangedDocumentContext /ram:BusinessProcessSpecifiedDocumentContextParameter /ram:ID

0.13

BT-26

Preceding Invoice issue date

Date on which the preceding invoice was issued.

Yes

-

-

-

Invoice

For a Credit Note, corresponds to the issue date of the original invoice.

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction

/ram:ApplicableHeaderTradeSettlement

/ram:InvoiceReferenceDocument

/ram:FormattedIssueDateTime

/qdt:DateTimeString

0.18

To be used in the following cases: correction of a previous invoice, final invoice referencing previous partial invoices, final invoice referencing previous prepayment invoices.

*WARNING: The BT-22 and BT-21 forms must be duplicated three times and must be mapped with the following information:

  • BT-22: Late Payment Penalty - Object: Company Name - sofactoapp__P_nalit_s_en_cas_de_retard__c

  • BT-21: PMD

  • BT-22: Discount Terms - Object: Company Name - sofactoapp__ConditionsEscompte__c

  • BT-21: AAB

  • BT-22: Collection Fees Note: No fields available in Frisbii. You can either create a new field to hold your collection fee note, or you can enter the text directly in the “fixed value” column.

  • BT-21: PMT

By default, Frisbii maps to the sofactoapp__Comments__c field on the invoice.
It is up to you to take the necessary steps to map the information listed above.

INVOICE LINE

ID

Business terms

Description

Used by Frisbii

Mapping possible

Duplication possible

Required by standard

Frisbii object

Frisbii fields

XPath

Version

Comments

BT-126

Invoice line identifier

Unique identifier of a line within the Invoice

Yes

-

-

Yes

-

Invoice line name: name

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:IncludedSupplyChainTradeLineItem /ram:AssociatedDocumentLineDocument /ram:LineID

0.1

EXT-FR-FE-183

Invoice line note subject code

Coded note subject

-

Yes

Yes

-

-

Default value AAI for General information

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:IncludedSupplyChainTradeLineItem /ram:AssociatedDocumentLineDocument /ram:IncludedNote /ram:SubjectCode

0.15

Can be duplicated

BT-127

Invoice line note

Unstructured comment relating to the invoice line

-

Yes

Yes

-

-

-

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:IncludedSupplyChainTradeLineItem /ram:AssociatedDocumentLineDocument /ram:IncludedNote /ram:Content

0.15

Can be duplicated

ITEM INFORMATION

ID

Business terms

Description

Used by Frisbii

Mapping possible

Duplication possible

Required by standard

Frisbii object

Frisbii fields

XPath

Version

Comments

BT-153

Item name

Yes

Yes

-

Yes

LDF

Designation: sofactoapp__Description__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:IncludedSupplyChainTradeLineItem /ram:SpecifiedTradeProduct /ram:Name

0.1

BT-154

Item description

Presents the item in more detail than the Name

Yes

Yes

-

-

LDF

Detailed description: sofactoapp__Description_detaillee__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:IncludedSupplyChainTradeLineItem /ram:SpecifiedTradeProduct /ram:Description

?

BT-160

Item attribute name

Example: colour

-

Yes

Yes

-

-

-

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:IncludedSupplyChainTradeLineItem /ram:SpecifiedTradeProduct /ram:ApplicableProductCharacteristic /ram:Description

0.15

Can be duplicated

BT-161

Item attribute value

Example: red

-

Yes

Yes

-

-

-

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:IncludedSupplyChainTradeLineItem /ram:SpecifiedTradeProduct /ram:ApplicableProductCharacteristic /ram:Value

0.15

Can be duplicated

NET UNIT PRICE

ID

Business terms

Description

Used by Frisbii

Mapping possible

Duplication possible

Required by standard

Frisbii object

Frisbii fields

XPath

Version

Comments

BT-146

Net price of the item

Net price after discount applied to the item price

Yes

Yes

-

Yes

LDF

Unit price after discount: sofactoapp__Prix_unitaire_HT_apres_remise__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:IncludedSupplyChainTradeLineItem /ram:SpecifiedLineTradeAgreement /ram:NetPriceProductTradePrice /ram:ChargeAmount

0.1

BT-148

Gross price of the item

Unit price excluding VAT before discount

Yes

Yes

-

-

LDF

Unit price excl. VAT: sofactoapp__Prix_Unitaire_HT__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:IncludedSupplyChainTradeLineItem /ram:SpecifiedLineTradeAgreement /ram:GrossPriceProductTradePrice /ram:ChargeAmount

0.1

BT-129

Invoiced quantity

Number of items taken into account in the Invoice line

Yes

Yes

-

Yes

LDF

Quantity: sofactoapp__Quantit__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:IncludedSupplyChainTradeLineItem /ram:SpecifiedLineTradeDelivery /ram:BilledQuantity

0.1

BT-130

Unit of measure for the invoiced quantity

Unit of measure applicable to the invoiced quantity

-

Yes

-

Yes

-

-

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:IncludedSupplyChainTradeLineItem /ram:SpecifiedLineTradeDelivery /ram:BilledQuantity /@unitCode

-

LINE AMOUNT INFORMATION

ID

Business terms

Description

Used by Frisbii

Mapping possible

Duplication possible

Required by standard

Frisbii object

Frisbii fields

XPath

Version

Comments

BT-138

Allowance percentage applicable to the invoice line

Yes

Yes

-

-

LDF

Discount rate: sofactoapp__Taux_Remise__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:IncludedSupplyChainTradeLineItem /ram:SpecifiedLineTradeSettlement /ram:SpecifiedTradeAllowanceCharge /ram:CalculationPercent

0.1

BT-136

Amount of the allowance applicable to the invoice line

Amount of an allowance, excluding VAT

Yes

Yes

-

Yes

LDF

Allowance amount: sofactoapp__Montant_Total_Remise__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:IncludedSupplyChainTradeLineItem /ram:SpecifiedLineTradeSettlement /ram:SpecifiedTradeAllowanceCharge /ram:ActualAmount

0.1

BT-139

Reason for the allowance applicable to the invoice line

-

Yes

-

-

-

-

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:IncludedSupplyChainTradeLineItem /ram:SpecifiedLineTradeSettlement /ram:SpecifiedTradeAllowanceCharge /ram:Reason

-

BT-131

Invoice line net amount

Total net amount of the invoice line, including line-level allowances, charges, or fees

Yes

Yes

-

Yes

LDF

Net amount precise: sofactoapp__Montant_HT_precis__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:IncludedSupplyChainTradeLineItem /ram:SpecifiedLineTradeSettlement /ram:SpecifiedTradeSettlementLineMonetarySummation /ram:LineTotalAmount

0.1

SELLER (ISSUER)

ID

Business terms

Description

Used by Frisbii

Mapping possible

Duplication possible

Required by standard

Frisbii object

Frisbii fields

XPath

Version

Comments

BT-27

Seller's corporate name

Full official name under which the Seller is registered

Yes

Yes

-

Yes

RS

RS_Emise__c (on Invoice)

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:SellerTradeParty /ram:Name

0.1

BT-28

Seller's trading name

Name by which the Seller is known, other than the Corporate name

Yes

Yes

-

-

RS

Trading name: Enseigne__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:SellerTradeParty /ram:SpecifiedLegalOrganization /ram:TradingBusinessName

0.1

BT-29

Seller identifier

Seller's SIRET

Yes

Yes

-

-

RS

SIREN sofactoapp__SIREN__c + NIC sofactoapp__NIC__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:SellerTradeParty /ram:ID

0.1

BT-29-1

Scheme identifier (seller)

Yes

Yes

-

-

-

Default 0009 if BT-29 consists of the SIRET

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:SellerTradeParty /ram:GlobalID /@schemeID

0.1

BT-30

Seller's legal registration identifier

Seller's SIREN

Yes

Yes

-

Yes

RS

SIREN: RS_Siren_Emise__c (on Invoice)

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:SellerTradeParty /ram:SpecifiedLegalOrganization /ram:ID

0.4

BT-31

Seller's VAT identifier

Seller's intra-community VAT number

Yes

Yes

-

Yes

RS

Intra-community VAT: sofactoapp__TVA_intra__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:SellerTradeParty /ram:SpecifiedTaxRegistration /ram:ID

0.1

BT-32

Seller's tax identification

NIC

Yes

Yes

-

Yes

RS

NIC: sofactoapp__NIC__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:SellerTradeParty /ram:SpecifiedTaxRegistration /ram:ID

0.1

The NIC is included in the electronic invoice only if the BT-153 Intra-Community VAT form is blank.

BT-34

Seller's electronic address

Electronic billing address

Yes

Yes

-

Yes

RS

fiix__ElectronicBillingAddress__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:SellerTradeParty /ram:URIUniversalCommunication /ram:URIID

0.14

BT-34-1

Scheme identifier (seller)

Scheme identifier code

Yes

Yes

-

Yes

RS

fiix__SchemaIdentifierCode__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:SellerTradeParty /ram:URIUniversalCommunication /ram:URIID /@schemeID

0.14

Picklist: 0225 (default value), 0002, 0009

BT-38

Seller postal code

Yes

Yes

-

Yes

RS

Postal code: sofactoapp__RS_Code_postal_Emise__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:SellerTradeParty /ram:PostalTradeAddress /ram:PostcodeCode

0.1

BT-35

Seller address - Line 1

Yes

Yes

-

Yes

RS

Street: sofactoapp__RS_Rue_Emise__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:SellerTradeParty /ram:PostalTradeAddress /ram:LineOne

0.1

BT-37

Seller's city

City

Yes

Yes

-

Yes

RS

City: sofactoapp__RS_Ville_Emise__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:SellerTradeParty /ram:PostalTradeAddress /ram:CityName

0.1

BT-40

Seller country code

ISO 3166 standard

Yes

-

-

Yes

-

Prerequisite: enable Territories in Salesforce

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:SellerTradeParty /ram:PostalTradeAddress /ram:CountryID

0.1

BT-84

Bank account identifier

IBAN

Yes

Yes

-

-

Bank details

IBANID

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradeSettlementPaymentMeans /ram:PayeePartyCreditorFinancialAccount /ram:IBANID

0.1

BT-85

Bank account name

Name of the account into which the payment should be made

Yes

Yes

-

-

Bank details

Bank details name: Name

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradeSettlementPaymentMeans /ram:PayeePartyCreditorFinancialAccount /ram:AccountName

0.1

The name associated with the bank account is required. If the name is missing, fields BT-84 and BT-86 will remain blank.

BT-86

Financial institution identifier

BIC

Yes

Yes

-

-

RS

BIC: sofactoapp__BIC__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradeSettlementPaymentMeans /ram:PayeeSpecifiedCreditorFinancialInstitution /ram:BICID

0.1

BT-90

Creditor bank identifier

ICS - mandatory for SEPA direct debit

Yes

Yes

-

-

RS

ICS: sofactoapp__ICS__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:CreditorReferenceID

0.1

BUYER (CUSTOMER)

ID

Business terms

Description

Used by Frisbii

Mapping possible

Duplication possible

Required by standard

Frisbii object

Frisbii fields

XPath

Version

Comments

BT-46

Buyer identifier

Buyer's SIREN

Yes

Yes

-

Yes

1. DC / 2. Account

1. Linked DC: sofactoapp__SIREN_NIF__c / 2. Account: sofactoapp__SIREN_NIF__c / 3. If not filled in: first 9 digits of the SIRET (BT-47)

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:BuyerTradeParty /ram:ID

0.4

Resolution priority: DC then Account then SIRET extraction

BT-44

Buyer's corporate name

Buyer's full name

Yes

Yes

-

Yes

1. DC / 2. and 3. Account

1. DC: sofactoapp__Raison_sociale_facturation__c / 2. Account: sofactoapp__Raison_sociale_facturation__c / 3. Name of the Account

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:BuyerTradeParty /ram:Name

0.1

BT-47

Buyer's legal registration identifier

Buyer's SIRET

Yes

Yes

-

Yes

1. DC / 2. Account

1. DC: sofactoapp__SIRET__c / 2. Account: sofactoapp__SIRET__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:BuyerTradeParty /ram:SpecifiedLegalOrganization /ram:ID

0.4

BT-48

Buyer's VAT identifier

Buyer's intra-community VAT number

Yes

Yes

-

Yes

1. DC / 2. Account

1. DC: sofactoapp__TVA_intracommunautaire__c / 2. Account: sofactoapp__TVA_intra__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:BuyerTradeParty /ram:SpecifiedTaxRegistration /ram:ID

0.4

BT-56

Buyer contact point

Billing contact

Yes

Yes

-

-

Contact

Full name: Name of the Billing Contact

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:BuyerTradeParty /ram:DefinedTradeContact /ram:PersonName

0.1

BT-57

Buyer contact's phone number

Yes

Yes

-

-

Contact

Phone (office): Phone of the Billing Contact

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:BuyerTradeParty /ram:DefinedTradeContact /ram:TelephoneUniversalCommunication /ram:CompleteNumber

0.1

BT-58

Buyer contact's email address

Yes

Yes

-

-

1. Contact / 2. Account

1. Email: Email of the Billing Contact / 2. Email of the Account: email

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:BuyerTradeParty /ram:DefinedTradeContact /ram:EmailURIUniversalCommunication /ram:URIID

0.1

BT-53

Buyer postal code

Billing postal code

Yes

Yes

-

Yes

Account

BillingPostalCode

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:BuyerTradeParty /ram:PostalTradeAddress /ram:PostcodeCode

0.1

BT-50

Buyer address - Line 1

Billing address

Yes

Yes

-

Yes

Account

BillingStreet

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:BuyerTradeParty /ram:PostalTradeAddress /ram:LineOne

0.1

BT-52

Buyer's city

Billing city

Yes

Yes

-

Yes

Account

BillingCity

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:BuyerTradeParty /ram:PostalTradeAddress /ram:CityName

0.1

BT-55

Buyer's country code

ISO 3166 standard

Yes

-

-

Yes

Account

Prerequisite: enable Territories in Salesforce. BillingCountryCode

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:BuyerTradeParty /ram:PostalTradeAddress /ram:CountryID

0.1

BT-54

Buyer's country subdivision

Example: region, county, state, province, etc.

-

Yes

-

-

Account

Not mapped by Frisbii standard

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:BuyerTradeParty /ram:PostalTradeAddress /ram:CountrySubDivisionName

0.1

BT-49

Buyer's electronic address

Electronic billing address

Yes

Yes

-

Yes

1. DC / 2. Account

Global picklist: fiix__ElectronicBillingAddress__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:BuyerTradeParty /ram:URIUniversalCommunication /ram:URIID

0.14

BT-49-1

Scheme identifier (buyer)

Scheme identifier code

Yes

Yes

-

Yes

1. DC / 2. Account

fiix__SchemaIdentifierCode__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:BuyerTradeParty /ram:URIUniversalCommunication /ram:URIID /@schemeID

0.14

Picklist: 0225 (default value), 0002, 0009

ATTACHED DOCUMENT (attached PDF)

ID

Business terms

Description

Used by Frisbii

Mapping possible

Duplication possible

Required by standard

Frisbii object

Frisbii fields

XPath

Version

Comments

BT-125-1

Attached document MIME code

Permitted MIME codes: application/pdf, image/png, image/jpeg, text/csv, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.oasis.opendocument.spreadsheet

Yes

Yes

Yes

-

-

Invoice PDF Base64-encoded if isPdfToAttach = true. In a custom case, a 2nd attachment is added

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:AdditionalReferencedDocument /ram:AttachmentBinaryObject /@mimeCode

0.15

BT-125-2

File name of the attached document

Yes

Yes

Yes

-

-

-

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:AdditionalReferencedDocument /ram:AttachmentBinaryObject /@filename

0.15

BT-122

Supporting document identifier

Reference of the human-readable invoice PDF

Yes

Yes

Yes

-

-

-

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeAgreement /ram:AdditionalReferencedDocument /ram:IssuerAssignedID

0.15

BT-122-0

Type code

Default code 916

Yes

-

Yes

-

-

-

-

0.15

DELIVERY INFORMATION

ID

Business terms

Description

Used by Frisbii

Mapping possible

Duplication possible

Required by standard

Frisbii object

Frisbii fields

XPath

Version

Comments

BT-78

Delivery postal code

Yes

Yes

-

-

Account

ShippingPostalCode

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeDelivery /ram:ShipToTradeParty /ram:PostalTradeAddress /ram:PostcodeCode

0.1

BT-75

Delivery address - Line 1

Yes

Yes

-

-

Account

ShippingStreet

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeDelivery /ram:ShipToTradeParty /ram:PostalTradeAddress /ram:LineOne

0.1

Optional under the standard, mandatory if different from the billing address

BT-77

Delivery city

City

Yes

Yes

-

-

Account

ShippingCity

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeDelivery /ram:ShipToTradeParty /ram:PostalTradeAddress /ram:CityName

0.1

BT-79

Country subdivision (delivery)

Example: region, county, state, province, etc.

-

Yes

-

-

Account

Not mapped by Frisbii standard

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeDelivery /ram:ShipToTradeParty /ram:PostalTradeAddress /ram:CountrySubDivisionName

0.1

BT-80

Delivery country code

ISO 3166 standard

Yes

-

-

-

Account

Prerequisite: enable Territories in Salesforce. ShippingCountryCode

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeDelivery /ram:ShipToTradeParty /ram:PostalTradeAdress /ram:CountryID

0.1

BT-72

Actual delivery date

Date on which the delivery takes place

Yes

Yes

-

-

Invoice

sofactoapp__Date_de_livraison__c

sofactoapp__Date_de_livraison__c

0.23

The delivery date is required if VAT is exempt on the grounds of an intra-Community delivery.

BT-5

Invoice currency code

Currency in which all amounts are expressed (except the VAT total in the accounting currency)

Yes

-

-

Yes

-

Invoice currency

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:InvoiceCurrencyCode

0.1

VAT AND ALLOWANCES AT DOCUMENT LEVEL

ID

Business terms

Description

Used by Frisbii

Mapping possible

Duplication possible

Required by standard

Frisbii object

Frisbii fields

XPath

Version

Comments

BT-117

Tax amount for the VAT category

Total VAT amount for a given category

Yes

-

-

Yes

Invoice

VAT 10%: sofactoapp__TVA_10_0__c / VAT 2.1%: sofactoapp__TVA_2_1__c / VAT 20%: sofactoapp__TVA_20_0__c / VAT 5.5%: sofactoapp__TVA_5_5__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:ApplicableTradeTax /ram:CalculatedAmount

0.1

BT-116

VAT category taxable amount

Sum of the net amount of lines, minus allowances, plus charges subject to this rate

Yes

-

-

Yes

Invoice

Total VAT: sofactoapp__Montant_TVA_apres_remise__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:ApplicableTradeTax /ram:BasisAmount

0.1

BT-118

VAT category code

S = Standard rate (2.1%, 5.5%, 10%, 20%) / E = Exempt / AE = Reverse charge / K = Intra-community supply / G = Export outside the EU / O = Outside VAT scope / L = Canary Islands / M = Ceuta and Melilla

Yes

-

-

Yes

LDF

S = Standard VAT + custom DOM-TOM 8.5% / E = VAT-exempt legal entity / AE = sofactoapp__Exon_ration_Vat__c: Reverse charge / K = sofactoapp__Exon_ration_Vat__c: Intra-community supply / G = sofactoapp__Exon_ration_Vat__c: Exports outside the EU / Z, O, L, M = not applicable in France

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:ApplicableTradeTax /ram:CategoryCode

0.1

BT-120

Reason for VAT exemption

Statement explaining why an amount is exempt

Yes

-

-

-

LDF

VAT exemption: sofactoapp__Exon_ration_Vat__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:ApplicableTradeTax /ram:ExemptionReason

0.1

BT-94

Document-level allowance percentage

Yes

-

-

-

Invoice

Footer discount rate: sofactoapp__Discount_rate__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradeAllowanceCharge /ram:CalculationPercent

0.1

BT-92

Amount of the document-level allowance

Amount of a footer allowance, excluding VAT

Yes

-

-

Yes

Invoice

Allowance amount: sofactoapp__Discount_description__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradeAllowanceCharge /ram:ActualAmount

0.1

BT-97

Reason for the document-level allowance

Yes

-

-

-

Invoice

Reason for the allowance: sofactoapp__Discount_description__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradeAllowanceCharge /ram:Reason

0.1

BT-95

VAT category code of the document-level allowance

Same codes as BT-118

Yes

-

-

Yes

RS

Same values and mappings as BT-118

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradeAllowanceCharge /ram:CategoryTradeTax /ram:CategoryCode

-

BT-81

Payment means type code

Code list UNTDID 4461

-

Yes

-

-

-

Payment mode: sofactoapp__Payment_mode__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradeSettlementPaymentMeans /ram:TypeCode

-

Payment methods supported by Frisbii:

20: Check

30: Bank transfer

48: B+ Payments (one-time)

48: Stripe

48: Credit card

48: B+ Payments (recurring)

ZZZ: Other payment method

DOCUMENT TOTALS

ID

Business terms

Description

Used by Frisbii

Mapping possible

Duplication possible

Required by standard

Frisbii object

Frisbii fields

XPath

Version

Comments

BT-106

Sum of the net amount of the invoice lines

Yes

Yes

-

Yes

Invoice

Net amount after all allowances: sofactoapp__Montant_HT_apres_toutes_remises__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradeSettlementHeaderMonetarySummation /ram:LineTotalAmount

0.1

BT-107

Sum of document-level allowances

Yes

Yes

-

-

Invoice

Total allowance amount: sofactoapp__Total_remise__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradeSettlementHeaderMonetarySummation /ram:AllowanceTotalAmount

0.1

BT-109

Total invoice amount excluding VAT

Sum of net lines, minus document allowances, plus document charges

Yes

Yes

-

Yes

Invoice

Net amount precise after all allowances: sofactoapp__Montant_HT_precis_apres_toutes_remises__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradeSettlementHeaderMonetarySummation /ram:TaxBasisTotalAmount

0.1

BT-110

VAT Total amount

VAT invoice total amount

Yes

-

-

-

Invoice

Precise VAT total amount after all allowances: sofactoapp__Total_TVA_precis_apres_toutes_remises__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradeSettlementHeaderMonetarySummation /ram:TaxTotalAmount

0.17

BT-112

Total invoice amount including VAT

Must be >= 0

Yes

Yes

-

Yes

Invoice

Total incl. VAT precise: sofactoapp__Precise_Amount_VAT__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradeSettlementHeaderMonetarySummation /ram:GrandTotalAmount

0.1

BT-115

Amount due

Total including VAT minus amount paid in advance. Zero if the invoice is fully paid.

Yes

Yes

-

Yes

Invoice

On a Balance invoice: Total incl. VAT: sofactoapp__Amount_VAT__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradeSettlementHeaderMonetarySummation /ram:DuePayableAmount

0.1

BT-113

Amount paid

Sum of amounts paid in advance

Yes

Yes

-

-

Invoice

Cumulative payments: sofactoapp__R_glements_cumul_s__c / On a Balance invoice: sofactoapp__TotalAcompteTTC__c + sofactoapp__R_glements_cumul_s__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradeSettlementHeaderMonetarySummation /ram:TotalPrepaidAmount

0.16

Balance invoice

BT-20

Payment terms

Textual description of the terms, including penalties

Yes

Yes

-

-

Invoice

Payment terms: sofactoapp__Delai_paiement__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradePaymentTerms /ram:Description

0.1

BT-9

Due date

Date on which the payment is due

Yes

Yes

-

Yes

Invoice

Due date: sofactoapp__Ech_ance__c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradeSettlement /ram:SpecifiedTradePaymentTerms /ram:DueDateDateTime /udt:DateTimeString

0.1

BT-25

Preceding invoice number

Identification of an Invoice previously sent by the Seller

Yes

Yes

-

Yes

Invoice

Credit Note Type: sofactoapp__Facture_Initiale_c

/rsm:CrossIndustryInvoice /rsm:SupplyChainTradeTransaction /ram:ApplicableHeaderTradceSettlement
/ram:InvoiceReferencedDocument
/ram:IssuerAssignedID

0.18