Retail Integration Mappings Report Release:15.0.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:15.0.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. TICKET_REQUEST STORE_ID NUMBER 10,0 Yes the unique identifier of the store.
external_id varchar2128 0 1 Unique identifier of the event or transaction within the external system. TICKET_REQUEST EXTERNAL_ID VARCHAR2 128 No the unique identifier for the external id associated with the request
transaction_id varchar2128 0 1 Unique identifier of the event or transaction that produced the tickets within SIM. TICKET_REQUEST TRANSACTION_ID VARCHAR2 128 No the unique identifier for the transaction associated with the request
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. TICKET_REQUEST PRINTER_NAME VARCHAR2 128 No the printer name for which the ticket request would be sent for printing
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. TICKET_REQUEST SCHEDULED_DATE DATE DATE Yes the date that the ticket request is scheduled to be printed
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. TICKET_REQUEST TICKET_TYPE_CODE VARCHAR2 25 Yes the unique identifier for what type of ticket is to be printed in this request
ticket_reason itm_tkt_reason 1 1 The reason for creating the item ticket batch request. Valid values are TICKET_GENERAL, RECEIVED_DELIVERIES, EXPECTED_DELIVERIES, PRICE_CLEARANCE, PRICE_CHANGE, PRICE_PROMOTION, PURCHASE_ORDER, UNKNOWN. TICKET_REQUEST TICKET_REASON NUMBER 2,0. Yes the unique identifier for the reason selected for creating the ticket request.
auto_refresh_qty xs:boolean 1 1 True if stock on hand is to be used to determined quantity, false otherwise. TICKET_REQUEST AUTO_REFRESH_QTY VARCHAR2 1 No Refreshes the Quantity for each line item to the current available stock on hand quantity before being sent off for print. Valid Values = N - No Y = Yes
ItmBatchTkt * 1 999 A collection of item tickets to print.

XML-Schema Name:ItmBatchTkt Version:15.0.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 ITEM_TICKET ITEM_ID VARCHAR2 25 Yes the unique identifier of the item that the ticket is being printed for.
quantity number10 1 1 Number of tickets to be printed for this item. ITEM_TICKET QUANTITY NUMBER 12,4 No the number of tickets to be printed for this item.
format_id number10 1 1 The print format to associate to the item ticket. ITEM_TICKET TICKET_FORMAT_ID NUMBER 10,0 Yes Item ticket format identifier
label_price number12_4 1 1 Price to be printed on the ticket. ITEM_TICKET LABEL_PRICE_VALUE NUMBER 12,4 Yes the currency value
label_currency varchar23 1 1 Retail currency code. A standardized 3 character code defined in ISO-4217. ITEM_TICKET LABEL_PRICE_CUR VARCHAR2 3 Yes the item price printed on the given item ticket.
external_po_id varchar2128 0 1 Unique identifier of the purchase order that triggered the creation of item tickets. ITEM_TICKET EXTERNAL_PO_ID VARCHAR2 128 No the purchase order that gave rise to the item ticket request. only used for item tickets.
promotion_id number10 0 1 Unique identifier of the promotion that triggered the creation of item tickets. ITEM_TICKET PROMOTION_ID NUMBER 10,0 No the promotion identifier of the price change that gave rise to the item ticket request.
effective_date xs:dateTime 0 1 The date that the ticket price becomes active. ITEM_TICKET EFFECTIVE_DATE DATE DATE No the date that the price change becomes effective.
multi_units number12_4 0 1 The multi units of the item ticket. ITEM_TICKET MULTI_UNITS NUMBER 12,4 No this field contains the multi-units for the ticket.
multi_label_price number12_4 0 1 The multi unit price for the multi unit selling of measure. ITEM_TICKET MULTI_UNIT_LABEL_PRICE_VALUE NUMBER 12,4 No the price value for the multi-unit
multi_label_currency varchar23 0 1 Multi label currency code. A standardized 3 character code defined in ISO-4217. ITEM_TICKET MULTI_UNIT_LABEL_PRICE_CUR VARCHAR2 3 No this field contains the multi-units for the ticket.
multi_unit_change xs:boolean 0 1 True if the multi unit was changed as part of the request, false otherwise. ITEM_TICKET MULTI_UNIT_CHANGE NUMBER 1,0 No indicates if the multi-unit pricing has changed for this items ticket. valid values
country_manufacture varchar23 0 1 Contains the country of manufacture of the item. ITEM_TICKET COUNTRY_MANUFACTURE VARCHAR2 3 No country of manufacture
print_order number10 0 1 The sequence or order in which the tickets should be printed. ITEM_TICKET PRINT_ORDER NUMBER 10,0 No The sequence or order in which the tickets should be printed.
uin_col varchar2128 0 999 Collection of all the unique identifiers/serial numbers associated with the line item. ITEM_TICKET_UIN UIN VARCHAR2 128 No Unique identifier/serial number associated with the line item
ItmBatchTktUda * 0 999 Collection of user defined attributes associated with the line item.

XML-Schema Name:ItmBatchTktUda Version:15.0.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. ITEM_TICKET_UDA LABEL VARCHAR2 128 No User defined ticket attribute label
value varchar2128 1 1 The value of the user defined attribute. ITEM_TICKET_UDA VALUE VARCHAR2 128 No User defined ticket attribute text value