weightunit => { type => 'varchar', length => 5 },
businessnumber => { type => 'text' },
version => { type => 'varchar', length => 8 },
- curr => { type => 'text' },
closedto => { type => 'date' },
revtrans => { type => 'boolean', default => 'false' },
ponumber => { type => 'text' },
assemblynumber => { type => 'text' },
warehouse_id => { type => 'integer' },
bin_id => { type => 'integer' },
- ],
+ currency_id => { type => 'integer', not_null => 1 },
+ show_weight => { type => 'boolean', default => 'false', not_null => 1 },
+ transfer_default => { type => 'boolean', default => 'true' },
+ transfer_default_use_master_default_bin => { type => 'boolean', default => 'false' },
+ transfer_default_ignore_onhand => { type => 'boolean', default => 'false' },
+ warehouse_id_ignore_onhand => { type => 'integer' },
+ bin_id_ignore_onhand => { type => 'integer' },
+ ],
primary_key_columns => [ 'id' ],
+ allow_inline_column_values => 1,
foreign_keys => [
bin => {
class => 'SL::DB::Bin',
key_columns => { bin_id => 'id' },
},
+ bin_obj => {
+ class => 'SL::DB::Bin',
+ key_columns => { bin_id_ignore_onhand => 'id' },
+ },
+
+ currency => {
+ class => 'SL::DB::Currency',
+ key_columns => { currency_id => 'id' },
+ },
+
warehouse => {
class => 'SL::DB::Warehouse',
key_columns => { warehouse_id => 'id' },
},
+
+ warehouse_obj => {
+ class => 'SL::DB::Warehouse',
+ key_columns => { warehouse_id_ignore_onhand => 'id' },
+ },
],
);