MSI Documentation Suite

LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rzu Table: Maintenance

Description Column Datatype
Audit record type
  A - Asset
  C - Client
  L - Lease
rzu_flg_c char (1)
Client, asset, or lease number clnt_unit_lse_s char (10)
Run date d_run_s date
Run time t_run_s char (6)
Unique portion for key unique_s char (5)
Oracle row stamp stamp_l number (10)
Table update option
  D - Delete
  U - Update
  I - Insert
table_option_c char (1)
Table name table_s char (4)
Field name field_s varchar2 (40)
Old value old_value_s varchar2 (60)
New value new_value_s varchar2 (60)
Username user_name_s char (12)

rzu Indexes:

Index name Piece 1 Piece 2 Piece 3 Piece 4 Piece 5
rzu_idx0 rzu_flg_c clnt_unit_lse_s d_run_s t_run_s unique_s


HomeTableIndexes