Skip to main content
Avalara Help Center

Map your fields

After importing and classifying tables from your point of sale system, map Avalara's tax fields to your own. Transform tax values to match your system by linking multiple source fields to one destination field, or use the function editor to insert custom expressions or static values.

About the mapping table

The mapping table is where you link Avalara's tax fields to your own. It consists of two columns containing source and destination fields, and a mapping panel on the right side. 

Reference tables
Search a glossary of Avalara's tax fields and examples of common field names. Use this when you need help finding tax fields that match up with your own.

Source fields
Source fields are on the left. These fields come from Avalara's tax data and they are grouped by tax table. Expand a group to view the fields within it.

Destination fields
Destination fields are on the right. They match the fields in your system and they are organized by the classification tables that you selected in the previous step.

Mapping panel
The mapping panel on the right side is blank until you begin linking fields. Use this panel to preview and modify fields after they have been linked. 

Map one field to another

  1. Find a source field by expanding a tax table group on the left.
    • For example, expand the TTE_tax_jurisdiction group to find fields related to tax jurisdictions
  2. Select a source field and then select a destination field on the right to link them.
    • For example, select TaxJurisdictionID on the left and then select the corresponding destination field on the right
  3. Select Done to finish mapping these fields. Mapped fields are connected by a solid line.

View mapped fields

  1. Select a linked source field to view all mappings that it is associated with.
  2. Mappings are listed on the right. Select a mapping in the list to view it.
    • Select Add New Mapping to link the source field with another destination field
  3. After viewing a mapping, select Done to return the mapping table to a resting state.
    • Note: You must view a mapping and select Done before you can map more fields

Edit a mapping

  1. Select the ... beside a linked source field. Close the window that appears.
  2. Mappings are listed on the right. Select a mapping in the list to view it.
  3. Select the X to remove a mapped field.
  4. Select Done to return to the mapping table to a resting state.. 

Preview mapped fields

  1. Select a linked source field to view all mappings that it is associated with.
  2. Mappings are listed on the right. Select a mapping in the list to view it.
  3. In the Mapping panel, select Preview to view the result of linking these fields.
    • Source: The source field(s) from Avalara's tax file
    • Destination: The destination field from your system
    • Functions: Any functions that apply to these fields. When mapping multiple source fields to one destination field, values are concatenated by default
  4. Select Done to exit the preview. 

Map multiple source fields to one destination field

Multiple source fields can be linked to one destination field.

  1. Select the first source field and then select a destination field to link them together.
  2. In the Mapping panel, select Add a Source Field, and then select another source field on the left. The second source field is added to the mapping relationship.
    • Additional source fields are listed in the Mapping panel as you add them
  3. Select Preview to view the result of linking these fields. 
    • When mapping multiple source fields to one destination field, values are concatenated by default. Use the Function Editor to change that behavior
  4. Select Done to finish mapping these fields.

Apply functions to mapped fields

Use functions to combine or modify source field values. By default, multiple source fields are concatenated when they are mapped to a single destination field. 

  1. Select a linked source field to view all mappings that it is associated with.
  2. Mappings are listed on the right. Select a mapping in the list to view it.
  3. In the Mapping panel, select Function Editor to open it.
  4. Type in the Function field to enter an expression manually, or select an option under Formula Types and Source Tables to view Avalara fields and various logical functions. Choose a field or function and select Insert to add it to the Function field instead of typing it by hand.
  5. Select Preview to view the result of your function using placeholder field values.
    • If you can't preview, double-check your function for errors. Previewing is disabled if your function isn't valid
    • Select Back to return to the editor view
  6. Select Save Transformation to save your work and close the Function Editor.

Insert a static value to destination fields

Add a static value when you know that your destination field value will always be the same.

  1. Select a linked source field to view all mappings that it is associated with.
  2. Mappings are listed on the right. Select a mapping in the list to view it.
  3. In the Mapping panel, add your value to the Input Text field. This value will be added to the linked destination field.
  4. Select Done to save your work and exit the mapping view.

Manage multiple mappings

When you select a field that's been linked to multiple fields, individual mappings are listed separately in the Mapping panel.

  1. Select a linked source field to view all mappings that it is associated with.
  2. Mappings are listed on the right. Select a mapping in the list to view it.
  3. Select Add a Source Field to link another field. Select the X to remove a mapped field.
  4. Select Done to return to the All Mappings view.
  • Was this article helpful?