rgc Table: Co-Lessee/Guarantor/User Defined Client Cross-reference
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rgc Table: Co-Lessee/Guarantor/User Defined Client Cross-reference

Indexes

Name Segment 1 Segment 2 Segment 3
rgc_idx0 app_lse_s client_typ_c client_id_s
rgc_idx1 client_id_s app_lse_s client_typ_c

   
Columns
Name DescriptionDatatype ¿? Allow Null
app_lse_s
Lease or application
char(10) no
client_typ_c
Client type (C/G/U)
  C - Co-lessee
  G - Guarantor
  U - User-defined client
char(1) no
client_id_s
Client
char(9) no
timestamp
Record modification stamp
timestamp yes
consumer_info_s
Consumer information indicator (CONSU.INFO code)
  A - Chapter 7 bankruptcy petitioned
  B - Chapter 11 bankruptcy petitioned
  C - Chapter 12 bankruptcy petitioned
  D - Chapter 13 bankruptcy petitioned
  E - Chapter 7 bankruptcy discharged
  F - Chapter 11 bankruptcy discharged
  G - Chapter 12 bankruptcy discharged
  H - Chapter 13 bankruptcy discharged
  I - Chapter 7 bankruptcy dismissed
  J - Chapter 11 bankruptcy dismissed
  K - Chapter 12 bankruptcy dismissed
  L - Chapter 13 bankruptcy dismissed
  M - Chapter 7 bankruptcy withdrawn
  N - Chapter 11 bankruptcy withdrawn
  O - Chapter 12 bankruptcy withdrawn
  P - Chapter 13 bankruptcy withdrawn
  1A - Personal receivership
  2A - Lease assumption
  Q - Removes previously reported bankruptcy CII (A to P)
      or personal receivership CII (1A)
  S - Removes previously reported lease assumption CII (2A)
  ' ' - Blank retains previously reported CII, or no new
        CII applies for this reporting period
char(2) yes
bankruptcy_chap_s
Bankruptcy chapter (BKRPT.CHAP code)
char(4) yes
d_bankruptcy_s
Bankruptcy filing date
datetime yes
bkrpt_plan_confirmed_c
Bankruptcy plan confirmed (Y/N)
char(1) yes