View | Details | Raw Unified | Return to bug 24156
Collapse All | Expand All

(-)a/admin/columns_settings.yml (-979 / +1013 lines)
Lines 2-64 modules: Link Here
2
  acqui:
2
  acqui:
3
    histsearch:
3
    histsearch:
4
      histsearcht:
4
      histsearcht:
5
        -
5
        columns:
6
          columnname: order_line
6
            -
7
        -
7
              columnname: order_line
8
          columnname: status
8
            -
9
        -
9
              columnname: status
10
          columnname: basket
10
            -
11
        -
11
              columnname: basket
12
          columnname: basket_creator
12
            -
13
        -
13
              columnname: basket_creator
14
          columnname: basket_group
14
            -
15
        -
15
              columnname: basket_group
16
          columnname: invoice_number
16
            -
17
        -
17
              columnname: invoice_number
18
          columnname: summary
18
            -
19
        -
19
              columnname: summary
20
          columnname: vendor
20
            -
21
        -
21
              columnname: vendor
22
          columnname: placed_on
22
            -
23
        -
23
              columnname: placed_on
24
          columnname: received_on
24
            -
25
        -
25
              columnname: received_on
26
          columnname: quantity_received
26
            -
27
        -
27
              columnname: quantity_received
28
          columnname: pending_order
28
            -
29
        -
29
              columnname: pending_order
30
          columnname: unit_cost
30
            -
31
        -
31
              columnname: unit_cost
32
          columnname: fund
32
            -
33
              columnname: fund
33
34
34
    lateorders:
35
    lateorders:
35
      late_orders:
36
      late_orders:
36
        -
37
        columns:
37
          columnname: checkbox
38
            -
38
          cannot_be_toggled: 1
39
              columnname: checkbox
39
          cannot_be_modified: 1
40
              cannot_be_toggled: 1
40
        -
41
              cannot_be_modified: 1
41
          columnname: order_date
42
            -
42
        -
43
              columnname: order_date
43
          columnname: estimated_delivery_date
44
            -
44
        -
45
              columnname: estimated_delivery_date
45
          columnname: vendor
46
            -
46
        -
47
              columnname: vendor
47
          columnname: information
48
            -
48
        -
49
              columnname: information
49
          columnname: total_cost
50
            -
50
        -
51
              columnname: total_cost
51
          columnname: basket
52
            -
52
        -
53
              columnname: basket
53
          columnname: basket_group
54
            -
54
        -
55
              columnname: basket_group
55
          columnname: library
56
            -
56
        -
57
              columnname: library
57
          columnname: fund
58
            -
58
        -
59
              columnname: fund
59
          columnname: claims_count
60
            -
60
        -
61
              columnname: claims_count
61
          columnname: claimed_date
62
            -
63
              columnname: claimed_date
62
    basket:
64
    basket:
63
      orders:
65
      orders:
64
        default_display_length: 20
66
        default_display_length: 20
Lines 111-269 modules: Link Here
111
  admin:
113
  admin:
112
    currency:
114
    currency:
113
      currencies-table:
115
      currencies-table:
114
        -
116
        columns:
115
          columnname: currency
117
            -
116
          cannot_be_toggled: 1
118
              columnname: currency
117
          cannot_be_modified: 1
119
              cannot_be_toggled: 1
118
        -
120
              cannot_be_modified: 1
119
          columnname: rate
121
            -
120
          cannot_be_toggled: 1
122
              columnname: rate
121
          cannot_be_modified: 1
123
              cannot_be_toggled: 1
122
        -
124
              cannot_be_modified: 1
123
          columnname: symbol
125
            -
124
        -
126
              columnname: symbol
125
          columnname: iso_code
127
            -
126
          is_hidden: 1
128
              columnname: iso_code
127
        -
129
              is_hidden: 1
128
          columnname: last_updated
130
            -
129
        -
131
              columnname: last_updated
130
          columnname: active
132
            -
131
        -
133
              columnname: active
132
          columnname: actions
134
            -
135
              columnname: actions
133
136
134
    categories:
137
    categories:
135
      patron_categories:
138
      patron_categories:
136
        -
139
        columns:
137
          columnname: code
140
            -
138
        -
141
              columnname: code
139
          columnname: category_name
142
            -
140
        -
143
              columnname: category_name
141
          columnname: type
144
            -
142
        -
145
              columnname: type
143
          columnname: enrollment_period
146
            -
144
        -
147
              columnname: enrollment_period
145
          columnname: age_required
148
            -
146
        -
149
              columnname: age_required
147
          columnname: upper_age_limit
150
            -
148
        -
151
              columnname: upper_age_limit
149
          columnname: enrollment_fee
152
            -
150
        -
153
              columnname: enrollment_fee
151
          columnname: overdue
154
            -
152
        -
155
              columnname: overdue
153
          columnname: lost_items
156
            -
154
        -
157
              columnname: lost_items
155
          columnname: hold_fee
158
            -
156
        -
159
              columnname: hold_fee
157
          columnname: messaging
160
            -
158
        -
161
              columnname: messaging
159
          columnname: branches_limitations
162
            -
160
        -
163
              columnname: branches_limitations
161
          columnname: default_privacy
164
            -
162
        -
165
              columnname: default_privacy
163
          columnname: actions
166
            -
164
          cannot_be_toggled: 1
167
              columnname: actions
165
          cannot_be_modified: 1
168
              cannot_be_toggled: 1
169
              cannot_be_modified: 1
166
170
167
    itemtypes:
171
    itemtypes:
168
      table_item_type:
172
      table_item_type:
169
        -
173
        columns:
170
          columnname: image
174
            -
171
        -
175
              columnname: image
172
          columnname: code
176
            -
173
        -
177
              columnname: code
174
          columnname: description
178
            -
175
        -
179
              columnname: description
176
          columnname: search_category
180
            -
177
        -
181
              columnname: search_category
178
          columnname: not_for_loan
182
            -
179
        -
183
              columnname: not_for_loan
180
          columnname: hide_in_opac
184
            -
181
        -
185
              columnname: hide_in_opac
182
          columnname: rental_charge
186
            -
183
        -
