Field Name

Type

Description

Acquired From

Text 50 (lookup)

Use this field to specify where you bought the book, who you got it from, etc.

Appraiser

Text 50 (lookup)

The name of the appraiser (this could be a person, a catalog, etc.).

Author

Text 50 (lookup)

The name of the author(s). In the first column, type the name of the person. In the second column, specify the role you want to link the person to (Co-Author, Editor, etc.).

Author Relation

Text (lookup)

This field includes all related authors.

Awards

Text 100

Here you can specify awards. You can also specify the year the award was given and any additional details.

Bar Code No

Text 50

The bar code number.

Binding

Text 50 (lookup)

Use this field to specify binding (Hardcover, Paperback, etc.).

Book ID

Numeric

This is an unique ID number that is assigned to each entry in the table.

Borrower

Text (lookup)

If the book is currently loaned out, this field contains the name of the borrower.

Category

Text 50 (lookup)

The category describes the type of book.

Note: By default this field is not visible in the data entry window (you can add it with the Form Designer). You might want to use the Genre field instead.

Change in Value

Numeric

The difference between price and value.

Change in Value %

Numeric

The difference between price and value in percent.

Condition

Text 50 (lookup)

Use this field to specify the condition of the book.

Copyright Date

Date

The book's copyright date. If you don't know the day and month, just specify the year.

Country

Text 50 (lookup)

The country of origin.

Cover Price

Numeric

The cover price. You can specify both the actual price, and the currency.

Cover

Binary

This field contains the image if it is stored in the database.

Cover - Notes

Memo

Comments about the image.

Cover - Compressed

Boolean

Specifies whether the image is compressed or not (only applies to BMP images).

Cover - External

Boolean

Specifies whether the image is stored externally (that is, only a link to the image is stored in the database) or not.

Cover - File Name

Text 255

If this is an external image, this field contains the file name.

Cover - Thumbnail

Binary

This field contains a thumbnail of the image. The thumbnail is automatically created when you add a new image.

Cover - Type

Numeric

The type of image: 0 - bmp, 1 - gif, 2 - jpeg, 3 - png, or 99 - other.

Credits

Text 50 (lookup)

Additional credits. In the first column, type the name of the person. In the second column, specify the role you want to link the person to (Cover Design, Illustrator, etc.).

Current Value

Numeric

The book's current value.

Custom 01

Text 50

This is a standard text field.

To rename the field to suit your needs, choose Database Setup from the Tools menu, click the Fields tab, locate the field in the list and type the new field name in the Name column.

Custom 02

Text 50

This is a standard text field.

Custom 03

Text 50

This is a standard text field.

Custom 04

Text 50

This is a standard text field.

Custom 05

Text 50 (lookup)

This is a text field linked to lookup table.

Custom 06

Text 50 (lookup)

This is a text field linked to lookup table.

Custom 07

Text 50 (lookup)

This is a text field linked to lookup table.

Custom 08

Text 50 (lookup)

This is a text field linked to lookup table.

Custom 09

Date

This is a date field.

Custom 10

Numeric

This is a numeric field.

Custom 11

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 12

Boolean

This is a boolean field (checkbox).

Custom 13

Boolean

This is a boolean field (checkbox).

Custom 14

Boolean

This is a boolean field (checkbox).

Custom 15

Boolean

This is a boolean field (checkbox).

Custom 16

Boolean

This is a boolean field (checkbox).

Custom 17

Boolean

This is a boolean field (checkbox).

Custom 18

Boolean

This is a boolean field (checkbox).

Date Acquired

Date

The date you acquired the book. If you don't remember the day and month, just specify the year.

Date Borrowed

Date

If the book is currently loaned out, this field contains the date it was borrowed.

Date Due

Date

If the book is currently loaned out, this field contains the date it is due to be returned.

Dewey

Text 25

The dewey decimal number.

Dimensions - Depth

Numeric

The depth of the book

Dimensions - Height

Numeric

The height of the book.

Dimensions - Width

Numeric

The width of the book.

Dustjacket Condition

Text 50 (lookup)

Use this field to specify the dustjacket condition.

Edition

Text 50 (lookup)

The book's edition.

File Links

Text

Here you can add links to files.

Full Title 1

Text

This field combines Title, Series and Release No into one field: Series (Release No): Title.

Full Title 2

Text

This field combines Title, Series and Release No into one field: Title (Series Release No).

Genre

Text 50 (lookup)

The book's genre(s). You can assign the book to as many genres as you like (for example History, Humor, Music or Science Fiction).

Insurance

Text 50 (lookup)

Use this field to link the book to an insurance policy.

ISBN

Text 25

The ISBN number (International Standard Book Number).

Keywords

Text 150 (lookup)

This field is for listing keywords that describe the book.

