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.

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",
"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   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