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

   1 borrowers.borrowernumber        Borrower Number
   2 borrowers.cardnumber    Card Number
   3 borrowers.surname       Surname
   4 borrowers.firstname     Firstname
   5 borrowers.title Title
   6 borrowers.othernames Other Names
   7 borrowers.initials       Initials
   8 borrowers.streetaddress Street Address
   9 borrowers.suburb        Suburb
  10 borrowers.city  City
  11 borrowers.phone Phone
  12 borrowers.emailaddress  Email
  13 borrowers.faxnumber     Fax
  14 borrowers.textmessaging Opac Message
  15 borrowers.altstreetaddress       Alternative Street Address
  16 borrowers.altsuburb     Alternative Suburb
  17 borrowers.altcity       Alternative City
  18 borrowers.altphone      Alternative Phone
  19 borrowers.dateofbirth   Date of Birth
  20 borrowers.branchcode    Branch Code
  21 borrowers.categorycode  Borrowers Category
  22 borrowers.dateenrolled  Date Enrolled
  23 borrowers.gonenoaddress Address Missing
  24 borrowers.lost  Lost Card
  25 borrowers.debarred      Debarred
  26 borrowers.studentnumber  Student Id number
  27 borrowers.school        School
  28 borrowers.contactname   Contact Name
  29 borrowers.borrowernotes Circulation Notes
  30 borrowers.guarantor     Guarantor(parent)
  31 borrowers.area  Area
  32 borrowers.ethnicity     Ethnicity
  33 borrowers.ethnotes      Ethnicity Notes
  34 borrowers.sex   Gender
  35 borrowers.expiry        Expiry Date
  36 borrowers.altnotes      Alternative Contact Notes
  37 borrowers.altrelationship       Relationship of Alternative Contact
  38 borrowers.streetcity    Streetcity??
  39 borrowers.phoneday      Work Phone
  40 borrowers.preferredcont  Preferred method of Contact
  41 borrowers.physstreet    Physical Street Address
  42 borrowers.password       Password
  43 borrowers.flags Warnings
  44 borrowers.userid        Login ID
  45 borrowers.homezipcode   Zip/Post Code
  46 borrowers.zipcode       Zip/Post Code 2?
  47 borrowers.sort1 Sorting Column
  48 borrowers.sort2 Sorting Column 2
  49 borrowers.cellph        Cellphone number
  50 borrowers.borlog
  51 borrowers.checkhist
  52 items.itemnumber        Item Number (koha internal)
  53 items.biblionumber      Biblio Number (koha internal)
  54 items.multivolumepart   Item one part of a Multi volume set
  55 items.biblioitemnumber  Biblioitem Number (koha internal)
  56 items.barcode   Barcode
  57 items.dateaccessioned   Accession Date
  58 items.booksellerid      Supplier ID
  59 items.homebranch        Permanent Branch Code
  60 items.price     Price
  61 items.replacementprice  Replacement Price
  62 items.replacementpricedate      Date Replacement Price was set
  63 items.datelastborrowed  Date Item last issued
  64 items.datelastseen      Date Item was last seen by Koha
  65 items.multivolume       Volume Number (if part of a multivolume work)
  66 items.stack     Is the item in the stack?
  67 items.onloan    On loan
  68 items.notforloan        Item Not for loan
  69 items.itemlost  Item Lost
  70 items.wthdrawn  Item Cancelled
  71 items.itemcallnumber    Item Call Number
  72 items.issues    Issues Count
  73 items.renewals  Renewals Count
  74 items.reserves  Reserves Count
  75 items.restricted        Item Restricted
  76 items.binding   Item needs binding
  77 items.itemnotes Item Notes
  78 items.holdingbranch     Current Branch
  79 items.paidfor   Has Item been lost and then paid for
  80 items.timestamp Timestamp
  81 items.location  Location
  82 items.ccode     Koha Collection
  83 items.itype     Item-level Item Type
  84 items.spystatus
  85 items.spydescr
  86 items.itemlog
  87 items.spycopydata
  88 statistics.datetime     Statistics Date and Time
  89 statistics.branch       Branch Code
  90 statistics.proccode     Type of Procedure
  91 statistics.value        Value
  92 statistics.type Type
  93 statistics.other
  94 statistics.usercode     User Code
  95 statistics.itemnumber   Item Number
  96 statistics.itemtype     Item Type
  97 statistics.borrowernumber       Borrower Number
  98 biblioitems.biblioitemnumber    Biblioitem Number
  99 biblioitems.biblionumber        Biblio Number
 100 biblioitems.volume      Volume Number
 101 biblioitems.number      Number
 102 biblioitems.classification      Classification
 103 biblioitems.itemtype    Biblio-level Item Type
 104 biblioitems.isbn        ISBN
 105 biblioitems.issn        ISSN
 106 biblioitems.dewey       Dewey/Classification
 107 biblioitems.subclass    Sub Classification
 108 biblioitems.publicationyear     Publication Date
 109 biblioitems.publishercode       Publisher
 110 biblioitems.volumedate  Volume Date
 111 biblioitems.volumeddesc Volume Information
 112 biblioitems.timestamp   Timestamp
 113 biblioitems.illus       Illustrator
 114 biblioitems.pages       Number of Pages
 115 biblioitems.notes       Notes
 116 biblioitems.size        Size
 117 biblioitems.place       Place of Publication
 118 biblioitems.lccn        LCCN
 119 biblioitems.marc        MARC Blob
 120 biblioitems.url URL