Field Mappings for Sales Credit Note to Electronic Invoice

When you send an Accounting sales credit note as an electronic invoice, Certinia converts it to an internal structured data format before passing it to Storecove. Storecove receives the document and converts it to the format required by the recipient.

The table below shows how fields on a sales credit note are mapped to the internal format, and then to Storecove. Some fields are populated with hard-coded values. You can also configure the field mappings. For more information on how to configure the sales credit note field mappings, see Managing Field Mappings for Sales Credit Note to Electronic Invoice.

Header Field Mapping

The table below lists the header field mappings. Some fields are populated with hard-coded values.

Warnings: Do not change the default mappings that are marked as "(Managed)". If you override them it will break the integration with Storecove.
Note:
  • Unsupported fields are not supported for the Certinia Spring 2023 release.
  • In addition to the listed unsupported fields in this release, Storecove might include further fields which cannot be mapped until a later Certinia release.

Sales Credit Note

ElectronicInvoicingService.Document

Storecove InvoiceSubmission

Notes
<not mapped, but available for mapping to a custom field>

-

invoice.taxSystem

Hard-coded to either 'tax_line_percentages' or 'tax_no_tax', depending on whether there is any tax information.
<not mapped, but available for mapping to a custom field>

AccountingCostCentre

invoice.accountingCost

c2g__Account__c

AccountingCustomerParty.AccountId

invoice.accountingCustomerParty.accountId

c2g__Account__r.Name

AccountingCustomerParty.CompanyName

invoice.accountingCustomerParty.party.companyName

c2g__Account__r.c2g__CODAFinanceContact__c

AccountingCustomerParty.ContactId

invoice.accountingCustomerParty.party.contact.id

c2g__Account__r.c2g__CODAFinanceContact__r.Name

AccountingCustomerParty.ContactName

invoice.accountingCustomerParty.party.contact.lastName

c2g__Account__r.c2g__CODAInvoiceEmail__c

AccountingCustomerParty.EmailAddress

invoice.accountingCustomerParty.party.contact.email

c2g__Account__r.BillingStreet

AccountingCustomerParty.PostalAddress.AddressLine1

invoice.accountingCustomerParty.party.contact.address.street1

<not mapped, but available for mapping to a custom field>

AccountingCustomerParty.PostalAddress.AddressLine2

invoice.accountingCustomerParty.party.contact.address.street2

c2g__Account__r.BillingCity

AccountingCustomerParty.PostalAddress.CityName

invoice.accountingCustomerParty.party.contact.address.city

c2g__Account__r.BillingCountry

AccountingCustomerParty.PostalAddress.Country

-

c2g__Account__r.c2g__CODAECCountryCode__c

AccountingCustomerParty.PostalAddress.CountryIdentificationCode

invoice.accountingCustomerParty.party.contact.address.country

<not mapped, but available for mapping to a custom field>

AccountingCustomerParty.PostalAddress.County

invoice.accountingCustomerParty.party.contact.address.county

c2g__Account__r.BillingPostalCode

AccountingCustomerParty.PostalAddress.PostalCode

invoice.accountingCustomerParty.party.contact.address.zip

c2g__Account__r.fferpcore__AccountExtension__r[0].fferpcore__EInvoicingAddressIdentifier__c

AccountingCustomerParty.PublicIdentifiers[0].Id

invoice.accountingCustomerParty.publicIdentifiers[0].id

c2g__Account__r.fferpcore__AccountExtension__r[0].fferpcore__EInvoicingSchemeID__c

AccountingCustomerParty.PublicIdentifiers[0].Scheme

invoice.accountingCustomerParty.publicIdentifiers[0].scheme

c2g__Account__r.c2g__CODAVATRegistrationNumber__c

AccountingCustomerParty.PublicIdentifiers[1].Id

invoice.accountingCustomerParty.publicIdentifiers[1].id

c2g__Account__r.c2g__CODAECCountryCode__c

AccountingCustomerParty.PublicIdentifiers[1].Scheme

invoice.accountingCustomerParty.publicIdentifiers[1].scheme

Country code is used to work out the appropriate scheme for a VAT identifier for this country (in Accounting code)

c2g__Account__r.Phone

AccountingCustomerParty.Telephone

invoice.accountingCustomerParty.party.contact.phone

<not mapped, but available for mapping to a custom field>

AccountingSupplierParty.ContactName

invoice.accountingSupplierParty.party.contact.lastName

