rtr Table: Tax Released
Oracle DBMS

Specifies the columns and rows with Oracle data type information for the rtr Tax Released table.

rtr Columns

DescriptionColumn NameData Type ?Characteristics ?
Payable type
  00 - Use tax
  01 - Property tax
  02 - Federal highway use tax
  03 -- 17 - Recurring charge 1-15
pay_typ_sCHAR(2)
Portfoliopor_sCHAR(2)
Payable recipient
  If payable type is use tax, property tax, or FHUT then
    recip_s = State(2)/County(4)/City(4)
  If payable type is recurring charge then
    recip_s = Broker/vendor number + " "
recip_sCHAR(10)
Asset or lease:
  If payable type is use tax, property tax, or FHUT then
    unit_lse_s = asset number
  If payable type is recurring charge then
    unit_lse_s = lease number
unit_lse_sCHAR(10)
Payment due dated_pmtdu_sDATE
Use tax entity:
  0 - State, all other payables
  1 - County
  2 - City
use_tax_cCHAR(1)
Unique portion for keyunique_sCHAR(5)
Record modification stampstamp_lNUMBER(10)
Companycom_sCHAR(2)
Regionreg_sCHAR(2)
Officeoff_sCHAR(3)
Leaselse_sCHAR(10)
Reportable switch (Y/N/' ')
  Y - reports on U0449A and U0449B
  N - reports on U0449D and U0449E
  ' ' - all other records
rpt_cCHAR(1)
County transit ratep_ct_trnst_rat_dNUMBER(15,5)
City transit ratep_cy_trnst_rat_dNUMBER(15,5)
Gross receipts (non-taxable)nontax_gross_dNUMBER(15,2)
Tax released (amount released)tax_r_dNUMBER(15,2)
Gross receipts (taxable)gross_dNUMBER(15,2)
State ratep_st_rat_dNUMBER(15,5)
County ratep_ct_rat_dNUMBER(15,5)
City ratep_cy_rat_dNUMBER(15,5)
Manual update flag
  '*' - flags records updated in LAU0105
  ' ' - all other records
man_updated_cCHAR(1)
Utilize vehicle tax rates (Y/N)utilize_veh_tax_rates_cCHAR(1)
State other ratep_st_oth_rat_dNUMBER(15,5)

rtr Indexes

Index NamePiece 1Piece 2Piece 3Piece 4Piece 5Piece 6Piece 7
rtr_idx0pay_typ_spor_srecip_sunit_lse_sd_pmtdu_suse_tax_cunique_s
rtr_idx1pay_typ_sunit_lse_spor_srecip_sd_pmtdu_suse_tax_cunique_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.