Retail Integration Mappings Report Release:16.0.21 (Ticket Printing Service)
Application Ticket Printing Service
Target Name Space http://www.oracle.com/retail/integration/base/bo/ItmTktPrtDesc/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:ItmTktPrtDesc Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItmTktPrtDesc in TPS application.
TPS's Table Name TPS's Column Name Integration API(RIB or/and RSB or/and RSL) TPS's Column Length Is Column Required in TPS's API? TPS's API Description
store_id number10 1 1 Unique identifier of the store. ITEM_TICKET STORE_ID NUMBER 10,0 Yes the unique identifier of the store.
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. ITEM_TICKET PRINTER VARCHAR2 128 No If source is internal, the logical name of the printer to use for printing. If source is external, identifying information about the external printer.
printer_source printer_src_type 1 1 Either internal or external. Valid values are INTERNAL, EXTERNAL. ITEM_TICKET PRINTER_SOURCE VARCHAR2 256 Yes The URI of the printer. Not supported for external printer source
printer_uri varchar2256 0 1 The URI of the printer. Not supported for external printer source. STORE_PRINTER NETWORK_ADDRESS VARCHAR2 300 Yes the network address of the given retail store printer.
printer_route varchar240 0 1 Routing code that contains additional information about what printing solution should be used. Not supported for external printer source. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
format_name varchar2128 1 1 The logical name of the format to print the data in. PRINT_FORMAT NAME VARCHAR2 128 Yes The format name
format_type report_content_type 1 1 The type of document to print. Valid values are PDF, XML. PRINT_FORMAT TYPE VARCHAR2 128 Yes Print format type code (report type code or ticket format code)
locale varchar2128 0 1 The locale selection for the ticket. Example fr-FR Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
copies number2 1 1 Number of copies to print. ITEM_TICKET QUANTITY NUMBER 12,4 Yes the number of tickets to be printed for this item.
ItemTicket * 1 999 A collection of item tickets to print.

