Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 7bff84cb

Von Thomas Heck vor etwa 12 Jahren hinzugefügt

  • ID 7bff84cbc6daa65a74b9f5c83415c98856eb30a1
  • Vorgänger dc7791df
  • Nachfolger 4fa7102b

Möglichkeit zum Setzen von "Steuer im Preis inbegriffen" als Default

fixt #1985

Unterschiede anzeigen:

SL/DB/MetaSetup/Customer.pm
10 10
  table   => 'customer',
11 11

  
12 12
  columns => [
13
    id             => { type => 'integer', not_null => 1, sequence => 'id' },
14
    name           => { type => 'text', not_null => 1 },
15
    department_1   => { type => 'varchar', length => 75 },
16
    department_2   => { type => 'varchar', length => 75 },
17
    street         => { type => 'varchar', length => 75 },
18
    zipcode        => { type => 'varchar', length => 10 },
19
    city           => { type => 'varchar', length => 75 },
20
    country        => { type => 'varchar', length => 75 },
21
    contact        => { type => 'text' },
22
    phone          => { type => 'text' },
23
    fax            => { type => 'varchar', length => 30 },
24
    homepage       => { type => 'text' },
25
    email          => { type => 'text' },
26
    notes          => { type => 'text' },
27
    discount       => { type => 'float', precision => 4 },
28
    taxincluded    => { type => 'boolean' },
29
    creditlimit    => { type => 'numeric', default => '0', precision => 5, scale => 15 },
30
    terms          => { type => 'integer', default => '0' },
31
    customernumber => { type => 'text' },
32
    cc             => { type => 'text' },
33
    bcc            => { type => 'text' },
34
    business_id    => { type => 'integer' },
35
    taxnumber      => { type => 'text' },
36
    account_number => { type => 'text' },
37
    bank_code      => { type => 'text' },
38
    bank           => { type => 'text' },
39
    language       => { type => 'varchar', length => 5 },
40
    itime          => { type => 'timestamp', default => 'now()' },
41
    mtime          => { type => 'timestamp' },
42
    obsolete       => { type => 'boolean', default => 'false' },
43
    username       => { type => 'varchar', length => 50 },
44
    user_password  => { type => 'text' },
45
    salesman_id    => { type => 'integer' },
46
    c_vendor_id    => { type => 'text' },
47
    klass          => { type => 'integer', default => '0' },
48
    language_id    => { type => 'integer' },
49
    payment_id     => { type => 'integer' },
50
    taxzone_id     => { type => 'integer', default => '0', not_null => 1 },
51
    greeting       => { type => 'text' },
52
    ustid          => { type => 'text' },
53
    iban           => { type => 'varchar', length => 100 },
54
    bic            => { type => 'varchar', length => 100 },
55
    direct_debit   => { type => 'boolean', default => 'false' },
56
    curr           => { type => 'character', length => 3 },
13
    id                  => { type => 'integer', not_null => 1, sequence => 'id' },
14
    name                => { type => 'text', not_null => 1 },
15
    department_1        => { type => 'varchar', length => 75 },
16
    department_2        => { type => 'varchar', length => 75 },
17
    street              => { type => 'varchar', length => 75 },
18
    zipcode             => { type => 'varchar', length => 10 },
19
    city                => { type => 'varchar', length => 75 },
20
    country             => { type => 'varchar', length => 75 },
21
    contact             => { type => 'text' },
22
    phone               => { type => 'text' },
23
    fax                 => { type => 'varchar', length => 30 },
24
    homepage            => { type => 'text' },
25
    email               => { type => 'text' },
26
    notes               => { type => 'text' },
27
    discount            => { type => 'float', precision => 4 },
28
    taxincluded         => { type => 'boolean' },
29
    creditlimit         => { type => 'numeric', default => '0', precision => 5, scale => 15 },
30
    terms               => { type => 'integer', default => '0' },
31
    customernumber      => { type => 'text' },
32
    cc                  => { type => 'text' },
33
    bcc                 => { type => 'text' },
34
    business_id         => { type => 'integer' },
35
    taxnumber           => { type => 'text' },
36
    account_number      => { type => 'text' },
37
    bank_code           => { type => 'text' },
38
    bank                => { type => 'text' },
39
    language            => { type => 'varchar', length => 5 },
40
    itime               => { type => 'timestamp', default => 'now()' },
41
    mtime               => { type => 'timestamp' },
42
    obsolete            => { type => 'boolean', default => 'false' },
43
    username            => { type => 'varchar', length => 50 },
44
    user_password       => { type => 'text' },
45
    salesman_id         => { type => 'integer' },
46
    c_vendor_id         => { type => 'text' },
47
    klass               => { type => 'integer', default => '0' },
48
    language_id         => { type => 'integer' },
49
    payment_id          => { type => 'integer' },
50
    taxzone_id          => { type => 'integer', default => '0', not_null => 1 },
51
    greeting            => { type => 'text' },
52
    ustid               => { type => 'text' },
53
    iban                => { type => 'varchar', length => 100 },
54
    bic                 => { type => 'varchar', length => 100 },
55
    direct_debit        => { type => 'boolean', default => 'false' },
56
    curr                => { type => 'character', length => 3 },
57
    taxincluded_checked => { type => 'varchar', length => 1 },
57 58
  ],
58 59

  
59 60
  primary_key_columns => [ 'id' ],

Auch abrufbar als: Unified diff