| Description | Column | Datatype |
|---|---|---|
| Payable type
00 - Use tax 01 - Property tax 02 - Federal highway use tax 03 -- 17 - Recurring charge 1-15 |
pay_typ_s | char (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_s | char (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_s | char (10) |
| Payment due date | d_pmtdu_s | datetime |
| Unique portion for key | unique_s | char (5) |
| Sybase timestamp | timestamp | timestamp |
| Invoice number | invo_s | char (8) |
| Asset | unit_s | char (10) |
| Property tax description code | ptax_desc_s | char (4) |
| Federal highway use tax (FHUT) description code | fhut_desc_s | char (4) |
| Tax accrued 1 (state) (amount payable) | tax_a1_d | double precision |
| Tax accrued 2 (county) | tax_a2_d | double precision |
| Tax accrued 3 (city) | tax_a3_d | double precision |
| Tax paid 1 (state) (amount paid) | tax_p1_d | double precision |
| Tax paid 2 (county) | tax_p2_d | double precision |
| Tax paid 3 (city) | tax_p3_d | double precision |
| Gross receipts (taxable) | gross_d | double precision |
| Manual update flag
'*' - flags records updated in LAU0105 ' ' - all other records |
man_updated_c | char (1) |
| Index name | Piece 1 | Piece 2 | Piece 3 | Piece 4 | Piece 5 | Piece 6 | Piece 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 |