rpa Table: Portfolio
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rpa Table: Portfolio

Child Tables

Name Description
rpar Porfolio Charge
rpay Portfolio 2
rpaz Portfolio 3

Indexes

Name Segment 1
rpa_idx0 por_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
CHAR(2) no
stamp_l
Record modification stamp
NUMBER(10) no
def_app_s
Default application
CHAR(10) yes
md_fis_s
Fiscal year end (MMDD)
CHAR(4) yes
md_tax_s
Tax reporting deadline for year end (MMDD)
CHAR(4) yes
md_itc_cut_s
ITC cutoff date (MMDD)
CHAR(4) yes
md_prev_fis_s
Previous fiscal year end (MMDD)
CHAR(4) yes
d_eff_fis_s
Effective fiscal year end
DATE yes
port_typ_s
Portfolio interest type
CHAR(4) yes
inv_hdg_s
Invoice heading code
CHAR(4) yes
invo_format_s
Invoice format code
CHAR(4) yes
remit_asg_s
Remittance address code
CHAR(4) yes
idc_amt_s
Initial direct cost amount code
CHAR(4) yes
idc_method_s
Initial direct cost method
CHAR(4) yes
col_team_s
Collection team
CHAR(4) yes
kol_team_s
Collateral team
CHAR(4) yes
ml_team_s
Maturing lease team
CHAR(4) yes
col_supr_s
Collection supervisor
CHAR(3) yes
kol_supr_s
Collateral supervisor
CHAR(3) yes
ml_supr_s
Maturing lease supervisor
CHAR(3) yes
clone_to_status_s
Clone to application status
CHAR(4) yes
master_appl_status_s
Master application status
CHAR(4) yes
ind_inv_laser_s
Individual invoice laser form code
CHAR(4) yes
grp_inv_laser_s
Group invoice laser form code
CHAR(4) yes
comm_stat_s
Commission access status code
  Used by Bell Atlantic - do not delete.
