Tax Registration Number Validation (Oracle Payables Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Tax Registration Number Validation

Payables provides for Italy, Spain, Netherlands, and Austria the following country-specific validation of the Taxpayer Registration Number, also known as the VAT number. If you have defined one of these countries as your "Home Country" in the Member State field of the Financials Options window, and your home country is the same as your Default Country profile option, then Payables validates the Taxpayer Identification Number you enter based on the rules of your home country. If the Member State value in the Financials Options window and Default Country profile option are different, Payables performs no validation.

Italy (IT)

Tax Registration Number is unique

All characters are numeric

Length = 11

Check Digit is correct

Spain (ES)

Tax Registration Number is unique

Prefixed with "ES"

Format of rest of number depending on the next character: If the next character is:

T then no further validation

A, B, C, D, E, F, G then rest must be numeric

X, P, Q, S, or a number then check Check Digit (last number)

Netherlands (NL)

Tax Registration Number is unique

Length = 14

First two characters are "NL"

Last two characters are in the range 01-99

12th character = B

Characters 3-10 are numeric

Characters 3-10 match check digit held in char 11

Austria (AT)

Tax Registration Number is unique

Length = 11

First three characters are "ATU"

Characters 4-10 match check digit held in character 11

Belgium (BE)

Tax Registration Number is unique

Length = 11

First two characters are "BE"

Characters 3-11 are numeric