Table
|
Enter the name of the SQL table for the column.
|
Column
|
Enter the name of the SQL column whose data type you are defining.
Note: If you are creating this column using the data type “Sort-Wt”, enter “original” as the column name.
|
Data Type
|
Choose one of these options:
|
•
|
Reconst. (Reconstituted) Mark this option if data in this column is modified for sorting purposes and must be processed by Horizon when displayed. |
|
•
|
Code. Mark this option if data in this column is a code that Horizon uses to identify valid entries and descriptions. |
|
•
|
Mq Value. Mark this option if data in this column is a list of values (integers) and descriptions that are displayed as radio buttons. |
|
•
|
Date. Mark this option if data in this column represents a date. Dates are Julian date or number of days since 1 January 1970. You control the date format through each PC’s OS setup/country National Language Setting (NLS) icon. |
|
•
|
Time. Mark this option if data in this column represents time. Times are represented as minutes since midnight. You control the 12/24 hour style and format through each PC’s OS setup/country National Language Setting (NLS) icon. |
|
•
|
Currency. Mark this option if data in this column is stored without a decimal (for example, $12.81 is stored as 1281). |
|
•
|
Money. Mark this option if data in this column is stored in dollars and cents with a decimal. |
|
•
|
Boolean. Mark this option if data in this column uses a binary yes/no value. When Boolean column types are editable, they appear as check boxes; when display-only, they appear as “Yes,” or “No.” |
|
•
|
Key String. Mark this option if data in this column is an alphanumeric string, such as barcodes. |
|
•
|
Month/Day. Mark this option if data in this column uses the date in form of mm/dd (four integers, no year). This is most commonly used in Serials for prediction patterns. You control the date format through each PC’s OS setup/country National Language Setting (NLS) icon. |
|
•
|
Multilingual. Mark this option if data in this column marks plain text as “multilingual” so that Horizon puts it through a translation routine if you are using Horizon in a non-English environment. |
|
•
|
Call. Mark this option if the call number data in the column is stored differently from the way it should display and must, therefore, be processed before displayed. |
|
•
|
Sort-Wt. Mark this option if data in this column has a numerical value that determines the sort order for linguistic characters used in Unicode. |
|
Reconst/Sw
|
Do one of these options:
|
•
|
If you chose the data type Reconst, enter the name of the column which contains the reconstituted data. (Usually this column is called reconst” or is the name of the column to be reconstituted plus “_reconst”.) |
|
•
|
If you chose the data type Sort-Wt, enter the name of the Sort Weight field in the table. (If you use the default script, enter “sort_weight”.) |
|
ALA Translate
|
Mark this box if the column is a reconstituted form which may contain ALA characters.
If you leave this box empty, ALA characters codes will not display correctly.
|
Code: Table
|
If you chose the data type Code, enter the name of the table that the code refers to.
(For example, if the code is location on the item table, the table to verify the code again is location.)
|
Key
|
If you chose the data type Code, enter the column that contains the code you actually use in the column whose characteristics you are defining.
|
Descr.
|
If you chose the data type Code, enter the description that is displayed to the right of the code box.
|
Currency Col.
|
Enter the name of the column that contains the currency code associated with a money type.
If you leave this box empty, the currency is not displayed on the window when you edit or display the value.
|
Key String Type
|
If you chose the data type “Key String”, enter or choose a code for the key string that you want to use.
|
Mqval Table Key
|
This field specifies the name of an MQ Value type column’s original table name (in cases where the column shares values with another table or column). This prevents duplication of MQ Value entries for the same set of values.
Enter the name of a table.
|
Mqval Col. Key
|
This field specifies the name of an MQ Value type column’s original column name (in cases where the column shares values with another table or column). This prevents duplication of MQ Value entries for the same set of values.
Enter the name of a column.
|