Avalara VAT Reporting Mappings Table

This table details the Avalara VAT Reporting mappings.

Note:

Some entries in the Source Field column are empty. You must create your own custom fields for those XML paths. For information on how to configure these, see Custom Fields and Source Field Mapping.

Key: R - Required.

Avalara VAT Reporting Mappings Fields

Source Field

  

XML Path

 Document Type

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 R InvoiceProperties/SupplierInvoiceNumber PI, PCN          
c2g__codaTransaction__c.c2g__Account__c   InvoiceProperties/SupplierID PI, PCN          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAVATRegistrationNumber__c R InvoiceProperties/SupplierData/VATNumber/VATNumber PI, PCN          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c R InvoiceProperties/SupplierData/VATNumber/VATNumberCountry PI, PCN          
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 R InvoiceProperties/CustomerData/VATNumber/VATNumber PI, PCN          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c R InvoiceProperties/CustomerData/VATNumber/VATNumberCountry PI, PCN          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c R InvoiceProperties/SupplierData/Country PI, PCN          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c R InvoiceProperties/CustomerData/Country PI, PCN          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c R InvoiceProperties/CountryVATNumberUsedBySupplier PI, PCN          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c R InvoiceProperties/CountryVATNumberUsedByCustomer PI, PCN          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAVATRegistrationNumber__c R InvoiceProperties/SupplierData/VATNumber/TaxNumber PI, PCN          
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 R InvoiceProperties/SupplierData/VATNumber/VATNumber SI, SCN, BD          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c R InvoiceProperties/SupplierData/VATNumber/VATNumberCountry SI, SCN, BD          
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, PL        
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__Street__c   InvoiceProperties/SupplierData/Address SI, SCN, BD IT, PL        
c2g__codaTransaction__c.c2g__Account__r.BillingCity   InvoiceProperties/SupplierData/City PI, PCN IT, PL        
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__City__c   InvoiceProperties/SupplierData/City SI, SCN, BD IT, PL        
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 R InvoiceProperties/CustomerData/VATNumber/VATNumber SI, SCN, BD          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c R InvoiceProperties/CustomerData/VATNumber/VATNumberCountry SI, SCN, BD          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c R InvoiceProperties/SupplierData/Country SI, SCN, BD          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c R InvoiceProperties/CustomerData/Country SI, SCN, BD          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__VATRegistrationNumber__c R InvoiceProperties/SupplierData/VATNumber/TaxNumber SI, SCN, BD          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c R InvoiceProperties/CountryVATNumberUsedBySupplier SI, SCN, BD          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c R InvoiceProperties/CountryVATNumberUsedByCustomer SI, SCN, BD          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c R InvoiceProperties/SupplierData/VATNumber/TaxNumberCountry SI, SCN, BD          
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 R InvoiceProperties/SupplierData/VATNumber/TaxNumberCountry PI, PCN          
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__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 R InvoiceProperties/IntrastatDocumentData/CountryDispatch SI   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 R InvoiceProperties/IntrastatDocumentData/CountryDispatch SI   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 R InvoiceProperties/IntrastatDocumentData/CountryDispatch SCN   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 R InvoiceProperties/IntrastatDocumentData/CountryDispatch SCN   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 R InvoiceProperties/IntrastatDocumentData/CountryDispatch PI          
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 R InvoiceProperties/IntrastatDocumentData/CountryArrival PI          
c2g__codaTransactionLineItem__c.c2g__LineDescription__c R InvoiceProperties/InvoiceLines[]/Description       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",
"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[]/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",
"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__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, PL   c2g__TransactionLineItems__r    
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__SalesInvoice__r.c2g__InvoiceDate__c   InvoiceProperties/InvoiceLines[]/DateOfSupply SI ES, PL   c2g__TransactionLineItems__r    
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__PayableCreditNote__r.c2g__InvoiceDate__c   InvoiceProperties/InvoiceLines[]/DateOfSupply PCN ES, PL   c2g__TransactionLineItems__r    
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__SalesCreditNote__r.c2g__InvoiceDate__c   InvoiceProperties/InvoiceLines[]/DateOfSupply SCN ES, PL   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, PL        
c2g__codaTransaction__c.c2g__Account__r.BillingPostalCode   InvoiceProperties/SupplierData/ZIP PI, PCN ES, IT, PL        
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, PL   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 R InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode PI   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 R InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode PI   c2g__PurchaseInvoiceExpenseLineItems__r c2g__codaPurchaseInvoice__c    
c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Sales_Order_Line_Item__r.SCMC__Quantity__c R InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1 SI   c2g__codaInvoice__c c2g__InvoiceLineItems__r    
c2g__codaCreditNoteLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Sales_Order_Line_Item__r.SCMC__Quantity__c R InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1 SCN   c2g__codaCreditNote__c c2g__CreditNoteLineItems__r    
c2g__codaPurchaseInvoiceLineItem__c.SCMFFA__AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Quantity__c R InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1 PI   c2g__PurchaseInvoiceLineItems__r c2g__codaPurchaseInvoice__c    
c2g__codaPurchaseInvoiceExpenseLineItem__c.SCMFFA__AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Quantity__c R InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1 PI   c2g__PurchaseInvoiceExpenseLineItems__r c2g__codaPurchaseInvoice__c    
c2g__codaInvoiceLineItem__c.SCMFFA__Item_Name__r.SCMC__Stocking_UOM__r.Name R InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1 SI   c2g__codaInvoice__c c2g__InvoiceLineItems__r    
c2g__codaCreditNoteLineItem__c.SCMFFA__Item_Name__r.SCMC__Stocking_UOM__r.Name R InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1 SCN   c2g__codaCreditNote__c c2g__CreditNoteLineItems__r    
c2g__codaPurchaseInvoiceLineItem__c.SCMFFA__Item_Master__r.SCMC__Stocking_UOM__r.Name R InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1 PI   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 R InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1 PI   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 R InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin SI   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 R InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin SI   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 R InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin SCN   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 R InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin SCN   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 R InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin PI          
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 R InvoiceProperties/InvoiceLines[]/IntrastatData/DetailValues/CommercialValue       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.

 R InvoiceProperties/InvoiceLines[]/IntrastatData/ModeOfTransport SI   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"
