rtp Table: Tax Payable

Database Reference Sybase DBMS

rtp Table: Tax Payable

Indexes

Name	Segment 1	Segment 2	Segment 3	Segment 4	Segment 5	Segment 6	Segment 7
rtp_idx0	pay_typ_s	recip_s	unit_lse_s	d_pmtdu_s	unique_s
rtp_idx1	pay_typ_s	invo_s	unit_s	recip_s	unit_lse_s	d_pmtdu_s	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
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	datetime	no
unique_s	Unique portion for key	char(5)	no
timestamp	Record modification stamp	timestamp	yes
invo_s	Invoice number	char(8)	no
unit_s	Asset or lease: If payable type is use tax, property tax, or FHUT then unit_s = asset number If payable type is recurring charge then unit_s = lease number	char(10)	no
ptax_desc_s	Property tax description code	char(4)	yes
fhut_desc_s	Federal highway use tax (FHUT) description code	char(4)	yes
tax_a1_d	Tax accrued 1 (state) (amount payable)	double precision	yes
tax_a2_d	Tax accrued 2 (county)	double precision	yes
tax_a3_d	Tax accrued 3 (city)	double precision	yes
tax_p1_d	Tax paid 1 (state) (amount paid)	double precision	yes
tax_p2_d	Tax paid 2 (county)	double precision	yes
tax_p3_d	Tax paid 3 (city)	double precision	yes
gross_d	Gross receipts (taxable)	double precision	yes
man_updated_c	Manual update flag '*' - flags records updated in LAU0105 ' ' - all other records	char(1)	yes
can_tax_round_c	Canada tax rounding (Y/N)	char(1)	yes
cnty_s	County	char(60)	yes
cty_s	City	char(25)	yes