| 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/' ') Y - Vertex O is used N or ' ' - 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 |