Revision 693e5820
Von Niclas Zimmermann vor mehr als 11 Jahren hinzugefügt
| SL/DB/Helper/TransNumberGenerator.pm | ||
|---|---|---|
| 34 | 34 |
vendor => { number_column => 'vendornumber', number_range_column => 'vendornumber', },
|
| 35 | 35 |
part => { number_column => 'partnumber', number_range_column => 'articlenumber', scoping => \&parts_scoping },
|
| 36 | 36 |
service => { number_column => 'partnumber', number_range_column => 'servicenumber', scoping => \&parts_scoping },
|
| 37 |
assembly => { number_column => 'partnumber', number_range_column => 'articlenumber', scoping => \&parts_scoping },
|
|
| 37 |
assembly => { number_column => 'partnumber', number_range_column => 'assemblynumber', scoping => \&parts_scoping },
|
|
| 38 | 38 |
); |
| 39 | 39 |
|
| 40 | 40 |
sub get_next_trans_number {
|
| ... | ... | |
| 56 | 56 |
my %numbers_in_use = map { ( $_ => 1 ) } @numbers;
|
| 57 | 57 |
|
| 58 | 58 |
my $defaults = SL::DB::Default->get; |
| 59 |
$number_range_column = 'articlenumber' if $number_range_column eq 'assemblynumber' and length($defaults->$number_range_column) < 1; |
|
| 59 | 60 |
my $sequence = SL::PrefixedNumber->new(number => $defaults->$number_range_column); |
| 60 | 61 |
|
| 61 | 62 |
$sequence->set_to_max(@numbers) if !$fill_holes_in_range; |
| SL/DB/MetaSetup/Default.pm | ||
|---|---|---|
| 36 | 36 |
mtime => { type => 'timestamp' },
|
| 37 | 37 |
rmanumber => { type => 'text' },
|
| 38 | 38 |
cnnumber => { type => 'text' },
|
| 39 |
accounting_method => { type => 'text' },
|
|
| 40 |
inventory_system => { type => 'text' },
|
|
| 41 |
profit_determination => { type => 'text' },
|
|
| 42 | 39 |
dunning_ar_amount_fee => { type => 'integer' },
|
| 43 | 40 |
dunning_ar_amount_interest => { type => 'integer' },
|
| 44 | 41 |
dunning_ar => { type => 'integer' },
|
| ... | ... | |
| 47 | 44 |
ar_paid_accno_id => { type => 'integer' },
|
| 48 | 45 |
id => { type => 'serial', not_null => 1 },
|
| 49 | 46 |
language_id => { type => 'integer' },
|
| 50 |
payments_changeable => { type => 'integer', default => '0', not_null => 1 },
|
|
| 51 |
show_bestbefore => { type => 'boolean', default => 'false' },
|
|
| 47 |
accounting_method => { type => 'text' },
|
|
| 48 |
inventory_system => { type => 'text' },
|
|
| 49 |
profit_determination => { type => 'text' },
|
|
| 52 | 50 |
datev_check_on_sales_invoice => { type => 'boolean', default => 'true' },
|
| 53 | 51 |
datev_check_on_purchase_invoice => { type => 'boolean', default => 'true' },
|
| 54 | 52 |
datev_check_on_ar_transaction => { type => 'boolean', default => 'true' },
|
| 55 | 53 |
datev_check_on_ap_transaction => { type => 'boolean', default => 'true' },
|
| 56 | 54 |
datev_check_on_gl_transaction => { type => 'boolean', default => 'true' },
|
| 55 |
payments_changeable => { type => 'integer', default => '0', not_null => 1 },
|
|
| 57 | 56 |
is_changeable => { type => 'integer', default => 2, not_null => 1 },
|
| 58 | 57 |
ir_changeable => { type => 'integer', default => 2, not_null => 1 },
|
| 59 | 58 |
ar_changeable => { type => 'integer', default => 2, not_null => 1 },
|
| 60 | 59 |
ap_changeable => { type => 'integer', default => 2, not_null => 1 },
|
| 61 | 60 |
gl_changeable => { type => 'integer', default => 2, not_null => 1 },
|
| 62 |
is_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 63 |
ir_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 64 |
ar_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 65 |
ap_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 61 |
show_bestbefore => { type => 'boolean', default => 'false' },
|
|
| 66 | 62 |
sales_order_show_delete => { type => 'boolean', default => 'true' },
|
| 67 | 63 |
purchase_order_show_delete => { type => 'boolean', default => 'true' },
|
| 68 | 64 |
sales_delivery_order_show_delete => { type => 'boolean', default => 'true' },
|
| 69 | 65 |
purchase_delivery_order_show_delete => { type => 'boolean', default => 'true' },
|
| 66 |
is_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 67 |
ir_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 68 |
ar_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 69 |
ap_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
|
| 70 |
deviating_fiscal_year => { type => 'boolean' },
|
|
| 71 |
assemblynumber => { type => 'text' },
|
|
| 70 | 72 |
], |
| 71 | 73 |
|
| 72 | 74 |
primary_key_columns => [ 'id' ], |
| 73 |
|
|
| 74 |
allow_inline_column_values => 1, |
|
| 75 | 75 |
); |
| 76 | 76 |
|
| 77 | 77 |
1; |
Auch abrufbar als: Unified diff
Nummernkreis Erzeugnis
Der TransNumberGenerator musste noch für den neuen Nummernkreis
Erzeugnisse angepasst werden.