projekt kivitendo

  ar_ap_chart_id          => { type => 'integer' },

  cb_transaction          => { type => 'boolean', default => 'false', not_null => 1 },

  currency_id             => { type => 'integer', not_null => 1 },

  customer_id             => { type => 'integer' },

  department_id           => { type => 'integer' },

  description             => { type => 'text' },

  direct_debit            => { type => 'boolean', default => 'false', not_null => 1 },

  employee_id             => { type => 'integer' },

  id                      => { type => 'serial', not_null => 1 },

  itime                   => { type => 'timestamp', default => 'now()', not_null => 1 },

  mtime                   => { type => 'timestamp', default => 'now()', not_null => 1 },

  notes                   => { type => 'text' },

  ob_transaction          => { type => 'boolean', default => 'false', not_null => 1 },

  ordnumber               => { type => 'text' },

  payment_id              => { type => 'integer' },

  project_id              => { type => 'integer' },

  reference               => { type => 'text' },

  show_details            => { type => 'boolean', default => 'false', not_null => 1 },

  taxincluded             => { type => 'boolean', default => 'false', not_null => 1 },

  template_name           => { type => 'text', not_null => 1 },

  template_type           => { type => 'enum', check_in => [ 'ar_transaction', 'ap_transaction', 'gl_transaction' ], db_type => 'record_template_type', not_null => 1 },

  transaction_description => { type => 'text' },

  vendor_id               => { type => 'integer' },

-- @tag: add_record_templates_transaction_description

-- @description: Vorgangsbezeichnung in Dialog-Vorlage ergänzen

-- @depends: release_3_5_8 create_record_template_tables

ALTER TABLE record_templates ADD COLUMN transaction_description TEXT;