← Back to branch summary

~vauxoo/openerp-venezuela-localization/migracion_localizacion

« back to all changes in this revision

Viewing changes to INGELUB/sql_post_ing.sql

  • Committer: Luis E. Escobar V.
  • Author(s): Vauxoo
  • Date: 2012-03-08 20:12:22 UTC
  • Revision ID: vxkikevx@gmail.com-20120308201222-c201bzwje7s246mw

[IMP] Added SQL sentences.

Show diffs side-by-side

added added

removed removed

Lines of Context:
INGELUB/sql_post_ing.sql
40
40
# price numeric DEFAULT 9.99
41
41
UPDATE account_retention  SET name = code WHERE name is null;
42
42
 
 
43
 
 
44
UPDATE account_tax SET name = 'IVA - 10% COMPRAS (ADIC.)' WHERE name = 'IVA - 12% COMPRAS'
 
45
UPDATE account_tax SET name = 'IVA - 0% COMPRAS SDCF' WHERE name = 'IVA - 0% COMPRAS'
 
46
 
 
47
UPDATE account_invoice_tax SET tax_id = at.id FROM account_tax at WHERE at.name = account_invoice_tax.name;
 
48
 
 
49
 
 
50
 
43
51
INSERT INTO account_wh_iva(id,create_uid,create_date,write_date,write_uid,code,account_id,number,
44
52
journal_id,currency_id,period_id,date,partner_id,name,date_ret,company_id,state,type) 
45
53
SELECT id,create_uid,create_date,write_date,write_uid,code,account_id,number,