187
              columnname: rental_charge
184
          columnname: daily_rental_charge
188
            -
185
        -
189
              columnname: daily_rental_charge
186
          columnname: hourly_rental_charge
190
            -
187
        -
191
              columnname: hourly_rental_charge
188
          columnname: default_replacement_cost
192
            -
189
        -
193
              columnname: default_replacement_cost
190
          columnname: lost_processing_fee
194
            -
191
        -
195
              columnname: lost_processing_fee
192
          columnname: checkin_message
196
            -
193
        -
197
              columnname: checkin_message
194
          columnname: library_limitations
198
            -
195
        -
199
              columnname: library_limitations
196
          columnname: actions
200
            -
197
          cannot_be_toggled: 1
201
              columnname: actions
198
          cannot_be_modified: 1
202
              cannot_be_toggled: 1
203
              cannot_be_modified: 1
199
204
200
    libraries:
205
    libraries:
201
      libraries:
206
      libraries:
202
        -
207
        columns:
203
          columnname: library_name
208
            -
204
        -
209
              columnname: library_name
205
          columnname: library_code
210
            -
206
        -
211
              columnname: library_code
207
          columnname: library_address
212
            -
208
        -
213
              columnname: library_address
209
          columnname: marc_organization_code
214
            -
210
        -
215
              columnname: marc_organization_code
211
          columnname: library_ip
216
            -
212
        -
217
              columnname: library_ip
213
          columnname: is_pickup_location
218
            -
214
        -
219
              columnname: is_pickup_location
215
          columnname: actions
220
            -
216
          cannot_be_toggled: 1
221
              columnname: actions
217
          cannot_be_modified: 1
222
              cannot_be_toggled: 1
223
              cannot_be_modified: 1
218
224
219
225
220
  catalogue:
226
  catalogue:
221
    detail:
227
    detail:
222
      acquisitiondetails-table:
228
      acquisitiondetails-table:
223
        -
229
        columns:
224
          columnname: vendor
230
            -
225
        -
231
              columnname: vendor
226
          columnname: invoice
232
            -
227
        -
233
              columnname: invoice
228
          columnname: basketgroup
234
            -
229
        -
235
              columnname: basketgroup
230
          columnname: basket
236
            -
231
        -
237
              columnname: basket
232
          columnname: ordernumber
238
            -
233
        -
239
              columnname: ordernumber
234
          columnname: creation_date
240
            -
235
        -
241
              columnname: creation_date
236
          columnname: received_data
242
            -
237
        -
243
              columnname: received_data
238
          columnname: status
244
            -
239
        -
245
              columnname: status
240
          columnname: quantity
246
            -
241
        -
247
              columnname: quantity
242
          columnname: order_internalnote
248
            -
243
        -
249
              columnname: order_internalnote
244
          columnname: subscription
250
            -
245
        -
251
              columnname: subscription
246
          columnname: subscription_callnumber
252
            -
253
              columnname: subscription_callnumber
247
254
248
      checkoutshistory-table:
255
      checkoutshistory-table:
249
        -
256
        columns:
250
          columnname: patron
257
            -
251
          cannot_be_toggled: 1
258
              columnname: patron
252
          cannot_be_modified: 1
259
              cannot_be_toggled: 1
253
        -
260
              cannot_be_modified: 1
254
          columnname: barcode
261
            -
255
          cannot_be_toggled: 1
262
              columnname: barcode
256
          cannot_be_modified: 1
263
              cannot_be_toggled: 1
257
        -
264
              cannot_be_modified: 1
258
          columnname: checked_out_from
265
            -
259
        -
266
              columnname: checked_out_from
260
          columnname: renewed
267
            -
261
        -
268
              columnname: renewed
262
          columnname: checkout_on
269
            -
263
        -
270
              columnname: checkout_on
264
          columnname: due_date
271
            -
265
        -
272
              columnname: due_date
266
          columnname: checkin_on
273
            -
274
              columnname: checkin_on
267
275
268
  cataloguing:
276
  cataloguing:
269
    additem:
277
    additem:
Lines 272-1127 modules: Link Here
272
        # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
280
        # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
273
        # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
281
        # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
274
        # reserves.
282
        # reserves.
275
        -
283
        columns:
276
          columnname: barcode
284
            -
277
        -
285
              columnname: barcode
278
          columnname: dateaccessioned
286
            -
279
        -
287
              columnname: dateaccessioned
280
          columnname: booksellerid
288
            -
281
        -
289
              columnname: booksellerid
282
          columnname: homebranch
290
            -
283
        -
291
              columnname: homebranch
284
          columnname: price
292
            -
285
        -
293
              columnname: price
286
          columnname: replacementprice
294
            -
287
        -
295
              columnname: replacementprice
288
          columnname: replacementpricedate
296
            -
289
        -
297
              columnname: replacementpricedate
290
          columnname: datelastborrowed
298
            -
291
        -
299
              columnname: datelastborrowed
292
          columnname: datelastseen
300
            -
293
        -
301
              columnname: datelastseen
294
          columnname: stack
302
            -
295
        -
303
              columnname: stack
296
          columnname: notforloan
304
            -
297
        -
305
              columnname: notforloan
298
          columnname: damaged
306
            -
299
        -
307
              columnname: damaged
300
          columnname: itemlost
308
            -
301
        -
309
              columnname: itemlost
302
          columnname: withdrawn
310
            -
303
        -
311
              columnname: withdrawn
304
          columnname: itemcallnumber
312
            -
305
        -
313
              columnname: itemcallnumber
306
          columnname: coded_location_qualifier
314
            -
307
        -
315
              columnname: coded_location_qualifier
308
          columnname: restricted
316
            -
309
        -
317
              columnname: restricted
310
          columnname: itemnotes
318
            -
311
        -
319
              columnname: itemnotes
312
          columnname: itemnotes_nonpublic
320
            -
313
        -
321
              columnname: itemnotes_nonpublic
314
          columnname: holdingbranch
322
            -
315
        -
323
              columnname: holdingbranch
316
          columnname: timestamp
324
            -
317
        -
325
              columnname: timestamp
318
          columnname: location
326
            -
319
        -
