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