rhy Table: Lease Year to Date History
Sybase DBMS

Specifies the columns and rows with Sybase data type information for the rhy Lease Year to Date History table.

rhy Columns

DescriptionColumn NameData Type ?Characteristics ?
Leaselse_scharlength 10
Yearyear_scharlength 4
Record modification stamptimestamptimestamp
Net receipts Y-T-Drec_ytd_ddoublescale 2
Rental income Y-T-Drent_ytd_ddoublescale 2
Other income Y-T-Doth_ytd_ddoublescale 2
Lessor income Y-T-Dl_in_ytd_ddoublescale 2
Vendor income Y-T-Dd_in_ytd_ddoublescale 2
Investor income Y-T-Di_in_ytd_ddoublescale 2
Payment amount accrued Y-T-Dpmt_acc_ddoublescale 2
Residual income Y-T-Dr_in_ytd_ddoublescale 2
Y-T-D lessor unearned income changesl_ue_chg_ytd_ddoublescale 2
Principal paid Y-T-Dprn_ytd_ddoublescale 2
Interest Y-T-Dint_ytd_ddoublescale 2
IDC Y-T-D amortization - taxidc_ytd_tax_ddoublescale 2
IDC Y-T-D amount - bookidc_ytd_ddoublescale 2
Lessor income reduction Y-T-Dl_in_red_ytd_ddoublescale 2
Residual income reduction Y-T-Dr_in_red_ytd_ddoublescale 2
Insurance premium year-to-date IDC1idc1_ins_prem_ytd_ddoublescale 2
Notary fee year-to-date IDC2idc2_notary_fee_ytd_ddoublescale 2
Insurance fee year-to-date IDR1idr1_ins_fee_ytd_ddoublescale 2
Registration fee year-to-date IDR2idr2_reg_fee_ytd_ddoublescale 2
Dealer subsidy year-to-date IDR3idr3_dlr_subsidy_ytd_ddoublescale 2
Open commission year-to-date IDR4idr4_open_comm_ytd_ddoublescale 2
Escrow received year-to-datercr_esc_ytd_ddoublescale 2
Year to date IDC3idc3_ytd_ddoublescale 2
Year to date IDC4idc4_ytd_ddoublescale 2
Year to date IDC5idc5_ytd_ddoublescale 2
Year to date IDR5idr5_ytd_ddoublescale 2
Year to date IDR6idr6_ytd_ddoublescale 2
Year to date IDR7idr7_ytd_ddoublescale 2
Year to date IDR8idr8_ytd_ddoublescale 2
Year to date IDR9idr9_ytd_ddoublescale 2
Year to date IDRAidra_ytd_ddoublescale 2
Year to date IDRBidrb_ytd_ddoublescale 2
Year to date IDRCidrc_ytd_ddoublescale 2
Alternate year to date IDC3alt_idc3_ytd_ddoublescale 2
Alternate year to date IDC4alt_idc4_ytd_ddoublescale 2
Alternate year to date IDC5alt_idc5_ytd_ddoublescale 2
Alternate year to date IDR5alt_idr5_ytd_ddoublescale 2
Alternate year to date IDR6alt_idr6_ytd_ddoublescale 2
Alternate year to date IDRBalt_idrb_ytd_ddoublescale 2
GL lessor income Y-T-Dgl_in_ytd_ddoublescale 2

rhy Indexes

Index NamePiece 1Piece 2
rhy_idx0lse_syear_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:
  • precision - The magnitude and fractional granularity together, meaning the maximum number of places available to both the left and right of the decimal point. Use precision minus scale to determine the maximum number of places available to the left of the decimal point.
  • 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.