admin/columns_settings.yml

   1 modules:
   2   acqui:
   3     acq_acqui-home:
   4       accounts:
   5         columns:
   6             -
   7               columnname: active
   8               cannot_be_toggled: 1
   9               cannot_be_modified: 1
  10             -
  11               columnname: budget_period_descriptions
  12               cannot_be_toggled: 1
  13               cannot_be_modified: 1
  14             -
  15               columnname: fund_code
  16             -
  17               columnname: fund_name
  18             -
  19               columnname: owner
  20             -
  21               columnname: library
  22             -
  23               columnname: amount
  24             -
  25               columnname: ordered
  26             -
  27               columnname: spent
  28             -
  29               columnname: total_available
  30
  31     histsearch:
  32       histsearcht:
  33         default_display_length: 20
  34         default_sort_order: 0
  35         columns:
  36             -
  37               columnname: order_line
  38             -
  39               columnname: status
  40             -
  41               columnname: basket
  42             -
  43               columnname: basket_creator
  44             -
  45               columnname: basket_group
  46             -
  47               columnname: managing_library
  48             -
  49               columnname: invoice_number
  50             -
  51               columnname: summary
  52             -
  53               columnname: vendor
  54             -
  55               columnname: placed_on
  56             -
  57               columnname: received_on
  58             -
  59               columnname: quantity_received
  60             -
  61               columnname: pending_order
  62             -
  63               columnname: unit_cost
  64             -
  65               columnname: fund
  66             -
  67               columnname: internalnote
  68             -
  69               columnname: vendornote
  70
  71     lateorders:
  72       late_orders:
  73         default_display_length: 20
  74         default_sort_order: 0
  75         columns:
  76             -
  77               columnname: checkbox
  78               cannot_be_toggled: 1
  79               cannot_be_modified: 1
  80             -
  81               columnname: order_line
  82             -
  83               columnname: order_date
  84             -
  85               columnname: estimated_delivery_date
  86             -
  87               columnname: vendor
  88             -
  89               columnname: information
  90             -
  91               columnname: quantity
  92             -
  93               columnname: total_cost
  94             -
  95               columnname: basket
  96             -
  97               columnname: basket_group
  98             -
  99               columnname: library
 100             -
 101               columnname: budget
 102             -
 103               columnname: fund
 104             -
 105               columnname: claims_count
 106             -
 107               columnname: claimed_date
 108             -
 109               columnname: internal_note
 110             -
 111               columnname: vendor_note
 112             -
 113               columnname: isbn
 114
 115     basket:
 116       orders:
 117         default_display_length: 20
 118         default_sort_order: 0
 119         columns:
 120             -
 121               columnname: basket_number
 122             -
 123               columnname: order_information
 124             -
 125               columnname: recommended_retail_price_tax_excluded
 126             -
 127               columnname: actual_cost_tax_excluded
 128             -
 129               columnname: budgeted_cost_price_tax_included
 130             -
 131               columnname: recommended_retail_price_tax_included
 132               is_hidden: 1
 133             -
 134               columnname: actual_cost_tax_included
 135               is_hidden: 1
 136             -
 137               columnname: budgeted_cost_tax_included
 138             -
 139               columnname: replacement_price
 140             -
 141               columnname: quantity
 142             -
 143               columnname: total_tax_excluded
 144             -
 145               columnname: total_tax_included
 146               is_hidden: 1
 147             -
 148               columnname: goods_and_services_tax_percentage
 149             -
 150               columnname: goods_and_services_tax
 151             -
 152               columnname: fund
 153             -
 154               columnname: supplier_report
 155             -
 156               columnname: modify
 157               cannot_be_toggled: 1
 158               cannot_be_modified: 1
 159             -
 160               columnname: cancel
 161               cannot_be_toggled: 1
 162               cannot_be_modified: 1
 163
 164     suggestions:
 165       suggestions:
 166         columns:
 167             -
 168               columnname: selections
 169               cannot_be_toggled: 1
 170               cannot_be_modified: 1
 171             -
 172               columnname: suggestion
 173             -
 174               columnname: suggested_by
 175             -
 176               columnname: suggested_on
 177             -
 178               columnname: patron_reason
 179             -
 180               columnname: managed_by
 181             -
 182               columnname: managed_on
 183             -
 184               columnname: lastmodificationby
 185             -
 186               columnname: lastmodificationdate
 187             -
 188               columnname: last_updated_date
 189             -
 190               columnname: library
 191             -
 192               columnname: library_fund
 193             -
 194               columnname: suggestion_status
 195             -
 196               columnname: actions
 197               cannot_be_toggled: 1
 198               cannot_be_modified: 1
 199   admin:
 200     cities:
 201       table_cities:
 202         default_display_length: 20
 203         default_sort_order: 0
 204         columns:
 205             -
 206               columnname: city_id
 207             -
 208               columnname: city_name
 209             -
 210               columnname: city_state
 211             -
 212               columnname: city_zipcode
 213             -
 214               columnname: city_country
 215             -
 216               columnname: actions
 217               cannot_be_toggled: 1
 218               cannot_be_modified: 1
 219     currency:
 220       currencies-table:
 221         columns:
 222             -
 223               columnname: currency
 224               cannot_be_toggled: 1
 225               cannot_be_modified: 1
 226             -
 227               columnname: rate
 228               cannot_be_toggled: 1
 229               cannot_be_modified: 1
 230             -
 231               columnname: symbol
 232             -
 233               columnname: iso_code
 234               is_hidden: 1
 235             -
 236               columnname: last_updated
 237             -
 238               columnname: active
 239             -
 240               columnname: actions
 241
 242     categories:
 243       patron_categories:
 244         default_display_length: 20
 245         default_sort_order: 1
 246         columns:
 247             -
 248               columnname: code
 249             -
 250               columnname: category_name
 251             -
 252               columnname: type
 253             -
 254               columnname: enrollment_period
 255             -
 256               columnname: age_required
 257             -
 258               columnname: upper_age_limit
 259             -
 260               columnname: enrollment_fee
 261             -
 262               columnname: overdue
 263             -
 264               columnname: lost_items
 265             -
 266               columnname: hold_fee
 267             -
 268               columnname: messaging
 269             -
 270               columnname: branches_limitations
 271             -
 272               columnname: default_privacy
 273             -
 274               columnname: actions
 275               cannot_be_toggled: 1
 276               cannot_be_modified: 1
 277
 278     itemtypes:
 279       table_item_type:
 280         default_display_length: 10
 281         default_sort_order: 1
 282         columns:
 283             -
 284               columnname: image
 285             -
 286               columnname: description
 287             -
 288               columnname: code
 289             -
 290               columnname: parent_code
 291             -
 292               columnname: search_category
 293             -
 294               columnname: not_for_loan
 295             -
 296               columnname: hide_in_opac
 297             -
 298               columnname: rental_charge
 299             -
 300               columnname: daily_rental_charge
 301             -
 302               columnname: hourly_rental_charge
 303             -
 304               columnname: default_replacement_cost
 305             -
 306               columnname: lost_processing_fee
 307             -
 308               columnname: checkin_message
 309             -
 310               columnname: library_limitations
 311             -
 312               columnname: automatic_checkin
 313               is_hidden: 1
 314             -
 315               columnname: actions
 316               cannot_be_toggled: 1
 317               cannot_be_modified: 1
 318
 319     libraries:
 320       libraries:
 321         default_display_length: 20
 322         default_sort_order: 0
 323         columns:
 324             -
 325               columnname: library_name
 326             -
 327               columnname: library_code
 328             -
 329               columnname: library_address
 330             -
 331               columnname: marc_organization_code
 332             -
 333               columnname: library_ip
 334             -
 335               columnname: is_pickup_location
 336             -
 337               columnname: smtp_server
 338             -
 339               columnname: actions
 340               cannot_be_toggled: 1
 341               cannot_be_modified: 1
 342
 343   catalogue:
 344     detail:
 345       holdings_table:
 346         columns:
 347             -
 348               columnname: holdings_checkbox
 349               cannot_be_toggled: 1
 350               cannot_be_modified: 1
 351             -
 352               columnname: holdings_cover_image
 353             -
 354               columnname: holdings_itype
 355             -
 356               columnname: holdings_holdingbranch
 357             -
 358               columnname: holdings_homebranch
 359             -
 360               columnname: holdings_ccode
 361             -
 362               columnname: holdings_itemcallnumber
 363             -
 364               columnname: holdings_status
 365             -
 366               columnname: holdings_lastseen
 367             -
 368               columnname: holdings_issues
 369               is_hidden: 1
 370             -
 371               columnname: holdings_renewals
 372               is_hidden: 1
 373             -
 374               columnname: holdings_dateaccessioned
 375             -
 376               columnname: holdings_datelastborrowed
 377             -
 378               columnname: holdings_barcode
 379             -
 380               columnname: holdings_enumchron
 381             -
 382               columnname: holdings_uri
 383             -
 384               columnname: holdings_copynumber
 385             -
 386               columnname: holdings_stocknumber
 387             -
 388               columnname: holdings_materials
 389             -
 390               columnname: holdings_itemnotes
 391             -
 392               columnname: holdings_itemnotes_nonpublic
 393             -
 394               columnname: holdings_hostrecord
 395             -
 396               columnname: holdings_usedin
 397             -
 398               columnname: holdings_usedin_col
 399             -
 400               columnname: holdings_course_reserves
 401             -
 402               columnname: holdings_spinelabel
 403             -
 404               columnname: holdings_actions
 405               cannot_be_toggled: 1
 406               cannot_be_modified: 1
 407
 408       otherholdings_table:
 409         columns:
 410             -
 411               columnname: otherholdings_checkbox
 412               cannot_be_toggled: 1
 413               cannot_be_modified: 1
 414             -
 415               columnname: otherholdings_cover_image
 416             -
 417               columnname: otherholdings_itype
 418             -
 419               columnname: otherholdings_holdingbranch
 420             -
 421               columnname: otherholdings_homebranch
 422             -
 423               columnname: otherholdings_ccode
 424             -
 425               columnname: otherholdings_itemcallnumber
 426             -
 427               columnname: otherholdings_status
 428             -
 429               columnname: otherholdings_lastseen
 430             -
 431               columnname: otherholdings_dateaccessioned
 432             -
 433               columnname: otherholdings_datelastborrowed
 434             -
 435               columnname: otherholdings_barcode
 436             -
 437               columnname: otherholdings_enumchron
 438             -
 439               columnname: otherholdings_uri
 440             -
 441               columnname: otherholdings_copynumber
 442             -
 443               columnname: otherholdings_stocknumber
 444             -
 445               columnname: otherholdings_materials
 446             -
 447               columnname: otherholdings_itemnotes
 448             -
 449               columnname: otherholdings_itemnotes_nonpublic
 450             -
 451               columnname: otherholdings_hostrecord
 452             -
 453               columnname: otherholdings_usedin
 454             -
 455               columnname: otherholdings_usedin_col
 456             -
 457               columnname: otherholdings_course_reserves
 458             -
 459               columnname: otherholdings_spinelabel
 460             -
 461               columnname: otherholdings_actions
 462               cannot_be_toggled: 1
 463               cannot_be_modified: 1
 464
 465       acquisitiondetails-table:
 466         columns:
 467             -
 468               columnname: vendor
 469             -
 470               columnname: invoice
 471             -
 472               columnname: basketgroup
 473             -
 474               columnname: basket
 475             -
 476               columnname: ordernumber
 477             -
 478               columnname: creation_date
 479             -
 480               columnname: received_data
 481             -
 482               columnname: status
 483             -
 484               columnname: quantity
 485             -
 486               columnname: price
 487             -
 488               columnname: order_internalnote
 489             -
 490               columnname: subscription
 491             -
 492               columnname: subscription_callnumber
 493
 494       checkoutshistory-table:
 495         default_display_length: 20
 496         columns:
 497             -
 498               columnname: patron
 499               cannot_be_toggled: 1
 500               cannot_be_modified: 1
 501             -
 502               columnname: barcode
 503               cannot_be_toggled: 1
 504               cannot_be_modified: 1
 505             -
 506               columnname: checked_out_from
 507             -
 508               columnname: checked_out_by
 509             -
 510               columnname: renewed
 511             -
 512               columnname: checkout_on
 513             -
 514               columnname: due_date
 515             -
 516               columnname: checkin_on
 517
 518   cataloguing:
 519     addbooks:
 520       reservoir-table:
 521         columns:
 522             -
 523               columnname: title
 524             -
 525               columnname: isbn
 526             -
 527               columnname: coming_from
 528             -
 529               columnname: import_date
 530             -
 531               columnname: actions
 532               cannot_be_toggled: 1
 533               cannot_be_modified: 1
 534     additem:
 535       itemst:
 536         # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
 537         # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
 538         # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
 539         # reserves.
 540         columns:
 541             -
 542               columnname: barcode
 543             -
 544               columnname: dateaccessioned
 545             -
 546               columnname: booksellerid
 547             -
 548               columnname: homebranch
 549             -
 550               columnname: price
 551             -
 552               columnname: replacementprice
 553             -
 554               columnname: replacementpricedate
 555             -
 556               columnname: datelastborrowed
 557             -
 558               columnname: datelastseen
 559             -
 560               columnname: stack
 561             -
 562               columnname: notforloan
 563             -
 564               columnname: damaged
 565             -
 566               columnname: itemlost
 567             -
 568               columnname: withdrawn
 569             -
 570               columnname: itemcallnumber
 571             -
 572               columnname: coded_location_qualifier
 573             -
 574               columnname: restricted
 575             -
 576               columnname: itemnotes
 577             -
 578               columnname: itemnotes_nonpublic
 579             -
 580               columnname: holdingbranch
 581             -
 582               columnname: timestamp
 583             -
 584               columnname: location
 585             -
 586               columnname: onloan
 587             -
 588               columnname: cn_source
 589             -
 590               columnname: ccode
 591             -
 592               columnname: materials
 593             -
 594               columnname: uri
 595             -
 596               columnname: itype
 597             -
 598               columnname: enumchron
 599             -
 600               columnname: copynumber
 601             -
 602               columnname: stocknumber
 603
 604     z3950_search:
 605       resultst:
 606         default_sort_order: 1
 607         columns:
 608             -
 609               columnname: server
 610             -
 611               columnname: title
 612             -
 613               columnname: author
 614             -
 615               columnname: date
 616             -
 617               columnname: edition
 618             -
 619               columnname: isbn
 620             -
 621               columnname: lccn
 622             -
 623               columnname: actions
 624               cannot_be_toggled: 1
 625               cannot_be_modified: 1
 626
 627   coursereserves:
 628     courses:
 629       course_reserves_table:
 630         default_display_length: 20
 631         default_sort_order: 0
 632         columns:
 633             -
 634               columnname: name
 635             -
 636               columnname: department
 637             -
 638               columnname: course_no
 639             -
 640               columnname: section
 641             -
 642               columnname: term
 643             -
 644               columnname: instructors
 645             -
 646               columnname: staff_note
 647             -
 648               columnname: public_note
 649             -
 650               columnname: no_of_students
 651             -
 652               columnname: enabled
 653
 654     reserves:
 655       course_reserves_table:
 656         default_display_length: 20
 657         default_sort_order: 0
 658         columns:
 659             -
 660               columnname: title
 661             -
 662              columnname: author
 663             -
 664               columnname: barcode
 665             -
 666               columnname: call_number
 667             -
 668               columnname: item_type
 669             -
 670               columnname: collection
 671             -
 672               columnname: location
 673             -
 674               columnname: home_library
 675             -
 676               columnname: holding_library
 677             -
 678               columnname: staff_note
 679             -
 680               columnname: public_note
 681             -
 682               columnname: link
 683             -
 684               columnname: other_course_reserves
 685             -
 686               columnname: actions
 687               cannot_be_toggled: 1
 688               cannot_be_modified: 1
 689
 690   illrequests:
 691     ill-requests:
 692       ill-requests:
 693         columns:
 694             -
 695               columnname: illrequest_id
 696             -
 697               columnname: metadata_author
 698             -
 699               columnname: metadata_title
 700             -
 701               columnname: metadata_article_title
 702             -
 703               columnname: metadata_issue
 704             -
 705               columnname: metadata_volume
 706             -
 707               columnname: metadata_year
 708             -
 709               columnname: metadata_pages
 710             -
 711               columnname: metadata_type
 712             -
 713               columnname: orderid
 714             -
 715               columnname: patron
 716             -
 717               columnname: biblio_id
 718             -
 719               columnname: library_branchname
 720             -
 721               columnname: status
 722             -
 723               columnname: placed
 724               cannot_be_toggled: 1
 725               cannot_be_modified: 1
 726               is_hidden: 1
 727             -
 728               columnname: placed_formatted
 729             -
 730               columnname: updated
 731               cannot_be_toggled: 1
 732               cannot_be_modified: 1
 733               is_hidden: 1
 734             -
 735               columnname: updated_formatted
 736             -
 737               columnname: replied
 738             -
 739               columnname: completed
 740               cannot_be_toggled: 1
 741               cannot_be_modified: 1
 742               is_hidden: 1
 743             -
 744               columnname: completed_formatted
 745             -
 746               columnname: accessurl
 747             -
 748               columnname: cost
 749             -
 750               columnname: comments
 751             -
 752               columnname: notesopac
 753             -
 754               columnname: notesstaff
 755             -
 756               columnname: backend
 757             -
 758               columnname: action
 759               cannot_be_toggled: 1
 760               cannot_be_modified: 1
 761
 762   members:
 763     fines:
 764       account-fines:
 765         default_display_length: 20
 766         columns:
 767             -
 768               columnname: date
 769             -
 770               columnname: timestamp
 771             -
 772               columnname: credit_number
 773               is_hidden: 1
 774             -
 775               columnname: account_type
 776             -
 777               columnname: description
 778             -
 779               columnname: barcode
 780             -
 781               columnname: date_due
 782             -
 783               columnname: returndate
 784             -
 785               columnname: issuedate
 786             -
 787               columnname: checked_out_from
 788             -
 789               columnname: home_library
 790             -
 791               columnname: note
 792             -
 793               columnname: amount
 794               cannot_be_toggled: 1
 795               cannot_be_modified: 1
 796             -
 797               columnname: amountoutstanding
 798               cannot_be_toggled: 1
 799               cannot_be_modified: 1
 800             -
 801               columnname: actions
 802               cannot_be_toggled: 1
 803               cannot_be_modified: 1
 804
 805     pay:
 806       pay-fines-table:
 807         default_display_length: 20
 808         default_sort_order: 3
 809         columns:
 810             -
 811               columnname: checkbox
 812               cannot_be_toggled: 1
 813               cannot_be_modified: 1
 814             -
 815               columnname: actions
 816               cannot_be_toggled: 1
 817               cannot_be_modified: 1
 818             -
 819               columnname: account_type
 820             -
 821               columnname: description
 822             -
 823               columnname: date
 824             -
 825               columnname: barcode
 826             -
 827               columnname: date_due
 828             -
 829               columnname: returndate
 830             -
 831               columnname: issuedate
 832             -
 833               columnname: checked_out_from
 834             -
 835               columnname: note
 836             -
 837               columnname: amount
 838             -
 839               columnname: amountoutstanding
 840
 841     member:
 842       memberresultst:
 843         columns:
 844             -
 845               columnname: checkbox
 846               cannot_be_toggled: 1
 847               cannot_be_modified: 1
 848             -
 849               columnname: cardnumber
 850             -
 851               columnname: name
 852             -
 853               columnname: dateofbirth
 854             -
 855               columnname: category
 856             -
 857               columnname: library
 858             -
 859               columnname: expires_on
 860             -
 861               columnname: od_checkouts
 862             -
 863               columnname: fines
 864             -
 865               columnname: circ_notes
 866             -
 867               columnname: actions
 868               cannot_be_toggled: 1
 869               cannot_be_modified: 1
 870
 871     moremember:
 872       issues-table:
 873         columns:
 874             -
 875               columnname: sort_order
 876               cannot_be_toggled: 1
 877               cannot_be_modified: 1
 878               is_hidden: 1
 879             -
 880               columnname: todays_or_previous_checkouts
 881               cannot_be_toggled: 1
 882               cannot_be_modified: 1
 883               is_hidden: 1
 884             -
 885               columnname: due_date_unformatted
 886               cannot_be_toggled: 1
 887               cannot_be_modified: 1
 888               is_hidden: 1
 889             -
 890               columnname: due_date
 891             -
 892               columnname: title
 893             -
 894               columnname: record_type
 895             -
 896               columnname: item_type
 897             -
 898               columnname: collection
 899             -
 900               columnname: location
 901             -
 902               columnname: homebranch
 903             -
 904               columnname: checkout_on_unformatted
 905               cannot_be_toggled: 1
 906               cannot_be_modified: 1
 907               is_hidden: 1
 908             -
 909               columnname: checkout_on
 910             -
 911               columnname: checkout_from
 912             -
 913               columnname: callno
 914             -
 915               columnname: copynumber
 916             -
 917               columnname: charge
 918             -
 919               columnname: fine
 920             -
 921               columnname: price
 922             -
 923               columnname: renew
 924               cannot_be_toggled: 1
 925               cannot_be_modified: 1
 926             -
 927               columnname: checkin
 928             -
 929               columnname: claims_returned
 930             -
 931               columnname: export
 932               cannot_be_toggled: 1
 933               cannot_be_modified: 1
 934
 935     holdshistory:
 936       holdshistory-table:
 937         default_display_length: 20
 938         columns:
 939             -
 940               columnname: title
 941               cannot_be_toggled: 1
 942               cannot_be_modified: 1
 943             -
 944               columnname: author
 945             -
 946               columnname: barcode
 947             -
 948               columnname: branch
 949             -
 950               columnname: reservedate
 951             -
 952               columnname: expirationdate
 953             -
 954               columnname: waitingdate
 955             -
 956               columnname: cancellationdate
 957             -
 958               columnname: itemtype
 959             -
 960               columnname: status
 961
 962     checkouthistory:
 963       checkouthistory-table:
 964         default_display_length: 20
 965         columns:
 966             - columnname: type
 967               cannot_be_toggled: 1
 968               cannot_be_modified: 1
 969             -
 970               columnname: date
 971             -
 972               columnname: title
 973             -
 974               columnname: author
 975             -
 976               columnname: call_number
 977             -
 978               columnname: barcode
 979             -
 980               columnname: number_of_renewals
 981             -
 982               columnname: checked_out_on
 983             -
 984               columnname: checked_out_from
 985             -
 986               columnname: date_due
 987             -
 988               columnname: return_date
 989
 990     patron-lists:
 991       patron-list-table:
 992         default_display_length: 20
 993         default_sort_order: 3
 994         columns:
 995             -
 996               columnname: checkbox
 997               cannot_be_toggled: 1
 998               cannot_be_modified: 1
 999             -
