Revision 8d252953
Von Werner Hahn vor mehr als 2 Jahren hinzugefügt
| SL/Controller/File.pm | ||
|---|---|---|
|
'purchase_order' => { gen => 7, gltype => '', dir =>'PurchaseOrder', model => 'Order', right => 'import_ap' },
|
||
|
'purchase_delivery_order' => { gen => 7, gltype => '', dir =>'PurchaseDeliveryOrder',model => 'DeliveryOrder', right => 'import_ap' },
|
||
|
'purchase_invoice' => { gen => 6, gltype => 'ap', dir =>'PurchaseInvoice', model => 'PurchaseInvoice',right => 'import_ap' },
|
||
|
'supplier_delivery_order' => { gen => 7, gltype => '', dir =>'SupplierDeliveryOrder',model => 'DeliveryOrder', right => 'import_ap' },
|
||
|
'vendor' => { gen => 0, gltype => '', dir =>'Vendor', model => 'Vendor', right => 'xx' },
|
||
|
'customer' => { gen => 1, gltype => '', dir =>'Customer', model => 'Customer', right => 'xx' },
|
||
|
'project' => { gen => 0, gltype => '', dir =>'Project', model => 'Project', right => 'xx' },
|
||
| sql/Pg-upgrade2/file_storage_supplier_delivery_order.sql | ||
|---|---|---|
|
-- @tag: file_storage_supplier_delivery_order
|
||
|
-- @description: Dateispeicher auch für Beistelllieferschein
|
||
|
-- @depends: file_storage_partial_invoices
|
||
|
|
||
|
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' )
|
||
|
);
|
||
Auch abrufbar als: Unified diff
Beistelllieferschein Belege im DMS speichern