Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision d714c183

Von Tamino Steinert vor 9 Monaten hinzugefügt

  • ID d714c18364f52bc13a3ed99949a4215a15653b1c
  • Vorgänger d3ebfa65
  • Nachfolger 48508b25

EmailJournal: Belegtype um Lieferantenauftragsbestätigung erweitert

Unterschiede anzeigen:

SL/DB/MetaSetup/EmailJournal.pm
21 21
  mtime              => { type => 'timestamp', default => 'now()', not_null => 1 },
22 22
  obsolete           => { type => 'boolean', default => 'false', not_null => 1 },
23 23
  recipients         => { type => 'text', not_null => 1 },
24
  record_type        => { type => 'enum', check_in => [ 'sales_order', 'purchase_order', 'sales_quotation', 'request_quotation', 'purchase_quotation_intake', 'sales_order_intake', 'sales_delivery_order', 'purchase_delivery_order', 'supplier_delivery_order', 'rma_delivery_order', 'sales_reclamation', 'purchase_reclamation', 'invoice', 'invoice_for_advance_payment', 'invoice_for_advance_payment_storno', 'final_invoice', 'invoice_storno', 'credit_note', 'credit_note_storno', 'purchase_invoice', 'purchase_credit_note', 'ap_transaction', 'ar_transaction', 'gl_transaction' ], db_type => 'email_journal_record_type' },
24
  record_type        => { type => 'enum', check_in => [ 'sales_order', 'purchase_order', 'sales_quotation', 'request_quotation', 'purchase_quotation_intake', 'sales_order_intake', 'sales_delivery_order', 'purchase_delivery_order', 'supplier_delivery_order', 'rma_delivery_order', 'sales_reclamation', 'purchase_reclamation', 'invoice', 'invoice_for_advance_payment', 'invoice_for_advance_payment_storno', 'final_invoice', 'invoice_storno', 'credit_note', 'credit_note_storno', 'purchase_invoice', 'purchase_credit_note', 'ap_transaction', 'ar_transaction', 'gl_transaction', 'purchase_order_confirmation' ], db_type => 'email_journal_record_type' },
25 25
  sender_id          => { type => 'integer' },
26 26
  sent_on            => { type => 'timestamp', default => 'now()', not_null => 1 },
27 27
  status             => { type => 'enum', check_in => [ 'sent', 'send_failed', 'imported' ], db_type => 'email_journal_status', not_null => 1 },
sql/Pg-upgrade2/email_journal_record_types_add_purchase_order_confirmation.sql
1
-- @tag: email_journal_record_types_add_purchase_order_confirmation
2
-- @description: E-Mail-Journal Beleg Type um Lieferantenauftragsbestätigung erweitern
3
-- @depends: email_journal_record_import_types
4

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

Auch abrufbar als: Unified diff