327
              columnname: location
320
          columnname: onloan
328
            -
321
        -
329
              columnname: onloan
322
          columnname: cn_source
330
            -
323
        -
331
              columnname: cn_source
324
          columnname: ccode
332
            -
325
        -
333
              columnname: ccode
326
          columnname: materials
334
            -
327
        -
335
              columnname: materials
328
          columnname: uri
336
            -
329
        -
337
              columnname: uri
330
          columnname: itype
338
            -
331
        -
339
              columnname: itype
332
          columnname: enumchron
340
            -
333
        -
341
              columnname: enumchron
334
          columnname: copynumber
342
            -
335
        -
343
              columnname: copynumber
336
          columnname: stocknumber
344
            -
345
              columnname: stocknumber
337
346
338
    z3950_search:
347
    z3950_search:
339
      resultst:
348
      resultst:
340
        -
349
        columns:
341
          columnname: server
350
            -
342
        -
351
              columnname: server
343
          columnname: title
352
            -
344
        -
353
              columnname: title
345
          columnname: author
354
            -
346
        -
355
              columnname: author
347
          columnname: date
356
            -
348
        -
357
              columnname: date
349
          columnname: edition
358
            -
350
        -
359
              columnname: edition
351
          columnname: isbn
360
            -
352
        -
361
              columnname: isbn
353
          columnname: lccn
362
            -
354
        -
363
              columnname: lccn
355
          columnname: actions
364
            -
356
          cannot_be_toggled: 1
365
              columnname: actions
357
          cannot_be_modified: 1
366
              cannot_be_toggled: 1
367
              cannot_be_modified: 1
358
368
359
  coursereserves:
369
  coursereserves:
360
    courses:
370
    courses:
361
      course_reserves_table:
371
      course_reserves_table:
362
        -
372
        columns:
363
          columnname: name
373
            -
364
        -
374
              columnname: name
365
          columnname: department
375
            -
366
        -
376
              columnname: department
367
          columnname: course_no
377
            -
368
        -
378
              columnname: course_no
369
          columnname: section
379
            -
370
        -
380
              columnname: section
371
          columnname: term
381
            -
372
        -
382
              columnname: term
373
          columnname: instructors
383
            -
374
        -
384
              columnname: instructors
375
          columnname: staff_note
385
            -
376
        -
386
              columnname: staff_note
377
          columnname: public_note
387
            -
378
        -
388
              columnname: public_note
379
          columnname: no_of_students
389
            -
380
        -
390
              columnname: no_of_students
381
          columnname: enabled
391
            -
392
              columnname: enabled
382
393
383
    reserves:
394
    reserves:
384
      course_reserves_table:
395
      course_reserves_table:
385
        -
396
        columns:
386
          columnname: title
397
            -
387
        -
398
              columnname: title
388
         columnname: author
399
            -
389
        -
400
             columnname: author
390
          columnname: barcode
401
            -
391
        -
402
              columnname: barcode
392
          columnname: call_number
403
            -
393
        -
404
              columnname: call_number
394
          columnname: item_type
405
            -
395
        -
406
              columnname: item_type
396
          columnname: collection
407
            -
397
        -
408
              columnname: collection
398
          columnname: location
409
            -
399
        -
410
              columnname: location
400
          columnname: library
411
            -
401
        -
412
              columnname: library
402
          columnname: staff_note
413
            -
403
        -
414
              columnname: staff_note
404
          columnname: public_note
415
            -
405
        -
416
              columnname: public_note
406
          columnname: link
417
            -
407
        -
418
              columnname: link
408
          columnname: other_course_reserves
419
            -
409
        -
420
              columnname: other_course_reserves
410
          columnname: actions
421
            -
411
          cannot_be_toggled: 1
422
              columnname: actions
412
          cannot_be_modified: 1
423
              cannot_be_toggled: 1
424
              cannot_be_modified: 1
413
425
414
  illrequests:
426
  illrequests:
415
    ill-requests:
427
    ill-requests:
416
      ill-requests:
428
      ill-requests:
417
        -
429
        columns:
418
          columnname: illrequest_id
430
            -
419
        -
431
              columnname: illrequest_id
420
          columnname: metadata_author
432
            -
421
        -
433
              columnname: metadata_author
422
          columnname: metadata_title
434
            -
423
        -
435
              columnname: metadata_title
424
          columnname: metadata_article_title
436
            -
425
        -
437
              columnname: metadata_article_title
426
          columnname: metadata_issue
438
            -
427
        -
439
              columnname: metadata_issue
428
          columnname: metadata_volume
440
            -
429
        -
441
              columnname: metadata_volume
430
          columnname: metadata_year
442
            -
431
        -
443
              columnname: metadata_year
432
          columnname: metadata_pages
444
            -
433
        -
445
              columnname: metadata_pages
434
          columnname: metadata_type
446
            -
435
        -
447
              columnname: metadata_type
436
          columnname: orderid
448
            -
437
        -
449
              columnname: orderid
438
          columnname: patron
450
            -
439
        -
451
              columnname: patron
440
          columnname: biblio_id
452
            -
441
        -
453
              columnname: biblio_id
442
          columnname: library_branchname
454
            -
443
        -
455
              columnname: library_branchname
444
          columnname: status
456
            -
445
        -
457
              columnname: status
446
          columnname: placed
458
            -
447
          cannot_be_toggled: 1
459
              columnname: placed
448
          cannot_be_modified: 1
460
              cannot_be_toggled: 1
449
          is_hidden: 1
461
              cannot_be_modified: 1
450
        -
462
              is_hidden: 1
451
          columnname: placed_formatted
463
            -
452
        -
464
              columnname: placed_formatted
453
          columnname: updated
465
            -
454
          cannot_be_toggled: 1
466
              columnname: updated
455
          cannot_be_modified: 1
467
              cannot_be_toggled: 1
456
          is_hidden: 1
468
              cannot_be_modified: 1
457
        -
469
              is_hidden: 1
458
          columnname: updated_formatted
470
            -
459
        -
471
              columnname: updated_formatted
460
          columnname: replied
472
            -
461
        -
473
              columnname: replied
