Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 72b54587

Von Moritz Bunkus vor fast 2 Jahren hinzugefügt

  • ID 72b54587bd15a5da907738e225ded4a82663817c
  • Vorgänger d9942d67
  • Nachfolger 8e927544

Wiederkehrende Abrechnung Positionen: Datenbankmodell

Unterschiede anzeigen:

SL/DB/MetaSetup/OrderItem.pm
9 9
__PACKAGE__->meta->table('orderitems');
10 10

  
11 11
__PACKAGE__->meta->columns(
12
  active_discount_source => { type => 'text', default => '', not_null => 1 },
13
  active_price_source    => { type => 'text', default => '', not_null => 1 },
14
  base_qty               => { type => 'float', precision => 4, scale => 4 },
15
  cusordnumber           => { type => 'text' },
16
  description            => { type => 'text' },
17
  discount               => { type => 'float', precision => 4, scale => 4 },
18
  id                     => { type => 'integer', not_null => 1, sequence => 'orderitemsid' },
19
  itime                  => { type => 'timestamp', default => 'now()' },
20
  lastcost               => { type => 'numeric', precision => 15, scale => 5 },
21
  longdescription        => { type => 'text' },
22
  marge_percent          => { type => 'numeric', precision => 15, scale => 5 },
23
  marge_price_factor     => { type => 'numeric', default => 1, precision => 15, scale => 5 },
24
  marge_total            => { type => 'numeric', precision => 15, scale => 5 },
25
  mtime                  => { type => 'timestamp' },
26
  optional               => { type => 'boolean', default => 'false' },
27
  ordnumber              => { type => 'text' },
28
  parts_id               => { type => 'integer' },
29
  position               => { type => 'integer', not_null => 1 },
30
  price_factor           => { type => 'numeric', default => 1, precision => 15, scale => 5 },
31
  price_factor_id        => { type => 'integer' },
32
  pricegroup_id          => { type => 'integer' },
33
  project_id             => { type => 'integer' },
34
  qty                    => { type => 'numeric', precision => 25, scale => 5 },
35
  reqdate                => { type => 'date' },
36
  sellprice              => { type => 'numeric', precision => 15, scale => 5 },
37
  serialnumber           => { type => 'text' },
38
  ship                   => { type => 'float', precision => 4, scale => 4 },
39
  subtotal               => { type => 'boolean', default => 'false' },
40
  trans_id               => { type => 'integer' },
41
  transdate              => { type => 'text' },
42
  unit                   => { type => 'varchar', length => 20 },
12
  active_discount_source       => { type => 'text', default => '', not_null => 1 },
13
  active_price_source          => { type => 'text', default => '', not_null => 1 },
14
  base_qty                     => { type => 'float', precision => 4, scale => 4 },
15
  cusordnumber                 => { type => 'text' },
16
  description                  => { type => 'text' },
17
  discount                     => { type => 'float', precision => 4, scale => 4 },
18
  id                           => { type => 'integer', not_null => 1, sequence => 'orderitemsid' },
19
  itime                        => { type => 'timestamp', default => 'now()' },
20
  lastcost                     => { type => 'numeric', precision => 15, scale => 5 },
21
  longdescription              => { type => 'text' },
22
  marge_percent                => { type => 'numeric', precision => 15, scale => 5 },
23
  marge_price_factor           => { type => 'numeric', default => 1, precision => 15, scale => 5 },
24
  marge_total                  => { type => 'numeric', precision => 15, scale => 5 },
25
  mtime                        => { type => 'timestamp' },
26
  optional                     => { type => 'boolean', default => 'false' },
27
  ordnumber                    => { type => 'text' },
28
  parts_id                     => { type => 'integer' },
29
  position                     => { type => 'integer', not_null => 1 },
30
  price_factor                 => { type => 'numeric', default => 1, precision => 15, scale => 5 },
31
  price_factor_id              => { type => 'integer' },
32
  pricegroup_id                => { type => 'integer' },
33
  project_id                   => { type => 'integer' },
34
  qty                          => { type => 'numeric', precision => 25, scale => 5 },
35
  recurring_billing_invoice_id => { type => 'integer' },
36
  recurring_billing_mode       => { type => 'enum', check_in => [ 'never', 'once', 'always' ], db_type => 'items_recurring_billing_mode', default => 'always', not_null => 1 },
37
  reqdate                      => { type => 'date' },
38
  sellprice                    => { type => 'numeric', precision => 15, scale => 5 },
39
  serialnumber                 => { type => 'text' },
40
  ship                         => { type => 'float', precision => 4, scale => 4 },
41
  subtotal                     => { type => 'boolean', default => 'false' },
42
  trans_id                     => { type => 'integer' },
43
  transdate                    => { type => 'text' },
44
  unit                         => { type => 'varchar', length => 20 },
43 45
);
44 46

  
45 47
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
......
72 74
    key_columns => { project_id => 'id' },
73 75
  },
74 76

  
77
  recurring_billing_invoice => {
78
    class       => 'SL::DB::Invoice',
79
    key_columns => { recurring_billing_invoice_id => 'id' },
80
  },
81

  
75 82
  unit_obj => {
76 83
    class       => 'SL::DB::Unit',
77 84
    key_columns => { unit => 'name' },

Auch abrufbar als: Unified diff