projekt kivitendo

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

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

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

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

  bic                       => { type => 'varchar', length => 100 },

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

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

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

  city                      => { type => 'varchar', length => 75 },

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

  country                   => { type => 'varchar', length => 75 },

  creditlimit               => { type => 'numeric', default => '0', precision => 5, scale => 15 },

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

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

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

  department_1              => { type => 'varchar', length => 75 },

  department_2              => { type => 'varchar', length => 75 },

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

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

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

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

  fax                       => { type => 'varchar', length => 30 },

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

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

  iban                      => { type => 'varchar', length => 100 },

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

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

  klass                     => { type => 'integer', default => '0' },

  language                  => { type => 'varchar', length => 5 },

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

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

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

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

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

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

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

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

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

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

  street                    => { type => 'varchar', length => 75 },

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

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

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

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

  terms                     => { type => 'integer', default => '0' },

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

  username                  => { type => 'varchar', length => 50 },

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

  zipcode                   => { type => 'varchar', length => 10 },