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

XML-Schema Name:VdrDelvCtnModVo Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for VdrDelvCtnModVo 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
carton_id number12 1 1 Container identifier of the container to update. DSD_CARTON ID NUMBER 12 Yes Carton identifier.
reference_id varchar2128 0 1 Container reference identifier. DSD_CARTON REFERENCE_ID VARCHAR2 128 No Carton reference identifier.
damaged_reason varchar2128 0 1 Container damaged reason. DSD_CARTON DAMAGED_REASON VARCHAR2 128 No Carton damaged reason.
serial_code number18 0 1 Container serial code. DSD_CARTON SERIAL_CODE NUMBER 18 No Carton serial code.
tracking_number varchar2128 0 1 Container tracking number. DSD_CARTON TRACKING_NUMBER VARCHAR2 128 No Carton tracking number.
damage_remaining xs:boolean 1 1 Indicates if all remaining quantities in the container should be marked as damaged on confirmation. DSD_CARTON DAMAGE_REMAINING VARCHAR2 1 Yes Indicates that all remaining quantities not received should be considered damage on confirmation..
receive_shopfloor xs:boolean 1 1 Indicate if inventory should be received on shop floor. DSD_CARTON RECEIVE_AT_SHOP_FLOOR VARCHAR2 1 Yes Indicate if inventory should be received on shop floor.
removed_line_id_col number12 0 1000 Collection of container line item identifiers to remove from the delivery. DSD_LINE_ITEM ID NUMBER 12 No container line item identifiers
VdrDelvCtnItmMod * 0 1000 Collection of line items.
VdrDelvCtnModNote * 0 1000 Notes associated to the vendor delivery.

XML-Schema Name:VdrDelvCtnItmMod Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for VdrDelvCtnItmMod 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 number15 0 1 Vendor delivery detail line internal identifier. If left empty, indicates adding a new delivery item. DSD_LINE_ITEM ID NUMBER 12 Yes Vendor delivery detail line internal identifier.
item_id varchar225 1 1 Item SKU. This value cannot be altered on update. DSD_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Item SKU
purchase_order_id number12 0 1 Purchase order identifier. DSD_LINE_ITEM PURCHASE_ORDER_ID NUMBER 12,0 No Purchase order identifier
case_size number10_2 0 1 Case size for the line item. DSD_LINE_ITEM CASE_SIZE NUMBER 10,2 No Case size for the line item.
unit_cost_override number12_4 0 1 Amount of the unit cost override for the line item. DSD_LINE_ITEM OVERRIDE_UNIT_COST_VALUE NUMBER 12,4 No Amount of the unit cost for the line item.
unit_cost_override_currency varchar23 0 1 Currency code of the unit cost for the line item. DSD_LINE_ITEM OVERRIDE_UNIT_COST_CURRENCY VARCHAR2 3 No The override unit cost currency.
quantity_received number20_4 0 1 Received quantity for the line item in units. DSD_LINE_ITEM QUANTITY_RECEIVED NUMBER 20,4 No Received quantity for the line item in units.
quantity_damaged number20_4 0 1 Damaged quantity for the line item in units. DSD_LINE_ITEM QUANTITY_DAMAGED NUMBER 20,4 No Damaged quantity for the line item in units.
removed_uin_col varchar2128 0 1000 Collection of unique identifier numbers to remove from the line item. ITEM_UIN UIN ITEM_UIN 128 Yes UIN to be removed from the delivery.
VdrDvCtnItmUinMod * 0 1000 Collection of unique identifier numbers to add or update for the line item.
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. DSD_LINE_ITEM_ATT BARCODE VARCHAR2 128 Yes Extended attribute barcode.

XML-Schema Name:VdrDvCtnItmUinMod Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for VdrDvCtnItmUinMod 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
uin varchar2128 1 1 Unique identifier number. ITEM_UIN UIN VARCHAR2 128 Yes Item UIN number
received xs:boolean 1 1 Indicates if the item uin is received. DSD_LINE_ITEM_UIN RECEIVED VARCHAR2 1 Yes Indicates if the item uin is received.
damaged xs:boolean 1 1 Indicates if the item uin is also damaged. DSD_LINE_ITEM_UIN DAMAGED VARCHAR2 1 No Indicates if the item uin is damaged.

XML-Schema Name:StrInvExtAttDesc Version:16.0.030 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 BDI) 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. TSF_SHIP_LINE_ITEM_ATT,TSF_DELV_LINE_ITEM_ATT,STOCK_COUNT_LINE_ITEM_ATT,RTV_SHIP_LINE_ITEM_ATT,INV_ADJUST_LINE_ITEM_ATT,FUL_ORD_DLV_LINE_ITEM_ATT,DSD_LINE_ITEM_ATT BARCODE VARCHAR2 128 Yes Extended attribute barcode.
quantity number10 1 1 Number of occurrences of the extended attribute scanned on the line item. TSF_SHIP_LINE_ITEM_ATT,TSF_DELV_LINE_ITEM_ATT,STOCK_COUNT_LINE_ITEM_ATT,RTV_SHIP_LINE_ITEM_ATT,INV_ADJUST_LINE_ITEM_ATT,FUL_ORD_DLV_LINE_ITEM_ATT,DSD_LINE_ITEM_ATT QUANTITY NUMBER 12 Yes Extended attribute quantity.
StrInvCodVal * 0 10 Collection of code-value pairs that contains the broken out information from within the barcode.

XML-Schema Name:VdrDelvCtnModNote Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for VdrDelvCtnModNote 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 Note associated to the vendor delivery. NOTES TEXT RIB or/and RSB 3000 No Note associated to the vendor delivery