462
          columnname: completed
474
            -
463
          cannot_be_toggled: 1
475
              columnname: completed
464
          cannot_be_modified: 1
476
              cannot_be_toggled: 1
465
          is_hidden: 1
477
              cannot_be_modified: 1
466
        -
478
              is_hidden: 1
467
          columnname: completed_formatted
479
            -
468
        -
480
              columnname: completed_formatted
469
          columnname: accessurl
481
            -
470
        -
482
              columnname: accessurl
471
          columnname: cost
483
            -
472
        -
484
              columnname: cost
473
          columnname: comments
485
            -
474
        -
486
              columnname: comments
475
          columnname: notesopac
487
            -
476
        -
488
              columnname: notesopac
477
          columnname: notesstaff
489
            -
478
        -
490
              columnname: notesstaff
479
          columnname: backend
491
            -
480
        -
492
              columnname: backend
481
          columnname: action
493
            -
482
          cannot_be_toggled: 1
494
              columnname: action
483
          cannot_be_modified: 1
495
              cannot_be_toggled: 1
496
              cannot_be_modified: 1
484
497
485
  members:
498
  members:
486
    fines:
499
    fines:
487
      account-fines:
500
      account-fines:
488
        -
501
        columns:
489
          columnname: date
502
            -
490
        -
503
              columnname: date
491
          columnname: description
504
            -
492
        -
505
              columnname: description
493
          columnname: barcode
506
            -
494
        -
507
              columnname: barcode
495
          columnname: date_due
508
            -
496
        -
509
              columnname: date_due
497
          columnname: returndate
510
            -
498
        -
511
              columnname: returndate
499
          columnname: note
512
            -
500
        -
513
              columnname: note
501
          columnname: amount
514
            -
502
          cannot_be_toggled: 1
515
              columnname: amount
503
          cannot_be_modified: 1
516
              cannot_be_toggled: 1
504
        -
517
              cannot_be_modified: 1
505
          columnname: amountoutstanding
518
            -
506
          cannot_be_toggled: 1
519
              columnname: amountoutstanding
507
          cannot_be_modified: 1
520
              cannot_be_toggled: 1
508
        -
521
              cannot_be_modified: 1
509
          columnname: actions
522
            -
510
          cannot_be_toggled: 1
523
              columnname: actions
511
          cannot_be_modified: 1
524
              cannot_be_toggled: 1
525
              cannot_be_modified: 1
512
526
513
    pay:
527
    pay:
514
      pay-fines-table:
528
      pay-fines-table:
515
        -
529
        columns:
516
          columnname: checkbox
530
            -
517
          cannot_be_toggled: 1
531
              columnname: checkbox
518
          cannot_be_modified: 1
532
              cannot_be_toggled: 1
519
        -
533
              cannot_be_modified: 1
520
          columnname: actions
534
            -
521
          cannot_be_toggled: 1
535
              columnname: actions
522
          cannot_be_modified: 1
536
              cannot_be_toggled: 1
523
        -
537
              cannot_be_modified: 1
524
          columnname: description
538
            -
525
        -
539
              columnname: description
526
          columnname: date
540
            -
527
        -
541
              columnname: date
528
          columnname: barcode
542
            -
529
        -
543
              columnname: barcode
530
          columnname: date_due
544
            -
531
        -
545
              columnname: date_due
532
          columnname: returndate
546
            -
533
        -
547
              columnname: returndate
534
          columnname: note
548
            -
535
        -
549
              columnname: note
536
          columnname: account_type
550
            -
537
        -
551
              columnname: account_type
538
          columnname: amount
552
            -
539
        -
553
              columnname: amount
540
          columnname: amountoutstanding
554
            -
541
555
              columnname: amountoutstanding
542
    member:
556
543
      memberresultst:
557
    member:
544
        -
558
      memberresultst:
545
          columnname: checkbox
559
        columns:
546
          cannot_be_toggled: 1
560
            -
547
          cannot_be_modified: 1
561
              columnname: checkbox
548
        -
562
              cannot_be_toggled: 1
549
          columnname: cardnumber
563
              cannot_be_modified: 1
550
        -
564
            -
551
          columnname: name
565
              columnname: cardnumber
552
        -
566
            -
553
          columnname: dateofbirth
567
              columnname: name
554
        -
568
            -
555
          columnname: category
569
              columnname: dateofbirth
556
        -
570
            -
557
          columnname: library
571
              columnname: category
558
        -
572
            -
559
          columnname: expires_on
573
              columnname: library
560
        -
574
            -
561
          columnname: od_checkouts
575
              columnname: expires_on
562
        -
576
            -
563
          columnname: fines
577
              columnname: od_checkouts
564
        -
578
            -
565
          columnname: circ_notes
579
              columnname: fines
566
        -
580
            -
567
          columnname: actions
581
              columnname: circ_notes
568
          cannot_be_toggled: 1
582
            -
569
          cannot_be_modified: 1
583
              columnname: actions
570
584
              cannot_be_toggled: 1
571
    moremember:
585
              cannot_be_modified: 1
572
      issues-table:
586
573
        -
587
    moremember:
574
          columnname: sort_order
588
      issues-table:
575
          cannot_be_toggled: 1
589
        columns:
576
          cannot_be_modified: 1
590
            -
577
          is_hidden: 1
591
              columnname: sort_order
578
        -
592
              cannot_be_toggled: 1
579
          columnname: todays_or_previous_checkouts
593
              cannot_be_modified: 1
580
          cannot_be_toggled: 1
594
              is_hidden: 1
581
          cannot_be_modified: 1
595
            -
582
          is_hidden: 1
596
              columnname: todays_or_previous_checkouts
583
        -
597
              cannot_be_toggled: 1
584
          columnname: due_date_unformatted
598
              cannot_be_modified: 1
585
          cannot_be_toggled: 1
599
              is_hidden: 1
586
          cannot_be_modified: 1
600
            -
587
          is_hidden: 1
601
              columnname: due_date_unformatted
588
        -
602
              cannot_be_toggled: 1
589
          columnname: due_date
603
              cannot_be_modified: 1
590
        -
604
              is_hidden: 1
591
          columnname: title
