Revision 2cf0bf46
Von Moritz Bunkus vor fast 14 Jahren hinzugefügt
| SL/DB/MetaSetup/DeliveryOrder.pm | ||
|---|---|---|
| 36 | 36 |
is_sales => { type => 'boolean' },
|
| 37 | 37 |
itime => { type => 'timestamp', default => 'now()' },
|
| 38 | 38 |
mtime => { type => 'timestamp' },
|
| 39 |
notes_bottom => { type => 'text' },
|
|
| 40 | 39 |
taxzone_id => { type => 'integer' },
|
| 41 | 40 |
taxincluded => { type => 'boolean' },
|
| 42 | 41 |
terms => { type => 'integer' },
|
| SL/DB/MetaSetup/Invoice.pm | ||
|---|---|---|
| 54 | 54 |
storno_id => { type => 'integer' },
|
| 55 | 55 |
marge_total => { type => 'numeric', precision => 5, scale => 15 },
|
| 56 | 56 |
marge_percent => { type => 'numeric', precision => 5, scale => 15 },
|
| 57 |
notes_bottom => { type => 'text' },
|
|
| 58 | 57 |
donumber => { type => 'text' },
|
| 59 | 58 |
], |
| 60 | 59 |
|
| SL/DB/MetaSetup/Order.pm | ||
|---|---|---|
| 46 | 46 |
transaction_description => { type => 'text' },
|
| 47 | 47 |
marge_total => { type => 'numeric', precision => 5, scale => 15 },
|
| 48 | 48 |
marge_percent => { type => 'numeric', precision => 5, scale => 15 },
|
| 49 |
notes_bottom => { type => 'text' },
|
|
| 50 |
project_manager_id => { type => 'integer' },
|
|
| 51 | 49 |
], |
| 52 | 50 |
|
| 53 | 51 |
primary_key_columns => [ 'id' ], |
| ... | ... | |
| 65 | 63 |
key_columns => { globalproject_id => 'id' },
|
| 66 | 64 |
}, |
| 67 | 65 |
|
| 68 |
project_manager => {
|
|
| 69 |
class => 'SL::DB::Employee', |
|
| 70 |
key_columns => { project_manager_id => 'id' },
|
|
| 71 |
}, |
|
| 72 |
|
|
| 73 | 66 |
salesman => {
|
| 74 | 67 |
class => 'SL::DB::Employee', |
| 75 | 68 |
key_columns => { salesman_id => 'id' },
|
| SL/DB/MetaSetup/PurchaseInvoice.pm | ||
|---|---|---|
| 43 | 43 |
globalproject_id => { type => 'integer' },
|
| 44 | 44 |
transaction_description => { type => 'text' },
|
| 45 | 45 |
storno_id => { type => 'integer' },
|
| 46 |
notes_bottom => { type => 'text' },
|
|
| 47 | 46 |
], |
| 48 | 47 |
|
| 49 | 48 |
primary_key_columns => [ 'id' ], |
Auch abrufbar als: Unified diff
Die Datenbankfelder notes_bottom und project_manager_id gibt es in der offiziellen Version nicht