omfgppc - 2009-03-10

You have subscribed to a wiki page or wiki category on "xTuple" for change =
notification.

The "EnhancedTaxInternationalization" page has been changed by jrogelstad:

  =

  =3D=3D Schema Changes =3D=3D
  =3D=3D=3D New Tables =3D=3D=3D
-  . taxzone - Will be used to store tax zone master data
+  . '''taxzone'''' - Will be used to store tax zone master data.
  =

  {{{
  CREATE TABLE taxzone
@@ -342, +342 @@

  COMMENT ON COLUMN taxzone.taxzone_code IS 'Code';
  COMMENT ON COLUMN taxzone.taxzone_descrip IS 'Description';
  }}}
+ Tax zone should be populated by the id, code and names listed in existing=
tax authorities into the tax zone id, code and description fields.  This w=
ill allow for a smooth transition from the use of tax authority to tax zone=
on all records.
+ =

-  . taxclass - Will be used to store tax class master data
+  . '''taxclass''' - Will be used to store tax class master data
  =

  {{{
  CREATE TABLE taxclass
@@ -397, +399 @@

  =

  The following tables will need to be updated to include a taxzone column =
as such:
  {{{
- ALTER TABLE asohist ADD COLUMN asohist_taxzone_id integer REFERENCES taxz=
one (taxzone_id);
- ALTER TABLE ccpay ADD COLUMN ccpay_taxzone_id integer REFERENCES taxzone =
(taxzone_id);
  ALTER TABLE cmhead ADD COLUMN cmhead_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
- ALTER TABLE cmitem ADD COLUMN cmitem_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
- ALTER TABLE cobill ADD COLUMN cobill_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
  ALTER TABLE cobmisc ADD COLUMN cobmisc_taxzone_id integer REFERENCES taxz=
one (taxzone_id);
  ALTER TABLE cohead ADD COLUMN cohead_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
- ALTER TABLE cohist ADD COLUMN cohist_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
- ALTER TABLE coitem ADD COLUMN coitem_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
  ALTER TABLE crmacct ADD COLUMN crmacct_taxzone_id integer REFERENCES taxz=
one (taxzone_id);
  ALTER TABLE custinfo ADD COLUMN custinfo_taxzone_id integer REFERENCES ta=
xzone (taxzone_id);
  ALTER TABLE invchead ADD COLUMN invchead_taxzone_id integer REFERENCES ta=
xzone (taxzone_id);
- ALTER TABLE invcitem ADD COLUMN invcitem_taxzone_id integer REFERENCES ta=
xzone (taxzone_id);
  ALTER TABLE itemtax ADD COLUMN itemtax_taxzone_id integer REFERENCES taxz=
one (taxzone_id);
- ALTER TABLE pohead ADD COLUMN pohead_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
  ALTER TABLE prospect ADD COLUMN prospect_taxzone_id integer REFERENCES ta=
xzone (taxzone_id);
  ALTER TABLE quhead ADD COLUMN quhead_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
- ALTER TABLE quitem ADD COLUMN quitem_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
  ALTER TABLE rahead ADD COLUMN rahead_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
- ALTER TABLE raitem ADD COLUMN raitem_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
  ALTER TABLE shiptoinfo ADD COLUMN shiptoinfo_taxzone_id integer REFERENCE=
S taxzone (taxzone_id);
- ALTER TABLE tax ADD COLUMN tax_taxzone_id integer REFERENCES taxzone (tax=
zone_id);
+ ALTER TABLE taxreg ADD COLUMN taxreg_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
- ALTER TABLE taxtype ADD COLUMN taxtype_taxzone_id integer REFERENCES taxz=
one (taxzone_id);
- ALTER TABLE taxzone ADD COLUMN taxzone_taxzone_id integer REFERENCES taxz=
one (taxzone_id);
  ALTER TABLE tohead ADD COLUMN tohead_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
- ALTER TABLE toitem ADD COLUMN toitem_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
  ALTER TABLE vendaddrinfo ADD COLUMN vendaddrinfo_taxzone_id integer REFER=
ENCES taxzone (taxzone_id);
  ALTER TABLE vendinfo ADD COLUMN vendinfo_taxzone_id integer REFERENCES ta=
xzone (taxzone_id);
  ALTER TABLE vohead ADD COLUMN vohead_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
- ALTER TABLE voitem ADD COLUMN voitem_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
  ALTER TABLE whsinfo ADD COLUMN whsinfo_taxzone_id integer REFERENCES taxz=
one (taxzone_id);
  }}}
+ =

+ These same tables should be populated with the existing taxauth_id into t=
he taxzone_id on their respective records.  Finally, the taxauth_id on the =
tables listed above should be dropped, with the exception of taxreg (tax re=
gistration).
+ =

+ =

  =

  What privileges do we need?
  ||||<style=3D"text-align: center;">'''Privileges for feature''' ||