| Description | Column | Datatype |
|---|---|---|
| Extension | ext_num_s | char (2) |
| Portfolio | por_s | char (2) |
| Company | com_s | char (2) |
| Region | reg_s | char (2) |
| Office | off_s | char (3) |
| Lease | lse_s | char (10) |
| Run date | d_run_s | datetime |
| Run time | t_run_s | char (6) |
| Transaction counter | trn_count_s | char (2) |
| Sybase timestamp | timestamp | timestamp |
| Effective date | d_eff_s | datetime |
| Invoice due date | d_indu_s | datetime |
| Transaction code | trn_s | char (4) |
| Payoff transaction code | ptrn_s | char (4) |
| Skip transfer to historical (Y/N) | skip_c | char (1) |
| A/R type flag (I/J/M/P/Q)
I - Invoice J - Overlapped due dates M - Credit memo P - Off lease billing of asset payoff Q - Off lease billing of lease payoff |
ar_typ_c | char (1) |
| Late charges calculated (Y/N) | late_c | char (1) |
| Operator initials | opr_s | char (3) |
| Invoice number | invo_s | char (8) |
| Asset | unit_s | char (10) |
| Suspense number | num_s | char (6) |
| Check number | chk_num_s | char (10) |
| Account credit vector | crdt_l | integer |
| Account debit vector | dbt_l | integer |
| Amount of money change | chg_d | double precision |
| Transaction reason code | trn_rsn_s | char (4) |
| Comments | comments_s | char (36) |
| Waived Principal/payment interest record (Y/N) | waive_c | char (1) |
| Index name | Piece 1 | Piece 2 | Piece 3 | Piece 4 | Piece 5 |
|---|---|---|---|---|---|
| rhx_idx0 | lse_s | ext_num_s | d_run_s | t_run_s | trn_count_s |