Retail Integration Mappings Report Release:19.0.000 (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:19.0.000 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 BDI) 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 NUMBER 15 Yes unique identifier of the transfer
store_id number10 1 1 Identifier of store requesting the operation. TSF DESTINATION_ID NUMBER 10 Yes the identifier of the destination that will receive the items on the transfer.
not_after_date xs:dateTime 0 1 Not after date for the transfer. TSF NOT_AFTER_DATE DATE No date after which the transfer is not valid.
context_id number18 0 1 Context type identifier. TSF CONTEXT_ID NUMBER 18 No The context identifier
context_value varchar225 0 1 Context type value. TSF CONTEXT_VALUE VARCHAR2 25 No This field holds value relating to the context type, e.g promotin number.
partial_delivery_allowed xs:boolean 1 1 True if partial delivery is allowed for the transfer. TSF ALLOW_PARTIAL_DELIVERY VARCHAR2 1 No Indicate if partial delivery is allowed
StsTsfReqItmMod * 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 NUMBER 15 Yes unique identifier of the transfer line item
StsTsfReqModNote * 0 1000 Notes associated to the transfer.
StrCustAttModVo:StrCustAttModVo * 0 50 Collection of custom attributes to be updated for the transfer. NA NA NA NA NA NA

XML-Schema Name:StsTsfReqItmMod Version:19.0.000 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 BDI) 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 NUMBER 15 Yes unique identifier of the transfer line item
item_id varchar225 1 1 Sku number of the item. This value can not be altered on update. TSF_LINE_ITEM ITEM_ID VARCHAR2 25 Yes item identifier
quantity number20_4 1 1 Quantity to be requested. This value is in standard units. TSF_LINE_ITEM QUANTITY_REQUESTED NUMBER 20,4 No Requested quantity
case_size number10_2 1 1 Case size associated with the item on this line item. TSF_LINE_ITEM CASE_SIZE NUMBER 10,2 No pack size

XML-Schema Name:StsTsfReqModNote Version:19.0.000 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StsTsfReqModNote in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) 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 VARCHAR2 2000 Yes The note's message.

XML-Schema Name:StrCustAttModVo Version:19.0.000 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrCustAttModVo in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
admin_id number12 0 1 The unique identifier for the admin record defining this attribute. NA NA NA NA NA NA
attribute_name varchar2128 0 1 Contains an identifying name of the attribute. Required if admin_id is not included. NA NA NA NA NA NA
value_text varchar2128 0 1 Holds the string value of the attribute. NA NA NA NA NA NA
value_date xs:dateTime 0 1 Holds the date value of the attribute. NA NA NA NA NA NA
value_decimal number18_4 0 1 Holds the decimal value of the attribute. NA NA NA NA NA NA
value_long number18 0 1 Holds the long value of the attribute. NA NA NA NA NA NA