projekt kivitendo

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  record_type                => { type => 'enum', check_in => [ 'sales_delivery_order', 'purchase_delivery_order', 'supplier_delivery_order', 'rma_delivery_order' ], db_type => 'delivery_order_types', not_null => 1 },

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  order_probability          => { type => 'integer', default => '0', not_null => 1 },

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

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

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

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

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

  record_type                => { type => 'enum', check_in => [ 'request_quotation', 'sales_quotation', 'purchase_quotation_intake', 'purchase_order', 'sales_order_intake', 'sales_order', 'purchase_order_confirmation' ], db_type => 'order_types', not_null => 1 },

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

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

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

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

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

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

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

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

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

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

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

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

-- @tag: oe_delivery_orders_add_vendor_confirmation_number

-- @description: Auftragsbestätigungs-Nummer des Lieferanten für Aufträge und Lieferscheine

-- @depends: release_3_8_0

ALTER TABLE oe              ADD COLUMN vendor_confirmation_number TEXT;

ALTER TABLE delivery_orders ADD COLUMN vendor_confirmation_number TEXT;