Wiki Change:

omfgppc
2009-03-10
2013-03-08
  • omfgppc
    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?