Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision a3511b2d

Von Moritz Bunkus vor fast 11 Jahren hinzugefügt

  • ID a3511b2d8974c72e4d26b2d85c5cf1cd711ccb6f
  • Vorgänger 6c22ee7e
  • Nachfolger fb03d191

MetaSetups mit RDBO >= 0.809 neu bauen

Siehe 6c22ee7eb1f64431bade6f361259737ed23b7ecc für die Erläuterung.

Unterschiede anzeigen:

SL/DB/MetaSetup/AccTransaction.pm
10 10

  
11 11
__PACKAGE__->meta->columns(
12 12
  acc_trans_id   => { type => 'bigint', not_null => 1, sequence => 'acc_trans_id_seq' },
13
  amount         => { type => 'numeric', precision => 5, scale => 15 },
13
  amount         => { type => 'numeric', precision => 15, scale => 5 },
14 14
  cb_transaction => { type => 'boolean', default => 'false', not_null => 1 },
15 15
  chart_id       => { type => 'integer', not_null => 1 },
16 16
  chart_link     => { type => 'text', not_null => 1 },
SL/DB/MetaSetup/Assembly.pm
15 15
  itime       => { type => 'timestamp', default => 'now()' },
16 16
  mtime       => { type => 'timestamp' },
17 17
  parts_id    => { type => 'integer' },
18
  qty         => { type => 'float', precision => 4 },
18
  qty         => { type => 'float', scale => 4 },
19 19
);
20 20

  
21 21
__PACKAGE__->meta->primary_key_columns([ 'assembly_id' ]);
SL/DB/MetaSetup/Business.pm
11 11
__PACKAGE__->meta->columns(
12 12
  customernumberinit => { type => 'text' },
13 13
  description        => { type => 'text' },
14
  discount           => { type => 'float', precision => 4 },
14
  discount           => { type => 'float', scale => 4 },
15 15
  id                 => { type => 'integer', not_null => 1, sequence => 'id' },
16 16
  itime              => { type => 'timestamp', default => 'now()' },
17 17
  mtime              => { type => 'timestamp' },
SL/DB/MetaSetup/CustomVariable.pm
14 14
  id              => { type => 'integer', not_null => 1, sequence => 'custom_variables_id' },
15 15
  itime           => { type => 'timestamp', default => 'now()' },
16 16
  mtime           => { type => 'timestamp' },
17
  number_value    => { type => 'numeric', precision => 5, scale => 25 },
17
  number_value    => { type => 'numeric', precision => 25, scale => 5 },
18 18
  sub_module      => { type => 'text', default => '', not_null => 1 },
19 19
  text_value      => { type => 'text' },
20 20
  timestamp_value => { type => 'timestamp' },
SL/DB/MetaSetup/Customer.pm
20 20
  city                      => { type => 'varchar', length => 75 },
21 21
  contact                   => { type => 'text' },
22 22
  country                   => { type => 'varchar', length => 75 },
23
  creditlimit               => { type => 'numeric', default => '0', precision => 5, scale => 15 },
23
  creditlimit               => { type => 'numeric', default => '0', precision => 15, scale => 5 },
24 24
  currency_id               => { type => 'integer', not_null => 1 },
25 25
  customernumber            => { type => 'text' },
26 26
  delivery_term_id          => { type => 'integer' },
......
28 28
  department_2              => { type => 'varchar', length => 75 },
29 29
  depositor                 => { type => 'text' },
30 30
  direct_debit              => { type => 'boolean', default => 'false' },
31
  discount                  => { type => 'float', precision => 4 },
31
  discount                  => { type => 'float', scale => 4 },
32 32
  email                     => { type => 'text' },
33 33
  fax                       => { type => 'varchar', length => 30 },
34 34
  greeting                  => { type => 'text' },
SL/DB/MetaSetup/DeliveryOrderItem.pm
9 9
__PACKAGE__->meta->table('delivery_order_items');
10 10

  
11 11
__PACKAGE__->meta->columns(
12
  base_qty           => { type => 'float', precision => 4 },
12
  base_qty           => { type => 'float', scale => 4 },
13 13
  cusordnumber       => { type => 'text' },
14 14
  delivery_order_id  => { type => 'integer', not_null => 1 },
15 15
  description        => { type => 'text' },
16
  discount           => { type => 'float', precision => 4 },
16
  discount           => { type => 'float', scale => 4 },
17 17
  id                 => { type => 'integer', not_null => 1, sequence => 'delivery_order_items_id' },
18 18
  itime              => { type => 'timestamp', default => 'now()' },
19
  lastcost           => { type => 'numeric', precision => 5, scale => 15 },
19
  lastcost           => { type => 'numeric', precision => 15, scale => 5 },
20 20
  longdescription    => { type => 'text' },
21
  marge_price_factor => { type => 'numeric', default => 1, precision => 5, scale => 15 },
21
  marge_price_factor => { type => 'numeric', default => 1, precision => 15, scale => 5 },
22 22
  mtime              => { type => 'timestamp' },
23 23
  ordnumber          => { type => 'text' },
24 24
  parts_id           => { type => 'integer', not_null => 1 },
25
  price_factor       => { type => 'numeric', default => 1, precision => 5, scale => 15 },
25
  price_factor       => { type => 'numeric', default => 1, precision => 15, scale => 5 },
26 26
  price_factor_id    => { type => 'integer' },
27 27
  pricegroup_id      => { type => 'integer' },
28 28
  project_id         => { type => 'integer' },
29
  qty                => { type => 'numeric', precision => 5, scale => 25 },
29
  qty                => { type => 'numeric', precision => 25, scale => 5 },
30 30
  reqdate            => { type => 'date' },
31
  sellprice          => { type => 'numeric', precision => 5, scale => 15 },
31
  sellprice          => { type => 'numeric', precision => 15, scale => 5 },
32 32
  serialnumber       => { type => 'text' },
33 33
  transdate          => { type => 'text' },
34 34
  unit               => { type => 'varchar', length => 20 },
SL/DB/MetaSetup/DeliveryOrderItemsStock.pm
16 16
  id                     => { type => 'integer', not_null => 1, sequence => 'id' },
17 17
  itime                  => { type => 'timestamp', default => 'now()' },
18 18
  mtime                  => { type => 'timestamp' },
19
  qty                    => { type => 'numeric', not_null => 1, precision => 5, scale => 15 },
19
  qty                    => { type => 'numeric', not_null => 1, precision => 15, scale => 5 },
20 20
  unit                   => { type => 'varchar', length => 20, not_null => 1 },
21 21
  warehouse_id           => { type => 'integer', not_null => 1 },
22 22
);
SL/DB/MetaSetup/Dunning.pm
13 13
  dunning_config_id  => { type => 'integer' },
14 14
  dunning_id         => { type => 'integer' },
15 15
  dunning_level      => { type => 'integer' },
16
  fee                => { type => 'numeric', precision => 5, scale => 15 },
16
  fee                => { type => 'numeric', precision => 15, scale => 5 },
17 17
  fee_interest_ar_id => { type => 'integer' },
18 18
  id                 => { type => 'integer', not_null => 1, sequence => 'id' },
19
  interest           => { type => 'numeric', precision => 5, scale => 15 },
19
  interest           => { type => 'numeric', precision => 15, scale => 5 },
20 20
  itime              => { type => 'timestamp', default => 'now()' },
21 21
  mtime              => { type => 'timestamp' },
22 22
  trans_id           => { type => 'integer' },
SL/DB/MetaSetup/DunningConfig.pm
18 18
  email_attachment         => { type => 'boolean' },
19 19
  email_body               => { type => 'text' },
20 20
  email_subject            => { type => 'text' },
21
  fee                      => { type => 'numeric', precision => 5, scale => 15 },
21
  fee                      => { type => 'numeric', precision => 15, scale => 5 },
22 22
  id                       => { type => 'integer', not_null => 1, sequence => 'id' },
23
  interest_rate            => { type => 'numeric', precision => 5, scale => 15 },
23
  interest_rate            => { type => 'numeric', precision => 15, scale => 5 },
24 24
  payment_terms            => { type => 'integer' },
25 25
  template                 => { type => 'text' },
26 26
  terms                    => { type => 'integer' },
SL/DB/MetaSetup/Exchangerate.pm
9 9
__PACKAGE__->meta->table('exchangerate');
10 10

  
11 11
__PACKAGE__->meta->columns(
12
  buy         => { type => 'numeric', precision => 5, scale => 15 },
12
  buy         => { type => 'numeric', precision => 15, scale => 5 },
13 13
  currency_id => { type => 'integer', not_null => 1 },
14 14
  id          => { type => 'serial', not_null => 1 },
15 15
  itime       => { type => 'timestamp', default => 'now()' },
16 16
  mtime       => { type => 'timestamp' },
17
  sell        => { type => 'numeric', precision => 5, scale => 15 },
17
  sell        => { type => 'numeric', precision => 15, scale => 5 },
18 18
  transdate   => { type => 'date' },
19 19
);
20 20

  
SL/DB/MetaSetup/Inventory.pm
21 21
  orderitems_id => { type => 'integer' },
22 22
  parts_id      => { type => 'integer', not_null => 1 },
23 23
  project_id    => { type => 'integer' },
24
  qty           => { type => 'numeric', precision => 5, scale => 25 },
24
  qty           => { type => 'numeric', precision => 25, scale => 5 },
25 25
  shippingdate  => { type => 'date' },
26 26
  trans_id      => { type => 'integer', not_null => 1 },
27 27
  trans_type_id => { type => 'integer', not_null => 1 },
SL/DB/MetaSetup/Invoice.pm
9 9
__PACKAGE__->meta->table('ar');
10 10

  
11 11
__PACKAGE__->meta->columns(
12
  amount                    => { type => 'numeric', precision => 5, scale => 15 },
12
  amount                    => { type => 'numeric', precision => 15, scale => 5 },
13 13
  cp_id                     => { type => 'integer' },
14 14
  currency_id               => { type => 'integer', not_null => 1 },
15 15
  cusordnumber              => { type => 'text' },
......
34 34
  invoice                   => { type => 'boolean', default => 'false' },
35 35
  itime                     => { type => 'timestamp', default => 'now()' },
36 36
  language_id               => { type => 'integer' },
37
  marge_percent             => { type => 'numeric', precision => 5, scale => 15 },
38
  marge_total               => { type => 'numeric', precision => 5, scale => 15 },
37
  marge_percent             => { type => 'numeric', precision => 15, scale => 5 },
38
  marge_total               => { type => 'numeric', precision => 15, scale => 5 },
39 39
  mtime                     => { type => 'timestamp' },
40
  netamount                 => { type => 'numeric', precision => 5, scale => 15 },
40
  netamount                 => { type => 'numeric', precision => 15, scale => 5 },
41 41
  notes                     => { type => 'text' },
42 42
  orddate                   => { type => 'date' },
43 43
  ordnumber                 => { type => 'text' },
44
  paid                      => { type => 'numeric', precision => 5, scale => 15 },
44
  paid                      => { type => 'numeric', precision => 15, scale => 5 },
45 45
  payment_id                => { type => 'integer' },
46 46
  quodate                   => { type => 'date' },
47 47
  quonumber                 => { type => 'text' },
SL/DB/MetaSetup/InvoiceItem.pm
9 9
__PACKAGE__->meta->table('invoice');
10 10

  
11 11
__PACKAGE__->meta->columns(
12
  allocated          => { type => 'float', precision => 4 },
12
  allocated          => { type => 'float', scale => 4 },
13 13
  assemblyitem       => { type => 'boolean', default => 'false' },
14
  base_qty           => { type => 'float', precision => 4 },
14
  base_qty           => { type => 'float', scale => 4 },
15 15
  cusordnumber       => { type => 'text' },
16 16
  deliverydate       => { type => 'date' },
17 17
  description        => { type => 'text' },
18
  discount           => { type => 'float', precision => 4 },
19
  fxsellprice        => { type => 'numeric', precision => 5, scale => 15 },
18
  discount           => { type => 'float', scale => 4 },
19
  fxsellprice        => { type => 'numeric', precision => 15, scale => 5 },
20 20
  id                 => { type => 'integer', not_null => 1, sequence => 'invoiceid' },
21 21
  itime              => { type => 'timestamp', default => 'now()' },
22
  lastcost           => { type => 'numeric', precision => 5, scale => 15 },
22
  lastcost           => { type => 'numeric', precision => 15, scale => 5 },
23 23
  longdescription    => { type => 'text' },
24
  marge_percent      => { type => 'numeric', precision => 5, scale => 15 },
25
  marge_price_factor => { type => 'numeric', default => 1, precision => 5, scale => 15 },
26
  marge_total        => { type => 'numeric', precision => 5, scale => 15 },
24
  marge_percent      => { type => 'numeric', precision => 15, scale => 5 },
25
  marge_price_factor => { type => 'numeric', default => 1, precision => 15, scale => 5 },
26
  marge_total        => { type => 'numeric', precision => 15, scale => 5 },
27 27
  mtime              => { type => 'timestamp' },
28 28
  ordnumber          => { type => 'text' },
29 29
  parts_id           => { type => 'integer' },
30
  price_factor       => { type => 'numeric', default => 1, precision => 5, scale => 15 },
30
  price_factor       => { type => 'numeric', default => 1, precision => 15, scale => 5 },
31 31
  price_factor_id    => { type => 'integer' },
32 32
  pricegroup_id      => { type => 'integer' },
33 33
  project_id         => { type => 'integer' },
34
  qty                => { type => 'float', precision => 4 },
35
  sellprice          => { type => 'numeric', precision => 5, scale => 15 },
34
  qty                => { type => 'float', scale => 4 },
35
  sellprice          => { type => 'numeric', precision => 15, scale => 5 },
36 36
  serialnumber       => { type => 'text' },
37 37
  subtotal           => { type => 'boolean', default => 'false' },
38 38
  trans_id           => { type => 'integer' },
SL/DB/MetaSetup/MakeModel.pm
11 11
__PACKAGE__->meta->columns(
12 12
  id         => { type => 'serial', not_null => 1 },
13 13
  itime      => { type => 'timestamp', default => 'now()' },
14
  lastcost   => { type => 'numeric', precision => 5, scale => 15 },
14
  lastcost   => { type => 'numeric', precision => 15, scale => 5 },
15 15
  lastupdate => { type => 'date' },
16 16
  make       => { type => 'integer' },
17 17
  model      => { type => 'text' },
SL/DB/MetaSetup/Order.pm
9 9
__PACKAGE__->meta->table('oe');
10 10

  
11 11
__PACKAGE__->meta->columns(
12
  amount                  => { type => 'numeric', precision => 5, scale => 15 },
12
  amount                  => { type => 'numeric', precision => 15, scale => 5 },
13 13
  closed                  => { type => 'boolean', default => 'false' },
14 14
  cp_id                   => { type => 'integer' },
15 15
  currency_id             => { type => 'integer', not_null => 1 },
......
26 26
  intnotes                => { type => 'text' },
27 27
  itime                   => { type => 'timestamp', default => 'now()' },
28 28
  language_id             => { type => 'integer' },
29
  marge_percent           => { type => 'numeric', precision => 5, scale => 15 },
30
  marge_total             => { type => 'numeric', precision => 5, scale => 15 },
29
  marge_percent           => { type => 'numeric', precision => 15, scale => 5 },
30
  marge_total             => { type => 'numeric', precision => 15, scale => 5 },
31 31
  mtime                   => { type => 'timestamp' },
32
  netamount               => { type => 'numeric', precision => 5, scale => 15 },
32
  netamount               => { type => 'numeric', precision => 15, scale => 5 },
33 33
  notes                   => { type => 'text' },
34 34
  ordnumber               => { type => 'text', not_null => 1 },
35 35
  payment_id              => { type => 'integer' },
SL/DB/MetaSetup/OrderItem.pm
9 9
__PACKAGE__->meta->table('orderitems');
10 10

  
11 11
__PACKAGE__->meta->columns(
12
  base_qty           => { type => 'float', precision => 4 },
12
  base_qty           => { type => 'float', scale => 4 },
13 13
  cusordnumber       => { type => 'text' },
14 14
  description        => { type => 'text' },
15
  discount           => { type => 'float', precision => 4 },
15
  discount           => { type => 'float', scale => 4 },
16 16
  id                 => { type => 'integer', not_null => 1, sequence => 'orderitemsid' },
17 17
  itime              => { type => 'timestamp', default => 'now()' },
18
  lastcost           => { type => 'numeric', precision => 5, scale => 15 },
18
  lastcost           => { type => 'numeric', precision => 15, scale => 5 },
19 19
  longdescription    => { type => 'text' },
20
  marge_percent      => { type => 'numeric', precision => 5, scale => 15 },
21
  marge_price_factor => { type => 'numeric', default => 1, precision => 5, scale => 15 },
22
  marge_total        => { type => 'numeric', precision => 5, scale => 15 },
20
  marge_percent      => { type => 'numeric', precision => 15, scale => 5 },
21
  marge_price_factor => { type => 'numeric', default => 1, precision => 15, scale => 5 },
22
  marge_total        => { type => 'numeric', precision => 15, scale => 5 },
23 23
  mtime              => { type => 'timestamp' },
24 24
  ordnumber          => { type => 'text' },
25 25
  parts_id           => { type => 'integer' },
26
  price_factor       => { type => 'numeric', default => 1, precision => 5, scale => 15 },
26
  price_factor       => { type => 'numeric', default => 1, precision => 15, scale => 5 },
27 27
  price_factor_id    => { type => 'integer' },
28 28
  pricegroup_id      => { type => 'integer' },
29 29
  project_id         => { type => 'integer' },
30
  qty                => { type => 'float', precision => 4 },
30
  qty                => { type => 'float', scale => 4 },
31 31
  reqdate            => { type => 'date' },
32
  sellprice          => { type => 'numeric', precision => 5, scale => 15 },
32
  sellprice          => { type => 'numeric', precision => 15, scale => 5 },
33 33
  serialnumber       => { type => 'text' },
34
  ship               => { type => 'float', precision => 4 },
34
  ship               => { type => 'float', scale => 4 },
35 35
  subtotal           => { type => 'boolean', default => 'false' },
36 36
  trans_id           => { type => 'integer' },
37 37
  transdate          => { type => 'text' },
SL/DB/MetaSetup/Part.pm
19 19
  ean                => { type => 'text' },
20 20
  expense_accno_id   => { type => 'integer' },
21 21
  formel             => { type => 'text' },
22
  gv                 => { type => 'numeric', precision => 5, scale => 15 },
22
  gv                 => { type => 'numeric', precision => 15, scale => 5 },
23 23
  has_sernumber      => { type => 'boolean', default => 'false' },
24 24
  id                 => { type => 'integer', not_null => 1, sequence => 'id' },
25 25
  image              => { type => 'text' },
26 26
  income_accno_id    => { type => 'integer' },
27 27
  inventory_accno_id => { type => 'integer' },
28 28
  itime              => { type => 'timestamp', default => 'now()' },
29
  lastcost           => { type => 'numeric', precision => 5, scale => 15 },
30
  listprice          => { type => 'numeric', precision => 5, scale => 15 },
29
  lastcost           => { type => 'numeric', precision => 15, scale => 5 },
30
  listprice          => { type => 'numeric', precision => 15, scale => 5 },
31 31
  makemodel          => { type => 'boolean', default => 'false' },
32 32
  microfiche         => { type => 'text' },
33 33
  mtime              => { type => 'timestamp' },
34 34
  not_discountable   => { type => 'boolean', default => 'false' },
35 35
  notes              => { type => 'text' },
36 36
  obsolete           => { type => 'boolean', default => 'false' },
37
  onhand             => { type => 'numeric', default => '0', precision => 5, scale => 25 },
37
  onhand             => { type => 'numeric', default => '0', precision => 25, scale => 5 },
38 38
  partnumber         => { type => 'text', not_null => 1 },
39 39
  partsgroup_id      => { type => 'integer' },
40 40
  payment_id         => { type => 'integer' },
41 41
  price_factor_id    => { type => 'integer' },
42 42
  priceupdate        => { type => 'date', default => 'now' },
43
  rop                => { type => 'float', precision => 4 },
44
  sellprice          => { type => 'numeric', precision => 5, scale => 15 },
43
  rop                => { type => 'float', scale => 4 },
44
  sellprice          => { type => 'numeric', precision => 15, scale => 5 },
45 45
  shop               => { type => 'boolean', default => 'false' },
46 46
  stockable          => { type => 'boolean', default => 'false' },
47 47
  unit               => { type => 'varchar', length => 20, not_null => 1 },
48 48
  ve                 => { type => 'integer' },
49 49
  warehouse_id       => { type => 'integer' },
50
  weight             => { type => 'float', precision => 4 },
50
  weight             => { type => 'float', scale => 4 },
51 51
);
52 52

  
53 53
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
SL/DB/MetaSetup/PaymentTerm.pm
14 14
  id               => { type => 'integer', not_null => 1, sequence => 'id' },
15 15
  itime            => { type => 'timestamp', default => 'now()' },
16 16
  mtime            => { type => 'timestamp' },
17
  percent_skonto   => { type => 'float', precision => 4 },
17
  percent_skonto   => { type => 'float', scale => 4 },
18 18
  ranking          => { type => 'integer' },
19 19
  sortkey          => { type => 'integer', not_null => 1 },
20 20
  terms_netto      => { type => 'integer' },
SL/DB/MetaSetup/Price.pm
11 11
__PACKAGE__->meta->columns(
12 12
  id            => { type => 'serial', not_null => 1 },
13 13
  parts_id      => { type => 'integer' },
14
  price         => { type => 'numeric', precision => 5, scale => 15 },
14
  price         => { type => 'numeric', precision => 15, scale => 5 },
15 15
  pricegroup_id => { type => 'integer' },
16 16
);
17 17

  
SL/DB/MetaSetup/PriceFactor.pm
10 10

  
11 11
__PACKAGE__->meta->columns(
12 12
  description => { type => 'text' },
13
  factor      => { type => 'numeric', precision => 5, scale => 15 },
13
  factor      => { type => 'numeric', precision => 15, scale => 5 },
14 14
  id          => { type => 'integer', not_null => 1, sequence => 'id' },
15 15
  sortkey     => { type => 'integer' },
16 16
);
SL/DB/MetaSetup/PurchaseInvoice.pm
9 9
__PACKAGE__->meta->table('ap');
10 10

  
11 11
__PACKAGE__->meta->columns(
12
  amount                  => { type => 'numeric', precision => 5, scale => 15 },
12
  amount                  => { type => 'numeric', precision => 15, scale => 5 },
13 13
  cp_id                   => { type => 'integer' },
14 14
  currency_id             => { type => 'integer', not_null => 1 },
15 15
  datepaid                => { type => 'date' },
......
28 28
  itime                   => { type => 'timestamp', default => 'now()' },
29 29
  language_id             => { type => 'integer' },
30 30
  mtime                   => { type => 'timestamp' },
31
  netamount               => { type => 'numeric', precision => 5, scale => 15 },
31
  netamount               => { type => 'numeric', precision => 15, scale => 5 },
32 32
  notes                   => { type => 'text' },
33 33
  orddate                 => { type => 'date' },
34 34
  ordnumber               => { type => 'text' },
35
  paid                    => { type => 'numeric', precision => 5, scale => 15 },
35
  paid                    => { type => 'numeric', precision => 15, scale => 5 },
36 36
  payment_id              => { type => 'integer' },
37 37
  quodate                 => { type => 'date' },
38 38
  quonumber               => { type => 'text' },
SL/DB/MetaSetup/SepaExportItem.pm
9 9
__PACKAGE__->meta->table('sepa_export_items');
10 10

  
11 11
__PACKAGE__->meta->columns(
12
  amount                       => { type => 'numeric', precision => 5, scale => 25 },
12
  amount                       => { type => 'numeric', precision => 25, scale => 5 },
13 13
  ap_id                        => { type => 'integer' },
14 14
  ar_id                        => { type => 'integer' },
15 15
  chart_id                     => { type => 'integer', not_null => 1 },
SL/DB/MetaSetup/Tax.pm
14 14
  id               => { type => 'integer', not_null => 1, sequence => 'id' },
15 15
  itime            => { type => 'timestamp', default => 'now()' },
16 16
  mtime            => { type => 'timestamp' },
17
  rate             => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
17
  rate             => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
18 18
  taxdescription   => { type => 'text', not_null => 1 },
19 19
  taxkey           => { type => 'integer', not_null => 1 },
20 20
  taxnumber        => { type => 'text' },
SL/DB/MetaSetup/Unit.pm
10 10

  
11 11
__PACKAGE__->meta->columns(
12 12
  base_unit => { type => 'varchar', length => 20 },
13
  factor    => { type => 'numeric', precision => 5, scale => 20 },
13
  factor    => { type => 'numeric', precision => 20, scale => 5 },
14 14
  id        => { type => 'serial', not_null => 1 },
15 15
  name      => { type => 'varchar', length => 20, not_null => 1 },
16 16
  sortkey   => { type => 'integer', not_null => 1 },
SL/DB/MetaSetup/Vendor.pm
19 19
  city             => { type => 'varchar', length => 75 },
20 20
  contact          => { type => 'varchar', length => 75 },
21 21
  country          => { type => 'varchar', length => 75 },
22
  creditlimit      => { type => 'numeric', precision => 5, scale => 15 },
22
  creditlimit      => { type => 'numeric', precision => 15, scale => 5 },
23 23
  currency_id      => { type => 'integer', not_null => 1 },
24 24
  delivery_term_id => { type => 'integer' },
25 25
  department_1     => { type => 'varchar', length => 75 },
26 26
  department_2     => { type => 'varchar', length => 75 },
27 27
  depositor        => { type => 'text' },
28 28
  direct_debit     => { type => 'boolean', default => 'false' },
29
  discount         => { type => 'float', precision => 4 },
29
  discount         => { type => 'float', scale => 4 },
30 30
  email            => { type => 'text' },
31 31
  fax              => { type => 'varchar', length => 30 },
32 32
  greeting         => { type => 'text' },

Auch abrufbar als: Unified diff