storage_ent_transfer
- Last UpdatedNov 20, 2024
- 2 minute read
If the system parameter Log storage entity changes is set to Yes, the storage_ent_transfer table captures changes in the location or status of storage entities, as well as changes in its spare field values.
The comments field can be used as an optional explanation field relating to this change.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
ent_id |
int32 |
N |
N |
ID of the storage entity |
|
to_storage_ent_id |
int32 |
N |
Y |
Current location of this storage entity if moved |
|
to_status |
int32 |
N |
Y |
Current status of this storage entity if changed |
|
to_spare1 |
string1000 |
N |
Y |
Current value of first spare field if changed |
|
to_spare2 |
string1000 |
N |
Y |
Current value of second spare field if changed |
|
to_spare3 |
string1000 |
N |
Y |
Current value of third spare field if changed |
|
to_spare4 |
string1000 |
N |
Y |
Current value of fourth spare field if changed |
|
to_spare_int1 |
int32 |
N |
Y |
Current value of first spare integer field if changed |
|
to_spare_int2 |
int32 |
N |
Y |
Current value of second spare integer field if changed |
|
to_spare_int3 |
int32 |
N |
Y |
Current value of third spare integer field if changed |
|
to_spare_int4 |
int32 |
N |
Y |
Current value of fourth spare integer field if changed |
|
from_storage_ent_id |
int32 |
N |
Y |
Previous location of this storage entity if moved |
|
from_status |
string40 |
N |
Y |
Previous status of this storage entity if changed |
|
from_spare1 |
string1000 |
N |
Y |
Previous value of first spare field if changed |
|
from_spare2 |
string1000 |
N |
Y |
Previous value of second spare field if changed |
|
from_spare3 |
string1000 |
N |
Y |
Previous value of third spare field if changed |
|
from_spare4 |
string1000 |
N |
Y |
Previous value of fourth spare field if changed |
|
from_spare_int1 |
int32 |
N |
Y |
Previous value of first spare integer field if changed |
|
from_spare_int2 |
int32 |
N |
Y |
Previous value of second spare integer field if changed |
|
from_spare_int3 |
int32 |
N |
Y |
Previous value of third spare integer field if changed |
|
from_spare_int4 |
int32 |
N |
Y |
Previous value of fourth spare integer field if changed |
|
comments |
string254 |
N |
Y |
Optional explanation field for this storage exec transfer |
|
transfer_by |
string40 |
N |
Y |
ID of user who made the transfer |
|
transfer_time_utc |
tdatetime |
N |
N |
When transfer occurred in UTC |
|
transfer_time_local |
tdatetime |
N |
N |
When transfer occurred in local time |
|
trans_id |
ID 1 |
Y |
N |
Unique ID for each transfer (sequence/identity) |
FK from ent_id to storage_exec. (Cascade delete)
FK from to_storage_ent_id and from_storage_ent_id to ent. (Cascade delete implemented by SP)