XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrAdjRsnDesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
reason_id |
number12 |
1 |
1 |
Unique identifier |
INV_ADJUST_REASON |
ID |
NUMBER |
12,0 |
Yes |
unique identifier of inventory adjustment reason. The first 100 IDs are reserved for reasons required by the system. |
reason_code |
number4 |
1 |
1 |
External reason code. |
INV_ADJUST_REASON |
CODE |
NUMBER |
4,0 |
Yes |
contains a code to uniquely identify the reason for an inventory adjustment. |
description |
varchar2256 |
1 |
1 |
Description of the reason |
INV_ADJUST_REASON |
DESCRIPTION |
VARCHAR2 |
255 |
No |
contains a description of the inventory adjustment reason code. |
disposition_desc |
varchar2256 |
1 |
1 |
Description of the inventory disposition associated to the reason. |
INV_ADJUST_REASON |
DISPOSITION |
NUMBER |
2,0 |
Yes |
the unique identifier of the disposition that is attached to the reason code. this will determine the from and to inventory dispositions as defined on the rk_disposition table. |
to_nonsellable_qty_type_id |
number12 |
0 |
1 |
Identifier of the non-sellable quantity type (or sub-bucket) the non-sellable inventory will move to. |
INV_ADJUST_REASON |
TO_NONSELLABLE_TYPE_ID |
NUMBER |
12,0 |
No |
To Unavailable Sub-Bucket |
from_nonsellable_qty_type_id |
number12 |
0 |
1 |
Identifier of the non-sellable quantity type (or sub-bucket) the non-sellable inventory will move from. |
INV_ADJUST_REASON |
FROM_NONSELLABLE_TYPE_ID |
NUMBER |
12,0 |
No |
From Unavailable Sub-Bucket |