Home / Library Software / Handy Library Manager / Tutorials: Database list, field names, field position

Handy Library Manager  for Windows

Help, how to topics > Options > Handy library databases, field names, field positions


We recommend backing up your databases before changing field names or any configuration files.

Below you will find all library database tables. Review tables before you try to modify field names or add/edit data forms.


LIBRARY:

field name

position

change name

IDNO 1 -
TITLE 2 YES
AUTHOR 3 YES
TYPE 4 -
COAUTHORS 5 YES
PUBLISHER 6 YES
PUBLISHED 7 YES
PLACE 8 YES
SERIES 9 YES
EDITION 10 YES
CATEGORY 11 YES
LEVEL 12 YES
FORMAT 13 YES
EDITOR 14 YES
ILLUSTRATOR 15 YES
PAGES 16 YES
PHYSICAL 17 YES
DEWEY 18 YES
LCCN 19 YES
ISBN 20 YES
ISSN 21 YES
UPC_EAN 22 YES
SUBJECT1 23 YES
SUBJECT2 24 YES
SUBJECT3 25 YES
SUBJECTS 26 YES
NOTES 27 YES
SUMMARY 28 YES
IMAGE 29 YES
CUSTOM1 30 YES
CUSTOM2 31 YES
CUSTOM3 32 YES
CUSTOM4 33 YES
CUSTOM5 34 YES
CUSTOM6 35 YES
CUSTOM7 36 YES
CUSTOM8 37 YES
CUSTOM9 38 YES
PRINT 39 -

LIB_COPIES:

field name

position

change name

ID 1 -
IDNO 2 -
BARCODE 3 -
CALL 4 YES
VOLUME 5 YES
LOAN_TYPE 6 YES
COPY_NOTES 7 YES
LOCATION 8 YES
CONDITION 9 YES
PURCHASED 10 YES
PRICE 11 YES
REPLACE_COST 12 YES
EVALUATED 13 YES
VALUE 14 YES
ACQUISITION 15 YES
ACQUISITIONNO 16 YES
DONATEDBY 17 YES
INMEMORYOF 18 YES
DONATED 19 YES
DATE_ADDED 20 -
LOANED 21 YES
STATUS 22 -
INVENTORY 23 YES
AUDIT 24 -
MISSING 25 -
PRINT_C 26 -
USER1 27 YES
USER2 28 YES

BORROWERS:

field name

position

change name

DATE_ADDED 1 -
BOR_IDNO 2 -
NAME 3 YES
BARCODE 4 -
TYPE 5 -
STATUS 6 -
EXPIRY 7 YES
ADDRESS1 8 YES
ADDRESS2 9 YES
CITY 10 YES
STATE 11 YES
ZIP 12 YES
PHONE 13 YES
CELL 14 YES
SENDTXTMSG 15 YES
EMAIL 16 YES
SENDEMAILS 17 YES
COMMENTS 18 YES
PICTURE 19 YES
NOTES 20 YES
LASTEMAIL 21 YES
LASTTXTMSG 22 YES
CUSTOM1 23 YES
CUSTOM2 24 YES
CUSTOM3 25 YES
CUSTOM4 26 YES
CUSTOM5 27 YES
CUSTOM6 28 YES
CUSTOM7 29 YES
CUSTOM8 30 YES
CUSTOM9 31 YES
PRINT 32 -

LOANS:

field name

position

change name

ID 1 -
ITEM_ID 2 -
ITEM_IDNO 3 -
BOR_IDNO 4 -
I_BARCODE 5 -
B_BARCODE 6 -
LOANDATE 7 YES
LOANTIME 8 YES
DUEDATE 9 YES
DUETIME 10 YES
RETURNDATE 11 YES
RETURNTIME 12 YES
NOTES 13 YES
EXTRA1 14 YES
EXTRA2 15 YES

RESERVATIONS:

field name

position

change name

ID 1 -
IDNO 2 -
BOR_IDNO 3 -
RESERVEDON 4 YES
AVAILABLEFROM 5 YES
RESERVEDUNTIL 6 YES
DAYS 7 YES
NOTES 8 YES

FINES:

field name

position

change name

ID 1 -
BOR_IDNO 2 -
FINEDATE 3 YES
AMOUNT 4 YES
WHAT 5 YES
NOTE 6 YES
CUSTOM 7 YES

Handy Library Manager

software
tour
features
try now
cloud

Copyright © 2017 · All Rights Reserved · PrimaSoft PC