rqu Table: Collection Queuing
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rqu Table: Collection Queuing

Indexes

Name Segment 1 Segment 2
rqu_idx0 q_type_c queue_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
q_type_c
Queue type
  C - Collection
  R - Recovery
CHAR(1) no
queue_s
Queue number
CHAR(4) no
stamp_l
Record modification stamp
NUMBER(10) no
q_name_s
Queue long name
VARCHAR2(20) yes
team_cd_s
Team code
CHAR(4) yes
lse_digits_low_s
Assignment lease digits low
CHAR(3) yes
lse_digits_high_s
Assignment lease digits high
CHAR(3) yes
low_days_l
Assignment days deinquent low
NUMBER(10) yes
high_days_l
Assignment days delinquent high
NUMBER(10) yes
por_s
Portfolio
CHAR(2) yes
com_s
Company
CHAR(2) yes
supervisor_q_c
Supervisor queue designator
CHAR(1) yes
por_array_s
Portfolio array
VARCHAR2(99) yes
regional_s
Regional code
CHAR(4) yes