Database Reference

Datatypes

CHAR(length)

Oracle DBMS fixed-length character string. Typically used for string columns which are less than 20 characters in length. Always used for string columns that are indexed, regardless of length. length denotes the maximum number of characters the string can contain.

char(length)

Sybase DBMS fixed length character string. Used for all LeasePak string columns, except the info_s columns in the Notebook tables. length denotes the maximum number of characters the string can contain.

DATE

Oracle DBMS date and time. Contains century, year, month, day, hour, minute, and second information. LeasePak uses only the date portion (century, year, month, day). It does not use the time portion (hour, minute, second). If the datatype of a column is DATE, the column name begins with 'd_'.

datetime

Sybase DBMS date and time. Contains century, year, month, day, hour, minute, second, and second fraction (accurate to 1/300 second) information. If a column has a datetime datatype and the column name begins with 'd_', LeasePak uses only the date portion (century, year, month, day); it does not use time portion (hour, minute, second, second fraction). If a column has a datetime datatype and the column name begins with 'dt_', LeasePak uses both the date and time portions.

double precision

Sybase DBMS floating-point number. Used to store percentages, rates, and dollar amounts.

integer

Sybase DBMS integer number. Used to store whole numbers.

NUMBER(15,scale)

Oracle DBMS floating-point number. Used to store percentages, rates, and dollar amounts. scale denotes the maximum number of digits to the right of the decimal point. The maximum number of digits to the left of the decimal point is 15 minus the scale.

NUMBER(10)

Oracle DBMS integer number, maximum 10 digits. The standard datatype used for most integers.

NUMBER(precision,0)

Oracle DBMS integer number with a maximum of precision digits. Used only for integers which may exceed 10 digits and the "next number" columns in the msv* tables.

text

Sybase DBMS long-length character string. Used only for the info_s columns in the Notebook tables.

TIMESTAMP(3)

Oracle DBMS date and time. Contains century, year, month, day, hour, minute, second, and second fraction (accurate to 1/1000 second) information. LeasePak uses both the date and time portions. If the datatype of a column is TIMESTAMP(3), the column name begins with 'dt_'.

timestamp

Sybase DBMS binary timestamp. Whenever a table includes a timestamp column, Sybase automatically updates the binary time information in the timestamp column each time a user inserts or updates a record. LeasePak uses the timestamp information to prevent corruption when multiple users attempt to update the same record simultaneously.

VARCHAR2(length)

Oracle DBMS variable-length character string. Used for non-indexed strings over 19 characters in length. length denotes the maximum number of characters the string can contain.