projekt kivitendo

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    curr                      => { type => 'character', length => 3 },

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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