Data fields from main entities explained

Acquisitions - Budget

Examples include:

Budget Commitments for this Year
Actual Expenditure for this Year
Different Group Levels used for the current Year
Budget Total Amount for the last 5 years

Data Element	Description	Example	Database Name ACCOUNT_HDR unless specified
Budget Account	Account code which is used for the expenditure within a budget	AF	ACH_ACCOUNT
Budget Account Details	Account description rather than the code	Adult Fiction	ACH_DESC
Budget Actual Amount	Actual Amount Spent within the Budget and on longer committed	2000.00	ACH_ACTUAL
Budget Commit Amount	Actual Amount Ordered and Committed within the Budget	1000.00	ACH_COMMIT
Budget Financial Year	Current Financial Year – generally the one to use as is available as a Drop-down and references the Financial Years in use	2014	ACH_YEAR
Budget Group Level 1	GL Code 1 from the Budget hierarchy	LIB	ACH_GROUP1
Budget Group Level 1 Details	GL Code 1 Description from the Budget hierarchy	Library	ACCNO_GROUP.ACCNO_CODE_DESC
Budget Group Level 2	GL Code 2 from the Budget hierarchy	BK	ACH_GROUP2
Budget Group Level 2 Details	GL Code 2 Description from the Budget hierarchy	Books	ACCNO_GROUP.ACCNO_CODE_DESC
Budget Group Level 3	GL Code 3from the Budget hierarchy	AF	ACH_GROUP3
Budget Group Level 3 Details	GL Code 3 Description from the Budget hierarchy	Adult Fiction	ACCNO_GROUP.ACCNO_CODE_DESC
Budget Group Level 4	GL Code 4 from the Budget hierarchy	NOV	ACH_GROUP4
Budget Group Level 4 Details	GL Code 4 Description from the Budget hierarchy	Novels	ACCNO_GROUP.ACCNO_CODE_DESC
Budget Library Group	Library Group for current Budget	PRIM	ACH.LIB.GROUP
Budget Total Amount	Budgeted Amount allowed to spend within the Budget	5000.00	ACH.BUDGET

Acquisitions – Invoices

This Report enables reports for the Order Invoices within the system. Ideas for reports could be:

Recent Invoices within a Date range
Invoice lines for a particular Invoice No
Invoices from Supplier/s
Total Costs of invoices created since the beginning of the month
Pending invoices

Data Element	Description	Example	Database Name – ACCOUNT_HEADER unless shown
Invoice Account	Account Code applied to the Invoice	ANF	ACCOUNT_COMPONENT.AC_ACCNO
Invoice Account Details	Description of the Account Code, applied to the Invoice	Adult Non Fiction	ACCOUNT.ACCNO_DESC
Invoice Allocation	Allocation Code set for the Order being invoiced	PK	ACCOUNT_COMPONENT.AC_ALLOCATE
Invoice Allocation Details	Description of the Allocation Code set for the Order being Invoiced	Paul Kosch	FIN_ALLOC.FA_DESC
Invoice Author	Invoice Line 2	Winton, Tim	ACCOUNT_COMPONENT.AC_LINE2
Invoice Date	Date Invoice was created	19/08/2015	AH_INVOICE_DATE
Invoice Discount	Discount as applied to the Invoice line	10%	ACCOUNT_COMPONENT.AC_DISCOUNT
Invoice Discount Indicator % or $	Indicates whether the Discount applied to Invoice costs is shown as a percentage, or money amount	%	ACCOUNT_COMPONENT.AC_DISCOUNT_ind
Invoice Forex Code	Foreign Exchange code as applied to the Invoice Header	AUS	AH_FCCODE
Invoice Forex Cost	Cost that applies to the Invoice Header prior to Discounts	30.00	AH_FCVALUE
Invoice Forex Date	Date of the Foreign Exchange code	01/01/1995	AH_FCDATE
Invoice Forex Rate	Rate applied to the Invoice amount for Foreign exchange	1.0000	AH_FCRATE
Invoice Lib Group	Library Group owning the Invoice Header	LIBRARY	AH_LIB_GROUP
Invoice Line includes Stockitem	The invoice line reference a Stockitem. Y/N	Y	AC_COMPONENT.AC_STOCKITEMYN
Invoice Line Notes	Notes associated with the Invoice Lines	Price changed on Invoice – discounted	AC_COMPONENT.AC_NOTES
Invoice Line Tax Account	Tax Account allocated on Invoice line	TAX	AC_COMPONENT.AC_TAX_ACCNO
Invoice Line Tax Code	Tax Code allocated on the Invoice line	GST	AC_COMPONENT.AC_TAX_CODE
Invoice Line Tax Rate	Rate calculated for the Tax code chosen	1.1%	AC_COMPONENT.AC_TAX_RATE
Invoice Local Cost	Invoice Total before Tax – Forex amount minus the tax component	60.00	AH_TOTAL
Invoice No	Invoice Number allocated to the Invoice	008899	AH_INVOICE_NO
Invoice Notes	Invoice Note	Cash purchase at Conference	AH_NOTES
Invoice Order Line No	Order Line No for processing	2	AC_COMPONENT.AC_ORDER_LNO
Invoice Order No	Order No included in the Order Invoice	516	AC_COMPONENT.AC_ORDER_NO
Invoice Report Date	Date of an Invoice report where the Update mode was set to Y	23/04/2015	AH_REPORT_DATE
Invoice Status	Status of the Invoice – either Pending or Invoiced	INVOICED	AH_STATUS
Invoice Supplier	Code of the Supplier for the Invoice	DYM	AH_SUPP_NO
Invoice Supplier Details	Description of the Supplier of the Invoice	Dymocks	PER_SUPPLIER.PS_COMPANY
Invoice Title	Invoice Line 1, usually the Title	Easy Reader Book 2	AC_COMPONENT.AC_LINE1
Invoice Total Tax excl	Invoice Total excluding Tax	66.00	AH_COST
Invoice Unit Cost exc Tax	Cost excluding the Tax component of the Invoice Line	40.00	ACCOUNT_COMPONENT.AC_COST
Invoice Unit Cost inc Tax	Cost including the Tax component of the Invoice Line	44.00	ACCOUNT_COMPONENT.AC_TOTAL
Invoice User Created	User who created the Invoice. Depends on login to the system	STAFF	AH_OPER
Invoiced Qty	No of items within the Invoice Line that have been invoiced	1	ACCOUNT_COMPONENT.AC_QTY_INVOICED

Acquisitions – Orders

This Report is a combination of Order Headers and Order Lines Useful Reports may include:

Orders placed during a time period
Orders Invoiced
Orders Received
Orders Not Received but placed over a certain date period
Orders placed by a certain supplier
Order Lines from a particular Order No
Orders where the cost of an Order line exceeds $100.00
Order Header Totals over a certain period

