RTNDSPCODE

This table stores return disposition codes to describe how a received item is disposed.

Column Descriptions:

NameTypeDescription
RTNDSPCODE_IDINTEGER NOT NULLGenerated unique key.
RETURNTOINVENTORYCHAR (1) NOT NULL DEFAULT 'Y'A flag to decide if an item with this disposition code should be returned to inventory or not, as follows: N = do not return to inventory Y = return to inventory
STOREENT_IDINTEGER NOT NULLStore Entity of the owner.
CODECHAR (10) NOT NULLCode used to reference the disposition code.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this disposition code has been marked for deletion: 0 = No. 1 = Yes, this disposition code has been marked for deletion.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>RTNDSPCODE_IDPrimary Key
I0000219CODE+STOREENT_IDUnique Index
I0000752STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_722STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_724RTNDSPCODE_IDRTNDSPDESCRTNDSPCODE_IDCascade
F_725RTNDSPCODE_IDRTNRCPTDSPRTNDSPCODE_IDCascade