rkr Table: Credit Report
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rkr Table: Credit Report

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6
rkr_idx0 client_id_s cb_s cred_prod_s d_reqst_s t_reqst_s  
rkr_idx1 app_s client_id_s cb_s cred_prod_s d_reqst_s t_reqst_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
client_id_s
Client
char(9) no
cb_s
Credit bureau code
char(4) no
cred_prod_s
Credit bureau product code
char(4) no
d_reqst_s
Request date
datetime no
t_reqst_s
Request time
char(6) no
timestamp
Record modification stamp
timestamp yes
client_typ_c
Client type (L/C/G/U)
  L - Lessee
  C - Co-lessee
  G - Guarantor
  U - User-defined client
char(1) yes
app_s
Application
char(10) no
opr_s
Operator initials
char(3) yes
ss_s
SS/Bus ID
char(20) yes
last_name_s
Last name
char(36) yes
first_name_s
First name
char(36) yes
mid_name_s
Middle name
char(36) yes
generation_title_s
Generation or title
char(4) yes
add_type_c
Address type code (S/P/R)
  S - Standard
  P - P.O. Box
  R - Rural Route
char(1) yes
street_num_s
Street/house number, PO Box or Rural Route
char(15) yes
street_name_s
Street name
char(36) yes
street_type_s
Street type code
char(2) yes
street_dir_s
Street direction (N/S/E/W/NW/SW/SE/NE)
char(2) yes
suite_s
Suite
char(6) yes
cty_s
City
char(25) yes
st_s
State code (RST.ST_S code)
char(2) yes
zip_s
Zip code
char(9) yes
rpt_status_c
Report status (?/?)
char(1) yes
crd_scr_s
Credit score
char(4) yes
t_end_s
End time
char(6) yes
rpt_name_s
Report file name
char(36) yes
trn_id_s
Transaction ID
char(10) yes
file_num_s
File number
char(9) yes
seq_num_s
Sequence number
char(3) yes
guid_s
Globally unique identifier
char(32) yes