rtr Table: Tax Released

Database Reference

rtr Table: Tax Released

Indexes

Name	Segment 1	Segment 2	Segment 3	Segment 4	Segment 5	Segment 6	Segment 7
rtr_idx0	pay_typ_s	por_s	recip_s	unit_lse_s	d_pmtdu_s	use_tax_c	unique_s
rtr_idx1	pay_typ_s	unit_lse_s	por_s	recip_s	d_pmtdu_s	use_tax_c	unique_s

Columns
Name	Description	Datatype ¿?	Allow Null
pay_typ_s	Payable type 00 - Use tax 01 - Property tax 02 - Federal highway use tax 03-37 - Recurring charge 1-35 38-47 - Asset fee 1-10 80-89 - Asset fee 1-10 when Vertex O used 90 - Vertex O Sales and use tax 91 - Property tax when Vertex O used 92 - FHUT when Vertex O used
por_s	Portfolio
recip_s	Payable recipient On Payable type: 00 - recip_s = State(2)/County(4)/City(4) 01,02,38-47 - recip_s = State(2)/County(4) 03-37 - recip_s = Broker/Vendor number + " " 80-89,90,91,92 - recip_s = State(2) (RST.ST_S code)
unit_lse_s	Asset or lease: If payable type is use tax, property tax, FHUT, or asset fee, then unit_lse_s = asset number If payable type is recurring charge then unit_lse_s = lease number
d_pmtdu_s	Payment due date
use_tax_c	Use tax entity (0/1/2) When pay_type_s is 00: 0 - State 1 - County 2 - City When pay_typ_s is not 00: 0 - Generic
unique_s	Unique portion for key
	Record modification stamp
com_s	Company
reg_s	Region
off_s	Office
lse_s	Lease
rpt_c	Reportable switch (Y/N/' ') Y - reports on U0449A and U0449B N - reports on U0449D and U0449E ' ' - all other records
p_ct_trnst_rat_d	County transit rate
p_cy_trnst_rat_d	City transit rate
nontax_gross_d	Gross receipts (non-taxable)
tax_r_d	Tax released (amount released)
gross_d	Gross receipts (taxable)
p_st_rat_d	State rate
p_ct_rat_d	County rate
p_cy_rat_d	City rate
man_updated_c	Manual update flag '*' - flags records updated in LAU0105 ' ' - all other records
utilize_veh_tax_rates_c	Utilize vehicle tax rates (Y/N)
p_st_oth_rat_d	State other rate
cnty_s	County
cty_s	City