rpaz Table: Portfolio 3
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rpaz Table: Portfolio 3

Parent Table

Name Description
rpa Portfolio

Indexes

Name Segment 1 Segment 2
rpaz_idx0 por_s unique_l

    
Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
char(2) no
unique_l
Record number (value is always 1)
integer no
timestamp
Record modification stamp
timestamp yes
app_stat_list_s
List of application statuses
char(148) yes
app_ent_s
Entry requirements
char(148) yes
disp1_s
Display field (X/' ')
char(200) yes
disp2_s
Display field (X/' ')
char(200) yes
disp3_s
Display field (X/' ')
char(200) yes
fmv_trm1_l
FMV term [1]
integer yes
fmv_trm2_l
FMV term [2]
integer yes
fmv_trm3_l
FMV term [3]
integer yes
fmv_trm4_l
FMV term [4]
integer yes
fmv_trm5_l
FMV term [5]
integer yes
h_cntr1_d
Maximum lease rate - precomputed simple
double precision yes
h_cntr2_d
Maximum lease rate - simple interest
double precision yes
h_cntr3_d
Maximum lease rate - level yield
double precision yes
h_cntr4_d
Maximum lease rate - rule of 12/78ths
double precision yes
h_cntr5_d
Maximum lease rate - straight line
double precision yes
l_cntr1_d
Minimum lease rate - precomputed simple
double precision yes
l_cntr2_d
Minimum lease rate - simple interest
double precision yes
l_cntr3_d
Minimum lease rate - level yield
double precision yes
l_cntr4_d
Minimum lease rate - rule of 12/78ths
double precision yes
l_cntr5_d
Minimum lease rate - straight line
double precision yes
h_dlr1_d
Maximum vendor rate - precomputed simple
double precision yes
h_dlr2_d
Maximum vendor rate - simple interest
double precision yes
h_dlr3_d
Maximum vendor rate - level yield
double precision yes
h_dlr4_d
Maximum vendor rate - rule of 12/78ths
double precision yes
h_dlr5_d
Maximum vendor rate - straight line
double precision yes
l_dlr1_d
Minimum vendor rate - precomputed simple
double precision yes
l_dlr2_d
Minimum vendor rate - simple interest
double precision yes
l_dlr3_d
Minimum vendor rate - level yield
double precision yes
l_dlr4_d
Minimum vendor rate - rule of 12/78ths
double precision yes
l_dlr5_d
Minimum vendor rate - straight line
double precision yes
h_inv1_d
Maximum investor rate - precomputed simple
double precision yes
h_inv2_d
Maximum investor rate - simple interest
double precision yes
h_inv3_d
Maximum investor rate - level yield
double precision yes
h_inv4_d
Maximum investor rate - rule of 12/78ths
double precision yes
h_inv5_d
Maximum investor rate - straight line
double precision yes
l_inv1_d
Minimum investor rate - precomputed simple
double precision yes
l_inv2_d
Minimum investor rate - simple interest
double precision yes
l_inv3_d
Minimum investor rate - level yield
double precision yes
l_inv4_d
Minimum investor rate - rule of 12/78ths
double precision yes
l_inv5_d
Minimum investor rate - straight line
double precision yes
fmv_per1_d
FMV percentage [1]
double precision yes
fmv_per2_d
FMV percentage [2]
double precision yes
fmv_per3_d
FMV percentage [3]
double precision yes
fmv_per4_d
FMV percentage [4]
double precision yes
fmv_per5_d
FMV percentage [5]
double precision yes
dflt_displ_pmt_c
Default display payment amount (Y/N)
char(1) yes
add_com_trn_c
Add comment to transaction (Y/N)
char(1) yes
past_due_priority_c
Priority settings affect application of payments to past-due
  items in (A/B/N):
  A - all payment processing
  B - batch payment processing only
  N - no payment processing
