projekt kivitendo

  cb_transaction          => { type => 'boolean' },

  deliverydate            => { type => 'date' },

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

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

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

  gldate                  => { type => 'date', default => 'now' },

  id                      => { type => 'integer', not_null => 1, sequence => 'glid' },

  imported                => { type => 'boolean', default => 'false' },

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

  mtime                   => { type => 'timestamp' },

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

  ob_transaction          => { type => 'boolean' },

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

  storno                  => { type => 'boolean', default => 'false' },

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

  tax_point               => { type => 'date' },

  taxincluded             => { type => 'boolean' },

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

  transdate               => { type => 'date', default => 'now' },

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

-- @tag: add_gl_transaction_description

-- @description: Vorgangsbezeichnung für Dialogbuchungen

-- @depends: release_3_5_8

ALTER TABLE gl ADD transaction_description TEXT;