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 RSL) |
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 |
RIB or/and RSB or/and RSL |
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 |
RIB or/and RSB or/and RSL |
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 |
RIB or/and RSB or/and RSL |
NUMBER(12,4) |
Yes |
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 |
RIB or/and RSB or/and RSL |
NUMBER(12,4) |
Yes |
The stock on hand quantity recount snapshot. |
stock_counted |
number12 |
0 |
1 |
The number of stock counted. |
STOCK_COUNT_LINE_ITEM |
COUNTED_QUANTITY |
RIB or/and RSB or/and RSL |
NUMBER(12,4) |
Yes |
The number of stock counted. |
stock_recounted |
number12 |
0 |
1 |
The number of stock recounted. |
STOCK_COUNT_LINE_ITEM |
RECOUNTED_QUANTITY |
RIB or/and RSB or/and RSL |
NUMBER(12,4) |
Yes |
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 |
RIB or/and RSB or/and RSL |
NUMBER(12,4) |
Yes |
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 |
RIB or/and RSB or/and RSL |
NUMBER(12,4) |
Yes |
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 |
RIB or/and RSB or/and RSL |
NUMBER(12,4) |
Yes |
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 |
RIB or/and RSB or/and RSL |
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 |
RIB or/and RSB or/and RSL |
DATE |
Yes |
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 |
RIB or/and RSB or/and RSL |
DATE |
Yes |
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 |
RIB or/and RSB or/and RSL |
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 |
RIB or/and RSB or/and RSL |
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 |
RIB or/and RSB or/and RSL |
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 |
RIB or/and RSB or/and RSL |
VARCHAR2(1) |
Yes |
True indicates the stock counted for this item has met discrepant requirements and is considered a discrepant count. |