Stamp table: Standard fields

Previous pageReturn to chapter overviewNext page

The Stamp table contains information about all stamps in the database. Information from lookup tables (for example Country or Catalog) is not stored in the Stamp table, StampCAT only saves a link to the relevant item in the lookup table. This means that any changes you make to a lookup item, for example fixing a typing error, is reflected in all stamps where the item is used.

Calculated Price (Numeric)

This is a calculated field that contains the result of Price * Quantity.

Calculated Value (Numeric)

This is a calculated field that contains the result of Value * Quantity. If you have specified a catalog, the exchange rate is used to calculate the value in your own currency.

Catalog (Text 50 - lookup)

The name of the catalog.

Catalog No (Text 50

Specify the stamp's catalog number. The text box is divided into three parts:

1. The prefix, or the "back of book qualifier", for example D for postage due stamps.
2. The "main" catalog number.
3. The suffix, or the "letter qualifier" used to separate variants of the same stamp, for example 34b or 76c.

To ensure that the stamps are sorted in the right order, it is important that you specify the catalog number correctly. Here are some examples:

D38   -> |  D|    38|   |
D41b  -> |  D|    41|  b|
76a   -> |   |    76|  a|
88    -> |   |    88|   |
109f  -> |   |   109|  f|

From the Options window (Tools=>Options=>Miscellaneous) you can control how the stamps are sorted when sorting on the Catalog No field. You can select whether to sort "part 1" or "part 2" of the catalog number first. For example, if you select "Part 1 / Part 2 / Part 3", catalog number "1462" is sorted before catalog number "V1461". If you select "Part 2 / Part 1 / Part 3", catalog number "V1461" is sorted before catalog number "1462".

Category (Text 50 - lookup)

Use this field if you want to catalog the stamp under an additional category.

Change in Value (Numeric

The difference between Calculated Price and Calculated Value.

Change in Value % (Numeric)

The difference between Calculated Price and Calculated Value in percent.

Class (Text 50 - lookup)

The stamp class, for example "Air mail", "Commemorative", "Postage Due", "Regular", "Special Delivery".

Code (Text 20)

Use this field to store a short description that identifies the stamp. How you use this field is entirely up to you. For example, if the stamp is located in album number 2 on page 23, you could specify A2/23.

Color (Text 50 - lookup)

The color of the stamp.

Condition (Text 50 - lookup)

The condition of the stamp, for example "Superb", "Very Fine" or "Average".

Country (Text 50 - lookup)

The name of the country that issued the stamp.

Date Acquired (Date)

The date you acquired the stamp. If you don't remember the day and month, just specify the year. Click on the calendar icon to display a pop-up calendar where you can select the date.

Design (Text 150)

This may be a simple description of what is on the stamp, words that appear on the stamp or anything that will distinguish the stamp from other stamps.

Duplicate (Checkbox)

Check this field if the stamp is a duplicate.

Face Value (Text 25)

The value that is printed on the stamp.

File Links (Text)

Here you can add links to external files.

Group (Text 50 - lookup)

Stamps can be collected in different groupings, for example "Block", "Booklet pane", "Envelope", "Sheet", or "Single".

Height (Numeric)

The height of the stamp.

Hinged (Text 50 - lookup)

Indicate whether the stamp is hinged or not: "Never Hinged", "Very Lightly Hinged", "Hinged Lightly", "Hinged", "Heavily Hinged", etc.

Image 1-9 (Binary)

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

Image 1-9 - Compressed (Yes/No)

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

Image 1-9 - External (Yes/No)

Specifies whether the image is stored externally (only the file path to the image file is stored in the database), or not.

Image 1-9 - File Name (Text 255)

If you have linked to an external image, this field contains the file name.

Image 1-9 - Notes (Memo)

This memo field is for your own notes about the image.

Image 1-9 - Type (Numeric)

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

Issued (Date)

The date the stamp was issued. If you don’t know the day and month, just specify the year.

Keywords (Text 150 - lookup)

This field is for listing keywords that describe the stamp.

Location (Text 50 - lookup)

Use this field to specify where the stamp is located.

Marked (Yes/No)

This field indicates whether the stamp is marked or not.

New Stamp (Yes/No)

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

Note: You can change the number of days used in this calculation by choosing Tools=>Options=>Data Entry, and specifying the new value in the 'New stamp period' text box. Default value is 60 days.

Notes (Memo)

This field is for your own notes.

Perforation Full (Text 100)

This field combines Perforation Horiz and Perforation Vert into one field. For example: "11 x 11½", "12 x 13" or "10" (if both horizontal and vertical perforation are equal).

Perforation Horiz (Text 50 - lookup)

The horizontal perforation.

Perforation Vert (Text 50 - lookup)

The vertical perforation.

Postmark (Text 50 - lookup)

Specify the type of postmark.

Postmark City (Text 50 - lookup)

Specify the city/town of the postmark.

Postmark Date (Date)

The date of the postmark.

Price (Numeric)

The purchase price. If the stamp is for sale, you can use this field to store the selling price.

Quantity (Numeric)

The quantity. If some of the information differ between several copies of the same stamp (for example condition or postmark) you should register them separately.

Registered (Date)

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

Stamp ID (Numeric)

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

Stamp Links (Text)

Here you can link to other stamps.

Status (Text 50 - lookup)

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

Topic (Text 100 - lookup)

If you collect stamps by topic, specify the topic here (for example "Animals", "Flowers", "Ships" or "Space").


Text 50 (lookup)

The type of stamp, for example "Mint", "Unused" or "Used".

Value (Numeric)

The current market value of the stamp according to the catalog you are using.

We recommend that you specify the value from the catalog you are using (for example if you live in Canada and are using the Stanley Gibbons catalog, you should specify the value in British pounds). StampCAT then uses the exchange rate for the currency used in the catalog when updating the Calculated Value (Canadian dollars in this example). When the exchange rate changes, you just modify the exchange rate for the catalog. The calculated value is then updated for all stamps in the database linked to this catalog. Always specify Price in your own currency.

Watermark (Checkbox)

Check this field if the stamp has a watermark.

Web Links (Text)

Here you can add links to web sites.

Width (Numeric)

The width of the stamp.

Do you have question? E-mail us at