XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItmBasketModVo 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_basket_id |
number12 |
0 |
1 |
SIM internal identifier. If null, new item basket will be created otherwise existing item basket will be updated. |
ITEM_BASKET |
ID |
VARCHAR2 |
128 |
Yes |
this column contains the customer reference. |
external_id |
varchar2128 |
1 |
1 |
Item basket identifier external to SIM. |
ITEM_BASKET |
EXTERNAL_ID |
varchar2 |
128 |
Yes |
this column contains the customer reference. |
type_id |
number2 |
1 |
1 |
Item basket type identifier |
ITEM_BASKET |
ITEM_BASKET_TYPE_ID |
RIB or/and RSB or/and RSL |
2,0 |
Yes |
The item basket type id defined in ITEM_BASKET_TYPE table |
store_id |
number10 |
1 |
1 |
Store identifier |
ITEM_BASKET |
STORE_ID |
NUMBER |
10,0 |
Yes |
store id of the store to which this item basket belongs. |
ItmBasketModItm
|
*
|
0
|
5000
|
Collection of added or modified item basket line items.
|
|
|
|
|
|
|
removed_line_id_col |
number10 |
0 |
1000 |
Collections of removed items indicated by its unique line identifier. |
ITEM_BASKET_LINE_ITEM |
ID |
NUMBER |
12,0 |
Yes |
this column value is generated from the sequence. |