605
            -
592
        -
606
              columnname: due_date
593
          columnname: record_type
607
            -
594
        -
608
              columnname: title
595
          columnname: item_type
609
            -
596
        -
610
              columnname: record_type
597
          columnname: collection
611
            -
598
        -
612
              columnname: item_type
599
          columnname: location
613
            -
600
        -
614
              columnname: collection
601
          columnname: homebranch
615
            -
602
        -
616
              columnname: location
603
          columnname: checkout_on_unformatted
617
            -
604
          cannot_be_toggled: 1
618
              columnname: homebranch
605
          cannot_be_modified: 1
619
            -
606
          is_hidden: 1
620
              columnname: checkout_on_unformatted
607
        -
621
              cannot_be_toggled: 1
608
          columnname: checkout_on
622
              cannot_be_modified: 1
609
        -
623
              is_hidden: 1
610
          columnname: checkout_from
624
            -
611
        -
625
              columnname: checkout_on
612
          columnname: callno
626
            -
613
        -
627
              columnname: checkout_from
614
          columnname: charge
628
            -
615
        -
629
              columnname: callno
616
          columnname: fine
630
            -
617
        -
631
              columnname: charge
618
          columnname: price
632
            -
619
        -
633
              columnname: fine
620
          columnname: renew
634
            -
621
          cannot_be_toggled: 1
635
              columnname: price
622
          cannot_be_modified: 1
636
            -
623
        -
637
              columnname: renew
624
          columnname: checkin
638
              cannot_be_toggled: 1
625
        -
639
              cannot_be_modified: 1
626
          columnname: export
640
            -
627
          cannot_be_toggled: 1
641
              columnname: checkin
628
          cannot_be_modified: 1
642
            -
629
643
              columnname: export
630
    holdshistory:
644
              cannot_be_toggled: 1
631
      holdshistory-table:
645
              cannot_be_modified: 1
632
        -
646
633
          columnname: title
647
    holdshistory:
634
          cannot_be_toggled: 1
648
      holdshistory-table:
635
          cannot_be_modified: 1
649
        columns:
636
        -
650
            -
637
          columnname: author
651
              columnname: title
638
        -
652
              cannot_be_toggled: 1
639
          columnname: barcode
653
              cannot_be_modified: 1
640
        -
654
            -
641
          columnname: branch
655
              columnname: author
642
        -
656
            -
643
          columnname: reservedate
657
              columnname: barcode
644
        -
658
            -
645
          columnname: expirationdate
659
              columnname: branch
646
        -
660
            -
647
          columnname: waitingdate
661
              columnname: reservedate
648
        -
662
            -
649
          columnname: cancellationdate
663
              columnname: expirationdate
650
        -
664
            -
651
          columnname: itemtype
665
              columnname: waitingdate
652
        -
666
            -
653
          columnname: status
667
              columnname: cancellationdate
654
668
            -
655
    checkouthistory:
669
              columnname: itemtype
656
      checkouthistory-table:
670
            -
657
        - columnname: type
671
              columnname: status
658
          cannot_be_toggled: 1
672
659
          cannot_be_modified: 1
673
    checkouthistory:
660
        -
674
      checkouthistory-table:
661
          columnname: date
675
        columns:
662
        -
676
            - columnname: type
663
          columnname: title
677
              cannot_be_toggled: 1
664
        -
678
              cannot_be_modified: 1
665
          columnname: author
679
            -
666
        -
680
              columnname: date
667
          columnname: call_number
681
            -
668
        -
682
              columnname: title
669
          columnname: barcode
683
            -
670
        -
684
              columnname: author
671
          columnname: number_of_renewals
685
            -
672
        -
686
              columnname: call_number
673
          columnname: checked_out_on
687
            -
674
        -
688
              columnname: barcode
675
          columnname: checked_out_from
689
            -
676
        -
690
              columnname: number_of_renewals
677
          columnname: date_due
691
            -
678
        -
692
              columnname: checked_out_on
679
          columnname: return_date
693
            -
680
694
              columnname: checked_out_from
681
    patron-lists:
695
            -
682
      patron-list-table:
696
              columnname: date_due
683
        -
697
            -
684
          columnname: checkbox
698
              columnname: return_date
685
          cannot_be_toggled: 1
699
686
          cannot_be_modified: 1
700
    patron-lists:
687
        -
701
      patron-list-table:
688
          columnname: card
702
        columns:
689
        -
703
            -
690
          columnname: firstname
704
              columnname: checkbox
691
        -
705
              cannot_be_toggled: 1
692
          columnname: surname
706
              cannot_be_modified: 1
693
        -
707
            -
694
          columnname: address
708
              columnname: card
695
        -
709
            -
696
          columnname: category
710
              columnname: firstname
697
        -
711
            -
698
          columnname: library
712
              columnname: surname
699
        -
713
            -
700
          columnname: expires_on
714
              columnname: address
701
        -
715
            -
702
          columnname: circ_notes
716
              columnname: category
717
            -
718
              columnname: library
719
            -
720
              columnname: expires_on
721
            -
722
              columnname: circ_notes
703
723
704
  reports:
724
  reports:
705
    lostitems:
725
    lostitems:
706
      lostitems-table:
726
      lostitems-table:
707
        -
727
        columns:
708
          columnname: title
728
            -
709
          cannot_be_toggled: 1
729
              columnname: title
710
          cannot_be_modified: 1
730
              cannot_be_toggled: 1
711
        -
731
              cannot_be_modified: 1
712
          columnname: author
732
            -
713
        -
733
              columnname: author
714
          columnname: lostcode
734
            -
715
        -
735
              columnname: lostcode
716
          columnname: itemlost_on
736
            -
717
        -
737
              columnname: itemlost_on
718
          columnname: barcode
738
            -
719
        -
739
              columnname: barcode
720
          columnname: callnumber
740
            -
721
        -
741
              columnname: callnumber
722
          columnname: datelastseen
742
            -
723
        -
743
              columnname: datelastseen
724
          columnname: price
744
            -
725
        -
745
              columnname: price
726
          columnname: replacementprice
746
            -
727
        -
747
              columnname: replacementprice
