| Description | Column | Datatype |
|---|---|---|
| Investor | inv_s | char (9) |
| Lease | lse_s | char (10) |
| Invoice number | invo_s | char (8) |
| Invoice reversal counter | rev_count_s | char (3) |
| Sybase timestamp | timestamp | timestamp |
| Date last update | d_last_s | datetime |
| Time of last update | t_lup_s | char (6) |
| Payment due date | d_due_s | datetime |
| Reversal date | d_rev_s | datetime |
| Earliest disbursement date
Payment due date + deferral dates (d_last_s + def_days_l) |
d_ear_dis_s | datetime |
| Disbursement date | d_dis_s | datetime |
| Disbursal bank account G/L vector | disb_bank_s | char (3) |
| Type of cashier's check | cash_check_typ_s | char (4) |
| Bank account G/L vector
' 1' - If multiple banks module is purchased ' ' - multiple banks module is not purchased. |
bank_s | char (3) |
| Assumed payment (Y/N) | a_pmt_c | char (1) |
| Check number | chk_s | char (6) |
| Check reference | chk_ref_s | char (36) |
| Participation percentage | part_perc_d | double precision |
| Investor participation total expected payment to be received
Invoice total (payment amount + interest amount) billed times the investor participation percent (rar.pamt_b_d + rar.iamt_b_d) * ris.part_perc_l |
inv_pamt_b_d | double precision |
| Investor participation total expected interest to be received
Invoice total interest amount billed times the investor participation percent rar.iamt_b_d * ris.part_perc_l |
inv_iamt_b_d | double precision |
| Investor participation total payment collected to date
Invoice total (payment amount + interest amount) paid times the investor participation percent (rar.pamt_p_d + rar.iamt_p_d) * ris.part_perc_l |
inv_pamt_c_d | double precision |
| Investor participation total interest collected to date
Invoice total interest amount paid times the investor participation percent rar.iamt_p_d * ris.part_perc_l |
inv_iamt_c_d | double precision |
| Investor participation total payment disbursed to date | inv_pamt_d_d | double precision |
| Investor participation total interest disbursed to date | inv_iamt_d_d | double precision |
| Index name | Piece 1 | Piece 2 | Piece 3 | Piece 4 |
|---|---|---|---|---|
| ris_idx0 | inv_s | lse_s | invo_s | rev_count_s |
| ris_idx1 | lse_s | invo_s | inv_s | rev_count_s |