Revision e1e09249
Von Cem Aydin vor etwa 1 Jahr hinzugefügt
| SL/DB/MetaSetup/PurchaseInvoice.pm | ||
|---|---|---|
| 36 | 36 |
ordnumber => { type => 'text' },
|
| 37 | 37 |
paid => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
|
| 38 | 38 |
payment_id => { type => 'integer' },
|
| 39 |
qrbill_data => { type => 'text' },
|
|
| 39 | 40 |
quodate => { type => 'date' },
|
| 40 | 41 |
quonumber => { type => 'text' },
|
| 41 | 42 |
shipvia => { type => 'text' },
|
| sql/Pg-upgrade2/ap_add_qrbill_data.sql | ||
|---|---|---|
| 1 |
-- @tag: ap_add_qrbill_data |
|
| 2 |
-- @description: Spalte für QR-Rechnungsdaten hinzufügen (Schweiz) |
|
| 3 |
-- @depends: release_3_7_0 |
|
| 4 |
ALTER TABLE ap ADD COLUMN qrbill_data text; |
|
| t/workflow/invoice_to_reclamation.t | ||
|---|---|---|
| 272 | 272 |
datepaid deliverydate direct_debit duedate gldate invoice orddate ordnumber paid quodate quonumber storno storno_id type is_sepa_blocked |
| 273 | 273 |
billing_address_id customer_id cv_record_number delivered closed exchangerate reqdate salesman_id shippingpoint shipto_id |
| 274 | 274 |
cp_id contact_id |
| 275 |
invnumber record_number |
|
| 275 |
invnumber record_number qrbill_data
|
|
| 276 | 276 |
)); |
| 277 | 277 |
|
| 278 | 278 |
# diag Dumper($sales_invoice->strip->as_tree); |
Auch abrufbar als: Unified diff
Schweizer QR-Rechnung: Datenbankupgrade: Spalte für QR-Code Daten in Kreditorenbuchung hinzugefügt
Test t/workflow/invoice_to_reclamation.t: Spalte ignorieren