| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StkCntChdLineItm 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_item_id |
number12 |
1 |
1 |
The unique identifier of the line item. |
STOCK_COUNT_LINE_ITEM |
ID |
NUMBER |
(12) |
Yes |
The unique identifier of the line item. |
| item_id |
varchar225 |
1 |
1 |
The sku number of the item being counted. |
STOCK_COUNT_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
(25) |
Yes |
The sku number of the item being counted. |
| count_snapshot |
number12 |
0 |
1 |
The stock on hand quantity count snapshot. |
STOCK_COUNT_LINE_ITEM |
COUNT_SNAPSHOT |
NUMBER |
(12,4) |
No |
The stock on hand quantity count snapshot. |
| recount_snapshot |
number12 |
0 |
1 |
The stock on hand quantity recount snapshot. |
STOCK_COUNT_LINE_ITEM |
RECOUNT_SNAPSHOT |
NUMBER |
(12,4) |
No |
The stock on hand quantity recount snapshot. |
| stock_counted |
number12 |
0 |
1 |
The number of stock counted. |
STOCK_COUNT_LINE_ITEM |
COUNTED_QUANTITY |
NUMBER |
(12,4) |
No |
The number of stock counted. |
| stock_recounted |
number12 |
0 |
1 |
The number of stock recounted. |
STOCK_COUNT_LINE_ITEM |
RECOUNTED_QUANTITY |
NUMBER |
(12,4) |
No |
The number of stock recounted. |
| stock_counted_total |
number12 |
0 |
1 |
The number of stock counted across all stock count children for the item. |
STOCK_COUNT_LINE_ITEM |
COUNTED_TOTAL |
NUMBER |
(12,4) |
No |
The number of stock counted across all stock count children for the item. |
| stock_recounted_total |
number12 |
0 |
1 |
The number of stock recounted across all stock count children for the item. |
STOCK_COUNT_LINE_ITEM |
RECOUNTED_TOTAL |
NUMBER |
(12,4) |
No |
The number of stock recounted across all stock count children for the item. |
| stock_approved |
number12 |
0 |
1 |
The number of stock approved across all stock count children for the item. |
STOCK_COUNT_LINE_ITEM |
APPROVED_QUANTITY |
NUMBER |
(12,4) |
No |
The number of stock approved across all stock count children for the item. |
| count_timestamp |
xs:dateTime |
0 |
1 |
The date of the first count for the item. |
STOCK_COUNT_LINE_ITEM |
COUNT_DATE_TIME |
DATE |
|
Yes |
The date of the first count for the item. |
| recount_timestamp |
xs:dateTime |
0 |
1 |
The date of the first re-count for the item. |
STOCK_COUNT_LINE_ITEM |
RECOUNT_DATE_TIME |
DATE |
|
No |
The date of the first re-count for the item. |
| approved_timestamp |
xs:dateTime |
0 |
1 |
The date of a last manual entry of an approval quantity. |
STOCK_COUNT_LINE_ITEM |
APPROVED_DATE_TIME |
DATE |
|
No |
The date of a last manual entry of an approval quantity. |
|
StkCntUinNum
|
*
|
0
|
1000
|
Collection of serial numbers associated with this line item
|
|
|
|
|
|
|
|
StrInvExtAttDesc:StrInvExtAttDesc
|
*
|
0
|
1000
|
Collection of extended attributes associated with the line item.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
| primary_location |
xs:boolean |
1 |
1 |
True indicates this is the primary instance of the item on the stock count. |
STOCK_COUNT_LINE_ITEM |
PRIMARY_LOCATION |
VARCHAR2 |
(1) |
Yes |
True indicates this is the primary instance of the item on the stock count. |
| breakable_component |
xs:boolean |
1 |
1 |
True indicates the item is a component of a breakable pack which requires adding pack counts to the line item before processing. |
STOCK_COUNT_LINE_ITEM |
BREAKABLE_COMPONENT |
VARCHAR2 |
(1) |
Yes |
True indicates the item is a component of a breakable pack which requires adding pack counts to the line item before processing. |
| multi_located |
xs:boolean |
1 |
1 |
True indicates the item exists multiple times within a stock. The item must have a primary location. |
STOCK_COUNT_LINE_ITEM |
MULTI_LOCATED |
VARCHAR2 |
(1) |
Yes |
True indicates the item exists multiple times within a stock. The item must have a primary location. |
| discrepant |
xs:boolean |
1 |
1 |
True indicates the stock counted for this item has met discrepant requirements and is considered a discrepant count. |
STOCK_COUNT_LINE_ITEM |
DISCREPANT |
VARCHAR2 |
(1) |
Yes |
True indicates the stock counted for this item has met discrepant requirements and is considered a discrepant count. |
