rtd Table: Table-Driven Depreciation
Sybase DBMS

Specifies the columns and rows with Sybase data type information for the rtd Table-Driven Depreciation table.

rtd Columns

Description	Column Name	Data Type ?	Characteristics ?
Depreciation method	depr_method_s	char	length 4
Record modification stamp	timestamp	timestamp
Depreciation rate for year [1]	p_depr1_d	double	scale 5
Depreciation rate for year [2]	p_depr2_d	double	scale 5
Depreciation rate for year [3]	p_depr3_d	double	scale 5
Depreciation rate for year [4]	p_depr4_d	double	scale 5
Depreciation rate for year [5]	p_depr5_d	double	scale 5
Depreciation rate for year [6]	p_depr6_d	double	scale 5
Depreciation rate for year [7]	p_depr7_d	double	scale 5
Depreciation rate for year [8]	p_depr8_d	double	scale 5
Depreciation rate for year [9]	p_depr9_d	double	scale 5
Depreciation rate for year [10]	p_depr10_d	double	scale 5
Depreciation rate for year [11]	p_depr11_d	double	scale 5
Depreciation rate for year [12]	p_depr12_d	double	scale 5
Depreciation rate for year [13]	p_depr13_d	double	scale 5
Depreciation rate for year [14]	p_depr14_d	double	scale 5
Depreciation rate for year [15]	p_depr15_d	double	scale 5
Depreciation rate for year [16]	p_depr16_d	double	scale 5
Depreciation rate for year [17]	p_depr17_d	double	scale 5
Depreciation rate for year [18]	p_depr18_d	double	scale 5
Depreciation rate for year [19]	p_depr19_d	double	scale 5
Depreciation rate for year [20]	p_depr20_d	double	scale 5
Depreciation rate for year [21]	p_depr21_d	double	scale 5
Depreciation rate for year [22]	p_depr22_d	double	scale 5
Depreciation rate for year [23]	p_depr23_d	double	scale 5
Depreciation rate for year [24]	p_depr24_d	double	scale 5
Depreciation rate for year [25]	p_depr25_d	double	scale 5
Depreciation rate for year [26]	p_depr26_d	double	scale 5
Depreciation rate for year [27]	p_depr27_d	double	scale 5
Depreciation rate for year [28]	p_depr28_d	double	scale 5
Depreciation rate for year [29]	p_depr29_d	double	scale 5
Depreciation rate for year [30]	p_depr30_d	double	scale 5
Depreciation rate for year [31]	p_depr31_d	double	scale 5
Depreciation rate for year [32]	p_depr32_d	double	scale 5
Depreciation rate for year [33]	p_depr33_d	double	scale 5
Depreciation rate for year [34]	p_depr34_d	double	scale 5
Depreciation rate for year [35]	p_depr35_d	double	scale 5
Depreciation rate for year [36]	p_depr36_d	double	scale 5
Depreciation rate for year [37]	p_depr37_d	double	scale 5
Depreciation rate for year [38]	p_depr38_d	double	scale 5
Depreciation rate for year [39]	p_depr39_d	double	scale 5
Depreciation rate for year [40]	p_depr40_d	double	scale 5
Depreciation rate for year [41]	p_depr41_d	double	scale 5
Depreciation rate for year [42]	p_depr42_d	double	scale 5
Depreciation rate for year [43]	p_depr43_d	double	scale 5
Depreciation rate for year [44]	p_depr44_d	double	scale 5
Depreciation rate for year [45]	p_depr45_d	double	scale 5
Depreciation rate for year [46]	p_depr46_d	double	scale 5
Depreciation rate for year [47]	p_depr47_d	double	scale 5
Depreciation rate for year [48]	p_depr48_d	double	scale 5
Depreciation rate for year [49]	p_depr49_d	double	scale 5
Depreciation rate for year [50]	p_depr50_d	double	scale 5
Depreciation rate for year [51]	p_depr51_d	double	scale 5
Depreciation rate for year [52]	p_depr52_d	double	scale 5
Depreciation rate for year [53]	p_depr53_d	double	scale 5
Depreciation rate for year [54]	p_depr54_d	double	scale 5
Depreciation rate for year [55]	p_depr55_d	double	scale 5
Depreciation rate for year [56]	p_depr56_d	double	scale 5
Depreciation rate for year [57]	p_depr57_d	double	scale 5
Depreciation rate for year [58]	p_depr58_d	double	scale 5
Depreciation rate for year [59]	p_depr59_d	double	scale 5
Depreciation rate for year [60]	p_depr60_d	double	scale 5
Depreciation rate for year [61]	p_depr61_d	double	scale 5
Depreciation rate for year [62]	p_depr62_d	double	scale 5
Depreciation rate for year [63]	p_depr63_d	double	scale 5
Depreciation rate for year [64]	p_depr64_d	double	scale 5
Depreciation rate for year [65]	p_depr65_d	double	scale 5
Depreciation rate for year [66]	p_depr66_d	double	scale 5
Depreciation rate for year [67]	p_depr67_d	double	scale 5
Depreciation rate for year [68]	p_depr68_d	double	scale 5
Depreciation rate for year [69]	p_depr69_d	double	scale 5
Depreciation rate for year [70]	p_depr70_d	double	scale 5
Depreciation rate for year [71]	p_depr71_d	double	scale 5
Depreciation rate for year [72]	p_depr72_d	double	scale 5
Depreciation rate for year [73]	p_depr73_d	double	scale 5
Depreciation rate for year [74]	p_depr74_d	double	scale 5
Depreciation rate for year [75]	p_depr75_d	double	scale 5
Depreciation rate for year [76]	p_depr76_d	double	scale 5
Depreciation rate for year [77]	p_depr77_d	double	scale 5
Depreciation rate for year [78]	p_depr78_d	double	scale 5
Depreciation rate for year [79]	p_depr79_d	double	scale 5
Depreciation rate for year [80]	p_depr80_d	double	scale 5
Depreciation rate for year [81]	p_depr81_d	double	scale 5
Depreciation rate for year [82]	p_depr82_d	double	scale 5
Depreciation rate for year [83]	p_depr83_d	double	scale 5
Depreciation rate for year [84]	p_depr84_d	double	scale 5
Depreciation rate for year [85]	p_depr85_d	double	scale 5
Depreciation rate for year [86]	p_depr86_d	double	scale 5
Depreciation rate for year [87]	p_depr87_d	double	scale 5
Depreciation rate for year [88]	p_depr88_d	double	scale 5
Depreciation rate for year [89]	p_depr89_d	double	scale 5
Depreciation rate for year [90]	p_depr90_d	double	scale 5
Depreciation rate for year [91]	p_depr91_d	double	scale 5
Depreciation rate for year [92]	p_depr92_d	double	scale 5
Depreciation rate for year [93]	p_depr93_d	double	scale 5
Depreciation rate for year [94]	p_depr94_d	double	scale 5
Depreciation rate for year [95]	p_depr95_d	double	scale 5
Depreciation rate for year [96]	p_depr96_d	double	scale 5
Depreciation rate for year [97]	p_depr97_d	double	scale 5
Depreciation rate for year [98]	p_depr98_d	double	scale 5
Depreciation rate for year [99]	p_depr99_d	double	scale 5
Depreciation rate for year [100]	p_depr100_d	double	scale 5

