Revision f8e2621e
Von Bernd Bleßmann vor mehr als 1 Jahr hinzugefügt
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
Auftrags-Eingang: DMS