projekt kivitendo

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

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

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

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

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

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

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

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

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

    version                                 => { type => 'varchar', length => 8 },

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    id                                      => { type => 'serial', not_null => 1 },

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

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

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

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

    datev_check_on_sales_invoice            => { type => 'boolean', default => 'true' },

    datev_check_on_purchase_invoice         => { type => 'boolean', default => 'true' },

    datev_check_on_ar_transaction           => { type => 'boolean', default => 'true' },

    datev_check_on_ap_transaction           => { type => 'boolean', default => 'true' },

    datev_check_on_gl_transaction           => { type => 'boolean', default => 'true' },

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

    is_changeable                           => { type => 'integer', default => 2, not_null => 1 },

    ir_changeable                           => { type => 'integer', default => 2, not_null => 1 },

    ar_changeable                           => { type => 'integer', default => 2, not_null => 1 },

    ap_changeable                           => { type => 'integer', default => 2, not_null => 1 },

    gl_changeable                           => { type => 'integer', default => 2, not_null => 1 },

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

    sales_order_show_delete                 => { type => 'boolean', default => 'true' },

    purchase_order_show_delete              => { type => 'boolean', default => 'true' },

    sales_delivery_order_show_delete        => { type => 'boolean', default => 'true' },

    purchase_delivery_order_show_delete     => { type => 'boolean', default => 'true' },

    is_show_mark_as_paid                    => { type => 'boolean', default => 'true' },

    ir_show_mark_as_paid                    => { type => 'boolean', default => 'true' },

    ar_show_mark_as_paid                    => { type => 'boolean', default => 'true' },

    ap_show_mark_as_paid                    => { type => 'boolean', default => 'true' },

    max_future_booking_interval             => { type => 'integer', default => 360 },

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

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

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

    show_weight                             => { type => 'boolean', default => 'false', not_null => 1 },

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

  ],

#========= ===========================================================

# prevents bookings to the to far away future

sub date_max_future {

  $main::lxdebug->enter_sub();

  my ($self, $date, $myconfig) = @_;

  my $dbh = $self->dbconnect($myconfig);

  my $query = "SELECT 1 FROM defaults WHERE ? - current_date > max_future_booking_interval";

  my $sth = prepare_execute_query($self, $dbh, $query, conv_date($date));

  my ($max_future_booking_interval) = $sth->fetchrow_array;

  $main::lxdebug->leave_sub();

  return $max_future_booking_interval;

}

# currently unused - value is set via audit_control (Bücherkontrolle)

sub get_max_future_booking_interval {

  my ($self) = @_;

  return ($self->{data}->{max_future_booking_interval});

}

=item C<get_max_future_booking_interval>

Returns the maximum interval value for future bookings

  'Cannot post transaction above the maximum future booking date!' => 'Das Buchungsdatum liegt oberhalb des maximal zulässigen Werts. Bitte korrigieren oder Wert erhöhen',

  'Empty selection for warehouse will not be added, even if the old bin is still visible (use back and forth to edit again).' => 'Leere Lager-Auswahl wird ignoriert, selbst wenn noch ein Lagerplatz ausgewählt ist. Alle Daten können durch zurück und vorwärts korrigiert werden.',

  'Maximum future booking interval' => 'Maximale Anzahl von Tagen an denen Buchungen in der Zukunft erlaubt sind.',

-- @tag: defaults_add_max_future_booking_intervall

-- @description: Fehleingaben für Buchungen in der Zukunft verhindern (s.a. 1897)

-- @depends: release_3_0_0

-- @charset: utf-8

ALTER TABLE defaults ADD COLUMN  max_future_booking_interval integer DEFAULT 360;

  <tr>

    <th>[% 'Maximum future booking interval' | $T8 %]</th>

    <td><input type="text" name="max_future_booking_interval" id="max_future_booking_interval" value="[% HTML.escape(max_future_booking_interval) %]"></td>

  </tr>