XML-Schema Name:ItemTicket Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemTicket in TPS application.
TPS's Table Name TPS's Column Name Integration API(RIB or/and RSB or/and RSL) TPS's Column Length Is Column Required in TPS's API? TPS's API Description
ticket_id number12 1 1 Unique identifier of the ticket. ITEM_TICKET ID NUMBER 12,0 Yes the unique identifier for the table. this is assigned by the system.
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.
item_short_desc varchar2255 0 1 Short description of the item. ITEM SHORT_DESCRIPTION VARCHAR2 255 Yes the textural description of the item and its characteristics.
item_long_desc varchar2400 0 1 Long description of the item. ITEM LONG_DESCRIPTION VARCHAR2 400 Yes long description of the item.
department_id number12 1 1 Unique identifier of the department. ITEM_HIERARCHY DEPARTMENT_ID NUMBER 12,0 Yes hierarchy department id
department_name varchar2360 0 1 Name of the department. ITEM_HIERARCHY DEPARTMENT_NAME VARCHAR2 360 Yes hierarchy department name
class_id number12 0 1 Unique identifier of the class. ITEM_HIERARCHY CLASS_ID NUMBER 12,0 Yes hierarchy class id
class_name varchar2360 0 1 Name of the class. ITEM_HIERARCHY CLASS_NAME VARCHAR2 360 Yes hierarchy class name
subclass_id number12 0 1 Unique identifier of the sub-class. ITEM_HIERARCHY SUBCLASS_ID NUMBER 12,0 No hierarchy subclass id
subclass_name varchar2360 0 1 Name of the sub-class. ITEM_HIERARCHY SUBCLASS_NAME VARCHAR2 360 No hierarchy subclass name
diff_type_one varchar2255 0 1 Description of the first differentiator type (example: Size). Fill application table name. DIFFERENTIATOR_1 RIB or/and RSB Fill column length. Yes Fill this description.
diff_desc_one varchar2255 0 1 Description of the first diferentiator value (example: L). ITEM DIFFERENTIATOR_1 VARCHAR2 10 No the unique identifier that differentiates the current item from its item parent. for an item that is a parent, this field may be either a group (i.e. mens pant sizes) or a value (6 oz). for an item that is not a parent, this field may contain a value (34x34, red, etc.) valid values are found on diff_id table.
diff_type_two varchar2255 0 1 Description of the second differentiator type. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
diff_desc_two varchar2255 0 1 Description of the second diferentiator value. ITEM DIFFERENTIATOR_2 VARCHAR2 10 No this field can be used the same way as diff_1.
diff_type_three varchar2255 0 1 Description of the third differentiator type. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
diff_desc_three varchar2255 0 1 Description of the third diferentiator value. ITEM DIFFERENTIATOR_3 VARCHAR2 10 No this field can be used the same way as diff_1.
diff_type_four varchar2255 0 1 Description of the fourt differentiator type. Fill application table name. DIFFERENTIATOR_4 RIB or/and RSB Fill column length. Yes Fill this description.
diff_desc_four varchar2255 0 1 Description of the fourth diferentiator value. ITEM DIFFERENTIATOR_4 VARCHAR2 10 No this field can be used the same way as diff_1.
template_url varchar2128 1 1 The URL of the template to use for printing. PRINT_FORMAT TEMPLATE_URL VARCHAR2 300 Yes holds the template to which the format is assigned
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.
label_price number12_4 1 1 Price to be printed on the ticket. ITEM_TICKET LABEL_PRICE_VALUE NUMBER 12,4 Yes Price to be printed on the ticket
label_price_type label_price_type 1 1 The label price type. Valid values are REGULAR, PROMOTIONAL, CLEARANCE. ITEM_TICKET LABEL_PRICE_TYPE NUMBER 200- Clearance, 201- Promotional, 202-regular price No The ticket price type. Valid values
label_price_uom varchar24 1 1 Label price unit of measure ITEM_PRICE PRICE_UNIT_OF_MEASURE VARCHAR2 4 Yes The price unit of measure.
label_currency varchar23 1 1 Currency of price. 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.
override_price number12_4 0 1 Manual override price. ITEM_TICKET OVERRIDE_PRICE_VAL NUMBER 12,4 No the price to be printed on the ticket if different from the actual retail price of the item.
override_currency varchar23 0 1 Currency of override price. A standardized 3 character code defined in ISO-4217 ITEM_TICKET OVERRIDE_PRICE_CUR VARCHAR2 3 No the price currency to be printed on the ticket if different from the actual retail price of the item.
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 of the multi unit selling of measure. ITEM_TICKET MULTI_UNIT_LABEL_PRICE_VALUE NUMBER 12,4 No The multi unit price of the multi unit selling of measure.
multi_label_currency varchar23 0 1 Retail currency code. A standardized 3 character code defined in ISO-4217 ITEM_TICKET MULTI_UNIT_LABEL_PRICE_CUR VARCHAR2 3 No this field holds the multi-unit retail in the multi-selling unit of measure.
multi_unit_change xs:boolean 1 1 True if the multi unit was changed as part of the request, false otherwise. ITEM_TICKET MULTI_UNIT_CHANGE NUMBER 1 No indicates if the multi-unit pricing has changed for this items ticket. valid values
effective_date xs:dateTime 0 1 The date that a price change becomes active. Fill application table name. Fill table column name. RIB or/and RSB 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. 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.
country_manufacture varchar23 0 1 Contains the country of manufacture of the item. ITEM_TICKET COUNTRY_MANUFACTURE VARCHAR2 3 Yes Country of Manufacture
msr_price number12_4 0 1 Manufacturer's suggested retail price. ITEM MANU_SUGGESTED_RETAIL_PRICE NUMBER 12,4 No Manufacturer suggested retail price
msr_currency varchar23 0 1 Currency of msr price. A standardized 3 character code defined in ISO-4217 ITEM_TICKET LABEL_PRICE_CUR VARCHAR2 3 No Currency of msr price. A standardized 3 character code defined in ISO-4217
print_order number10 1 1 The sequence or order in which the tickets should be printed. ITEM_TICKET PRINT_ORDER NUMBER 10 No The sequence or order in which the tickets would be printed
uin varchar2128 0 1 Unique identifier/serial number associated with the line item. ITEM_TICKET_UIN UIN VARCHAR2 128 No Unique identifier/serial number associated with the line item
ItemTicketUda * 0 999 Collection of user defined attributes associated with the line item.
ItemTicketQrc * 0 999 Collection of qr codes associated with the line item.

XML-Schema Name:ItemTicketUda Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemTicketUda in TPS application.
TPS's Table Name TPS's Column Name Integration API(RIB or/and RSB or/and RSL) TPS's Column Length Is Column Required in TPS's API? TPS'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_TEXT VARCHAR2 128 No User defined ticket attribute text value

XML-Schema Name:ItemTicketQrc Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemTicketQrc in TPS application.
TPS's Table Name TPS's Column Name Integration API(RIB or/and RSB or/and RSL) TPS's Column Length Is Column Required in TPS's API? TPS's API Description
name varchar2120 1 1 A name associated with the QR code. ITEM_QR_CODE IMAGE_NAME VARCHAR2 120 No Name of the QR code image
url varchar21000 1 1 The URL of the QR code image. ITEM_QR_CODE IMAGE_URL VARCHAR2 1000 No URL to the image location
start_date xs:dateTime 0 1 The date that the QR code becomes active. ITEM_QR_CODE START_DATE DATE DATE No The date that the QR code becomes active.
end_date xs:dateTime 0 1 The date that the QR code becomes inactive. ITEM_QR_CODE END_DATE DATE DATE No The date that the QR code becomes inactive