R InvoiceProperties/InvoiceLines[]/IntrastatData/ModeOfTransport SCN   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"
R InvoiceProperties/InvoiceLines[]/IntrastatData/DeliveryConditions SI          
R InvoiceProperties/InvoiceLines[]/IntrastatData/DeliveryConditions SCN          
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        
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 R InvoiceProperties/SupplierInvoiceNumber PI, PCN          
c2g__codaTransaction__c.c2g__Account__c   InvoiceProperties/SupplierID PI, PCN          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAVATRegistrationNumber__c R InvoiceProperties/SupplierData/VATNumber/VATNumber PI, PCN          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c R InvoiceProperties/SupplierData/VATNumber/VATNumberCountry PI, PCN          
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 R InvoiceProperties/CustomerData/VATNumber/VATNumber PI, PCN          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c R InvoiceProperties/CustomerData/VATNumber/VATNumberCountry PI, PCN          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c R InvoiceProperties/SupplierData/Country PI, PCN          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c R InvoiceProperties/CustomerData/Country PI, PCN          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c R InvoiceProperties/CountryVATNumberUsedBySupplier PI, PCN          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c R InvoiceProperties/CountryVATNumberUsedByCustomer PI, PCN          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAVATRegistrationNumber__c R InvoiceProperties/SupplierData/VATNumber/TaxNumber PI, PCN          
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 R InvoiceProperties/SupplierData/VATNumber/VATNumber SI, SCN, BD          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c R InvoiceProperties/SupplierData/VATNumber/VATNumberCountry SI, SCN, BD          
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, PL        
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__Street__c   InvoiceProperties/SupplierData/Address SI, SCN, BD IT, PL        
c2g__codaTransaction__c.c2g__Account__r.BillingCity   InvoiceProperties/SupplierData/City PI, PCN IT, PL        
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__City__c   InvoiceProperties/SupplierData/City SI, SCN, BD IT, PL        
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 R InvoiceProperties/CustomerData/VATNumber/VATNumber SI, SCN, BD          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c R InvoiceProperties/CustomerData/VATNumber/VATNumberCountry SI, SCN, BD          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c R InvoiceProperties/SupplierData/Country SI, SCN, BD          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c R InvoiceProperties/CustomerData/Country SI, SCN, BD          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__VATRegistrationNumber__c R InvoiceProperties/SupplierData/VATNumber/TaxNumber SI, SCN, BD          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c R InvoiceProperties/CountryVATNumberUsedBySupplier SI, SCN, BD          
c2g__codaTransaction__c.c2g__Account__r.c2g__CODAECCountryCode__c R InvoiceProperties/CountryVATNumberUsedByCustomer SI, SCN, BD          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c R InvoiceProperties/SupplierData/VATNumber/TaxNumberCountry SI, SCN, BD          
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 R InvoiceProperties/SupplierData/VATNumber/TaxNumberCountry PI, PCN          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__VATRegistrationNumber__c R InvoiceProperties/CustomerData/VATNumber/TaxNumber PI, PCN          
c2g__codaTransaction__c.c2g__OwnerCompany__r.c2g__ECCountryCode__c R 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__codaPurchaseInvoice__c.c2g__InvoiceCurrency__r.Name   InvoiceProperties/DocumentCurrency PI PL        
c2g__codaPurchaseCreditNote__c.c2g__CreditNoteCurrency__r.Name   InvoiceProperties/DocumentCurrency PCN PL        
c2g__codaInvoice__c.c2g__InvoiceCurrency__r.Name   InvoiceProperties/DocumentCurrency SI PL        
c2g__codaCreditNote__c.c2g__CreditNoteCurrency__r.Name   InvoiceProperties/DocumentCurrency SCN PL        
c2g__codaTransaction__c.c2g__TransactionType__c   InvoiceProperties/IntrastatDocumentData/TransactionType SI, SCN, PI, PCN         "Invoice": "11", "Credit Note": "21", "Purchase Invoice": "11", "Purchase Credit Note": "21"
c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Sales_Order_Line_Item__r.SCMC__Supplier_Site__r.SCMC__Mailing_Country__c R InvoiceProperties/IntrastatDocumentData/CountryDispatch SI   c2g__InvoiceLineItems__r c2g__codaInvoice__c "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 R InvoiceProperties/IntrastatDocumentData/CountryDispatch SI   c2g__InvoiceLineItems__r c2g__codaInvoice__c "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 R InvoiceProperties/IntrastatDocumentData/CountryDispatch SCN   c2g__CreditNoteLineItems__r c2g__codaCreditNote__c "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 R InvoiceProperties/IntrastatDocumentData/CountryDispatch SCN   c2g__CreditNoteLineItems__r c2g__codaCreditNote__c "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__codaTransaction__c.c2g__Account__r.ShippingCountry   InvoiceProperties/IntrastatDocumentData/CountryArrival SI, SCN          
c2g__codaPurchaseInvoice__c.SCMFFA__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Supplier_Site__r.SCMC__Mailing_Country__c R InvoiceProperties/IntrastatDocumentData/CountryDispatch PI          
c2g__codaPurchaseInvoice__c.SCMFFA__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Ship_To_Warehouse__r.SCMC__Address__r.SCMC__Country__c R InvoiceProperties/IntrastatDocumentData/CountryArrival PI          
c2g__codaPurchaseCreditNote__c.SCMFFA__AP_Voucher_Credit__r.SCMC__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Supplier_Site__r.SCMC__Mailing_Country__c R InvoiceProperties/IntrastatDocumentData/CountryDispatch PCN          
c2g__codaPurchaseCreditNote__c.SCMFFA__AP_Voucher_Credit__r.SCMC__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Ship_To_Warehouse__r.SCMC__Address__r.SCMC__Country__c R InvoiceProperties/IntrastatDocumentData/CountryArrival PCN          
c2g__codaTransactionLineItem__c.c2g__LineDescription__c R InvoiceProperties/InvoiceLines[]/Description     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", "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[]/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", "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__TaxCode1__r.Name   InvoiceProperties/InvoiceLines[]/LineVATCode     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   "SourceField": "c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__c", "ChildRelationship": "c2g__TransactionLineItems__r", "Operator": "equals", "Value": ""  
c2g__codaTransactionLineItem__c.c2g__ReverseChargeTaxCode__r.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__r.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, PL c2g__TransactionLineItems__r      
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__SalesInvoice__r.c2g__InvoiceDate__c   InvoiceProperties/InvoiceLines[]/DateOfSupply SI ES, PL c2g__TransactionLineItems__r      
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__PayableCreditNote__r.c2g__InvoiceDate__c   InvoiceProperties/InvoiceLines[]/DateOfSupply PCN ES, PL c2g__TransactionLineItems__r      
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__SalesCreditNote__r.c2g__InvoiceDate__c   InvoiceProperties/InvoiceLines[]/DateOfSupply SCN ES, PL 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, PL        
c2g__codaTransaction__c.c2g__Account__r.BillingPostalCode   InvoiceProperties/SupplierData/ZIP PI, PCN ES, IT, PL        
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, PL c2g__TransactionLineItems__r      
c2g__codaInvoiceLineItem__c.SCMFFA__Item_Name__r.SCMC__Commodity_Code__r.SCMC__Number__c R InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode SI   c2g__InvoiceLineItems__r c2g__codaInvoice__c    
c2g__codaCreditNoteLineItem__c.SCMFFA__Item_Name__r.SCMC__Commodity_Code__r.SCMC__Number__c R InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode SCN   c2g__CreditNoteLineItems__r c2g__codaCreditNote__c    
c2g__codaPurchaseInvoiceLineItem__c.SCMFFA__Item_Master__r.SCMC__Commodity_Code__r.SCMC__Number__c R InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode PI   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 R InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode PI   c2g__PurchaseInvoiceExpenseLineItems__r c2g__codaPurchaseInvoice__c    
c2g__codaPurchaseCreditNoteLineItem__c.SCMFFA__AP_Voucher_Line_Credit__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Item_Master__r.SCMC__Commodity_Code__r.SCMC__Number__c R InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode PCN   c2g__PurchaseCreditNoteLineItems__r c2g__codaPurchaseCreditNote__c    
c2g__codaPurchaseCreditNoteExpLineItem__c.SCMFFA__AP_Voucher_Line_Credit__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Item_Master__r.SCMC__Commodity_Code__r.SCMC__Number__c R InvoiceProperties/InvoiceLines[]/IntrastatData/IntrastatCode PCN   c2g__PurchaseCreditNoteExpenseLineItems__r c2g__codaPurchaseCreditNote__c    
c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Sales_Order_Line_Item__r.SCMC__Quantity__c R InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1 SI   c2g__InvoiceLineItems__r c2g__codaInvoice__c    
c2g__codaCreditNoteLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Sales_Order_Line_Item__r.SCMC__Quantity__c R InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1 SCN   c2g__CreditNoteLineItems__r c2g__codaCreditNote__c    
c2g__codaPurchaseInvoiceLineItem__c.SCMFFA__AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Quantity__c R InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1 PI   c2g__PurchaseInvoiceLineItems__r c2g__codaPurchaseInvoice__c    
c2g__codaPurchaseInvoiceExpenseLineItem__c.SCMFFA__AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Quantity__c R InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1 PI   c2g__PurchaseInvoiceExpenseLineItems__r c2g__codaPurchaseInvoice__c    
c2g__codaPurchaseCreditNoteLineItem__c.SCMFFA__AP_Voucher_Line_Credit__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Quantity__c R InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1 PCN   c2g__PurchaseCreditNoteLineItems__r c2g__codaPurchaseCreditNote__c    
c2g__codaPurchaseCreditNoteExpLineItem__c.SCMFFA__AP_Voucher_Line_Credit__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Quantity__c R InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity1 PCN   c2g__PurchaseCreditNoteExpenseLineItems__r c2g__codaPurchaseCreditNote__c    
c2g__codaInvoiceLineItem__c.SCMFFA__Item_Name__r.SCMC__Stocking_UOM__r.Name R InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1 SI   c2g__InvoiceLineItems__r c2g__codaInvoice__c    
c2g__codaCreditNoteLineItem__c.SCMFFA__Item_Name__r.SCMC__Stocking_UOM__r.Name R InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1 SCN   c2g__CreditNoteLineItems__r c2g__codaCreditNote__c    
c2g__codaPurchaseInvoiceLineItem__c.SCMFFA__Item_Master__r.SCMC__Stocking_UOM__r.Name R InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1 PI   c2g__PurchaseInvoiceLineItems__r c2g__codaPurchaseInvoice__c    
c2g__codaPurchaseInvoiceExpenseLineItem__c.SCMFFA__AP_Voucher_Line__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Stocking_Unit_of_Measure__c R InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1 PI   c2g__PurchaseInvoiceExpenseLineItems__r c2g__codaPurchaseInvoice__c    
c2g__codaPurchaseCreditNoteLineItem__c.SCMFFA__AP_Voucher_Line_Credit__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Item_Master__r.SCMC__Stocking_UOM__r.Name R InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1 PCN   c2g__PurchaseCreditNoteLineItems__r c2g__codaPurchaseCreditNote__c    
c2g__codaPurchaseCreditNoteExpLineItem__c.SCMFFA__AP_Voucher_Line_Credit__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Item_Master__r.SCMC__Stocking_UOM__r.Name R InvoiceProperties/InvoiceLines[]/IntrastatData/Unit1 PCN   c2g__PurchaseCreditNoteExpenseLineItems__r c2g__codaPurchaseCreditNote__c    
    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/Quantity2 PCN   c2g__PurchaseCreditNoteLineItems__r c2g__codaPurchaseCreditNote__c    
    InvoiceProperties/InvoiceLines[]/IntrastatData/Quantity2 PCN   c2g__PurchaseCreditNoteExpenseLineItems__r c2g__codaPurchaseCreditNote__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    
    InvoiceProperties/InvoiceLines[]/IntrastatData/Unit2 PCN   c2g__PurchaseCreditNoteLineItems__r c2g__codaPurchaseCreditNote__c    
    InvoiceProperties/InvoiceLines[]/IntrastatData/Unit2 PCN   c2g__PurchaseCreditNoteExpenseLineItems__r c2g__codaPurchaseCreditNote__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__InvoiceLineItems__r c2g__codaInvoice__c "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__InvoiceLineItems__r c2g__codaInvoice__c "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__CreditNoteLineItems__r c2g__codaCreditNote__c "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__CreditNoteLineItems__r c2g__codaCreditNote__c "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__codaPurchaseCreditNote__c.SCMFFA__AP_Voucher_Credit__r.SCMC__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Supplier_Site__r.SCMC__Mailing_State_Province__c   InvoiceProperties/InvoiceLines[]/IntrastatData/RegionDispatch PCN 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__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__codaPurchaseCreditNoteLineItem__c.SCMFFA__AP_Voucher_Line_Credit__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Warehouse__r.SCMC__Address__r.SCMC__State__c   InvoiceProperties/InvoiceLines[]/IntrastatData/RegionArrival PCN BE,FR,DE,ES,IT,SK,BG c2g__PurchaseCreditNoteLineItems__r c2g__codaPurchaseCreditNote__c    
