Field Mappings for Electronic Invoice to Payable Credit Note

The table below shows how fields on a Storecove delivered credit note are mapped to an internal format (electronic invoice) and then to the payable credit note. Some fields are populated with hardcoded values. You can configure the mappings between the electronic invoice and payable credit note fields. For more information, see Managing Field Mappings for Electronic Invoice to Payable Credit Note.

Currently, electronic invoice’s payable credit note line items are always recorded as expense line items.

Note: It is recommended that you do not change the field mappings for PEPPOL IDs and legal entity ID fields. If you change them, the payable credit note generation will fail because the system uses them to match the accounting companies and vendor accounts.

Header Field Mapping

The table below lists the header field mappings. Some fields are populated with hardcoded values.

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

Storecove Purchase Invoice

ElectronicInvoicingService.Document

Field on Mapping UI

Payable Credit Note

Notes
guid DocumentIdentifier (Managed) E-Invoice Identifier c2g__EInvoiceExternalIdentifier__c  
    (Managed) Hardcoded - Acknowledged c2g__EInvoiceProcessingStatus__c  
tax_system TaxSystem   Either tax_line_percentages, or tax_line_amounts  
legal_entity_id LegalEntityId (Managed) Legal Entity ID c2g__OwnerCompany__r.c2g__EInvoicingLegalEntityID__c  
system_generated_primary_image CreatePrimaryImage Create Primary Image <not mapped, but available for mapping to a custom field>  
invoice_number invoiceNumber Invoice Number "c2g__AccountCreditNoteNumber__c"  
document -   <not supported>  
attachments Attachments   <not supported>  
issue_date IssueDate Issue Date c2g__RegisteredDate__c  
tax_point_date TaxPointDate Tax Date c2g__CreditNoteDate__c  
due_date DueDate Due Date c2g__DueDate__c  
document_currency_code DocumentCurrencyCode (Managed) Document Currency c2g__CreditNoteCurrency__c  
vat_reverse_charge -   <not supported>  
amount_including_vat -   <not supported>  
document_totals.rounding PayableRoundingAmount Payable Rounding Amount <not mapped, but available for mapping to a custom field>  
document_totals.prepaid PrepaidAmount Prepaid Amount <not mapped, but available for mapping to a custom field>  
document_totals.payable DocumentTotal Invoice Total <not mapped, but available for mapping to a custom field>  
document_totals.total AmountIncludingTax Amount Including Tax <not mapped, but available for mapping to a custom field>  
allowance_charge -   <not supported>  
allowance_charges AllowanceCharges Allowance Charge <not mapped, but available for mapping to a complex structure>  
allowance_charges.amount_excluding_tax AllowanceCharges[..].NetValue Net Value <not mapped, but available for mapping to a complex structure>  
allowance_charges.reason AllowanceCharges[..].Reason Reason <not mapped, but available for mapping to a complex structure>  
allowance_charges.tax.tax_amount AllowanceCharges[..].TaxBreakdown[0].Amount Tax Breakdown Amount <not mapped, but available for mapping to a complex structure>  
allowance_charges.tax.percentage AllowanceCharges[..].TaxBreakdown[0].Percent Tax Breakdown Percent <not mapped, but available for mapping to a complex structure>  
allowance_charges.tax.country AllowanceCharges[..].TaxBreakdown[0].CountryIdentificationCode Tax Breakdown ISO Country Code <not mapped, but available for mapping to a complex structure>  
allowance_charges.tax.category AllowanceCharges[..].TaxBreakdown[0].TaxCode Tax Breakdown Tax Code <not mapped, but available for mapping to a complex structure>  
allowance_charges.tax.type AllowanceCharges[..].TaxBreakdown[0].Type Tax Breakdown Tax Type <not mapped, but available for mapping to a complex structure>  
source Source   <not supported>  
sender.party_name AccountingSupplierParty.PartyName Supplier Name <not mapped, but available for mapping to a custom field>  
sender.department AccountingSupplierParty.Department Supplier Department <not mapped, but available for mapping to a custom field>  
sender.line1 AccountingSupplierParty.Line1 Supplier Address Line 1 <not mapped, but available for mapping to a custom field>  
sender.line2 AccountingSupplierParty.Line2 Supplier Address Line 2 <not mapped, but available for mapping to a custom field>  
sender.zip AccountingSupplierParty.Zip Supplier Zip Code <not mapped, but available for mapping to a custom field>  
sender.city AccountingSupplierParty.City Supplier City <not mapped, but available for mapping to a custom field>  
sender.county AccountingSupplierParty.County Supplier County <not mapped, but available for mapping to a custom field>  
sender.country AccountingSupplierParty.Country Supplier Country <not mapped, but available for mapping to a custom field>  
sender.legal_name AccountingSupplierParty.LegalName Supplier Legal Name <not mapped, but available for mapping to a custom field>  
sender.building_number AccountingSupplierParty.BuildingNumber Supplier Building Number <not mapped, but available for mapping to a custom field>  
sender.secondary_number AccountingSupplierParty.SecondaryNumber Supplier Secondary Number <not mapped, but available for mapping to a custom field>  
sender.neighborhood AccountingSupplierParty.Neighborhood Supplier Neighborhood <not mapped, but available for mapping to a custom field>  
sender.billing_contact.first_name AccountingSupplierParty.ContactFirstName Supplier First Name <not mapped, but available for mapping to a custom field>  
sender.billing_contact.last_name AccountingSupplierParty.ContactSecondName Supplier Last Name <not mapped, but available for mapping to a custom field>  
sender.billing_contact.email AccountingSupplierParty.EmailAddress Supplier Email <not mapped, but available for mapping to a custom field>  
sender.billing_contact.phone AccountingSupplierParty.Telephone Supplier Phone <not mapped, but available for mapping to a custom field>  
sender.peppol_identifiers.superscheme AccountingSupplierParty.Identifiers[0].SuperScheme   <not mapped, but available for mapping to a custom field>  
sender.peppol_identifiers.scheme AccountingSupplierParty.Identifiers[0].Scheme   <not mapped, but available for mapping to a custom field>  
sender.peppol_identifiers.identifier AccountingSupplierParty.Identifiers[0].Id (Managed) PEPPOL ID <not mapped, but available for mapping to a custom field>  
sender.identifiers AccountingSupplierParty.Identifiers Supplier Identifiers <not mapped, but available for mapping to a complex structure>  
sender.identifiers.superscheme AccountingSupplierParty.Identifiers[..].SuperScheme Super Scheme <not mapped, but available for mapping to a complex structure>  
sender.identifiers.scheme AccountingSupplierParty.Identifiers[..].Scheme Scheme <not mapped, but available for mapping to a complex structure>  
sender.identifiers.identifier AccountingSupplierParty.Identifiers[..].Id ID <not mapped, but available for mapping to a complex structure>  
sender.identifiers.scheme_numeric AccountingSupplierParty.Identifiers[..].SchemeNumeric Scheme Numeric <not mapped, but available for mapping to a complex structure>  
invoice_type -   -  
document_type -   <not supported>  
sub_type documentType   [used to determine whether to create a PIN or a PCR]  
period_start InvoicePeriod.StartDate Invoice Period Start Date <not mapped, but available for mapping to a custom field>  
period_end InvoicePeriod.EndDate Invoice Period End Date <not mapped, but available for mapping to a custom field>  
buyer_reference CustomerReference Customer Reference c2g__Reference1__c  
billing_reference BillingReference Billing Reference c2g__Reference2__c  
contract_document_reference ContractDocumentReference Contract Reference <not mapped, but available for mapping to a custom field>  
order_reference CustomerOrderReference Customer Reference <not mapped, but available for mapping to a custom field>  
project_reference ProjectReference Project Reference <not mapped, but available for mapping to a custom field>  
payment_means_payment_id -      
payment_means.iban -      
payment_means.id -      
payment_means_array PaymentMeans Payment Method <not mapped, but available for mapping to a complex structure>  
payment_means_array.type PaymentMeans[..].Code Code <not mapped, but available for mapping to a complex structure>  
payment_means_array.account PaymentMeans[..].Account Account <not mapped, but available for mapping to a complex structure>  
payment_means_array.holder PaymentMeans[..].Holder Holder <not mapped, but available for mapping to a complex structure>  
payment_means_array.branch_code PaymentMeans[..].BranchCode Branch Code <not mapped, but available for mapping to a complex structure>  
payment_means_array.payment_id PaymentMeans[..].PaymentId Payment ID <not mapped, but available for mapping to a complex structure>  
payment_means_array.mandate PaymentMeans[..].Mandate Mandate <not mapped, but available for mapping to a complex structure>  
payment_means_array.network PaymentMeans[..].Network Network <not mapped, but available for mapping to a complex structure>  
accounting_cost AccountingCostCentre Cost Center <not mapped, but available for mapping to a custom field>  
external_key ExternalKey External Key <not mapped, but available for mapping to a custom field>  
external_user_id ExternalUserId Enternal User ID <not mapped, but available for mapping to a custom field>  
note Note Note <not mapped, but available for mapping to a custom field>  
payment_terms_note PaymentTerms.Note Payment Terms Note <not mapped, but available for mapping to a custom field>  
tax_subtotals TaxSubtoals Tax Subtotal <not mapped, but available for mapping to a complex structure>  
tax_subtotals.amount_excluding_tax TaxSubtotals[..].TaxableAmount Taxable Amount <not mapped, but available for mapping to a complex structure>  
tax_subtotals.tax.tax_amount TaxSubtotals[..].Tax.Amount Tax Amount <not mapped, but available for mapping to a complex structure>  
tax_subtotals.tax.category TaxSubtotals[..].Tax.TaxCode Tax Code <not mapped, but available for mapping to a complex structure>  
tax_subtotals.tax.category_code        
tax_subtotals.tax.percentage TaxSubtotals[..].Tax.Percent Tax Percent <not mapped, but available for mapping to a complex structure>  
tax_subtotals.tax.type TaxSubtotals[..].Tax.Type Tax Type <not mapped, but available for mapping to a complex structure>  
tax_subtotals.tax.country TaxSubtotals[..].Tax.CountryIdentificationCode Tax ISO Country Code <not mapped, but available for mapping to a complex structure>  
delivery.actual_date Delivery.ActualDate Delivery Date <not mapped, but available for mapping to a custom field>  
delivery.location.city Delivery.Location.City Delivery Address City <not mapped, but available for mapping to a custom field>  
delivery.location.country Delivery.Location.Country Delivery Address Country <not mapped, but available for mapping to a custom field>  
delivery.location.county Delivery.Location.County Delivery Address County <not mapped, but available for mapping to a custom field>  
delivery.location.department Delivery.Location.Department Delivery Address Department <not mapped, but available for mapping to a custom field>  
delivery.location.id Delivery.location.id Delivery Location Id <not mapped, but available for mapping to a custom field>  
delivery.location.line1 Delivery.Location.Line1 Delivery Address Line1 <not mapped, but available for mapping to a custom field>  
delivery.location.line2 Delivery.Location.Line2 Delivery Address Line2 <not mapped, but available for mapping to a custom field>  
delivery.location.scheme_id Delivery.location.schemeId Delivery Scheme Id <not mapped, but available for mapping to a custom field>  
delivery.location.zip Delivery.Location.Zip Delivery Zip Code <not mapped, but available for mapping to a custom field>  
delivery.location.building_number Delivery.Location.BuildingNumber Delivery Address Building Number <not mapped, but available for mapping to a custom field>  
delivery.location.secondary_number Delivery.Location.SecondaryNumber Delivery Address Secondary Number <not mapped, but available for mapping to a custom field>  
delivery.location.neighborhood Delivery.Location.Neighborhood Delivery Address Neighborhood <not mapped, but available for mapping to a custom field>  
delivery.party.name Delivery.PartyName Delivery Party Name <not mapped, but available for mapping to a custom field>  

