Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

CSV import

File format for international product mappings

Using a simplified CSV file format, you can import mappings from your ERP's source codes to Determination international product codes using the product path. The international product code mapping import file applies only to existing products - those you created in Determination, or those you uploaded with Import/Export.
A product mapping maps your ERP (enterprise resource planning) codes to a non-US product code in the product tree by specifying the entire product path. The CSV file specifies the product path to map to a product code and whether it's a custom product.

Example product mappings - INTL file format

SDITYPE=PRODUCTMAPPINGS-INTL
Column name
Format
Required
Description
ProductCode
varchar2(100)
Yes
The source code passed in from your ERP system.
ProductCodeType
N/A
N/A
Leave blank. Reserved for future use.
ProductPath
varchar2
Yes
The product path in ONESOURCE Determination. It's related to a product in the product tree.


For example: Goods.apparel and Luggage and Personal Car Products.Clothing.Athletic Wear

StartDate
mm/dd/yyyy
Yes
The date (mm/dd/yyyy) on which the product mapping becomes active.
EndDate
mm/dd/yyyy
No
The date (mm/dd/yyyy) on which the product mapping terminates. If left blank, the mapping doesn't automatically end.
CustomProduct
varchar2(100)
Yes
Indicates whether the product mapping data applies to a Custom Product (Y) or a Tax Data Provider Product (N).
ProductCodeDesc
varchar2(100)
No
Provide product code description in this field.

Example product mappings - INTL file

For example, this file maps 3 product tree paths to 3 product codes with specific start dates, and indicates if it's a custom code.


sdiType=ProductMappings-INTL,,,,,,


ProductCode, ProductCodeType, ProductPath, StartDate, EndDate,


CustomProduct, ProductCodeDesc


ACME,,Goods,08/10/2020,,N,Sold in Brazil


TOOLS,, Goods, 09/01/2020,,N,


SPORTWEAR,, Goods.Apparel and Luggage and Personal Care


Products.Clothing.Athletic Wear, 11/03/2020,,Y,

This article applies to:

  • Product: ONESOURCE Determination, ONESOURCE Indirect Tax