rpay Table: Portfolio 2
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rpay Table: Portfolio 2

Parent Table

Name Description
rpa Portfolio

Indexes

Name Segment 1 Segment 2
rpay_idx0 por_s unique_l

     
Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
CHAR(2) no
unique_l
Record number (value is always 1)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
grs_rec1_s
Gross receivable balance (Y/N)
VARCHAR2(90) yes
net_out1_s
Net outstanding balance (Y/N)
VARCHAR2(90) yes
grs_out1_s
Gross outstanding balance (Y/N)
VARCHAR2(90) yes
rev_def_c
Reversed deferment fee to suspense (Y/N)
CHAR(1) yes
extdef_c
Extension/deferment fee required (Y/N)
CHAR(1) yes
def_res_c
Allow deferment residual update (Y/N)
CHAR(1) yes
dlr_rem_bank_s
Dealer remittance bank code
CHAR(3) yes
auto_susp_l
Automatic suspended days
NUMBER(10) yes
auto_unsusp_l
Automatic unsuspended days
NUMBER(10) yes
susp_inc_c
Recognize suspended income at payment (Y/N)
CHAR(1) yes
batch_app_stat_s
Batch application status
CHAR(4) yes
max_mths_add_fin_l
Maximum months that may be added via payment def/ext  FIN
NUMBER(10) yes
max_mths_add_opr_l
Maximum months that may be added via payment def/ext  OPR
NUMBER(10) yes
rev_susp_l
Reversal suspense limit in days
NUMBER(10) yes
payoff_invo_rcr_l
Recurring charge for payoff invoice
NUMBER(10) yes
ins_fin_c
Insurance finance (Y/N)
CHAR(1) yes
ins_pol_fee_d
Insurance policy fee
NUMBER(15,2) yes
idc_idr_in_irr_c
Include IDC and IDR in calculating IRR (Y/N)
CHAR(1) yes
open_comm_in_irr_c
Include open commission in calculating IRR (Y/N)
CHAR(1) yes
chg_acct_bkd_c
Change book accounting and depreciation methods (Y/N)
CHAR(1) yes
prn_write_down_c
Principal write down (Y/N)
CHAR(1) yes
auto_payo_csa_c
Automatic payoff of CSA leases (Y/N)
CHAR(1) yes
susp_bkd_c
Calculate book depreciation on suspended leases (Y/N)
CHAR(1) yes
eom_pre_acc_c
EOM pre-accrual and invoicing (Y/N)
CHAR(1) yes
prorate_inc_idc_depr_c
Prorate income, IDC/IDR and depreciation (Y/N)
CHAR(1) yes
take_incm_susp_prn_c
Take income on PRN payoff for suspended simple interest
  lease (Y/N)
CHAR(1) yes
take_incm_susp_opr_c
Take income on OPR payoff for suspended operating
  lease (Y/N)
CHAR(1) yes
take_incm_susp_inv_o_c
Take income on INV termination for suspended operating
  lease (Y/N)
CHAR(1) yes
use_quote_c
Use third-party payoff quote (Y/N)
CHAR(1) yes
refund_bank_s
Default refund bank
CHAR(3) yes
refund_defr_l
Refund check date deferral
NUMBER(10) yes
unit_pct_calc_c
Asset percentage calculation method
CHAR(1) yes
ver_sum_pmt_c
Verify sum of payments (Y/N)
CHAR(1) yes
olb_rent_base_c
Off lease billing apply rent amount to base payoff (Y/N)
CHAR(1) yes
nsf_assmt_code_s
NSF assessment code
CHAR(4) yes
post_unb_gnls_c
Post unbilled income to gain/loss (Y/N)
CHAR(1) yes
unrec_opr_inc_payo_c
Take unrecognized OPR income at payoff (Y/N)
CHAR(1) yes
note_follow_up_l
Notebook follow-up days
NUMBER(10) yes
doc_path_s
Document directory
VARCHAR2(120) yes
crd_rpt_path_s
Credit report directory
VARCHAR2(120) yes
fasb13_irr_c
FASB 13 IRR for NPV calculation (A/B/C)
  A - use p_con_d
  B - use p_irr_d
  C - use p_irr_nr_d
