| 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 | datetime |
| Run time | t_run_s | char (6) |
| Unique portion for key | unique_s | char (5) |
| Sybase timestamp | timestamp | timestamp |
| Table update option
D - Delete U - Update I - Insert |
table_option_c | char (1) |
| Table name | table_s | char (4) |
| Field name | field_s | char (40) |
| Old value | old_value_s | char (60) |
| New value | new_value_s | char (60) |
| Username | user_name_s | char (12) |
| 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 |