Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 7289518a

Von Bernd Bleßmann vor etwa 1 Jahr hinzugefügt

  • ID 7289518a4d918a1855f552a57e582f8c5b94f03e
  • Vorgänger d9969d0b
  • Nachfolger 110e0829

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