⚲
Projekt
Übersicht
Aktivität
Roadmap
Tickets
Aufgewendete Zeit
News
Dokumente
Wiki
Foren
Repository
Allgemein
Hauptseite
Projekte
Hilfe
Profil
Anmelden
Suche
:
projekt kivitendo
Alle Projekte
projekt kivitendo
Herunterladen (5,08 KB)
Statistiken
| Zweig:
2017-validator-args
2018-cvar-presenter
2020-cgi-removal
2020-helper-number
2020-inventory-helper
2020-inventory-helper2
2020-leistungsdatum
2021-delivery-order-controller-3
2021-delivery-order-controller-5
2021-delivery-order-controller-7
2021-delivery-order-controller-8
transaction_description TEXT, shippingpoint TEXT, cv_record_number TEXT, reqdate DATE, --money/summery amount NUMERIC(15,5), netamount NUMERIC(15,5), payment_id INTEGER REFERENCES payment_terms(id), currency_id INTEGER NOT NULL REFERENCES currencies(id), taxincluded BOOLEAN NOT NULL, tax_point DATE, exchangerate NUMERIC(15,5), taxzone_id INTEGER NOT NULL REFERENCES tax_zones(id), --other notes TEXT, intnotes TEXT, language_id INTEGER REFERENCES language(id), salesman_id INTEGER REFERENCES employee(id), customer_id INTEGER REFERENCES customer(id), vendor_id INTEGER REFERENCES vendor(id), CONSTRAINT reclamations_customervendor_check CHECK ( (customer_id IS NOT NULL AND vendor_id IS NULL) OR (vendor_id IS NOT NULL AND customer_id IS NULL) ), PRIMARY KEY (id) ); CREATE TRIGGER mtime_reclamations BEFORE UPDATE ON reclamations FOR EACH ROW EXECUTE PROCEDURE set_mtime(); ALTER TABLE defaults ADD COLUMN p_reclamation_record_number TEXT NOT NULL DEFAULT 0; ALTER TABLE defaults ADD COLUMN s_reclamation_record_number TEXT NOT NULL DEFAULT 0; CREATE TABLE reclamation_items ( --base id SERIAL PRIMARY KEY, reclamation_id INTEGER NOT NULL REFERENCES reclamations(id) ON DELETE CASCADE, reason_id INTEGER NOT NULL REFERENCES reclamation_reasons(id), reason_description_ext TEXT, reason_description_int TEXT, position INTEGER NOT NULL CHECK(position > 0), itime TIMESTAMP without time zone DEFAULT now(), mtime TIMESTAMP without time zone, --header project_id INTEGER REFERENCES project(id) ON DELETE SET NULL, --part description parts_id INTEGER NOT NULL REFERENCES parts(id), description TEXT, longdescription TEXT, serialnumber TEXT, base_qty REAL, qty REAL, unit character varying(20) REFERENCES units(name), --money sellprice NUMERIC(15,5), lastcost NUMERIC(15,5), discount REAL, pricegroup_id INTEGER REFERENCES pricegroup(id), price_factor_id INTEGER REFERENCES price_factors(id), price_factor NUMERIC(15,5) DEFAULT 1, active_price_source TEXT NOT NULL DEFAULT ''::text, active_discount_source TEXT NOT NULL DEFAULT ''::text, --other reqdate DATE ); CREATE TRIGGER mtime_reclamation_items BEFORE UPDATE ON reclamation_items FOR EACH ROW EXECUTE PROCEDURE set_mtime(); « Zurück1…416417418419420…586Weiter »(418-418/586) Powered by Redmine © 2006-2025 Jean-Philippe Lang Lade...