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

Database Reference Sybase DBMS

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
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