Revision 0fdf5891
Von Bernd Bleßmann vor etwa 7 Jahren hinzugefügt
| SL/DB/MetaSetup/Default.pm | ||
|---|---|---|
| 136 | 136 |
signature => { type => 'text' },
|
| 137 | 137 |
sonumber => { type => 'text' },
|
| 138 | 138 |
sqnumber => { type => 'text' },
|
| 139 |
stocktaking_bin_id => { type => 'integer' },
|
|
| 140 |
stocktaking_cutoff_date => { type => 'date' },
|
|
| 141 |
stocktaking_warehouse_id => { type => 'integer' },
|
|
| 139 | 142 |
taxnumber => { type => 'text' },
|
| 140 | 143 |
templates => { type => 'text' },
|
| 141 | 144 |
transfer_default => { type => 'boolean', default => 'true' },
|
| ... | ... | |
| 199 | 202 |
key_columns => { requirement_spec_section_order_part_id => 'id' },
|
| 200 | 203 |
}, |
| 201 | 204 |
|
| 205 |
stocktaking_bin => {
|
|
| 206 |
class => 'SL::DB::Bin', |
|
| 207 |
key_columns => { stocktaking_bin_id => 'id' },
|
|
| 208 |
}, |
|
| 209 |
|
|
| 210 |
stocktaking_warehouse => {
|
|
| 211 |
class => 'SL::DB::Warehouse', |
|
| 212 |
key_columns => { stocktaking_warehouse_id => 'id' },
|
|
| 213 |
}, |
|
| 214 |
|
|
| 202 | 215 |
warehouse => {
|
| 203 | 216 |
class => 'SL::DB::Warehouse', |
| 204 | 217 |
key_columns => { warehouse_id => 'id' },
|
| sql/Pg-upgrade2/add_stocktaking_preselects_client_config_default.sql | ||
|---|---|---|
| 1 |
-- @tag: add_stocktaking_preselects_client_config_default |
|
| 2 |
-- @description: Konfigurations-Optionen für Vorbelegungen zur Inventur |
|
| 3 |
-- @depends: warehouse |
|
| 4 |
ALTER TABLE defaults ADD COLUMN stocktaking_warehouse_id INTEGER REFERENCES warehouse(id); |
|
| 5 |
ALTER TABLE defaults ADD COLUMN stocktaking_bin_id INTEGER REFERENCES bin(id); |
|
| 6 |
ALTER TABLE defaults ADD COLUMN stocktaking_cutoff_date DATE; |
|
Auch abrufbar als: Unified diff
Inventur: Voreinstellungen für Lager, Lagerplatz und Stichtag (DB und Rose)