items

primary key and unique identifier added by Koha

foreign key from biblio table used to link this item to the right bib record

foreign key from the biblioitems table to link to item to additional information

item barcode (MARC21 952$p)

date the item was acquired or added to Koha (MARC21 952$d)

where the item was purchased (MARC21 952$e)

foreign key from the branches table for the library that owns this item (MARC21 952$a)

purchase price (MARC21 952$g)

cost the library charges to replace the item if it has been marked lost (MARC21 952$v)

the date the price is effective from (MARC21 952$w)

the date the item was last checked out/issued

the date the item was last see (usually the last time the barcode was scanned or inventory was done)

authorized value defining why this item is not for loan (MARC21 952$7)

authorized value defining this item as damaged (MARC21 952$4)

the date and time an item was last marked as damaged, NULL if not damaged

authorized value defining this item as lost (MARC21 952$1)

the date and time an item was last marked as lost, NULL if not lost

authorized value defining this item as withdrawn (MARC21 952$0)

the date and time an item was last marked as withdrawn, NULL if not withdrawn

call number for this item (MARC21 952$o)

coded location qualifier(MARC21 952$f)

number of times this item has been checked out/issued

number of times this item has been renewed

number of times this item has been placed on hold/reserved

authorized value defining use restrictions for this item (MARC21 952$5)

public notes on this item (MARC21 952$z)

non-public notes on this item (MARC21 952$x)

foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)

date and time this item was last altered

date/time of deletion

authorized value for the shelving location for this item (MARC21 952$c)

linked to the CART and PROC temporary locations feature, stores the permanent shelving location

defines if item is checked out (NULL for not checked out, and due date for checked out)

classification source used on this item (MARC21 952$2)

normalized form of the call number (MARC21 952$o) used for sorting

authorized value for the collection code associated with this item (MARC21 952$8)

materials specified (MARC21 952$3)

URL for the item (MARC21 952$u)

foreign key from the itemtypes table defining the type for this item (MARC21 952$y)

additional 952 subfields in XML format

serial enumeration/chronology for the item (MARC21 952$h)

copy number (MARC21 952$t)

inventory number (MARC21 952$i)

‘new’ value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.

Exclude this item from local holds priority