XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StsTsfShpModVo 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 |
transfer_id |
number12 |
0 |
1 |
Internal transfer identifier. If null, will create a new transfer, otherwise will modify specified transfer. |
TRANSFER |
ID |
NUMBER |
12,0 |
Yes |
unique identifier of the transfer |
sending_store_id |
number10 |
1 |
1 |
Identifier of store sending the items. This value can not be altered on update. |
TRANSFER |
SENDING_STORE_ID |
number |
10,0 |
Yes |
the identifier of the store that will send the items on the transfer. |
receiving_store_id |
number10 |
1 |
1 |
Identifier of store receiving the items. This value can not be altered on update. |
TRANSFER |
RECEIVING_STORE_ID |
number |
10,0 |
Yes |
the identifier of the store that will receive the items on the transfer. |
external_id |
varchar2128 |
0 |
1 |
External identifier to associated to the transfer. This value can not be altered on update. |
TRANSFER |
EXTERNAL_ID |
varchar2 |
128 |
No |
external id. ex external id is from rms |
comments |
varchar22000 |
0 |
1 |
Comments associated to the transfer during the transfer stage. |
TRANSFER |
TRANSFER_COMMENT |
varchar2 |
2000 |
No |
comments associated with the transfer. |
context_type_id |
varchar215 |
0 |
1 |
Identifier of the context type associated to the transfer. |
TRANSFER |
CONTEXT_TYPE_ID |
varchar2 |
15 |
No |
This field hods the functional area code to which the transfer relates to. For example promotions.
e.g
PROM - Promotion |
context_value |
varchar2240 |
0 |
1 |
Value of the context associated to the transfer |
TRANSFER |
CONTEXT_VALUE |
varchar2 |
25 |
No |
This field holds value relating to the context type, e.g promotin number. |
StsTsfBolMod
|
*
|
0
|
1
|
Information about bill of lading for the transfer.
|
|
|
|
|
|
|
StsTsfShpItmMod
|
*
|
0
|
1500
|
Collection of transfer line items containing modified information.
|
|
|
|
|
|
|
removed_line_id_col |
number12 |
0 |
1500 |
Collections of removed line items indicated by their identifier. |
|
|
|
|
Yes |
removed line items |