Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 8d252953

Von Werner Hahn vor etwa 2 Jahren hinzugefügt

Beistelllieferschein Belege im DMS speichern

Unterschiede anzeigen:

SL/Controller/File.pm
66 66
  'purchase_order'              => { gen => 7, gltype => '',   dir =>'PurchaseOrder',        model => 'Order',          right => 'import_ap'  },
67 67
  'purchase_delivery_order'     => { gen => 7, gltype => '',   dir =>'PurchaseDeliveryOrder',model => 'DeliveryOrder',  right => 'import_ap'  },
68 68
  'purchase_invoice'            => { gen => 6, gltype => 'ap', dir =>'PurchaseInvoice',      model => 'PurchaseInvoice',right => 'import_ap'  },
69
  'supplier_delivery_order'     => { gen => 7, gltype => '',   dir =>'SupplierDeliveryOrder',model => 'DeliveryOrder',  right => 'import_ap'  },
69 70
  'vendor'                      => { gen => 0, gltype => '',   dir =>'Vendor',               model => 'Vendor',         right => 'xx'         },
70 71
  'customer'                    => { gen => 1, gltype => '',   dir =>'Customer',             model => 'Customer',       right => 'xx'         },
71 72
  'project'                     => { gen => 0, gltype => '',   dir =>'Project',              model => 'Project',        right => 'xx'         },
sql/Pg-upgrade2/file_storage_supplier_delivery_order.sql
1
-- @tag: file_storage_supplier_delivery_order
2
-- @description: Dateispeicher auch für Beistelllieferschein
3
-- @depends: file_storage_partial_invoices
4

  
5
ALTER TABLE files
6
  DROP CONSTRAINT valid_type;
7
ALTER TABLE files
8
  ADD  CONSTRAINT valid_type CHECK (
9
             (object_type = 'credit_note'                 ) OR (object_type = 'invoice'                 ) OR (object_type = 'sales_order'             )
10
          OR (object_type = 'sales_quotation'             ) OR (object_type = 'sales_delivery_order'    ) OR (object_type = 'request_quotation'       )
11
          OR (object_type = 'purchase_order'              ) OR (object_type = 'purchase_delivery_order' ) OR (object_type = 'purchase_invoice'        )
12
          OR (object_type = 'vendor'                      ) OR (object_type = 'customer'                ) OR (object_type = 'part'                    )
13
          OR (object_type = 'gl_transaction'              ) OR (object_type = 'dunning'                 ) OR (object_type = 'dunning1'                )
14
          OR (object_type = 'dunning2'                    ) OR (object_type = 'dunning3'                ) OR (object_type = 'dunning_orig_invoice'    )
15
          OR (object_type = 'dunning_invoice'             ) OR (object_type = 'draft'                   ) OR (object_type = 'statement'               )
16
          OR (object_type = 'shop_image'                  ) OR (object_type = 'letter'                  ) OR (object_type = 'project'                 )
17
          OR (object_type = 'invoice_for_advance_payment' ) OR (object_type = 'final_invoice'           ) OR (object_type = 'supplier_delivery_order' )
18
  );

Auch abrufbar als: Unified diff