Revision 7349649b
Von Kivitendo Admin vor mehr als 8 Jahren hinzugefügt
| SL/IS.pm | ||
|---|---|---|
| 2112 | 2112 |
c.id AS customer_id, c.name AS customer, c.discount as customer_discount, c.creditlimit, |
| 2113 | 2113 |
c.email, c.cc, c.bcc, c.language_id, c.payment_id, c.delivery_term_id, |
| 2114 | 2114 |
c.street, c.zipcode, c.city, c.country, |
| 2115 |
c.notes AS intnotes, c.klass as customer_klass, c.taxzone_id, c.salesman_id, cu.name AS curr,
|
|
| 2115 |
c.notes AS intnotes, c.pricegroup_id as customer_pricegroup_id, c.taxzone_id, c.salesman_id, cu.name AS curr,
|
|
| 2116 | 2116 |
c.taxincluded_checked, c.direct_debit, |
| 2117 | 2117 |
b.discount AS tradediscount, b.description AS business |
| 2118 | 2118 |
FROM customer c |
Auch abrufbar als: Unified diff
Kunde: Datenbanktabelle "klass" nach "pricegroup_id" migriert
und einen Fremdschlüssel gesetzt.