Database Table: RTNDSPCODE

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

Column Name Column Type Column Description
CODE CHARACTER (10)
NOT NULL
Code used to reference the disposition code.
MARKFORDELETE INTEGER
NOT NULL, DEFAULT 0
Indicates if this disposition code has been marked for deletion:
0 = No.
1 = Yes, this disposition code has been marked for deletion.
RETURNTOINVENTORY CHARACTER (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
RTNDSPCODE_ID INTEGER
NOT NULL
Generated unique key.
STOREENT_ID INTEGER
NOT NULL
Store Entity of the owner.
Indexes:
Index Name Indexed Column Names Index Type
I0000219 CODE, STOREENT_ID Unique Index
SQL030416035057650 RTNDSPCODE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_722 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_724 RTNDSPCODE_ID RTNDSPDESC RTNDSPCODE_ID Cascade
F_725 RTNDSPCODE_ID RTNRCPTDSP RTNDSPCODE_ID Cascade