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) |
integer | no |
timestamp | Record modification stamp |
timestamp | yes |
stg_eqty_d | Staged equity amount |
double precision | yes |
lvr_c | Leveraged (Y/N) |
char(1) | yes |
d_lvr_com_s | Leveraged commencement date |
datetime | yes |
d_lst_lvr_s | Date of last leveraged table download |
datetime | yes |
lvr_trm_l | Leveraged term |
integer | yes |
stg_eqty_pay_to_s | Staged equity fund payable to |
char(9) | yes |
npyr_min_d | Non-pyramiding late charge minimum payment due |
double precision | yes |
note_follow_up_l | Notebook follow-up days |
integer | yes |
d_fasb13_test_s | FASB 13 test date |
datetime | 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 |
double precision | yes |
opt_res_d | Optional residual |
double precision | yes |
p_opt_res_d | Optional residual percentage |
double precision | 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 |
double precision | yes |
dlr_rec_pmts_d | Dealer-received payments |
double precision | 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. |
integer | 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 |
integer | yes |
p_float_base_d | Float base rate percentage |
double precision | 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 |
datetime | 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 |
double precision | yes |
unused_fee_thresh_d | Unused drawdown fee threshold |
double precision | yes |
d_unused_fee_start_s | Start date of unused drawdown fee assessment |
datetime | yes |
d_unused_fee_next_s | Next date of unused drawdown fee assessment |
datetime | 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 |
char(50) | yes |
d_pap_eff_s | PAP effective date |
datetime | 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 |
integer | 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 |
integer | yes |
idc8_d | Guaranteed reserves IDC8 |
double precision | yes |
idc9_d | Guaranteed reserves IDC9 |
double precision | yes |
idca_d | Guaranteed reserves IDCA |
double precision | yes |
idcb_d | Guaranteed reserves IDCB |
double precision | yes |
idcc_d | Guaranteed reserves IDCC |
double precision | yes |
idcd_d | Guaranteed reserves IDCD |
double precision | yes |
idce_d | Guaranteed reserves IDCE |
double precision | yes |
idcf_d | Guaranteed reserves IDCF |
double precision | yes |
idcg_d | Guaranteed reserves IDCG |
double precision | yes |
idch_d | Guaranteed reserves IDCH |
double precision | yes |
idc_asc842_d | Total IDC ASC 842 initial direct cost amount |
double precision | 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 |
datetime | yes |
d_auto_pay_stop_s | Auto-pay stop date |
datetime | 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 |
double precision | yes |