Data Element	Description	Example	Database Name
Order Header Condition	Order Condition of Header	NORM, URGENT	OH_CONDITION
Order Header Date Placed	Date place of the Order	16/09/2015	OH_DATE_PLACED
Order Header Date Printed	Date Order was printed (if in update mode)	16/09/2015	OH_DATE_PRINTED
Order Header Date To Claim	Date specified to claim	16/09/2015	OH_DATE_TO_CLAIM
Order Header Description	Order Header Notes	Delayed with Supplier	OH_DESCRIPTION
Order Header Forex Total	Order Header Total excluding Discounts	$30.00	OH_COST
Order Header Local Cost	Order Header Total Cost including Discounts	$27.00	OH_TOTAL
Order Header Summary	Summary	Bookweek purchases	OH_SUMMARY
Order Header Type	Order Type	NORM	OH_TYPE
Order Line Account	Account code for Order Line	JF	OC_ACCNO
Order Line Account Details	Description for the Account Code shown	Junior Fiction Books	OC_ACCNO_DESC
Order Line Allocation	Allocation code for Order Line	ENG	OC_ALLOC
Order Line Allocation Details	Description for the Allocation Code	English Dept	OC_ALLOC_DESC
Order Line Author	Order Line 2	Winton, Tim	OC_LINE2
Order Line Call No	Order Line 6	F WIN	OC_LINE6
Order Line Catalogue Ref	Order Line Catalogue Reference	103432	OC_CAT_REF
Order Line Discount	Discount allocated to Order Line	10%	OC_DISCOUNT
Order Line Grouping	Order Header Group	37-362392	OC_GROUP-NO
Order Line has Stockitem?	Order line has a Stockitem attached	Y	OC_STOCKITEMYN
Order Line ISBN	ISBN reference	9781863733144	OC_ISBN
Order Line ISSN	ISSN reference	2113-3321	OC_ISSN
Order Line Item	Stockitem Order Barcode	I94323	OC_STOCKITEM
Order Line Form	Form Code of the Order item	DVD	OC_FORM
Order Line Stats Code	Stats Code of the Order item	JF	OC_STATS_CODE
Order Line Lib Group	Library Group for Order Line	LIBRARY	OC_LIB_GROUP
Order Line No	Number of the Order Line	4	OC_ORDER_LNO
Order Line Notes	Notes entered in the Order Line	CIP confirmed	OC_NOTES
Order Line Process	Process associated with the Order Line as set in Defaults	ON ORDER	OC_PROCESS
Order Line Publisher	Order Line 3	Penguin, UK 2014	OC_LINE3
Order Line Qty Invoiced	Quantity already invoiced	6	OC_QTY_INVOICED
Order Line Qty Ordered	Quantity already Received	6	OC_QTY_RECEIVED
Order Line Qty Received	Quantity Ordered	12	OC_QTY_ORDERED
Order Line Series	Order Line 4	Animorphs	OC_LINE4
Order Line Subject	Order Line 3	Gold	OC_LINE3
Order Line Tax Account	Tax Account for the Order Line	TAX	OC_TAX_ACCNO
Order Line Tax Code	Tax Code for the Order Line	GST	OC_TAX_CODE
Order Line Tax Rate	Tax Rate for the Order Line	10	OC_TAX_RATE
Order Line Title	Order Line 1	The journey	OC_LINE1
Order Line Total Incl Tax	Local Amount inclusive of Tax		OC_TOTAL
Order Line Unit Cost	Cost per Item of the Order Line	20.00	OC_COST
Order Number	Order Number for the Order Header and associated Order lines	4500	OH_ORDER_NO
Order Supplier	Supplier for the Order Header	DYMOCKS	OH_SUPP_NO

Authorities

These reports focus on data from the Authority module of Amlib

Example reports for this module include:

New Subject Headings
New Genre Headings (655) Tags for promotion
New Series Headings from 490 or 440 Tags
Authorities with See Also references
Subjects with Authority Notes
Author list – including 100 and 700 Tags (added Authors)
Report on various Files as required

Data Element	Description	Example	Database Name – from AUTHORITY unless shown
Authority Created/Modified by	User who created or modified the Authority last	STAFF	AUTH_OPER
Authority Date Modified	Authority Date created or Date modified. Only one date Field in the Authority	22/06/2015	AUTH_DATETIME
Authority Details	Data contained within the Marc Tag	Animals - Fiction	AUTH_MARC
Authority File Date	File Date created or Date modified.	22/06/2015	FILE_DATE
Authority File Description	Description used to Name the File	SCIS 22/06	FILE_DESC
Authority File Entries	The number of entries within the File	121	FILE_QTY
Authority File Number	The unique File Number. This is recommended to pinpoint a particular File (as the description may not be unique to each File)	3554	FILE_NUMBER
Authority File Operator	File Operator (User name)	STAFF	FILE_OPER
Authority File Operator Access	Whether other Users are allowed to access the File Y/N	Y	FILE_OPER_ACCESS
Authority Has See Also?	The Authority has See Also references Y/N	Y	AUTH_HAS_SA
Authority Lib Group	Library Group Code associated with the Marc Tag	LIBRARY	AUTH_LIB_GROUP
Authority Note Text	Authority Note that guides the Cataloguer on to when to use the Authority	“Use for descriptive works on houses”	AUTH_NOTE.AUTH_NOTE_ DATA
Authority Note?	Whether the Tag has an Authority Note Y/N	Y	AUTH_NOTE
Authority Search Key	Search term as held in the database table	MOLLYS REVENGE	AUTH_KEY
Authority Tag Description	Authority Description of the Authority Tag	Subject – Topical Term	TAG_TAGDEF.TT_TAG_DES C
Authority Tag Indicator 1	First Indicator for the Tag	4	AUTH_IND1
Authority Tag Indicator 2	Second indicator for the Tag	1	AUTH_IND2
Authority Tag No	Authority Tag Number	650	AUTH_TAG_NO

Bibliographic

Useful for getting Bibliographic reports that gives the Catalogue Marc Tags in full. This allows for multiple Subject Headings and notes displaying.

Examples include:

New Fiction collection along with the blurb
New records with full catalogue display
Subject listings for a Department – for example within the Science Department etc.
Bibliography showing multiple Authors, including 100 (Main) and 700 (Added) Authors included
It is possible to report on a Catalogue File if required which is useful for Subject Lists and Newly received Files through Marc Take Up

