rgp Table: General Ledger Pool
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rgp Table: General Ledger Pool

Child Tables

Name Description
rgpc General Ledger Pool Account

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5
rgp_idx0 por_s com_s reg_s off_s pool_id_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
CHAR(2) no
com_s
Company
CHAR(2) no
reg_s
Region
CHAR(2) no
off_s
Office
CHAR(3) no
pool_id_s
Pool ID
CHAR(10) no
stamp_l
Record modification stamp
NUMBER(10) no
c_prc_d
Cash processed
NUMBER(15,2) yes
d_glpool_s
Date of last general ledger pool update
DATE yes
t_glpool_s
Time of last general ledger pool update
CHAR(6) yes
d_run_tx_no_lse_s
Run date of most recently processed no-lease rtx record in
  default pool
DATE yes
t_run_tx_no_lse_s
Run time of most recently processed no-lease rtx record in
  default pool
CHAR(6) yes