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 },

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

    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' },

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

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

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

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

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

    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' },

    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 },

    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' },

    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' },