Data Element	Description	Example	Database Name - from CATALOGUE unless shown
Author	Author as shown in the 1^st line of the Catalogue Display – usually Author	Winton, Tim, 1960-	CAT_STR1
Author Key	Author as stored by the Database, without punctuation,stopwords and all capitalized	WINTON TIM	CAT_KEY1
Call No	Call No as shown in the Catalogue	B/WIN	CAT_STR4
Call No Key	Call No as stored by the Database without punctuation and all capitalized	B WIN	CAT_KEY4
Catalogue Created By	Amlib Operator who created the Catalogue record	SSTAFF	CAT_CREATE_OPERATOR
Catalogue Date Created	Date the Catalogue record was created	19/01/2015	CAT_CREATE_DATETIME
Catalogue File Date	File Date created or Date modified.	22/06/2015	FILE_DATE
Catalogue File Description	Description used to Name the File	SCIS 22/06	FILE_DESC
Catalogue File Entries	The number of entries within the File	121	FILE_QTY
Catalogue File Number	The unique File Number. This is recommended to pinpoint a particular File (as the description may not be unique to each File)	3554	FILE_NUMBER
Catalogue File Operator	File Operator (User name)	STAFF	FILE_OPER
Catalogue File Operator Access	Whether other Users are allowed to access the File Y/N	Y	FILE_OPER_ACCESS
Catalogue Indicator 1	Indicator 1 as shown within the Catalogue Data Tag	4	BIBVIEW.INDICATOR1
Catalogue Indicator 2	Indicator 2 as shown within the Catalogue Data Tag	5	BIBVIEW.INDICATOR1
Catalogue Lib Group	Lib Group for the Catalogue record	LIB	CAT_LIB_GROUP
Catalogue Modified By	Catalogue last modified by this Amlib User	JSTAFF	CAT.OPERATOR
Catalogue Ref Number	Catalogue Reference ID	67819	CAT_ NO
Catalogue Tag Data	Data associated with that Marc Tag	978-1-567-24526-8	BIBVIEW.TAG_DATA
Catalogue Tag Description	Description of the Catalogue Tag	Subject – Topical Term	TT.TAG_DESCRIPTION
Catalogue Tag Number	Catalogue Tag Number	020	BIBVIEW.TAGNO
Catalogue Tag Seq	Catalogue Tag Sequence	24500	BIBVIEW.CATSEQUENCE
Catalogue Updated	Date/Time that the Catalogue was last updated. Default is to show the Date but Time can be formatted to display	29/09/2010	CAT_DATETIME
Non Authority Details	Only appears in Oracle OpenReports version. Non Authority data up to 250 characters
Non Authority Details Long	Only appears in Oracle OpenReports version. Non Authority data over 250 characters
Publisher	Publisher as shown in the 3rd line of the Catalogue Display – usually Publisher	London, Puffin : 2015	CAT_STR3
Publisher Key	Publisher as shown as stored in the Database, without punctuation and capitalized	London Puffin 2016	CAT_KEY3
Title	Title as shown in the 2nd line of the Catalogue Display – usually Title	Molly’s revenge	CAT_STR2
Title Key	Title as shown as stored in the Database, without punctuation, stopwords and capitalized	MOLLYS REVENGE	CAT_KEY2

Borrower

Countless Reports can be derived from the Borrower Report Entity. Ideas may include:

Borrower joined since a certain date
Borrowers with a particular Type, Group or Class
Borrowers without email addresses
Borrowers with email addresses but Borrower Use Email is set to N
Borrowers without email addresses but Borrower Use Email is set to Y
Borrowers with a particular Postcode
Borrowers with a balance greater that a certain amount
Borrowers with Memos
Borrowers with a certain Memo Type
Borrower where Total Loans counts exceeds a set number (e.g. 1000)
List of Borrowers and associated Email address
Telephone list
Class Lists
Status reports – all Borrowers with Status other than OK
Registration due to come up in the next month
Count by Class, Type etc.

