rapa Table: Application 2
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference

rapa Table: Application 2

Parent Table

Name Description
rap Application

Indexes

Name Segment 1 Segment 2
rapa_idx0 app_s unique_l


Columns
Name DescriptionDatatype ¿? Allow Null
app_s
Application
unique_l
Record number (value is always 1)
Record modification stamp
stg_eqty_d
Staged equity amount
lvr_c
Leveraged (Y/N)
d_lvr_com_s
Leveraged commencement date
d_lst_lvr_s
Date of last leveraged table download
lvr_trm_l
Leveraged term
stg_eqty_pay_to_s
Staged equity fund payable to
npyr_min_d
Non-pyramiding late charge minimum payment due
note_follow_up_l
Notebook follow-up days
d_fasb13_test_s
FASB 13 test date
fasb13_test_c
FASB 13 test result (P/F/' ')
  P - Pass
  F - Fail
  ' ' - Untested
orig_intfc_s
Originating interface
  MBT - Microbilt
  MPR - mPower
  STM - SuperTrump
metro2_s
Metro2 file format code
invo_format_s
Invoice format code
non_comm_d
Non commission amount
opt_res_d
Optional residual
p_opt_res_d
Optional residual percentage
revolving_drawdown_c
Revolving drawdown credit (Y/N)
stax_exempt_s
Sales/use tax exempt code
oper_drawdown_d
Operating lease application drawdown amount
dlr_rec_pmts_d
Dealer-received payments
prn_write_down_c
Principal write down (Y/N)
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
float_frq_s
Frequency of float rate setting
  DAY - daily
  MON - monthly
  QTR - quarterly
  SEMI - semiannually
  ANNL - annually
  NONE - rate setting functionality is disabled
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.
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
p_float_base_d
Float base rate percentage
calendar_s
Calendar to use for determining business days
dlr_pmt_bank_code_s
Dealer payment bank code
d_cntr_end_s
Contract end date
dlr_pmt_applied_c
Dealer payments applied (Y/N)
rcr_pmt_sched_c
Has recurring charge payment schedule (Y/N)
rcr_synch_c
Recurring charge payment schedule in synch with lease (Y/N)
asset_lvl_c
Has asset level payment schedule (Y/N)
assmt_desc_c
Has assessment description (Y/N)
p_unused_fee_d
Unused drawdown fee rate
unused_fee_thresh_d
Unused drawdown fee threshold
d_unused_fee_start_s
Start date of unused drawdown fee assessment
d_unused_fee_next_s
Next date of unused drawdown fee assessment
unused_fee_frq_s
Unused drawdown fee frequency (NONE/DAY/MON/QTR/SEMI/ANNL)
pmt_hier_s
Payment hierarchy
pool_id_s
Pool ID
inst_id_s
PAP institution/ACH transit ID
payer_acct_s
PAP account number
payer_acct_nam_s
PAP bank account name
d_pap_eff_s
PAP effective date
vtx_o_c
Use Vertex O (Y/N/NULL)
  Y - Vertex O is used
  N or NULL - Vertex O is not used
int_free_mths_l
Interest free months
prepaid_c
Prepaid lease (Y/N)
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
idc8_d
Guaranteed reserves IDC8
idc9_d
Guaranteed reserves IDC9
idca_d
Guaranteed reserves IDCA
idcb_d
Guaranteed reserves IDCB
idcc_d
Guaranteed reserves IDCC
idcd_d
Guaranteed reserves IDCD
idce_d
Guaranteed reserves IDCE
idcf_d
Guaranteed reserves IDCF
idcg_d
Guaranteed reserves IDCG
idch_d
Guaranteed reserves IDCH
idc_asc842_d
Total IDC ASC 842 initial direct cost amount
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)
idc_book_accting_c
IDC book accounting method (I/A/B)
  I - Income
  A - Amortization
  B - Alternative amortization
pmt_source_s
Payment source
auto_pay_c
Auto-pay through a Payment Service (Y/N)
d_auto_pay_start_s
Auto-pay start date
d_auto_pay_stop_s
Auto-pay stop date
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
auto_pay_other_amt_d
Auto-pay other amount