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.
Header Field Mapping
The table below lists the header field mappings. Some fields are populated with hard-coded values.
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.
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> |