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

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

Hi Rafael,

There are separate fields for this in both those tables.

IRD number is potentially  11 chars in NZ.
In Australia  ABN is a unique 11 digit identifier
Looks like longest is 12 char on this list - plus 3 chars for country code = 15

http://www.tmf-vat.com/vat/eu-vat-number-formats.html
<http://www.tmf-vat.com/vat/eu-vat-number-formats.html>

Phil

Ph: +64 (0)275 567890
Skype: daintree
http://www.logicworks.co.nz

On 22 July 2013 at 17:05 webERP Developers
<web...@li...> wrote:

>  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
> <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
> <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.
> 
> ------------------------------------------------------------------------------
>  See everything from the browser to the database with AppDynamics
>  Get end-to-end visibility with application monitoring from AppDynamics
>  Isolate bottlenecks and diagnose root cause in seconds.
>  Start your free trial of AppDynamics Pro today!
> 
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk_______________________________________________
>  Web-erp-developers mailing list
>  Web...@li...
>  https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>