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

Database Reference Oracle 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
DATE no
t_run_s
Run time
CHAR(6) no
unique_s
Unique portion for key
CHAR(5) no
stamp_l
Record modification stamp
NUMBER(10) no
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
VARCHAR2(40) yes
new_value_s
New value of field
VARCHAR2(60) yes
user_name_s
Username (lowercase)
CHAR(12) yes