Limited Use Exemption Certificates CSV Format

CertificateNumber

varchar2(100)

Y

Certificate number.

CustomerName

varchar2(100)

Y

Customer name. Must map to an existing customer.

CustomerNumber

varchar2(100)

Y

Customer number. Must map to an existing customer.

Status

varchar2(100)

Y

Certificate Status. Valid values are:

• A: Approved
• I: In Review
• T: Temporary
• U: Unapproved

ExemptReasonCode

varchar2(2)

Y

The exempt reason short code for the certificate. Must map to an existing exempt reason.

Always include the ExemptReasonCode header, even if you do not include a value.

ValidFromDate

mm/dd/yyyy

Y

The first date on which the certificate is valid.

ExpiresDate

mm/dd/yyyy

N

An optional expiration date.

Active

varchar2(1)

N

Indicates whether or not the certificate may be applied to transactions. Valid values are Y or N.

FullyExempt

varchar2(1)

N

Indicates whether or not the certificate results in full exemption from tax. Valid values are Y or N.

TaxDataType

varchar2(50)

Y

The Tax Data Type. Valid values are:

• US
• INTL

CertificateImagePath

varchar2(1000)

N

A fully-qualified filename for an image of the physical certificate.

ExemptAmount

NUMBER

N

The amount to exempt for a transaction to which this certificate applies.

If you specify an amount, the currency must match the currency used on a document.

CurrencyCode

varchar2(50)

Y *

A valid Currency Code such as USD.

See Currency Rules for a list of valid codes.

(*) Required if ExemptAmount is included.

BasisPercent

NUMBER

N

A Basis Percentage to apply to the transaction. A real number between 0 and 1. For example, .5 indicates a 50% basis percentage.

CustomerTaxId

varchar2(100)

N

Optional information about the customer, not used in calculations.

CustomerLicenseNumber

varchar2(50)

N

CustomerBusinessType

varchar2(100)

N

CustomerComments

varchar2(2000)

N

SellerName

varchar2(100)

N

Optional information about the seller, not used in calculation.

SellerNumber

varchar2(100)

N

SellerDbaName

varchar2(100)

N

SellerTaxId

varchar2(100)

N

SellerLicenseNumber

varchar2(100)

N

ProductCode

varchar2(100)

N

A string (full, or partial with wildcards) that matches the Input XML element <INVOICE>.<LINE>.<PRODUCT_CODE> passed in with a transaction. If a Product Code is specified, only transactions containing that product can potentially have the certificate applied.

XmlElement

varchar2(100)

Y

This is the XML Element on the Certificate Use tab. Can be one or more Custom Attribute elements used to match this certificate to invoice or line-level transaction data.

Use the Determination Attribute designation, not the Custom Attribute value. For example: If Attribute 1 is PlantID, the CSV file should use INVOICE.USER_ELEMENT.ATTRIBUTE1, not PlantID.

Value

varchar2(200)

Y

This corresponds to the Value Pattern column on the Certificate Use tab. The value of the attribute, for example an invoice number.

You can enter either:

• An exact string to match. Bracket the data you want to match with the ^ and $ regular expressions. For example, to match invoice 1001, enter ^1001$.
• A string that contains no regular expressions or wildcards. In this case, the string includes an implied % wildcard both at the beginning and end of the string. For example, entering the string 1234 would match 1234, 11234, 12345, and 1123456, but would not match 11223344.
• A pattern using the following wildcards in conjunction with the regular expressions shown above: % (percent) to match any number of characters, or _ (underline) to match any one character. For example, entering the string %1234_$ would match 12345, 12346, 112345, and 112346, but would not match 1123456.