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:

    taxcum_cumulative_taxass_id integer NOT NULL REFERENCES taxass (taxass_=
id)
  );
  GRANT ALL ON TABLE taxcum TO xtrole;
- COMMENT ON TABLE taxcum IS 'The tax cumulative table associates tax assig=
nments with each other in a parent child relationsh to calculate cumulative=
taxes.';
+ COMMENT ON TABLE taxcum IS 'The tax cumulative table associates tax assig=
nments with each other in a parent child relationship to calculate cumulati=
ve taxes.';
  COMMENT ON COLUMN taxcum.taxcum_taxass_id IS 'The id of the parent tax as=
signment.';
- COMMENT ON COLUMN taxcum.taxcum_cumulative_taxass_id IS 'The id of the ta=
x assigment whose calculation will be added to the parent base price.';
+ COMMENT ON COLUMN taxcum.taxcum_cumulative_taxass_id IS 'The id of the ta=
x assignment whose calculation will be added to the parent base price.';
+ }}}
+ =

+ 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 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);
  }}}
  =

  What privileges do we need?