Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 4fd22b56

Von Sven Schöling vor mehr als 14 Jahren hinzugefügt

  • ID 4fd22b569d4436293e0a9d364d7356b5bfc503e5
  • Vorgänger 78034f24
  • Nachfolger 606b8c86

DBO Update - alle normalen Models hinzugefügt.

Unterschiede anzeigen:

SL/DB/BankAccount.pm
# 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;
SL/DB/Buchungsgruppe.pm
# 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;
SL/DB/Contact.pm
# 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;
SL/DB/CustomVariable.pm
# 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;
SL/DB/CustomVariableConfig.pm
# 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;
SL/DB/CustomVariableValidity.pm
# 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;
SL/DB/Draft.pm
# 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;
SL/DB/Dunning.pm
# 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;
SL/DB/DunningConfig.pm
# 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;
SL/DB/Employee.pm
# 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;
SL/DB/FollowUp.pm
# 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;
SL/DB/FollowUpLink.pm
# 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;
SL/DB/GenericTranslation.pm
# 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;
SL/DB/Helpers/ALL.pm
use strict;
use SL::DB::Assembly;
use SL::DB::BankAccount;
use SL::DB::Bin;
use SL::DB::Buchungsgruppe;
use SL::DB::Business;
use SL::DB::Chart;
use SL::DB::Contact;
use SL::DB::CustomVariable;
use SL::DB::CustomVariableConfig;
use SL::DB::CustomVariableValidity;
use SL::DB::Customer;
use SL::DB::DeliveryOrder;
use SL::DB::DeliveryOrderItem;
use SL::DB::DeliveryOrderItemsStock;
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::GLTransaction;
use SL::DB::GenericTranslation;
use SL::DB::History;
use SL::DB::Invoice;
use SL::DB::InvoiceItem;
use SL::DB::Language;
use SL::DB::Licemse;
use SL::DB::Note;
use SL::DB::Order;
use SL::DB::OrderItem;
use SL::DB::Part;
use SL::DB::PaymentTerm;
use SL::DB::PriceFactor;
use SL::DB::Pricegroup;
use SL::DB::Printer;
use SL::DB::Project;
use SL::DB::PurchaseInvoice;
use SL::DB::RMA;
use SL::DB::SepaExport;
use SL::DB::SepaExportItem;
use SL::DB::Shipto;
use SL::DB::Tax;
use SL::DB::Taxkey;
use SL::DB::TransferType;
use SL::DB::Unit;
use SL::DB::Vendor;
use SL::DB::Warehouse;
1;
__END__
SL/DB/Helpers/Mappings.pm
use strict;
# threse will not be managed as Rose::DB models, because they are not normalized
# these will not be managed as Rose::DB models, because they are not normalized
# significant changes are needed to get them done.
my @lxoffice_blacklist_permanent = qw(
acc_trans audittrail customertax datev defaults department dpt_trans
......
# these are not managed _yet_, but will hopefully at some point.
# if you are confident that one of these works, remove it here.
my @lxoffice_blacklist_temp = qw(
bank_accounts buchungsgruppen contacts custom_variable_configs
custom_variables custom_variables_validity drafts dunning dunning_config
employee follow_up_links follow_ups generic_translations history_erp language
license notes payment_terms pricegroup rma schema_info sepa_export
sepa_export_items tax taxkeys
schema_info
);
my @lxoffice_blacklist = (@lxoffice_blacklist_permanent, @lxoffice_blacklist_temp);
......
my %lxoffice_package_names = (
ar => 'invoice',
ap => 'purchase_invoice',
bank_accounts => 'bank_account',
buchungsgruppen => 'buchungsgruppe',
contacts => 'contact',
custom_variable_configs => 'custom_variable_config',
custom_variables => 'custom_variable',
custom_variables_validity => 'custom_variable_validity',
delivery_orders => 'delivery_order',
delivery_order_items => 'delivery_order_item',
drafts => 'draft',
dunning => 'dunning',
dunning_config => 'dunning_config',
employee => 'employee',
follow_up_links => 'follow_up_link',
follow_ups => 'follow_up',
generic_translations => 'generic_translation',
gl => 'GLTransaction',
history_erp => 'history',
invoice => 'invoice_item',
language => 'language',
license => 'licemse',
notes => 'note',
orderitems => 'order_item',
oe => 'order',
parts => 'part',
payment_terms => 'payment_term',
price_factors => 'price_factor',
pricegroup => 'pricegroup',
printers => 'Printer',
rma => 'RMA',
sepa_export => 'sepa_export',
sepa_export_items => 'sepa_export_item',
tax => 'tax',
taxkeys => 'taxkey',
units => 'unit',
);
SL/DB/History.pm
# 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;
SL/DB/Language.pm
# 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;
SL/DB/Licemse.pm
# 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;
SL/DB/MetaSetup/BankAccount.pm
# 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;
;
SL/DB/MetaSetup/Buchungsgruppe.pm
# 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;
;
SL/DB/MetaSetup/Contact.pm
# 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;
;
SL/DB/MetaSetup/CustomVariable.pm
# 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;
;
SL/DB/MetaSetup/CustomVariableConfig.pm
# 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;
;
SL/DB/MetaSetup/CustomVariableValidity.pm
# 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;
;
SL/DB/MetaSetup/DeliveryOrder.pm
allow_inline_column_values => 1,
foreign_keys => [
contact => {
class => 'SL::DB::Contact',
key_columns => { cp_id => 'cp_id' },
},
customer => {
class => 'SL::DB::Customer',
key_columns => { customer_id => 'id' },
},
employee => {
class => 'SL::DB::Employee',
key_columns => { employee_id => 'id' },
},
globalproject => {
class => 'SL::DB::Project',
key_columns => { globalproject_id => 'id' },
},
language => {
class => 'SL::DB::Language',
key_columns => { language_id => 'id' },
},
salesman => {
class => 'SL::DB::Employee',
key_columns => { salesman_id => 'id' },
},
vendor => {
class => 'SL::DB::Vendor',
key_columns => { vendor_id => 'id' },
SL/DB/MetaSetup/Draft.pm
# 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;
;
SL/DB/MetaSetup/Dunning.pm
# 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;
;
SL/DB/MetaSetup/DunningConfig.pm
# 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;
;
SL/DB/MetaSetup/Employee.pm
# 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;
;
SL/DB/MetaSetup/FollowUp.pm
# 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;
;
SL/DB/MetaSetup/FollowUpLink.pm
# 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;
;
SL/DB/MetaSetup/GenericTranslation.pm
# 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;
;
SL/DB/MetaSetup/History.pm
# 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;
;
SL/DB/MetaSetup/Invoice.pm
key_columns => { customer_id => 'id' },
},
dunning_config => {
class => 'SL::DB::DunningConfig',
key_columns => { dunning_config_id => 'id' },
},
globalproject => {
class => 'SL::DB::Project',
key_columns => { globalproject_id => 'id' },
},
salesman => {
class => 'SL::DB::Employee',
key_columns => { salesman_id => 'id' },
},
storno_obj => {
class => 'SL::DB::Invoice',
key_columns => { storno_id => 'id' },
SL/DB/MetaSetup/Language.pm
# 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;
;
SL/DB/MetaSetup/Licemse.pm
# 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;
;
SL/DB/MetaSetup/Note.pm
# 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;
;
SL/DB/MetaSetup/Order.pm
allow_inline_column_values => 1,
foreign_keys => [
employee => {
class => 'SL::DB::Employee',
key_columns => { employee_id => 'id' },
},
globalproject => {
class => 'SL::DB::Project',
key_columns => { globalproject_id => 'id' },
},
project_manager => {
class => 'SL::DB::Employee',
key_columns => { project_manager_id => 'id' },
},
salesman => {
class => 'SL::DB::Employee',
key_columns => { salesman_id => 'id' },
},
],
);
SL/DB/MetaSetup/Part.pm
primary_key_columns => [ 'id' ],
allow_inline_column_values => 1,
foreign_keys => [
buchungsgruppen => {
class => 'SL::DB::Buchungsgruppe',
key_columns => { buchungsgruppen_id => 'id' },
},
],
);
1;
SL/DB/MetaSetup/PaymentTerm.pm
# 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;
;
SL/DB/MetaSetup/Pricegroup.pm
# 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;
;
SL/DB/MetaSetup/RMA.pm
# 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;
;
SL/DB/MetaSetup/SepaExport.pm
# 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;
;
SL/DB/MetaSetup/SepaExportItem.pm
# 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;
;
SL/DB/MetaSetup/Tax.pm
# 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,
... Dieser Diff wurde abgeschnitten, weil er die maximale Anzahl anzuzeigender Zeilen überschreitet.

Auch abrufbar als: Unified diff