Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 48f0c3d3

Von Bernd Bleßmann vor 12 Monaten hinzugefügt

  • ID 48f0c3d3270200dcc4af9d2fa616e75036dcecc1
  • Vorgänger 7e12ffd2
  • Nachfolger 217fd4b2

Lieferantenauftragsbestätigung: DB-Type order_types

Unterschiede anzeigen:

SL/DB/MetaSetup/Order.pm
40 40
  payment_id              => { type => 'integer' },
41 41
  proforma                => { type => 'boolean', default => 'false' },
42 42
  quonumber               => { type => 'text' },
43
  record_type             => { type => 'enum', check_in => [ 'request_quotation', 'sales_quotation', 'purchase_quotation_intake', 'purchase_order', 'sales_order_intake', 'sales_order' ], db_type => 'order_types', not_null => 1 },
43
  record_type             => { type => 'enum', check_in => [ 'request_quotation', 'sales_quotation', 'purchase_quotation_intake', 'purchase_order', 'sales_order_intake', 'sales_order', 'purchase_order_confirmation' ], db_type => 'order_types', not_null => 1 },
44 44
  reqdate                 => { type => 'date' },
45 45
  salesman_id             => { type => 'integer' },
46 46
  shippingpoint           => { type => 'text' },
sql/Pg-upgrade2/oe_purchase_order_confirmation_order_types.sql
1
-- @tag: oe_purchase_order_confirmation_order_types
2
-- @description: order_types-Eintrag für Lieferantenauftragsbesätigung (purchase_order_confirmation)
3
-- @depends: order_type
4

  
5
ALTER TYPE order_types ADD VALUE IF NOT EXISTS 'purchase_order_confirmation';

Auch abrufbar als: Unified diff