| Name | Description | 
|---|---|
| rhab | Historical Accounts Receivable Assessment | 
| Name | Segment 1 | Segment 2 | Segment 3 | Segment 4 | Segment 5 | Segment 6 | Segment 7 | 
|---|---|---|---|---|---|---|---|
| rha_idx0 | por_s | com_s | reg_s | off_s | lse_s | d_pmtdu_s | ar_typ_c | 
| rha_idx1 | invo_s | 
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null | 
| por_s | Portfolio  | 
||
| com_s | Company  | 
||
| reg_s | Region  | 
||
| off_s | Office  | 
||
| lse_s | Lease  | 
||
| d_pmtdu_s | Payment due date  | 
||
| ar_typ_c | 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  | 
||
Record modification stamp  | 
|||
| invo_s | Invoice number  | 
||
| d_last_s | Date of last update  | 
||
| bank_s | Bank account GL vector ' 1' - If multiple banks module is purchased ' ' - multiple banks module is not purchased  | 
||
| ptax_desc_s | Property tax description code  | 
||
| fhut_desc_s | Federal highway use tax (FHUT) description code  | 
||
| grp_c | Group switch (Y/N)  | 
||
| pay_c | A/R payoff switch (Y/N)  | 
||
| prin_bill_c | Principal bill switch (B/N)  | 
||
| int_bill_c | Interest bill switch (B/N)  | 
||
| auto_ltch_assessed_c | Automatic late charges assessed (Y/N)  | 
||
| car_d | Interest carryover  | 
||
| tamt_p_d | Total amount paid  | 
||
| pamt_b_d | Payment amount billed  | 
||
| pamt_p_d | Payment amount paid  | 
||
| iamt_b_d | Interest amount billed  | 
||
| iamt_p_d | Interest amount paid  | 
||
| int_d | Interest portion - memo account  | 
||
| int_adj_d | Interest adjustment  | 
||
| prin_stax_c | Principal sales tax (Y/N)  | 
||
| int_stax_c | Interest sales tax (Y/N)  | 
||
| org_iamt_b_d | Interest amount billed when invoice 1st created  | 
||
| delq_category_l | Current delinquency category  | 
||
| late_int_d | Interest paid after due date  | 
||
| olb_payoff_c | Off lease billing payoff/termination flag (T/P/' ') T - Termination and off lease billing P or Q invoice P - Payoff and off lease billing P or Q invoice ' ' - not off lease billing P or Q invoice  | 
||
| tamt_p_after_payoff_d | Total amount paid after payoff  | 
||
| pamt_p_after_payoff_d | Payment amount paid after payoff  | 
||
| iamt_p_after_payoff_d | Interest amount paid after payoff  | 
||
| vtx_o_c | Use Vertex O (Y/N/' ') Y - Vertex O is used N or ' ' - Vertex O is not used  | 
||
| paid_off_ck_c | Lease change-keyed after payoff (Y/' ') Y - Lease was change-keyed ' ' - Lease was not change-keyed  | 
||