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

XML-Schema Name:StsTsfRcvModVo Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StsTsfRcvModVo 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 1 1 Internal transfer identifier TRANSFER ID number 12,0 Yes unique identifier of the transfer
StsTsfRcvItmMod * 1 1500 Collection of transfer line items containing modified receiving information.

XML-Schema Name:StsTsfRcvItmMod Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StsTsfRcvItmMod 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 1 1 Line Item identifier. If left empty, indicates new line item, otherwise will attempt to modify existing line item. TRANSFER_LINE_ITEM ID number 20,4 No received quantity of transfer line item
case_size number10_2 1 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
received_quantity number20_4 0 1 Quantity of transfer received as good. Value is ignored for UIN enabled items. TRANSFER_LINE_ITEM RECEIVED_QUANTITY number 20,4 No received quantity of transfer line item
damaged_quantity number20_4 0 1 Quantity to transfer received as damaged. Value is ignored for UIN enabled items. TRANSFER_LINE_ITEM DAMAGED_QUANTITY number 20,4 No damaged quantity of transfer line item
received_uin_col varchar2128 0 200 Universal Identifier Numbers to be added to the line item and received as good. Yes received serial numbers
damaged_uin_col varchar2128 0 200 Universal Identifier Numbers to be added to the line item and received as damaged. Yes damaged serial numbers
removed_uin_col varchar2128 0 200 Universal Identifier Numbers to be removed from the line item. Yes removed serial numbers
StrInvExtAttDesc:StrInvExtAttDesc * 0 1000 Collection of extended attributes associated to the line item, either added or updated external attributes. NA NA NA NA NA NA
removed_ext_att_col varchar2128 0 1000 Contains barcodes associated to the extended attribute scan to be deleted. All occurrences will be deleted. NA NA NA NA NA NA

XML-Schema Name:StrInvExtAttDesc Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrInvExtAttDesc 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
barcode varchar2128 1 1 Barcode data representation of the associated GS1 international code standards and their values. NA NA NA NA NA NA
quantity number10 1 1 Number of occurrences of the extended attribute scanned on the line item. NA NA NA NA NA NA
StrInvCodVal * 0 10 Collection of code-value pairs that contains the broken out information from within the barcode. NA NA NA NA NA NA