CAO - FAKTURA

Code: Alles auswählen

ALTER TABLE ADRESSEN
  ADD COLUMN FSKGRP ENUM('Y','N') NOT NULL DEFAULT 'N' AFTER GRUPPE;

ALTER TABLE ARTIKEL  
  ADD COLUMN EK_VPE DECIMAL(12,4) NOT NULL DEFAULT '0.0000' AFTER EK_PREIS,  
  ADD COLUMN EKDS_PREIS DECIMAL(12,4) NOT NULL DEFAULT '0.0000' AFTER EK_VPE,
  ADD COLUMN SHOP_SORT INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER SHOP_META_KEY,
  ADD COLUMN SHOP_LIEFSTATUS INT(11) UNSIGNED NOT NULL DEFAULT 1 AFTER SHOP_SORT,
  ADD COLUMN SHOP_LIEFTEXT VARCHAR(255) NOT NULL DEFAULT 'Standard' AFTER SHOP_LIEFSTATUS,
  ADD COLUMN SHOP_CHANGE_LIEF INT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER SHOP_LIEFTEXT;
 
ALTER TABLE JOURNAL  
  ADD COLUMN AGBNUM VARCHAR(20) NULL DEFAULT NULL AFTER PROJEKT_ID,
  ADD COLUMN VERSNR INT(11) NOT NULL DEFAULT '-1' AFTER VLSNUM,  
  ADD COLUMN AGBDATUM DATE NULL DEFAULT NULL AFTER GLOBRABATT,
  ADD COLUMN TRACKINGCODE VARCHAR(255) NULL DEFAULT NULL AFTER INFO;
  
ALTER TABLE ZAHLUNGSARTEN
  ADD COLUMN AUTOZAHL_FLAG ENUM('N','Y') NOT NULL DEFAULT 'N' AFTER AKTIV_FLAG;

ALTER TABLE LIEFERSCHEIN
  ADD COLUMN TRACKINGCODE VARCHAR(255) NULL DEFAULT NULL AFTER INFO;
  
UPDATE ZAHLUNGSARTEN SET AUTOZAHL_FLAG='Y' WHERE REC_ID IN(1,5);