use strict;
-use base qw(SL::DB::Object);
+use parent qw(SL::DB::Object);
__PACKAGE__->meta->table('inventory');
delivery_order_items_stock_id => { type => 'integer' },
employee_id => { type => 'integer', not_null => 1 },
id => { type => 'serial', not_null => 1 },
+ invoice_id => { type => 'integer' },
itime => { type => 'timestamp', default => 'now()' },
mtime => { type => 'timestamp' },
oe_id => { type => 'integer' },
parts_id => { type => 'integer', not_null => 1 },
project_id => { type => 'integer' },
qty => { type => 'numeric', precision => 25, scale => 5 },
- shippingdate => { type => 'date' },
+ shippingdate => { type => 'date', not_null => 1 },
trans_id => { type => 'integer', not_null => 1 },
trans_type_id => { type => 'integer', not_null => 1 },
warehouse_id => { type => 'integer', not_null => 1 },
key_columns => { employee_id => 'id' },
},
+ invoice => {
+ class => 'SL::DB::InvoiceItem',
+ key_columns => { invoice_id => 'id' },
+ },
+
oe => {
class => 'SL::DB::DeliveryOrder',
key_columns => { oe_id => 'id' },