/
Map Avalara Fields
Map Avalara Fields
- Scott Zhuo
- Muhammad.Umair
- Patricia Zhuo
Owned by Scott Zhuo
Use the Developer Console to get access to the XML Mapping field.
Click on the Query Editor tab.
Copy and paste the following code into the Query Editor and Execute.
SELECT FIELDS(ALL) FROM AVA_SFCLOUD__AvaTax_Mapping__c LIMIT 10One record will be returned. Copy and paste the content in the column named AVA_SFCloud_Field to an online XML formatter so you can easily update the mappings, then copy the content back to the AVA_SFCloud_Field field.
Format XML
After copying the XML, you should format it using a formatter to better understand it.
We recommend using this: Best XML Formatter and XML Beautifier
Sample file below:
<avatax>
<addressvalidation>
<Account>
<hooks>
<avaconfig>AVA_SFCLOUD.ConfigProviderForAddressValidation</avaconfig>
</hooks>
<Billing>
<query>select BillingStreet, BillingCity,BillingState,BillingCountry,BillingPostalCode from Account where id = '{AccountId}'</query>
<parameters>
<AccountId>Id</AccountId>
</parameters>
<Mapping>
<line1>BillingStreet</line1>
<city>BillingCity</city>
<region>BillingState</region>
<country>BillingCountry</country>
<postalcode>BillingPostalCode</postalcode>
</Mapping>
<UpdateMapping>
<line1>BillingStreet</line1>
<city>BillingCity</city>
<region>BillingState</region>
<country>BillingCountry</country>
<postalcode>BillingPostalCode</postalcode>
</UpdateMapping>
</Billing>
<Shipping>
<query>select ShippingStreet, ShippingCity,ShippingState,ShippingCountry,ShippingPostalCode from Account where id = '{AccountId}'</query>
<parameters>
<AccountId>Id</AccountId>
</parameters>
<Mapping>
<line1>ShippingStreet</line1>
<city>ShippingCity</city>
<region>ShippingState</region>
<country>ShippingCountry</country>
<postalcode>ShippingPostalCode</postalcode>
</Mapping>
<UpdateMapping>
<line1>ShippingStreet</line1>
<city>ShippingCity</city>
<region>ShippingState</region>
<country>ShippingCountry</country>
<postalcode>ShippingPostalCode</postalcode>
</UpdateMapping>
</Shipping>
</Account>
<Opportunity>
<hooks>
<avaconfig>AVA_SFCLOUD.ConfigProviderForAddressValidation</avaconfig>
</hooks>
<Origin>
<query>select AVA_SFCLOUD__Origin_Street__c, AVA_SFCLOUD__Origin_City__c, AVA_SFCLOUD__Origin_State__c, AVA_SFCLOUD__Origin_Country__c, AVA_SFCLOUD__Origin_Postal_Code__c From Opportunity Where id = '{OpportunityId}'</query>
<parameters>
<OpportunityId>Id</OpportunityId>
</parameters>
<Mapping>
<line1>AVA_SFCLOUD__Origin_Street__c</line1>
<city>AVA_SFCLOUD__Origin_City__c</city>
<region>AVA_SFCLOUD__Origin_State__c</region>
<country>AVA_SFCLOUD__Origin_Country__c</country>
<postalcode>AVA_SFCLOUD__Origin_Postal_Code__c</postalcode>
</Mapping>
<UpdateMapping>
<line1>AVA_SFCLOUD__Origin_Street__c</line1>
<city>AVA_SFCLOUD__Origin_City__c</city>
<region>AVA_SFCLOUD__Origin_State__c</region>
<country>AVA_SFCLOUD__Origin_Country__c</country>
<postalcode>AVA_SFCLOUD__Origin_Postal_Code__c</postalcode>
</UpdateMapping>
</Origin>
</Opportunity>
<OpportunityLineItem>
<hooks>
<avaconfig>AVA_SFCLOUD.ConfigProviderForAddressValidation</avaconfig>
</hooks>
<Shipping>
<query>select AVA_SFCLOUD__Shipping_Street_Line__c, AVA_SFCLOUD__Shipping_City_Line__c, AVA_SFCLOUD__Shipping_State_Line__c, AVA_SFCLOUD__Shipping_Country_Line__c, AVA_SFCLOUD__Shipping_Postal_Code_Line__c from OpportunityLineItem Where id = '{OpportunityLineItemId}'</query>
<parameters>
<OpportunityLineItemId>Id</OpportunityLineItemId>
</parameters>
<Mapping>
<line1>AVA_SFCLOUD__Shipping_Street_Line__c</line1>
<city>AVA_SFCLOUD__Shipping_City_Line__c</city>
<region>AVA_SFCLOUD__Shipping_State_Line__c</region>
<country>AVA_SFCLOUD__Shipping_Country_Line__c</country>
<postalcode>AVA_SFCLOUD__Shipping_Postal_Code_Line__c</postalcode>
</Mapping>
<UpdateMapping>
<line1>AVA_SFCLOUD__Shipping_Street_Line__c</line1>
<city>AVA_SFCLOUD__Shipping_City_Line__c</city>
<region>AVA_SFCLOUD__Shipping_State_Line__c</region>
<country>AVA_SFCLOUD__Shipping_Country_Line__c</country>
<postalcode>AVA_SFCLOUD__Shipping_Postal_Code_Line__c</postalcode>
</UpdateMapping>
</Shipping>
</OpportunityLineItem>
<Quote>
<hooks>
<avaconfig>AVA_SFCLOUD.ConfigProviderForAddressValidation</avaconfig>
</hooks>
<Billing>
<query>select BillingStreet, BillingCity,BillingState,BillingCountry,BillingPostalCode from Quote where id = '{QuoteId}'</query>
<parameters>
<QuoteId>Id</QuoteId>
</parameters>
<Mapping>
<line1>BillingStreet</line1>
<city>BillingCity</city>
<region>BillingState</region>
<country>BillingCountry</country>
<postalcode>BillingPostalCode</postalcode>
</Mapping>
<UpdateMapping>
<line1>BillingStreet</line1>
<city>BillingCity</city>
<region>BillingState</region>
<country>BillingCountry</country>
<postalcode>BillingPostalCode</postalcode>
</UpdateMapping>
</Billing>
<Shipping>
<query>select ShippingStreet, ShippingCity,ShippingState,ShippingCountry,ShippingPostalCode from Quote where id = '{QuoteId}'</query>
<parameters>
<QuoteId>Id</QuoteId>
</parameters>
<Mapping>
<line1>ShippingStreet</line1>
<city>ShippingCity</city>
<region>ShippingState</region>
<country>ShippingCountry</country>
<postalcode>ShippingPostalCode</postalcode>
</Mapping>
<UpdateMapping>
<line1>ShippingStreet</line1>
<city>ShippingCity</city>
<region>ShippingState</region>
<country>ShippingCountry</country>
<postalcode>ShippingPostalCode</postalcode>
</UpdateMapping>
</Shipping>
<Origin>
<query>select AVA_SFCLOUD__Origin_Street__c, AVA_SFCLOUD__Origin_City__c, AVA_SFCLOUD__Origin_State__c, AVA_SFCLOUD__Origin_Country__c, AVA_SFCLOUD__Origin_Postal_Code__c From Quote Where id = '{QuoteId}'</query>
<parameters>
<QuoteId>Id</QuoteId>
</parameters>
<Mapping>
<line1>AVA_SFCLOUD__Origin_Street__c</line1>
<city>AVA_SFCLOUD__Origin_City__c</city>
<region>AVA_SFCLOUD__Origin_State__c</region>
<country>AVA_SFCLOUD__Origin_Country__c</country>
<postalcode>AVA_SFCLOUD__Origin_Postal_Code__c</postalcode>
</Mapping>
<UpdateMapping>
<line1>AVA_SFCLOUD__Origin_Street__c</line1>
<city>AVA_SFCLOUD__Origin_City__c</city>
<region>AVA_SFCLOUD__Origin_State__c</region>
<country>AVA_SFCLOUD__Origin_Country__c</country>
<postalcode>AVA_SFCLOUD__Origin_Postal_Code__c</postalcode>
</UpdateMapping>
</Origin>
</Quote>
<QuoteLineItem>
<hooks>
<avaconfig>AVA_SFCLOUD.ConfigProviderForAddressValidation</avaconfig>
</hooks>
<Shipping>
<query>select AVA_SFCLOUD__Shipping_Street_Line__c, AVA_SFCLOUD__Shipping_City_Line__c, AVA_SFCLOUD__Shipping_State_Line__c, AVA_SFCLOUD__Shipping_Country_Line__c, AVA_SFCLOUD__Shipping_Postal_Code_Line__c from QuoteLineItem Where id = '{QuoteLineItemId}'</query>
<parameters>
<QuoteLineItemId>Id</QuoteLineItemId>
</parameters>
<Mapping>
<line1>AVA_SFCLOUD__Shipping_Street_Line__c</line1>
<city>AVA_SFCLOUD__Shipping_City_Line__c</city>
<region>AVA_SFCLOUD__Shipping_State_Line__c</region>
<country>AVA_SFCLOUD__Shipping_Country_Line__c</country>
<postalcode>AVA_SFCLOUD__Shipping_Postal_Code_Line__c</postalcode>
</Mapping>
<UpdateMapping>
<line1>AVA_SFCLOUD__Shipping_Street_Line__c</line1>
<city>AVA_SFCLOUD__Shipping_City_Line__c</city>
<region>AVA_SFCLOUD__Shipping_State_Line__c</region>
<country>AVA_SFCLOUD__Shipping_Country_Line__c</country>
<postalcode>AVA_SFCLOUD__Shipping_Postal_Code_Line__c</postalcode>
</UpdateMapping>
</Shipping>
</QuoteLineItem>
<Order>
<hooks>
<avaconfig>AVA_SFCLOUD.ConfigProviderForAddressValidation</avaconfig>
</hooks>
<Billing>
<query>select BillingStreet, BillingCity,BillingState,BillingCountry,BillingPostalCode from Order where id = '{OrderId}'</query>
<parameters>
<OrderId>Id</OrderId>
</parameters>
<Mapping>
<line1>BillingStreet</line1>
<city>BillingCity</city>
<region>BillingState</region>
<country>BillingCountry</country>
<postalcode>BillingPostalCode</postalcode>
</Mapping>
<UpdateMapping>
<line1>BillingStreet</line1>
<city>BillingCity</city>
<region>BillingState</region>
<country>BillingCountry</country>
<postalcode>BillingPostalCode</postalcode>
</UpdateMapping>
</Billing>
<Shipping>
<query>select ShippingStreet, ShippingCity,ShippingState,ShippingCountry,ShippingPostalCode from Order where id = '{OrderId}'</query>
<parameters>
<OrderId>Id</OrderId>
</parameters>
<Mapping>
<line1>ShippingStreet</line1>
<city>ShippingCity</city>
<region>ShippingState</region>
<country>ShippingCountry</country>
<postalcode>ShippingPostalCode</postalcode>
</Mapping>
<UpdateMapping>
<line1>ShippingStreet</line1>
<city>ShippingCity</city>
<region>ShippingState</region>
<country>ShippingCountry</country>
<postalcode>ShippingPostalCode</postalcode>
</UpdateMapping>
</Shipping>
<Origin>
<query>select AVA_SFCLOUD__Origin_Street__c, AVA_SFCLOUD__Origin_City__c, AVA_SFCLOUD__Origin_State__c, AVA_SFCLOUD__Origin_Country__c, AVA_SFCLOUD__Origin_Postal_Code__c From Order Where id = '{OrderId}'</query>
<parameters>
<OrderId>Id</OrderId>
</parameters>
<Mapping>
<line1>AVA_SFCLOUD__Origin_Street__c</line1>
<city>AVA_SFCLOUD__Origin_City__c</city>
<region>AVA_SFCLOUD__Origin_State__c</region>
<country>AVA_SFCLOUD__Origin_Country__c</country>
<postalcode>AVA_SFCLOUD__Origin_Postal_Code__c</postalcode>
</Mapping>
<UpdateMapping>
<line1>AVA_SFCLOUD__Origin_Street__c</line1>
<city>AVA_SFCLOUD__Origin_City__c</city>
<region>AVA_SFCLOUD__Origin_State__c</region>
<country>AVA_SFCLOUD__Origin_Country__c</country>
<postalcode>AVA_SFCLOUD__Origin_Postal_Code__c</postalcode>
</UpdateMapping>
</Origin>
</Order>
<OrderItem>
<hooks>
<avaconfig>AVA_SFCLOUD.ConfigProviderForAddressValidation</avaconfig>
</hooks>
<Shipping>
<query>select AVA_SFCLOUD__Shipping_Street_Line__c, AVA_SFCLOUD__Shipping_City_Line__c, AVA_SFCLOUD__Shipping_State_Line__c, AVA_SFCLOUD__Shipping_Country_Line__c, AVA_SFCLOUD__Shipping_Postal_Code_Line__c from OrderItem Where id = '{OrderItemId}'</query>
<parameters>
<OrderItemId>Id</OrderItemId>
</parameters>
<Mapping>
<line1>AVA_SFCLOUD__Shipping_Street_Line__c</line1>
<city>AVA_SFCLOUD__Shipping_City_Line__c</city>
<region>AVA_SFCLOUD__Shipping_State_Line__c</region>
<country>AVA_SFCLOUD__Shipping_Country_Line__c</country>
<postalcode>AVA_SFCLOUD__Shipping_Postal_Code_Line__c</postalcode>
</Mapping>
<UpdateMapping>
<line1>AVA_SFCLOUD__Shipping_Street_Line__c</line1>
<city>AVA_SFCLOUD__Shipping_City_Line__c</city>
<region>AVA_SFCLOUD__Shipping_State_Line__c</region>
<country>AVA_SFCLOUD__Shipping_Country_Line__c</country>
<postalcode>AVA_SFCLOUD__Shipping_Postal_Code_Line__c</postalcode>
</UpdateMapping>
</Shipping>
</OrderItem>
<Contact>
<hooks>
<avaconfig>AVA_SFCLOUD.ConfigProviderForAddressValidation</avaconfig>
</hooks>
<Mailing>
<query>select MailingStreet, MailingCity,MailingState,MailingCountry,MailingPostalCode from Contact where id = '{ContactId}'</query>
<parameters>
<ContactId>Id</ContactId>
</parameters>
<Mapping>
<line1>MailingStreet</line1>
<city>MailingCity</city>
<region>MailingState</region>
<country>MailingCountry</country>
<postalcode>MailingPostalCode</postalcode>
</Mapping>
<UpdateMapping>
<line1>MailingStreet</line1>
<city>MailingCity</city>
<region>MailingState</region>
<postalcode>MailingPostalCode</postalcode>
<country>MailingCountry</country>
</UpdateMapping>
</Mailing>
</Contact>
<AVA_SFCLOUD__AvaTaxCompany__c>
<hooks>
<avaconfig>AVA_SFCLOUD.ConfigProviderForAddressValidation</avaconfig>
</hooks>
<Company>
<query>select AVA_SFCLOUD__AddressLine1__c, AVA_SFCLOUD__City__c, AVA_SFCLOUD__State__c, AVA_SFCLOUD__Country__c, AVA_SFCLOUD__PostalCode__c from AVA_SFCLOUD__AvaTaxCompany__c where id = '{CompanyId}'</query>
<parameters>
<CompanyId>Id</CompanyId>
</parameters>
<Mapping>
<line1>AVA_SFCLOUD__AddressLine1__c</line1>
<city>AVA_SFCLOUD__City__c</city>
<region>AVA_SFCLOUD__State__c</region>
<country>AVA_SFCLOUD__Country__c</country>
<postalcode>AVA_SFCLOUD__PostalCode__c</postalcode>
</Mapping>
<UpdateMapping>
<line1>AVA_SFCLOUD__AddressLine1__c</line1>
<city>AVA_SFCLOUD__City__c</city>
<region>AVA_SFCLOUD__State__c</region>
<postalcode>AVA_SFCLOUD__PostalCode__c</postalcode>
<country>AVA_SFCLOUD__Country__c</country>
</UpdateMapping>
</Company>
</AVA_SFCLOUD__AvaTaxCompany__c>
<GFERP__Sales_Order__c>
<hooks>
<avaconfig>AVA_SFCLOUD.ConfigProviderForAddressValidation</avaconfig>
</hooks>
</GFERP__Sales_Order__c>
<GFERP__Sales_Invoice__c>
<hooks>
<avaconfig>AVA_SFCLOUD.ConfigProviderForAddressValidation</avaconfig>
</hooks>
</GFERP__Sales_Invoice__c>
</addressvalidation>
<taxcalculation>
<Opportunity>
<hooks>
<overriderequestline></overriderequestline>
<beforetaxcalculation></beforetaxcalculation>
<beforeupdate></beforeupdate>
<afterupdate></afterupdate>
</hooks>
<Header>
<Queries>
<Opportunity>
<query>select Id, AccountId, Description, Account.AVA_SFCLOUD__AvaTax_Exemption_Customer_ID__c, Account.AVA_MAPPER__Business_Identification_Number__c, AVA_SFCLOUD__Is_Seller_Importer_Of_Record__c, AVA_SFCLOUD__Entity_Use_Code__r.Name, Account.Id, Account.AccountNumber, Account.Name, Account.ShippingStreet, Account.ShippingCity, Account.ShippingState, Account.ShippingPostalCode, Account.ShippingCountry, Account.BillingStreet, Account.BillingCity, Account.BillingState, AVA_SFCLOUD__AvaTax_Doc_Status__c, Account.BillingPostalCode, Account.BillingCountry, AVA_SFCLOUD__Tax_Date__c, CreatedDate, Account.AVA_MAPPER__Exemption_Number__c, AVA_SFCLOUD__Sales_Tax__c, AVA_SFCLOUD__AvaTax_Message__c, AVA_SFCLOUD__Origin_Street__c, AVA_SFCLOUD__Origin_City__c, AVA_SFCLOUD__Origin_State__c, AVA_SFCLOUD__Origin_Country__c, AVA_SFCLOUD__Origin_Postal_Code__c,AVA_SFCLOUD__Transport__c, AVA_SFCLOUD__Import_Fees__c,AVA_SFCLOUD__Shipping_Method__c,AVA_SFCLOUD__Cross_Border_Summary_Message__c, AVA_SFCLOUD__Invoice_Message__c, AVA_SFCLOUD__ShippingHandling__c, AVA_SFCLOUD__ShippingHandling_Tax__c {subsidiary} {CurrencyIsoCode} From Opportunity Where id = '{OpportunityId}'</query>
<parameters>
<subsidiary>optionalParams.subsidiary</subsidiary>
<CurrencyIsoCode>optionalParams.currencyIsoCode</CurrencyIsoCode>
<OpportunityId>Id</OpportunityId>
</parameters>
<Mapping>
<code>Id</code>
<customerCode>Account.AccountNumber</customerCode>
<businessIdentificationNo> Account.AVA_MAPPER__Business_Identification_Number__c</businessIdentificationNo>
<isSellerImporterOfRecord>AVA_SFCLOUD__Is_Seller_Importer_Of_Record__c</isSellerImporterOfRecord>
<customerUsageType>AVA_SFCLOUD__Entity_Use_Code__r.Name</customerUsageType>
<exemptionNo>Account.AVA_MAPPER__Exemption_Number__c</exemptionNo>
<description>Description</description>
<documentDate>CreatedDate</documentDate>
<addresses.shipTo.line1>Account.ShippingStreet</addresses.shipTo.line1>
<addresses.shipTo.line2></addresses.shipTo.line2>
<addresses.shipTo.line3></addresses.shipTo.line3>
<addresses.shipTo.city>Account.ShippingCity</addresses.shipTo.city>
<addresses.shipTo.region>Account.ShippingState</addresses.shipTo.region>
<addresses.shipTo.country>Account.ShippingCountry</addresses.shipTo.country>
<addresses.shipTo.postalCode>Account.ShippingPostalCode</addresses.shipTo.postalCode>
<addresses.shipTo.latitude></addresses.shipTo.latitude>
<addresses.shipTo.longitude></addresses.shipTo.longitude>
<addresses.shipFrom.line1>AVA_SFCLOUD__Origin_Street__c</addresses.shipFrom.line1>
<addresses.shipFrom.city>AVA_SFCLOUD__Origin_City__c</addresses.shipFrom.city>
<addresses.shipFrom.region>AVA_SFCLOUD__Origin_State__c</addresses.shipFrom.region>
<addresses.shipFrom.country>AVA_SFCLOUD__Origin_Country__c</addresses.shipFrom.country>
<addresses.shipFrom.postalCode>AVA_SFCLOUD__Origin_Postal_Code__c</addresses.shipFrom.postalCode>
</Mapping>
<UpdateMapping>
<AVA_SFCLOUD__Sales_Tax__c>totalTax</AVA_SFCLOUD__Sales_Tax__c>
<AVA_SFCLOUD__AvaTax_Doc_Status__c>AVA_SFCLOUD.GetAvaTaxDocStatus</AVA_SFCLOUD__AvaTax_Doc_Status__c>
<AVA_SFCLOUD__AvaTax_Message__c>AVA_SFCLOUD.GetAvaTaxMessage</AVA_SFCLOUD__AvaTax_Message__c>
<AVA_SFCLOUD__ShippingHandling_Tax__c>AVA_SFCLOUD.GetShippingTax</AVA_SFCLOUD__ShippingHandling_Tax__c>
<AVA_SFCLOUD__Invoice_Message__c>AVA_SFCLOUD.GetInvoiceMessage</AVA_SFCLOUD__Invoice_Message__c>
<AVA_SFCLOUD__Import_Fees__c>AVA_SFCLOUD.GetCustomDutyTax</AVA_SFCLOUD__Import_Fees__c>
<AVA_SFCLOUD__Cross_Border_Summary_Message__c> AVA_SFCLOUD.GetCrossBorderSummaryMessage</AVA_SFCLOUD__Cross_Border_Summary_Message__c>
</UpdateMapping>
</Opportunity>
</Queries>
</Header>
<Line>
<Queries>
<OpportunityLineItem>
<query>select Id, Pricebookentry.Product2.Name, Pricebookentry.ProductCode, Pricebookentry.product2.Description, Quantity, TotalPrice, UnitPrice, AVA_SFCLOUD__SalesTax_Line__c, AVA_SFCLOUD__Sales_Tax_Rate__c, AVA_SFCLOUD__Sales_Tax_Details__c, AVA_SFCLOUD__Entity_Use_Code_Line__r.Name,Product2.AVA_SFCLOUD__Tax_Included__c, Pricebookentry.Product2.AVA_SFCLOUD__AvaTax_Tax_Code__r.Name, Pricebookentry.Product2.AVA_SFCLOUD__UPC__c, AVA_SFCLOUD__Tax_Override__c, AVA_SFCLOUD__Shipping_Street_Line__c, AVA_SFCLOUD__Shipping_City_Line__c, AVA_SFCLOUD__Shipping_Country_Line__c, AVA_SFCLOUD__Shipping_State_Line__c, AVA_SFCLOUD__Shipping_Postal_Code_Line__c, AVA_SFCLOUD__Vat_Code__c, Opportunity.Account.BillingStreet, Opportunity.Account.BillingCity, Opportunity.Account.BillingCountry, Opportunity.Account.BillingState,Opportunity.Account.BillingPostalCode, Opportunity.Account.ShippingStreet, Opportunity.Account.ShippingCity, Opportunity.Account.ShippingCountry, Product2.AVA_SFCLOUD__HsCode__c,Product2.AVA_SFCLOUD__Product_Category__c,Opportunity.AVA_SFCLOUD__Shipping_Method__c,AVA_SFCLOUD__Shipping_Method__c, Opportunity.Account.ShippingState,Opportunity.Account.ShippingPostalCode FROM OpportunityLineItem where OpportunityId = '{OpportunityId}'</query>
<parameters>
<OpportunityId>Opportunity.Id</OpportunityId>
</parameters>
<Mapping>
<quantity>Quantity</quantity>
<itemCode>Pricebookentry.ProductCode</itemCode>
<taxCode>Pricebookentry.Product2.AVA_SFCLOUD__AvaTax_Tax_Code__r.Name</taxCode>
<amount>TotalPrice</amount>
<description>Pricebookentry.product2.Description</description>
<addresses.shipTo.line1>Opportunity.Account.ShippingStreet</addresses.shipTo.line1>
<addresses.shipTo.city>Opportunity.Account.ShippingCity</addresses.shipTo.city>
<addresses.shipTo.country>Opportunity.Account.ShippingCountry</addresses.shipTo.country>
<addresses.shipTo.region>Opportunity.Account.ShippingState</addresses.shipTo.region>
<addresses.shipTo.postalCode>Opportunity.Account.ShippingPostalCode</addresses.shipTo.postalCode>
<customerUsageType>AVA_SFCLOUD__Entity_Use_Code_Line__r.Name</customerUsageType>
<taxIncluded>Product2.AVA_SFCLOUD__Tax_Included__c</taxIncluded>
</Mapping>
<UpdateMapping>
<AVA_SFCLOUD__Vat_Code__c>vatCode</AVA_SFCLOUD__Vat_Code__c>
<AVA_SFCLOUD__SalesTax_Line__c>tax</AVA_SFCLOUD__SalesTax_Line__c>
<AVA_SFCLOUD__Sales_Tax_Rate__c>AVA_SFCLOUD.GetLineTaxRate</AVA_SFCLOUD__Sales_Tax_Rate__c>
<AVA_SFCLOUD__Sales_Tax_Details__c>AVA_SFCLOUD.GetLineTaxDetails</AVA_SFCLOUD__Sales_Tax_Details__c>
</UpdateMapping>
</OpportunityLineItem>
</Queries>
</Line>
</Opportunity>
<Quote>
<hooks>
<overriderequestline></overriderequestline>
<beforetaxcalculation></beforetaxcalculation>
<beforeupdate></beforeupdate>
<afterupdate></afterupdate>
</hooks>
<Header>
<Queries>
<Quote>
<query>select Id, AccountId, Description, Account.AVA_SFCLOUD__AvaTax_Exemption_Customer_ID__c, Account.AVA_MAPPER__Business_Identification_Number__c, AVA_SFCLOUD__Is_Seller_Importer_Of_Record__c, AVA_SFCLOUD__Entity_Use_Code__r.Name, Account.Id, Account.AccountNumber, Account.Name, Account.BillingStreet, Account.BillingCity, Account.BillingState, Account.BillingPostalCode, Account.BillingCountry, ShippingStreet, ShippingCity, ShippingState, ShippingPostalCode, ShippingCountry, BillingStreet, BillingCity, BillingState, BillingPostalCode, BillingCountry, ShippingHandling, AVA_SFCLOUD__ShippingHandling_Tax__c, AVA_SFCLOUD__AvaTax_Doc_Status__c, AVA_SFCLOUD__Tax_Date__c, CreatedDate, Tax, AVA_SFCLOUD__Transport__c, AVA_SFCLOUD__Origin_Street__c, AVA_SFCLOUD__Origin_City__c, AVA_SFCLOUD__Origin_State__c, AVA_SFCLOUD__Origin_Country__c, AVA_SFCLOUD__Origin_Postal_Code__c, AVA_SFCLOUD__Import_Fees__c,AVA_SFCLOUD__Shipping_Method__c,AVA_SFCLOUD__Cross_Border_Summary_Message__c, AVA_SFCLOUD__AvaTax_Message__c, AVA_SFCLOUD__Invoice_Message__c, Account.AVA_MAPPER__Exemption_Number__c {subsidiary} {CurrencyIsoCode} From Quote where id = '{QuoteId}'</query>
<parameters>
<subsidiary>optionalParams.subsidiary</subsidiary>
<CurrencyIsoCode>optionalParams.currencyIsoCode</CurrencyIsoCode>
<QuoteId>Id</QuoteId>
</parameters>
<Mapping>
<code>Id</code>
<customerCode>Account.AccountNumber</customerCode>
<businessIdentificationNo> Account.AVA_MAPPER__Business_Identification_Number__c</businessIdentificationNo>
<isSellerImporterOfRecord>AVA_SFCLOUD__Is_Seller_Importer_Of_Record__c</isSellerImporterOfRecord>
<customerUsageType>AVA_SFCLOUD__Entity_Use_Code__r.Name</customerUsageType>
<exemptionNo>Account.AVA_MAPPER__Exemption_Number__c</exemptionNo>
<description>Description</description>
<documentDate>CreatedDate</documentDate>
<addresses.shipTo.line1>ShippingStreet</addresses.shipTo.line1>
<addresses.shipTo.line2></addresses.shipTo.line2>
<addresses.shipTo.line3></addresses.shipTo.line3>
<addresses.shipTo.city>ShippingCity</addresses.shipTo.city>
<addresses.shipTo.region>ShippingState</addresses.shipTo.region>
<addresses.shipTo.country>ShippingCountry</addresses.shipTo.country>
<addresses.shipTo.postalCode>ShippingPostalCode</addresses.shipTo.postalCode>
<addresses.shipTo.latitude></addresses.shipTo.latitude>
<addresses.shipTo.longitude></addresses.shipTo.longitude>
<addresses.shipFrom.line1>AVA_SFCLOUD__Origin_Street__c</addresses.shipFrom.line1>
<addresses.shipFrom.city>AVA_SFCLOUD__Origin_City__c</addresses.shipFrom.city>
<addresses.shipFrom.region>AVA_SFCLOUD__Origin_State__c</addresses.shipFrom.region>
<addresses.shipFrom.country>AVA_SFCLOUD__Origin_Country__c</addresses.shipFrom.country>
<addresses.shipFrom.postalCode>AVA_SFCLOUD__Origin_Postal_Code__c</addresses.shipFrom.postalCode>
</Mapping>
<UpdateMapping>
<Tax>AVA_SFCLOUD.GetTaxAtHeader</Tax>
<AVA_SFCLOUD__AvaTax_Doc_Status__c>AVA_SFCLOUD.GetAvaTaxDocStatus</AVA_SFCLOUD__AvaTax_Doc_Status__c>
<AVA_SFCLOUD__ShippingHandling_Tax__c>AVA_SFCLOUD.GetShippingTax</AVA_SFCLOUD__ShippingHandling_Tax__c>
<AVA_SFCLOUD__AvaTax_Message__c>AVA_SFCLOUD.GetAvaTaxMessage</AVA_SFCLOUD__AvaTax_Message__c>
<AVA_SFCLOUD__Invoice_Message__c>AVA_SFCLOUD.GetInvoiceMessage</AVA_SFCLOUD__Invoice_Message__c>
<AVA_SFCLOUD__Import_Fees__c>AVA_SFCLOUD.GetCustomDutyTax</AVA_SFCLOUD__Import_Fees__c>
<AVA_SFCLOUD__Cross_Border_Summary_Message__c> AVA_SFCLOUD.GetCrossBorderSummaryMessage</AVA_SFCLOUD__Cross_Border_Summary_Message__c>
</UpdateMapping>
</Quote>
</Queries>
</Header>
<Line>
<Queries>
<QuoteLineItem>
<query>select Id, Pricebookentry.Product2.Name, Pricebookentry.ProductCode, Pricebookentry.product2.Description, AVA_SFCLOUD__Entity_Use_Code_Line__r.Name, Quantity, TotalPrice, UnitPrice, AVA_SFCLOUD__SalesTax_Line__c, AVA_SFCLOUD__Sales_Tax_Rate__c, AVA_SFCLOUD__Sales_Tax_Details__c, AVA_SFCLOUD__Vat_Code__c,AVA_SFCLOUD__Inclusive_Tax_Amount__c, Pricebookentry.Product2.AVA_SFCLOUD__AvaTax_Tax_Code__r.Name, Pricebookentry.Product2.AVA_SFCLOUD__UPC__c, AVA_SFCLOUD__Tax_Override__c, AVA_SFCLOUD__Shipping_Street_Line__c, Product2.AVA_SFCLOUD__HsCode__c,Product2.AVA_SFCLOUD__Product_Category__c,Quote.AVA_SFCLOUD__Shipping_Method__c,AVA_SFCLOUD__Shipping_Method__c, AVA_SFCLOUD__Shipping_City_Line__c, AVA_SFCLOUD__Shipping_Country_Line__c, AVA_SFCLOUD__Shipping_State_Line__c, AVA_SFCLOUD__Shipping_Postal_Code_Line__c, Product2.AVA_SFCLOUD__Tax_Included__c FROM QuoteLineItem where QuoteId = '{QuoteId}'</query>
<parameters>
<QuoteId>Quote.Id</QuoteId>
</parameters>
<Mapping>
<quantity>Quantity</quantity>
<itemCode>Pricebookentry.ProductCode</itemCode>
<taxCode>Pricebookentry.product2.AVA_SFCLOUD__AvaTax_Tax_Code__r.Name</taxCode>
<amount>TotalPrice</amount>
<description>Pricebookentry.product2.Description</description>
<addresses.shipTo.line1>AVA_SFCLOUD__Shipping_Street_Line__c</addresses.shipTo.line1>
<addresses.shipTo.city>AVA_SFCLOUD__Shipping_City_Line__c</addresses.shipTo.city>
<addresses.shipTo.country>AVA_SFCLOUD__Shipping_Country_Line__c</addresses.shipTo.country>
<addresses.shipTo.region>AVA_SFCLOUD__Shipping_State_Line__c</addresses.shipTo.region>
<addresses.shipTo.postalCode>AVA_SFCLOUD__Shipping_Postal_Code_Line__c</addresses.shipTo.postalCode>
<customerUsageType>AVA_SFCLOUD__Entity_Use_Code_Line__r.Name</customerUsageType>
<taxIncluded>Product2.AVA_SFCLOUD__Tax_Included__c</taxIncluded>
</Mapping>
<UpdateMapping>
<AVA_SFCLOUD__SalesTax_Line__c>AVA_SFCLOUD.GetTaxAmount</AVA_SFCLOUD__SalesTax_Line__c>
<AVA_SFCLOUD__Inclusive_Tax_Amount__c>AVA_SFCLOUD.GetInclusiveTaxAmount</AVA_SFCLOUD__Inclusive_Tax_Amount__c>
<AVA_SFCLOUD__Sales_Tax_Rate__c>AVA_SFCLOUD.GetLineTaxRate</AVA_SFCLOUD__Sales_Tax_Rate__c>
<AVA_SFCLOUD__Sales_Tax_Details__c>AVA_SFCLOUD.GetLineTaxDetails</AVA_SFCLOUD__Sales_Tax_Details__c>
<AVA_SFCLOUD__Vat_Code__c>vatCode</AVA_SFCLOUD__Vat_Code__c>
</UpdateMapping>
</QuoteLineItem>
</Queries>
</Line>
</Quote>
<Order>
<hooks>
<overriderequestline></overriderequestline>
<beforetaxcalculation></beforetaxcalculation>
<beforeupdate></beforeupdate>
<afterupdate></afterupdate>
</hooks>
<Header>
<Queries>
<Order>
<query>select Id, AccountId, Description, Account.AVA_MAPPER__Business_Identification_Number__c, Account.AVA_SFCLOUD__AvaTax_Exemption_Customer_ID__c, AVA_SFCLOUD__Is_Seller_Importer_Of_Record__c, AVA_SFCLOUD__Entity_Use_Code__r.Name, Account.Id, Account.AccountNumber, Account.Name, AVA_SFCLOUD__ShippingHandling__c, Account.BillingStreet, Account.BillingCity, Account.BillingState, Account.BillingPostalCode, Account.BillingCountry, AVA_SFCLOUD__ShippingHandling_Tax__c, ShippingStreet, ShippingCity, ShippingState, ShippingPostalCode, ShippingCountry, BillingStreet, BillingCity, BillingState, BillingPostalCode, BillingCountry, AVA_SFCLOUD__AvaTax_Doc_Status__c, AVA_SFCLOUD__Tax_Date__c, AVA_SFCLOUD__Commit_Tax__c, CreatedDate, AVA_SFCLOUD__Sales_Tax__c, AVA_SFCLOUD__Transport__c, AVA_SFCLOUD__Origin_Street__c, AVA_SFCLOUD__Origin_City__c, AVA_SFCLOUD__Origin_State__c, AVA_SFCLOUD__Origin_Country__c, AVA_SFCLOUD__Origin_Postal_Code__c, AVA_SFCLOUD__Import_Fees__c,AVA_SFCLOUD__Shipping_Method__c,AVA_SFCLOUD__Cross_Border_Summary_Message__c, AVA_SFCLOUD__AvaTax_Message__c, AVA_SFCLOUD__Invoice_Message__c, Account.AVA_MAPPER__Exemption_Number__c {subsidiary} {CurrencyIsoCode} From Order Where id = '{OrderId}'</query>
<parameters>
<subsidiary>optionalParams.subsidiary</subsidiary>
<CurrencyIsoCode>optionalParams.currencyIsoCode</CurrencyIsoCode>
<OrderId>Id</OrderId>
</parameters>
<Mapping>
<code>Id</code>
<customerCode>Account.AccountNumber</customerCode>
<businessIdentificationNo> Account.AVA_MAPPER__Business_Identification_Number__c</businessIdentificationNo>
<isSellerImporterOfRecord>AVA_SFCLOUD__Is_Seller_Importer_Of_Record__c</isSellerImporterOfRecord>
<customerUsageType>AVA_SFCLOUD__Entity_Use_Code__r.Name</customerUsageType>
<exemptionNo>Account.AVA_MAPPER__Exemption_Number__c</exemptionNo>
<description>Description</description>
<documentDate>CreatedDate</documentDate>
<addresses.shipTo.line1>ShippingStreet</addresses.shipTo.line1>
<addresses.shipTo.line2></addresses.shipTo.line2>
<addresses.shipTo.line3></addresses.shipTo.line3>
<addresses.shipTo.city>ShippingCity</addresses.shipTo.city>
<addresses.shipTo.region>ShippingState</addresses.shipTo.region>
<addresses.shipTo.country>ShippingCountry</addresses.shipTo.country>
<addresses.shipTo.postalCode>ShippingPostalCode</addresses.shipTo.postalCode>
<addresses.shipTo.latitude></addresses.shipTo.latitude>
<addresses.shipTo.longitude></addresses.shipTo.longitude>
<addresses.shipFrom.line1>AVA_SFCLOUD__Origin_Street__c</addresses.shipFrom.line1>
<addresses.shipFrom.city>AVA_SFCLOUD__Origin_City__c</addresses.shipFrom.city>
<addresses.shipFrom.region>AVA_SFCLOUD__Origin_State__c</addresses.shipFrom.region>
<addresses.shipFrom.country>AVA_SFCLOUD__Origin_Country__c</addresses.shipFrom.country>
<addresses.shipFrom.postalCode>AVA_SFCLOUD__Origin_Postal_Code__c</addresses.shipFrom.postalCode>
</Mapping>
<UpdateMapping>
<AVA_SFCLOUD__Sales_Tax__c>totalTax</AVA_SFCLOUD__Sales_Tax__c>
<AVA_SFCLOUD__AvaTax_Doc_Status__c>AVA_SFCLOUD.GetAvaTaxDocStatus</AVA_SFCLOUD__AvaTax_Doc_Status__c>
<AVA_SFCLOUD__AvaTax_Message__c>AVA_SFCLOUD.GetAvaTaxMessage</AVA_SFCLOUD__AvaTax_Message__c>
<AVA_SFCLOUD__ShippingHandling_Tax__c>AVA_SFCLOUD.GetShippingTax</AVA_SFCLOUD__ShippingHandling_Tax__c>
<AVA_SFCLOUD__Invoice_Message__c>AVA_SFCLOUD.GetInvoiceMessage</AVA_SFCLOUD__Invoice_Message__c>
<AVA_SFCLOUD__Import_Fees__c>AVA_SFCLOUD.GetCustomDutyTax</AVA_SFCLOUD__Import_Fees__c>
<AVA_SFCLOUD__Cross_Border_Summary_Message__c> AVA_SFCLOUD.GetCrossBorderSummaryMessage</AVA_SFCLOUD__Cross_Border_Summary_Message__c>
</UpdateMapping>
</Order>
</Queries>
</Header>
<Line>
<Queries>
<OrderItem>
<query>select Id, Pricebookentry.Product2.Name, Pricebookentry.ProductCode, Pricebookentry.product2.Description, AVA_SFCLOUD__Entity_Use_Code_Line__r.Name, Quantity, TotalPrice, UnitPrice, AVA_SFCLOUD__Sales_Tax_Amount_Line__c, AVA_SFCLOUD__Sales_Tax_Rate__c, AVA_SFCLOUD__Sales_Tax_Details__c, AVA_SFCLOUD__Vat_Code__c, Pricebookentry.Product2.AVA_SFCLOUD__AvaTax_Tax_Code__r.Name, Pricebookentry.Product2.AVA_SFCLOUD__UPC__c, AVA_SFCLOUD__Tax_Override__c, AVA_SFCLOUD__Shipping_Street_Line__c, Product2.AVA_SFCLOUD__HsCode__c,Product2.AVA_SFCLOUD__Product_Category__c,Order.AVA_SFCLOUD__Shipping_Method__c,AVA_SFCLOUD__Shipping_Method__c, AVA_SFCLOUD__Shipping_City_Line__c, AVA_SFCLOUD__Shipping_Country_Line__c, AVA_SFCLOUD__Shipping_State_Line__c, AVA_SFCLOUD__Shipping_Postal_Code_Line__c, Product2.AVA_SFCLOUD__Tax_Included__c FROM OrderItem where OrderId = '{OrderId}'</query>
<parameters>
<OrderId>Order.Id</OrderId>
</parameters>
<Mapping>
<quantity>Quantity</quantity>
<itemCode>Pricebookentry.ProductCode</itemCode>
<taxCode>Pricebookentry.product2.AVA_SFCLOUD__AvaTax_Tax_Code__r.Name</taxCode>
<amount>TotalPrice</amount>
<description>Pricebookentry.product2.Description</description>
<addresses.shipTo.line1>AVA_SFCLOUD__Shipping_Street_Line__c</addresses.shipTo.line1>
<addresses.shipTo.city>AVA_SFCLOUD__Shipping_City_Line__c</addresses.shipTo.city>
<addresses.shipTo.country>AVA_SFCLOUD__Shipping_Country_Line__c</addresses.shipTo.country>
<addresses.shipTo.region>AVA_SFCLOUD__Shipping_State_Line__c</addresses.shipTo.region>
<addresses.shipTo.postalCode>AVA_SFCLOUD__Shipping_Postal_Code_Line__c</addresses.shipTo.postalCode>
<customerUsageType>AVA_SFCLOUD__Entity_Use_Code_Line__r.Name</customerUsageType>
<taxIncluded>Product2.AVA_SFCLOUD__Tax_Included__c</taxIncluded>
</Mapping>
<UpdateMapping>
<AVA_SFCLOUD__Sales_Tax_Amount_Line__c>tax</AVA_SFCLOUD__Sales_Tax_Amount_Line__c>
<AVA_SFCLOUD__Sales_Tax_Rate__c>AVA_SFCLOUD.GetLineTaxRate</AVA_SFCLOUD__Sales_Tax_Rate__c>
<AVA_SFCLOUD__Sales_Tax_Details__c>AVA_SFCLOUD.GetLineTaxDetails</AVA_SFCLOUD__Sales_Tax_Details__c>
<AVA_SFCLOUD__Vat_Code__c>vatCode</AVA_SFCLOUD__Vat_Code__c>
</UpdateMapping>
</OrderItem>
</Queries>
</Line>
</Order>
<GFERP__Sales_Order__c>
<hooks>
<overriderequestline></overriderequestline>
<beforetaxcalculation></beforetaxcalculation>
<beforeupdate></beforeupdate>
<afterupdate></afterupdate>
</hooks>
<Header>
<Queries>
<GFERP__Sales_Order__c>
<query>select Id,Name,GFERP__Order_Date__c,GFERP__Sell_to_Customer__r.AccountNumber,GFERP__Sell_to_Customer__r.AVA_MAPPER__Is_Seller_Importer_Of_Record__c,GFERP__Sell_to_Customer__r.AVA_MAPPER__Business_Identification_Number__c,GFAVA__Sales_Tax__c,GFAVA__Invoice_Message__c,GFAVA__AvaTax_Doc_Status__c,GFAVA__AvaTax_Message__c,GFERP__Shipping_City__c,GFERP__Shipping_Country__c,GFERP__Shipping_State__c,GFERP__Shipping_Street__c,GFERP__Shipping_Postal_Code__c,GFAVA__Entity_Use_Code__r.Name,GFERP__Sell_to_Customer__r.AVA_MAPPER__Exemption_Number__c,GFERP__Sell_to_Customer__r.AVA_MAPPER__Entity_Use_code__r.Name from GFERP__Sales_Order__c where Id = '{GFERP__Sales_Order__cId}'</query>
<parameters>
<GFERP__Sales_Order__cId>Id</GFERP__Sales_Order__cId>
</parameters>
<Mapping>
<code>Name</code>
<date>GFERP__Order_Date__c</date>
<customerCode>GFERP__Sell_to_Customer__r.AccountNumber</customerCode>
<addresses.shipTo.city>GFERP__Shipping_City__c</addresses.shipTo.city>
<addresses.shipTo.country>GFERP__Shipping_Country__c</addresses.shipTo.country>
<addresses.shipTo.region>GFERP__Shipping_State__c</addresses.shipTo.region>
<addresses.shipTo.line1>GFERP__Shipping_Street__c</addresses.shipTo.line1>
<addresses.shipTo.postalCode>GFERP__Shipping_Postal_Code__c</addresses.shipTo.postalCode>
<entityUseCode>GFERP__Sell_to_Customer__r.AVA_MAPPER__Entity_Use_code__r.Name</entityUseCode>
<isSellerImporterOfRecord>GFERP__Sell_to_Customer__r.AVA_MAPPER__Is_Seller_Importer_Of_Record__c</isSellerImporterOfRecord>
<businessIdentificationNo>GFERP__Sell_to_Customer__r.AVA_MAPPER__Business_Identification_Number__c</businessIdentificationNo>
</Mapping>
<UpdateMapping>
<GFAVA__Sales_Tax__c>totalTax</GFAVA__Sales_Tax__c>
</UpdateMapping>
</GFERP__Sales_Order__c>
</Queries>
</Header>
<Line>
<Queries>
<GFERP__Sales_Line__c>
<query>select Id,GFERP__Item__r.Name,GFERP__Item__r.GFERP__Description__c,GFERP__Line_Amount__c,GFERP__Quantity__c,GFAVA__Sales_Tax_Amount__c,GFERP__Item__r.GFAVA__AvaTax_Tax_Code__r.Name from GFERP__Sales_Line__c where GFERP__Sales_Order__c = '{GFERP__Sales_Order__cId}'</query>
<parameters>
<GFERP__Sales_Order__cId>GFERP__Sales_Order__c.Id</GFERP__Sales_Order__cId>
</parameters>
<Mapping>
<quantity>GFERP__Quantity__c</quantity>
<amount>GFERP__Line_Amount__c</amount>
<description>GFERP__Item__r.GFERP__Description__c</description>
<itemCode>GFERP__Item__r.Name</itemCode>
<taxCode>GFERP__Item__r.GFAVA__AvaTax_Tax_Code__r.Name</taxCode>
</Mapping>
<UpdateMapping>
<GFAVA__Sales_Tax_Amount__c>tax</GFAVA__Sales_Tax_Amount__c>
</UpdateMapping>
</GFERP__Sales_Line__c>
</Queries>
</Line>
</GFERP__Sales_Order__c>
<GFERP__Sales_Invoice__c>
<hooks>
<overriderequestline></overriderequestline>
<beforetaxcalculation></beforetaxcalculation>
<beforeupdate></beforeupdate>
<afterupdate></afterupdate>
</hooks>
<Header>
<Queries>
<GFERP__Sales_Invoice__c>
<query>select Id, Name, CreatedDate, GFAVA__Invoice_Message__c,GFAVA__Entity_Use_Code__c,GFAVA__AvaTax_Doc_Status__c,GFERP__Billing_City__c, GFERP__Billing_Country__c,GFERP__Billing_Postal_Code__c, GFERP__Billing_State__c,GFERP__Billing_Street__c, GFERP__Sell_to_Customer__r.AccountNumber,GFERP__Currency__r.Name, GFERP__Shipping_City2__c,GFERP__Sell_to_Customer__r.AVA_MAPPER__Entity_Use_code__r.Name,GFERP__Shipping_Country2__c, GFERP__Shipping_Postal_Code2__c,GFERP__Shipping_State2__c, GFERP__Shipping_Street2__c,GFERP__Sell_to_Customer__r.Name, GFAVA__AvaTax_Message__c,GFAVA__Sales_Tax__c,GFERP__Sell_to_Customer__r.AVA_MAPPER__Is_Seller_Importer_Of_Record__c,GFERP__Sell_to_Customer__r.AVA_MAPPER__Business_Identification_Number__c from GFERP__Sales_Invoice__c where Id = '{GFERP__Sales_Invoice__cId}'</query>
<parameters>
<GFERP__Sales_Invoice__cId>Id</GFERP__Sales_Invoice__cId>
</parameters>
<Mapping>
<code>Name</code>
<exemptionNo>GFAVA__Invoice_Message__c</exemptionNo>
<customerUsageType>GFAVA__Entity_Use_Code__c</customerUsageType>
<isSellerImporterOfRecord>GFERP__Sell_to_Customer__r.AVA_MAPPER__Is_Seller_Importer_Of_Record__c</isSellerImporterOfRecord>
<customerCode>GFERP__Sell_to_Customer__r.Name</customerCode>
<addresses.shipTo.city>GFERP__Shipping_City2__c</addresses.shipTo.city>
<addresses.shipTo.country>GFERP__Shipping_Country2__c</addresses.shipTo.country>
<addresses.shipTo.postalCode>GFERP__Shipping_Postal_Code2__c</addresses.shipTo.postalCode>
<addresses.shipTo.region>GFERP__Shipping_State2__c</addresses.shipTo.region>
<addresses.shipTo.line1>GFERP__Shipping_Street2__c</addresses.shipTo.line1>
<date>CreatedDate</date>
<entityUseCode>GFERP__Sell_to_Customer__r.AVA_MAPPER__Entity_Use_code__r.Name</entityUseCode>
<currencyCode>GFERP__Currency__r.Name</currencyCode>
<businessIdentificationNo>GFERP__Sell_to_Customer__r.AVA_MAPPER__Business_Identification_Number__c</businessIdentificationNo>
</Mapping>
<UpdateMapping>
<GFAVA__Sales_Tax__c>totalTax</GFAVA__Sales_Tax__c>
</UpdateMapping>
</GFERP__Sales_Invoice__c>
</Queries>
</Header>
<Line>
<Queries>
<GFERP__Sales_Invoice_Line__c>
<query>select Id,GFERP__Line_Amount__c,GFERP__Item__r.Name,GFERP__Item__r.GFERP__Description__c,GFERP__Line_No__c,GFERP__Quantity__c,GFERP__Lot_Tracked__c,GFERP__Tax__c,GFERP__Item__r.GFAVA__AvaTax_Tax_Code__r.Name from GFERP__Sales_Invoice_Line__c where GFERP__Sales_Invoice__c = '{GFERP__Sales_Invoice_Line__cId}'</query>
<parameters>
<GFERP__Sales_Invoice_Line__cId>optionalParams.salesinvoiceid</GFERP__Sales_Invoice_Line__cId>
</parameters>
<Mapping>
<itemCode>GFERP__Item__r.Name</itemCode>
<description>GFERP__Item__r.GFERP__Description__c</description>
<amount>GFERP__Line_Amount__c</amount>
<number>GFERP__Line_No__c</number>
<quantity>GFERP__Quantity__c</quantity>
<taxCode>GFERP__Item__r.GFAVA__AvaTax_Tax_Code__r.Name</taxCode>
</Mapping>
<UpdateMapping>
<GFAVA__Sales_Tax_Amount__c>tax</GFAVA__Sales_Tax_Amount__c>
</UpdateMapping>
</GFERP__Sales_Invoice_Line__c>
</Queries>
</Line>
</GFERP__Sales_Invoice__c>
</taxcalculation>
<bulkaddressvalidation>
<Account>
<hooks>
<avaconfig>AVA_SFCLOUD.ConfigProviderForAddressValidation</avaconfig>
</hooks>
<Billing>
<query>select BillingStreet,BillingCity,BillingState,BillingCountry,Billingpostalcode from Account where id = '{AccountId}'</query>
<parameters>
<AccountId>Id</AccountId>
</parameters>
<Mapping>
<line1>BillingStreet</line1>
<city>BillingCity</city>
<region>BillingState</region>
<country>BillingCountry</country>
<postalcode>Billingpostalcode</postalcode>
</Mapping>
<UpdateMapping>
<line1>BillingStreet</line1>
<city>BillingCity</city>
<region>BillingState</region>
<country>BillingCountry</country>
<postalcode>Billingpostalcode</postalcode>
</UpdateMapping>
</Billing>
<Shipping>
<query>select ShippingStreet,ShippingCity,ShippingState,ShippingCountry,Shippingpostalcode from Account where id = '{AccountId}'</query>
<parameters>
<AccountId>Id</AccountId>
</parameters>
<Mapping>
<line1>ShippingStreet</line1>
<city>ShippingCity</city>
<region>ShippingState</region>
<country>ShippingCountry</country>
<postalcode>Shippingpostalcode</postalcode>
</Mapping>
<UpdateMapping>
<line1>ShippingStreet</line1>
<city>ShippingCity</city>
<region>ShippingState</region>
<country>ShippingCountry</country>
<postalcode>Shippingpostalcode</postalcode>
</UpdateMapping>
</Shipping>
</Account>
</bulkaddressvalidation>
<canceltaxcalculation>
<Order>
<Queries>
<Order>
<query>select Id From Order where id = '{OrderId}' and isDeleted = true all rows</query>
<parameters>
<OrderId>Id</OrderId>
</parameters>
<Mapping>
<transactionCode>Id</transactionCode>
</Mapping>
</Order>
</Queries>
</Order>
<GFERP__Sales_Invoice__c>
<hooks></hooks>
<Queries>
<GFERP__Sales_Invoice__c>
<query>select Id,Name from GFERP__Sales_Invoice__c where Id = '{GFERP__Sales_Invoice__cId}'</query>
<parameters>
<GFERP__Sales_Invoice__cId>Id</GFERP__Sales_Invoice__cId>
</parameters>
<Mapping>
<transactionCode>Name</transactionCode>
</Mapping>
<UpdateMapping></UpdateMapping>
</GFERP__Sales_Invoice__c>
</Queries>
</GFERP__Sales_Invoice__c>
</canceltaxcalculation>
<posttaxcalculation>
<Order>
<hooks></hooks>
<Queries>
<Order>
<query>select Id, AccountId, Description from Order where id = '{OrderId}'</query>
<parameters>
<OrderId>Id</OrderId>
</parameters>
<Mapping>
<transactionCode>Id</transactionCode>
</Mapping>
</Order>
</Queries>
</Order>
<GFERP__Sales_Invoice__c>
<hooks></hooks>
<Queries>
<GFERP__Sales_Invoice__c>
<query>select Id,Name,GFERP__Sell_to_Customer__c,GFERP__Description__c from GFERP__Sales_Invoice__c where Id = '{GFERP__Sales_Invoice__cId}'</query>
<parameters>
<GFERP__Sales_Invoice__cId>Id</GFERP__Sales_Invoice__cId>
</parameters>
<Mapping>
<transactionCode>Name</transactionCode>
</Mapping>
<UpdateMapping></UpdateMapping>
</GFERP__Sales_Invoice__c>
</Queries>
</GFERP__Sales_Invoice__c>
</posttaxcalculation>
</avatax>XML Tags
This tag represents tax calculation mapping for the objects defined.
<taxcalculation><Header> represents parent object mapping. <Mapping> tag contains the mapping for sending information from Salesforce to Avalara and <UpdateMapping> includes the mapping from Avalara to Salesforce.
This tag represents post-calculation mapping for the objects defined.
<posttaxcalculation><parameters> contains the record ID for fetching the record. <Mapping> contains record information. It will find the record based on <transactionCode>. We mapped this by name which means the record name in Salesforce and Avalara should be the same, otherwise we will get the error message ‘Document Not Found’.
This tag represents cancel-calculation mapping for the objects defined.
<canceltaxcalculation><parameters> contains the record ID for fetching the record. <Mapping> contains record information. It will find the record based on <transactionCode>. We mapped this by name which means the record name in Salesforce and Avalara should be the same, otherwise we will get the error message ‘Document Not Found’.
Minify the XML before you update it AVA_SFCloud_Field field
Copy your final XML and paste it to the below tool to minify. You can use any online tool.
We recommend using this tool: Minify XML - Online XML Tools
Paste your minified result into the AVA_SFCloud_Field field and Save.
, multiple selections available,
Related content
Use Avalara Integration
Use Avalara Integration
Read with this
Salesforce Order Mapping
Salesforce Order Mapping
More like this
Salesforce OrderItem Mapping
Salesforce OrderItem Mapping
More like this
Sales Invoice Mapping
Sales Invoice Mapping
More like this
Sales Invoice Line Mapping
Sales Invoice Line Mapping
More like this
Sales Order/Sales Quote Mapping
Sales Order/Sales Quote Mapping
More like this