| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrShpRsnDesc 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 |
SHIPMENT_REASON |
ID |
NUMBER |
12,0 |
Yes |
unique identifier of the shipment reason |
| reason_code |
varchar26 |
1 |
1 |
Reason code |
SHIPMENT_REASON |
CODE |
VARCHAR2 |
6 |
Yes |
The reason code |
| description |
varchar2120 |
1 |
1 |
Description |
SHIPMENT_REASON |
DESCRIPTION |
VARCHAR2 |
120 |
No |
The shipment reason description |
| location_type |
location_type |
1 |
1 |
Indicates the type of destination this is reason code is valid to ship to. Valid values are STORE, SUPPLIER, WAREHOUSE, FINISHER, CUSTOMER, UNKNOWN. |
SHIPMENT_REASON |
TYPE |
NUMBER |
2,0 |
Yes |
Shipment source type |
| nonsellable_qty_type_id |
number12 |
0 |
1 |
Identifier of the non-sellable quantity type (or sub-bucket) the non-sellable inventory will move from |
SHIPMENT_REASON |
NONSELLABLE_TYPE_ID |
NUMBER |
12,0 |
No |
The Non sellable quanity type identifier |
| use_available |
xs:boolean |
1 |
1 |
If true, use available inventory, otherwise use unavailable inventory. |
SHIPMENT_REASON |
USE_AVAILABLE |
VARCHAR2 |
1 |
Yes |
Indicates if use available inventory |
|