CHAR(1) yes
calc_pmt_hist_c
Calculate payment history (Y/N)
CHAR(1) yes
cpu_assmt_code_s
Cost per use assessment code
CHAR(4) yes
rcr_ali_s
Recurring charge code for American Lease Insurance
CHAR(4) yes
cc_sec_bank_s
Default bank code for security deposit disbursal
CHAR(3) yes
hold_sec_c
Hold security deposit in payoff/termination (Y/N)
CHAR(1) yes
hold_sec_days_l
Period in days to hold security deposit before disbursal
NUMBER(10) yes
cash_control_used_c
Cash Control used (Y/N)
CHAR(1) yes
lse_cpu_assmt_code_s
Lease level cost per use assessment code
CHAR(4) yes
batch_app_disb_bank_comm_s
Batch application disbursal bank account GL vector
  for COMM type
CHAR(3) yes
rcr_idr6_s
IDR6 offsetting account (OFFSET.IDR code)
CHAR(4) yes
rcr_idrb_s
IDRB offsetting account (OFFSET.IDR code)
CHAR(4) yes
auto_calc_app_interim_rent_c
Automatically calculate interim rent on applications (Y/N)
CHAR(1) yes
ibl_int_after_mat_c
Accrue IBL interest after maturity (Y/N)
CHAR(1) yes
d_last_paynet_export_s
Date of last Paynet export
DATE yes
client_asm_name1_s
Client assessment name 1
VARCHAR2(20) yes
client_asm_name2_s
Client assessment name 2
VARCHAR2(20) yes
client_asm_name3_s
Client assessment name 3
VARCHAR2(20) yes
invo_unit_detl_c
Invoice asset detail (N/P/T)
  N - None
  P - Prorate
  T - Top Down
CHAR(1) yes
unused_fee_assmt_code_s
Unused drawdown fee assessment code
CHAR(4) yes
allow_prepay_on_susp_c
Allow prepayment on 'N***' suspended earnings leases (Y/N)
CHAR(1) yes
allow_prepay_on_mat_c
Allow prepayment on matured leases (Y/N)
CHAR(1) yes
allow_res_ext_on_susp_c
Allow '*RES' accrual extension on 'N***'
  suspended earnings leases (Y/N)
CHAR(1) yes
auto_bpayo_ibl_bpmt_susp_c
Automatic Batch Payoff for IBL Batch Payment Suspense (Y/N)
CHAR(1) yes
s_idrd_s
IDRD alias - 21 characters
VARCHAR2(21) yes
s_idre_s
IDRE alias - 21 characters
VARCHAR2(21) yes
s_idrf_s
IDRF alias - 21 characters
VARCHAR2(21) yes
s_idrg_s
IDRG alias - 21 characters
VARCHAR2(21) yes
s_idrh_s
IDRH alias - 21 characters
VARCHAR2(21) yes
ss_idrd_s
IDRD alias - 9 characters
CHAR(9) yes
ss_idre_s
IDRE alias - 9 characters
CHAR(9) yes
ss_idrf_s
IDRF alias - 9 characters
CHAR(9) yes
ss_idrg_s
IDRG alias - 9 characters
CHAR(9) yes
ss_idrh_s
IDRH alias - 9 characters
CHAR(9) yes
s_idc6_s
IDC6 alias - 21 characters
VARCHAR2(21) yes
ss_idc6_s
IDC6 alias - 9 characters
CHAR(9) yes
dlr_bonus_c
Dealer bonus (Y/N)
CHAR(1) yes
dlr_reserve_c
Allow dealer reserve (Y/N)
CHAR(1) yes
pool_init_c
General ledger pools initialized (Y/N)
CHAR(1) yes
s_idc7_s
IDC7 alias - 21 characters
VARCHAR2(21) yes
ss_idc7_s
IDC7 alias - 9 characters
CHAR(9) yes
cln_dck_l
Months before deleting RCK records
NUMBER(10) 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
pmt_rsc_assmt_code_s
Payment reschedule assessment code (ASM.TYP.L code)
CHAR(4) yes
pxt_assmt_code_s
Payment extension assessment code (ASM.TYP.L code)
CHAR(4) yes
lxt_assmt_code_s
Lease extension assessment code (ASM.TYP.L code)
CHAR(4) yes
due_assmt_code_s
Payment due day change assessment code (ASM.TYP.L code)
CHAR(4) yes
adj_idc_ibl_c
Adjust Unamortized IDC and IDR for IBL (Y/N)
CHAR(1) yes
deficiency_por_c
Deficiency portfolio (Y/N)
CHAR(1) yes
days_mat_full_l
Days before maturity for full term
NUMBER(10) yes
delq_pmt_perc_paid_off_l
Delinquency payment percentage for terminated/paid off leases
NUMBER(10) yes
delq_past_due_c
Use delinquency settings for amount past due (Y/N)
CHAR(1) yes
cmemo_pmt_hier_c
Credit memo uses payment hierarchy (Y/N)
CHAR(1) yes
cmemo_apply_freq_c
Frequency of applying credit memos to payments (D/M/O)
  D - Daily
  M - Monthly
  O - Turn off credit memo processing
