| Name | Description |
|---|---|
| rap | Application |
| Name | Segment 1 | Segment 2 |
|---|---|---|
| rapa_idx0 | app_s | unique_l |
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null |
| app_s | Application |
CHAR(10) | no |
| unique_l | Record number (value is always 1) |
NUMBER(10) | no |
| stamp_l | Record modification stamp |
NUMBER(10) | no |
| stg_eqty_d | Staged equity amount |
NUMBER(15,2) | yes |
| lvr_c | Leveraged (Y/N) |
CHAR(1) | yes |
| d_lvr_com_s | Leveraged commencement date |
DATE | yes |
| d_lst_lvr_s | Date of last leveraged table download |
DATE | yes |
| lvr_trm_l | Leveraged term |
NUMBER(10) | yes |
| stg_eqty_pay_to_s | Staged equity fund payable to |
CHAR(9) | yes |
| npyr_min_d | Non-pyramiding late charge minimum payment due |
NUMBER(15,2) | yes |
| note_follow_up_l | Notebook follow-up days |
NUMBER(10) | yes |
| d_fasb13_test_s | FASB 13 test date |
DATE | yes |
| fasb13_test_c | FASB 13 test result (P/F/' ') P - Pass F - Fail ' ' - Untested |
CHAR(1) | yes |
| orig_intfc_s | Originating interface MBT - Microbilt MPR - mPower STM - SuperTrump |
CHAR(3) | yes |
| metro2_s | Metro2 file format code |
CHAR(4) | yes |
| invo_format_s | Invoice format code |
CHAR(4) | yes |
| non_comm_d | Non commission amount |
NUMBER(15,2) | yes |
| opt_res_d | Optional residual |
NUMBER(15,2) | yes |
| p_opt_res_d | Optional residual percentage |
NUMBER(15,5) | yes |
| revolving_drawdown_c | Revolving drawdown credit (Y/N) |
CHAR(1) | yes |
| stax_exempt_s | Sales/use tax exempt code |
CHAR(4) | yes |
| oper_drawdown_d | Operating lease application drawdown amount |
NUMBER(15,2) | yes |
| dlr_rec_pmts_d | Dealer-received payments |
NUMBER(15,2) | yes |
| prn_write_down_c | Principal write down (Y/N) |
CHAR(1) | yes |
| float_bus_or_cal_c | Set float rate on business or calendar day (P/F/C) P - previous business day F - following business day C - calendar day |
CHAR(1) | yes |
| float_frq_s | Frequency of float rate setting DAY - daily MON - monthly QTR - quarterly SEMI - semiannually ANNL - annually NONE - rate setting functionality is disabled |
CHAR(4) | yes |
| float_day_l | Day of month on which float rate is set (1-31 or 0) A value of zero indicates that the rate setting functionality has been disabled. |
NUMBER(10) | yes |
| float_mon_l | Month in which float rate is set (1-12 or 0) 0 - if frequency is NONE, MON or DAY 1 to 3 - if frequency is QTR 1 to 6 - if frequency is SEMI 1 to 12 - if frequency is ANNL |
NUMBER(10) | yes |
| p_float_base_d | Float base rate percentage |
NUMBER(15,5) | yes |
| calendar_s | Calendar to use for determining business days |
CHAR(4) | yes |
| dlr_pmt_bank_code_s | Dealer payment bank code |
CHAR(4) | yes |
| d_cntr_end_s | Contract end date |
DATE | yes |
| dlr_pmt_applied_c | Dealer payments applied (Y/N) |
CHAR(1) | yes |
| rcr_pmt_sched_c | Has recurring charge payment schedule (Y/N) |
CHAR(1) | yes |
| rcr_synch_c | Recurring charge payment schedule in synch with lease (Y/N) |
CHAR(1) | yes |
| asset_lvl_c | Has asset level payment schedule (Y/N) |
CHAR(1) | yes |
| assmt_desc_c | Has assessment description (Y/N) |
CHAR(1) | yes |
| p_unused_fee_d | Unused drawdown fee rate |
NUMBER(15,5) | yes |
| unused_fee_thresh_d | Unused drawdown fee threshold |
NUMBER(15,2) | yes |
| d_unused_fee_start_s | Start date of unused drawdown fee assessment |
DATE | yes |
| d_unused_fee_next_s | Next date of unused drawdown fee assessment |
DATE | yes |
| unused_fee_frq_s | Unused drawdown fee frequency (NONE/DAY/MON/QTR/SEMI/ANNL) |
CHAR(4) | yes |
| pmt_hier_s | Payment hierarchy |
CHAR(4) | yes |
| pool_id_s | Pool ID |
CHAR(10) | yes |
| inst_id_s | PAP institution/ACH transit ID |
CHAR(9) | yes |
| payer_acct_s | PAP account number |
CHAR(17) | yes |
| payer_acct_nam_s | PAP bank account name |
VARCHAR2(50) | yes |
| d_pap_eff_s | PAP effective date |
DATE | 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 |
| int_free_mths_l | Interest free months |
NUMBER(10) | yes |
| prepaid_c | Prepaid lease (Y/N) |
CHAR(1) | yes |
| auto_pay_interval_l | Auto-pay interval frequency (0/1/2/4) 0 - defined in rjp (Automatic Payment Interval Schedule) 1 - once per billing cycle 2 - twice per billing cycle 4 - four times per billing cycle |
NUMBER(10) | yes |
| idc8_d | Guaranteed reserves IDC8 |
NUMBER(15,2) | yes |
| idc9_d | Guaranteed reserves IDC9 |
NUMBER(15,2) | yes |
| idca_d | Guaranteed reserves IDCA |
NUMBER(15,2) | yes |
| idcb_d | Guaranteed reserves IDCB |
NUMBER(15,2) | yes |
| idcc_d | Guaranteed reserves IDCC |
NUMBER(15,2) | yes |
| idcd_d | Guaranteed reserves IDCD |
NUMBER(15,2) | yes |
| idce_d | Guaranteed reserves IDCE |
NUMBER(15,2) | yes |
| idcf_d | Guaranteed reserves IDCF |
NUMBER(15,2) | yes |
| idcg_d | Guaranteed reserves IDCG |
NUMBER(15,2) | yes |
| idch_d | Guaranteed reserves IDCH |
NUMBER(15,2) | yes |
| idc_asc842_d | Total IDC ASC 842 initial direct cost amount |
NUMBER(15,2) | yes |
| accrual_cycle_c | Accrual/billing cycle (M/S/B/W) M - Monthly (12 per year) S - Semi-monthly (24 per year) B - Bi-weekly (26 per year) W - Weekly (52 per year) |
CHAR(1) | yes |
| idc_book_accting_c | IDC book accounting method (I/A/B) I - Income A - Amortization B - Alternative amortization |
CHAR(1) | yes |
| pmt_source_s | Payment source |
CHAR(2) | yes |
| auto_pay_c | Auto-pay through a Payment Service (Y/N) |
CHAR(1) | yes |
| d_auto_pay_start_s | Auto-pay start date |
DATE | yes |
| d_auto_pay_stop_s | Auto-pay stop date |
DATE | yes |
| auto_pay_amt_type_c | Auto-pay amount type (A/B/C/D/T/P/O/' ')
A - Total outstanding on current invoice (apply lease)
B - Total outstanding on current invoice (apply invoice)
C - Payment and tax outstanding on current invoice (apply
lease)
D - Payment and tax outstanding on current invoice (apply
invoice)
T - Total outstanding on lease
P - Payment and tax outstanding on lease
O - Other specified amount
' ' - n/a |
CHAR(1) | yes |
| auto_pay_other_amt_d | Auto-pay other amount |
NUMBER(15,2) | yes |