Language

Text 50 (lookup)

The language.

Last Modified

Date

The date the record was last modified (automatically updated by the program).

Last Read

Date

The date you last read the book.

LCCN

Text 25

The LCCN number (Library of Congress Catalog Number).

Location

Text 50 (lookup)

Use this field to specify where the book is located.

Main Author

Text (lookup)

This field includes authors assigned to the Main Author role.

Marked

Boolean

This field indicates whether the book is marked or not.

New Book

Boolean

This field indicates whether the book is new, and is based on the Date Acquired field. By default, if it's less than 60 days since you acquired the book, this field returns Yes. If not, it returns No.

You can change the number of days used in this calculation by choosing Options from the Tools menu, and specifying the new value in the New Book period text box. Default value is 60 days.

Nominations

Text 100 (lookup)

Here you can specify award nominations. You can also specify the year the nomination was given and any additional details.

Notes

Memo

This field is for your own notes, and can hold up to 250Kb of text.

Number of Sections

Numeric

This field contains the number of sections in the book, and is automatically maintained by BookCAT.

On Loan

Boolean

This field indicates whether the book is currently on loan.

Original Copyright

Date

If the book is translated, use this field to specify the original copyright date. If you don't know the day and month, just specify the year.

Original Country

Text 50 (lookup)

If the book is translated, use this field to specify the original country of origin.

Original Language

Text 50 (lookup)

If the book is translated, use this field to specify the original language.

Original Publisher

Date

If the book is translated, use this field to specify the original publisher.

Original Release No

Numeric

If the book was translated, use this field to specify the release number in the series.

Original Series

Text 50 (lookup)

If the book is translated, use this field to specify the name of the original series.

Original Subtitle

Text 255

If the book is translated, use this field to specify the original subtitle.

Original Title

Text 150

If the book is translated, use this field to specify the original title.

Overdue

Boolean

If the book is loaned out, this field indicates whether it is overdue or not.

Owner

Text 50 (lookup)

Use this field to specify the owner of the book.

Pages

Numeric

The total number of pages.

Personal Rating

Text with image (lookup)

Use this field to specify your own personal rating. The default setup will let you select a star rating between 0 and 5 stars.

In the data entry window, you can press the + or - button to select rating without having to open the list.

Printed by

Text 50 (lookup)

The name of the company that has printed the book.

Printing

Text 50 (lookup)

The printing (1st printing, 2rd printing, etc.).

Publication Place

Text 50 (lookup)

The publication place (name of the city, and state or province, and country, if needed to identify the city) where the book was published or released.

Publish Date

Date

The publish date. If you don't know the day and month, just specify the year.

Publisher

Text 50 (lookup)

Type the name of the publisher or select it from the list.

Purchase Price

Numeric

Use this field to specify what you paid for the book.

Reference No

Text 25

Use this field if you have your own system for identifying books in your collection.

BookCAT will automatically generate the reference number. To configure this feature, choose Options from the Tools menu, click the Reference No tab and make your selections.

Registered

Date

This field contains the date the book was added to the database. Today's date is used automatically, but you can change it if you want.

Release No

Numeric

If the book is part of a series, use this field to specify the release number.

Reviews

Memo

This field is for reviews, and can hold up to 250Kb of text.

Selling Price

Numeric

Use this field to specify the selling price.

Series

Text 50 (lookup)

If the book is part of a series, specify the name of the series in this field.

Status

Text 50 (lookup)

Use this field to specify the status of the book, for example Own (you own the book), Want (you have it on your want list), For sale (the book is for sale) or Reference (you don't own it, but just want to include it in the database).

Sub-Category

Text 50 (lookup)

In addition to the Category field, you can use the Sub-category to describe the type of book.

Note: By default this field is not visible in the data entry window (you can add it with the Form Designer). You might want to use the Genre field instead.

Subtitle

Text 255

The book's subtitle.

Synopsis

Memo

This field is for the synopsis, and can hold up to 250Kb of text.

Title

Text 150

The title of the book.

When you tab out of the Title field (or save the book), BookCAT will automatically fill in the Title Sort field if it is empty.

Title Sort

Text 152

This is the value that is used when sorting on the book title.

When you tab out of the Title field (or save the book), BookCAT will automatically fill in the Title Sort field if it is empty. If the name begins with “A” or “The”, BookCAT will automatically update the Title Sort field to reflect this. For example, if you type “The Hobbit” in the Title field, BookCAT will add “Hobbit, The” to the Title Sort field. This means that the book is sorted under "H" and not "T".

Translator

Text 50 (lookup)

If the book is translated, specify the name of the translator(s) here.

Type

Text 50 (lookup)

Use this field to specify the type of book, for example Fiction or Non-fiction.

Web Links

Text

Here you can add links to web sites.