Revision 3dc3b1bc
Von Bernd Bleßmann vor mehr als 2 Jahren hinzugefügt
| SL/DB/MetaSetup/Order.pm | ||
|---|---|---|
|
netamount => { type => 'numeric', precision => 15, scale => 5 },
|
||
|
notes => { type => 'text' },
|
||
|
order_probability => { type => 'integer', default => '0', not_null => 1 },
|
||
|
order_status_id => { type => 'integer' },
|
||
|
ordnumber => { type => 'text', not_null => 1 },
|
||
|
payment_id => { type => 'integer' },
|
||
|
proforma => { type => 'boolean', default => 'false' },
|
||
| ... | ... | |
|
key_columns => { language_id => 'id' },
|
||
|
},
|
||
|
|
||
|
order_status => {
|
||
|
class => 'SL::DB::OrderStatus',
|
||
|
key_columns => { order_status_id => 'id' },
|
||
|
},
|
||
|
|
||
|
payment_terms => {
|
||
|
class => 'SL::DB::PaymentTerm',
|
||
|
key_columns => { payment_id => 'id' },
|
||
| sql/Pg-upgrade2/oe_add_order_status.sql | ||
|---|---|---|
|
-- @tag: oe_add_order_status
|
||
|
-- @description: Status für Angebote und Aufträge: Feld in Angebot/Auftrags-Tabelle
|
||
|
-- @depends: order_statuses
|
||
|
|
||
|
ALTER TABLE oe ADD COLUMN order_status_id INTEGER REFERENCES order_statuses(id);
|
||
Auch abrufbar als: Unified diff
Angebot/Auftrag Status: Feld in Tabelle für Angebote/Aufträge: DB und Rose