Revision 3eb3d1b1
Von Moritz Bunkus vor mehr als 11 Jahren hinzugefügt
SL/DB/MetaSetup/PurchaseInvoice.pm | ||
---|---|---|
9 | 9 |
__PACKAGE__->meta->table('ap'); |
10 | 10 |
|
11 | 11 |
__PACKAGE__->meta->columns( |
12 |
id => { type => 'integer', not_null => 1, sequence => 'glid' }, |
|
13 |
invnumber => { type => 'text', not_null => 1 }, |
|
14 |
transdate => { type => 'date', default => 'now' }, |
|
15 |
gldate => { type => 'date', default => 'now' }, |
|
16 |
vendor_id => { type => 'integer' }, |
|
17 |
taxincluded => { type => 'boolean', default => 'false' }, |
|
18 | 12 |
amount => { type => 'numeric', precision => 5, scale => 15 }, |
19 |
netamount => { type => 'numeric', precision => 5, scale => 15 },
|
|
20 |
paid => { type => 'numeric', precision => 5, scale => 15 },
|
|
13 |
cp_id => { type => 'integer' },
|
|
14 |
currency_id => { type => 'integer', not_null => 1 },
|
|
21 | 15 |
datepaid => { type => 'date' }, |
16 |
deliverydate => { type => 'date' }, |
|
17 |
department_id => { type => 'integer' }, |
|
18 |
direct_debit => { type => 'boolean', default => 'false' }, |
|
22 | 19 |
duedate => { type => 'date' }, |
23 |
invoice => { type => 'boolean', default => 'false' }, |
|
24 |
ordnumber => { type => 'text' }, |
|
25 |
notes => { type => 'text' }, |
|
26 | 20 |
employee_id => { type => 'integer' }, |
27 |
quonumber => { type => 'text' }, |
|
21 |
gldate => { type => 'date', default => 'now' }, |
|
22 |
globalproject_id => { type => 'integer' }, |
|
23 |
id => { type => 'integer', not_null => 1, sequence => 'glid' }, |
|
28 | 24 |
intnotes => { type => 'text' }, |
29 |
department_id => { type => 'integer' }, |
|
25 |
invnumber => { type => 'text', not_null => 1 }, |
|
26 |
invoice => { type => 'boolean', default => 'false' }, |
|
30 | 27 |
itime => { type => 'timestamp', default => 'now()' }, |
31 |
mtime => { type => 'timestamp' }, |
|
32 |
shipvia => { type => 'text' }, |
|
33 |
cp_id => { type => 'integer' }, |
|
34 | 28 |
language_id => { type => 'integer' }, |
29 |
mtime => { type => 'timestamp' }, |
|
30 |
netamount => { type => 'numeric', precision => 5, scale => 15 }, |
|
31 |
notes => { type => 'text' }, |
|
32 |
orddate => { type => 'date' }, |
|
33 |
ordnumber => { type => 'text' }, |
|
34 |
paid => { type => 'numeric', precision => 5, scale => 15 }, |
|
35 | 35 |
payment_id => { type => 'integer' }, |
36 |
quodate => { type => 'date' }, |
|
37 |
quonumber => { type => 'text' }, |
|
38 |
shipvia => { type => 'text' }, |
|
36 | 39 |
storno => { type => 'boolean', default => 'false' }, |
40 |
storno_id => { type => 'integer' }, |
|
41 |
taxincluded => { type => 'boolean', default => 'false' }, |
|
37 | 42 |
taxzone_id => { type => 'integer' }, |
38 |
type => { type => 'text' }, |
|
39 |
orddate => { type => 'date' }, |
|
40 |
quodate => { type => 'date' }, |
|
41 |
globalproject_id => { type => 'integer' }, |
|
42 | 43 |
transaction_description => { type => 'text' }, |
43 |
storno_id => { type => 'integer' }, |
|
44 |
direct_debit => { type => 'boolean', default => 'false' }, |
|
45 |
deliverydate => { type => 'date' }, |
|
46 |
currency_id => { type => 'integer', not_null => 1 }, |
|
44 |
transdate => { type => 'date', default => 'now' }, |
|
45 |
type => { type => 'text' }, |
|
46 |
vendor_id => { type => 'integer' }, |
|
47 | 47 |
); |
48 | 48 |
|
49 | 49 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
... | ... | |
97 | 97 |
}, |
98 | 98 |
); |
99 | 99 |
|
100 |
# __PACKAGE__->meta->initialize; |
|
101 |
|
|
102 | 100 |
1; |
103 | 101 |
; |
Auch abrufbar als: Unified diff
MetaSetup: Spalten- und Fremdschlüsselnamen alphabetisch sortieren