Revision 3d433e1f
Von Tamino Steinert vor 11 Monaten hinzugefügt
- ID 3d433e1f69add82bd4c654e7ca6b1071a35e0c86
- Vorgänger 9da868aa
SL/DB/MetaSetup/Part.pm | ||
---|---|---|
32 | 32 |
obsolete => { type => 'boolean', default => 'false', not_null => 1 }, |
33 | 33 |
onhand => { type => 'numeric', default => '0', precision => 25, scale => 5 }, |
34 | 34 |
order_qty => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 }, |
35 |
part_type => { type => 'enum', check_in => [ 'part', 'service', 'assembly', 'assortment' ], db_type => 'part_type_enum', not_null => 1 }, |
|
35 |
part_type => { type => 'enum', check_in => [ 'part', 'service', 'assembly', 'assortment', 'parent_variant', 'variant' ], db_type => 'part_type_enum', not_null => 1 },
|
|
36 | 36 |
partnumber => { type => 'text', not_null => 1 }, |
37 | 37 |
partsgroup_id => { type => 'integer' }, |
38 | 38 |
payment_id => { type => 'integer' }, |
Auch abrufbar als: Unified diff
Varianten: SQL-Scripte und ROSE-DB Dateien erstellt