Avalara VAT Reporting Mappings Table
This table details the Avalara VAT Reporting mappings.
Source Field |
XML Path |
Document Type |
Required |
Country |
Child Relationship |
Parent Object |
Conditions |
Value Transformation |
---|---|---|---|---|---|---|---|---|
c2g__codaTransaction__c.c2g__TransactionDate__c | TransactionDate | |||||||
c2g__codaTransaction__c.c2g__OwnerCompany__c | ReporterID | |||||||
c2g__codaTransaction__c.c2g__DocumentNumber__c | InvoiceProperties/InvoiceNumber | |||||||
c2g__codaTransaction__c.c2g__TransactionDate__c | InvoiceProperties/InvoiceDate | |||||||
c2g__codaTransaction__c.c2g__VendorDocumentNumber__c | InvoiceProperties/SupplierInvoiceNumber | PI,PCN | TRUE | |||||
c2g__codaTransaction__c.c2g__Account__c | InvoiceProperties/SupplierID | PI,PCN | ||||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAVATRegistrationNumber__c | InvoiceProperties/SupplierData/VATNumber/VATNumber | PI,PCN | TRUE | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c | InvoiceProperties/SupplierData/VATNumber/VATNumberCountry | PI,PCN | TRUE | |||||
c2g__codaTransaction__c.c2g__OwnerCompany__c | InvoiceProperties/CustomerID | PI,PCN | ||||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.Name | InvoiceProperties/CustomerData/Name | PI,PCN | ||||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__VATRegistrationNumber__c | InvoiceProperties/CustomerData/VATNumber/VATNumber | PI,PCN | TRUE | |||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c | InvoiceProperties/CustomerData/VATNumber/VATNumberCountry | PI,PCN | TRUE | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c | InvoiceProperties/SupplierData/Country | PI,PCN | TRUE | |||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c | InvoiceProperties/CustomerData/Country | PI,PCN | TRUE | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c | InvoiceProperties/CountryVATNumberUsedBySupplier | PI,PCN | TRUE | |||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c | InvoiceProperties/CountryVATNumberUsedByCustomer | PI,PCN | TRUE | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAVATRegistrationNumber__c | InvoiceProperties/SupplierData/VATNumber/TaxNumber | PI,PCN | TRUE | |||||
c2g__codaTransaction__c.c2g__OwnerCompany__c | InvoiceProperties/SupplierID | SI,SCN,BD | ||||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.Name | InvoiceProperties/SupplierData/Name | SI,SCN,BD | ||||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__VATRegistrationNumber__c | InvoiceProperties/SupplierData/VATNumber/VATNumber | SI,SCN,BD | TRUE | |||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c | InvoiceProperties/SupplierData/VATNumber/VATNumberCountry | SI,SCN,BD | TRUE | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.FirstName | InvoiceProperties/SupplierData/PrivatePersonFirstName | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.LastName | InvoiceProperties/SupplierData/PrivatePersonLastName | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.BillingStreet | InvoiceProperties/SupplierData/Address | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__Street__c | InvoiceProperties/SupplierData/Address | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.BillingCity | InvoiceProperties/SupplierData/City | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__City__c | InvoiceProperties/SupplierData/City | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.Name | InvoiceProperties/SupplierData/VATNumber/FiscalRepresentativeName | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.FirstName | InvoiceProperties/SupplierData/VATNumber/FiscalRepresentativePrivatePersonFirstName | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.LastName | InvoiceProperties/SupplierData/VATNumber/FiscalRepresentativePrivatePersonLastName | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.MailingStreet | InvoiceProperties/SupplierData/VATNumber/FiscalRepresentativeStreet | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.MailingPostalCode | InvoiceProperties/SupplierData/VATNumber/FiscalRepresentativeZip | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.MailingCity | InvoiceProperties/SupplierData/VATNumber/FiscalRepresentativeCity | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.MailingCountry | InvoiceProperties/SupplierData/VATNumber/FiscalRepresentativeCountry | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.BillingStreet | InvoiceProperties/SupplierData/VATNumber/FixedEstablishmentStreet | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.BillingPostalCode | InvoiceProperties/SupplierData/VATNumber/FixedEstablishmentZip | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.BillingCity | InvoiceProperties/SupplierData/VATNumber/FixedEstablishmentCity | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.BillingCountry | InvoiceProperties/SupplierData/VATNumber/FixedEstablishmentCountry | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.FirstName | InvoiceProperties/CustomerData/PrivatePersonFirstName | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.LastName | InvoiceProperties/CustomerData/PrivatePersonLastName | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.BillingStreet | InvoiceProperties/CustomerData/Address | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__Street__c | InvoiceProperties/CustomerData/Address | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.BillingCity | InvoiceProperties/CustomerData/City | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__City__c | InvoiceProperties/CustomerData/City | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.Name | InvoiceProperties/CustomerData/VATNumber/FiscalRepresentativeName | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.FirstName | InvoiceProperties/CustomerData/VATNumber/FiscalRepresentativePrivatePersonFirstName | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.LastName | InvoiceProperties/CustomerData/VATNumber/FiscalRepresentativePrivatePersonLastName | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.MailingStreet | InvoiceProperties/CustomerData/VATNumber/FiscalRepresentativeStreet | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.MailingPostalCode | InvoiceProperties/CustomerData/VATNumber/FiscalRepresentativeZip | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.MailingCity | InvoiceProperties/CustomerData/VATNumber/FiscalRepresentativeCity | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAFinanceContact__r.MailingCountry | InvoiceProperties/CustomerData/VATNumber/FiscalRepresentativeCountry | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.BillingStreet | InvoiceProperties/CustomerData/VATNumber/FixedEstablishmentStreet | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.BillingPostalCode | InvoiceProperties/CustomerData/VATNumber/FixedEstablishmentZip | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.BillingCity | InvoiceProperties/CustomerData/VATNumber/FixedEstablishmentCity | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__Account__r.BillingCountry | InvoiceProperties/CustomerData/VATNumber/FixedEstablishmentCountry | SI,SCN,BD | IT | |||||
c2g__codaTransaction__c.c2g__Account__c | InvoiceProperties/CustomerID | SI,SCN,BD | ||||||
c2g__codaTransaction__c.c2g__Account__r.Name | InvoiceProperties/CustomerData/Name | SI,SCN,BD | ||||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAVATRegistrationNumber__c | InvoiceProperties/CustomerData/VATNumber/VATNumber | SI,SCN,BD | TRUE | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c | InvoiceProperties/CustomerData/VATNumber/VATNumberCountry | SI,SCN,BD | TRUE | |||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c | InvoiceProperties/SupplierData/Country | SI,SCN,BD | TRUE | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c | InvoiceProperties/CustomerData/Country | SI,SCN,BD | TRUE | |||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__VATRegistrationNumber__c | InvoiceProperties/SupplierData/VATNumber/TaxNumber | SI,SCN,BD | TRUE | |||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c | InvoiceProperties/CountryVATNumberUsedBySupplier | SI,SCN,BD | TRUE | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c | InvoiceProperties/CountryVATNumberUsedByCustomer | SI,SCN,BD | TRUE | |||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c | InvoiceProperties/SupplierData/VATNumber/TaxNumberCountry | SI,SCN,BD | TRUE | |||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAVATRegistrationNumber__c | InvoiceProperties/CustomerData/VATNumber/TaxNumber | SI,SCN,BD | ||||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c | InvoiceProperties/CustomerData/VATNumber/TaxNumberCountry | SI,SCN,BD | ||||||
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c | InvoiceProperties/SupplierData/VATNumber/TaxNumberCountry | PI,PCN | TRUE | |||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__VATRegistrationNumber__c | InvoiceProperties/CustomerData/VATNumber/TaxNumber | PI,PCN | ||||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c | InvoiceProperties/CustomerData/VATNumber/TaxNumberCountry | PI,PCN | ||||||
c2g__codaTransaction__c.c2g__Account__r.Name | InvoiceProperties/SupplierData/Name | PI,PCN | ||||||
c2g__codaTransaction__c.c2g__TransactionType__c | InvoiceProperties/DocumentType |
"Invoice": "0", "Purchase Invoice": "1", "Credit Note": "2", "Purchase Credit Note": "3" |
||||||
c2g__codaTransactionLineItem__c.c2g__HomeCurrency__r.Name | InvoiceProperties/InvoiceValues[]/Currency | c2g__TransactionLineItems__r | ||||||
c2g__codaTransaction__c.c2g__TransactionType__c | InvoiceProperties/IntrastatDocumentData/TransactionType | SI,SCN,PI | "Invoice": "11", "Credit Note": "21", "Purchase Invoice": "41" |
|||||
c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Sales_Order_Line_Item__r.SCMC__Supplier_Site__r.SCMC__Mailing_Country__c | InvoiceProperties/IntrastatDocumentData/CountryDispatch | SI | TRUE | c2g__codaInvoice__c | c2g__InvoiceLineItems__r | "SourceField": "c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.RecordType.Name", "ChildRelationship": "c2g__InvoiceLineItems__r", "ParentObject": "c2g__codaInvoice__c", "Operator": "equals", "Value": "Drop Ship Item" |
||
c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Pick_list_Details__r.SCMC__Warehouse__r.SCMC__Address__r.SCMC__Country__c | InvoiceProperties/IntrastatDocumentData/CountryDispatch | SI | TRUE | c2g__codaInvoice__c | c2g__InvoiceLineItems__r | "SourceField": "c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.RecordType.Name", "ChildRelationship": "c2g__InvoiceLineItems__r", "ParentObject": "c2g__codaInvoice__c", "Operator": "not equals", "Value": "Drop Ship Item" |
||
c2g__codaCreditNoteLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Sales_Order_Line_Item__r.SCMC__Supplier_Site__r.SCMC__Mailing_Country__c | InvoiceProperties/IntrastatDocumentData/CountryDispatch | SCN | TRUE | c2g__codaCreditNote__c | c2g__CreditNoteLineItems__r | "SourceField": "c2g__codaCreditNoteLineItem__c.SCMFFA__SCM_Invoice_Line__r.RecordType.Name", "ChildRelationship": "c2g__CreditNoteLineItems__r", "ParentObject": "c2g__codaCreditNote__c", "Operator": "equals", "Value": "Drop Ship Item" |
||
c2g__codaCreditNoteLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Pick_list_Details__r.SCMC__Warehouse__r.SCMC__Address__r.SCMC__Country__c | InvoiceProperties/IntrastatDocumentData/CountryDispatch | SCN | TRUE | c2g__codaCreditNote__c | c2g__CreditNoteLineItems__r | "SourceField": "c2g__codaCreditNoteLineItem__c.SCMFFA__SCM_Invoice_Line__r.RecordType.Name", "ChildRelationship": "c2g__CreditNoteLineItems__r", "ParentObject": "c2g__codaCreditNote__c", "Operator": "not equals", "Value": "Drop Ship Item" |
||
c2g__codaPurchaseInvoice__c.SCMFFA__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Supplier_Site__r.SCMC__Mailing_Country__c | InvoiceProperties/IntrastatDocumentData/CountryDispatch | PI | TRUE | |||||
c2g__codaTransaction__c.c2g__Account__r.ShippingCountry | InvoiceProperties/IntrastatDocumentData/CountryArrival | SI,SCN | ||||||
c2g__codaPurchaseInvoice__c.SCMFFA__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Ship_To_Warehouse__r.SCMC__Address__r.SCMC__Country__c | InvoiceProperties/IntrastatDocumentData/CountryArrival | PI | TRUE | |||||
c2g__codaTransactionLineItem__c.c2g__LineDescription__c | InvoiceProperties/InvoiceLines[]/Description | TRUE | c2g__TransactionLineItems__r | |||||
c2g__codaTransactionLineItem__c.c2g__HomeTaxValue1__c | InvoiceProperties/InvoiceLines[]/ValueDeductibleVAT | SI,SCN | c2g__TransactionLineItems__r | |||||
c2g__codaTransactionLineItem__c.c2g__HomeTaxValue1__c | InvoiceProperties/InvoiceLines[]/ValueDeductibleVAT | PI,PCN | c2g__TransactionLineItems__r | "SourceField":"c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c", "ChildRelationship": "c2g__TransactionLineItems__r", "Operator":"equals", "Value":"" |
||||
c2g__codaTransactionLineItem__c.c2g__HomeValue__c | InvoiceProperties/InvoiceLines[]/ValueDeductibleVAT | PI | c2g__TransactionLineItems__r | "SourceField":"c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c", "ChildRelationship": "c2g__TransactionLineItems__r", "Operator":"not equals", "Value":"" "SourceField": "c2g__codaPurchaseInvoiceLineItem__c.c2g__OutputTaxRate__c", "ChildRelationship": "c2g__PurchaseInvoiceLineItems__r", "ParentObject": "c2g__codaPurchaseInvoice__c", "Operator":"not equals", "Value":"" |
||||
c2g__codaTransactionLineItem__c.c2g__HomeValue__c | InvoiceProperties/InvoiceLines[]/ValueDeductibleVAT | PI | c2g__TransactionLineItems__r | "SourceField":"c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c", "ChildRelationship": "c2g__TransactionLineItems__r", "Operator":"not equals", "Value":"" "SourceField": "c2g__codaPurchaseInvoiceExpenseLineItem__c.c2g__OutputTaxRate__c", "ChildRelationship": "c2g__PurchaseInvoiceExpenseLineItems__r", "ParentObject": "c2g__codaPurchaseInvoice__c", "Operator":"not equals", "Value":"" |
||||
c2g__codaTransactionLineItem__c.c2g__HomeValue__c | InvoiceProperties/InvoiceLines[]/ValueDeductibleVAT | PCN | c2g__TransactionLineItems__r | "SourceField":"c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c", "ChildRelationship": "c2g__TransactionLineItems__r", "Operator":"not equals", "Value":"" "SourceField": "c2g__codaPurchaseCreditNoteLineItem__c.c2g__OutputTaxRate__c", "ChildRelationship": "c2g__PurchaseCreditNoteLineItems__r", "ParentObject": "c2g__codaPurchaseCreditNote__c", "Operator":"not equals", "Value":"" |
||||
c2g__codaTransactionLineItem__c.c2g__HomeValue__c | InvoiceProperties/InvoiceLines[]/ValueDeductibleVAT | PCN | c2g__TransactionLineItems__r | "SourceField":"c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c", "ChildRelationship": "c2g__TransactionLineItems__r", "Operator":"not equals", "Value":"" }, { "SourceField": "c2g__codaPurchaseCreditNoteExpLineItem__c.c2g__OutputTaxRate__c", "ChildRelationship": "c2g__PurchaseCreditNoteExpenseLineItems__r", "ParentObject": "c2g__codaPurchaseCreditNote__c", "Operator":"not equals", "Value":"" | ||||
c2g__codaTransactionLineItem__c.c2g__HomeTaxValue1__c | InvoiceProperties/InvoiceLines[]/ValueVAT | c2g__TransactionLineItems__r | ||||||
c2g__codaTransactionLineItem__c.c2g__HomeTaxValue1__c | InvoiceProperties/InvoiceLines[]/VATReversed | PI,PCN | c2g__TransactionLineItems__r | "SourceField":"c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c", "ChildRelationship": "c2g__TransactionLineItems__r", "Operator":"equals", "Value":"" |
"*": "0.00" | |||
c2g__codaTransactionLineItem__c.c2g__HomeValue__c | InvoiceProperties/InvoiceLines[]/VATReversed | PI | c2g__TransactionLineItems__r |
"SourceField":"c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c", |
||||
c2g__codaTransactionLineItem__c.c2g__HomeValue__c | InvoiceProperties/InvoiceLines[]/VATReversed | PI | c2g__TransactionLineItems__r | "SourceField":"c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c", "ChildRelationship": "c2g__TransactionLineItems__r", "Operator":"not equals", "Value":"" "SourceField": "c2g__codaPurchaseInvoiceExpenseLineItem__c.c2g__OutputTaxRate__c", "ChildRelationship": "c2g__PurchaseInvoiceExpenseLineItems__r", "ParentObject": "c2g__codaPurchaseInvoice__c", "Operator":"not equals", "Value":"" |
||||
c2g__codaTransactionLineItem__c.c2g__HomeValue__c | InvoiceProperties/InvoiceLines[]/VATReversed | PCN | c2g__TransactionLineItems__r | "SourceField":"c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c", "ChildRelationship": "c2g__TransactionLineItems__r", "Operator":"not equals", "Value":"" "SourceField": "c2g__codaPurchaseCreditNoteLineItem__c.c2g__OutputTaxRate__c", "ChildRelationship": "c2g__PurchaseCreditNoteLineItems__r", "ParentObject": "c2g__codaPurchaseCreditNote__c", "Operator":"not equals", "Value":"" |
||||
c2g__codaTransactionLineItem__c.c2g__HomeValue__c | InvoiceProperties/InvoiceLines[]/VATReversed | PCN | c2g__TransactionLineItems__r |
"SourceField":"c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c", |
||||
c2g__codaTransactionLineItem__c.c2g__TaxCode1__r.Name | InvoiceProperties/InvoiceLines[]/LineVATCode | c2g__TransactionLineItems__r | c2g__TransactionLineItems__r | "SourceField":"c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c", "ChildRelationship":"c2g__TransactionLineItems__r", "Operator":"equals", "Value":"" |
||||
c2g__codaTransactionLineItem__c.c2g__TaxCode1__r.c2g__Description__c | InvoiceProperties/InvoiceLines[]/LineVATCodeDescription | c2g__TransactionLineItems__r | c2g__TransactionLineItems__r | "SourceField":"c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c", "ChildRelationship":"c2g__TransactionLineItems__r", "Operator":"equals", "Value":"" |
||||
c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c.Name | InvoiceProperties/InvoiceLines[]/LineVATCode | c2g__TransactionLineItems__r | "SourceField":"c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c", "ChildRelationship":"c2g__TransactionLineItems__r", "Operator":"not equals", "Value":"" |
|||||
c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c.c2g__Description__c | InvoiceProperties/InvoiceLines[]/LineVATCodeDescription | c2g__TransactionLineItems__r | "SourceField":"c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c", "ChildRelationship":"c2g__TransactionLineItems__r", "Operator":"not equals", "Value":"" |
|||||
c2g__codaTransactionLineItem__c.c2g__HomeValue__c | InvoiceProperties/InvoiceLines[]/ValueExclVAT | c2g__TransactionLineItems__r | ||||||
c2g__codaTransactionLineItem__c.c2g__HomeValue__c | InvoiceProperties/InvoiceLines[]/ValueTaxableBasis | c2g__TransactionLineItems__r | ||||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__PayableInvoice__r.c2g__InvoiceDate__c | InvoiceProperties/InvoiceLines[]/DateOfSupply | PI | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__SalesInvoice__r.c2g__InvoiceDate__c | InvoiceProperties/InvoiceLines[]/DateOfSupply | SI | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__PayableCreditNote__r.c2g__InvoiceDate__c | InvoiceProperties/InvoiceLines[]/DateOfSupply | PCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__SalesCreditNote__r.c2g__InvoiceDate__c | InvoiceProperties/InvoiceLines[]/DateOfSupply | SCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransaction__c.c2g__TransactionDate__c | IncomingPostingDate | ES | ||||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__OwnerCompany__r.c2g__ECCountryCode__c | InvoiceProperties/InvoiceLines[]/ShipToCountry | PI,PCN | c2g__TransactionLineItems__r | |||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__OwnerCompany__r.c2g__City__c | InvoiceProperties/InvoiceLines[]/ShipToCity | PI,PCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__OwnerCompany__r.c2g__Street__c | InvoiceProperties/InvoiceLines[]/ShipToStreet | PI,PCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__OwnerCompany__r.c2g__ZipPostCode__c | InvoiceProperties/InvoiceLines[]/ShipToZIP | PI,PCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__Account__r.c2g__CODAECCountryCode__c | InvoiceProperties/InvoiceLines[]/ShipToCountry | SI,SCN,BD | c2g__TransactionLineItems__r | |||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__Account__r.BillingCity | InvoiceProperties/InvoiceLines[]/ShipToCity | SI,SCN,BD | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__Account__r.BillingStreet | InvoiceProperties/InvoiceLines[]/ShipToStreet | SI,SCN,BD | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__Account__r.BillingPostalCode | InvoiceProperties/InvoiceLines[]/ShipToZIP | SI,SCN,BD | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__OwnerCompany__r.c2g__ECCountryCode__c | InvoiceProperties/InvoiceLines[]/ShipFromCountry | SI,SCN,BD | c2g__TransactionLineItems__r | |||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__OwnerCompany__r.c2g__City__c | InvoiceProperties/InvoiceLines[]/ShipFromCity | SI,SCN,BD | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__OwnerCompany__r.c2g__Street__c | InvoiceProperties/InvoiceLines[]/ShipFromStreet | SI,SCN,BD | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__OwnerCompany__r.c2g__ZipPostCode__c | InvoiceProperties/InvoiceLines[]/ShipFromZIP | SI,SCN,BD | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__Account__r.c2g__CODAECCountryCode__c | InvoiceProperties/InvoiceLines[]/ShipFromCountry | PI,PCN | c2g__TransactionLineItems__r | |||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__Account__r.BillingCity | InvoiceProperties/InvoiceLines[]/ShipFromCity | PI,PCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__Account__r.BillingStreet | InvoiceProperties/InvoiceLines[]/ShipFromStreet | PI,PCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__Account__r.BillingPostalCode | InvoiceProperties/InvoiceLines[]/ShipFromZIP | PI,PCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ZipPostCode__c | InvoiceProperties/SupplierData/ZIP | SI,SCN,BD | ES,IT | |||||
c2g__codaTransaction__c.c2g__Account__r.BillingPostalCode | InvoiceProperties/SupplierData/ZIP | PI,PCN | ES,IT | |||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__OwnerCompany__r.c2g__Street__c | InvoiceProperties/InvoiceLines[]/ShipFromStreetNumber | SI,SCN,BD | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__Account__r.BillingStreet | InvoiceProperties/InvoiceLines[]/ShipFromStreetNumber | PI,PCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__Account__r.BillingStreet | InvoiceProperties/InvoiceLines[]/ShipToStreetNumber | SI,SCN,BD | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__OwnerCompany__r.c2g__Street__c | InvoiceProperties/InvoiceLines[]/ShipToStreetNumber | PI,PCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ZipPostCode__c | InvoiceProperties/CustomerData/ZIP | PI,PCN | ES,IT | |||||
c2g__codaTransaction__c.c2g__Account__r.BillingPostalCode | InvoiceProperties/CustomerData/ZIP | SI,SCN,BD | ES,IT | |||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__SalesCreditNote__r.c2g__Invoice__r.Name | InvoiceProperties/InvoiceLines[]/ReferenceInvoiceNumber | SCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__PayableCreditNote__r.c2g__PurchaseInvoice__r.Name | InvoiceProperties/InvoiceLines[]/ReferenceInvoiceNumber | PCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__SalesCreditNote__r.c2g__Invoice__r.c2g__Transaction__r.c2g__TransactionDate__c | InvoiceProperties/InvoiceLines[]/ReferenceInvoiceDate | SCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__PayableCreditNote__r.c2g__PurchaseInvoice__r.c2g__Transaction__r.c2g__TransactionDate__c | InvoiceProperties/InvoiceLines[]/ReferenceInvoiceDate | PCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__HomeValue__c | InvoiceProperties/InvoiceLines[]/ReferenceTaxableBasis | SCN,PCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__HomeTaxValue1__c | InvoiceProperties/InvoiceLines[]/ReferenceVAT | SCN,PCN | ES | c2g__TransactionLineItems__r | ||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__BillingDocument__r.fferpcore__DocumentDate__c | InvoiceProperties/InvoiceLines[]/DateOfSupply | BD | ES | c2g__TransactionLineItems__r | ||||
c2g__codaInvoiceLineItem__c.SCMFFA__Item_Name__r.SCMC__Commodity_Code__r.SCMC__Number__c | InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode | SI | c2g__codaInvoice__c | c2g__InvoiceLineItems__r | ||||
c2g__codaCreditNoteLineItem__c.SCMFFA__Item_Name__r.SCMC__Commodity_Code__r.SCMC__Number__c | InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode | SCN | c2g__codaCreditNote__c | c2g__CreditNoteLineItems__r | ||||
c2g__codaPurchaseInvoiceLineItem__c.SCMFFA__Item_Master__r.SCMC__Commodity_Code__r.SCMC__Number__c | InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode | PI | TRUE | c2g__PurchaseInvoiceLineItems__r | c2g__codaPurchaseInvoice__c | |||
c2g__codaPurchaseInvoiceExpenseLineItem__c.SCMFFA__AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Item_Master__r.SCMC__Commodity_Code__r.SCMC__Number__c | InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode | PI | TRUE | c2g__PurchaseInvoiceExpenseLineItems__r | c2g__codaPurchaseInvoice__c | |||
c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Sales_Order_Line_Item__r.SCMC__Quantity__c | InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1 | SI | TRUE | c2g__codaInvoice__c | c2g__InvoiceLineItems__r | |||
c2g__codaCreditNoteLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Sales_Order_Line_Item__r.SCMC__Quantity__c | InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1 | SCN | TRUE | c2g__codaCreditNote__c | c2g__CreditNoteLineItems__r | |||
c2g__codaPurchaseInvoiceLineItem__c.SCMFFA__AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Quantity__c | InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1 | PI | TRUE | c2g__PurchaseInvoiceLineItems__r | c2g__codaPurchaseInvoice__c | |||
c2g__codaPurchaseInvoiceExpenseLineItem__c.SCMFFA__AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Quantity__c | InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1 | PI | TRUE | c2g__PurchaseInvoiceExpenseLineItems__r | c2g__codaPurchaseInvoice__c | |||
c2g__codaInvoiceLineItem__c.SCMFFA__Item_Name__r.SCMC__Stocking_UOM__r.Name | InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1 | SI | TRUE | c2g__codaInvoice__c | c2g__InvoiceLineItems__r | |||
c2g__codaCreditNoteLineItem__c.SCMFFA__Item_Name__r.SCMC__Stocking_UOM__r.Name | InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1 | SCN | TRUE | c2g__codaCreditNote__c | c2g__CreditNoteLineItems__r | |||
c2g__codaPurchaseInvoiceLineItem__c.SCMFFA__Item_Master__r.SCMC__Stocking_UOM__r.Name | InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1 | PI | TRUE | c2g__PurchaseInvoiceLineItems__r | c2g__codaPurchaseInvoice__c | |||
Custom field required. For information on how to configure these, see Custom Fields and Source Field Mapping. |
InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity2 | |||||||
InvoiceProperties/InvoiceLines[]/IntrastatData/Unit2 | ||||||||
c2g__codaPurchaseInvoiceExpenseLineItem__c.SCMFFA__AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Stocking_Unit_of_Measure__c | InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1 | PI | TRUE | c2g__PurchaseInvoiceExpenseLineItems__r | c2g__codaPurchaseInvoice__c | |||
Custom field required. For information on how to configure these, see Custom Fields and Source Field Mapping. |
InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity2 | SI | c2g__InvoiceLineItems__r | c2g__codaInvoice__c | ||||
InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity2 | SCN | c2g__CreditNoteLineItems__r | c2g__codaCreditNote__c | |||||
InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity2 | PI | c2g__PurchaseInvoiceLineItems__r | c2g__codaPurchaseInvoice__c | |||||
InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity2 | PI | c2g__PurchaseInvoiceExpenseLineItems__r | c2g__codaPurchaseInvoice__c | |||||
InvoiceProperties/InvoiceLines[]/IntrastatData/Unit2 | SI | c2g__InvoiceLineItems__r | c2g__codaInvoice__c | |||||
InvoiceProperties/InvoiceLines[]/IntrastatData/Unit2 | SCN | c2g__CreditNoteLineItems__r | c2g__codaCreditNote__c | |||||
InvoiceProperties/InvoiceLines[]/IntrastatData/Unit2 | PI | c2g__PurchaseInvoiceLineItems__r | c2g__codaPurchaseInvoice__c | |||||
InvoiceProperties/InvoiceLines[]/IntrastatData/Unit2 | PI | c2g__PurchaseInvoiceExpenseLineItems__r | c2g__codaPurchaseInvoice__c | |||||
c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Sales_Order_Line_Item__r.SCMC__Supplier_Site__r.SCMC__Mailing_State_Province__c | InvoiceProperties/InvoiceLines[]/IntrastatData/RegionDispatch | SI | BE,FR,DE,ES,IT,SK,BG | c2g__codaInvoice__c | c2g__InvoiceLineItems__r | "SourceField": "c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.RecordType.Name", "ChildRelationship": "c2g__InvoiceLineItems__r", "ParentObject": "c2g__codaInvoice__c", "Operator": "equals", "Value": "Drop Ship Item" |
||
c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Pick_list_Details__r.SCMC__Warehouse__r.SCMC__Address__r.SCMC__State__c | InvoiceProperties/InvoiceLines[]/IntrastatData/RegionDispatch | SI | BE,FR,DE,ES,IT,SK,BG | c2g__codaInvoice__c | c2g__InvoiceLineItems__r | "SourceField": "c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.RecordType.Name", "ChildRelationship": "c2g__InvoiceLineItems__r", "ParentObject": "c2g__codaInvoice__c", "Operator": "not equals", "Value": "Drop Ship Item" |
||
c2g__codaCreditNoteLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Sales_Order_Line_Item__r.SCMC__Supplier_Site__r.SCMC__Mailing_State_Province__c | InvoiceProperties/InvoiceLines[]/IntrastatData/RegionDispatch | SCN | BE,FR,DE,ES,IT,SK,BG | c2g__codaCreditNote__c | c2g__CreditNoteLineItems__r | "SourceField": "c2g__codaCreditNoteLineItem__c.SCMFFA__SCM_Invoice_Line__r.RecordType.Name", "ChildRelationship": "c2g__CreditNoteLineItems__r", "ParentObject": "c2g__codaCreditNote__c", "Operator": "equals", "Value": "Drop Ship Item" |
||
c2g__codaCreditNoteLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Pick_list_Details__r.SCMC__Warehouse__r.SCMC__Address__r.SCMC__State__c | InvoiceProperties/InvoiceLines[]/IntrastatData/RegionDispatch | SCN | BE,FR,DE,ES,IT,SK,BG | c2g__codaCreditNote__c | c2g__CreditNoteLineItems__r | "SourceField": "c2g__codaCreditNoteLineItem__c.SCMFFA__SCM_Invoice_Line__r.RecordType.Name", "ChildRelationship": "c2g__CreditNoteLineItems__r", "ParentObject": "c2g__codaCreditNote__c", "Operator": "not equals", "Value": "Drop Ship Item" |
||
c2g__codaPurchaseInvoice__c.SCMFFA__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Supplier_Site__r.SCMC__Mailing_State_Province__c | InvoiceProperties/InvoiceLines[]/IntrastatData/RegionDispatch | PI | BE,FR,DE,ES,IT,SK,BG | |||||
c2g__codaTransactionLineItem__c.c2g__Account__r.ShippingState | InvoiceProperties/InvoiceLines[]/IntrastatData/RegionArrival | SI,SCN | BE,FR,DE,ES,IT,SK,BG | c2g__TransactionLineItems__r | ||||
c2g__codaCreditNote__c.SCMFFA__SCM_Invoice__r.SCMC__Sales_Order__r.SCMC__Customer_Account__r.ShippingState | InvoiceProperties/InvoiceLines[]/IntrastatData/RegionArrival | SCN | BE,FR,DE,ES,IT,SK,BG | |||||
c2g__codaPurchaseInvoiceLineItem__c.SCMFFA__AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Warehouse__r.SCMC__Address__r.SCMC__State__c | InvoiceProperties/InvoiceLines[]/IntrastatData/RegionArrival | PI | BE,FR,DE,ES,IT,SK,BG | c2g__PurchaseInvoiceLineItems__r | c2g__codaPurchaseInvoice__c | |||
c2g__codaPurchaseInvoiceExpenseLineItem__c.SCMFFA__AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Warehouse__r.SCMC__Address__r.SCMC__State__c | InvoiceProperties/InvoiceLines[]/IntrastatData/RegionArrival | PI | BE,FR,DE,ES,IT,SK,BG | c2g__PurchaseInvoiceExpenseLineItems__r | c2g__codaPurchaseInvoice__c | |||
c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Sales_Order_Line_Item__r.SCMC__Supplier_Site__r.SCMC__Mailing_Country__c | InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin | SI | TRUE | c2g__codaInvoice__c | c2g__InvoiceLineItems__r | "SourceField": "c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.RecordType.Name", "ChildRelationship": "c2g__InvoiceLineItems__r", "ParentObject": "c2g__codaInvoice__c", "Operator": "equals", "Value": "Drop Ship Item" |
||
c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Pick_list_Details__r.SCMC__Warehouse__r.SCMC__Address__r.SCMC__Country__c | InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin | SI | TRUE | c2g__codaInvoice__c | c2g__InvoiceLineItems__r | "SourceField": "c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.RecordType.Name", "ChildRelationship": "c2g__InvoiceLineItems__r", "ParentObject": "c2g__codaInvoice__c", "Operator": "not equals", "Value": "Drop Ship Item" |
||
c2g__codaCreditNoteLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Sales_Order_Line_Item__r.SCMC__Supplier_Site__r.SCMC__Mailing_Country__c | InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin | SCN | TRUE | c2g__codaCreditNote__c | c2g__CreditNoteLineItems__r | "SourceField": "c2g__codaCreditNoteLineItem__c.SCMFFA__SCM_Invoice_Line__r.RecordType.Name", "ChildRelationship": "c2g__CreditNoteLineItems__r", "ParentObject": "c2g__codaCreditNote__c", "Operator": "equals", "Value": "Drop Ship Item" |
||
c2g__codaCreditNoteLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Pick_list_Details__r.SCMC__Warehouse__r.SCMC__Address__r.SCMC__Country__c | InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin | SCN | TRUE | c2g__codaCreditNote__c | c2g__CreditNoteLineItems__r | "SourceField": "c2g__codaCreditNoteLineItem__c.SCMFFA__SCM_Invoice_Line__r.RecordType.Name", "ChildRelationship": "c2g__CreditNoteLineItems__r", "ParentObject": "c2g__codaCreditNote__c", "Operator": "not equals", "Value": "Drop Ship Item" |
||
c2g__codaPurchaseInvoice__c.SCMFFA__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Supplier_Site__r.SCMC__Mailing_Country__c | InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin | PI | TRUE | |||||
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__TransactionType__c | InvoiceProperties/InvoiceLines[]/IntrastatData/ItemType | SI,SCN,PI | c2g__TransactionLineItems__r | "Invoice": "0", "Credit Note": "0", "Purchase Invoice": "0" |
||||
c2g__codaTransactionLineItem__c.c2g__HomeValue__c | InvoiceProperties/InvoiceLines[]/IntrastatData/DetailValues/CommercialValue | TRUE | c2g__TransactionLineItems__r | |||||
c2g__codaTransactionLineItem__c.c2g__HomeValue__c | InvoiceProperties/InvoiceLines[]/IntrastatData/DetailValues/StatisticalValue | AT,BG,HR,CY,CZ,EE,FI,DE,EL,HU,IE,IT,LT,LU,MT,PL,PT,RO,SI,ES | c2g__TransactionLineItems__r | |||||
Custom field required. For information on how to configure these, see Custom Fields and Source Field Mapping. |
InvoiceProperties/InvoiceLines[]/IntrastatData/ModeOfTransport | SI | TRUE | c2g__InvoiceLineItems__r | c2g__codaInvoice__c | "Sea Transport": "1", "Railroad": "2", "Road": "3", "Air": "4", "Postal Delivery": "5", "Networks": "7", "Internal Water": "8", "With Own Means": "9" |
||
InvoiceProperties/InvoiceLines[]/IntrastatData/ModeOfTransport | SCN | TRUE | c2g__CreditNoteLineItems__r | c2g__codaCreditNote__c | "Sea Transport": "1", "Railroad": "2", "Road": "3", "Air": "4", "Postal Delivery": "5", "Networks": "7", "Internal Water": "8", "With Own Means": "9" |
|||
InvoiceProperties/InvoiceLines[]/IntrastatData/DeliveryConditions | SI | TRUE | ||||||
InvoiceProperties/InvoiceLines[]/IntrastatData/DeliveryConditions | SCN | TRUE | ||||||
c2g__codaTransaction__c.c2g__InvoiceGroup__c | InvoiceProperties/LastInvoiceNumber | SI | ES | |||||
c2g__codaTransaction__c.c2g__SalesInvoice__r.c2g__AvalaraVATReportingDocumentIndicator__c | InvoiceProperties/DocumentIndicator | SI |
"1 - Invoice": "1", "2 - Simplified Invoice": "2", "3 - Ticket": "3", "4 - Advance Payment": "4", "5 - Canceled Invoice": "5", "6 - Receipts - Italy": "6", "7 - Summary Invoice": "7", "8 - Simplified Invoice with Partner Details - Spain": "8", "9 - Regular Invoice without Partner Information - Spain": "9", "10 - Customs - Customs additional Assessment - Spain": "10" |
|||||
c2g__codaTransaction__c.c2g__PayableInvoice__r.c2g__AvalaraVATReportingDocumentIndicator__c | InvoiceProperties/DocumentIndicator | PI |
"1 - Invoice": "1", "2 - Simplified Invoice": "2", "3 - Ticket": "3", "4 - Advance Payment": "4", "5 - Canceled Invoice": "5", "6 - Receipts - Italy": "6", "7 - Summary Invoice": "7", "8 - Simplified Invoice with Partner Details - Spain": "8", "9 - Regular Invoice without Partner Information - Spain": "9", "10 - Customs - Customs additional Assessment - Spain": "10" |
|||||
c2g__codaTransaction__c.c2g__PayableCreditNote__r.c2g__AvalaraVATReportingDocumentIndicator__c | InvoiceProperties/DocumentIndicator | PCN |
"1 - Invoice": "1", "2 - Simplified Invoice": "2", "3 - Ticket": "3", "4 - Advance Payment": "4", "5 - Canceled Invoice": "5", "6 - Receipts - Italy": "6", "7 - Summary Invoice": "7", "8 - Simplified Invoice with Partner Details - Spain": "8", "9 - Regular Invoice without Partner Information - Spain": "9", "10 - Customs - Customs additional Assessment - Spain": "10" |
|||||
c2g__codaTransaction__c.c2g__SalesCreditNote__r.c2g__AvalaraVATReportingDocumentIndicator__c | InvoiceProperties/DocumentIndicator | SCN |
"1 - Invoice": "1", "2 - Simplified Invoice": "2", "3 - Ticket": "3", "4 - Advance Payment": "4", "5 - Canceled Invoice": "5", "6 - Receipts - Italy": "6", "7 - Summary Invoice": "7", "8 - Simplified Invoice with Partner Details - Spain": "8", "9 - Regular Invoice without Partner Information - Spain": "9", "10 - Customs - Customs additional Assessment - Spain": "10" |
|||||
c2g__codaTransaction__c.c2g__BillingDocument__r.c2g__AvalaraVATReportingDocumentIndicator__c | InvoiceProperties/DocumentIndicator | BD |
"1 - Invoice": "1", "2 - Simplified Invoice": "2", "3 - Ticket": "3", "4 - Advance Payment": "4", "5 - Canceled Invoice": "5", "6 - Receipts - Italy": "6", "7 - Summary Invoice": "7", "8 - Simplified Invoice with Partner Details - Spain": "8", "9 - Regular Invoice without Partner Information - Spain": "9", "10 - Customs - Customs additional Assessment - Spain": "10" |
|||||
c2g__codaTransaction__c.c2g__DocumentNumber__c | InvoiceProperties/SupplierData/VATNumber/VATNumberType | PI,PCN | IT | |||||
c2g__codaTransaction__c.c2g__DocumentNumber__c | InvoiceProperties/CustomerData/VATNumber/VATNumberType | SI,SCN,BD | IT |