| Name | Description | 
|---|---|
| rarb | Accounts Receivable Assessment | 
| Name | Segment 1 | Segment 2 | Segment 3 | Segment 4 | Segment 5 | Segment 6 | Segment 7 | 
|---|---|---|---|---|---|---|---|
| rar_idx0 | por_s | com_s | reg_s | off_s | lse_s | d_pmtdu_s | ar_typ_c | 
| rar_idx1 | invo_s | 
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null | 
| por_s | Portfolio  | 
CHAR(2) | no | 
| com_s | Company  | 
CHAR(2) | no | 
| reg_s | Region  | 
CHAR(2) | no | 
| off_s | Office  | 
CHAR(3) | no | 
| lse_s | Lease  | 
CHAR(10) | no | 
| d_pmtdu_s | Payment due date  | 
DATE | no | 
| ar_typ_c | A/R type flag (I/J/H/M/P/Q) I - Invoice J - Overlapped due dates H - Advance invoice M - Credit memo P - Off Lease Billing of asset payoff Q - Off Lease Billing of lease payoff  | 
CHAR(1) | no | 
| stamp_l | Record modification stamp  | 
NUMBER(10) | no | 
| invo_s | Invoice number  | 
CHAR(8) | no | 
| d_last_s | Date of last update  | 
DATE | yes | 
| bank_s | Bank account GL vector ' 1' - If multiple banks module is purchased ' ' - multiple banks module is not purchased  | 
CHAR(3) | yes | 
| ptax_desc_s | Property tax description code  | 
CHAR(4) | yes | 
| fhut_desc_s | Federal highway use tax (FHUT) description code  | 
CHAR(4) | yes | 
| grp_c | Group switch (Y/N)  | 
CHAR(1) | yes | 
| prin_bill_c | Principal bill switch (B/N)  | 
CHAR(1) | yes | 
| int_bill_c | Interest bill switch (B/N)  | 
CHAR(1) | yes | 
| a_pmt_c | Assumed payment (Y/N)  | 
CHAR(1) | yes | 
| auto_ltch_assessed_c | Automatic late charges assessed (Y/N)  | 
CHAR(1) | yes | 
| car_d | Interest carryover  | 
NUMBER(15,2) | yes | 
| tamt_b_d | Total amount billed  | 
NUMBER(15,2) | yes | 
| tamt_p_d | Total amount paid  | 
NUMBER(15,2) | yes | 
| pamt_b_d | Payment amount billed  | 
NUMBER(15,2) | yes | 
| pamt_p_d | Payment amount paid  | 
NUMBER(15,2) | yes | 
| iamt_b_d | Interest amount billed  | 
NUMBER(15,2) | yes | 
| iamt_p_d | Interest amount paid  | 
NUMBER(15,2) | yes | 
| int_d | Interest portion - memo account  | 
NUMBER(15,2) | yes | 
| int_adj_d | Interest adjustment  | 
NUMBER(15,2) | yes | 
| income_accrued_c | Income accrued (Y/N)  | 
CHAR(1) | yes | 
| prin_stax_c | Principal sales tax (Y/N)  | 
CHAR(1) | yes | 
| int_stax_c | Interest sales tax (Y/N)  | 
CHAR(1) | yes | 
| org_iamt_b_d | Interest amount billed when invoice 1st created  | 
NUMBER(15,2) | yes | 
| delq_category_l | Current delinquency category  | 
NUMBER(10) | yes | 
| late_int_d | Interest paid after due date  | 
NUMBER(15,2) | yes | 
| 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  | 
CHAR(1) | yes | 
| d_prin_bill_s | Date principal billed  | 
DATE | yes | 
| d_int_bill_s | Date interest billed  | 
DATE | yes | 
| tamt_p_after_payoff_d | Total amount paid after payoff  | 
NUMBER(15,2) | yes | 
| pamt_p_after_payoff_d | Payment amount paid after payoff  | 
NUMBER(15,2) | yes | 
| iamt_p_after_payoff_d | Interest amount paid after payoff  | 
NUMBER(15,2) | yes | 
| vtx_o_c | Use Vertex O (Y/N/NULL) Y - Vertex O is used N or NULL - Vertex O is not used  | 
CHAR(1) | yes | 
| paid_off_ck_c | Lease change-keyed after payoff (Y/' ') Y - Lease was change-keyed ' ' - Lease was not change-keyed  | 
CHAR(1) | yes |