rpc Table: Principal Change
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rpc Table: Principal Change

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4
rpc_idx0 lse_s d_eff_s d_run_s t_run_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
CHAR(10) no
d_eff_s
Effective date
DATE no
d_run_s
Run date
DATE no
t_run_s
Run time
CHAR(6) no
stamp_l
Record modification stamp
NUMBER(10) no
pc_typ_s
Principal change description
CHAR(4) yes
opr_s
Operator initials
CHAR(3) yes
prn_chg_d
Principal change
NUMBER(15,2) yes
p_con_d
Lessor yield
NUMBER(15,7) yes
bank_s
Bank account GL vector
  '  1' - If multiple banks module is purchased
  '   ' - multiple banks module is not purchased
CHAR(3) yes