c2g__codaPurchaseCreditNoteExpLineItem__c.SCMFFA__AP_Voucher_Line_Credit__r.SCMC__Purchase_Order_Line_Item__r.SCMC__Warehouse__r.SCMC__Address__r.SCMC__State__c   InvoiceProperties/InvoiceLines[]/IntrastatData/RegionArrival PCN BE,FR,DE,ES,IT,SK,BG c2g__PurchaseCreditNoteExpenseLineItems__r c2g__codaPurchaseCreditNote__c    
c2g__codaInvoiceLineItem__c.SCMFFA__SCM_Invoice_Line__r.SCMC__Sales_Order_Line_Item__r.SCMC__Supplier_Site__r.SCMC__Mailing_Country__c R InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin SI   c2g__InvoiceLineItems__r c2g__codaInvoice__c "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 R InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin SI   c2g__InvoiceLineItems__r c2g__codaInvoice__c "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 R InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin SCN   c2g__CreditNoteLineItems__r c2g__codaCreditNote__c "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 R InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin SCN   c2g__CreditNoteLineItems__r c2g__codaCreditNote__c "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 R InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin PI          
c2g__codaPurchaseCreditNote__c.SCMFFA__AP_Voucher_Credit__r.SCMC__AP_Voucher__r.SCMC__Purchase_Order__r.SCMC__Supplier_Site__r.SCMC__Mailing_Country__c R InvoiceProperties/InvoiceLines[]/IntrastatData/CountryOrigin PCN          
c2g__codaTransactionLineItem__c.c2g__Transaction__r.c2g__TransactionType__c   InvoiceProperties/InvoiceLines[]/IntrastatData/ItemType SI, SCN, PI, PCN   c2g__TransactionLineItems__r     "Invoice": "0", "Credit Note": "0", "Purchase Invoice": "0", "Purchase Credit Note": "0"
c2g__codaTransactionLineItem__c.c2g__HomeValue__c   InvoiceProperties/InvoiceLines[]/IntrastatData/DetailValues/CommercialValue     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      
  R InvoiceProperties/InvoiceLines[]/IntrastatData/ModeOfTransport SI   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"
  R InvoiceProperties/InvoiceLines[]/IntrastatData/ModeOfTransport SCN   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"
  R InvoiceProperties/InvoiceLines[]/IntrastatData/DeliveryConditions SI          
  R InvoiceProperties/InvoiceLines[]/IntrastatData/DeliveryConditions SCN          
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", "13 - Internal Document - Poland", "14 - Invoice issued under the flat rate scheme for farmers - Poland", "15 - Invoice issued by sellers under the cash accounting scheme - Poland", "16 - Sales receipt issued through a cash register that are included in a summary document for VAT - Poland"
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", "13 - Internal Document - Poland", "14 - Invoice issued under the flat rate scheme for farmers - Poland", "15 - Invoice issued by sellers under the cash accounting scheme - Poland", "16 - Sales receipt issued through a cash register that are included in a summary document for VAT - Poland"
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", "13 - Internal Document - Poland", "14 - Invoice issued under the flat rate scheme for farmers - Poland", "15 - Invoice issued by sellers under the cash accounting scheme - Poland", "16 - Sales receipt issued through a cash register that are included in a summary document for VAT - Poland"
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", "13 - Internal Document - Poland", "14 - Invoice issued under the flat rate scheme for farmers - Poland", "15 - Invoice issued by sellers under the cash accounting scheme - Poland", "16 - Sales receipt issued through a cash register that are included in a summary document for VAT - Poland"
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", "13 - Internal Document - Poland", "14 - Invoice issued under the flat rate scheme for farmers - Poland", "15 - Invoice issued by sellers under the cash accounting scheme - Poland", "16 - Sales receipt issued through a cash register that are included in a summary document for VAT - Poland"
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        