Expense Line Field Mapping

The table below lists the expense line field mappings. Some fields are populated with hardcoded values.

Note:
  • Unsupported fields are not supported for the Certinia Summer 2023 release.
  • In addition to the unsupported fields in this release, Storecove might include further fields which cannot be mapped until a later Certinia release.
  • The default values for the payable invoice and payable credit note expense lines are picked up from the Account's General Ledger Account, Dimensions 1 to 4, and Input VAT/GST Codes. So, ensure you have a general ledger account associated with the Account and it is populated. Although these field default values will be picked up from the Account, you can still override them on the payable document.
 
Warnings: Do not change the default mappings that are marked as "(Managed)". If you override them it will break the integration with Storecove.

Storecove Purchase Invoice Line

ElectronicInvoicingService.Document

Field on Mapping UI

Payable Credit Note Line Item

Notes

name

ItemName

Item Name

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

  

description

Description

Description

c2g__LineDescription__c

  

price.amount

UnitPrice

Unit Price

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

  

units.quantity

Quantity

Quantity

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

  

price.base_quantity

BaseQuantity

Base Quantity

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

  

units.unit_code

UnitCode

Unit Code

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

  

allowance_charge

-

  

<not supported>

  

allowance_charges_array

AllowanceCharges

Allowance Charge

