|
Application
|
Store Inventory Management
|
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/ItmBasketDesc/v1
|
|
Version
|
1.0
|
|
Description
|
|
|
XSD Structure
|
|
|
|
XML-Schema Name:ItmBasketDesc
|
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 ItmBasketDesc 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 |
Unique identifier |
ITEM_BASKET |
ID |
NUMBER |
12,0 |
Yes |
this column is the primary key for item basket data. |
| 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 |
| reference_id |
number12 |
0 |
1 |
Item basket identifier of the reference item basket. |
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. |
| type_id |
number18 |
1 |
1 |
Item basket type identifier. |
ITEM_BASKET_TYPE |
ID |
NUMBER |
2,0 |
Yes |
this is primary key |
| status |
itm_basket_status |
1 |
1 |
Current status Valid values are IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN. |
NA |
NA |
NA |
NA |
NA |
NA |
| create_date |
xs:dateTime |
1 |
1 |
Item basket create date |
NA |
NA |
NA |
NA |
NA |
NA |
| update_date |
xs:dateTime |
1 |
1 |
Item basket update date |
NA |
NA |
NA |
NA |
NA |
NA |
| create_user |
varchar2128 |
1 |
1 |
Create user |
NA |
NA |
NA |
NA |
NA |
NA |
| update_user |
varchar2128 |
1 |
1 |
Update user |
NA |
NA |
NA |
NA |
NA |
NA |
| expiration_date |
xs:dateTime |
0 |
1 |
Item basket expiration date |
NA |
NA |
NA |
NA |
NA |
NA |
|
ItmBasketNote
|
*
|
0
|
1000
|
Notes associated to the item basket.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
ItmBasketItm
|
*
|
0
|
5000
|
Collection of item basket items.
|
|
|
|
|
|
|
|
StrCustAttDesc:StrCustAttDesc
|
*
|
0
|
50
|
Custom attributes associated to the item basket.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:ItmBasketNote
|
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 ItmBasketNote 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:ItmBasketItm
|
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 ItmBasketItm 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 |
1 |
1 |
Unique line item identifier |
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 uom. If uom is not the item's standard unit of measure, conversion to standard unit of measure will be attempted. |
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:StrCustAttDesc
|
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 StrCustAttDesc 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 |
| label |
varchar230 |
1 |
1 |
Holds the attribute label. |
NA |
NA |
NA |
NA |
NA |
NA |
| value_text |
varchar2250 |
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 |
| admin_id |
number12 |
0 |
1 |
The unique identifier for the attribute admin record. If not present, indicates a display only non-editable value. |
NA |
NA |
NA |
NA |
NA |
NA |
|
|
