From 1aab83dc1f96f2b6d73a61ab14898e39b8c9dd46 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Mon, 21 Nov 2022 21:40:54 +0000 Subject: [PATCH] Bug 32292: Add column descriptions to aqorders table This adds nice descriptions to the aqorders database columns. To test: * Go to Guided reports * Start a new report for acquisitions module * Verify that all aqorders columns show with nice descriptions None should be missing. Signed-off-by: David Nind Signed-off-by: Martin Renvoize --- Koha/Database/Columns.pm | 52 ++++++++++++++++++++++++++++++++++++++++ 1 file changed, 52 insertions(+) diff --git a/Koha/Database/Columns.pm b/Koha/Database/Columns.pm index 519a215b9b5..d092b23ab15 100644 --- a/Koha/Database/Columns.pm +++ b/Koha/Database/Columns.pm @@ -58,6 +58,58 @@ to descriptions, for several tables. Currently sub columns { return { + aqorders => { + "ordernumber" => __("Order number"), + "biblionumber" => __("Biblionumber (internal)"), + "entrydate" => __("Creation date"), + "quantity" => __("Quantity"), + "currency" => __("Currency"), + "listprice" => __("Vendor price"), + "datereceived" => __("Date received"), + "invoiceid" => __("Invoice ID (internal)"), + "freight" => __("Not used (deprecated)"), + "unitprice" => __("Actual cost"), + "unitprice_tax_excluded" => __("Actual cost, tax excl."), + "unitprice_tax_included" => __("Actual cost, tax incl."), + "quantityreceived" => __("Quantity received"), + "created_by" => __("Borrower number of creator"), + "datecancellationprinted" => __("Cancellation date"), + "cancellationreason" => __("Cancellation reason"), + "order_internalnote" => __("Internal note"), + "order_vendornote" => __("Vendor note"), + "purchaseordernumber" => __("Not used (deprecated)"), + "basketno" => __("Basket ID (inernal)"), + "timestamp" => __("Timestamp"), + "rrp" => __("Retail price"), + "replacementprice" => __("Replacement price"), + "rrp_tax_excluded" => __("Retail price, tax excl."), + "rrp_tax_included" => __("Retail price, tax incl."), + "ecost" => __("Budgeted cost"), + "ecost_tax_excluded" => __("Budgeted cost, tax excl."), + "ecost_tax_included" => __("Budgeted cost, tax incl."), + "tax_rate_bak" => __("Tax rate backup (deprecated)"), + "tax_rate_on_ordering" => __("Tax rate on order"), + "tax_rate_on_receiving" => __("Tax rate on receive"), + "tax_value_bak" => __("Tax value backup (deprecated)"), + "tax_value_on_ordering" => __("Tax amount on order"), + "tax_value_on_receiving" => __("Tax amount on receive"), + "discount" => __("Discount"), + "budget_id" => __("Fund ID (internal)"), + "budgetdate" => __("Not used (deprecated)"), + "sort1" => __("Statistic 1"), + "sort2" => __("Statistic 2"), + "sort1_authcat" => __("Not used"), + "sort2_authcat" => __("Not used"), + "uncertainprice" => __("Uncertain price"), + "subscriptionid" => __("Subscription ID (internal)"), + "parent_ordernumber" => __("Parent order number (internal)"), + "orderstatus" => __("Order status"), + "line_item_id" => __("Line item ID (EDIFACT)"), + "suppliers_reference_number" => __("Vendor reference number (EDIFACT)"), + "suppliers_reference_qualifier" => __("Vendor reference qualifier (EDIFACT)"), + "suppliers_report" => __("Vendor report (EDIFACT)"), + "estimated_delivery_date" => __("Estimated delivery date"), + }, borrowers => { "borrowernumber" => __("Borrower number"), "title" => __("Salutation"), -- 2.39.1