Overview
The Tax Rate Import process reads files from the ./Incoming/TaxRates/
in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/TaxRates/
before being processed in alpha-numeric order.
Keys
- Tax Rate Id
- Country Code
- Tax Rate Type
- Percentage
Validations
You can update any field if you specify Tax Rate Id. If there is no Tax Rate Id, then Coupa uses the combination of Country Code, Tax Rate Type and Percentage to look up an existing record.
Column Name
|
Description
|
Req'd
|
Unique
|
Type
|
Allowable Values
|
Country Code
|
The country code where the tax rate will be applied
|
No
|
No
|
string(4)
|
Any
|
Tax Rate Type
|
The type of Tax Rate (ex: VAT, GST)
|
No
|
No
|
string(4)
|
Any
|
Percentage
|
Tax Percentage Amount
|
Yes
|
Yes
|
decimal(30,6)
|
Any
|
Tax Rate ID
|
Coupa's unique ID for the tax rate
|
No
|
No
|
integer(11)
|
Any
|
Active
|
Determines if the tax rate is enabled or disabled
|
No
|
No
|
boolean
|
Yes/No, True/False
|
Exempt
|
Determines if the tax rate is exempt or not
|
No
|
Yes
|
boolean
|
Yes/No, True/False
|
Reverse Charge
|
Determines tax rate is reverse charge or not
|
No
|
Yes
|
boolean
|
Yes/No, True/False
|
Customer Accounting
|
Determines if the tax rate is customer accounting
|
No
|
No
|
boolean
|
Yes/No, True/False
|
Tax Rate Description
|
Tax Rate Description
|
No
|
No
|
string(255)
|
Any
|
Effective Date
|
The date when the tax rate will become active
|
No
|
No
|
datetime
|
Any
|
Expiration Date
|
The date when the tax rate will expire
|
No
|
No
|
datetime
|
Any
|
Out of Scope
|
Determines tax rate is out of scope or not
|
No
|
No
|
boolean
|
Any
|