Retail Integration Mappings Report Release:14.0.0 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/StsTsfReqModVo/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:StsTsfReqModVo Version:14.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StsTsfReqModVo 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 Transfer identifier. If left empty, indicates creating new transfer, otherwise will attempt to modify the transfer indicator by the identifier. 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
external_id varchar2128 0 1 External identifier to associated to the transfer. 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.
comments varchar22000 0 1 Comments associated to the transfer during the request stage. Will overwrite any comments currently associated to the transfer. TRANSFER REQUEST_COMMENT varchar2 2000 No comments associated with the original request.
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.ex 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.
StsTsfReqItmMod * 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 identifiers. Yes removed line items

XML-Schema Name:StsTsfReqItmMod Version:14.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StsTsfReqItmMod 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 Line item identifier. If left empty, indicates new line item, otherwise will attempt to modify existing line item based on the identifier. TRANSFER_LINE_ITEM ID number 12,0 Yes unique identifier of the transfer line item
item_id varchar225 1 1 Sku number of the item. This value cannot be altered for an existing line item. TRANSFER_LINE_ITEM ITEM_ID varchar2 25 Yes reference to item identifier
case_size number10_2 0 1 Case size associated with the item on this line item. The value will be defaulted by the service if a value is not supplied. TRANSFER_LINE_ITEM CASE_SIZE NUMBER 10,2 No pack size
requested_quantity number12_4 1 1 Quantity to request in units. TRANSFER_LINE_ITEM REQUESTED_QUANTITY number 20,4 No requested quantity for transfer line item