Revision b71e18fb
Von Cem Aydin vor mehr als 1 Jahr hinzugefügt
| SL/DB/MetaSetup/PurchaseInvoice.pm | ||
|---|---|---|
|
ordnumber => { type => 'text' },
|
||
|
paid => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
|
||
|
payment_id => { type => 'integer' },
|
||
|
qrbill_data => { type => 'text' },
|
||
|
quodate => { type => 'date' },
|
||
|
quonumber => { type => 'text' },
|
||
|
shipvia => { type => 'text' },
|
||
| sql/Pg-upgrade2/ap_add_qrbill_data.sql | ||
|---|---|---|
|
-- @tag: ap_add_qrbill_data
|
||
|
-- @description: Spalte für QR-Rechnungsdaten hinzufügen (Schweiz)
|
||
|
-- @depends: release_3_7_0
|
||
|
ALTER TABLE ap ADD COLUMN qrbill_data text;
|
||
| t/workflow/invoice_to_reclamation.t | ||
|---|---|---|
|
datepaid deliverydate direct_debit duedate gldate invoice orddate ordnumber paid quodate quonumber storno storno_id type is_sepa_blocked
|
||
|
billing_address_id customer_id cv_record_number delivered closed exchangerate reqdate salesman_id shippingpoint shipto_id
|
||
|
cp_id contact_id
|
||
|
invnumber record_number
|
||
|
invnumber record_number qrbill_data
|
||
|
));
|
||
|
|
||
|
# 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