Revision 7289518a
Von Bernd Bleßmann vor etwa 1 Jahr hinzugefügt
SL/DB/MetaSetup/Order.pm | ||
---|---|---|
40 | 40 |
payment_id => { type => 'integer' }, |
41 | 41 |
proforma => { type => 'boolean', default => 'false' }, |
42 | 42 |
quonumber => { type => 'text' }, |
43 |
record_type => { type => 'enum', check_in => [ 'request_quotation', 'sales_quotation', 'purchase_quotation_intake', 'purchase_order', 'sales_order_intake', 'sales_order' ], db_type => 'order_types', not_null => 1 }, |
|
43 |
record_type => { type => 'enum', check_in => [ 'request_quotation', 'sales_quotation', 'purchase_quotation_intake', 'purchase_order', 'sales_order_intake', 'sales_order', 'purchase_order_confirmation' ], db_type => 'order_types', not_null => 1 },
|
|
44 | 44 |
reqdate => { type => 'date' }, |
45 | 45 |
salesman_id => { type => 'integer' }, |
46 | 46 |
shippingpoint => { type => 'text' }, |
sql/Pg-upgrade2/oe_purchase_order_confirmation_order_types.sql | ||
---|---|---|
1 |
-- @tag: oe_purchase_order_confirmation_order_types |
|
2 |
-- @description: order_types-Eintrag für Lieferantenauftragsbesätigung (purchase_order_confirmation) |
|
3 |
-- @depends: order_type |
|
4 |
|
|
5 |
ALTER TYPE order_types ADD VALUE IF NOT EXISTS 'purchase_order_confirmation'; |
Auch abrufbar als: Unified diff
Lieferantenauftragsbestätigung: DB-Type order_types