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

XML-Schema Name:ItmTktFrmColDesc 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 ItmTktFrmColDesc 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
ItmTktFrmDesc:ItmTktFrmDesc * 0 unbounded Collection of item ticket formats. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:ItmTktFrmDesc 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 ItmTktFrmDesc 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
format_id number10 1 1 Unique identifier of the format. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this 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.
format_name varchar2128 1 1 Logical name of the format. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
format_desc varchar2128 0 1 Further description of the format. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
template_url varchar2128 1 1 The URL of the template for printing the format. 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 ticket type associated with the format. 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.