728
          columnname: library
748
            -
729
        -
749
              columnname: library
730
          columnname: itemtype
750
            -
731
        -
751
              columnname: itemtype
732
          columnname: collection_code
752
            -
733
        -
753
              columnname: collection_code
734
          columnname: current_location
754
            -
735
        -
755
              columnname: current_location
736
          columnname: location
756
            -
737
        -
757
              columnname: location
738
          columnname: notforloan
758
            -
739
        -
759
              columnname: notforloan
740
          columnname: notes
760
            -
761
              columnname: notes
741
762
742
    saved-sql:
763
    saved-sql:
743
      table_reports:
764
      table_reports:
744
        -
765
        columns:
745
          columnname: selection
766
            -
746
          cannot_be_toggled: 1
767
              columnname: selection
747
          cannot_be_modified: 1
768
              cannot_be_toggled: 1
748
        -
769
              cannot_be_modified: 1
749
          columnname: report_id
770
            -
750
          cannot_be_toggled: 1
771
              columnname: report_id
751
          cannot_be_modified: 1
772
              cannot_be_toggled: 1
752
        -
773
              cannot_be_modified: 1
753
          columnname: report_name
774
            -
754
        -
775
              columnname: report_name
755
          columnname: type
776
            -
756
        -
777
              columnname: type
757
          columnname: group
778
            -
758
        -
779
              columnname: group
759
          columnname: subgroup
780
            -
760
        -
781
              columnname: subgroup
761
          columnname: notes
782
            -
762
        -
783
              columnname: notes
763
          columnname: author
784
            -
764
        -
785
              columnname: author
765
          columnname: creation_date
786
            -
766
        -
787
              columnname: creation_date
767
          columnname: last_edit
788
            -
768
        -
789
              columnname: last_edit
769
          columnname: last_run
790
            -
770
        -
791
              columnname: last_run
771
          columnname: public
792
            -
772
        -
793
              columnname: public
773
          columnname: json_url
794
            -
774
        -
795
              columnname: json_url
775
          columnname: cache_expiry
796
            -
776
        -
797
              columnname: cache_expiry
777
          columnname: saved_results
798
            -
778
        -
799
              columnname: saved_results
779
          columnname: update
800
            -
780
        -
801
              columnname: update
781
          columnname: actions
802
            -
782
          cannot_be_toggled: 1
803
              columnname: actions
783
          cannot_be_modified: 1
804
              cannot_be_toggled: 1
805
              cannot_be_modified: 1
784
806
785
  circ:
807
  circ:
786
    circulation:
808
    circulation:
787
      issues-table:
809
      issues-table:
788
        -
810
        columns:
789
          columnname: sort_order
811
            -
790
          cannot_be_toggled: 1
812
              columnname: sort_order
791
          cannot_be_modified: 1
813
              cannot_be_toggled: 1
792
          is_hidden: 1
814
              cannot_be_modified: 1
793
        -
815
              is_hidden: 1
794
          columnname: todays_or_previous_checkouts
816
            -
795
          cannot_be_toggled: 1
817
              columnname: todays_or_previous_checkouts
796
          cannot_be_modified: 1
818
              cannot_be_toggled: 1
797
          is_hidden: 1
819
              cannot_be_modified: 1
798
        -
820
              is_hidden: 1
799
          columnname: due_date_unformatted
821
            -
800
          cannot_be_toggled: 1
822
              columnname: due_date_unformatted
801
          cannot_be_modified: 1
823
              cannot_be_toggled: 1
802
          is_hidden: 1
824
              cannot_be_modified: 1
803
        -
825
              is_hidden: 1
804
          columnname: due_date
826
            -
805
        -
827
              columnname: due_date
806
          columnname: title
828
            -
807
        -
829
              columnname: title
808
          columnname: record_type
830
            -
809
        -
831
              columnname: record_type
810
          columnname: item_type
832
            -
811
        -
833
              columnname: item_type
812
          columnname: collection
834
            -
813
        -
835
              columnname: collection
814
          columnname: location
836
            -
815
        -
837
              columnname: location
816
          columnname: homebranch
838
            -
817
        -
839
              columnname: homebranch
818
          columnname: checkout_on_unformatted
840
            -
819
          cannot_be_toggled: 1
841
              columnname: checkout_on_unformatted
820
          cannot_be_modified: 1
842
              cannot_be_toggled: 1
821
          is_hidden: 1
843
              cannot_be_modified: 1
822
        -
844
              is_hidden: 1
823
          columnname: checkout_on
845
            -
824
        -
846
              columnname: checkout_on
825
          columnname: checkout_from
847
            -
826
        -
848
              columnname: checkout_from
827
          columnname: callno
849
            -
828
        -
850
              columnname: callno
829
          columnname: charge
851
            -
830
        -
852
              columnname: charge
831
          columnname: fine
853
            -
832
        -
854
              columnname: fine
833
          columnname: price
855
            -
834
        -
856
              columnname: price
835
          columnname: renew
857
            -
836
          cannot_be_toggled: 1
858
              columnname: renew
837
          cannot_be_modified: 1
859
              cannot_be_toggled: 1
838
        -
860
              cannot_be_modified: 1
839
          columnname: checkin
861
            -
840
        -
862
              columnname: checkin
841
          columnname: export
863
            -
842
          cannot_be_toggled: 1
864
              columnname: export
843
          cannot_be_modified: 1
865
              cannot_be_toggled: 1
866
              cannot_be_modified: 1
844
      table_borrowers:
867
      table_borrowers:
845
        -
868
        columns:
846
          columnname: name
869
            -
847
          cannot_be_toggled: 1
870
              columnname: name
848
          cannot_be_modified: 1
871
              cannot_be_toggled: 1
849
        -
872
              cannot_be_modified: 1
850
          columnname: cardnumber
873
            -
851
        -
874
              columnname: cardnumber
852
          columnname: date_of_birth
875
            -
853
        -
876
              columnname: date_of_birth
854
          columnname: category
877
            -
855
        -
878
              columnname: category
856
          columnname: library
879
            -
857
        -
880
              columnname: library
858
          columnname: address
881
            -
