rcm Table: Credit Bureau Extract Client Modification
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rcm Table: Credit Bureau Extract Client Modification

Indexes

Name Segment 1 Segment 2
rcm_idx0 lse_s client_id_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
char(10) no
client_id_s
Client
char(9) no
timestamp
Record modification stamp
timestamp yes
d_run_s
Run date
datetime yes
t_run_s
Run time
char(6) yes
client_typ_c
Client type (L/C/G)
  L - Lessee
  C - Co-lessee
  G - Guarantor
char(1) yes
mod_typ_c
Modification type (A/D/1/2/3/4)
  A - Add: report on both extracts
  D - Delete: report on both extracts
  1 - Add: report on metro2 extract
  2 - Add: report on business extract
  3 - Delete: report on metro2 extract
  4 - Delete: report on business extract
char(1) yes
delete_reason_c
Reason client was removed from lease (T/X/Z)
  T - Termination of association with lease
  X - Deceased
  Z - Association with lease made in error
char(1) yes