Data Element	Description	Example	Database Name - from BORROWER unless shown
Borrower Address1 Full	Borrower Address shown as displayed in the Borrower Details Window for the first line of the Address. Usually displays, all the Address lines as well as the Telephone and Postcode, concatenated to one line and split by commas	0345677654 Unit 1, 15 Haddin Way, Bedford, WA, 6115	BOR_ADDR1_TXT
Borrower Address1 Line1	Borrower Address as shown in the First Address Field of the Borrower – first line.	Unit 4	BORADDR.BA_ADDR1
Borrower Address1 Line2	Borrower Address as shown in the First Address Field of the Borrower – second line	Tiger Lane	BORADDR.BA_ADDR2
Borrower Address1 Line3	Borrower Address as shown in the First Address Field of the Borrower – third line	Chelsea	BORADDR.BA_ADDR3
Borrower Address1 Line4	Borrower Address as shown in the First Address Field of the Borrower – fourth line	Australia	BORADDR.BA_ADDR4
Borrower Address1 Postcode	Postcode as shown in the Postcode Field of the Borrower Address 1	3145	BORADDR.BA_PCODE
Borrower Address1 Telephone	Telephone as shown in the Telephone Field of the Borrower Address 1	0345677654	BORADDR.BA_TELEPHONE
Borrower Address2 Full	Borrower Address shown as displayed in the Borrower Details Window for the second line of the Address. Usually displays, all the Address lines as well as the Telephone and Postcode, concatenated to one line and split by commas for this second address.	0345677654 Unit 1, 15 Haddin Way, Bedford, WA, 6115	BOR_ADDR2_TXT
Borrower Address2, Line 1	Address 2, Line 1	13 Station St	BORADDR2.BA_ADDR1
Borrower Address2, Line 2	Address 2, Line 2	Bedford	BORADDR2.BA_ADDR2
Borrower Address2, Line 3	Address 2, Line 3	WA 6115	BORADDR2.BA_ADDR3
Borrower Address2, Line 4	Address 2, Line 4	Australia	BORADDR2.BA_ADDR4
Borrower Address2 Postcode	Postcode as shown in the Postcode Field of the Borrower Address 2		BORADDR2.BA_PCODE
Borrower Address2 Telephone	Telephone as shown in the Telephone Field of the Borrower Address 2		BORADDR2.BA_TELEPHON E
Borrower Address3 Full	Borrower Address shown as displayed in the Borrower Details Window for the third line of the Address. Usually displays, all the Address lines as well as the Telephone and Postcode, concatenated to one line and split by commas for this second address.	0345677654 Unit 1, 15 Haddin Way, Bedford, WA, 6115	BOR_ADDR3_TXT
Borrower Address3, Line 1	Address 3, Line 1	13 Station St	BORADDR3.BA_ADDR1
Borrower Address3, Line 2	Address 3, Line 2	Bedford	BORADDR3.BA_ADDR2
Borrower Address3, Line 3	Address 3, Line 3	WA 6115	BORADDR3.BA_ADDR3
Borrower Address3, Line 4	Address 3, Line 4	Australia	BORADDR3.BA_ADDR4
Borrower Address3 Postcode	Postcode as shown in the Postcode Field of the Borrower Address 3		BORADDR3.BA_PCODE
Borrower Address3 Telephone	Telephone as shown in the Telephone Field of the Borrower Address 3		BORADDR3.BA_TELEPHON E
Borrower Area Code	Borrower Area code	NW	BORADDR.BA_AREA_CD
Borrower Area Code Details	Borrower Area Description of Code	North West	AREA.AREA_NAME
Borrower Balance	Balance of money owing	24.00	BOR_OWING
Borrower Barcode	Barcode or ID of Borrower	B24256	BOR_BAR_NO
Borrower Class	Borrower Class Code	RM9	BOR_CLASS
Borrower Class Details	Class Code description	Room 9 – Mr Evans	BORCLASSES.BC_NAME
Borrower Count	Count of Borrower depending on the Filter used	25	#Function#
Borrower Date of Birth	Borrower Date of Birth (Format can be altered for the report)	21/03/1981	BOR_DOB
Borrower Email	Borrower Email address	Steven.evans@iinet. net.au	BOR_EMAIL
Borrower Exclude from Debt Collection	Borrower exclude from Debt Collection setting Y/N	N	BOR_DC_EXCLUDE
Borrower File Date	File Date created or Date modified.	22/06/2015	FILE_SET_NAMES.FILE_DAT E
Borrower File Description	Description used to Name the File	Admin Load 22/06	FILE_SET_NAMES. FILE_DESC
Borrower File Entries	The number of entries within the File	121	FILE_SET_NAMES.FILE_QTY
Borrower File Number	The unique File Number. This is recommended to pinpoint a particular File (as the description may not be unique to each File)	3554	FILE_SET_NAMES. FILE_NUMBER
Borrower File Operator	File Operator (User name)	STAFF	FILE_SET_NAMES. FILE_OPER
Borrower File Operator Access	Whether other Users are allowed to access the File Y/N	Y	FILE_SET_NAMES. FILE_OPER_ACCESS
Borrower File Date	File Date created or Date modified.	22/06/2015	FILE_SET_NAMES.FILE_DAT E
Borrower Full Name- Given, Surname	Concatenated Borrower Given and Surnames in one string	Tom Strange	#Function#
Borrower Full Name- Surname, Given	Concatenated Borrower Surname and Given Name	Strange, Tom	#Function#
Borrower Gender	Borrower Sex/Gender	F	BOR_SEX
Borrower Given Name	Borrower Given Name	Steven	BOR_GIVEN
Borrower Group	Borrower Group Code	GOLD	BOR_GROUP
Borrower Group Details	Description of Borrower Group Code	GOLD FACTION	BORGROUPS.BG_NAME
Borrower Guardian address	Borrower Guardian address as shown in Address 3	Mr Taylor, 19 The Crescent, Maylands WA 2522.	BOR_ADDR3_TXT
Borrower Initial	Initial for Middle Name	T.	BOR_INIT
Borrower Joined Date	Date that Borrower joined the Library (format can be altered within the report)	24/05/2013	BOR_START_MSHIP
Borrower Joined Location	Location Code - where Borrower joined the Library	CHEL	BOR_START_LOCATION
Borrower Joined Location Details	Location Description of the Code - where Borrower joined the Library	Chelsea	LIB_LOCATIONS31.LL_NAM E
Borrower Last Active	Date that Borrower last entered barcode for Circulation / Visit (Barcode was entered)	21/05/2015	BOR_LASTACTIVE
Borrower Last Status Update	Status last modified	21/11/2014	BOR_STATUS_DATE
Borrower Last Updated	Last time the Borrower Details were saved. Default is to show the date but time can be used to format differently	21/11/2014	BOR_DATETIME
Borrower Lib Group	Library Group for Location	LIB	BOR_LIB_GROUP
Borrower Loans Count	Borrower Total Loans as shown in the Borrower History	5	BOR_NO_ LOANS
Borrower Location	Current Location of Borrower	CHEL	BOR_LOCATION
Borrower Location Details	Description of Current Borrower Location	Chelsea Public Library	LIB.LOCATIONS31.LL_NAM E
Borrower Memo Date	Memo Date of Borrower’s Memo. Format can be altered within report	22/04/2014	BOR_MEMOS.BM_EFF_DA TE
Borrower Memo Details	Memo Text of Borrower’s Memo	Left umbrella	LIB_MEMOS.LM_DESC
Borrower Memo Type	Memo Type for Borrower’s Memo	ADDRESS	BOR_MEMOS.BM_TYPE
Borrower Memo Type Details	Description for Borrower Memo Type	Change of Address required	LIB_MEMOS.LM_DESC
Borrower Mobile Number	Mobile Telephone Number of Borrower	0411889933	BOR_MOBILE_TEL
Borrower PIN	Personal Identifier Number for Borrower	9999	BOR_PIN
Borrower Ref1	Data entered in Reference1 Field of Borrower. Free Text field and label can be altered through Supervisor, Installation Parameters	Page 264 Registration Book	BOR_REF1
Borrower Ref2	Data entered in Reference2 of Borrower. Free Text field and label can be altered through Supervisor, Installation Parameters	HILTOM	BOR_REF2
Borrower Registration Date	Date set for Borrower Registration	22/09/2017	BOR_REGDATE
Borrower Status	Borrower Status as currently shown within Borrower	OK	BOR_STATUS
Borrower Suburb Code	Suburb Code	BED	BA_SUBURB_CD
Borrower Suburb Code Details	Description of Suburb Code	Bedford	SUBURB.SUBURB_NAME
Borrower Surname	Borrower Surname or Family name	SMITH	BOR_SURNAME
Borrower Title	Title if given within Borrower Details	MR	BOR_TITLE
Borrower Total Renews	Number in total of Renewal as shown in Borrower History	24	BOR_NO_RENEWS
Borrower Total Reserves	Number in total of Reserves as shown in Borrower History	33	BOR_NO_RESERVES
Borrower Total Loans	Number in total of Loans as shown in Borrower History	1919	BOR_NO_LOANS
Borrower Total Visits	Number in total of Visits (Barcode used within Circulation tasks) as shown in Borrower History	50	BOR_NO_VISITS
Borrower Type	Borrower Type Code	A	BOR_TYPE
Borrower Type Details	Description given to Borrower type Code	Adult	BOR_TYPES.BT_NAME
Borrower Use Email	Borrower Use Email within Reports Y/N?	Y	BOR_USE_EMAIL
Borrower Use Mobile	Borrower Use Mobile within Reports Y/N	N	BOR_MOB_USFN
Borrower Ward Code	Ward Code of Borrower	SP	BA_WARD_CD
Borrower Ward Code Details	Description of Ward Code	South Perth	WARD.WARD_NAME

Borrower Addresses

The Headings that display in the Borrower Address Fields can be customised within Supervisor For example, first Address could be Postal

Counter

Enables a Count to be made of the Group Data Fields

Data Element	Description	Example	Database Name
Group Details Count	Include this field in your Display Fields and the report will contain a count of items per field(s) in the Group Fields	22	#Function#

