Retail Integration Mappings Report Release:16.0.21 (Store Inventory Management)
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.