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/StsTsfApvModVo/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:StsTsfApvModVo 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 StsTsfApvModVo 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
store_id number10 1 1 Identifier of store requesting the operation. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
StsTsfApvItmMod * 0 5000 Collection of transfer request line items.
removed_line_id_col number12 0 5000 Collections of removed line items indicated by their identifiers. n/a n/a RIB or/and RSB n/a Yes Fill this description.
StsTsfApvModNote * 0 1000 Notes associated to the transfer.

XML-Schema Name:StsTsfApvItmMod 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 StsTsfApvItmMod 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. 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 can not be altered on update. TSF_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Sku number
quantity number20_4 1 1 Quantity to be approved. This value is in standard units. TSF_LINE_ITEM QUANTITY_APPROVED NUMBER 20,4 No Approved quantity
case_size number10_2 1 1 Case size associated with the item on this line item. TRANSFER_LINE_ITEM CASE_SIZE number 10,2 No pack size

XML-Schema Name:StsTsfApvModNote 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 StsTsfApvModNote 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.