Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 64cb58a3

Von Bernd Bleßmann vor 12 Monaten hinzugefügt

  • ID 64cb58a302fcbd1e0f48458d7f27621e1c8e75e6
  • Vorgänger 4425d550
  • Nachfolger 44787171

Lieferantenauftragsbestätigung: DMS

Unterschiede anzeigen:

SL/Controller/File.pm
67 67 
  'request_quotation'           => { gen => 7, gltype => '',   dir =>'RequestForQuotation',     model => 'Order',          right => 'import_ap'  },
68 68 
  'purchase_quotation_intake'   => { gen => 7, gltype => '',   dir =>'PurchaseQuotationIntake', model => 'Order',          right => 'import_ap'  },
69 69 
  'purchase_order'              => { gen => 7, gltype => '',   dir =>'PurchaseOrder',           model => 'Order',          right => 'import_ap'  },
70 
  'purchase_order_confirmation' => { gen => 7, gltype => '',   dir =>'PurchaseOrderConfirmation', model => 'Order',        right => 'import_ap'  },
70 71 
  'purchase_delivery_order'     => { gen => 7, gltype => '',   dir =>'PurchaseDeliveryOrder',   model => 'DeliveryOrder',  right => 'import_ap'  },
71 72 
  'purchase_reclamation'        => { gen => 7, gltype => '',   dir =>'PurchaseReclamation',     model => 'Reclamation',    right => 'import_ap'  },
72 73 
  'purchase_invoice'            => { gen => 6, gltype => 'ap', dir =>'PurchaseInvoice',         model => 'PurchaseInvoice',right => 'import_ap'  },
sql/Pg-upgrade2/file_storage_purchase_order_confirmation.sql
1 
-- @tag: file_storage_purchase_order_confirmation
2 
-- @description: Dateispeicher auch für Lieferantenauftragsbestätigungen
3 
-- @depends: file_storage_purchase_quotation_intake
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'                    )


  		




  
  10
  
    
          OR (object_type = 'sales_order'                ) OR (object_type = 'sales_order_intake'         )


  		




  
  11
  
    
          OR (object_type = 'sales_quotation'            ) OR (object_type = 'sales_delivery_order'       )


  		




  
  12
  
    
          OR (object_type = 'request_quotation'          ) OR (object_type = 'purchase_quotation_intake'  )


  		




  
  13
  
    
          OR (object_type = 'purchase_order'             ) OR (object_type = 'purchase_order_confirmation')


  		




  
  14
  
    
          OR (object_type = 'purchase_delivery_order'    ) OR (object_type = 'purchase_invoice'           )


  		




  
  15
  
    
          OR (object_type = 'vendor'                     ) OR (object_type = 'customer'                   ) OR (object_type = 'part'                   )


  		




  
  16
  
    
          OR (object_type = 'gl_transaction'             ) OR (object_type = 'dunning'                    ) OR (object_type = 'dunning1'               )


  		




  
  17
  
    
          OR (object_type = 'dunning2'                   ) OR (object_type = 'dunning3'                   ) OR (object_type = 'dunning_orig_invoice'   )


  		




  
  18
  
    
          OR (object_type = 'dunning_invoice'            ) OR (object_type = 'draft'                      ) OR (object_type = 'statement'              )


  		




  
  19
  
    
          OR (object_type = 'shop_image'                 ) OR (object_type = 'letter'                     ) OR (object_type = 'project'                )


  		




  
  20
  
    
          OR (object_type = 'invoice_for_advance_payment') OR (object_type = 'final_invoice'              ) OR (object_type = 'supplier_delivery_order')


  		




  
  21
  
    
          OR (object_type = 'sales_reclamation'          ) OR (object_type = 'purchase_reclamation'       ) OR (object_type = 'rma_delivery_order'     )


  		




  
  22
  
    
  );


  		












Auch abrufbar als:  Unified diff