|
Application
|
Store Inventory Management
|
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/ItmBasketModVo/v1
|
|
Version
|
1.0
|
|
Description
|
|
|
XSD Structure
|
|
|
|
XML-Schema Name:ItmBasketModVo
|
Version:19.0.000
|
Return to Top
|
| 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 BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
| item_basket_id |
number12 |
1 |
1 |
SIM internal identifier. |
ITEM_BASKET |
ID |
VARCHAR2 |
128 |
Yes |
this column contains the customer reference. |
| type_id |
number18 |
0 |
1 |
Item basket type identifier. |
ITEM_BASKET_TYPE |
ID |
NUMBER |
2,0 |
Yes |
The item basket type id defined in ITEM_BASKET_TYPE table |
| description |
varchar2250 |
0 |
1 |
Item basket description. |
NA |
NA |
NA |
NA |
NA |
NA |
| alternate_id |
number12 |
0 |
1 |
Item basket alternate identifier. |
NA |
NA |
NA |
NA |
NA |
NA |
| expiration_date |
xs:dateTime |
0 |
1 |
Item basket expiration date |
NA |
NA |
NA |
NA |
NA |
NA |
| store_id |
number10 |
0 |
1 |
Store identifier |
ITEM_BASKET |
STORE_ID |
NUMBER |
10,0 |
Yes |
store id of the store to which this item basket belongs. |
|
ItmBasketModNote
|
*
|
0
|
100
|
Collection of notes that will be added to the item basket.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
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. |
|
StrCustAttModVo:StrCustAttModVo
|
*
|
0
|
50
|
Collection of custom attributes to be updated for the item basket.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:ItmBasketModNote
|
Version:19.0.000
|
Return to Top
|
| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItmBasketModNote in SIM application. |
| SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
| note |
varchar22000 |
0 |
1 |
Note associated to the item basket. |
NA |
NA |
NA |
NA |
NA |
NA |
|
|
|
XML-Schema Name:ItmBasketModItm
|
Version:19.0.000
|
Return to Top
|
| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItmBasketModItm in SIM application. |
| SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
| line_id |
number12 |
0 |
1 |
Unique line item identifier. If null, new item basket line item will be created otherwise existing item will be updated. |
ITEM_BASKET_LINE_ITEM |
ID |
NUMBER |
12,0 |
Yes |
this column value is generated from the sequence. |
| item_id |
varchar225 |
1 |
1 |
Sku number |
ITEM_BASKET_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
this column contains the item id. |
| quantity |
number12_4 |
1 |
1 |
Quantity in unit of measure. If unit of measure is not the item's standard unit of measure, conversion to standard unit of measure will be attempted. Quantity will be overridden with 1 if uin exists. |
ITEM_BASKET_LINE_ITEM |
QUANTITY |
NUMBER |
12,4 |
Yes |
this column contains the quantity of this item in this item basket. |
| case_size |
number12_4 |
1 |
1 |
Default case size of item |
ITEM_BASKET_LINE_ITEM |
CASE_SIZE |
NUMBER |
12,4 |
No |
pack size of the item. |
|
|
|
XML-Schema Name:StrCustAttModVo
|
Version:19.0.000
|
Return to Top
|
| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrCustAttModVo in SIM application. |
| SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
| admin_id |
number12 |
0 |
1 |
The unique identifier for the admin record defining this attribute. |
NA |
NA |
NA |
NA |
NA |
NA |
| attribute_name |
varchar2128 |
0 |
1 |
Contains an identifying name of the attribute. Required if admin_id is not included. |
NA |
NA |
NA |
NA |
NA |
NA |
| value_text |
varchar2128 |
0 |
1 |
Holds the string value of the attribute. |
NA |
NA |
NA |
NA |
NA |
NA |
| value_date |
xs:dateTime |
0 |
1 |
Holds the date value of the attribute. |
NA |
NA |
NA |
NA |
NA |
NA |
| value_decimal |
number18_4 |
0 |
1 |
Holds the decimal value of the attribute. |
NA |
NA |
NA |
NA |
NA |
NA |
| value_long |
number18 |
0 |
1 |
Holds the long value of the attribute. |
NA |
NA |
NA |
NA |
NA |
NA |
|
|
