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.
|
|
|
|
|
|
|