projekt kivitendo

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::BankAccount;

use strict;

use SL::DB::MetaSetup::BankAccount;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::Buchungsgruppe;

use strict;

use SL::DB::MetaSetup::Buchungsgruppe;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::Contact;

use strict;

use SL::DB::MetaSetup::Contact;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::CustomVariable;

use strict;

use SL::DB::MetaSetup::CustomVariable;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::CustomVariableConfig;

use strict;

use SL::DB::MetaSetup::CustomVariableConfig;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::CustomVariableValidity;

use strict;

use SL::DB::MetaSetup::CustomVariableValidity;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::Draft;

use strict;

use SL::DB::MetaSetup::Draft;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::Dunning;

use strict;

use SL::DB::MetaSetup::Dunning;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::DunningConfig;

use strict;

use SL::DB::MetaSetup::DunningConfig;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::Employee;

use strict;

use SL::DB::MetaSetup::Employee;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::FollowUp;

use strict;

use SL::DB::MetaSetup::FollowUp;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::FollowUpLink;

use strict;

use SL::DB::MetaSetup::FollowUpLink;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::GenericTranslation;

use strict;

use SL::DB::MetaSetup::GenericTranslation;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

use SL::DB::BankAccount;

use SL::DB::Buchungsgruppe;

use SL::DB::Contact;

use SL::DB::CustomVariable;

use SL::DB::CustomVariableConfig;

use SL::DB::CustomVariableValidity;

use SL::DB::Draft;

use SL::DB::Dunning;

use SL::DB::DunningConfig;

use SL::DB::Employee;

use SL::DB::FollowUp;

use SL::DB::FollowUpLink;

use SL::DB::GenericTranslation;

use SL::DB::History;

use SL::DB::Language;

use SL::DB::Licemse;

use SL::DB::Note;

use SL::DB::PaymentTerm;

use SL::DB::Pricegroup;

use SL::DB::RMA;

use SL::DB::SepaExport;

use SL::DB::SepaExportItem;

use SL::DB::Tax;

use SL::DB::Taxkey;

# these will not be managed as Rose::DB models, because they are not normalized

     schema_info

  bank_accounts                  => 'bank_account',

  buchungsgruppen                => 'buchungsgruppe',

  contacts                       => 'contact',

  custom_variable_configs        => 'custom_variable_config',

  custom_variables               => 'custom_variable',

  custom_variables_validity      => 'custom_variable_validity',

  drafts                         => 'draft',

  dunning                        => 'dunning',

  dunning_config                 => 'dunning_config',

  employee                       => 'employee',

  follow_up_links                => 'follow_up_link',

  follow_ups                     => 'follow_up',

  generic_translations           => 'generic_translation',

  history_erp                    => 'history',

  language                       => 'language',

  license                        => 'licemse',

  notes                          => 'note',

  payment_terms                  => 'payment_term',

  pricegroup                     => 'pricegroup',

  rma                            => 'RMA',

  sepa_export                    => 'sepa_export',

  sepa_export_items              => 'sepa_export_item',

  tax                            => 'tax',

  taxkeys                        => 'taxkey',

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::History;

use strict;

use SL::DB::MetaSetup::History;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::Language;

use strict;

use SL::DB::MetaSetup::Language;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::Licemse;

use strict;

use SL::DB::MetaSetup::Licemse;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

