[WebERP-developers] VAT identification number as Customer-code and Supplier-code. Experience?

[webERP D. <web...@li...>]

Hi,

This is a question about your experience. I explain myself:

Due a particular situation, I have to use the tax/vat identification number
as the client_code (debtorsmaster.debtorno) and the supplier_code
(suppliers.supplierid).

The biggest VAT identification number --as far I know-- is 17 characters (=
2 characters for the ISO 3166-1 Alpha-2 code + 15 characters for the local
VAT identification number). See:
http://en.wikipedia.org/wiki/VAT_identification_number.

* Anyone knows a tax/vat identification number greater than that indicated
in http://en.wikipedia.org/wiki/VAT_identification_number ?

* Who of you have used the VAT number as the customer or supplier number ?
Comments ?

Regards,

Rafael Chacón
---
Note: Columns involved in changing size from varchar(10) to varchar(17):
contracts.debtorno; custbranch.debtorno; custcontacts.debtorno;
custnotes.debtorno; debtorsmaster.debtorno; debtortrans.debtorno;
offers.supplierid; orderdeliverydifferenceslog.debtorno; prices.debtorno;
purchdata.supplierno; purchorders.supplierno;
recurringsalesorders.debtorno; salesorders.debtorno;
sellthroughsupport.debtorno; shipments.supplierid; stockmoves.debtorno;
suppliercontacts.supplierid; supplierdiscounts.supplierno;
suppliers.supplierid; supptrans.supplierno.