rpar Table: Porfolio Charge
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rpar Table: Porfolio Charge

Parent Table

Name Description
rpa Portfolio

Indexes

Name Segment 1 Segment 2
rpar_idx0 por_s unique_l

    
Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
CHAR(2) no
unique_l
Record number (possible values are 1 to 85)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
chrg_type_c
Charge type (I/P/T/E/N)
  I - retained as income
  P - payable to a third party
  T - special form of use tax
  E - escrow
  N - not applicable
CHAR(1) yes
chrg_name_s
Charge name
VARCHAR2(20) yes
chrg_bundle_c
Bundle charge on invoice (Y/N)
CHAR(1) yes
chrg_cd_s
Charge code
CHAR(4) yes
chrg_used_c
Charge used (Y/N)
CHAR(1) yes
chrg_basis_c
Charge cash or accrual basis (C/A)
CHAR(1) yes
chrg_delq_c
Include charge in delinquency calculation (Y/N)
CHAR(1) yes
chrg_priority_c
Priority charge (Y/N)
CHAR(1) yes
chrg_pmt_order_l
Charge payment order
NUMBER(10) yes
chrg_tol_d
Charge tolerance amount
NUMBER(15,2) yes
chrg_apply_cmemo_c
Apply credit memo to charge (Y/N)
CHAR(1) yes
chrg_delq_paid_off_c
Include charge in delinquency calculation after payoff (Y/N)
CHAR(1) yes
chrg_incl_pap_pmt_c
Include charge in PAP-ACH payment amount (Y/N)
CHAR(1) yes