CHAR(1) yes
s_idc8_s
IDC8 alias - 21 characters
VARCHAR2(21) yes
s_idc9_s
IDC9 alias - 21 characters
VARCHAR2(21) yes
s_idca_s
IDCA alias - 21 characters
VARCHAR2(21) yes
s_idcb_s
IDCB alias - 21 characters
VARCHAR2(21) yes
s_idcc_s
IDCC alias - 21 characters
VARCHAR2(21) yes
s_idcd_s
IDCD alias - 21 characters
VARCHAR2(21) yes
s_idce_s
IDCE alias - 21 characters
VARCHAR2(21) yes
s_idcf_s
IDCF alias - 21 characters
VARCHAR2(21) yes
s_idcg_s
IDCG alias - 21 characters
VARCHAR2(21) yes
s_idch_s
IDCH alias - 21 characters
VARCHAR2(21) yes
ss_idc8_s
IDC8 alias - 9 characters
CHAR(9) yes
ss_idc9_s
IDC9 alias - 9 characters
CHAR(9) yes
ss_idca_s
IDCA alias - 9 characters
CHAR(9) yes
ss_idcb_s
IDCB alias - 9 characters
CHAR(9) yes
ss_idcc_s
IDCC alias - 9 characters
CHAR(9) yes
ss_idcd_s
IDCD alias - 9 characters
CHAR(9) yes
ss_idce_s
IDCE alias - 9 characters
CHAR(9) yes
ss_idcf_s
IDCF alias - 9 characters
CHAR(9) yes
ss_idcg_s
IDCG alias - 9 characters
CHAR(9) yes
ss_idch_s
IDCH alias - 9 characters
CHAR(9) yes
delq_method_paid_off_c
Delinquency determination method after 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_paid_off_c
CHAR(1) yes
idc_asc842_accting_c
IDC ASC 842 accounting method (I/A/B)
  I - Income
  A - Amortization
  B - Alternative amortization
CHAR(1) yes
idc_book_accting_c
IDC book accounting method (I/A/B)
  I - Income
  A - Amortization
  B - Alternative amortization
CHAR(1) yes
idc_accting_s
IDC1-9, IDCA-H accounting method (I/A/B)
  I - Income
  A - Amortization
  B - Alternative amortization
CHAR(17) yes
idr_accting_s
IDR1-9, IDRA-H accounting method (I/A/B)
  I - Income
  A - Amortization
  B - Alternative amortization
CHAR(17) yes
grc_accrual_wk_l
Accrual deferral days for weekly accrual cycle
NUMBER(10) yes
grc_invoice_wk_l
Invoice deferral days for weekly accrual cycle
NUMBER(10) yes
auto_pay_days_before_l
Number of days before due date to process auto-pay
NUMBER(10) yes
auto_pay_wkend_holid_c
Auto-pay before or after weekends and holidays (A/B)
  A - After
  B - Before
CHAR(1) yes
def_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
  ' ' - No default
CHAR(1) yes
currency_type_s
Currency type (ACH.CURTYP code)
  AUD - Australian dollars
  CAD - Canadian dollars
  USD - US dollars
CHAR(3) yes
grc_accrual_biw_l
Accrual deferral days for bi-weekly accrual cycle
NUMBER(10) yes
grc_invoice_biw_l
Invoice deferral days for bi-weekly accrual cycle
NUMBER(10) yes
grc_accrual_smo_l
Accrual deferral days for semi-monthly accrual cycle
NUMBER(10) yes
grc_invoice_smo_l
Invoice deferral days for semi-monthly accrual cycle
NUMBER(10) yes
prorate_depr_c
Prorate depreciation (Y/N)
CHAR(1) yes
batch_app_disb_bank_idc1_s
Batch application disbursal bank account GL vector
  for IDC1 type
CHAR(3) yes
batch_app_disb_bank_idc2_s
Batch application disbursal bank account GL vector
  for IDC2 type
CHAR(3) yes
batch_app_disb_bank_newa_s
Batch application disbursal bank account GL vector
  for NEWA type
CHAR(3) yes
batch_app_disb_bank_newd_s
Batch application disbursal bank account GL vector
  for NEWD type
CHAR(3) yes
allow_perm_tax_rate_change_c
Allow tax rate changes for PERM use tax code
CHAR(1) yes
copy_lp_chk_to_bank_chk_c
Copy LeasePak check number to bank check number (Y/N)
CHAR(1) yes