rzu Table: Maintenance
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rzu Table: Maintenance

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5
rzu_idx0 rzu_flg_c clnt_unit_lse_s d_run_s t_run_s unique_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
rzu_flg_c
Audit record type (A/C/I/L/P/R/S/T)
  A - Asset
  C - Client
  I - Custom General
  L - Lease
  P - Portfolio
  R - Non-lease address
  S - Security
  T - State
char(1) no
clnt_unit_lse_s
Client, lease, asset, or portfolio number
char(10) no
d_run_s
Run date
datetime no
t_run_s
Run time
char(6) no
unique_s
Unique portion for key
char(5) no
timestamp
Record modification stamp
timestamp yes
table_option_c
Table i/o option
  I - Insert
  U - Update
  D - Delete
char(1) yes
table_s
Table name
char(4) yes
field_s
Field name
char(40) yes
new_value_s
New value of field
char(60) yes
user_name_s
Username (lowercase)
char(12) yes