Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 2ae9ca71

Von Bernd Bleßmann vor mehr als 1 Jahr hinzugefügt

  • ID 2ae9ca71c358bf272781eab7afdf4c28fc84c769
  • Vorgänger abcea474
  • Nachfolger 549bb6d9

Auftrags-Eingang: DMS

Unterschiede anzeigen:

SL/Controller/File.pm
56 56 
# right:  access right used for import
57 57 
my %file_types = (
58 58 
  'sales_quotation'             => { gen => 1, gltype => '',   dir =>'SalesQuotation',       model => 'Order',          right => 'import_ar'  },
59 
  'sales_order_intake'          => { gen => 5, gltype => '',   dir =>'SalesOrderIntake',     model => 'Order',          right => 'import_ar'  },
59 60 
  'sales_order'                 => { gen => 5, gltype => '',   dir =>'SalesOrder',           model => 'Order',          right => 'import_ar'  },
60 61 
  'sales_delivery_order'        => { gen => 1, gltype => '',   dir =>'SalesDeliveryOrder',   model => 'DeliveryOrder',  right => 'import_ar'  },
61 62 
  'sales_reclamation'           => { gen => 5, gltype => '',   dir =>'SalesReclamation',     model => 'Reclamation',    right => 'import_ar'  },
sql/Pg-upgrade2/file_storage_sales_order_intake.sql
1 
-- @tag: file_storage_sales_order_intake
2 
-- @description: Dateispeicher auch für Auftragseingänge
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'                 )


  		




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


  		




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


  		




  
  12
  
    
          OR (object_type = 'purchase_order'  ) OR (object_type = 'purchase_delivery_order' ) OR (object_type = 'purchase_invoice'     )


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  18
  
    
          OR (object_type = 'invoice_for_advance_payment') OR (object_type = 'final_invoice')


  		




  
  19
  
    
  );


  		












Auch abrufbar als:  Unified diff