rfp Table: Former Lease For Pool Maintenance
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rfp Table: Former Lease For Pool Maintenance

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5
rfp_idx0 por_s com_s reg_s off_s lse_s
rfp_idx1 lse_s por_s com_s reg_s off_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
lse_s
Lease
CHAR(10) no
stamp_l
Record modification stamp
NUMBER(10) no
pool_id_s
Pool ID
CHAR(10) yes
tran_src_c
Transaction source (C/R)
  C - Change key
  R - Remove lease
CHAR(1) 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