Field Mappings for Electronic Invoice to Payable Invoice

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

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

Notes: 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 invoice 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 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 unsupported fields in this release, Storecove might include further fields which cannot be mapped until a later Certinia release.

Storecove Purchase Invoice Line

ElectronicInvoicingService.DocumentLine

Payable Invoice

guid

DocumentIdentifier

c2g__EInvoiceIdentifier__c

tax_system

TaxSystem

Either tax_line_percentages, or tax_line_amounts

legal_entity_id

LegalEntityId

c2g__OwnerCompany__r.c2g__EInvoicingLegalEntityID__c

system_generated_primary_image

CreatePrimaryImage

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

invoice_number

invoiceNumber

c2g__AccountInvoiceNumber__c

document

-

<unsupported>

attachments

Attachments

<unsupported>

issue_date

IssueDate

c2g__RegisteredDate__c

tax_point_date

TaxPointDate

c2g__InvoiceDate__c

due_date

DueDate

c2g__DueDate__c

document_currency_code

DocumentCurrencyCode

c2g__InvoiceCurrency__c

document_totals.rounding

PayableRoundingAmount

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

document_totals.prepaid

PrepaidAmount

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

document_totals.payable

DocumentTotal

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

document_totals.total

AmountIncludingTax

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

allowance_charges

AllowanceCharges

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

allowance_charges.amount_excluding_tax

AllowanceCharges.NetValue

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

allowance_charges.reason

AllowanceCharges.Reason

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

allowance_charges.tax.tax_amount

AllowanceCharges.TaxBreakdown[0].Amount

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

allowance_charges.tax.percentage

AllowanceCharges.TaxBreakdown[0].Percent

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

allowance_charges.tax.country

AllowanceCharges.TaxBreakdown[0].CountryIdentificationCode

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

allowance_charges.tax.category

AllowanceCharges.TaxBreakdown[0].TaxCode

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

allowance_charges.tax.type

AllowanceCharges.TaxBreakdown[0].Type

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

source

Source

<unsupported>

sender.party_name

AccountingSupplierParty.PartyName

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

sender.department

AccountingSupplierParty.Department

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

sender.line1

AccountingSupplierParty.Line1

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

sender.line2

AccountingSupplierParty.Line2

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

sender.zip

AccountingSupplierParty.Zip

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

sender.city

AccountingSupplierParty.City

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

sender.county

AccountingSupplierParty.County

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

sender.country

AccountingSupplierParty.Country

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

sender.legal_name

AccountingSupplierParty.LegalName

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

sender.building_number

AccountingSupplierParty.BuildingNumber

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

sender.secondary_number

AccountingSupplierParty.SecondaryNumber

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

sender.neighborhood

AccountingSupplierParty.Neighborhood

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

sender.billing_contact.first_name

AccountingSupplierParty.ContactFirstName

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

sender.billing_contact.last_name

AccountingSupplierParty.ContactSecondName

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

sender.billing_contact.email

AccountingSupplierParty.EmailAddress

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

sender.billing_contact.phone

AccountingSupplierParty.Telephone

<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

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

sender.identifiers

AccountingSupplierParty.Identifiers

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

sender.identifiers.superscheme

AccountingSupplierParty.Identifiers[..].SuperScheme

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

sender.identifiers.scheme

AccountingSupplierParty.Identifiers[..].Scheme

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

sender.identifiers.identifier

AccountingSupplierParty.Identifiers[..].Id

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

sender.identifiers.scheme_numeric

AccountingSupplierParty.Identifiers[..].SchemeNumeric

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

document_type

-

<unsupported>

sub_type

documentType

[used to determine whether to create a PIN or a PCR]

period_start

InvoicePeriod.StartDate

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

period_end

InvoicePeriod.EndDate

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

buyer_reference

CustomerReference

c2g__Reference1__c

billing_reference

BillingReference

c2g__Reference2__c

contract_document_reference

ContractDocumentReference

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

order_reference

CustomerOrderReference

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

project_reference

ProjectReference

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

payment_means_array

PaymentMeans

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

payment_means_array.type

PaymentMeans.Code

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

payment_means_array.account

PaymentMeans.Account

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

payment_means_array.holder

PaymentMeans.Holder

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

payment_means_array.branch_code

PaymentMeans.BranchCode

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

payment_means_array.payment_id

PaymentMeans.PaymentId

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

payment_means_array.mandate

PaymentMeans.Mandate

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

payment_means_array.network

PaymentMeans.Network

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

accounting_cost

AccountingCostCentre

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

external_key

ExternalKey

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

external_user_id

ExternalUserId

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

note

Note

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

payment_terms_note

PaymentTerms.Note

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

tax_subtotals

TaxSubtoals

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

tax_subtotals.amount_excluding_tax

TaxSubtotals[..].TaxableAmount

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

tax_subtotals.tax.tax_amount

TaxSubtotals[..].Tax.Amount

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

tax_subtotals.tax.category

TaxSubtotals[..].Tax.TaxCode

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

tax_subtotals.tax.percentage

TaxSubtotals[..].Tax.Percent

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

tax_subtotals.tax.type

TaxSubtotals[..].Tax.Type

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

tax_subtotals.tax.country

TaxSubtotals[..].Tax.CountryIdentificationCode

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

delivery.actual_date

Delivery.ActualDate

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

delivery.location.city

Delivery.Location.City

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

delivery.location.country

Delivery.Location.Country

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

delivery.location.county

Delivery.Location.County

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

delivery.location.department

Delivery.Location.Department

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

delivery.location.id

Delivery.location.id

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

delivery.location.line1

Delivery.Location.Line1

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

delivery.location.line2

Delivery.Location.Line2

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

delivery.location.scheme_id

Delivery.location.schemeId

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

delivery.location.zip

Delivery.Location.Zip

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

delivery.location.building_number

Delivery.Location.BuildingNumber

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

delivery.location.secondary_number

Delivery.Location.SecondaryNumber

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

delivery.location.neighborhood

Delivery.Location.Neighborhood

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

delivery.party.name

Delivery.PartyName

<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 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 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.

Storecove Purchase Invoice Line

ElectronicInvoicingService.DocumentLine

Payable Invoice Line Item

name

ItemName

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

description

Description

c2g__LineDescription__c

price.amount

UnitPrice

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

units.quantity

Quantity

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

price.base_quantity

BaseQuantity

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

units.unit_code

UnitCode

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

allowance_charges_array

AllowanceCharges

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

allowance_charges_array.amount

AllowanceCharges.NetValue

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

amount_excluding_tax

AmountExcludingTax

c2g__NetValue__c

tax.tax_amount

TaxBreakdown[0].Amount

c2g__TaxValue1__c

tax.percentage

TaxBreakdown[0].Percent

c2g__TaxRate1__c

tax.country

TaxBreakdown[0].CountryIdentificationCode

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

tax.category

TaxBreakdown[0].TaxCode

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

tax.type

TaxBreakdown[0].Type

 

period_start

Period.StartDate

c2g__DateFrom__c

period_end

Period.EndDate

c2g__DateTo__c

accounting.code

AccountingDetail.code

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

accounting.list

Accounting.CodeList

<unsupported>

accounting.Name

AccountingDetail.Name

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