CHAR(4) yes
credit_apprv_stat_s
Credit approval status code
CHAR(4) yes
prim_num_s
Prime rate bank number
CHAR(4) yes
itc_accrue_c
Book ITC accrue (Y/N)
CHAR(1) yes
pro_rate_c
Interim rent (Y/N)
CHAR(1) yes
idc_c
Exclude initial direct cost from yield (Y/N)
CHAR(1) yes
bad_debt_c
Bad debt included in initial direct cost (Y/N)
CHAR(1) yes
sh_pyof_c
Short payoffs accepted (Y/N)
CHAR(1) yes
ck_lse_d_c
Lease date after other dates (Y/N)
CHAR(1) yes
dlnq_back_c
Backdated new leases appear on delinquency report (Y/N)
CHAR(1) yes
delq_inv_c
Warning message for payment for non-delinquent invoice (Y/N)
CHAR(1) yes
auto_opt_c
Track automobile options (Y/N)
CHAR(1) yes
cyc_acc_s
Cycle accruals (Y/N)
VARCHAR2(31) yes
cyc_bil_s
Billing cycle (Y/N)
VARCHAR2(31) yes
ofc_c
Activate approval officer security (Y/N)
CHAR(1) yes
latch_60_c
Assess late charges to leases less than 60 days old (Y/N)
CHAR(1) yes
calc_idc_c
Calculate IDC w/o broker fees or bad debt (Y/N)
CHAR(1) yes
stub_int_c
Use stub interest (Y/N)
CHAR(1) yes
insf1_c
Special insurance follow up (Y/N)
CHAR(1) yes
dlnq1_c
Special delinquency (Y/N)
CHAR(1) yes
cl_rec_c
Client receives advance money (R/I/A)
CHAR(1) yes
udf_app_c
User defined lease application fields used (Y/N)
CHAR(1) yes
udf_lse_c
User defined lease fields used (Y/N)
CHAR(1) yes
udf_ass_c
User defined asset fields used (Y/N)
CHAR(1) yes
udf_cus_c
User defined customer fields used (Y/N)
CHAR(1) yes
udf_les_c
User defined lessee fields used (Y/N)
CHAR(1) yes
udf_dlr_c
User defined vendor fields used (Y/N)
CHAR(1) yes
udt_app_c
User defined lease application table used (Y/N)
CHAR(1) yes
udt_lse_c
User defined lease table used (Y/N)
CHAR(1) yes
udt_ass_c
User defined asset table used (Y/N)
CHAR(1) yes
udt_cus_c
User defined customer Table used (Y/N)
CHAR(1) yes
udt_les_c
User defined lessee table used (Y/N)
CHAR(1) yes
udt_dlr_c
User defined vendor table used (Y/N)
CHAR(1) yes
eop_s_subtl_c
EOP subtotals (Y/N)
CHAR(1) yes
eop_s_grnd_c
EOP grand totals (Y/N)
CHAR(1) yes
eop_s_por_grnd_c
EOP portfolio on grand total (Y/N)
CHAR(1) yes
eop_s_com_grnd_c
EOP company on grand total (Y/N)
CHAR(1) yes
eop_s_reg_grnd_c
EOP region on grand total (Y/N)
CHAR(1) yes
eop_s_off_grnd_c
EOP office on grand total (Y/N)
CHAR(1) yes
eop_s_cus_grnd_c
EOP customer on grand total (Y/N)
CHAR(1) yes
eop_s_les_grnd_c
EOP lessee on grand total (Y/N)
CHAR(1) yes
eop_s_por_sub_c
EOP portfolio on subtotal (Y/N)
CHAR(1) yes
eop_s_com_sub_c
EOP company on subtotal (Y/N)
CHAR(1) yes
eop_s_reg_sub_c
EOP region on subtotal (Y/N)
CHAR(1) yes
eop_s_off_sub_c
EOP office on subtotal (Y/N)
CHAR(1) yes
eop_s_cus_sub_c
EOP customer on subtotal (Y/N)
CHAR(1) yes
eop_s_les_sub_c
EOP lessee on subtotal (Y/N)
CHAR(1) yes
s_por_gbrk_c
Portfolio page on grand total (Y/N)
CHAR(1) yes
s_com_gbrk_c
Company page on grand total (Y/N)
CHAR(1) yes
s_reg_gbrk_c
Region page on grand total (Y/N)
CHAR(1) yes
s_cus_gbrk_c
Customer page on grand total (Y/N)
CHAR(1) yes
s_indent_c
Grand total indentation (Y/N)
CHAR(1) yes
s_heading_c
Print heading above keys (Y/N)
CHAR(1) yes
s_titles_c
Print row titles or names (T/N)
CHAR(1) yes
tx_xfer_c
Transfer payment transaction to historical file (Y/N)
CHAR(1) yes
lst_pmt_inv_c
Print payment amount on invoice (Y/N)
CHAR(1) yes
cus_inv_c
Sort invoices by customer (Y/N)
CHAR(1) yes
nveh_info_c
Track auxiliary non-vehicle information (Y/N)
CHAR(1) yes
veh_info_c
Track auxiliary vehicle information (Y/N)
CHAR(1) yes
res_inc_c
Residual income separated (Y/N)
CHAR(1) yes
calc_ast_yld_c
Calculate asset yield (Y/N)
CHAR(1) yes
reset_c
Reset time outstanding when application status changes (Y/N)
CHAR(1) yes
lse_fac_c
Lease factor - Payment/Rental (P/R)
CHAR(1) yes
tar_prn_c
IBL target principal levels used (Y/N)
CHAR(1) yes
grs_rec_s
Gross receivable balance (Y/N)
VARCHAR2(80) yes
net_out_s
Net outstanding balance (Y/N)
VARCHAR2(80) yes
grs_out_s
Gross outstanding balance (Y/N)
VARCHAR2(80) yes
port_wtch_c
Portfolio status report watch or grace (W/G)
CHAR(1) yes
col_wtch_c
Collection module watch or grace (W/G)
CHAR(1) yes
del_i_wtch_c
Delinquency report interactive watch code or grace (W/G)
CHAR(1) yes
del_e_wtch_c
Delinquency report EOP watch code or grace period (W/G)
CHAR(1) yes
lse_dsct_c
Lease discounting used (Y/N)
CHAR(1) yes
upd_lck_c
Updates locked (Y/N)
CHAR(1) yes
d_inc_c
Vendor participating in income (Y/N)
CHAR(1) yes
ses_c
Session update used (Y/N)
CHAR(1) yes
ses_disb_c
Assign cash disbursements through session (Y/N)
CHAR(1) yes
idc_int_adj_c
IDC interest adjustment switch (Y/N)
CHAR(1) yes
ver_s
Verify field (X/' ')
VARCHAR2(20) yes
eop_s_grp_grnd_c
EOP group on grand total (Y/N)
CHAR(1) yes
eop_s_grp_sub_c
EOP group on subtotal (Y/N)
CHAR(1) yes
ptax_desc_use_c
Use property tax description code (Y/N)
CHAR(1) yes
fhut_desc_use_c
Use FHUT description code (Y/N)
CHAR(1) yes
clone_appl_his_c
Clone application status history (Y/N)
CHAR(1) yes
drawdown_tracking_c
Drawdown history tracking (Y/N)
CHAR(1) yes
appl_first_last_c
First or last occurrence (F/L/' ')
  For cloning application status history through
  first or last occurrence of rpa::clone_to_status_s.
  This field will be initialized to blank if the
  history/client cloning module is not purchased