1000               columnname: card
1001             -
1002               columnname: firstname
1003             -
1004               columnname: surname
1005             -
1006               columnname: address
1007             -
1008               columnname: category
1009             -
1010               columnname: library
1011             -
1012               columnname: expires_on
1013             -
1014               columnname: circ_notes
1015
1016   reports:
1017     lostitems:
1018       lostitems-table:
1019         columns:
1020             -
1021               columnname: title
1022               cannot_be_toggled: 1
1023               cannot_be_modified: 1
1024             -
1025               columnname: author
1026             -
1027               columnname: lostcode
1028             -
1029               columnname: itemlost_on
1030             -
1031               columnname: barcode
1032             -
1033               columnname: callnumber
1034             -
1035               columnname: datelastseen
1036             -
1037               columnname: price
1038             -
1039               columnname: replacementprice
1040             -
1041               columnname: library
1042             -
1043               columnname: itemtype
1044             -
1045               columnname: collection_code
1046             -
1047               columnname: current_location
1048             -
1049               columnname: location
1050             -
1051               columnname: notforloan
1052             -
1053               columnname: notes
1054
1055     orders_by_fund:
1056       funds-table:
1057         default_display_length: 20
1058         default_sort_order: 0
1059         columns:
1060             -
1061               columnname: fund
1062             -
1063               columnname: basket
1064               cannot_be_toggled: 1
1065               cannot_be_modified: 1
1066             -
1067               columnname: basket_name
1068             -
1069               columnname: basket_by
1070             -
1071               columnname: title
1072             -
1073               columnname: currency
1074             -
1075               columnname: list_price
1076             -
1077               columnname: rrp
1078             -
1079               columnname: budgeted_cost
1080             -
1081               columnname: quantity
1082             -
1083               columnname: total_rrp
1084             -
1085               columnname: total_cost
1086             -
1087               columnname: entry_date
1088             -
1089               columnname: date_received
1090             -
1091               columnname: internal_note
1092             -
1093               columnname: vendor_note
1094
1095     saved-sql:
1096       table_reports:
1097         default_display_length: 20
1098         default_sort_order: 0
1099         columns:
1100             -
1101               columnname: selection
1102               cannot_be_toggled: 1
1103               cannot_be_modified: 1
1104             -
1105               columnname: report_id
1106               cannot_be_toggled: 1
1107               cannot_be_modified: 1
1108             -
1109               columnname: report_name
1110             -
1111               columnname: type
1112             -
1113               columnname: group
1114             -
1115               columnname: subgroup
1116             -
1117               columnname: notes
1118             -
1119               columnname: author
1120             -
1121               columnname: creation_date
1122             -
1123               columnname: last_edit
1124             -
1125               columnname: last_run
1126             -
1127               columnname: public
1128             -
1129               columnname: json_url
1130             -
1131               columnname: cache_expiry
1132             -
1133               columnname: saved_results
1134             -
1135               columnname: update
1136             -
1137               columnname: actions
1138               cannot_be_toggled: 1
1139               cannot_be_modified: 1
1140
1141   circ:
1142     circulation:
1143       issues-table:
1144         columns:
1145             -
1146               columnname: sort_order
1147               cannot_be_toggled: 1
1148               cannot_be_modified: 1
1149               is_hidden: 1
1150             -
1151               columnname: todays_or_previous_checkouts
1152               cannot_be_toggled: 1
1153               cannot_be_modified: 1
1154               is_hidden: 1
1155             -
1156               columnname: due_date_unformatted
1157               cannot_be_toggled: 1
1158               cannot_be_modified: 1
1159               is_hidden: 1
1160             -
1161               columnname: due_date
1162             -
1163               columnname: title
1164             -
1165               columnname: record_type
1166             -
1167               columnname: item_type
1168             -
1169               columnname: collection
1170             -
1171               columnname: location
1172             -
1173               columnname: homebranch
1174             -
1175               columnname: checkout_on_unformatted
1176               cannot_be_toggled: 1
1177               cannot_be_modified: 1
1178               is_hidden: 1
1179             -
1180               columnname: checkout_on
1181             -
1182               columnname: checkout_from
1183             -
1184               columnname: callno
1185             -
1186               columnname: copynumber
1187             -
1188               columnname: charge
1189             -
1190               columnname: fine
1191             -
1192               columnname: price
1193             -
1194               columnname: renew
1195               cannot_be_toggled: 1
1196               cannot_be_modified: 1
1197             -
1198               columnname: checkin
1199             -
1200               columnname: claims_returned
1201             -
1202               columnname: export
1203               cannot_be_toggled: 1
1204               cannot_be_modified: 1
1205
1206       table_borrowers:
1207         columns:
1208             -
1209               columnname: name
1210               cannot_be_toggled: 1
1211               cannot_be_modified: 1
1212             -
1213               columnname: cardnumber
1214             -
1215               columnname: date_of_birth
1216             -
1217               columnname: category
1218             -
1219               columnname: library
1220             -
1221               columnname: address
1222             -
1223               columnname: phone
1224               is_hidden: 1
1225
1226     returns:
1227       checkedintable:
1228         columns:
1229             -
1230               columnname: due_date
1231             -
1232               columnname: title
1233             -
1234               columnname: author
1235             -
1236               columnname: barcode
1237             -
1238               columnname: homelibrary
1239             -
1240               columnname: transferlibrary
1241             -
1242               columnname: location
1243             -
1244               columnname: itemcallnumber
1245             -
1246               columnname: dateaccessioned
1247               is_hidden: 1
1248             -
1249               columnname: record_type
1250             -
1251               columnname: itype
1252             -
1253               columnname: ccode
1254             -
1255               columnname: borrower
1256             -
1257               columnname: itemnote
1258
1259     view_holdsqueue:
1260       holds-table:
1261         default_sort_order: 3
1262         columns:
1263             -
1264               columnname: title
1265             -
1266               columnname: collection
1267             -
1268               columnname: document_type
1269             -
1270               columnname: callnumber
1271             -
1272               columnname: copynumber
1273             -
1274               columnname: enumeration
1275             -
1276               columnname: barcode
1277             -
1278               columnname: patron
1279             -
1280               columnname: patroncategory
1281             -
1282               columnname: send_to
1283             -
1284               columnname: date
1285             -
1286               columnname: notes
1287
1288     holds:
1289       holds-to-pull:
1290         default_display_length: 20
1291         default_sort_order: 0
1292         columns:
1293             -
1294               columnname: pull_items
1295             -
1296               columnname: avalaible_items
1297             -
1298               columnname: patrons
1299             -
1300               columnname: patron
1301             -
1302               columnname: title
1303             -
1304               columnname: libraries
1305             -
1306               columnname: barcodes
1307             -
1308               columnname: call_numbers
1309             -
1310               columnname: copy_numbers
1311             -
1312               columnname: enumeration
1313             -
1314               columnname: itemtypes
1315             -
1316               columnname: locations
1317             -
1318               columnname: hold_date
1319             -
1320               columnname: reserve_notes
1321             -
1322               columnname: pickup_location
1323             -
1324               columnname: action
1325
1326     holdsratios:
1327       holds-ratios:
1328         default_display_length: 20
1329         columns:
1330             -
1331               columnname: holds
1332             -
1333               columnname: items
1334             -
1335               columnname: holds_ratio
1336             -
1337               columnname: title
1338             -
1339               columnname: home_libraries
1340             -
1341               columnname: holding_libraries
1342             -
1343               columnname: location
1344             -
1345               columnname: itemtype
1346             -
1347               columnname: call_numbers
1348             -
1349               columnname: items_needed
1350
1351     holds_awaiting_pickup:
1352       holdst:
1353         columns:
1354             -
1355               columnname: checkbox
1356               cannot_be_toggled: 1
1357               cannot_be_modified: 1
1358             -
1359               columnname: waiting_since
1360             -
1361               columnname: date_hold_placed
1362             -
1363               columnname: expiration_date
1364             -
1365               columnname: title
1366             -
1367               columnname: patron
1368             -
1369               columnname: home_library
1370             -
1371               columnname: current_location
1372             -
1373               columnname: shelving_location
1374             -
1375               columnname: call_number
1376             -
1377               columnname: copy_number
1378             -
1379               columnname: enumeration
1380             -
1381               columnname: action
1382
1383       holdso:
1384         columns:
1385             -
1386               columnname: checkbox
1387               cannot_be_toggled: 1
1388               cannot_be_modified: 1
1389             -
1390               columnname: waiting_since
1391             -
1392               columnname: date_hold_placed
1393             -
1394               columnname: expiration_date
1395             -
1396               columnname: title
1397             -
1398               columnname: patron
1399             -
1400               columnname: home_library
1401             -
1402               columnname: current_location
1403             -
1404               columnname: shelving_location
1405             -
1406               columnname: call_number
1407             -
1408               columnname: copy_number
1409             -
1410               columnname: enumeration
1411             -
1412               columnname: action
1413
1414     overdues:
1415       circ-overdues:
1416         default_display_length: 20
1417         default_sort_order: 0
1418         columns:
1419             -
1420               columnname: due_date
1421             -
1422               columnname: patron
1423             -
1424               columnname: patron_category
1425               is_hidden: 1
1426             -
1427               columnname: patron_library
1428             -
1429               columnname: title
1430             -
1431               columnname: home_library
1432               is_hidden: 1
1433             -
1434               columnname: holding_library
1435               is_hidden: 1
1436             -
1437               columnname: shelving_location
1438             -
1439               columnname: barcode
1440             -
1441               columnname: call_number
1442             -
1443               columnname: item_type
1444               is_hidden: 1
1445             -
1446               columnname: price
1447             -
1448               columnname: non-public_note
1449
1450     print_summary:
1451         print-summary-checkouts:
1452             columns:
1453                 -
1454                     columnname: title
1455                 -
1456                     columnname: author
1457                 -
1458                     columnname: call_number
1459                 -
1460                     columnname: item_type
1461                 -
1462                     columnname: date_due
1463                 -
1464                     columnname: barcode
1465                 -
1466                     columnname: inventory_number
1467                 -
1468                     columnname: charge
1469                 -
1470                     columnname: price
1471                 -
1472                     columnname: status
1473
1474         print-summary-holds:
1475             columns:
1476                 -
1477                     columnname: title
1478                 -
1479                     columnname: author
1480                 -
1481                     columnname: placed_on
1482                 -
1483                     columnname: expires_on
1484                 -
1485                     columnname: pick up_location
1486
1487         print-summary-fines:
1488             columns:
1489                 -
1490                     columnname: date
1491                 -
1492                     columnname: description_of_charges
1493                 -
1494                     columnname: note
1495                 -
1496                     columnname: amount
1497                 -
1498                     columnname: outstanding
1499
1500   opac:
1501     biblio-detail:
1502       holdingst:
1503         columns:
1504             -
1505               columnname: item_cover
1506             -
1507               columnname: item_itemtype
1508             -
1509               columnname: item_current_location
1510             -
1511               columnname: item_home_location
1512             -
1513               columnname: item_shelving_location
1514               is_hidden: 1
1515             -
1516               columnname: item_ccode
1517             -
1518               columnname: item_callnumber
1519             -
1520               columnname: item_materials
1521               is_hidden: 1
1522             -
1523               columnname: item_enumchron
1524             -
1525               columnname: item_url
1526             -
1527               columnname: item_copy
1528             -
1529               columnname: item_status
1530             -
1531               columnname: item_notes
1532             -
1533               columnname: item_datedue
1534             -
1535               columnname: item_barcode
1536               is_hidden: 1
1537             -
1538               columnname: item_holds
1539             -
1540               columnname: item_priority
1541             -
1542               columnname: item_coursereserves
1543
1544       course_reserves_table:
1545         columns:
1546             -
1547               columnname: coursename
1548             -
1549               columnname: department
1550             -
1551               columnname: course_number
1552             -
1553               columnname: section
1554             -
1555               columnname: term
1556             -
1557               columnname: instructor
1558             -
1559               columnname: notes
1560
1561       subscriptionst:
1562         columns:
1563             -
1564               columnname: serial_serialseq
1565             -
1566               columnname: serial_publisheddate
1567             -
1568               columnname: serial_planneddate
1569             -
1570               columnname: serial_status
1571             -
1572               columnname: serial_notes
1573
1574       course-items-table:
1575         columns:
1576             -
1577               columnname: title
1578             -
1579               columnname: author
1580             -
1581               columnname: itemtype
1582             -
1583               columnname: location
1584             -
1585               columnname: collection
1586             -
1587               columnname: callnumber
1588             -
1589               columnname: copynumber
1590             -
1591               columnname: status
1592             -
1593               columnname: datedue
1594             -
1595               columnname: notes
1596             -
1597               columnname: link
1598
1599   serials:
1600     subscription-detail:
1601       orders:
1602         columns:
1603             -
1604               columnname: invoice
1605             -
1606               columnname: basket
1607             -
1608               columnname: ordernumber
1609             -
1610               columnname: creation_date
1611             -
1612               columnname: receive_date
1613             -
1614               columnname: status
1615             -
1616               columnname: order_internalnote
1617             -
1618               columnname: order_vendornote
1619             -
1620               columnname: fund
1621             -
1622               columnname: ordered
1623             -
1624               columnname: spent
1625
1626   tools:
1627     batch_patron_modification:
1628       borrowerst:
1629         columns:
1630             -
1631               columnname: batch_patron_edit_selections
1632               cannot_be_toggled: 1
1633               cannot_be_modified: 1
1634             -
1635               columnname: batch_patron_edit_cardnumber
1636             -
1637               columnname: batch_patron_edit_surname
1638             -
1639               columnname: batch_patron_edit_firstname
1640             -
1641               columnname: batch_patron_edit_branchcode
1642             -
1643               columnname: batch_patron_edit_categorycode
1644             -
1645               columnname: batch_patron_edit_streetnumber
1646             -
1647               columnname: batch_patron_edit_address
1648             -
1649               columnname: batch_patron_edit_address2
1650             -
1651               columnname: batch_patron_edit_city
1652             -
1653               columnname: batch_patron_edit_state
1654             -
1655               columnname: batch_patron_edit_zipcode
1656             -
1657               columnname: batch_patron_edit_country
1658             -
1659               columnname: batch_patron_edit_email
1660             -
1661               columnname: batch_patron_edit_phone
1662             -
1663               columnname: batch_patron_edit_mobile
1664             -
1665               columnname: batch_patron_edit_dateenrolled
1666             -
1667               columnname: batch_patron_edit_dateexpiry
1668             -
1669               columnname: batch_patron_edit_borrowernotes
1670             -
1671               columnname: batch_patron_edit_opacnote
1672             -
1673               columnname: batch_patron_edit_debarred
1674             -
1675               columnname: batch_patron_edit_debarredcomment
1676
1677     logviewer:
1678       logst:
1679         default_display_length: 20
1680         columns:
1681             -
1682               columnname: date
1683             -
1684               columnname: librarian
1685             -
1686               columnname: module
1687             -
1688               columnname: action
1689             -
1690               columnname: object
1691             -
1692               columnname: info
1693             -
1694               columnname: interface
1695     marc-modification-templates:
1696       templatest:
1697         columns:
1698             -
1699               columnname: id
1700               is_hidden: 1
1701             -
1702               columnname: template
1703             -
1704               columnname: actions
1705               cannot_be_toggled: 1
1706               cannot_be_modified: 1
1707     notices:
1708       lettert:
1709         default_sort_order: 3
1710         columns:
1711             -
1712               columnname: library
1713             -
1714               columnname: module
1715             -
1716               columnname: code
1717             -
1718               columnname: name
1719             -
1720               columnname: updated_on
1721             -
1722               columnname: copy_notice
1723             -
1724               columnname: actions
1725               cannot_be_toggled: 1
1726               cannot_be_modified: 1
1727
1728     stockrotation:
1729       stock_rotation:
1730         columns:
1731             -
1732               columnname: name
1733             -
1734               columnname: cyclical
1735             -
1736               columnname: active
1737             -
1738               columnname: description
1739             -
1740               columnname: number_of_items
1741             -
1742               columnname: actions
1743               cannot_be_toggled: 1
1744               cannot_be_modified: 1
1745
1746       stock_rotation_manage_items:
1747         columns:
1748             -
1749               columnname: barcode
1750             -
1751               columnname: title
1752             -
1753               columnname: author
1754             -
1755               columnname: call_number
1756             -
1757               columnname: in_transit
1758             -
1759               columnname: stages
1760             -
1761               columnname: actions
1762               cannot_be_toggled: 1
1763               cannot_be_modified: 1
1764
1765     upload:
1766       uploadresults:
1767         default_display_length: 20
1768         columns:
1769             -
1770               columnname: filename
1771             -
1772               columnname: size
1773             -
1774               columnname: hashvalue
1775             -
1776               columnname: date
1777               is_hidden: 1
1778             -
1779               columnname: category
1780             -
1781               columnname: public
1782             -
1783               columnname: temporary
1784             -
1785               columnname: actions
1786               cannot_be_toggled: 1
1787               cannot_be_modified: 1
1788   pos:
1789     pay:
1790       invoices:
1791         columns:
1792             -
1793               columnname: code
1794             -
1795               columnname: description
1796             -
1797               columnname: cost
1798             -
1799               columnname: actions
1800               cannot_be_toggled: 1
1801               cannot_be_modified: 1