Revision 1861cb74
Von Tamino Steinert vor 6 Tagen hinzugefügt
SL/DB/MetaSetup/Part.pm | ||
---|---|---|
33 | 33 |
onhand => { type => 'numeric', default => '0', precision => 25, scale => 5 }, |
34 | 34 |
order_locked => { type => 'boolean', default => 'false' }, |
35 | 35 |
order_qty => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 }, |
36 |
part_type => { type => 'enum', check_in => [ 'part', 'service', 'assembly', 'assortment', 'parent_variant', 'variant' ], db_type => 'part_type_enum', not_null => 1 },
|
|
36 |
part_type => { type => 'enum', check_in => [ 'part', 'service', 'assembly', 'assortment' ], db_type => 'part_type_enum', not_null => 1 }, |
|
37 | 37 |
partnumber => { type => 'text', not_null => 1 }, |
38 | 38 |
partsgroup_id => { type => 'integer' }, |
39 | 39 |
payment_id => { type => 'integer' }, |
... | ... | |
45 | 45 |
stockable => { type => 'boolean', default => 'false' }, |
46 | 46 |
tariff_code => { type => 'text' }, |
47 | 47 |
unit => { type => 'varchar', length => 20, not_null => 1 }, |
48 |
variant_type => { type => 'enum', check_in => [ 'single', 'parent_variant', 'variant' ], db_type => 'part_variant_type', default => 'single', not_null => 1 }, |
|
48 | 49 |
ve => { type => 'integer' }, |
49 | 50 |
warehouse_id => { type => 'integer' }, |
50 | 51 |
weight => { type => 'float', precision => 4, scale => 4 }, |
Auch abrufbar als: Unified diff
Varianten: alle Artikeltypen ermöglichen