storage_exec

ent_id

int32

Y

N

Identity of entity that can store material

type

string80

N

Y

User defined for sorting, etc. (e.g., WIP)

status

Int32

N

N

Enumeration of the status of the storage entity:

0 = Available (default)

1 = Used

2 = Dirty (if this entity allows a dirty state)

max_capacity

tfloat

N

Y

Maximum capacity; no limit if null or 0

uom_id

int32

N

Y

Unit of measure for max_capacity

tare

tfloat

N

Y

Weight of empty entity

tare_uom_id

int32

N

Y

Unit of measure for tare weight

auto_del_zero_inv

logical

N

N

Delete row in item_inventory table when qty_left <= 0 or not. Default = No.

allow_neg_qty

logical

N

N

Allow qty_left values < 0 or not. Default = No.

scannable_id

string40

N

Y

Database must force this field to be unique if not null. Used to allow a barcode scan to uniquely identify the entity

allow_multiple_items

logical

N

N

Allow different items to be stored within this storage entity? Default = Yes.

allow_multiple_lots

logical

N

N

Allow different lot numbers to be stored within this entity? Default = Yes.

movable

logical

N

N

Is this storage entity movable? Default = No.

storage_ent_id

int32

N

Y

ID.of other storage entity where this storage entity is currently located – used when this storage entity is movable, otherwise null.

allow_dirty_state

logical

N

N

Is the Dirty state (status = 2) available for this storage entity? Default = No.

log_state_transitions

logical

N

N

Are state transitions logged for this entity? Default = No.

indistinguishable_lots

logical

N

N

If Yes, inventory stored here cannot be separated by lot_no (bulk storage) when consumed, shipped, or transferred out,. Default = No.

unlisted

logical

N

N

If Yes, entity does not show up in certain trees or lists of storage entities. Default = No.

spare_int1

int32

N

Y

Use defined by language term 2267

spare_int2

int32

N

Y

Use defined by language term 2268

spare_int3

int32

N

Y

Use defined by language term 2269

spare_int4

int32

N

Y

Use defined by language term 2270

spare1

string1000

N

Y

Use defined by language term 518

spare2

string1000

N

Y

Use defined by language term 519

spare3

string1000

N

Y

Use defined by language term 520

spare4

string1000

N

Y

Use defined by language term 1741

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

Y

Who last changed this record

last_edit_at

tdatetime

N

N

When this record was last changed