c2g__OwnerCompany__r.c2g__ContactEmail__c

AccountingSupplierParty.EmailAddress

invoice.accountingSupplierParty.party.contact.email

c2g__OwnerCompany__r.c2g__Phone__c

AccountingSupplierParty.Telephone

invoice.accountingSupplierParty.party.contact.telephone

<not mapped, but available for mapping to a custom field>

AllowanceCharges

invoice.allowanceCharges

<not mapped, but available for mapping to a custom field>

Attachments

attachments

Unsupported field
<not mapped, but available for mapping to a custom field>

BillingReference

invoice.billingReference

<not mapped, but available for mapping to a custom field>

ConsumerTaxMode

invoice.consumerTaxMode

Hardcoded as 'false'
<not mapped, but available for mapping to a custom field>

ContractDocumentReference

invoice.contractDocumentReference

<not mapped, but available for mapping to a custom field>

CreatePrimaryImage

createPrimaryImage

Hard coded as 'true'

c2g__CustomerReference__c

CustomerOrderReference

invoice.orderReference

c2g__CustomerReference__c

CustomerReference

invoice.buyerReference

<not mapped, but available for mapping to a custom field>

Delivery.ActualDate

invoice.delivery.actualDate

<not mapped, but available for mapping to a custom field>

Delivery.Location.Id

invoice.delivery.location.id

<not mapped, but available for mapping to a custom field>

Delivery.Location.SchemeAgencyId

invoice.delivery.location.schemeAgencyId

<not mapped, but available for mapping to a custom field>

Delivery.Location.SchemeId

invoice.delivery.location.schemeId

<not mapped, but available for mapping to a custom field>

Delivery.Quantity

invoice.delivery.quantity

<not mapped, but available for mapping to a custom field>

DeliveryAddress

invoice.delivery.location.address

c2g__Currency__c

DocumentCurrencyCode

invoice.documentCurrencyCode

c2g__EInvoiceIdentifier__c

DocumentIdentifier

idempotencyGuid

c2g__InvoiceTotal__c

DocumentTotal

invoice.amountIncludingVat

Amount is negated.

c2g__DueDate__c

DueDate

invoice.dueDate

Name

InvoiceNumber

invoice.invoiceNumber

<not mapped, but available for mapping to a custom field>

InvoicePeriod

invoice.invoicePeriod

c2g__CreditNoteDate__c

IssueDate

invoice.issueDate

c2g__OwnerCompany__r.c2g__EInvoicingLegalEntityID__c

LegalEntityId

legalEntityId

<not mapped, but available for mapping to a custom field>

Note

invoice.note

<not mapped, but available for mapping to a custom field>

PaymentMeans

invoice.paymentMeansArray

<not mapped, but available for mapping to a custom field>

PaymentTerms

invoice.paymentTerms

<not mapped, but available for mapping to a custom field>

PrepaidAmount

invoice.prepaidAmount

Amount is negated.
<not mapped, but available for mapping to a custom field>

ProjectReference

invoice.projectReference

c2g__Account__r.fferpcore__AccountExtensions__r[0].fferpcore__EInvoicingAddressIdentifier__c

Routing.EIdentifiers[0].Id

routing.eIdentifiers[0].id

This mapping is used in validation and should not be changed 

c2g__Account__r.fferpcore__AccountExtensions__r[0].fferpcore__EInvoicingSchemeID__c

Routing.EIdentifiers[0].Scheme

routing.eIdentifiers[0].scheme

This mapping is used in validation and must not be changed

c2g__Account__r.c2g__CODAVATRegistrationNumber__c

Routing.EIdentifiers[1].Id

routing.eIdentifiers[1].id

c2g__Account__r.c2g__CODAECCountryCode__c

Routing.EIdentifiers[1].Scheme

routing.eIdentifiers[1].scheme

Country code is used to work out the appropriate scheme for a VAT identifier for this country

c2g__Account__r.c2g__CODAInvoiceEmail__c

Routing.Emails[0]

routing.emails

<not mapped, but available for mapping to a custom field>

SalesOrderId

invoice.salesOrderId

c2g__CreditNoteDate__c

TaxPointDate

  

<not mapped, but available for mapping to a custom field>

TaxPointDate

invoice.taxPointDate

<not mapped, but available for mapping to a custom field>

TaxSubtotals

invoice.taxSubtotals

These are worked out automatically from the taxes on the lines.
<not mapped, but available for mapping to a custom field>

UblExtensions

