rlsa Table: Lease 2
Sybase DBMS

Specifies the columns and rows with Sybase data type information for the rlsa Lease 2 table.

Parent-Child: This table has a parent table--click here for a listing.

rlsa Columns

DescriptionColumn NameData Type ?Characteristics ?
Leaselse_scharlength 10
Record numberunique_linteger
Record modification stamptimestamptimestamp
Lease address namelse_nam_scharlength 36
Lease addresslse_add_scharlength 36
Lease address 2lse_add2_scharlength 36
Lease address citylse_cty_scharlength 25
Lease address statelse_st_scharlength 2
Lease address zip codelse_zip_scharlength 9
Billing address namebill_nam_scharlength 36
Billing addressbill_add_scharlength 36
Billing address 2bill_add2_scharlength 36
Billing address citybill_cty_scharlength 25
Billing address statebill_st_scharlength 2
Billing address zip codebill_zip_scharlength 9
Last IBL principal change dated_last_prin_adj_scharformat YYYYMMDD
Capitalize IBL interest (Y/N/' ')capitalize_interest_ccharlength 1
Insurance premium payable to IDC1idc1_ins_prem_pay_to_scharlength 9
Notary fee payable to IDC2idc2_notary_fee_pay_to_scharlength 9
Insurance premium IDC1idc1_ins_prem_ddoublescale 2
Insurance premium unearned IDC1idc1_ins_prem_ue_ddoublescale 2
Insurance premium current IDC1idc1_ins_prem_cur_ddoublescale 2
Insurance premium year-to-date IDC1idc1_ins_prem_ytd_ddoublescale 2
Insurance premium suspended IDC1idc1_ins_prem_susp_ddoublescale 2
Insurance premium reduction IDC1idc1_ins_prem_red_ddoublescale 2
Insurance premium accounts payable IDC1idc1_ins_prem_ap_ddoublescale 2
Notary fee IDC2idc2_notary_fee_ddoublescale 2
Notary fee unearned IDC2idc2_notary_fee_ue_ddoublescale 2
Notary fee current IDC2idc2_notary_fee_cur_ddoublescale 2
Notary fee year-to-date IDC2idc2_notary_fee_ytd_ddoublescale 2
Notary fee suspended IDC2idc2_notary_fee_susp_ddoublescale 2
Notary fee reduction IDC2idc2_notary_fee_red_ddoublescale 2
Notary fee accounts payable IDC2idc2_notary_fee_ap_ddoublescale 2
Insurance fee IDR1idr1_ins_fee_ddoublescale 2
Insurance fee unearned IDR1idr1_ins_fee_ue_ddoublescale 2
Insurance fee current IDR1idr1_ins_fee_cur_ddoublescale 2
Insurance fee year-to-date IDR1idr1_ins_fee_ytd_ddoublescale 2
Insurance fee suspended IDR1idr1_ins_fee_susp_ddoublescale 2
Insurance fee reduction IDR1idr1_ins_fee_red_ddoublescale 2
Registration fee IDR2idr2_reg_fee_ddoublescale 2
Registration fee unearned IDR2idr2_reg_fee_ue_ddoublescale 2
Registration fee current IDR2idr2_reg_fee_cur_ddoublescale 2
Registration fee year-to-date IDR2idr2_reg_fee_ytd_ddoublescale 2
Registration fee suspended IDR2idr2_reg_fee_susp_ddoublescale 2
Registration fee reduction IDR2idr2_reg_fee_red_ddoublescale 2
Dealer subsidy IDR3idr3_dlr_subsidy_ddoublescale 2
Dealer subsidy unearned IDR3idr3_dlr_subsidy_ue_ddoublescale 2
Dealer subsidy current IDR3idr3_dlr_subsidy_cur_ddoublescale 2
Dealer subsidy year-to-date IDR3idr3_dlr_subsidy_ytd_ddoublescale 2
Dealer subsidy suspended IDR3idr3_dlr_subsidy_susp_ddoublescale 2
Dealer subsidy reduction IDR3idr3_dlr_subsidy_red_ddoublescale 2
Open commission IDR4idr4_open_comm_ddoublescale 2
Open commission unearned IDR4idr4_open_comm_ue_ddoublescale 2
Open commission current IDR4idr4_open_comm_cur_ddoublescale 2
Open commission year-to-date IDR4idr4_open_comm_ytd_ddoublescale 2
Open commission suspended IDR4idr4_open_comm_susp_ddoublescale 2
Open commission reduction IDR4idr4_open_comm_red_ddoublescale 2
Advanced invoice daysadv_inv_days_linteger
Allow lease extension (Y/N)allow_ext_ccharlength 1
IBL payment method (A/B)ibl_pmt_meth_ab_ccharlength 1
Date of last escrow disbursald_rcr_esc_pd_scharformat YYYYMMDD
Date of last escrow paymentd_rcr_esc_rc_scharformat YYYYMMDD
Date account last reported to Credit Bureaud_acc_rptd_scharformat YYYYMMDD
12-month payment history gridpmt_hist_scharlength 12
PAP institution/ACH transit IDinst_id_scharlength 9
PAP account numberpayer_acct_scharlength 17
Clerk when removed from insurance trackingini_icur_scharlength 3
Escrow received month-to-datercr_esc_mtd_ddoublescale 2
Escrow received year-to-datercr_esc_ytd_ddoublescale 2
Escrow received lease-to-datercr_esc_ltd_ddoublescale 2
Escrow disbursed lease-to-datercr_esc_dsb_ddoublescale 2
Report account to Credit Bureau (Y/N)rpt_acc_ccharlength 1
Securitize (Y/N)securitized_ccharlength 1
Lease weightweight_linteger
IDC accrual method (O/N)idc_accr_meth_ccharlength 1
Last payment date prior to delinquencyd_last_cur_pmt_scharformat YYYYMMDD
Late charges waived L-T-Dltch_waive_ltd_ddoublescale 2
Collection fees waived L-T-Dcoll_waive_ltd_ddoublescale 2
Assumption fees waived L-T-Dasmf_waive_ltd_ddoublescale 2
Property tax waived L-T-Dprtx_waive_ltd_ddoublescale 2
Legal fees waived L-T-Dlegf_waive_ltd_ddoublescale 2
Payment extension fees waived L-T-Dpext_waive_ltd_ddoublescale 2
Lease extension fees waived L-T-Dlext_waive_ltd_ddoublescale 2
ITC fees waived L-T-Ditcf_waive_ltd_ddoublescale 2
Federal highway use tax waived L-T-Dfhut_waive_ltd_ddoublescale 2
Lease re-write fees waived L-T-Dlsrw_waive_ltd_ddoublescale 2
Other fees waived L-T-Dothf_waive_ltd_ddoublescale 2
Sales/Use tax waived L-T-Dstax_waive_ltd_ddoublescale 2
Recurring charge waived L-T-D [1]rcr_waive_ltd1_ddoublescale 2
Recurring charge waived L-T-D [2]rcr_waive_ltd2_ddoublescale 2
Recurring charge waived L-T-D [3]rcr_waive_ltd3_ddoublescale 2
Recurring charge waived L-T-D [4]rcr_waive_ltd4_ddoublescale 2
Recurring charge waived L-T-D [5]rcr_waive_ltd5_ddoublescale 2
Recurring charge waived L-T-D [6]rcr_waive_ltd6_ddoublescale 2
Recurring charge waived L-T-D [7]rcr_waive_ltd7_ddoublescale 2
Recurring charge waived L-T-D [8]rcr_waive_ltd8_ddoublescale 2
Recurring charge waived L-T-D [9]rcr_waive_ltd9_ddoublescale 2
Recurring charge waived L-T-D [10]rcr_waive_ltd10_ddoublescale 2
Recurring charge waived L-T-D [11]rcr_waive_ltd11_ddoublescale 2
Recurring charge waived L-T-D [12]rcr_waive_ltd12_ddoublescale 2
Recurring charge waived L-T-D [13]rcr_waive_ltd13_ddoublescale 2
Recurring charge waived L-T-D [14]rcr_waive_ltd14_ddoublescale 2
Recurring charge waived L-T-D [15]rcr_waive_ltd15_ddoublescale 2
Payment waived L-T-Dpmt_waive_ltd_ddoublescale 2
Principal waived L-T-Dprn_waive_ltd_ddoublescale 2
Interest waived L-T-Dint_waive_ltd_ddoublescale 2
Fixed rate reserves IDC3idc3_ddoublescale 2
Unearned IDC3idc3_ue_ddoublescale 2
Current IDC3idc3_cur_ddoublescale 2
Year to date IDC3idc3_ytd_ddoublescale 2
Reduction IDC3idc3_red_ddoublescale 2
Suspended IDC3idc3_susp_ddoublescale 2
Payable amount IDC3idc3_ap_ddoublescale 2
Standard reserves IDC4idc4_ddoublescale 2
Unearned IDC4idc4_ue_ddoublescale 2
Current IDC4idc4_cur_ddoublescale 2
Year to date IDC4idc4_ytd_ddoublescale 2
Reduction IDC4idc4_red_ddoublescale 2
Suspended IDC4idc4_susp_ddoublescale 2
Payable amount IDC4idc4_ap_ddoublescale 2
Guaranteed reserves IDC5idc5_ddoublescale 2
Unearned IDC5idc5_ue_ddoublescale 2
Current IDC5idc5_cur_ddoublescale 2
Year to date IDC5idc5_ytd_ddoublescale 2
Reduction IDC5idc5_red_ddoublescale 2
Suspended IDC5idc5_susp_ddoublescale 2
Payable amount IDC5idc5_ap_ddoublescale 2
Subvention IDR5idr5_ddoublescale 2
Unearned IDR5idr5_ue_ddoublescale 2
Current IDR5idr5_cur_ddoublescale 2
Year to date IDR5idr5_ytd_ddoublescale 2
Reduction IDR5idr5_red_ddoublescale 2
Suspended IDR5idr5_susp_ddoublescale 2
Dealer buy down ID6idr6_ddoublescale 2
Unearned IDR6idr6_ue_ddoublescale 2
Current IDR6idr6_cur_ddoublescale 2
Year to date IDR6idr6_ytd_ddoublescale 2
Reduction IDR6idr6_red_ddoublescale 2
Suspended IDR6idr6_susp_ddoublescale 2
Credit life insurance 1 IDR7idr7_ddoublescale 2
Unearned IDR7idr7_ue_ddoublescale 2
Current IDR7idr7_cur_ddoublescale 2
Year to date IDR7idr7_ytd_ddoublescale 2
Reduction IDR7idr7_red_ddoublescale 2
Suspended IDR7idr7_susp_ddoublescale 2
Save unearned IDR7idr7_save_ddoublescale 2
Credit life insurance 2 IDR8idr8_ddoublescale 2
Unearned IDR8idr8_ue_ddoublescale 2
Current IDR8idr8_cur_ddoublescale 2
Year to date IDR8idr8_ytd_ddoublescale 2
Reduction IDR8idr8_red_ddoublescale 2
Suspended IDR8idr8_susp_ddoublescale 2
Save unearned IDR8idr8_save_ddoublescale 2
Credit disability insurance 1 IDR9idr9_ddoublescale 2
Unearned IDR9idr9_ue_ddoublescale 2
Current IDR9idr9_cur_ddoublescale 2
Year to date IDR9idr9_ytd_ddoublescale 2
Reduction IDR9idr9_red_ddoublescale 2
Suspended IDR9idr9_susp_ddoublescale 2
Save unearned IDR9idr9_save_ddoublescale 2
Credit disability insurance 2 IDRAidra_ddoublescale 2
Unearned IDRAidra_ue_ddoublescale 2
Current IDRAidra_cur_ddoublescale 2
Year to date IDRAidra_ytd_ddoublescale 2
Reduction IDRAidra_red_ddoublescale 2
Suspended IDRAidra_susp_ddoublescale 2
Save unearned IDRAidra_save_ddoublescale 2
Acquisition fee IDRBidrb_ddoublescale 2
Unearned IDRBidrb_ue_ddoublescale 2
Current IDRBidrb_cur_ddoublescale 2
Year to date IDRBidrb_ytd_ddoublescale 2
Reduction IDRBidrb_red_ddoublescale 2
Suspended IDRBidrb_susp_ddoublescale 2
Warranty insurance IDRCidrc_ddoublescale 2
Unearned IDRCidrc_ue_ddoublescale 2
Current IDRCidrc_cur_ddoublescale 2
Year to date IDRCidrc_ytd_ddoublescale 2
Reduction IDRCidrc_red_ddoublescale 2
Suspended IDRCidrc_susp_ddoublescale 2
Save unearned IDRCidrc_save_ddoublescale 2
Excess MSRPx_msrp_ddoublescale 2
Excess MSRP bank codex_msrp_scharlength 3
Estimated unearnedl_est_ue_ddoublescale 2
Informational down payment amountinf_dwn_pmt_ddoublescale 2
Trade-in maketrade_in_make_scharlength 15
Trade-in modeltrade_in_model_scharlength 15
Trade-in yeartrade_in_year_linteger
Trade-in gross allowancetrade_in_gross_allow_ddoublescale 2
Trade-in outstanding debttrade_in_outst_debt_ddoublescale 2
Trade-in net allowancetrade_in_net_allow_ddoublescale 2
Trade-in cash downtrade_in_cash_dwn_ddoublescale 2
Down payment taxdwn_pmt_tax_ddoublescale 2
Dealer recourserec_scharlength 4
Credit qualitycred_quality_scharlength 4
Optional insuranceopt_ins_scharlength 4
Purchase option feepurch_option_fee_ddoublescale 2
Number of payment reschedulespmt_rsc_linteger
Number of months payment extendedpxt_ext_mnts_linteger
Number of times delinquent [5]del5_linteger
Number of times delinquent [6]del6_linteger
Number of times delinquent [7]del7_linteger
Transfer of equity (Y/N)tran_eqty_ccharlength 1
Cancel credit life insurance 1can_cr_lif1_ccharlength 1
Cancel credit life insurance 2can_cr_lif2_ccharlength 1
Cancel credit disability insurance 1can_cr_dis1_ccharlength 1
Cancel credit disability insurance 2can_cr_dis2_ccharlength 1
Cancel warranty insurancecan_warranty_ccharlength 1
Account type (P/L/I)
P - Prestige Buyer
L - Lease
I - Retail Installment
acct_type_ccharlength 1

rlsa Indexes

Index NamePiece 1Piece 2
rlsa_idx0lse_sunique_l

Parent Table Listing

Table NameDescription
rlsLease

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.