859
        -
882
              columnname: address
860
          columnname: phone
883
            -
861
          is_hidden: 1
884
              columnname: phone
885
              is_hidden: 1
862
    returns:
886
    returns:
863
      checkedintable:
887
      checkedintable:
864
        -
888
        columns:
865
          columnname: due_date
889
            -
866
        -
890
              columnname: due_date
867
          columnname: title
891
            -
868
        -
892
              columnname: title
869
          columnname: author
893
            -
870
        -
894
              columnname: author
871
          columnname: barcode
895
            -
872
        -
896
              columnname: barcode
873
          columnname: homelibrary
897
            -
874
        -
898
              columnname: homelibrary
875
          columnname: holdinglibrary
899
            -
876
        -
900
              columnname: holdinglibrary
877
          columnname: location
901
            -
878
        -
902
              columnname: location
879
          columnname: itemcallnumber
903
            -
880
        -
904
              columnname: itemcallnumber
881
          columnname: dateaccessioned
905
            -
882
          is_hidden: 1
906
              columnname: dateaccessioned
883
        -
907
              is_hidden: 1
884
          columnname: record_type
908
            -
885
        -
909
              columnname: record_type
886
          columnname: itype
910
            -
887
        -
911
              columnname: itype
888
          columnname: borrower
912
            -
889
        -
913
              columnname: borrower
890
          columnname: itemnote
914
            -
915
              columnname: itemnote
891
916
892
    view_holdsqueue:
917
    view_holdsqueue:
893
      holds-table:
918
      holds-table:
894
        -
919
        columns:
895
          columnname: title
920
            -
896
        -
921
              columnname: title
897
          columnname: collection
922
            -
898
        -
923
              columnname: collection
899
          columnname: document_type
924
            -
900
        -
925
              columnname: document_type
901
          columnname: callnumber
926
            -
902
        -
927
              columnname: callnumber
903
          columnname: copynumber
928
            -
904
        -
929
              columnname: copynumber
905
          columnname: enumeration
930
            -
906
        -
931
              columnname: enumeration
907
          columnname: barcode
932
            -
908
        -
933
              columnname: barcode
909
          columnname: patron
934
            -
910
        -
935
              columnname: patron
911
          columnname: send_to
936
            -
912
        -
937
              columnname: send_to
913
          columnname: date
938
            -
914
        -
939
              columnname: date
915
          columnname: notes
940
            -
941
              columnname: notes
916
942
917
    holds:
943
    holds:
918
      holds-to-pull:
944
      holds-to-pull:
919
        -
945
        columns:
920
          columnname: pull_items
946
            -
921
        -
947
              columnname: pull_items
922
          columnname: avalaible_items
948
            -
923
        -
949
              columnname: avalaible_items
924
          columnname: patrons
950
            -
925
        -
951
              columnname: patrons
926
          columnname: patron
952
            -
927
        -
953
              columnname: patron
928
          columnname: title
954
            -
929
        -
955
              columnname: title
930
          columnname: libraries
956
            -
931
        -
957
              columnname: libraries
932
          columnname: call_numbers
958
            -
933
        -
959
              columnname: call_numbers
934
          columnname: copy_numbers
960
            -
935
        -
961
              columnname: copy_numbers
936
          columnname: enumeration
962
            -
937
        -
963
              columnname: enumeration
938
          columnname: itemtypes
964
            -
939
        -
965
              columnname: itemtypes
940
          columnname: locations
966
            -
941
        -
967
              columnname: locations
942
          columnname: hold_date
968
            -
943
        -
969
              columnname: hold_date
944
          columnname: action
970
            -
971
              columnname: action
945
972
946
    holdsratios:
973
    holdsratios:
947
      holds-ratios:
974
      holds-ratios:
948
        -
975
        columns:
949
          columnname: holds
976
            -
950
        -
977
              columnname: holds
951
          columnname: items
978
            -
952
        -
979
              columnname: items
953
          columnname: holds_ratio
980
            -
954
        -
981
              columnname: holds_ratio
955
          columnname: title
982
            -
956
        -
983
              columnname: title
957
          columnname: home_libraries
984
            -
958
        -
985
              columnname: home_libraries
959
          columnname: holding_libraries
986
            -
960
        -
987
              columnname: holding_libraries
961
          columnname: location
988
            -
962
        -
989
              columnname: location
963
          columnname: itemtype
990
            -
964
        -
991
              columnname: itemtype
965
          columnname: call_numbers
992
            -
966
        -
993
              columnname: call_numbers
967
          columnname: items_needed
994
            -
995
              columnname: items_needed
968
996
969
    overdues:
997
    overdues:
970
      circ-overdues:
998
      circ-overdues:
971
        -
999
        columns:
972
          columnname: due_date
1000
            -
973
        -
1001
              columnname: due_date
974
          columnname: patron
1002
            -
975
        -
1003
              columnname: patron
976
          columnname: patron_category
1004
            -
977
          is_hidden: 1
1005
              columnname: patron_category
978
        -
1006
              is_hidden: 1
979
          columnname: patron_library
1007
            -
980
        -
1008
              columnname: patron_library
981
          columnname: title
1009
            -
982
        -
1010
              columnname: title
983
          columnname: home_library
1011
            -
984
          is_hidden: 1
1012
              columnname: home_library
985
        -
1013
              is_hidden: 1
986
          columnname: holding_library
1014
            -
987
          is_hidden: 1
1015
              columnname: holding_library
988
        -
1016
              is_hidden: 1
989
          columnname: barcode
1017
            -
990
        -
1018
              columnname: barcode
991
          columnname: call_number
1019
            -
992
        -
1020
              columnname: call_number
993
          columnname: item_type
1021
            -
994
          is_hidden: 1
1022
              columnname: item_type
995
        -
1023
              is_hidden: 1
996
          columnname: price
1024
            -
997
        -
1025
              columnname: price
998
          columnname: non-public_note
1026
            -
1027
              columnname: non-public_note
999
1028
1000
  opac:
1029
  opac:
1001
    biblio-detail:
1030
    biblio-detail:
1002
      holdingst:
1031
      holdingst:
1003
        -