rtd Indexes

Index Name	Piece 1
rtd_idx0	depr_method_s

Data Type Definitions and Characteristics

Following are descriptions of the Sybase data types used in the LeasePak database. Note that LeasePak does not use all the Sybase data types.

char

Sybase fixed length character string. Typically used to store short and medium-length string data such as keys, names, addresses, descriptions, four-character codes, and single-character switch values.
Characteristics:

• length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.

datetime

Sybase date and time, containing century, year, month, day, hour, minute, second, and second fraction (to 1/300 second) information.
Characteristics:

• format - The date format for the LeasePak database. For example, format YYYYMMDD is the 4-digit year number followed by the 2-digit month number followed by the 2-digit day number with no intervening punctuation.

double

Sybase numeric data type. Typically used to store percentage, rate, and dollar amount information.
Characteristics:

• scale - The fractional granularity, meaning the number of places available to the right of the decimal point.

integer

Sybase numeric data type. Typically used to store counter and whole number information--term length, payment due day, number of units on lease, number of times delinquent, etc.

timestamp

Sybase data type based on the varbinary data type storing raw binary data. Whenever a table includes a timestamp column, Sybase updates the information in timestamp each time a user inserts or updates a record, preventing multiple-user cross-update data corruption.

text

Sybase expandable character data type. Typically used to store long-length string data such as notebook entries.

LeasePak 6.0a Documentation Suite

© 2008 by McCue Systems Incorporated. All rights reserved.

The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of McCue Systems, Inc. is prohibited.