c2g__codaCreditNote__c.c2g__Invoice__r.Name

c2g__codaPurchaseCreditNote__c.c2g__PurchaseInvoice__r.Name

   InvoiceProperties/CreditNoteOriginalDocument SCN, PCN PL        

c2g__codaPurchaseCreditNote__c.c2g__CreditNoteReason__c

c2g__codaCreditNote__c.c2g__CreditNoteReason__c

   InvoiceProperties/CreditNoteReason SCN, PCN PL        
c2g__codaTransaction__c.c2g__Period__r.Name   InvoiceProperties/CreditNotePeriod SCN, PCN PL        

c2g__codaPurchaseInvoice__c.c2g__RegisteredDate__c

c2g__codaPurchaseCreditNote__c.c2g__RegisteredDate__c

   InvoiceProperties/InvoiceReceiptDate PIN, PCN PL        

c2g__codaCreditNoteLineItem__c.c2g__Quantity__c

c2g__codaInvoiceLineItem__c.c2g__Quantity__c

   InvoiceProperties/InvoiceLines[]/Quantity SIN, SCN PL        

c2g__codaCreditNoteLineItem__c.c2g__UnitPrice__c

c2g__codaInvoiceLineItem__c.c2g__UnitPrice__c

   InvoiceProperties/InvoiceLines[]/Unit SIN, SCN PL        

