Revision 3eb3d1b1
Von Moritz Bunkus vor mehr als 11 Jahren hinzugefügt
| SL/DB/MetaSetup/AccTransaction.pm | ||
|---|---|---|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 | 12 |
acc_trans_id => { type => 'bigint', not_null => 1, sequence => 'acc_trans_id_seq' },
|
| 13 |
trans_id => { type => 'integer', not_null => 1 },
|
|
| 14 |
chart_id => { type => 'integer', not_null => 1 },
|
|
| 15 | 13 |
amount => { type => 'numeric', precision => 5, scale => 15 },
|
| 16 |
transdate => { type => 'date', default => 'now' },
|
|
| 17 |
gldate => { type => 'date', default => 'now' },
|
|
| 18 |
source => { type => 'text' },
|
|
| 14 |
cb_transaction => { type => 'boolean', default => 'false', not_null => 1 },
|
|
| 15 |
chart_id => { type => 'integer', not_null => 1 },
|
|
| 16 |
chart_link => { type => 'text', not_null => 1 },
|
|
| 19 | 17 |
cleared => { type => 'boolean', default => 'false', not_null => 1 },
|
| 20 | 18 |
fx_transaction => { type => 'boolean', default => 'false', not_null => 1 },
|
| 21 |
ob_transaction => { type => 'boolean', default => 'false', not_null => 1 },
|
|
| 22 |
cb_transaction => { type => 'boolean', default => 'false', not_null => 1 },
|
|
| 23 |
project_id => { type => 'integer' },
|
|
| 24 |
memo => { type => 'text' },
|
|
| 25 |
taxkey => { type => 'integer' },
|
|
| 19 |
gldate => { type => 'date', default => 'now' },
|
|
| 26 | 20 |
itime => { type => 'timestamp', default => 'now()' },
|
| 21 |
memo => { type => 'text' },
|
|
| 27 | 22 |
mtime => { type => 'timestamp' },
|
| 23 |
ob_transaction => { type => 'boolean', default => 'false', not_null => 1 },
|
|
| 24 |
project_id => { type => 'integer' },
|
|
| 25 |
source => { type => 'text' },
|
|
| 28 | 26 |
tax_id => { type => 'integer', not_null => 1 },
|
| 29 |
chart_link => { type => 'text', not_null => 1 },
|
|
| 27 |
taxkey => { type => 'integer' },
|
|
| 28 |
trans_id => { type => 'integer', not_null => 1 },
|
|
| 29 |
transdate => { type => 'date', default => 'now' },
|
|
| 30 | 30 |
); |
| 31 | 31 |
|
| 32 | 32 |
__PACKAGE__->meta->primary_key_columns([ 'acc_trans_id' ]); |
| ... | ... | |
| 50 | 50 |
}, |
| 51 | 51 |
); |
| 52 | 52 |
|
| 53 |
# __PACKAGE__->meta->initialize; |
|
| 54 |
|
|
| 55 | 53 |
1; |
| 56 | 54 |
; |
| SL/DB/MetaSetup/Assembly.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('assembly');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer' },
|
|
| 13 |
parts_id => { type => 'integer' },
|
|
| 14 |
qty => { type => 'float', precision => 4 },
|
|
| 12 |
assembly_id => { type => 'serial', not_null => 1 },
|
|
| 15 | 13 |
bom => { type => 'boolean' },
|
| 14 |
id => { type => 'integer' },
|
|
| 16 | 15 |
itime => { type => 'timestamp', default => 'now()' },
|
| 17 | 16 |
mtime => { type => 'timestamp' },
|
| 18 |
assembly_id => { type => 'serial', not_null => 1 },
|
|
| 17 |
parts_id => { type => 'integer' },
|
|
| 18 |
qty => { type => 'float', precision => 4 },
|
|
| 19 | 19 |
); |
| 20 | 20 |
|
| 21 | 21 |
__PACKAGE__->meta->primary_key_columns([ 'assembly_id' ]); |
| 22 | 22 |
|
| 23 | 23 |
__PACKAGE__->meta->allow_inline_column_values(1); |
| 24 | 24 |
|
| 25 |
# __PACKAGE__->meta->initialize; |
|
| 26 |
|
|
| 27 | 25 |
1; |
| 28 | 26 |
; |
| SL/DB/MetaSetup/AuditTrail.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('audittrail');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
trans_id => { type => 'integer' },
|
|
| 13 |
tablename => { type => 'text' },
|
|
| 14 |
reference => { type => 'text' },
|
|
| 15 |
formname => { type => 'text' },
|
|
| 16 | 12 |
action => { type => 'text' },
|
| 17 |
transdate => { type => 'timestamp', default => 'now' },
|
|
| 18 | 13 |
employee_id => { type => 'integer' },
|
| 14 |
formname => { type => 'text' },
|
|
| 19 | 15 |
id => { type => 'serial', not_null => 1 },
|
| 16 |
reference => { type => 'text' },
|
|
| 17 |
tablename => { type => 'text' },
|
|
| 18 |
trans_id => { type => 'integer' },
|
|
| 19 |
transdate => { type => 'timestamp', default => 'now' },
|
|
| 20 | 20 |
); |
| 21 | 21 |
|
| 22 | 22 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| 23 | 23 |
|
| 24 |
# __PACKAGE__->meta->initialize; |
|
| 25 |
|
|
| 26 | 24 |
1; |
| 27 | 25 |
; |
| SL/DB/MetaSetup/BackgroundJob.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('background_jobs');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
active => { type => 'boolean' },
|
|
| 13 |
cron_spec => { type => 'varchar', length => 255 },
|
|
| 14 |
data => { type => 'text' },
|
|
| 12 | 15 |
id => { type => 'serial', not_null => 1 },
|
| 13 |
type => { type => 'varchar', length => 255 },
|
|
| 14 |
package_name => { type => 'varchar', length => 255 },
|
|
| 15 | 16 |
last_run_at => { type => 'timestamp' },
|
| 16 | 17 |
next_run_at => { type => 'timestamp' },
|
| 17 |
data => { type => 'text' },
|
|
| 18 |
active => { type => 'boolean' },
|
|
| 19 |
cron_spec => { type => 'varchar', length => 255 },
|
|
| 18 |
package_name => { type => 'varchar', length => 255 },
|
|
| 19 |
type => { type => 'varchar', length => 255 },
|
|
| 20 | 20 |
); |
| 21 | 21 |
|
| 22 | 22 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| 23 | 23 |
|
| 24 |
# __PACKAGE__->meta->initialize; |
|
| 25 |
|
|
| 26 | 24 |
1; |
| 27 | 25 |
; |
| SL/DB/MetaSetup/BackgroundJobHistory.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('background_job_histories');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
data => { type => 'text' },
|
|
| 13 |
error => { type => 'text', alias => 'error_col' },
|
|
| 12 | 14 |
id => { type => 'serial', not_null => 1 },
|
| 13 | 15 |
package_name => { type => 'varchar', length => 255 },
|
| 16 |
result => { type => 'text' },
|
|
| 14 | 17 |
run_at => { type => 'timestamp' },
|
| 15 | 18 |
status => { type => 'varchar', length => 255 },
|
| 16 |
result => { type => 'text' },
|
|
| 17 |
error => { type => 'text', alias => 'error_col' },
|
|
| 18 |
data => { type => 'text' },
|
|
| 19 | 19 |
); |
| 20 | 20 |
|
| 21 | 21 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| 22 | 22 |
|
| 23 |
# __PACKAGE__->meta->initialize; |
|
| 24 |
|
|
| 25 | 23 |
1; |
| 26 | 24 |
; |
| SL/DB/MetaSetup/BankAccount.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('bank_accounts');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 13 | 12 |
account_number => { type => 'varchar', length => 100 },
|
| 13 |
bank => { type => 'text' },
|
|
| 14 | 14 |
bank_code => { type => 'varchar', length => 100 },
|
| 15 |
iban => { type => 'varchar', length => 100 },
|
|
| 16 | 15 |
bic => { type => 'varchar', length => 100 },
|
| 17 |
bank => { type => 'text' },
|
|
| 18 | 16 |
chart_id => { type => 'integer', not_null => 1 },
|
| 17 |
iban => { type => 'varchar', length => 100 },
|
|
| 18 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 19 | 19 |
); |
| 20 | 20 |
|
| 21 | 21 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 27 | 27 |
}, |
| 28 | 28 |
); |
| 29 | 29 |
|
| 30 |
# __PACKAGE__->meta->initialize; |
|
| 31 |
|
|
| 32 | 30 |
1; |
| 33 | 31 |
; |
| SL/DB/MetaSetup/Bin.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('bin');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 13 |
warehouse_id => { type => 'integer', not_null => 1 },
|
|
| 14 | 12 |
description => { type => 'text' },
|
| 13 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 15 | 14 |
itime => { type => 'timestamp', default => 'now()' },
|
| 16 | 15 |
mtime => { type => 'timestamp' },
|
| 16 |
warehouse_id => { type => 'integer', not_null => 1 },
|
|
| 17 | 17 |
); |
| 18 | 18 |
|
| 19 | 19 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 27 | 27 |
}, |
| 28 | 28 |
); |
| 29 | 29 |
|
| 30 |
# __PACKAGE__->meta->initialize; |
|
| 31 |
|
|
| 32 | 30 |
1; |
| 33 | 31 |
; |
| SL/DB/MetaSetup/Buchungsgruppe.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('buchungsgruppen');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 13 | 12 |
description => { type => 'text' },
|
| 14 |
inventory_accno_id => { type => 'integer' },
|
|
| 15 |
income_accno_id_0 => { type => 'integer' },
|
|
| 16 | 13 |
expense_accno_id_0 => { type => 'integer' },
|
| 17 |
income_accno_id_1 => { type => 'integer' },
|
|
| 18 | 14 |
expense_accno_id_1 => { type => 'integer' },
|
| 19 |
income_accno_id_2 => { type => 'integer' },
|
|
| 20 | 15 |
expense_accno_id_2 => { type => 'integer' },
|
| 21 |
income_accno_id_3 => { type => 'integer' },
|
|
| 22 | 16 |
expense_accno_id_3 => { type => 'integer' },
|
| 17 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 18 |
income_accno_id_0 => { type => 'integer' },
|
|
| 19 |
income_accno_id_1 => { type => 'integer' },
|
|
| 20 |
income_accno_id_2 => { type => 'integer' },
|
|
| 21 |
income_accno_id_3 => { type => 'integer' },
|
|
| 22 |
inventory_accno_id => { type => 'integer' },
|
|
| 23 | 23 |
sortkey => { type => 'integer', not_null => 1 },
|
| 24 | 24 |
); |
| 25 | 25 |
|
| 26 | 26 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| 27 | 27 |
|
| 28 |
# __PACKAGE__->meta->initialize; |
|
| 29 |
|
|
| 30 | 28 |
1; |
| 31 | 29 |
; |
| SL/DB/MetaSetup/Business.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('business');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 12 |
customernumberinit => { type => 'text' },
|
|
| 13 | 13 |
description => { type => 'text' },
|
| 14 | 14 |
discount => { type => 'float', precision => 4 },
|
| 15 |
customernumberinit => { type => 'text' },
|
|
| 16 |
salesman => { type => 'boolean', default => 'false' },
|
|
| 15 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 17 | 16 |
itime => { type => 'timestamp', default => 'now()' },
|
| 18 | 17 |
mtime => { type => 'timestamp' },
|
| 18 |
salesman => { type => 'boolean', default => 'false' },
|
|
| 19 | 19 |
); |
| 20 | 20 |
|
| 21 | 21 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| 22 | 22 |
|
| 23 | 23 |
__PACKAGE__->meta->allow_inline_column_values(1); |
| 24 | 24 |
|
| 25 |
# __PACKAGE__->meta->initialize; |
|
| 26 |
|
|
| 27 | 25 |
1; |
| 28 | 26 |
; |
| SL/DB/MetaSetup/Chart.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('chart');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 13 | 12 |
accno => { type => 'text', not_null => 1 },
|
| 14 |
description => { type => 'text' },
|
|
| 15 |
charttype => { type => 'character', default => 'A', length => 1 },
|
|
| 16 | 13 |
category => { type => 'character', length => 1 },
|
| 17 |
link => { type => 'text', not_null => 1 },
|
|
| 18 |
taxkey_id => { type => 'integer' },
|
|
| 19 |
pos_bwa => { type => 'integer' },
|
|
| 20 |
pos_bilanz => { type => 'integer' },
|
|
| 21 |
pos_eur => { type => 'integer' },
|
|
| 14 |
charttype => { type => 'character', default => 'A', length => 1 },
|
|
| 22 | 15 |
datevautomatik => { type => 'boolean', default => 'false' },
|
| 16 |
description => { type => 'text' },
|
|
| 17 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 23 | 18 |
itime => { type => 'timestamp', default => 'now()' },
|
| 19 |
link => { type => 'text', not_null => 1 },
|
|
| 24 | 20 |
mtime => { type => 'timestamp' },
|
| 25 | 21 |
new_chart_id => { type => 'integer' },
|
| 22 |
pos_bilanz => { type => 'integer' },
|
|
| 23 |
pos_bwa => { type => 'integer' },
|
|
| 24 |
pos_eur => { type => 'integer' },
|
|
| 25 |
taxkey_id => { type => 'integer' },
|
|
| 26 | 26 |
valid_from => { type => 'date' },
|
| 27 | 27 |
); |
| 28 | 28 |
|
| ... | ... | |
| 32 | 32 |
|
| 33 | 33 |
__PACKAGE__->meta->allow_inline_column_values(1); |
| 34 | 34 |
|
| 35 |
# __PACKAGE__->meta->initialize; |
|
| 36 |
|
|
| 37 | 35 |
1; |
| 38 | 36 |
; |
| SL/DB/MetaSetup/Contact.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('contacts');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
cp_id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 12 |
cp_abteilung => { type => 'text' },
|
|
| 13 |
cp_birthday => { type => 'date' },
|
|
| 14 |
cp_city => { type => 'text' },
|
|
| 13 | 15 |
cp_cv_id => { type => 'integer' },
|
| 14 |
cp_title => { type => 'varchar', length => 75 },
|
|
| 15 |
cp_givenname => { type => 'varchar', length => 75 },
|
|
| 16 |
cp_name => { type => 'varchar', length => 75 },
|
|
| 17 | 16 |
cp_email => { type => 'text' },
|
| 18 |
cp_phone1 => { type => 'varchar', length => 75 },
|
|
| 19 |
cp_phone2 => { type => 'varchar', length => 75 },
|
|
| 20 |
itime => { type => 'timestamp', default => 'now()' },
|
|
| 21 |
mtime => { type => 'timestamp' },
|
|
| 22 | 17 |
cp_fax => { type => 'text' },
|
| 18 |
cp_gender => { type => 'character', length => 1 },
|
|
| 19 |
cp_givenname => { type => 'varchar', length => 75 },
|
|
| 20 |
cp_id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 23 | 21 |
cp_mobile1 => { type => 'text' },
|
| 24 | 22 |
cp_mobile2 => { type => 'text' },
|
| 25 |
cp_satphone => { type => 'text' },
|
|
| 26 |
cp_satfax => { type => 'text' },
|
|
| 27 |
cp_project => { type => 'text' },
|
|
| 28 |
cp_privatphone => { type => 'text' },
|
|
| 23 |
cp_name => { type => 'varchar', length => 75 },
|
|
| 24 |
cp_phone1 => { type => 'varchar', length => 75 },
|
|
| 25 |
cp_phone2 => { type => 'varchar', length => 75 },
|
|
| 26 |
cp_position => { type => 'varchar', length => 75 },
|
|
| 29 | 27 |
cp_privatemail => { type => 'text' },
|
| 30 |
cp_abteilung => { type => 'text' },
|
|
| 31 |
cp_gender => { type => 'character', length => 1 },
|
|
| 28 |
cp_privatphone => { type => 'text' },
|
|
| 29 |
cp_project => { type => 'text' },
|
|
| 30 |
cp_satfax => { type => 'text' },
|
|
| 31 |
cp_satphone => { type => 'text' },
|
|
| 32 | 32 |
cp_street => { type => 'text' },
|
| 33 |
cp_title => { type => 'varchar', length => 75 },
|
|
| 33 | 34 |
cp_zipcode => { type => 'text' },
|
| 34 |
cp_city => { type => 'text' },
|
|
| 35 |
cp_birthday => { type => 'date' },
|
|
| 36 |
cp_position => { type => 'varchar', length => 75 },
|
|
| 35 |
itime => { type => 'timestamp', default => 'now()' },
|
|
| 36 |
mtime => { type => 'timestamp' },
|
|
| 37 | 37 |
); |
| 38 | 38 |
|
| 39 | 39 |
__PACKAGE__->meta->primary_key_columns([ 'cp_id' ]); |
| 40 | 40 |
|
| 41 | 41 |
__PACKAGE__->meta->allow_inline_column_values(1); |
| 42 | 42 |
|
| 43 |
# __PACKAGE__->meta->initialize; |
|
| 44 |
|
|
| 45 | 43 |
1; |
| 46 | 44 |
; |
| SL/DB/MetaSetup/CsvImportProfile.pm | ||
|---|---|---|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 | 12 |
id => { type => 'serial', not_null => 1 },
|
| 13 |
name => { type => 'text', not_null => 1 },
|
|
| 14 |
type => { type => 'varchar', length => 20, not_null => 1 },
|
|
| 15 | 13 |
is_default => { type => 'boolean', default => 'false' },
|
| 16 | 14 |
login => { type => 'text' },
|
| 15 |
name => { type => 'text', not_null => 1 },
|
|
| 16 |
type => { type => 'varchar', length => 20, not_null => 1 },
|
|
| 17 | 17 |
); |
| 18 | 18 |
|
| 19 | 19 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| 20 | 20 |
|
| 21 |
# __PACKAGE__->meta->initialize; |
|
| 22 |
|
|
| 23 | 21 |
1; |
| 24 | 22 |
; |
| SL/DB/MetaSetup/CsvImportProfileSetting.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('csv_import_profile_settings');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'serial', not_null => 1 },
|
|
| 13 | 12 |
csv_import_profile_id => { type => 'integer', not_null => 1 },
|
| 13 |
id => { type => 'serial', not_null => 1 },
|
|
| 14 | 14 |
key => { type => 'text', not_null => 1 },
|
| 15 | 15 |
value => { type => 'text' },
|
| 16 | 16 |
); |
| ... | ... | |
| 26 | 26 |
}, |
| 27 | 27 |
); |
| 28 | 28 |
|
| 29 |
# __PACKAGE__->meta->initialize; |
|
| 30 |
|
|
| 31 | 29 |
1; |
| 32 | 30 |
; |
| SL/DB/MetaSetup/CsvImportReport.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('csv_import_reports');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
file => { type => 'text', not_null => 1 },
|
|
| 12 | 13 |
id => { type => 'serial', not_null => 1 },
|
| 13 |
session_id => { type => 'text', not_null => 1 },
|
|
| 14 |
numrows => { type => 'integer', not_null => 1 },
|
|
| 14 | 15 |
profile_id => { type => 'integer', not_null => 1 },
|
| 16 |
session_id => { type => 'text', not_null => 1 },
|
|
| 15 | 17 |
type => { type => 'text', not_null => 1 },
|
| 16 |
file => { type => 'text', not_null => 1 },
|
|
| 17 |
numrows => { type => 'integer', not_null => 1 },
|
|
| 18 | 18 |
); |
| 19 | 19 |
|
| 20 | 20 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 26 | 26 |
}, |
| 27 | 27 |
); |
| 28 | 28 |
|
| 29 |
# __PACKAGE__->meta->initialize; |
|
| 30 |
|
|
| 31 | 29 |
1; |
| 32 | 30 |
; |
| SL/DB/MetaSetup/CsvImportReportRow.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('csv_import_report_rows');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'serial', not_null => 1 },
|
|
| 13 |
csv_import_report_id => { type => 'integer', not_null => 1 },
|
|
| 14 | 12 |
col => { type => 'integer', not_null => 1 },
|
| 13 |
csv_import_report_id => { type => 'integer', not_null => 1 },
|
|
| 14 |
id => { type => 'serial', not_null => 1 },
|
|
| 15 | 15 |
row => { type => 'integer', not_null => 1 },
|
| 16 | 16 |
value => { type => 'text' },
|
| 17 | 17 |
); |
| ... | ... | |
| 25 | 25 |
}, |
| 26 | 26 |
); |
| 27 | 27 |
|
| 28 |
# __PACKAGE__->meta->initialize; |
|
| 29 |
|
|
| 30 | 28 |
1; |
| 31 | 29 |
; |
| SL/DB/MetaSetup/CsvImportReportStatus.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('csv_import_report_status');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'serial', not_null => 1 },
|
|
| 13 | 12 |
csv_import_report_id => { type => 'integer', not_null => 1 },
|
| 13 |
id => { type => 'serial', not_null => 1 },
|
|
| 14 | 14 |
row => { type => 'integer', not_null => 1 },
|
| 15 | 15 |
type => { type => 'text', not_null => 1 },
|
| 16 | 16 |
value => { type => 'text' },
|
| ... | ... | |
| 25 | 25 |
}, |
| 26 | 26 |
); |
| 27 | 27 |
|
| 28 |
# __PACKAGE__->meta->initialize; |
|
| 29 |
|
|
| 30 | 28 |
1; |
| 31 | 29 |
; |
| SL/DB/MetaSetup/Currency.pm | ||
|---|---|---|
| 17 | 17 |
|
| 18 | 18 |
__PACKAGE__->meta->unique_keys([ 'name' ]); |
| 19 | 19 |
|
| 20 |
# __PACKAGE__->meta->initialize; |
|
| 21 |
|
|
| 22 | 20 |
1; |
| 23 | 21 |
; |
| SL/DB/MetaSetup/CustomVariable.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('custom_variables');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'custom_variables_id' },
|
|
| 13 |
config_id => { type => 'integer', not_null => 1 },
|
|
| 14 |
trans_id => { type => 'integer', not_null => 1 },
|
|
| 15 | 12 |
bool_value => { type => 'boolean' },
|
| 16 |
timestamp_value => { type => 'timestamp' },
|
|
| 17 |
text_value => { type => 'text' },
|
|
| 18 |
number_value => { type => 'numeric', precision => 5, scale => 25 },
|
|
| 13 |
config_id => { type => 'integer', not_null => 1 },
|
|
| 14 |
id => { type => 'integer', not_null => 1, sequence => 'custom_variables_id' },
|
|
| 19 | 15 |
itime => { type => 'timestamp', default => 'now()' },
|
| 20 | 16 |
mtime => { type => 'timestamp' },
|
| 17 |
number_value => { type => 'numeric', precision => 5, scale => 25 },
|
|
| 21 | 18 |
sub_module => { type => 'text', default => '', not_null => 1 },
|
| 19 |
text_value => { type => 'text' },
|
|
| 20 |
timestamp_value => { type => 'timestamp' },
|
|
| 21 |
trans_id => { type => 'integer', not_null => 1 },
|
|
| 22 | 22 |
); |
| 23 | 23 |
|
| 24 | 24 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 32 | 32 |
}, |
| 33 | 33 |
); |
| 34 | 34 |
|
| 35 |
# __PACKAGE__->meta->initialize; |
|
| 36 |
|
|
| 37 | 35 |
1; |
| 38 | 36 |
; |
| SL/DB/MetaSetup/CustomVariableConfig.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('custom_variable_configs');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'custom_variable_configs_id' },
|
|
| 13 |
name => { type => 'text', not_null => 1 },
|
|
| 14 |
description => { type => 'text', not_null => 1 },
|
|
| 15 |
type => { type => 'text', not_null => 1 },
|
|
| 16 |
module => { type => 'text', not_null => 1 },
|
|
| 17 | 12 |
default_value => { type => 'text' },
|
| 18 |
options => { type => 'text' },
|
|
| 19 |
searchable => { type => 'boolean', not_null => 1 },
|
|
| 13 |
description => { type => 'text', not_null => 1 },
|
|
| 14 |
flags => { type => 'text' },
|
|
| 15 |
id => { type => 'integer', not_null => 1, sequence => 'custom_variable_configs_id' },
|
|
| 20 | 16 |
includeable => { type => 'boolean', not_null => 1 },
|
| 21 | 17 |
included_by_default => { type => 'boolean', not_null => 1 },
|
| 22 |
sortkey => { type => 'integer', not_null => 1 },
|
|
| 23 | 18 |
itime => { type => 'timestamp', default => 'now()' },
|
| 19 |
module => { type => 'text', not_null => 1 },
|
|
| 24 | 20 |
mtime => { type => 'timestamp' },
|
| 25 |
flags => { type => 'text' },
|
|
| 21 |
name => { type => 'text', not_null => 1 },
|
|
| 22 |
options => { type => 'text' },
|
|
| 23 |
searchable => { type => 'boolean', not_null => 1 },
|
|
| 24 |
sortkey => { type => 'integer', not_null => 1 },
|
|
| 25 |
type => { type => 'text', not_null => 1 },
|
|
| 26 | 26 |
); |
| 27 | 27 |
|
| 28 | 28 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| 29 | 29 |
|
| 30 | 30 |
__PACKAGE__->meta->allow_inline_column_values(1); |
| 31 | 31 |
|
| 32 |
# __PACKAGE__->meta->initialize; |
|
| 33 |
|
|
| 34 | 32 |
1; |
| 35 | 33 |
; |
| SL/DB/MetaSetup/CustomVariableValidity.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('custom_variables_validity');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 13 | 12 |
config_id => { type => 'integer', not_null => 1 },
|
| 14 |
trans_id => { type => 'integer', not_null => 1 },
|
|
| 13 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 15 | 14 |
itime => { type => 'timestamp', default => 'now()' },
|
| 15 |
trans_id => { type => 'integer', not_null => 1 },
|
|
| 16 | 16 |
); |
| 17 | 17 |
|
| 18 | 18 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 26 | 26 |
}, |
| 27 | 27 |
); |
| 28 | 28 |
|
| 29 |
# __PACKAGE__->meta->initialize; |
|
| 30 |
|
|
| 31 | 29 |
1; |
| 32 | 30 |
; |
| SL/DB/MetaSetup/Customer.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('customer');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 13 |
name => { type => 'text', not_null => 1 },
|
|
| 14 |
department_1 => { type => 'varchar', length => 75 },
|
|
| 15 |
department_2 => { type => 'varchar', length => 75 },
|
|
| 16 |
street => { type => 'varchar', length => 75 },
|
|
| 17 |
zipcode => { type => 'varchar', length => 10 },
|
|
| 12 |
account_number => { type => 'text' },
|
|
| 13 |
bank => { type => 'text' },
|
|
| 14 |
bank_code => { type => 'text' },
|
|
| 15 |
bcc => { type => 'text' },
|
|
| 16 |
bic => { type => 'varchar', length => 100 },
|
|
| 17 |
business_id => { type => 'integer' },
|
|
| 18 |
c_vendor_id => { type => 'text' },
|
|
| 19 |
cc => { type => 'text' },
|
|
| 18 | 20 |
city => { type => 'varchar', length => 75 },
|
| 19 |
country => { type => 'varchar', length => 75 },
|
|
| 20 | 21 |
contact => { type => 'text' },
|
| 21 |
phone => { type => 'text' },
|
|
| 22 |
fax => { type => 'varchar', length => 30 },
|
|
| 23 |
homepage => { type => 'text' },
|
|
| 24 |
email => { type => 'text' },
|
|
| 25 |
notes => { type => 'text' },
|
|
| 26 |
discount => { type => 'float', precision => 4 },
|
|
| 27 |
taxincluded => { type => 'boolean' },
|
|
| 22 |
country => { type => 'varchar', length => 75 },
|
|
| 28 | 23 |
creditlimit => { type => 'numeric', default => '0', precision => 5, scale => 15 },
|
| 29 |
terms => { type => 'integer', default => '0' },
|
|
| 24 |
currency_id => { type => 'integer', not_null => 1 },
|
|
| 30 | 25 |
customernumber => { type => 'text' },
|
| 31 |
cc => { type => 'text' },
|
|
| 32 |
bcc => { type => 'text' },
|
|
| 33 |
business_id => { type => 'integer' },
|
|
| 34 |
taxnumber => { type => 'text' },
|
|
| 35 |
account_number => { type => 'text' },
|
|
| 36 |
bank_code => { type => 'text' },
|
|
| 37 |
bank => { type => 'text' },
|
|
| 38 |
language => { type => 'varchar', length => 5 },
|
|
| 26 |
department_1 => { type => 'varchar', length => 75 },
|
|
| 27 |
department_2 => { type => 'varchar', length => 75 },
|
|
| 28 |
direct_debit => { type => 'boolean', default => 'false' },
|
|
| 29 |
discount => { type => 'float', precision => 4 },
|
|
| 30 |
email => { type => 'text' },
|
|
| 31 |
fax => { type => 'varchar', length => 30 },
|
|
| 32 |
greeting => { type => 'text' },
|
|
| 33 |
homepage => { type => 'text' },
|
|
| 34 |
iban => { type => 'varchar', length => 100 },
|
|
| 35 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 39 | 36 |
itime => { type => 'timestamp', default => 'now()' },
|
| 40 |
mtime => { type => 'timestamp' },
|
|
| 41 |
obsolete => { type => 'boolean', default => 'false' },
|
|
| 42 |
username => { type => 'varchar', length => 50 },
|
|
| 43 |
user_password => { type => 'text' },
|
|
| 44 |
salesman_id => { type => 'integer' },
|
|
| 45 |
c_vendor_id => { type => 'text' },
|
|
| 46 | 37 |
klass => { type => 'integer', default => '0' },
|
| 38 |
language => { type => 'varchar', length => 5 },
|
|
| 47 | 39 |
language_id => { type => 'integer' },
|
| 40 |
mtime => { type => 'timestamp' },
|
|
| 41 |
name => { type => 'text', not_null => 1 },
|
|
| 42 |
notes => { type => 'text' },
|
|
| 43 |
obsolete => { type => 'boolean', default => 'false' },
|
|
| 48 | 44 |
payment_id => { type => 'integer' },
|
| 45 |
phone => { type => 'text' },
|
|
| 46 |
salesman_id => { type => 'integer' },
|
|
| 47 |
street => { type => 'varchar', length => 75 },
|
|
| 48 |
taxincluded => { type => 'boolean' },
|
|
| 49 |
taxincluded_checked => { type => 'boolean' },
|
|
| 50 |
taxnumber => { type => 'text' },
|
|
| 49 | 51 |
taxzone_id => { type => 'integer', default => '0', not_null => 1 },
|
| 50 |
greeting => { type => 'text' },
|
|
| 52 |
terms => { type => 'integer', default => '0' },
|
|
| 53 |
user_password => { type => 'text' },
|
|
| 54 |
username => { type => 'varchar', length => 50 },
|
|
| 51 | 55 |
ustid => { type => 'text' },
|
| 52 |
direct_debit => { type => 'boolean', default => 'false' },
|
|
| 53 |
iban => { type => 'varchar', length => 100 },
|
|
| 54 |
bic => { type => 'varchar', length => 100 },
|
|
| 55 |
taxincluded_checked => { type => 'boolean' },
|
|
| 56 |
currency_id => { type => 'integer', not_null => 1 },
|
|
| 56 |
zipcode => { type => 'varchar', length => 10 },
|
|
| 57 | 57 |
); |
| 58 | 58 |
|
| 59 | 59 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 82 | 82 |
}, |
| 83 | 83 |
); |
| 84 | 84 |
|
| 85 |
# __PACKAGE__->meta->initialize; |
|
| 86 |
|
|
| 87 | 85 |
1; |
| 88 | 86 |
; |
| SL/DB/MetaSetup/Datev.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('datev');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
beraternr => { type => 'varchar', length => 7 },
|
|
| 12 |
abrechnungsnr => { type => 'varchar', length => 6 },
|
|
| 13 | 13 |
beratername => { type => 'varchar', length => 9 },
|
| 14 |
mandantennr => { type => 'varchar', length => 5 },
|
|
| 15 |
dfvkz => { type => 'varchar', length => 2 },
|
|
| 14 |
beraternr => { type => 'varchar', length => 7 },
|
|
| 16 | 15 |
datentraegernr => { type => 'varchar', length => 3 },
|
| 17 |
abrechnungsnr => { type => 'varchar', length => 6 },
|
|
| 16 |
dfvkz => { type => 'varchar', length => 2 },
|
|
| 17 |
id => { type => 'serial', not_null => 1 },
|
|
| 18 | 18 |
itime => { type => 'timestamp', default => 'now()' },
|
| 19 |
mandantennr => { type => 'varchar', length => 5 },
|
|
| 19 | 20 |
mtime => { type => 'timestamp' },
|
| 20 |
id => { type => 'serial', not_null => 1 },
|
|
| 21 | 21 |
); |
| 22 | 22 |
|
| 23 | 23 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| 24 | 24 |
|
| 25 | 25 |
__PACKAGE__->meta->allow_inline_column_values(1); |
| 26 | 26 |
|
| 27 |
# __PACKAGE__->meta->initialize; |
|
| 28 |
|
|
| 29 | 27 |
1; |
| 30 | 28 |
; |
| SL/DB/MetaSetup/Default.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('defaults');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
inventory_accno_id => { type => 'integer' },
|
|
| 13 |
income_accno_id => { type => 'integer' },
|
|
| 14 |
expense_accno_id => { type => 'integer' },
|
|
| 15 |
fxgain_accno_id => { type => 'integer' },
|
|
| 16 |
fxloss_accno_id => { type => 'integer' },
|
|
| 17 |
invnumber => { type => 'text' },
|
|
| 18 |
sonumber => { type => 'text' },
|
|
| 19 |
weightunit => { type => 'varchar', length => 5 },
|
|
| 12 |
accounting_method => { type => 'text' },
|
|
| 13 |
address => { type => 'text' },
|
|
| 14 |
ap_changeable => { type => 'integer', default => 2, not_null => 1 },
|
|
| 15 |
ap_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 16 |
ar_changeable => { type => 'integer', default => 2, not_null => 1 },
|
|
| 17 |
ar_paid_accno_id => { type => 'integer' },
|
|
| 18 |
ar_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 19 |
articlenumber => { type => 'text' },
|
|
| 20 |
assemblynumber => { type => 'text' },
|
|
| 21 |
audittrail => { type => 'boolean', default => 'false' },
|
|
| 22 |
bin_id => { type => 'integer' },
|
|
| 23 |
bin_id_ignore_onhand => { type => 'integer' },
|
|
| 20 | 24 |
businessnumber => { type => 'text' },
|
| 21 |
version => { type => 'varchar', length => 8 },
|
|
| 22 | 25 |
closedto => { type => 'date' },
|
| 23 |
revtrans => { type => 'boolean', default => 'false' },
|
|
| 24 |
ponumber => { type => 'text' },
|
|
| 25 |
sqnumber => { type => 'text' },
|
|
| 26 |
rfqnumber => { type => 'text' },
|
|
| 27 |
customernumber => { type => 'text' },
|
|
| 28 |
vendornumber => { type => 'text' },
|
|
| 29 |
audittrail => { type => 'boolean', default => 'false' },
|
|
| 30 |
articlenumber => { type => 'text' },
|
|
| 31 |
servicenumber => { type => 'text' },
|
|
| 32 |
coa => { type => 'text' },
|
|
| 33 |
itime => { type => 'timestamp', default => 'now()' },
|
|
| 34 |
mtime => { type => 'timestamp' },
|
|
| 35 |
rmanumber => { type => 'text' },
|
|
| 36 | 26 |
cnnumber => { type => 'text' },
|
| 37 |
accounting_method => { type => 'text' },
|
|
| 38 |
inventory_system => { type => 'text' },
|
|
| 39 |
profit_determination => { type => 'text' },
|
|
| 27 |
co_ustid => { type => 'text' },
|
|
| 28 |
coa => { type => 'text' },
|
|
| 29 |
company => { type => 'text' },
|
|
| 30 |
currency_id => { type => 'integer', not_null => 1 },
|
|
| 31 |
customernumber => { type => 'text' },
|
|
| 32 |
datev_check_on_ap_transaction => { type => 'boolean', default => 'true' },
|
|
| 33 |
datev_check_on_ar_transaction => { type => 'boolean', default => 'true' },
|
|
| 34 |
datev_check_on_gl_transaction => { type => 'boolean', default => 'true' },
|
|
| 35 |
datev_check_on_purchase_invoice => { type => 'boolean', default => 'true' },
|
|
| 36 |
datev_check_on_sales_invoice => { type => 'boolean', default => 'true' },
|
|
| 37 |
dunning_ar => { type => 'integer' },
|
|
| 40 | 38 |
dunning_ar_amount_fee => { type => 'integer' },
|
| 41 | 39 |
dunning_ar_amount_interest => { type => 'integer' },
|
| 42 |
dunning_ar => { type => 'integer' },
|
|
| 43 |
pdonumber => { type => 'text' },
|
|
| 44 |
sdonumber => { type => 'text' },
|
|
| 45 |
ar_paid_accno_id => { type => 'integer' },
|
|
| 40 |
duns => { type => 'text' },
|
|
| 41 |
expense_accno_id => { type => 'integer' },
|
|
| 42 |
fxgain_accno_id => { type => 'integer' },
|
|
| 43 |
fxloss_accno_id => { type => 'integer' },
|
|
| 44 |
gl_changeable => { type => 'integer', default => 2, not_null => 1 },
|
|
| 46 | 45 |
id => { type => 'serial', not_null => 1 },
|
| 46 |
income_accno_id => { type => 'integer' },
|
|
| 47 |
inventory_accno_id => { type => 'integer' },
|
|
| 48 |
inventory_system => { type => 'text' },
|
|
| 49 |
invnumber => { type => 'text' },
|
|
| 50 |
ir_changeable => { type => 'integer', default => 2, not_null => 1 },
|
|
| 51 |
ir_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 52 |
is_changeable => { type => 'integer', default => 2, not_null => 1 },
|
|
| 53 |
is_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 54 |
itime => { type => 'timestamp', default => 'now()' },
|
|
| 47 | 55 |
language_id => { type => 'integer' },
|
| 48 |
datev_check_on_sales_invoice => { type => 'boolean', default => 'true' },
|
|
| 49 |
datev_check_on_purchase_invoice => { type => 'boolean', default => 'true' },
|
|
| 50 |
datev_check_on_ar_transaction => { type => 'boolean', default => 'true' },
|
|
| 51 |
datev_check_on_ap_transaction => { type => 'boolean', default => 'true' },
|
|
| 52 |
datev_check_on_gl_transaction => { type => 'boolean', default => 'true' },
|
|
| 56 |
max_future_booking_interval => { type => 'integer', default => 360 },
|
|
| 57 |
mtime => { type => 'timestamp' },
|
|
| 58 |
parts_image_css => { type => 'text', default => 'border:0;float:left;max-width:250px;margin-top:20px:margin-right:10px;margin-left:10px;' },
|
|
| 59 |
parts_listing_image => { type => 'boolean', default => 'true' },
|
|
| 60 |
parts_show_image => { type => 'boolean', default => 'true' },
|
|
| 53 | 61 |
payments_changeable => { type => 'integer', default => '0', not_null => 1 },
|
| 54 |
is_changeable => { type => 'integer', default => 2, not_null => 1 },
|
|
| 55 |
ir_changeable => { type => 'integer', default => 2, not_null => 1 },
|
|
| 56 |
ar_changeable => { type => 'integer', default => 2, not_null => 1 },
|
|
| 57 |
ap_changeable => { type => 'integer', default => 2, not_null => 1 },
|
|
| 58 |
gl_changeable => { type => 'integer', default => 2, not_null => 1 },
|
|
| 59 |
show_bestbefore => { type => 'boolean', default => 'false' },
|
|
| 60 |
sales_order_show_delete => { type => 'boolean', default => 'true' },
|
|
| 62 |
pdonumber => { type => 'text' },
|
|
| 63 |
ponumber => { type => 'text' },
|
|
| 64 |
profit_determination => { type => 'text' },
|
|
| 65 |
purchase_delivery_order_show_delete => { type => 'boolean', default => 'true' },
|
|
| 61 | 66 |
purchase_order_show_delete => { type => 'boolean', default => 'true' },
|
| 67 |
revtrans => { type => 'boolean', default => 'false' },
|
|
| 68 |
rfqnumber => { type => 'text' },
|
|
| 69 |
rmanumber => { type => 'text' },
|
|
| 62 | 70 |
sales_delivery_order_show_delete => { type => 'boolean', default => 'true' },
|
| 63 |
purchase_delivery_order_show_delete => { type => 'boolean', default => 'true' },
|
|
| 64 |
is_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 65 |
ir_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 66 |
ar_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 67 |
ap_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 68 |
warehouse_id => { type => 'integer' },
|
|
| 69 |
bin_id => { type => 'integer' },
|
|
| 70 |
max_future_booking_interval => { type => 'integer', default => 360 },
|
|
| 71 |
assemblynumber => { type => 'text' },
|
|
| 71 |
sales_order_show_delete => { type => 'boolean', default => 'true' },
|
|
| 72 |
sdonumber => { type => 'text' },
|
|
| 73 |
sepa_creditor_id => { type => 'text' },
|
|
| 74 |
servicenumber => { type => 'text' },
|
|
| 75 |
show_bestbefore => { type => 'boolean', default => 'false' },
|
|
| 72 | 76 |
show_weight => { type => 'boolean', default => 'false', not_null => 1 },
|
| 77 |
sonumber => { type => 'text' },
|
|
| 78 |
sqnumber => { type => 'text' },
|
|
| 79 |
taxnumber => { type => 'text' },
|
|
| 80 |
templates => { type => 'text' },
|
|
| 73 | 81 |
transfer_default => { type => 'boolean', default => 'true' },
|
| 74 |
transfer_default_use_master_default_bin => { type => 'boolean', default => 'false' },
|
|
| 75 | 82 |
transfer_default_ignore_onhand => { type => 'boolean', default => 'false' },
|
| 83 |
transfer_default_use_master_default_bin => { type => 'boolean', default => 'false' },
|
|
| 84 |
vendornumber => { type => 'text' },
|
|
| 85 |
version => { type => 'varchar', length => 8 },
|
|
| 86 |
vertreter => { type => 'boolean', default => 'false' },
|
|
| 87 |
warehouse_id => { type => 'integer' },
|
|
| 76 | 88 |
warehouse_id_ignore_onhand => { type => 'integer' },
|
| 77 |
bin_id_ignore_onhand => { type => 'integer' },
|
|
| 78 |
currency_id => { type => 'integer', not_null => 1 },
|
|
| 79 |
company => { type => 'text' },
|
|
| 80 |
address => { type => 'text' },
|
|
| 81 |
taxnumber => { type => 'text' },
|
|
| 82 |
co_ustid => { type => 'text' },
|
|
| 83 |
duns => { type => 'text' },
|
|
| 84 |
sepa_creditor_id => { type => 'text' },
|
|
| 85 |
templates => { type => 'text' },
|
|
| 86 | 89 |
webdav => { type => 'boolean', default => 'false' },
|
| 87 | 90 |
webdav_documents => { type => 'boolean', default => 'false' },
|
| 88 |
vertreter => { type => 'boolean', default => 'false' },
|
|
| 89 |
parts_show_image => { type => 'boolean', default => 'true' },
|
|
| 90 |
parts_listing_image => { type => 'boolean', default => 'true' },
|
|
| 91 |
parts_image_css => { type => 'text', default => 'border:0;float:left;max-width:250px;margin-top:20px:margin-right:10px;margin-left:10px;' },
|
|
| 91 |
weightunit => { type => 'varchar', length => 5 },
|
|
| 92 | 92 |
); |
| 93 | 93 |
|
| 94 | 94 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 122 | 122 |
}, |
| 123 | 123 |
); |
| 124 | 124 |
|
| 125 |
# __PACKAGE__->meta->initialize; |
|
| 126 |
|
|
| 127 | 125 |
1; |
| 128 | 126 |
; |
| SL/DB/MetaSetup/DeliveryOrder.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('delivery_orders');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 13 |
donumber => { type => 'text', not_null => 1 },
|
|
| 14 |
ordnumber => { type => 'text' },
|
|
| 15 |
transdate => { type => 'date', default => 'now()' },
|
|
| 16 |
vendor_id => { type => 'integer' },
|
|
| 17 |
customer_id => { type => 'integer' },
|
|
| 18 |
reqdate => { type => 'date' },
|
|
| 19 |
shippingpoint => { type => 'text' },
|
|
| 20 |
notes => { type => 'text' },
|
|
| 21 |
intnotes => { type => 'text' },
|
|
| 22 |
employee_id => { type => 'integer' },
|
|
| 23 | 12 |
closed => { type => 'boolean', default => 'false' },
|
| 24 |
delivered => { type => 'boolean', default => 'false' },
|
|
| 13 |
cp_id => { type => 'integer' },
|
|
| 14 |
currency_id => { type => 'integer', not_null => 1 },
|
|
| 25 | 15 |
cusordnumber => { type => 'text' },
|
| 26 |
oreqnumber => { type => 'text' },
|
|
| 16 |
customer_id => { type => 'integer' },
|
|
| 17 |
delivered => { type => 'boolean', default => 'false' },
|
|
| 27 | 18 |
department_id => { type => 'integer' },
|
| 28 |
shipvia => { type => 'text' },
|
|
| 29 |
cp_id => { type => 'integer' },
|
|
| 30 |
language_id => { type => 'integer' },
|
|
| 31 |
shipto_id => { type => 'integer' },
|
|
| 19 |
donumber => { type => 'text', not_null => 1 },
|
|
| 20 |
employee_id => { type => 'integer' },
|
|
| 32 | 21 |
globalproject_id => { type => 'integer' },
|
| 33 |
salesman_id => { type => 'integer' },
|
|
| 34 |
transaction_description => { type => 'text' },
|
|
| 22 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 23 |
intnotes => { type => 'text' },
|
|
| 35 | 24 |
is_sales => { type => 'boolean' },
|
| 36 | 25 |
itime => { type => 'timestamp', default => 'now()' },
|
| 26 |
language_id => { type => 'integer' },
|
|
| 37 | 27 |
mtime => { type => 'timestamp' },
|
| 38 |
taxzone_id => { type => 'integer' },
|
|
| 28 |
notes => { type => 'text' },
|
|
| 29 |
ordnumber => { type => 'text' },
|
|
| 30 |
oreqnumber => { type => 'text' },
|
|
| 31 |
reqdate => { type => 'date' },
|
|
| 32 |
salesman_id => { type => 'integer' },
|
|
| 33 |
shippingpoint => { type => 'text' },
|
|
| 34 |
shipto_id => { type => 'integer' },
|
|
| 35 |
shipvia => { type => 'text' },
|
|
| 39 | 36 |
taxincluded => { type => 'boolean' },
|
| 37 |
taxzone_id => { type => 'integer' },
|
|
| 40 | 38 |
terms => { type => 'integer' },
|
| 41 |
currency_id => { type => 'integer', not_null => 1 },
|
|
| 39 |
transaction_description => { type => 'text' },
|
|
| 40 |
transdate => { type => 'date', default => 'now()' },
|
|
| 41 |
vendor_id => { type => 'integer' },
|
|
| 42 | 42 |
); |
| 43 | 43 |
|
| 44 | 44 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 97 | 97 |
}, |
| 98 | 98 |
); |
| 99 | 99 |
|
| 100 |
# __PACKAGE__->meta->initialize; |
|
| 101 |
|
|
| 102 | 100 |
1; |
| 103 | 101 |
; |
| SL/DB/MetaSetup/DeliveryOrderItem.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('delivery_order_items');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'delivery_order_items_id' },
|
|
| 12 |
base_qty => { type => 'float', precision => 4 },
|
|
| 13 |
cusordnumber => { type => 'text' },
|
|
| 13 | 14 |
delivery_order_id => { type => 'integer', not_null => 1 },
|
| 14 |
parts_id => { type => 'integer', not_null => 1 },
|
|
| 15 | 15 |
description => { type => 'text' },
|
| 16 |
qty => { type => 'numeric', precision => 5, scale => 25 },
|
|
| 17 |
sellprice => { type => 'numeric', precision => 5, scale => 15 },
|
|
| 18 | 16 |
discount => { type => 'float', precision => 4 },
|
| 17 |
id => { type => 'integer', not_null => 1, sequence => 'delivery_order_items_id' },
|
|
| 18 |
itime => { type => 'timestamp', default => 'now()' },
|
|
| 19 |
lastcost => { type => 'numeric', precision => 5, scale => 15 },
|
|
| 20 |
longdescription => { type => 'text' },
|
|
| 21 |
marge_price_factor => { type => 'numeric', default => 1, precision => 5, scale => 15 },
|
|
| 22 |
mtime => { type => 'timestamp' },
|
|
| 23 |
ordnumber => { type => 'text' },
|
|
| 24 |
parts_id => { type => 'integer', not_null => 1 },
|
|
| 25 |
price_factor => { type => 'numeric', default => 1, precision => 5, scale => 15 },
|
|
| 26 |
price_factor_id => { type => 'integer' },
|
|
| 27 |
pricegroup_id => { type => 'integer' },
|
|
| 19 | 28 |
project_id => { type => 'integer' },
|
| 29 |
qty => { type => 'numeric', precision => 5, scale => 25 },
|
|
| 20 | 30 |
reqdate => { type => 'date' },
|
| 31 |
sellprice => { type => 'numeric', precision => 5, scale => 15 },
|
|
| 21 | 32 |
serialnumber => { type => 'text' },
|
| 22 |
ordnumber => { type => 'text' },
|
|
| 23 | 33 |
transdate => { type => 'text' },
|
| 24 |
cusordnumber => { type => 'text' },
|
|
| 25 | 34 |
unit => { type => 'varchar', length => 20 },
|
| 26 |
base_qty => { type => 'float', precision => 4 },
|
|
| 27 |
longdescription => { type => 'text' },
|
|
| 28 |
lastcost => { type => 'numeric', precision => 5, scale => 15 },
|
|
| 29 |
price_factor_id => { type => 'integer' },
|
|
| 30 |
price_factor => { type => 'numeric', default => 1, precision => 5, scale => 15 },
|
|
| 31 |
marge_price_factor => { type => 'numeric', default => 1, precision => 5, scale => 15 },
|
|
| 32 |
itime => { type => 'timestamp', default => 'now()' },
|
|
| 33 |
mtime => { type => 'timestamp' },
|
|
| 34 |
pricegroup_id => { type => 'integer' },
|
|
| 35 | 35 |
); |
| 36 | 36 |
|
| 37 | 37 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 65 | 65 |
}, |
| 66 | 66 |
); |
| 67 | 67 |
|
| 68 |
# __PACKAGE__->meta->initialize; |
|
| 69 |
|
|
| 70 | 68 |
1; |
| 71 | 69 |
; |
| SL/DB/MetaSetup/DeliveryOrderItemsStock.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('delivery_order_items_stock');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 13 |
delivery_order_item_id => { type => 'integer', not_null => 1 },
|
|
| 14 |
qty => { type => 'numeric', not_null => 1, precision => 5, scale => 15 },
|
|
| 15 |
unit => { type => 'varchar', length => 20, not_null => 1 },
|
|
| 16 |
warehouse_id => { type => 'integer', not_null => 1 },
|
|
| 12 |
bestbefore => { type => 'date' },
|
|
| 17 | 13 |
bin_id => { type => 'integer', not_null => 1 },
|
| 18 | 14 |
chargenumber => { type => 'text' },
|
| 15 |
delivery_order_item_id => { type => 'integer', not_null => 1 },
|
|
| 16 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 19 | 17 |
itime => { type => 'timestamp', default => 'now()' },
|
| 20 | 18 |
mtime => { type => 'timestamp' },
|
| 21 |
bestbefore => { type => 'date' },
|
|
| 19 |
qty => { type => 'numeric', not_null => 1, precision => 5, scale => 15 },
|
|
| 20 |
unit => { type => 'varchar', length => 20, not_null => 1 },
|
|
| 21 |
warehouse_id => { type => 'integer', not_null => 1 },
|
|
| 22 | 22 |
); |
| 23 | 23 |
|
| 24 | 24 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 42 | 42 |
}, |
| 43 | 43 |
); |
| 44 | 44 |
|
| 45 |
# __PACKAGE__->meta->initialize; |
|
| 46 |
|
|
| 47 | 45 |
1; |
| 48 | 46 |
; |
| SL/DB/MetaSetup/Department.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('department');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 13 | 12 |
description => { type => 'text' },
|
| 13 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 14 | 14 |
itime => { type => 'timestamp', default => 'now()' },
|
| 15 | 15 |
mtime => { type => 'timestamp' },
|
| 16 | 16 |
); |
| ... | ... | |
| 19 | 19 |
|
| 20 | 20 |
__PACKAGE__->meta->allow_inline_column_values(1); |
| 21 | 21 |
|
| 22 |
# __PACKAGE__->meta->initialize; |
|
| 23 |
|
|
| 24 | 22 |
1; |
| 25 | 23 |
; |
| SL/DB/MetaSetup/Draft.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('drafts');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
description => { type => 'text' },
|
|
| 13 |
employee_id => { type => 'integer' },
|
|
| 14 |
form => { type => 'text' },
|
|
| 12 | 15 |
id => { type => 'varchar', length => 50, not_null => 1 },
|
| 16 |
itime => { type => 'timestamp', default => 'now()' },
|
|
| 13 | 17 |
module => { type => 'varchar', length => 50, not_null => 1 },
|
| 14 | 18 |
submodule => { type => 'varchar', length => 50, not_null => 1 },
|
| 15 |
description => { type => 'text' },
|
|
| 16 |
itime => { type => 'timestamp', default => 'now()' },
|
|
| 17 |
form => { type => 'text' },
|
|
| 18 |
employee_id => { type => 'integer' },
|
|
| 19 | 19 |
); |
| 20 | 20 |
|
| 21 | 21 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 29 | 29 |
}, |
| 30 | 30 |
); |
| 31 | 31 |
|
| 32 |
# __PACKAGE__->meta->initialize; |
|
| 33 |
|
|
| 34 | 32 |
1; |
| 35 | 33 |
; |
| SL/DB/MetaSetup/Dunning.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('dunning');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 13 |
trans_id => { type => 'integer' },
|
|
| 12 |
duedate => { type => 'date' },
|
|
| 13 |
dunning_config_id => { type => 'integer' },
|
|
| 14 | 14 |
dunning_id => { type => 'integer' },
|
| 15 | 15 |
dunning_level => { type => 'integer' },
|
| 16 |
transdate => { type => 'date' },
|
|
| 17 |
duedate => { type => 'date' },
|
|
| 18 | 16 |
fee => { type => 'numeric', precision => 5, scale => 15 },
|
| 17 |
fee_interest_ar_id => { type => 'integer' },
|
|
| 18 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 19 | 19 |
interest => { type => 'numeric', precision => 5, scale => 15 },
|
| 20 |
dunning_config_id => { type => 'integer' },
|
|
| 21 | 20 |
itime => { type => 'timestamp', default => 'now()' },
|
| 22 | 21 |
mtime => { type => 'timestamp' },
|
| 23 |
fee_interest_ar_id => { type => 'integer' },
|
|
| 22 |
trans_id => { type => 'integer' },
|
|
| 23 |
transdate => { type => 'date' },
|
|
| 24 | 24 |
); |
| 25 | 25 |
|
| 26 | 26 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 39 | 39 |
}, |
| 40 | 40 |
); |
| 41 | 41 |
|
| 42 |
# __PACKAGE__->meta->initialize; |
|
| 43 |
|
|
| 44 | 42 |
1; |
| 45 | 43 |
; |
| SL/DB/MetaSetup/DunningConfig.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('dunning_config');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 13 |
dunning_level => { type => 'integer' },
|
|
| 14 |
dunning_description => { type => 'text' },
|
|
| 15 | 12 |
active => { type => 'boolean' },
|
| 16 | 13 |
auto => { type => 'boolean' },
|
| 14 |
create_invoices_for_fees => { type => 'boolean', default => 'true' },
|
|
| 15 |
dunning_description => { type => 'text' },
|
|
| 16 |
dunning_level => { type => 'integer' },
|
|
| 17 | 17 |
email => { type => 'boolean' },
|
| 18 |
terms => { type => 'integer' },
|
|
| 19 |
payment_terms => { type => 'integer' },
|
|
| 20 |
fee => { type => 'numeric', precision => 5, scale => 15 },
|
|
| 21 |
interest_rate => { type => 'numeric', precision => 5, scale => 15 },
|
|
| 18 |
email_attachment => { type => 'boolean' },
|
|
| 22 | 19 |
email_body => { type => 'text' },
|
| 23 | 20 |
email_subject => { type => 'text' },
|
| 24 |
email_attachment => { type => 'boolean' },
|
|
| 21 |
fee => { type => 'numeric', precision => 5, scale => 15 },
|
|
| 22 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 23 |
interest_rate => { type => 'numeric', precision => 5, scale => 15 },
|
|
| 24 |
payment_terms => { type => 'integer' },
|
|
| 25 | 25 |
template => { type => 'text' },
|
| 26 |
create_invoices_for_fees => { type => 'boolean', default => 'true' },
|
|
| 26 |
terms => { type => 'integer' },
|
|
| 27 | 27 |
); |
| 28 | 28 |
|
| 29 | 29 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| 30 | 30 |
|
| 31 |
# __PACKAGE__->meta->initialize; |
|
| 32 |
|
|
| 33 | 31 |
1; |
| 34 | 32 |
; |
| SL/DB/MetaSetup/Employee.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('employee');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 13 |
login => { type => 'text' },
|
|
| 14 |
startdate => { type => 'date', default => 'now' },
|
|
| 15 |
enddate => { type => 'date' },
|
|
| 16 |
notes => { type => 'text' },
|
|
| 17 |
sales => { type => 'boolean', default => 'true' },
|
|
| 18 |
itime => { type => 'timestamp', default => 'now()' },
|
|
| 19 |
mtime => { type => 'timestamp' },
|
|
| 20 |
name => { type => 'text' },
|
|
| 21 | 12 |
addr1 => { type => 'text' },
|
| 22 | 13 |
addr2 => { type => 'text' },
|
| 23 | 14 |
addr3 => { type => 'text' },
|
| 24 | 15 |
addr4 => { type => 'text' },
|
| 16 |
deleted => { type => 'boolean', default => 'false' },
|
|
| 17 |
enddate => { type => 'date' },
|
|
| 25 | 18 |
homephone => { type => 'text' },
|
| 19 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 20 |
itime => { type => 'timestamp', default => 'now()' },
|
|
| 21 |
login => { type => 'text' },
|
|
| 22 |
mtime => { type => 'timestamp' },
|
|
| 23 |
name => { type => 'text' },
|
|
| 24 |
notes => { type => 'text' },
|
|
| 25 |
sales => { type => 'boolean', default => 'true' },
|
|
| 26 |
startdate => { type => 'date', default => 'now' },
|
|
| 26 | 27 |
workphone => { type => 'text' },
|
| 27 |
deleted => { type => 'boolean', default => 'false' },
|
|
| 28 | 28 |
); |
| 29 | 29 |
|
| 30 | 30 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 33 | 33 |
|
| 34 | 34 |
__PACKAGE__->meta->allow_inline_column_values(1); |
| 35 | 35 |
|
| 36 |
# __PACKAGE__->meta->initialize; |
|
| 37 |
|
|
| 38 | 36 |
1; |
| 39 | 37 |
; |
| SL/DB/MetaSetup/Exchangerate.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('exchangerate');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
transdate => { type => 'date' },
|
|
| 13 | 12 |
buy => { type => 'numeric', precision => 5, scale => 15 },
|
| 14 |
sell => { type => 'numeric', precision => 5, scale => 15 },
|
|
| 13 |
currency_id => { type => 'integer', not_null => 1 },
|
|
| 14 |
id => { type => 'serial', not_null => 1 },
|
|
| 15 | 15 |
itime => { type => 'timestamp', default => 'now()' },
|
| 16 | 16 |
mtime => { type => 'timestamp' },
|
| 17 |
id => { type => 'serial', not_null => 1 },
|
|
| 18 |
currency_id => { type => 'integer', not_null => 1 },
|
|
| 17 |
sell => { type => 'numeric', precision => 5, scale => 15 },
|
|
| 18 |
transdate => { type => 'date' },
|
|
| 19 | 19 |
); |
| 20 | 20 |
|
| 21 | 21 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 29 | 29 |
}, |
| 30 | 30 |
); |
| 31 | 31 |
|
| 32 |
# __PACKAGE__->meta->initialize; |
|
| 33 |
|
|
| 34 | 32 |
1; |
| 35 | 33 |
; |
| SL/DB/MetaSetup/Finanzamt.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('finanzamt');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
fa_land_nr => { type => 'text' },
|
|
| 12 |
fa_bankbezeichnung_1 => { type => 'text' },
|
|
| 13 |
fa_bankbezeichnung_2 => { type => 'text' },
|
|
| 14 |
fa_blz_1 => { type => 'text' },
|
|
| 15 |
fa_blz_2 => { type => 'text' },
|
|
| 13 | 16 |
fa_bufa_nr => { type => 'text' },
|
| 17 |
fa_email => { type => 'text' },
|
|
| 18 |
fa_fax => { type => 'text' },
|
|
| 19 |
fa_internet => { type => 'text' },
|
|
| 20 |
fa_kontonummer_1 => { type => 'text' },
|
|
| 21 |
fa_kontonummer_2 => { type => 'text' },
|
|
| 22 |
fa_land_nr => { type => 'text' },
|
|
| 14 | 23 |
fa_name => { type => 'text' },
|
| 15 |
fa_strasse => { type => 'text' },
|
|
| 16 |
fa_plz => { type => 'text' },
|
|
| 24 |
fa_oeffnungszeiten => { type => 'text' },
|
|
| 17 | 25 |
fa_ort => { type => 'text' },
|
| 18 |
fa_telefon => { type => 'text' },
|
|
| 19 |
fa_fax => { type => 'text' },
|
|
| 26 |
fa_plz => { type => 'text' },
|
|
| 20 | 27 |
fa_plz_grosskunden => { type => 'text' },
|
| 21 | 28 |
fa_plz_postfach => { type => 'text' },
|
| 22 | 29 |
fa_postfach => { type => 'text' },
|
| 23 |
fa_blz_1 => { type => 'text' },
|
|
| 24 |
fa_kontonummer_1 => { type => 'text' },
|
|
| 25 |
fa_bankbezeichnung_1 => { type => 'text' },
|
|
| 26 |
fa_blz_2 => { type => 'text' },
|
|
| 27 |
fa_kontonummer_2 => { type => 'text' },
|
|
| 28 |
fa_bankbezeichnung_2 => { type => 'text' },
|
|
| 29 |
fa_oeffnungszeiten => { type => 'text' },
|
|
| 30 |
fa_email => { type => 'text' },
|
|
| 31 |
fa_internet => { type => 'text' },
|
|
| 30 |
fa_strasse => { type => 'text' },
|
|
| 31 |
fa_telefon => { type => 'text' },
|
|
| 32 | 32 |
id => { type => 'serial', not_null => 1 },
|
| 33 | 33 |
); |
| 34 | 34 |
|
| 35 | 35 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| 36 | 36 |
|
| 37 |
# __PACKAGE__->meta->initialize; |
|
| 38 |
|
|
| 39 | 37 |
1; |
| 40 | 38 |
; |
| SL/DB/MetaSetup/FollowUp.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('follow_ups');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'follow_up_id' },
|
|
| 13 |
follow_up_date => { type => 'date', not_null => 1 },
|
|
| 12 |
created_by => { type => 'integer', not_null => 1 },
|
|
| 14 | 13 |
created_for_user => { type => 'integer', not_null => 1 },
|
| 15 | 14 |
done => { type => 'boolean', default => 'false' },
|
| 16 |
note_id => { type => 'integer', not_null => 1 },
|
|
| 17 |
created_by => { type => 'integer', not_null => 1 },
|
|
| 15 |
follow_up_date => { type => 'date', not_null => 1 },
|
|
| 16 |
id => { type => 'integer', not_null => 1, sequence => 'follow_up_id' },
|
|
| 18 | 17 |
itime => { type => 'timestamp', default => 'now()' },
|
| 19 | 18 |
mtime => { type => 'timestamp' },
|
| 19 |
note_id => { type => 'integer', not_null => 1 },
|
|
| 20 | 20 |
); |
| 21 | 21 |
|
| 22 | 22 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 26 | 26 |
__PACKAGE__->meta->foreign_keys( |
| 27 | 27 |
employee => {
|
| 28 | 28 |
class => 'SL::DB::Employee', |
| 29 |
key_columns => { created_for_user => 'id' },
|
|
| 29 |
key_columns => { created_by => 'id' },
|
|
| 30 | 30 |
}, |
| 31 | 31 |
|
| 32 | 32 |
employee_obj => {
|
| 33 | 33 |
class => 'SL::DB::Employee', |
| 34 |
key_columns => { created_by => 'id' },
|
|
| 34 |
key_columns => { created_for_user => 'id' },
|
|
| 35 | 35 |
}, |
| 36 | 36 |
|
| 37 | 37 |
note => {
|
| ... | ... | |
| 40 | 40 |
}, |
| 41 | 41 |
); |
| 42 | 42 |
|
| 43 |
# __PACKAGE__->meta->initialize; |
|
| 44 |
|
|
| 45 | 43 |
1; |
| 46 | 44 |
; |
| SL/DB/MetaSetup/FollowUpAccess.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('follow_up_access');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
who => { type => 'integer', not_null => 1 },
|
|
| 13 |
what => { type => 'integer', not_null => 1 },
|
|
| 14 | 12 |
id => { type => 'serial', not_null => 1 },
|
| 13 |
what => { type => 'integer', not_null => 1 },
|
|
| 14 |
who => { type => 'integer', not_null => 1 },
|
|
| 15 | 15 |
); |
| 16 | 16 |
|
| 17 | 17 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 19 | 19 |
__PACKAGE__->meta->foreign_keys( |
| 20 | 20 |
employee => {
|
| 21 | 21 |
class => 'SL::DB::Employee', |
| 22 |
key_columns => { who => 'id' },
|
|
| 22 |
key_columns => { what => 'id' },
|
|
| 23 | 23 |
}, |
| 24 | 24 |
|
| 25 | 25 |
employee_obj => {
|
| 26 | 26 |
class => 'SL::DB::Employee', |
| 27 |
key_columns => { what => 'id' },
|
|
| 27 |
key_columns => { who => 'id' },
|
|
| 28 | 28 |
}, |
| 29 | 29 |
); |
| 30 | 30 |
|
| 31 |
# __PACKAGE__->meta->initialize; |
|
| 32 |
|
|
| 33 | 31 |
1; |
| 34 | 32 |
; |
| SL/DB/MetaSetup/FollowUpLink.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('follow_up_links');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'follow_up_link_id' },
|
|
| 13 | 12 |
follow_up_id => { type => 'integer', not_null => 1 },
|
| 14 |
trans_id => { type => 'integer', not_null => 1 },
|
|
| 15 |
trans_type => { type => 'text', not_null => 1 },
|
|
| 16 |
trans_info => { type => 'text' },
|
|
| 13 |
id => { type => 'integer', not_null => 1, sequence => 'follow_up_link_id' },
|
|
| 17 | 14 |
itime => { type => 'timestamp', default => 'now()' },
|
| 18 | 15 |
mtime => { type => 'timestamp' },
|
| 16 |
trans_id => { type => 'integer', not_null => 1 },
|
|
| 17 |
trans_info => { type => 'text' },
|
|
| 18 |
trans_type => { type => 'text', not_null => 1 },
|
|
| 19 | 19 |
); |
| 20 | 20 |
|
| 21 | 21 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 29 | 29 |
}, |
| 30 | 30 |
); |
| 31 | 31 |
|
| 32 |
# __PACKAGE__->meta->initialize; |
|
| 33 |
|
|
| 34 | 32 |
1; |
| 35 | 33 |
; |
| SL/DB/MetaSetup/GLTransaction.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('gl');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
id => { type => 'integer', not_null => 1, sequence => 'glid' },
|
|
| 13 |
reference => { type => 'text' },
|
|
| 12 |
cb_transaction => { type => 'boolean' },
|
|
| 13 |
department_id => { type => 'integer' },
|
|
| 14 | 14 |
description => { type => 'text' },
|
| 15 |
transdate => { type => 'date', default => 'now' },
|
|
| 16 |
gldate => { type => 'date', default => 'now' },
|
|
| 17 | 15 |
employee_id => { type => 'integer' },
|
| 18 |
notes => { type => 'text' },
|
|
| 19 |
department_id => { type => 'integer' },
|
|
| 20 |
taxincluded => { type => 'boolean' },
|
|
| 16 |
gldate => { type => 'date', default => 'now' },
|
|
| 17 |
id => { type => 'integer', not_null => 1, sequence => 'glid' },
|
|
| 21 | 18 |
itime => { type => 'timestamp', default => 'now()' },
|
| 22 | 19 |
mtime => { type => 'timestamp' },
|
| 23 |
type => { type => 'text' },
|
|
| 20 |
notes => { type => 'text' },
|
|
| 21 |
ob_transaction => { type => 'boolean' },
|
|
| 22 |
reference => { type => 'text' },
|
|
| 24 | 23 |
storno => { type => 'boolean', default => 'false' },
|
| 25 | 24 |
storno_id => { type => 'integer' },
|
| 26 |
ob_transaction => { type => 'boolean' },
|
|
| 27 |
cb_transaction => { type => 'boolean' },
|
|
| 25 |
taxincluded => { type => 'boolean' },
|
|
| 26 |
transdate => { type => 'date', default => 'now' },
|
|
| 27 |
type => { type => 'text' },
|
|
| 28 | 28 |
); |
| 29 | 29 |
|
| 30 | 30 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 43 | 43 |
}, |
| 44 | 44 |
); |
| 45 | 45 |
|
| 46 |
# __PACKAGE__->meta->initialize; |
|
| 47 |
|
|
| 48 | 46 |
1; |
| 49 | 47 |
; |
| SL/DB/MetaSetup/GenericTranslation.pm | ||
|---|---|---|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 | 12 |
id => { type => 'serial', not_null => 1 },
|
| 13 | 13 |
language_id => { type => 'integer' },
|
| 14 |
translation_type => { type => 'varchar', length => 100, not_null => 1 },
|
|
| 15 |
translation_id => { type => 'integer' },
|
|
| 16 | 14 |
translation => { type => 'text' },
|
| 15 |
translation_id => { type => 'integer' },
|
|
| 16 |
translation_type => { type => 'varchar', length => 100, not_null => 1 },
|
|
| 17 | 17 |
); |
| 18 | 18 |
|
| 19 | 19 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 25 | 25 |
}, |
| 26 | 26 |
); |
Auch abrufbar als: Unified diff
MetaSetup: Spalten- und Fremdschlüsselnamen alphabetisch sortieren