rtr Table: Tax Released

Database Reference Oracle DBMS

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	CHAR(2)	no
por_s	Portfolio	CHAR(2)	no
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)	CHAR(10)	no
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	CHAR(10)	no
d_pmtdu_s	Payment due date	DATE	no
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	CHAR(1)	no
unique_s	Unique portion for key	CHAR(5)	no
stamp_l	Record modification stamp	NUMBER(10)	no
com_s	Company	CHAR(2)	yes
reg_s	Region	CHAR(2)	yes
off_s	Office	CHAR(3)	yes
lse_s	Lease	CHAR(10)	yes
rpt_c	Reportable switch (Y/N/' ') Y - reports on U0449A and U0449B N - reports on U0449D and U0449E ' ' - all other records	CHAR(1)	yes
p_ct_trnst_rat_d	County transit rate	NUMBER(15,5)	yes
p_cy_trnst_rat_d	City transit rate	NUMBER(15,5)	yes
nontax_gross_d	Gross receipts (non-taxable)	NUMBER(15,2)	yes
tax_r_d	Tax released (amount released)	NUMBER(15,2)	yes
gross_d	Gross receipts (taxable)	NUMBER(15,2)	yes
p_st_rat_d	State rate	NUMBER(15,5)	yes
p_ct_rat_d	County rate	NUMBER(15,5)	yes
p_cy_rat_d	City rate	NUMBER(15,5)	yes
man_updated_c	Manual update flag '*' - flags records updated in LAU0105 ' ' - all other records	CHAR(1)	yes
utilize_veh_tax_rates_c	Utilize vehicle tax rates (Y/N)	CHAR(1)	yes
p_st_oth_rat_d	State other rate	NUMBER(15,5)	yes
cnty_s	County	VARCHAR2(60)	yes
cty_s	City	VARCHAR2(25)	yes