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

Database Reference

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