There are different Entities as associated Data Fields to use depending on whether your Database is running Single or Double Financials To check whether you are running Single or Double entry Financials:

Launch the Amlib client
Go to Main > Supervisor > Installation – the Installation (DEFAULT) screen will display
Select the System tab
Scroll down and check the following setting: Use Double Entry Accounting
If set to N, then your system is set to single-entry accounting
If set to Y, then your system is set to double-entry accounting

Borrower financial - Double entry

Field names alter depending on whether the transactions for Borrower Financials are on a Double entry or Single entry. The Fields below are for Double entry only. This table can be combined with Borrower to get the details of Financial Transactions

A Special View (Financial Link View) of the database allows separate access to the Double and Single Financial Transactions

A Special View (Financial Link View) of the database allows separate access to the Double and Single Financial Transactions Samples of reports

Borrowers still owing money
Transactions over a date period
Receipt Nos associated with payments

Data Element	Description	Example	Database Name From Special View created as Financial link View
DTransaction Amount Owing	Amount owing from the transaction	20.00	FINANCIALLINKVIEW.OUTSTANDING
DTransaction Borrower Name	Borrower Name as shown in the Transaction		FINANCIALLINKVIEW.BORROWERNAME
DTransaction Charge Amount	Debit transaction amount	30.00	FINANCIALLINKVIEW.VALUE
DTransaction Comments	Comments associated with the transaction		FINANCIALLINKVIEW.COMMENTS
DTransaction Credit or Debit	Whether the transaction was a CR - Credit (payment) or DB - Debit (charge)	CR	FINANCIALLINKVIEW.CRDB
DTransaction Date	Date for the Transaction – Format can be altered within the report	15/04/2015	FINANCIALLINKVIEW.DATEENTERED
DTransaction Invoice Date	Date for the Invoice	13/04/2015	FINANCIALLINKVIEW.INVDATE
DTransaction Invoice Number	Invoice Number included in the Transaction	13667	FINANCIALLINKVIEW.INVNUMBER
DTransaction Item Barcode	Associated Stockitem barcode for transaction		FINANCIALLINKVIEW.ITEMBARCODE
DTransaction Item Title	Associated Stockitem Title for transaction	The high tide	FINANCIALLINKVIEW.ITEMTITLE
DTransaction Last Modified	Date the Transaction was modified	13/04/2015	FINANCIALLINKVIEW.DATEMODIFIED
DTransaction Location	Location Code at which Transaction occurred	Chelsea	FINANCIALLINKVIEW.LOCATION
DTransaction Location Details	Description of Transaction Location Code	Chelsea Public Library	LIBLOCATIONS16 - LLNAME
DTransaction Paid	Paid amount	10.00	FINANCIALLINKVIEW.PAID
DTransaction Paid Calculation	Paid amount Amount paid calculation	20.00	#Function#
DTransaction Quantity	Quantity of items/days	30	FINANCIALLINKVIEW.QTY
DTransaction Receipt No	Receipt Number of payment	76544	FINANCIALLINKVIEW.RECEIPTNUMBER
DTransaction Type	Transaction Type Code	FINE	FINANCIALLINKVIEW.TYPE
DTransaction Type Details	Description of Transaction Type Code	OVERDUE FINE	FINTYPES.FIN_DESC

Borrower financial – Single entry

There is a special Data element of “Transaction Amount Owing which can be useful for Filtering

Samples of reports

Borrowers still owing money
Transactions over a date period
Receipt Nos associated with payments

Data Element	Description	Example	Database Name - from FIN_TRANS unless shown
Transaction Amount Owing	Amount owing from the transaction	20.00	#Function#
Transaction Borrower Name	Borrower Name as shown in the Transaction	Smith, Julian	FIN_NAME
Transaction Charge Amount	Debit transaction amount	30.00	FIN_VALUE
Transaction Comments	Comments associated with the transaction	Renewed item was overdue	FIN_COMMENTS
Transaction Credit or Debit	Whether the transaction was a CR - Credit (payment) or DB - Debit (charge)	CR	FIN_CR
Transaction Date	Date for the Transaction – Format can be altered within the report	15/04/2015	FIN_DATE
Transaction Invoice Date	Date for the Invoice	13/04/2015	FIN_INV_DATE
Transaction Invoice Number	Invoice Number included in the Transaction	13667	FIN_INV_NO
Transaction Item Barcode	Associated Stockitem barcode for transaction	I89321	FIN_ITEM
Transaction Item Title	Associated Stockitem Title for transaction	The high tide	FIN_TITLE
Transaction Last Modified	Date the Transaction was modified	13/04/2015	FIN_DATE_MOD
Transaction Location	Location Code at which Transaction occurred	Chelsea	FIN_LOC
Transaction Location Details	Description of Transaction Location Code	Chelsea Public Library	LIBLOCATIONS4.LLNAME
Transaction Paid	Paid amount	10.00	FIN_PAID
Transaction Quantity	Quantity of items/days	30	FIN_QTY
Transaction Receipt No	Receipt Number of payment	76544	FIN_RECEIPT
Transaction Type	Transaction Type Code	FINE	FIN_TYPE
Transaction Type Details	Description of Transaction Type Code	OVERDUE FINE	FIN_TYPES.FIN_DESC

Borrower history

Borrower History allows the reporting of items associated with Borrowers through History. Once selected it is possible to also select from the Borrower Entity. These reports will only work if the READING history is kept. Many sites use the RETURN history instead which actually comes from the Stockitem History so it maybe preferable to use Stockitem History to get the results required

Samples may include

List of Items issued by a Class
Count of items issued by a Borrower Type
Borrowers activity between a date range
List of Accounts sent through Report History

Data Element	Description	Example	Database Name BOR_HISTORY – unless shown
Borrower History Comments	Comment recorded within History	“980393755 Mindpower : set your sights on success”	BH_COMMENTS
Borrower History Date	Date as displayed in History Table. **Note: Date and time element	6 March 2015 9:00AM	BH_DATE
Borrower History Title	Item Title	The Gift Horse	STK_TITLE
Borrower History Type	There are choices of Borrower history types	ACCOUNT,ACCT, CLAIMRET, READING, RESADV, RESCANC	BH_TYPE

**Note: Date and time element. When Filtering with a Date that also includes a time, it is better to use a range of DateS rather than an equal.

For example Borrower History Date >= 15/04/2015 AND Borrower History Date < 16/04/2015 rather than Borrower History Date = 15/04/2015 so that all time periods are correctly accounted

Catalogue

There is no separate Catalogue Entity - To get Catalogue information use the Bibliographic Entity as the Date Catalogue created is included within that Entity and this entity gives much more scope for display.

Current loans

Loans are accessed from the Borrower Entity and Stockitem Entity to get the details required. For example Issue Date and Issue Date Due are in the Stockitem Entity

