rtp Table: Tax Payable
Oracle DBMS

Specifies the columns and rows with Oracle data type information for the rtp Tax Payable table.

rtp 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)
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
Unique portion for keyunique_sCHAR(5)
Record modification stampstamp_lNUMBER(10)
Invoice numberinvo_sCHAR(8)
Assetunit_sCHAR(10)
Property tax description codeptax_desc_sCHAR(4)
Federal highway use tax (FHUT) description codefhut_desc_sCHAR(4)
Tax accrued 1 (state) (amount payable)tax_a1_dNUMBER(15,2)
Tax accrued 2 (county)tax_a2_dNUMBER(15,2)
Tax accrued 3 (city)tax_a3_dNUMBER(15,2)
Tax paid 1 (state) (amount paid)tax_p1_dNUMBER(15,2)
Tax paid 2 (county)tax_p2_dNUMBER(15,2)
Tax paid 3 (city)tax_p3_dNUMBER(15,2)
Gross receipts (taxable)gross_dNUMBER(15,2)
Manual update flag
  '*' - flags records updated in LAU0105
  ' ' - all other records
man_updated_cCHAR(1)

rtp Indexes

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