admin/columns_settings.yml

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