taxincluded => { type => 'boolean' },
shippingpoint => { type => 'text' },
notes => { type => 'text' },
- curr => { type => 'character', length => 3 },
employee_id => { type => 'integer' },
closed => { type => 'boolean', default => 'false' },
quotation => { type => 'boolean', default => 'false' },
delivered => { type => 'boolean', default => 'false' },
globalproject_id => { type => 'integer' },
salesman_id => { type => 'integer' },
- transaction_description => { type => 'text' },
marge_total => { type => 'numeric', precision => 5, scale => 15 },
marge_percent => { type => 'numeric', precision => 5, scale => 15 },
+ transaction_description => { type => 'text' },
+ currency_id => { type => 'integer', not_null => 1 },
],
primary_key_columns => [ 'id' ],
key_columns => { cp_id => 'cp_id' },
},
+ currency => {
+ class => 'SL::DB::Currency',
+ key_columns => { currency_id => 'id' },
+ },
+
customer => {
class => 'SL::DB::Customer',
key_columns => { customer_id => 'id' },
key_columns => { employee_id => 'id' },
},
- employee_obj => {
- class => 'SL::DB::Employee',
- key_columns => { employee_id => 'id' },
- },
-
globalproject => {
class => 'SL::DB::Project',
key_columns => { globalproject_id => 'id' },
key_columns => { language_id => 'id' },
},
- payment => {
+ payment_terms => {
class => 'SL::DB::PaymentTerm',
key_columns => { payment_id => 'id' },
},