projekt kivitendo

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  position                     => { 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 },

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

  recurring_billing_mode       => { type => 'enum', check_in => [ 'never', 'once', 'always' ], db_type => 'items_recurring_billing_mode', default => 'always', not_null => 1 },

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

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

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

  ship                         => { type => 'float', precision => 4, scale => 4 },

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

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

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

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

  recurring_billing_invoice => {

    class       => 'SL::DB::Invoice',

    key_columns => { recurring_billing_invoice_id => 'id' },

  },

-- @tag: sales_orders_recurring_billing_mode

-- @description: Verkaufsaufträge: Positionen wiederkehrender Rechnungen optional nur einmal oder gar nicht abrechnen

-- @depends: release_3_6_0

CREATE TYPE items_recurring_billing_mode AS ENUM ('never', 'once', 'always');

ALTER TABLE orderitems

  ADD COLUMN recurring_billing_mode items_recurring_billing_mode DEFAULT 'always' NOT NULL,

  ADD COLUMN recurring_billing_invoice_id INTEGER,

  ADD FOREIGN KEY (recurring_billing_invoice_id) REFERENCES ar (id) ON DELETE SET NULL;