rlr Table: Vendor
Oracle DBMS

Specifies the columns and rows with Oracle data type information for the rlr Vendor table.



rlr Columns

DescriptionColumn NameData Type ?Characteristics ?
Vendordlr_scharlength 9
Record modification stampstamp_lnumberprecision 10
Default applicationdef_app_scharlength 10
Vendor agreement dated_agr_sdateformat YYYYMMDD
Financial statement dated_fin_sdateformat YYYYMMDD
Vendor participation codepart_scharlength 4
Salesperson numbersales_scharlength 4
Activity statusstat_scharlength 4
Vendor typevend_type_scharlength 4
Rate plan groupplan_scharlength 4
Remittance type coderemit_type_scharlength 4
Recourse typerec_scharlength 4
Default portfoliodef_por_scharlength 2
Default companydef_com_scharlength 2
Default regiondef_reg_scharlength 2
Default officedef_off_scharlength 3
Long namenam_long_svarchar2length 125
Addressadd_svarchar2length 36
Address 2add2_svarchar2length 36
Citycty_svarchar2length 25
Statest_scharlength 2
Zip codezip_scharlength 9
Phone numberphn_scharlength 10
Remittance namermt_nam_svarchar2length 36
Remittance addressrmt_add_svarchar2length 36
Remittance address 2rmt_add2_svarchar2length 36
Remittance cityrmt_cty_svarchar2length 25
Remittance statermt_st_scharlength 2
Remittance zip codermt_zip_scharlength 9
Contact name 1cont_nam1_svarchar2length 36
Contact title 1cont_title1_svarchar2length 25
Contact name 2cont_nam2_svarchar2length 36
Contact title 2cont_title2_svarchar2length 25
Owner or manager nameown_svarchar2length 36
Authorization signature nameauth_sign_svarchar2length 36
Bad debt percentagebad_debt_dnumberprecision 15, scale 5
Default GL only (Y/N)gl_only_ccharlength 1
Letter version codelt_version_scharlength 4
PAP institution/ACH transit IDinst_id_scharlength 9
PAP account numberpayer_acct_scharlength 17
Prenotification sent (Y/N)prenote_sent_ccharlength 1
Date prenotification sent ond_prenote_sent_on_sdateformat YYYYMMDD
ACH types (PPD/CCD)ach_type_scharlength 4
Dealer tax identification numberdlr_tax_id_svarchar2length 36
Holdback amount allowholdback_dnumberprecision 15, scale 2
Actual holdback amountholdback_bal_dnumberprecision 15, scale 2
Alert switches (Y/N)alrt_scharlength 6
Alert amount [1]alrt_amt1_dnumberprecision 15, scale 2
Alert amount [2]alrt_amt2_dnumberprecision 15, scale 2
Alert amount [3]alrt_amt3_dnumberprecision 15, scale 2
Alert amount [4]alrt_amt4_dnumberprecision 15, scale 2
Alert amount [5]alrt_amt5_dnumberprecision 15, scale 2
Alert amount [6]alrt_amt6_dnumberprecision 15, scale 2
Alert suspense override dated_alrt_susp_ovr_sdateformat YYYYMMDD
Alert notealrt_note_svarchar2length 255
Insurance percentagep_ins_dnumberprecision 15, scale 5
Insurance bank codeins_bank_scharlength 3
Email addressemail_svarchar2length 50
Maturing lease teamml_team_scharlength 4
New application ownernew_own_scharlength 3



rlr Indexes

Index NamePiece 1
rlr_idx0dlr_s



Data Type Definitions and Characteristics

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

char
Oracle fixed length character string. Typically used to store short-length string data such as keys, four-character codes, and single-character switch values.
Characteristics:
  • length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.

date
Oracle date and time, containing century, year, month, day, hour, minute, and 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.

number
Oracle numeric data type. Used for all numbers.
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 maximum number of places available to the right of the decimal point.

varchar2
Oracle variable length character string. Typically used to store medium and long-length string data such as names, addresses, descriptions, and notebook entries.
Characteristics:
  • length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.