Data Element	Description	Example	Database Name LOANS.VIEW – unless shown
Item Issue Date	Date the item was issued	12/02/2015. Can include Time element if Format set	STK_ISS_DATE
Item Issue Due Back Date	Date the item is due for return	12/03/2015	STK_ISS_DUE
Item Issue Location	Location Code at which the Issue transaction took place	CHEL	STK_ISS_LOC
Item Issue Location Details	Description of the Location Code where the Issue took place	Chelsea Public Library	LIB_LOCATIONS.LL_NAME
Item Issue Times Renewed			STK_ISSUE_RENEWED
Item Issue Type	How the Issue was processed – Hourly, Overnight, Daily, Term, Semester, Yearly	D	STK_ISSUE_TYPE

OPAC requests or suggests

These requests are derived from NetOpacs and/or OpenOPAC. This Report Type is from the Supervisor/Opac Suggests Table and can include the Request details and the Library Response

Data Element	Description	Example	Database Name OPAC_USER_COMMENTS unless shown
OPAC Accept Cost	Whether patron will accept cost Y?N	N	OUC_COSTACCEPT
OPAC Author	Details entered on Line 2 of the form – usually Author		OUC_LINE2
OPAC Call No	Details entered on Line 6 of the form – usually Call No		OUC_ LINE6
OPAC Comments	Comments entered for the request		OUC_COMMENTS
OPAC Date	Date of the request		OUC_DATE
OPAC Estimated Cost	Estimated cost of the request		OUC_ESTCOST
OPAC Form code	Form code of the item requested	DVD	OUC_FORM
OPAC ISBN	ISBN of the item requested		OUC_ISBN
OPAC Library Response	Notes given by the Library Staff as a response	Your request has been received. We will respond by the end of the week	OUCR_LIBRESPONSE
OPAC Location	Location Code of the Request	CHEL	OUC_LOCATION
OPAC Location Details	Location Description of the Code from the Request	Chelsea Public Library	LIBLOCATIONS8.LL_NAME
OPAC Notes	Notes from the Request	Urgent request	OUC_NOTES
OPAC Publisher	Details entered on Line 6 of the form – usually Call No	Penguin, London	OUC_LINE3
OPAC Reply Date	Reply date of the response given by Staff	Not used 15/06/2015	OUCR_DATE
OPAC Reply Type	Reply type of the response given by Staff	Not used	OUCR_TYPE
OPAC Series	Details entered on Line 4 of the form – usually Series	Animorphs	OUC_LINE4
OPAC Subject	Details entered on Line 5 of the form – usually Subject	Family - Fiction	OUC_LINE5
OPAC Title	Details entered on Line 1 of the form – usually Type	Breathe	OUC_LINE1
OPAC Type	Request details: All are Item now so not used	Item, Borrower or Opac.	OUC_TYPE

Periodicals

Periodicals have 4 main levels all of which are available under the Periodical Master Headings:

Main Periodical
Subscription
Issue details
Copy details Useful reports include:
Current Periodicals with a current Subscription
Issues with a Claim
Cost of Subscription for each Periodical
List of Main Titles
Issues associated with a certain Periodical
Renewals due in the next 3 months
Items received since a certain date

Data Element	Description	Example	Database Name
Periodical Call No	Call No as shown on the Copies window	REF PER NAT	PER_COPY.PC_CALL_NO
Periodical Circulation List	Circulation List	1234	PER_SUBS.PS_CIRC_LIST
Periodical Copies Due	The Number of Copies of Issues Due still due, on the Subscriptions/Issues window of Amlib	1	PER_ISSUES.PI_QTY_SUB
Periodical Copies Per Issue	The Number Copies Issues Due in total. This can be seen on the Subscriptions window	2	PER_SUBS.PS_QTY_DUE
Periodical Copies Received	The Number Issues Received. This can be seen on the Subscriptions/Issues window of Amlib	1	PER_ISSUES.PI_QTY_RECD
Periodical Copy Barcode	Barcode of the Stockitem received from Periodical	I984332	PER_COPY.PC_STK_ITEM_NO
Periodical Copy Title	Copy Description as shown in the Periodical Module (Issue Details)	Volume 49 Index No 1- 4 Supplement to Reading Time Vol 50 No 1 2006	PER_COPY.PC_DESCRIPTION
Periodical Date Recd	Date that the copy was received	12/03/2015	PER_COPY.PC_DATE_RECD
Periodical Description	Description of the Issue	Vol 1. No 16, July 2015	PER_ISSUES.PI_DESCRIPTION
Periodical Form Code	Form Code as set in Stock Defaults	PER	PERIODICAL.PER_STK_FORM
Periodical Frequency	Frequency for the Periodical Subscription	M	PERIODICAL.PER_FREQ
Periodical ISSN	ISSN as shown on the Periodical	6554-1223	PERIODICAL.PER.ISSN
Periodical Issue Catalogue	Catalogue Reference attached to a Periodical Issue	389112	PER_ISSUES.PI_CAT_REF
Periodical Issue Claim	Where a Claim has been made against an Issue Y/N	N	PER_ISSUES.PI_CLAIM
Periodical Issues Per Subs	The Number of Issues for each Subscription	12	PER_SUBS.PS_QTY_ISSUES
Periodical Item Stats Code	Form Code as set in Stock Defaults	JPER	PERIODICAL.PER_STATS_CODE
Periodical Main Title	The Title given to the Main Periodical Details	Better homes and gardens	PERIODICAL.PER_TITLE
Periodical Subs Comments	Comments related to the Subscription	Trial in 2015	PER_SUBS.PS_COMMENTS
Periodical Subs Cost	Cost for the Subscription	144.00	PER_SUBS.PS_COST
Periodical Subs Cost per Issue	Subscription cost per Issue as calculated by the No of Issues and Subscription cost	12.50	PER_SUBS.PS_COST_ISSUE
Periodical Subs End Date	The final date for the Subscription	31/12/2015	PER_SUBS.PS_END_DATE
Periodical Subs Lib Group	The Library Group for the Subscription	LIB	PER_SUBS.PS_LIB_GROUP
Periodical Subs Location	The Location Code for the Subscription	CHEL	PER_SUBS.PS_LL_CODE
Periodical Subs Location Details	The Description given to the Location Code of the Subscription	Chelsea Public Library	LIB_LOCATIONS7.LL_NAME
Periodical Subs Renewal Date	The Renewal Date given to the Subscription	15/11/2015	PER_SUBS.PS_RENEW_DATE
Periodical Subs Start Date	The beginning date of the Subscription	01/01/2015	PER_SUBS.PS_START_DATE
Periodical Subs Supplier	The Supplier Code for the Subscription	CNEW	PER_SUBS.PS_SUPP_NO
Periodical Supplier Details	The Description given to the Supplier Code	Chelsea Newsagent	PER_SUPPLIER.PS_COMPANY

RESERVATIONS

Can combine with Borrower to get the current reservations and reservation statuses