1;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::BankAccount;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'bank_accounts',

  columns => [

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

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

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  foreign_keys => [

    chart => {

      class       => 'SL::DB::Chart',

      key_columns => { chart_id => 'id' },

    },

  ],

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::Buchungsgruppe;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'buchungsgruppen',

  columns => [

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

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

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

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

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

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

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

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::Contact;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'contacts',

  columns => [

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    cp_gender      => { type => 'character', length => 1 },

  ],

  primary_key_columns => [ 'cp_id' ],

  allow_inline_column_values => 1,

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::CustomVariable;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'custom_variables',

  columns => [

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

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

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

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

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

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

    number_value    => { type => 'numeric', precision => 5, scale => 25 },

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  allow_inline_column_values => 1,

  foreign_keys => [

    config => {

      class       => 'SL::DB::CustomVariableConfig',

      key_columns => { config_id => 'id' },

    },

  ],

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::CustomVariableConfig;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'custom_variable_configs',

  columns => [

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

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

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

    type                => { type => 'varchar', length => 20 },

    module              => { type => 'varchar', length => 20 },

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

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

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

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

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  allow_inline_column_values => 1,

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::CustomVariableValidity;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'custom_variables_validity',

  columns => [

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  allow_inline_column_values => 1,

  foreign_keys => [

    config => {

      class       => 'SL::DB::CustomVariableConfig',

      key_columns => { config_id => 'id' },

    },

  ],

);

1;

;

    contact => {

      class       => 'SL::DB::Contact',

      key_columns => { cp_id => 'cp_id' },

    },

    employee => {

      class       => 'SL::DB::Employee',

      key_columns => { employee_id => 'id' },

    },

    language => {

      class       => 'SL::DB::Language',

      key_columns => { language_id => 'id' },

    },

    salesman => {

      class       => 'SL::DB::Employee',

      key_columns => { salesman_id => 'id' },

    },

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::Draft;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'drafts',

  columns => [

    id          => { type => 'varchar', length => 50, not_null => 1 },

    module      => { type => 'varchar', length => 50, not_null => 1 },

    submodule   => { type => 'varchar', length => 50, not_null => 1 },

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  allow_inline_column_values => 1,

  foreign_keys => [

    employee => {

      class       => 'SL::DB::Employee',

      key_columns => { employee_id => 'id' },

    },

  ],

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::Dunning;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'dunning',

  columns => [

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

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

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

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

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

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

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

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  allow_inline_column_values => 1,

  foreign_keys => [

    dunning_config => {

      class       => 'SL::DB::DunningConfig',

      key_columns => { dunning_config_id => 'id' },

    },

    fee_interest_ar => {

      class       => 'SL::DB::Invoice',

      key_columns => { fee_interest_ar_id => 'id' },

    },

  ],

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::DunningConfig;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'dunning_config',

  columns => [

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::Employee;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'employee',

  columns => [

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  unique_key => [ 'login' ],

  allow_inline_column_values => 1,

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::FollowUp;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'follow_ups',

  columns => [

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

    follow_up_date   => { type => 'date', not_null => 1 },

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

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  allow_inline_column_values => 1,

  foreign_keys => [

    employee => {

      class       => 'SL::DB::Employee',

      key_columns => { created_for_user => 'id' },

    },

    employee_obj => {

      class       => 'SL::DB::Employee',

      key_columns => { created_by => 'id' },

    },

    note => {

      class       => 'SL::DB::Note',

      key_columns => { note_id => 'id' },

    },

  ],

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::FollowUpLink;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'follow_up_links',

  columns => [

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

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

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  allow_inline_column_values => 1,

  foreign_keys => [

    follow_up => {

      class       => 'SL::DB::FollowUp',

      key_columns => { follow_up_id => 'id' },

    },

  ],

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::GenericTranslation;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'generic_translations',

  columns => [

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

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

    translation_type => { type => 'varchar', length => 100, not_null => 1 },

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

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

  ],

  primary_key_columns => [ 'id' ],

  foreign_keys => [

    language => {

      class       => 'SL::DB::Language',

      key_columns => { language_id => 'id' },

    },

  ],

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::History;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'history_erp',

  columns => [

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

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

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  allow_inline_column_values => 1,

  foreign_keys => [

    employee => {

      class       => 'SL::DB::Employee',

      key_columns => { employee_id => 'id' },

    },

  ],

);

1;

;

    dunning_config => {

      class       => 'SL::DB::DunningConfig',

      key_columns => { dunning_config_id => 'id' },

    },

    salesman => {

      class       => 'SL::DB::Employee',

      key_columns => { salesman_id => 'id' },

    },

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::Language;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'language',

  columns => [

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

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

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

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

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  allow_inline_column_values => 1,

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::Licemse;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'license',

  columns => [

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

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

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

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::Note;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'notes',

  columns => [

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

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

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

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  allow_inline_column_values => 1,

  foreign_keys => [

    employee => {

      class       => 'SL::DB::Employee',

      key_columns => { created_by => 'id' },

    },

  ],

);

1;

;

    employee => {

      class       => 'SL::DB::Employee',

      key_columns => { employee_id => 'id' },

    },

    project_manager => {

      class       => 'SL::DB::Employee',

      key_columns => { project_manager_id => 'id' },

    },

    salesman => {

      class       => 'SL::DB::Employee',

      key_columns => { salesman_id => 'id' },

    },

  foreign_keys => [

    buchungsgruppen => {

      class       => 'SL::DB::Buchungsgruppe',

      key_columns => { buchungsgruppen_id => 'id' },

    },

  ],

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::PaymentTerm;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'payment_terms',

  columns => [

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

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

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

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

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

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  allow_inline_column_values => 1,

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::Pricegroup;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'pricegroup',

  columns => [

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

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

  ],

  primary_key_columns => [ 'id' ],

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::RMA;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'rma',

  columns => [

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  allow_inline_column_values => 1,

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::SepaExport;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'sepa_export',

  columns => [

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  allow_inline_column_values => 1,

  foreign_keys => [

    employee => {

      class       => 'SL::DB::Employee',

      key_columns => { employee_id => 'id' },

    },

  ],

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::SepaExportItem;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'sepa_export_items',

  columns => [

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

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

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

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

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

    reference                => { type => 'varchar', length => 35 },

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

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

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

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

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

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

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

    end_to_end_id            => { type => 'varchar', length => 35 },

  ],

  primary_key_columns => [ 'id' ],

  foreign_keys => [

    ap => {

      class       => 'SL::DB::PurchaseInvoice',

      key_columns => { ap_id => 'id' },

    },

    chart => {

      class       => 'SL::DB::Chart',

      key_columns => { chart_id => 'id' },

    },

    sepa_export => {

      class       => 'SL::DB::SepaExport',

      key_columns => { sepa_export_id => 'id' },

    },

  ],

);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::Tax;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->setup(

  table   => 'tax',

  columns => [

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

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

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

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

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

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

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

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

  ],

  primary_key_columns => [ 'id' ],

  allow_inline_column_values => 1,