rtp Table: Tax Payable

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
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
unique_s	Unique portion for key
	Record modification stamp
invo_s	Invoice number
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
ptax_desc_s	Property tax description code
fhut_desc_s	Federal highway use tax (FHUT) description code
tax_a1_d	Tax accrued 1 (state) (amount payable)
tax_a2_d	Tax accrued 2 (county)
tax_a3_d	Tax accrued 3 (city)
tax_p1_d	Tax paid 1 (state) (amount paid)
tax_p2_d	Tax paid 2 (county)
tax_p3_d	Tax paid 3 (city)
gross_d	Gross receipts (taxable)
man_updated_c	Manual update flag '*' - flags records updated in LAU0105 ' ' - all other records
can_tax_round_c	Canada tax rounding (Y/N)
cnty_s	County
cty_s	City