Reservations with status of Printed - Printed several days ago but not collected
Reservations with status of Return
Reservations placed at a location
Reservations to be collected at a location
Reservations by an individual
Counts of Borrowers - No of reservations determined by the filter
Counts of Items - No of reservations determined by the filter
Reservation Placed in the past week/month etc.
Reservations passed the Expiry date
Queue No of individuals

Data Element	Description	Example	Database Name – Reservations Table unless shown otherwise
Reservation All or First	Whether Reservation was placed for all copies or the first copy only F - First/A-All	F	RES_ALL_OR_FIRST
Reservation Collection Location	Location code at which the Reservations will be collected	CHEL	RES_COLL_LOCATION
Reservation Collection Location Details	Location Description assigned to the code at which the Reservations will be collected	Chelsea Public Library	LIB_LOCATIONS91.LL_NAME
Reservation Date Placed	Date the reservations were placed	12/05/2015	RES_DATE
Reservation Expiry Date	Date the reservations expired (set by Supervisor/Installation parameters)	19/05/2015	RES_EXPIRY
Reservation Item Title	Item Title for the Reservation	Breath	RESERVATIONSTOCKITEMVIEW.STK_LINE1
Reservation Placed Location	Location code at which the Reservations were placed	CHEL	RES_PLACED_LOC
Reservation Placed Location Details	Location Description assigned to the code at which the Reservations were placed	Chelsea Public Library	LIB_LOCATIONS9.LL_NAME
Reservation Position in Queue	Queue position for the reservation. Generally in sets of 5 (5,10,15 etc)	10	RES_PRIORITY
Reservation Status	Status of Reservation: ILLS, ON LOAN, ORDER, PRINTED, RETURN, SHELF, TRANSFER	PRINTED	RES_STATUS
Reservation User Placed	Amlib Operator who placed the reserve	STAFF	RES_WHO_PLACED

STATISTICS

Statistics can be shown effectively as graphs

Issues per month for the last year
All activity this Financial year

Data Element	Description	Example	Database Name – STATS unless shown otherwise
Statistics Borrower Area	Borrower Area Code at the time of the Statistics collection	Metro	STATS_AREA_CD
Statistics Borrower Area Details	Description of the Area Code	Metropolitan	AREA.AREA_NAME
Statistics Borrower Class	Borrower Class Code at the time of the Statistics collection	Rm5	STATS_BOR_CLASS
Statistics Borrower Class Details	Description of the Class Code	Room 5 – Mr Davies	BORCLASSES.BC_NAME
Statistics Borrower Group	Borrower Group Code at the time of the Statistics collection	E	STATS_BOR_GROUP
Statistics Borrower Group Details	Description of the Class Code	Endeavour	BORGROUPS.BG_NAME
Statistics Borrower Suburb	Borrower Suburb Code at the time of the Statistics collection	BEL	STATS_SUBURB
Statistics Borrower Suburb Details	Description of the Suburb Code	Belmont	SUBURBS.SUBURBS_NAME
Statistics Borrower Type	Borrower Type Code at the time of the Statistics collection	A	STATS_BOR_TYPE
Statistics Borrower Type Details	Description of the Borrower Type Code	Adult	BORTYPES.BT_NAME
Statistics Borrower Ward	Borrower Ward Code at the time of the Statistics collection	NW	STATS_WARD
Statistics Borrower Ward Details	Description of the Borrower Ward Code	North West Metro	WARDS.WARD_NAME
Statistics Count	Count calculated brought back from the Database	215	STATS_COUNT
Statistics Day 0123456	Day of collection of statistics 0 Sunday, 1 Monday etc.	1	STATS_DAY
Statistics Hour 0 24	Hour of collection of statistics in 24 hour format	12	STATS_HOUR
Statistics Item Form	Item Form Code at the time of the Statistics collection	DVD	STATS_STK_FORM
Statistics Item Stats Code	Item Stats Code at the time of the Statistics collection	AF	STATS_STK_CODE
Statistics Item Stats Code Details	Description of the Item Stats Code	Adult Fiction	STK_CODES.STATS_STK_CODE00
Statistics Location	Location Code where the Statistics were collected	LIB	STATS_LL_CODE
Statistics Location Details	Description of the Location Code where statistics collected	Chelsea Public Library	LIB_LOCATIONS.LL_NAME
Statistics Money Amount	Money amount collected	15.00	STATS_MONEY
Statistics Month 0 12	Month of collection of statistics 1 – January to 12 December	IN 10,11,12	STATS_MONTH
Statistics Transaction Date	Date of collection of statistics by specific date	< 31/12/2015	STATS_DATE
Statistics Type 05 06 etc.	Number used for collection of Statistics. See Supervisor, Stats Params (05 – Issues, 06 – Renewals etc.)	05	STATS_TYPE
Statistics Type Details	Description used for Stats parameters	Issues	STATS_CODES.STATS_DESCRIPTION
Statistics Year 2014 etc.	Year of collection of statistics	2015	STATS_YEAR

STOCK HISTORY

Stock History relates to the Item History and provides information in relation to the History set in each Stockitem. This entity can be used in relation to the Stockitem Entity to get the necessary Data Fields such as Title, Call No etc. It can also be used in relation to Borrower to get the Name, Borrower Type, Class etc. as required.

Example of reports could include:

History of a particular item
History by Borrower Type
History by Item Type
History filtered by the History Type

Data Element	Description	Example	Database Name – uses STK_HISTORY Table unless shown otherwise
Stock History Borrower Barcode	Borrower Barcode for the History Transaction	B44332	SH_BOR_NO
Stock History Comments	Comments recorded for the History transaction	Circ issue at VIC by IS1 to RICCI, DEANNE Due: 06/11/2007 11:59 PM	SH_COMMENTS
Stock History Date	Date of the History transaction. It is possible to alter the Format of this to include the hour and minutes as this is kept by the History	dd/mm/yyyy 22/08/2015 dd/mm/yyyy hh:mm tt 22/08/2015 09:54 AM	SH_DATE
Stock History Item	Item Barcode for the History Transaction	I33442	SH_STK_ITEM_NO
Stock History Type	The History Type available includes ORDER, PRICE, TRANSFER, RENEW, RETURN, ISSUE, INHOUSE, RES.HIST	ISSUE	SH_TYPE

STOCKITEMS

From simple lists to complex lists there are many possibilities. For example Items with a Process code showing the cost

There are huge numbers of reports that can be gained using Stockitem on its own or in combination with other Entities – for example with Borrower, History, Reservations etc.

New items
Items with Call Set
Items with Cost
Items with a specific Process, Form, Stats Code etc.
Items at a particular Location
Items without a Catalogue Reference
Items Count by Form
Items Count by Stats Code
Items On Loan
Items Not on Loan
On Order items
Overdue List
Overdue list of Items issued by a Class or Type
Items on loan
Items on loan by Class or Type
ILL items on loan
Overdue ILL
Items issued from a particular Location
Items issued on a particular Day
Items due back on a particular Day
Shelf list of items overdue

