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.
|
