Application
|
Store Inventory Management
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/StsTsfModVo/v1
|
Version
|
1.0
|
Description
|
|
XSD Structure
|
|
|
XML-Schema Name:StsTsfModVo
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StsTsfModVo 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 |
tsf_id |
number15 |
1 |
1 |
Transfer Unique internal identifier. |
TSF |
ID |
RIB or/and RSB |
15 |
Yes |
Fill this description. |
store_id |
number10 |
1 |
1 |
Identifier of store requesting the operation. |
TSF |
SOURCE_ID |
RIB or/and RSB |
10 |
Yes |
Fill this description. |
not_after_date |
xs:dateTime |
0 |
1 |
Not after date for the transfer. |
TSF |
NOT_AFTER_DATE |
RIB or/and RSB |
7 |
No |
Fill this description. |
context_type_id |
varchar215 |
0 |
1 |
Context type identifier. |
TSF |
CONTEXT_TYPE_ID |
RIB or/and RSB |
15 |
No |
Fill this description. |
context_value |
varchar225 |
0 |
1 |
Context type value. |
TSF |
CONTEXT_VALUE |
RIB or/and RSB |
25 |
No |
Fill this description. |
partial_delivery_allowed |
xs:boolean |
1 |
1 |
True if partial delivery is allowed for the transfer. |
TSF |
ALLOW_PARTIAL_DELIVERY |
RIB or/and RSB |
1 |
No |
Fill this description. |
StsTsfItmMod
|
*
|
0
|
5000
|
Collection of transfer request line items.
|
|
|
|
|
|
|
removed_line_id_col |
number12 |
0 |
5000 |
Collections of removed line items indicated by their identifiers. |
TSF_LINE_ITEM |
ID |
RIB or/and RSB |
15 |
No |
Collections of removed line item identifier |
StsTsfModNote
|
*
|
0
|
1000
|
Notes associated to the transfer.
|
|
|
|
|
|
|
|
|
XML-Schema Name:StsTsfItmMod
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StsTsfItmMod 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 |
line_id |
number12 |
0 |
1 |
Unique Identifier. If left null, indicates a new line item, otherwise indicates the line item to modify. |
TSF_LINE_ITEM |
ID |
RIB or/and RSB |
15 |
Yes |
Fill this description. |
item_id |
varchar225 |
1 |
1 |
Sku number of the item. This value can not be altered on update. |
TSF_LINE_ITEM |
ITEM_ID |
RIB or/and RSB |
25 |
Yes |
Fill this description. |
quantity |
number20_4 |
1 |
1 |
Quantity to be transfered. This value is in standard units. |
TSF_LINE_ITEM |
QUANTITY_REQUESTED |
RIB or/and RSB |
20,4 |
Yes |
Fill this description. |
case_size |
number10_2 |
1 |
1 |
Case size associated with the item on this line item. |
TSF_LINE_ITEM |
CASE_SIZE |
RIB or/and RSB |
(10,2) |
No |
Fill this description. |
|
|
XML-Schema Name:StsTsfModNote
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StsTsfModNote 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 |
note |
varchar22000 |
1 |
1 |
The contents of the note. |
NOTES |
TEXT |
RIB or/and RSB |
2000 |
No |
Fill this description. |
|
|