Data Element	Description	Example	Database Name – uses STK_ITEM Table unless shown otherwise
Item Author	Stock Line 2 of Stockitem Display – usually Author	Winton, Tim.	STK_LINE2
Item Barcode	Item Barcode as shown on the Stockitem window	I635589	STK_ITEM_NO
Item Call No	Stock Line 6 of Stockitem Display – usually Call No	F WIN	STK_LINE6
Item Call Set	Item Call Set as set via the Call Set Table	FOLK	STK_CALL_SET
Item Call Set Details	Description of the Call set as set on the Call Set Table	Folktales	STK_CALL_SETS.SC_DESC
Item Catalogue Reference	Catalogue reference attached to the Stockitem	139032	STK_CAT_REF
Item Convert Value	Item Convert Value as shown on the Stockitem Window. This Field can have a different Heading as set in Supervisor/Installation	Signed by Author	STK_CONVERT_VALUE
Item Cost	Item Current Cost as shown in the Stockitem Window	25.50	STK_COST
Item Date Accessioned	Date accessioned as shown in the Stockitem Window	12/05/2015	STK_DATE_ACC
Item Date Modified	Date the item was last modified	01/01/2015	STK_DATETIME
Item Date Received	Date the item was received	31/12/2015	STK_DATE_RECD
Item Description	Item Description Value as shown on the Stockitem Window. This Field can have a different Heading as set in Supervisor/Installation	Part of a Big Book set	STK_DESCRIPTION
Item Edition	Edition Field as shown on the Stockitem window. Sometimes shows the Year of publication	2^nd ed.	STK_EDITION
Item File Date	File Date created or Date modified.	22/06/2015	FILE_SET_NAMES1.FILE_DATE
Item File Description	Description used to Name the File	Admin Load 22/06	FILE_SET_NAMES1. FILE_DESC
Item File Entries	The number of entries within the File	121	FILE_SET_NAMES1.FILE_QTY
Item File Number	The unique File Number. This is recommended to pinpoint a particular File (as the description may not be unique to each File)	3554	FILE_SET_NAMES1. FILE_NUMBER
Item File Operator	File Operator (User name)	STAFF	FILE_SET_NAMES1. FILE_OPER
Item File Operator Access	Whether other Users are allowed to access the File Y/N	Y	FILE_SET_NAMES1. FILE_OPER_ACCESS
Item Floor Location	Floor location as shown on the Stockitem window	Map drawer	STK_LOC_FLOOR
Item For Loan?	Whether the item is allowed to be loaned or not. Y/N	N	STK_FOR_LOAN
Item Form	Item Form Code as currently set. Usually the basis for the Loan parameters	LP	STK_FORM
Item Form Details	Description of the Item Form Code	Large Print Book	STK_FORMS.STK_FORM_DESC
Item is on Loan?	Whether the item is on loan or not. Y/N	Y	STK_IS_ON_LOAN
Item is on Order?	Whether the item is on Order. Y/N	N	STK_IS_ON_ORDER
Item is on Reserve?	Whether the item is reserved. Y/N	Y	STK_IS_RESERVED
Item Last Active Date	Date of last active Circulation activity	12/05/2015	STK_LAST_ACTIVE
Item Last Depreciation Date	Date of the last depreciation process	30/06/2015	STK_LAST_DEP
Item Library Group	Library Group related to the permanent Location	LIB	STK_LIB_GROUP
Item Loan Type	Item Loan Type if this applies. This is set on the Stockitem window and overwrites normal borrowing privileges	OV	STK_LOAN_TYPE
Item Memo Date	Item Memo Date created	23/06/2015	STK_MEMOS.SM_EFF_DATE
Item Memo Details	Item Memo Details contained in the Memo	Item is damaged. Repair on return	STK_MEMOS.SM_DATA
Item Memo Type	Memo Type from Supervisor/Memo Types Table used by Item	SBARCODE	STK_MEMOS.SM_TYPE
Item Memo Type Details	Memo Type Description from Supervisor/Memo Types Table for the Memo Type	System change barcode rule	LIB_MEMOS1.LM_DESC
Item Original Cost	Original Cost as set in Stockitem/History	15.00	STK_ORIG_COST
Item Perm Location	Permanent Location Code currently assigned to the item	CHEL	STK_LOC_PERM
Item Perm Location Details	Description of the Permanent Location Code	Chelsea Public Library	LIB_LOCATIONS122.LL_NAME
Item Process Code	Process or Status Code as set on the Stockitem window	MISSING	STK_PROCESS
Item Process Date	Date the process was assigned to the Stockitem	01/01/2013	STK_PROCESS_DATE
Item Publisher	Line 5 of the Stockitem Display – usually Publisher	London : Penguin, 2019.	STK_LINE5
Item Series	Line 4 of the Stockitem Display – usually Series	Animorphs v6.	STK_LINE4
Item Show in Opac?	Whether the Stockitem can be displayed in Opac Y/N	Y	STK_OPAC_SHOW
Item Source	The Origin Code of the Stockitem. Some sites use this to populate a Supplier or funding	DYM	STK_ITEM_ORIGIN
Item Stats Code	The Stats Code of the Stockitem	JF	STK_ITEM_STATS
Item Stats Code Details	The description of the Stockitem Stats Code	Junior Fiction	STK_CODES.STK_CODE_DESC
Item Stocktake Date	The date of the last Stocktake as shown in Stockitem History/Stocktake	01/12/2014	STK_LAST_TAKE
Item Subject	Line 3 of the Stockitem Display – usually Subject. Note that the Stockitem only shows 1 of the Subjects from the Catalogue	Family - Fiction	STK_LINE3
Item Temp Location	The Temporary Location Code that is displayed on the Stockitem window	ARM	STK_LOC_TEMP
Item Temp Location Details	The description of the Temporary Location Code	Armadale Public Library	LIB_LOCATIONS121.LL_NAME
Item Times Borrowed Total	The number of times borrowed since the beginning or since Period set as displayed in the Stockitem History	360	STK_TIMES_BORROWED
Item Times Renewed Total	The number of times renewed since the beginning or since Period set as displayed in the Stockitem History	24	STK_TIMES_RENEWED
Item Times Reserved Total	The number of times reserved since the beginning or since Period set as displayed in the Stockitem History	29	STK_TIMES_RESERVED
Item Title	The Main Title of the item	Black horse island	STK_LINE1
Item Type	Whether the Item is a Normal item, a Master or a Subsidiary. Note: Master and Subsidiary items are usually given to Kits and their Contents	Normal	STK_ITEM_TYPE
Item Volume	The Volume as shown on the Stockitem. This is sometimes set to the Series No	V22	STK_VOLUME