This table stores return disposition codes to describe how a received item is disposed.
Column Name | Column Type | Description |
---|---|---|
RTNDSPCODE_ID | INTEGER NOT NULL | Generated unique key. |
RETURNTOINVENTORY | CHAR(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_ID | INTEGER NOT NULL | Store Entity of the owner. |
CODE | CHAR(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. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000219 | CODE+STOREENT_ID | Unique Index |
SQL050212031308060 | RTNDSPCODE_ID | Primary Key |
I0000752 | STOREENT_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_722 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_724 | RTNDSPCODE_ID | RTNDSPDESC | RTNDSPCODE_ID | Cascade |
F_725 | RTNDSPCODE_ID | RTNRCPTDSP | RTNDSPCODE_ID | Cascade |