invoice.ublExtensions

Line Field Mapping

The table below lists the line field mappings. Some fields are populated with hard-coded values.

Warnings: Do not change the default mappings that are marked as "(Managed)". If you override them it will break the integration with Storecove.
Note:
  • Unsupported fields are not supported for the Certinia Spring 2023 release.
  • In addition to the listed unsupported fields in this release, Storecove might include further fields which cannot be mapped until a later Certinia release.

Sales Invoice Line Item

ElectronicInvoicingService.DocumentLine

Storecove InvoiceLine

Notes

c2g__LineNumber__c

LineId

lineId

  

c2g__LineDescription__c

Description

description

  

c2g__Product__r.Name

ItemName

name

  

c2g__ProductCode__c

SellersItemIdentification

sellersItemIdentification

  

c2g__UnitPrice__c

UnitPrice

itemPrice

Value is negated.

c2g__Quantity__c

Quantity

quantity

  

c2g__NetValue__c

NetValue

amountExcludingVat

Amount is negated. Rounded to two decimal points.

c2g__TaxValue1__c

TaxBreakdown[0].Amount

taxes_duties_fees[0].amount

Amount is negated. Rounded to two decimal points.

c2g__OwnerCompany__r.c2g__ECCountryCode__c

TaxBreakdown[0].CountryIdentificationCode

taxes_duties_fees[0].country

  

c2g__TaxRate1__c

TaxBreakdown[0].Percent

taxes_duties_fees[0].percentage

Rounded to one decimal point.

c2g__OwnerCompany__r.EInvoicingTaxCategory__c

TaxBreakdown[0].TaxCode

taxes_duties_fees[0].category

  

c2g__TaxValue2__c

TaxBreakdown[1].Amount

taxes_duties_fees[1].amount

Amount is negated. Rounded to two decimal points.

c2g__OwnerCompany__r.c2g__ECCountryCode__c

TaxBreakdown[1].CountryIdentificationCode

taxes_duties_fees[1].country

  

c2g__TaxRate2__c

TaxBreakdown[1].Percent

taxes_duties_fees[1].percentage

Rounded to one decimal point.

c2g__OwnerCompany__r.EInvoicingTaxCategory__c

TaxBreakdown[1].TaxCode

taxes_duties_fees[1].category

  

c2g__TaxValue3__c

TaxBreakdown[2].Amount

taxes_duties_fees[2].amount

Amount is negated. Rounded to two decimal points.

c2g__OwnerCompany__r.c2g__ECCountryCode__c

TaxBreakdown[2].CountryIdentificationCode

taxes_duties_fees[2].country

  

c2g__TaxRate3__c

TaxBreakdown[2].Percent

taxes_duties_fees[2].percentage

Rounded to one decimal point.

c2g__OwnerCompany__r.EInvoicingTaxCategory__c

TaxBreakdown[2].TaxCode

taxes_duties_fees[2].category

  
<not mapped, but available for mapping to a custom field>

AccountingCostCentre

accountingcost

  
<not mapped, but available for mapping to a custom field>

AdditionalItemProperties

additionalItemProperties

  
<not mapped, but available for mapping to a custom field>

DiscountAmount

allowanceCharge

Value is negated.
<not mapped, but available for mapping to a custom field>

CustomerItemIdentification

buyersItemIdentification

  
<not mapped, but available for mapping to a custom field>

Period

invoicePeriod

  
<not mapped, but available for mapping to a custom field>

OrderLineReferenceLineId

orderLineReferenceLineId

  
<not mapped, but available for mapping to a custom field>

UnitCode

quantityUnitCode

  
<not mapped, but available for mapping to a custom field>

StandardItemIdentification

standardItemIdentification

  
<not mapped, but available for mapping to a custom field>

StandardItemIdentificationSchemeAgencyId

standardItemIdentificationSchemeAgencyId

  
<not mapped, but available for mapping to a custom field>

StandardItemIdentificationSchemeId

standardItemIdentificationSchemeId

  
Note: About Line-Level Tax Details
  • A sales credit note line item can have up to three taxes but Storecove only handles one. If you populate the sales credit note line item fields for more than one tax, Storecove will report an error.
  • The E-Invoicing Tax Category field on the Accounting Company (c2g__OwnerCompany__r.EInvoicingTaxCategory__c) is a picklist of values specified by Storecove. For the list of possible values, see Storecove's API documentation for tax category: https://www.storecove.com/docs/#_openapi_tax