1032
        columns:
1004
          columnname: item_itemtype
1033
            -
1005
        -
1034
              columnname: item_itemtype
1006
          columnname: item_current_location
1035
            -
1007
        -
1036
              columnname: item_current_location
1008
          columnname: item_home_location
1037
            -
1009
        -
1038
              columnname: item_home_location
1010
          columnname: item_shelving_location
1039
            -
1011
          is_hidden: 1
1040
              columnname: item_shelving_location
1012
        -
1041
              is_hidden: 1
1013
          columnname: item_ccode
1042
            -
1014
        -
1043
              columnname: item_ccode
1015
          columnname: item_callnumber
1044
            -
1016
        -
1045
              columnname: item_callnumber
1017
          columnname: item_enumchron
1046
            -
1018
        -
1047
              columnname: item_enumchron
1019
          columnname: item_url
1048
            -
1020
        -
1049
              columnname: item_url
1021
          columnname: item_copy
1050
            -
1022
        -
1051
              columnname: item_copy
1023
          columnname: item_status
1052
            -
1024
        -
1053
              columnname: item_status
1025
          columnname: item_notes
1054
            -
1026
        -
1055
              columnname: item_notes
1027
          columnname: item_datedue
1056
            -
1028
        -
1057
              columnname: item_datedue
1029
          columnname: item_barcode
1058
            -
1030
          is_hidden: 1
1059
              columnname: item_barcode
1031
        -
1060
              is_hidden: 1
1032
          columnname: item_holds
1061
            -
1033
        -
1062
              columnname: item_holds
1034
          columnname: item_priority
1063
            -
1035
        -
1064
              columnname: item_priority
1036
          columnname: item_coursereserves
1065
            -
1066
              columnname: item_coursereserves
1037
1067
1038
      subscriptionst:
1068
      subscriptionst:
1039
        -
1069
        columns:
1040
          columnname: serial_serialseq
1070
            -
1041
        -
1071
              columnname: serial_serialseq
1042
          columnname: serial_publisheddate
1072
            -
1043
        -
1073
              columnname: serial_publisheddate
1044
          columnname: serial_planneddate
1074
            -
1045
        -
1075
              columnname: serial_planneddate
1046
          columnname: serial_status
1076
            -
1047
        -
1077
              columnname: serial_status
1048
          columnname: serial_notes
1078
            -
1079
              columnname: serial_notes
1049
1080
1050
  serials:
1081
  serials:
1051
    subscription-detail:
1082
    subscription-detail:
1052
      orders:
1083
      orders:
1053
        -
1084
        columns:
1054
          columnname: invoice
1085
            -
1055
        -
1086
              columnname: invoice
1056
          columnname: basket
1087
            -
1057
        -
1088
              columnname: basket
1058
          columnname: ordernumber
1089
            -
1059
        -
1090
              columnname: ordernumber
1060
          columnname: creation_date
1091
            -
1061
        -
1092
              columnname: creation_date
1062
          columnname: receive_date
1093
            -
1063
        -
1094
              columnname: receive_date
1064
          columnname: status
1095
            -
1065
        -
1096
              columnname: status
1066
          columnname: order_internalnote
1097
            -
1067
        -
1098
              columnname: order_internalnote
1068
          columnname: order_vendornote
1099
            -
1069
        -
1100
              columnname: order_vendornote
1070
          columnname: fund
1101
            -
1071
        -
1102
              columnname: fund
1072
          columnname: ordered
1103
            -
1073
        -
1104
              columnname: ordered
1074
          columnname: spent
1105
            -
1106
              columnname: spent
1075
1107
1076
  tools:
1108
  tools:
1077
    notices:
1109
    notices:
1078
      lettert:
1110
      lettert:
1079
        -
1111
        columns:
1080
          columnname: library
1112
            -
1081
        -
1113
              columnname: library
1082
          columnname: module
1114
            -
1083
        -
1115
              columnname: module
1084
          columnname: code
1116
            -
1085
        -
1117
              columnname: code
1086
          columnname: name
1118
            -
1087
        -
1119
              columnname: name
1088
          columnname: copy_notice
1120
            -
1089
        -
1121
              columnname: copy_notice
1090
          columnname: actions
1122
            -
1091
          cannot_be_toggled: 1
1123
              columnname: actions
1092
          cannot_be_modified: 1
1124
              cannot_be_toggled: 1
1125
              cannot_be_modified: 1
1093
1126
1094
    stockrotation:
1127
    stockrotation:
1095
      stock_rotation:
1128
      stock_rotation:
1096
        -
1129
        columns:
1097
          columnname: name
1130
            -
1098
        -
1131
              columnname: name
1099
          columnname: cyclical
1132
            -
1100
        -
1133
              columnname: cyclical
1101
          columnname: active
1134
            -
1102
        -
1135
              columnname: active
1103
          columnname: description
1136
            -
1104
        -
1137
              columnname: description
1105
          columnname: number_of_items
1138
            -
1106
        -
1139
              columnname: number_of_items
1107
          columnname: actions
1140
            -
1108
          cannot_be_toggled: 1
1141
              columnname: actions
1109
          cannot_be_modified: 1
1142
              cannot_be_toggled: 1
1143
              cannot_be_modified: 1
1110
1144
1111
      stock_rotation_manage_items:
1145
      stock_rotation_manage_items:
1112
        -
1146
        columns:
1113
          columnname: barcode
1147
            -
1114
        -
1148
              columnname: barcode
1115
          columnname: title
1149
            -
1116
        -
1150
              columnname: title
1117
          columnname: author
1151
            -
1118
        -
1152
              columnname: author
1119
          columnname: call_number
1153
            -
1120
        -
1154
              columnname: call_number
1121
          columnname: in_transit
1155
            -
1122
        -
1156
              columnname: in_transit
1123
          columnname: stages
1157
            -
1124
        -
1158
              columnname: stages
1125
          columnname: actions
1159
            -
1126
          cannot_be_toggled: 1
1160
              columnname: actions
1127
          cannot_be_modified: 1
1161
              cannot_be_toggled: 1
1162
              cannot_be_modified: 1
1128
- 

Return to bug 24156