Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 3efd5d9c

Von Werner Hahn vor etwa 2 Jahren hinzugefügt

  • ID 3efd5d9cd0ad7521e1339965a28ecfc2612ed9d4
  • Vorgänger 411259d0
  • Nachfolger 1c66252f

fyle_type für RMA DeliveryOrder

Unterschiede anzeigen:

sql/Pg-upgrade2/file_storage_rma_delivery_order.sql
-- @tag: file_storage_rma_delivery_order
-- @description: Dateispeicher auch für Retourenlieferschein anbieten
-- @depends: file_storage_reclamation
ALTER TABLE files
DROP CONSTRAINT valid_type;
ALTER TABLE files
ADD CONSTRAINT valid_type CHECK (
(object_type = 'credit_note' ) OR (object_type = 'invoice' ) OR (object_type = 'sales_order' )
OR (object_type = 'sales_quotation' ) OR (object_type = 'sales_delivery_order' ) OR (object_type = 'request_quotation' )
OR (object_type = 'purchase_order' ) OR (object_type = 'purchase_delivery_order' ) OR (object_type = 'purchase_invoice' )
OR (object_type = 'vendor' ) OR (object_type = 'customer' ) OR (object_type = 'part' )
OR (object_type = 'gl_transaction' ) OR (object_type = 'dunning' ) OR (object_type = 'dunning1' )
OR (object_type = 'dunning2' ) OR (object_type = 'dunning3' ) OR (object_type = 'dunning_orig_invoice' )
OR (object_type = 'dunning_invoice' ) OR (object_type = 'draft' ) OR (object_type = 'statement' )
OR (object_type = 'shop_image' ) OR (object_type = 'letter' ) OR (object_type = 'project' )
OR (object_type = 'invoice_for_advance_payment' ) OR (object_type = 'final_invoice' ) OR (object_type = 'supplier_delivery_order' )
OR (object_type = 'sales_reclamation' ) OR (object_type = 'purchase_reclamation' ) OR (object_type = 'rma_delivery_order' )
);

Auch abrufbar als: Unified diff