Key: R - Required.

Avalara VAT Reporting Mappings Custom Fields

Custom Field

  

XML Path

 Document Type

Country

Child Relationship

Parent Object

Conditions

 Value Transformation
ExemptionReason   InvoiceProperties/InvoiceLines[]/ExemptionReason SIN, SCN PL c2g__InvoiceLineItems__r c2g__codaInvoice__c    
ExemptionReason   InvoiceProperties/InvoiceLines[]/ExemptionReason SCN PL c2g__CreditNoteLineItems__r c2g__codaCreditNote__c    
ItemIdentifier   InvoiceProperties/InvoiceLines[]/ItemIdentifier SIN, SCN, PIN, PCN PL c2g__InvoiceLineItems__r c2g__codaInvoice__c    
ItemIdentifier   InvoiceProperties/InvoiceLines[]/ItemIdentifier SCN PL c2g__CreditNoteLineItems__r c2g__codaCreditNote__c    
ItemIdentifier   InvoiceProperties/InvoiceLines[]/ItemIdentifier PIN PL c2g__PurchaseInvoiceLineItems__r c2g__codaPurchaseInvoice__c    
ItemIdentifier   InvoiceProperties/InvoiceLines[]/ItemIdentifier PCN PL c2g__PurchaseCreditNoteLineItems__r c2g__codaPurchaseCreditNote__c    
OutsourcingPartyAddress   InvoiceProperties/OutsourcingPartyAddress SIN, SCN PL        
OutsourcingPartyName   InvoiceProperties/OutsourcingPartyName SIN, SCN PL        
OutsourcingPartyType   InvoiceProperties/OutsourcingPartyType SIN, SCN PL       "Self": "0", "Customer": "1", "Third Party": "2"
OutsourcingPartyVRN   InvoiceProperties/OutsourcingPartyVRN SIN, SCN PL