koha-tmpl/intranet-tmpl/prog/en/columns.def

   1 borrowers.borrowernumber        Borrower number
   2 borrowers.title Salutation
   3 borrowers.surname       Surname
   4 borrowers.firstname     First name
   5 borrowers.dateofbirth   Date of birth
   6 borrowers.initials      Initials
   7 borrowers.othernames    Other name
   8 borrowers.sex   Gender
   9 borrowers.relationship  Relationship
  10 borrowers.guarantorid   Guarantor borrower number
  11 borrowers.streetnumber  Street number
  12 borrowers.streettype    Street type
  13 borrowers.address       Address
  14 borrowers.address2      Address 2
  15 borrowers.city  City
  16 borrowers.state State
  17 borrowers.zipcode       Zip/postal code
  18 borrowers.country       Country
  19 borrowers.phone Primary phone
  20 borrowers.phonepro      Secondary phone
  21 borrowers.mobile        Other phone
  22 borrowers.email Primary email
  23 borrowers.emailpro      Secondary email
  24 borrowers.fax   Fax
  25 borrowers.B_streetnumber        Alternate address: Street number
  26 borrowers.B_streettype  Alternate address: Street type
  27 borrowers.B_address     Alternate address: Address
  28 borrowers.B_address2    Alternate address: Address 2
  29 borrowers.B_city        Alternate address: City
  30 borrowers.B_state       Alternate address: State
  31 borrowers.B_zipcode     Alternate address: Zip/postal code
  32 borrowers.B_country     Alternate address: Country
  33 borrowers.B_phone       Alternate address: Phone
  34 borrowers.B_email       Alternate address: Email
  35 borrowers.contactnote   Alternate contact: Note
  36 borrowers.altcontactfirstname   Alternate contact: Last name
  37 borrowers.altcontactsurname     Alternate contact: First name
  38 borrowers.altcontactaddress1    Alternate contact: Address
  39 borrowers.altcontactaddress2    Alternate contact: Address 2
  40 borrowers.altcontactaddress3    Alternate contact: City
  41 borrowers.contactname   Alternate contact: Surname
  42 borrowers.contactfirstname      Alternate contact: First name
  43 borrowers.contacttitle  Alternate contact: Title
  44 borrowers.altcontactstate       Alternate contact: State
  45 borrowers.altcontactzipcode     Alternate contact: Zip/postal code
  46 borrowers.altcontactcountry     Alternate contact: Country
  47 borrowers.altcontactphone       Alternate contact: Phone
  48 borrowers.cardnumber    Card number
  49 borrowers.branchcode    Home library
  50 borrowers.categorycode  Category
  51 borrowers.sort1 Sort 1
  52 borrowers.sort2 Sort 2
  53 borrowers.dateenrolled  Registration date
  54 borrowers.dateexpiry    Expiry date
  55 borrowers.opacnote      OPAC note
  56 borrowers.borrowernotes Circulation note
  57 borrowers.userid        Username
  58 borrowers.password      Password
  59 borrowers.flags System permissions
  60 borrowers.gonenoaddress Gone no address flag
  61 borrowers.lost  Lost card flag
  62 borrowers.debarred      Restricted [until] flag
  63 borrowers.debarredcomment       Comment
  64 borrowers.smsalertnumber        Mobile phone number
  65 borrowers.privacy       Privacy settings
  66 items.itemnumber        Item number (internal)
  67 items.biblionumber      Biblio number (internal)
  68 items.biblioitemnumber  Biblioitem number (internal)
  69 items.barcode   Barcode
  70 items.dateaccessioned   Date acquired
  71 items.booksellerid      Source of acquisition
  72 items.homebranch        Permanent library
  73 items.price     Price
  74 items.replacementprice  Replacement price
  75 items.replacementpricedate      Price effective from
  76 items.datelastborrowed  Date last checked out
  77 items.datelastseen      Date last seen
  78 items.stack     Shelving control number
  79 items.onloan    Due date
  80 items.cn_source Source of classification / shelving scheme
  81 items.cn_sort   Koha normalized classification for sorting
  82 items.notforloan        Not for loan
  83 items.itemlost  Lost status
  84 items.wthdrawn  Withdrawn status
  85 items.itemcallnumber    Call number
  86 items.issues    Total checkouts
  87 items.renewals  Total renewals
  88 items.reserves  Total holds
  89 items.restricted        Use restrictions
  90 items.itemnotes Public note
  91 items.holdingbranch     Current library
  92 items.paidfor
  93 items.timestamp Timestamp
  94 items.location  Shelving location
  95 items.ccode     Collection code
  96 items.itype     Koha itemtype
  97 items.stocknumber       Inventory number
  98 items.damaged   Damaged status
  99 items.materials Materials specified
 100 items.uri       Uniform Resource Identifier
 101 items.more_subfields_xml        Additional subfields (XML)
 102 items.enumchron Serial enumeraton/chronology
 103 items.copynumber        Copy number
 104 statistics.datetime     Statistics date and time
 105 statistics.branch       Library
 106 statistics.proccode     Type of procedure
 107 statistics.value        Value
 108 statistics.type Type
 109 statistics.other
 110 statistics.usercode     User code
 111 statistics.itemnumber   Item number
 112 statistics.itemtype     Itemtype
 113 statistics.borrowernumber       Borrower number
 114 biblio.frameworkcode    Framework code
 115 biblio.author   Author
 116 biblio.datecreated      Creation date
 117 biblio.timestamp        Modification date
 118 biblioitems.biblioitemnumber    Biblioitem number
 119 biblioitems.biblionumber        Biblio number
 120 biblioitems.volume      Volume number
 121 biblioitems.number      Number
 122 biblioitems.classification      Classification
 123 biblioitems.itemtype    Biblio-level item type
 124 biblioitems.isbn        ISBN
 125 biblioitems.issn        ISSN
 126 biblioitems.dewey       Dewey/classification
 127 biblioitems.subclass    Sub classification
 128 biblioitems.publicationyear     Publication date
 129 biblioitems.publishercode       Publisher
 130 biblioitems.volumedate  Volume date
 131 biblioitems.volumedesc  Volume information
 132 biblioitems.timestamp   Timestamp
 133 biblioitems.illus       Illustrator
 134 biblioitems.pages       Number of pages
 135 biblioitems.notes       Notes
 136 biblioitems.size        Size
 137 biblioitems.place       Place of publication
 138 biblioitems.lccn        LCCN
 139 biblioitems.marcxml     MARC blob
 140 biblioitems.url URL