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

XML-Schema Name:ItmTktBatchDesc 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 ItmTktBatchDesc 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
store_id number10 1 1 Unique identifier of the store. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
external_id varchar2128 0 1 Unique identifier of the event or transaction within the external system. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
transaction_id varchar2128 0 1 Unique identifier of the event or transaction that produced the tickets within SIM. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
printer varchar2128 1 1 If source is internal, the logical name of the printer to use for printing. If source is external, identifying information about the external printer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
printer_source itm_tkt_prt_src 1 1 Either internal or external. Valid values are INTERNAL, EXTERNAL. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
print_date xs:dateTime 1 1 The date the item tickets are scheduled to be printed. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
ticket_type itm_tkt_type 1 1 The type of ticket to be printed for all item tickets within the batch. Valid values are SHELF_LABEL, ITEM_TICKET, AGSN, UNKNOWN. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
ticket_reason itm_tkt_reason 1 1 The reason for creating the item ticket batch request. Valid values are DIRECT_DELIVERY, TICKET_GENERAL, TRANSFER, WAREHOUSE_DELIVERY, PRICE_CLEARANCE, PRICE_CHANGE, PRICE_PROMOTION, PURCHASE_ORDER, UNKNOWN. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
auto_refresh_qty xs:boolean 1 1 True if stock on hand is to be used to determined quantity, false otherwise. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
ItmBatchTkt * 1 999 A collection of item tickets to print.

XML-Schema Name:ItmBatchTkt 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 ItmBatchTkt 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
item_id varchar225 1 1 Sku number Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
quantity number10 1 1 Number of tickets to be printed for this item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
format_id number10 1 1 The print format to associate to the item ticket. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
label_price number12_4 1 1 Price to be printed on the ticket. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
label_currency varchar23 1 1 Retail currency code. A standardized 3 character code defined in ISO-4217. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
external_po_id varchar2128 0 1 Unique identifier of the purchase order that triggered the creation of item tickets. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
promotion_id number10 0 1 Unique identifier of the promotion that triggered the creation of item tickets. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
effective_date xs:dateTime 0 1 The date that the ticket price becomes active. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
multi_units number12_4 0 1 The multi units of the item ticket. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
multi_label_price number12_4 0 1 The multi unit price for the multi unit selling of measure. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
multi_label_currency varchar23 0 1 Multi label currency code. A standardized 3 character code defined in ISO-4217. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
multi_unit_change xs:boolean 0 1 True if the multi unit was changed as part of the request, false otherwise. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
country_manufacture varchar23 0 1 Contains the country of manufacture of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
print_order number10 0 1 The sequence or order in which the tickets should be printed. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
uin_col varchar2128 0 999 Collection of all the unique identifiers/serial numbers associated with the line item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
ItmBatchTktUda * 0 999 Collection of user defined attributes associated with the line item.

XML-Schema Name:ItmBatchTktUda 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 ItmBatchTktUda 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
label varchar2128 1 1 The label of the user defined attribute. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
value varchar2128 1 1 The value of the user defined attribute. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.