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

XML-Schema Name:VdrDelvCtnDesc 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 VdrDelvCtnDesc 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 Carton identifier. DSD_CARTON ID NUMBER 12 Yes Carton identifier.
store_id number10 1 1 Store identifier. DSD_CARTON STORE_ID NUMBER 10 Yes Store identifier
external_id varchar2128 0 1 Carton external identifier. DSD_CARTON EXTERNAL_ID VARCHAR2 128 No Carton external identifier.
reference_id varchar2128 0 1 Carton reference identifier. DSD_CARTON REFERENCE_ID VARCHAR2 128 No Carton reference identifier.
delivery_id number12 1 1 Delivery identifier. DSD_CARTON DSD_ID NUMBER 12 Yes Delivery identifier.
status dsd_carton_status 1 1 Status of the carton. Valid values are NEW, IN_PROGRESS, SUBMITTED, RECEIVED, DAMAGED, MISSING, NO_VALUE, UNKNOWN. DSD_CARTON STATUS NUMBER 4 Yes carton status. 1 - New, 2 - In Progress, 3 - Submitted, 4 - Received, 5 - Damaged, 6 - Missing, 7 - Canceled
customer_order_related order_related_type 1 1 Carton is related to customer order. Valid values are YES, MIX, NO, NO_VALUE, UNKNOWN. DSD_CARTON CUSTOMER_ORDER_RELATED NUMBER 4 Yes Indicate if carton contains customer order items. 1 - yes, 2 - mix; 3 - no
damaged_reason varchar2128 0 1 Carton damaged reason. DSD_CARTON DAMAGED_REASON VARCHAR2 128 No Carton damaged reason.
serial_code number18 0 1 Carton serial code. DSD_CARTON SERIAL_CODE NUMBER 18 No Carton serial code.
tracking_number varchar2128 0 1 Carton tracking number. DSD_CARTON TRACKING_NUMBER VARCHAR2 128 No Carton tracking number.
create_date xs:dateTime 1 1 The date the carton was created. DSD_CARTON CREATE_DATE DATE Yes The date the carton was created.
create_user varchar2128 1 1 The user that created the carton. DSD_CARTON CREATE_USER VARCHAR2 128 Yes The user that created the carton.
update_date xs:dateTime 1 1 The date the carton was last updated. DSD_CARTON UPDATE_DATE DATE No The date the carton was last updated.
update_user varchar2128 1 1 The user that last updated the carton. DSD_CARTON UPDATE_USER VARCHAR2 128 No The user that last updated the carton.
received_date xs:dateTime 0 1 The date the carton was received. DSD_CARTON RECEIVE_DATE DATE No The date the carton was received.
received_user varchar2128 0 1 The user that received the carton. DSD_CARTON RECEIVE_USER VARCHAR2 128 No The user that received the carton.
adjusted xs:boolean 1 1 Indicates the carton is currently being adjusted. DSD_CARTON ADJUSTED VARCHAR2 1 Yes Indicates the carton is currently being adjusted
external_created xs:boolean 1 1 Indicates if carton was externally created. DSD_CARTON EXTERNAL_CREATE VARCHAR2 1 Yes Indicates if carton was externally created.
quality_control xs:boolean 1 1 Indicates quality control is still required for the carton. DSD_CARTON QUALITY_CONTROL VARCHAR2 1 Yes Indicates quality control is still required for the carton
damage_remaining xs:boolean 1 1 Indicates that all remaining quantities not received should be considered damage 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.
VdrDelvCtnItm * 0 1000 Collection of line items in the container.

XML-Schema Name:VdrDelvCtnItm 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 VdrDelvCtnItm 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 1 1 Vendor delivery detail line internal identifier. DSD_LINE_ITEM ID NUMBER 12 Yes Vendor delivery detail line internal identifier.
item_id varchar225 1 1 Item SKU. DSD_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Item SKU
primary_vpn varchar2256 0 1 The vendor product number DSD_LINE_ITEM VENDOR_PRODUCT_NUMBER VARCHAR2 256 No The vendor product number
case_size number10_2 1 1 Case size for the line item. DSD_LINE_ITEM CASE_SIZE NUMBER 10,2 No Case size for the line item.
unit_cost number12_4 0 1 Amount of the unit cost for the line item. DSD_LINE_ITEM UNIT_COST_VALUE NUMBER 12,4 No Amount of the unit cost for the line item.
unit_cost_override number12_4 0 1 Amount of the unit cost for the line item. DSD_LINE_ITEM OVERRIDE_UNIT_COST_VALUE NUMBER 12,4 No Amount of the unit cost for the line item.
quantity_expected number20_4 0 1 Expected quantity for the line item in units. DSD_LINE_ITEM QUANTITY_EXPECTED NUMBER 20,4 Yes Fill this description.
quantity_remaining number20_4 0 1 Remaining quantity for the line item in units. No Calculated difference between expected and total received for an item on the associated purchase order.
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.
quantity_received_overage number20_4 0 1 Overage received quantity for the line item in units. DSD_LINE_ITEM QUANTITY_RECEIVED_OVER NUMBER 20,4 No Overage received quantity for the line item in units.
quantity_damaged_overage number20_4 0 1 Ovarage damaged quantity for the line item in units. DSD_LINE_ITEM QUANTITY_DAMAGED_OVER NUMBER 20,4 No Ovarage damaged quantity for the line item in units.
purchase_order_id number12 0 1 Purchase order identifier. DSD_LINE_ITEM PURCHASE_ORDER_ID NUMBER 12 No Purchase order identifier.
purchase_order_ext_id varchar2128 0 1 Purchase order external identifier DSD_LINE_ITEM PURCHASE_ORDER_EXT_ID VARCHAR2 128 No Purchase order external identifier
customer_order_id varchar2128 0 1 Customer order identifier. DSD_LINE_ITEM CUST_ORDER_ID VARCHAR2 128 No Customer order identifier.
fulfillment_order_id varchar2128 0 1 Fulfillment order identifier. DSD_LINE_ITEM FUL_ORD_EXTERNAL_ID VARCHAR2 128 No Fulfillment order identifier.
preferred_uom varchar24 0 1 Preferred unit of measure of the line item. PURCHASE_ORDER_LINE_ITEM PREFERRED_UOM VARCHAR2 4 No Preferred unit of measure of the line item.
VdrDelvCtnItmUin * 0 1000 Collection of item uins.
StrInvExtAttDesc:StrInvExtAttDesc * 0 5000 Collection of extended attributes for the line item. NA NA NA NA NA NA

XML-Schema Name:VdrDelvCtnItmUin 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 VdrDelvCtnItmUin 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
shipped xs:boolean 1 1 Indicates if the item uin is shipped. DSD_LINE_ITEM_UIN SHIPPED VARCHAR2 1 Yes Indicates if the item uin is shipped.
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 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.