<not mapped, but available for mapping to a complex structure>

  

allowance_charges_array.amount

AllowanceCharges[..].NetValue

Net Value

<not mapped, but available for mapping to a complex structure>

  

allowance_charges

        

amount_excluding_vat

    

Not supported

  

amount_excluding_tax

AmountExcludingTax

Net Value

c2g__NetValue__c

  

vat.amount

-

  

c2g__TaxValue1__c

  

vat.percentage

-

  

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

  

vat.country

-

  

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

  

tax.tax_amount

TaxBreakdown[0].Amount

Tax Breakdown Amount

c2g__TaxValue1__c

  

tax.percentage

TaxBreakdown[0].Percent

Tax Breakdown Percent

c2g__TaxRate1__c

  

tax.country

TaxBreakdown[0].CountryIdentificationCode

Tax Breakdown Country Identification Code

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

  

tax.category

TaxBreakdown[0].TaxCode

Tax Breakdown Tax Code

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

  

tax.category_code

-

      

tax.type

TaxBreakdown[0].Type

Tax Breakdown Tax Type

    

period_start

Period.StartDate

Period Start Date

c2g__DateFrom__c

  

period_end

Period.EndDate

Period End Date

c2g__DateTo__c

  

accounting.code

AccountingDetail.code

Accounting Detail Code

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

  

accounting.list

        

accounting.name

AccountingDetail.Name

Accounting Detail Name

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

  
   

(Managed) [Account Default Dimension 1]

c2g__Dimension1__c

  
   

(Managed) [Account Default Dimension 2]

c2g__Dimension2__c

  
   

(Managed) [Account Default Dimension 3]

c2g__Dimension3__c

  
   

(Managed) [Account Default Dimension 4]

c2g__Dimension4__c

  
   

(Managed) [Account Default Tax Code]

c2g__InputVATCode__c