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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000219 | CODE, STOREENT_ID | Unique Index |
SQL030416035057650 | RTNDSPCODE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_722 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
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 |