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

Database Reference

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
cb_s
Credit bureau code
cred_prod_s
Credit bureau product code
d_reqst_s
Request date
t_reqst_s
Request time
Record modification stamp
client_typ_c
Client type (L/C/G/U)
  L - Lessee
  C - Co-lessee
  G - Guarantor
  U - User-defined client
app_s
Application
opr_s
Operator initials
ss_s
SS/Bus ID
last_name_s
Last name
first_name_s
First name
mid_name_s
Middle name
generation_title_s
Generation or title
add_type_c
Address type code (S/P/R)
  S - Standard
  P - P.O. Box
  R - Rural Route
street_num_s
Street/house number, PO Box or Rural Route
street_name_s
Street name
street_type_s
Street type code
street_dir_s
Street direction (N/S/E/W/NW/SW/SE/NE)
suite_s
Suite
cty_s
City
st_s
State code (RST.ST_S code)
zip_s
Zip code
rpt_status_c
Report status (?/?)
crd_scr_s
Credit score
t_end_s
End time
rpt_name_s
Report file name
trn_id_s
Transaction ID
file_num_s
File number
seq_num_s
Sequence number
guid_s
Globally unique identifier