char(1) yes
waive_bank_s
Principal/payment interest bank code
char(3) yes
s_idc1_s
IDC1 alias - 21 characters
char(21) yes
s_idc2_s
IDC2 alias - 21 characters
char(21) yes
s_idc3_s
IDC3 alias - 21 characters
char(21) yes
s_idc4_s
IDC4 alias - 21 characters
char(21) yes
s_idc5_s
IDC5 alias - 21 characters
char(21) yes
s_idr1_s
IDR1 alias - 21 characters
char(21) yes
s_idr2_s
IDR2 alias - 21 characters
char(21) yes
s_idr3_s
IDR3 alias - 21 characters
char(21) yes
s_idr4_s
IDR4 alias - 21 characters
char(21) yes
s_idr5_s
IDR5 alias - 21 characters
char(21) yes
s_idr6_s
IDR6 alias - 21 characters
char(21) yes
s_idr7_s
IDR7 alias - 21 characters
char(21) yes
s_idr8_s
IDR8 alias - 21 characters
char(21) yes
s_idr9_s
IDR9 alias - 21 characters
char(21) yes
s_idra_s
IDRA alias - 21 characters
char(21) yes
s_idrb_s
IDRB alias - 21 characters
char(21) yes
s_idrc_s
IDRC alias - 21 characters
char(21) yes
ss_idc1_s
IDC1 alias - 9 characters
char(9) yes
ss_idc2_s
IDC2 alias - 9 characters
char(9) yes
ss_idc3_s
IDC3 alias - 9 characters
char(9) yes
ss_idc4_s
IDC4 alias - 9 characters
char(9) yes
ss_idc5_s
IDC5 alias - 9 characters
char(9) yes
ss_idr1_s
IDR1 alias - 9 characters
char(9) yes
ss_idr2_s
IDR2 alias - 9 characters
char(9) yes
ss_idr3_s
IDR3 alias - 9 characters
char(9) yes
ss_idr4_s
IDR4 alias - 9 characters
char(9) yes
ss_idr5_s
IDR5 alias - 9 characters
char(9) yes
ss_idr6_s
IDR6 alias - 9 characters
char(9) yes
ss_idr7_s
IDR7 alias - 9 characters
char(9) yes
ss_idr8_s
IDR8 alias - 9 characters
char(9) yes
ss_idr9_s
IDR9 alias - 9 characters
char(9) yes
ss_idra_s
IDRA alias - 9 characters
char(9) yes
ss_idrb_s
IDRB alias - 9 characters
char(9) yes
ss_idrc_s
IDRC alias - 9 characters
char(9) yes
dwn_pmt_inf_c
Down payment is informational only (Y/N)
char(1) yes
auto_payo_loss_tol_d
Automatic payoff loss tolerance
double precision yes
auto_payo_gain_tol_d
Automatic payoff gain tolerance
double precision yes
rev_cat1_s
Reversal reason code/bank code [1]
char(5) yes
rev_cat2_s
Reversal reason code/bank code [2]
char(5) yes
rev_cat3_s
Reversal reason code/bank code [3]
char(5) yes
rev_cat4_s
Reversal reason code/bank code [4]
char(5) yes
rev_cat5_s
Reversal reason code/bank code [5]
char(5) yes
cc_auto_sus_bank_s
Default bank code for auto suspense
char(3) yes
cc_auto_sus_cro_s
Default C/R/O for auto suspense
char(7) yes
del_pmt_perc_l
Delinquency payment percentage
integer yes
delq4_l
Delinquency category boundaries [4]
integer yes
delq5_l
Delinquency category boundaries [5]
integer yes
delq6_l
Delinquency category boundaries [6]
integer yes
sec_bank_s
Default securitization bank code
char(3) yes
delq_method_c
Delinquency determination method before payoff (A/B/C)
  A - principal and interest
  B - principal, interest, and sales tax
  C - principal, interest, and charges included by column
      rpar.chrg_delq_c
char(1) yes
pmt_frst_extdef_l
Number of payments for first extension/deferment eligibility
integer yes
pmt_btw_extdef_l
Number of payments between for next extension/deferment
integer yes