projekt kivitendo

  active_discount_source => { type => 'text', default => '', not_null => 1 },

  active_price_source    => { type => 'text', default => '', not_null => 1 },

  base_qty               => { type => 'float', scale => 4 },

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

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

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

  discount               => { type => 'float', scale => 4 },

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

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

  lastcost               => { type => 'numeric', precision => 15, scale => 5 },

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

  marge_price_factor     => { type => 'numeric', default => 1, precision => 15, scale => 5 },

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

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

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

  price_factor           => { type => 'numeric', default => 1, precision => 15, scale => 5 },

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

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

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

  qty                    => { type => 'numeric', precision => 25, scale => 5 },

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

  sellprice              => { type => 'numeric', precision => 15, scale => 5 },

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

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

  unit                   => { type => 'varchar', length => 20 },