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:

  COMMENT ON COLUMN taxclass.taxclass_descrip IS 'Description';
  COMMENT ON COLUMN taxclass.taxclass_sequence IS 'Group sequence';
  }}}
+ =

+  . '''taxrate''' - Stores tax rate data for tax codes
+ {{{
+ CREATE TABLE taxrate (
+   taxrate_id serial,
+   taxrate_tax_id integer NOT NULL REFERENCES tax (tax_id),
+   taxrate_rate numeric (8,4) NOT NULL,
+   taxrate_effective date,
+   taxrate_expires date
+ );
+ GRANT ALL ON TABLE taxrate TO xtrole;
+ COMMENT ON TABLE taxrate IS 'Tax rates.';
+ COMMENT ON COLUMN taxrate.taxrate_id IS 'Primary key.';
+ COMMENT ON COLUMN taxrate.taxrate_tax_id IS 'The id of the parent tax cod=
e.'; =

+ COMMENT ON COLUMN taxrate.taxrate_rate IS 'Tax rate percentage.';
+ COMMENT ON COLUMN taxrate.taxrate_effective IS 'The effective date of the=
tax rate.  NULL value means always.';
+ COMMENT ON COLUMN taxrate.taxrate_expires IS 'The expire date of the tax =
rate.  NULL value means never.'; =

+ }}}
+ =

-  . taxass - Used to store tax assignment information.  Replaces taxsel.
+  . '''taxass''' - Used to store tax assignment information.  Replaces tax=
sel.
  =

  {{{
  CREATE TABLE taxass
@@ -421, +440 @@

  }}}
  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).
  =

+ '''tax''' will be modified to include a reference to tax class:
+ {{{
+ ALTER TABLE tax ADD COLUMN tax_taxclass_id integer REFERENCES taxclass (t=
axclass_id);
+ }}}
+ =

+ =

+ =

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

@@ -465, +491 @@

   * selectforbilling
   * selectuninvoicedshipment
  =

- The triggers on cohead and quhead will need to be altered to reference ta=
x zone instead of tax authority.
- The following api views will need to be altered to reference tax zone ins=
tead of tax authority:
+ The triggers on cohead and quhead will need to be altered to reference ta=
x zone instead of tax authority. The following api views will need to be al=
tered to reference tax zone instead of tax authority:
+ =

   * creditmemo
   * creditmemoline
   * customer