| Description | Column | Datatype |
|---|---|---|
| EOM that created these records | d_end_of_month_s | datetime |
| Payable type
00 - Use tax 01 - Property tax 02 - Federal highway use tax 03 -- 17 - Recurring charge 1-15 |
pay_typ_s | char (2) |
| Portfolio | por_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 |
| Use tax entity:
0 - State, all other payables 1 - County 2 - City |
use_tax_c | char (1) |
| Unique portion for key | unique_s | char (5) |
| Sybase timestamp | timestamp | timestamp |
| Company | com_s | char (2) |
| Region | reg_s | char (2) |
| Office | off_s | char (3) |
| Lease | lse_s | char (10) |
| Reportable switch (Y/N/' ')
Y - reports on u0449a and u0449b N - reports on u0449d and u0449e ' ' - all other records |
rpt_c | char (1) |
| County transit rate | p_ct_trnst_rat_d | double precision |
| City transit rate | p_cy_trnst_rat_d | double precision |
| Gross receipts (non-taxable) | nontax_gross_d | double precision |
| Tax released (amount released) | tax_r_d | double precision |
| Gross receipts (taxable) | gross_d | double precision |
| State rate | p_st_rat_d | double precision |
| County rate | p_ct_rat_d | double precision |
| City rate | p_cy_rat_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 | Piece 8 |
|---|---|---|---|---|---|---|---|---|
| rhr_idx0 | d_end_of_month_s | pay_typ_s | por_s | recip_s | unit_lse_s | d_pmtdu_s | use_tax_c | unique_s |