CHAR(1) yes
cca_c
CCA module used (Y/N)
CHAR(1) yes
cl_s
Portfolio name
VARCHAR2(36) yes
add_s
Portfolio address
VARCHAR2(36) yes
cty_s
Portfolio city
VARCHAR2(25) yes
st_s
Portfolio state
CHAR(2) yes
zip_s
Portfolio zip code
CHAR(9) yes
phn_s
Phone number
CHAR(10) yes
cl_div_s
Division name
VARCHAR2(80) yes
doc_lett_s
Default document letter
CHAR(6) yes
batch_que_s
Batch queue name
VARCHAR2(40) yes
cca_def_ent_s
CCA default tax entity
CHAR(4) yes
invst_req_c
Investor input required for lease discounting (Y/N)
CHAR(1) yes
dsb_upfrnt_tax_c
Disburse Upfront sales tax through [U0449] (Y/N)
CHAR(1) yes
incl_sec_dep_yld_c
Include security deposit in yield (Y/N)
CHAR(1) yes
ach_prenote_used_c
ACH prenotes used (Y/N)
CHAR(1) yes
prenote_ccd_c
Corporate standard entry class code is to be prenoted (Y/N)
CHAR(1) yes
incl_idc_npv_sb_c
Include IDC in NPV and SB payoffs (Y/N)
CHAR(1) yes
take_incm_susp_inv_c
Take income on INV payoff for suspended lease (Y/N)
CHAR(1) yes
net_cost_calc_meth_c
Net cost calculation method (A/C)
CHAR(1) yes
app_str_l
Number of months to wait before deleting booked
  application structures
NUMBER(10) yes
lse_str_l
Number of months to wait before deleting lease structures
NUMBER(10) yes
cln_lse_l
Days before cleaning up lease/asset records
NUMBER(10) yes
last_day_mth_l
Last day of the month
NUMBER(10) yes
grc_l
Grace period in days
NUMBER(10) yes
grc_invoice_l
Invoice deferral days for monthly accrual cycle
NUMBER(10) yes
grc_accrual_l
Accrual deferral days for monthly accrual cycle
NUMBER(10) yes
sus_l
Suspense limit in days
NUMBER(10) yes
delq1_l
Delinquency category boundaries [1]
NUMBER(10) yes
delq2_l
Delinquency category boundaries [2]
NUMBER(10) yes
delq3_l
Delinquency category boundaries [3]
NUMBER(10) yes
b_lsd_l
Maximum days before current date for lease date
NUMBER(10) yes
a_lsd_l
Maximum days after current date for lease date
NUMBER(10) yes
b_dis_l
Maximum days before current date for disbursement date
NUMBER(10) yes
a_dis_l
Maximum days after current date for disbursement date
NUMBER(10) yes
a_com_l
Maximum days after current date for commencement date
NUMBER(10) yes
oc_l
Days after lease date to begin certificate ownership tracking
NUMBER(10) yes
ucc_l
Days after lease date to begin UCC tracking
NUMBER(10) yes
matls_l
Days before maturity to begin Matured Lease tracking
NUMBER(10) yes
h_trm_l
Maximum lease term
NUMBER(10) yes
l_trm_l
Minimum lease term
NUMBER(10) yes
exp_l
Approval expiration days
NUMBER(10) yes
cln_app_l
Months after booking to delete application
NUMBER(10) yes
cln_dcln_l
Months after rejection/withdrawal to move
  application to ROA table
NUMBER(10) yes
cln_dps_l
Months before deleting RPS records
NUMBER(10) yes
cln_doa_l
Months before deleting ROA records
NUMBER(10) yes
lse_ltr_l
Number of days to wait before writing lease letters
NUMBER(10) yes
bad_debt_d
Bad debt percentage
NUMBER(15,5) yes
comm_rate_d
Commission rate
NUMBER(15,5) yes
port_tax_d
Tax rate
NUMBER(15,5) yes
idc_pct_d
Initial direct cost percentage
NUMBER(15,5) yes
h_disc_d
Maximum discount rate
NUMBER(15,5) yes
l_disc_d
Minimum discount rate
NUMBER(15,5) yes
p_max_por_d
Portfolio maximum interest rate
NUMBER(15,5) yes
p_min_por_d
Mininum interest rate
NUMBER(15,5) yes
p_cca_paddon_d
CCA prescribed rate add-on percentage
NUMBER(15,5) yes
grc_d
Grace amount
NUMBER(15,2) yes
tol_d
Tolerance amount
NUMBER(15,2) yes
max_poff_d
Maximum shortage on short payoff
NUMBER(15,2) yes
idc_amt_d
Initial direct cost amount
NUMBER(15,2) yes
h_org_d
Maximum original acquisition cost
NUMBER(15,2) yes
l_org_d
Mininum original acquisition cost
NUMBER(15,2) yes
h_up_d
Maximum documentation fee
NUMBER(15,2) yes
l_up_d
Minimum documentation fee
NUMBER(15,2) yes
l_ext_calc_meth_c
Lease extension calculation method (A/C)
CHAR(1) yes
ins_fee_d
Insurance fee rate
NUMBER(15,5) yes
check_cred_bal_c
Check credit balance on asset add-on (Y/N)
CHAR(1) yes
calc_dd_30_360_c
Calculate days delinquent 30/360 (Y/N)
CHAR(1) yes
allow_taxable_asset_on_ibl_c
Allow taxable asset on IBL (Y/N)
CHAR(1) yes
pay_tax_with_item_c
Pay tax along with item (Y/N)
CHAR(1) yes
upf_vat_c
Upfront value added tax (IVA) (Y/N)
CHAR(1) yes
ern_mth_c
Lease date affects yield (Y/N)
CHAR(1) yes
ignore_assmt_for_prepay_c
Ignore assessments for prepayments (Y/N)
CHAR(1) yes
cred_rpt_note_type_s
Note type used in credit approval report
CHAR(4) yes
rev_bank_s
Reversal bank code
CHAR(3) yes
appl_pay_to_note_c
Apply payment to note attached to lease (Y/N)
CHAR(1) yes
cln_trx_l
Number of months before cleaning up GL transactions
NUMBER(10) yes
def_sec_por_s
Default securitization portfolio
CHAR(2) yes
def_sec_com_s
Default securitization company
CHAR(2) yes
def_sec_reg_s
Default securitization region
CHAR(2) yes
def_sec_off_s
Default securitization office
CHAR(3) yes
ins_exp_l
Number of days before tracking insurance
NUMBER(10) yes
ins_team_s
Insurance team
CHAR(4) yes
ins_supr_s
Insurance supervisor
CHAR(3) yes
aggregator_s
Portfolio aggregator
  Groups or distinguishes portfolios across environments
CHAR(4) yes