XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StkCntHdrDesc 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 |
store_id |
number10 |
1 |
1 |
The store where the stock is being counted. |
STOCK_COUNT |
STORE_ID |
NUMBER |
10 |
Yes |
an identifier of the store where the stock count will take place. |
stock_count_id |
number12 |
1 |
1 |
The unique identifier for the stock count. |
STOCK_COUNT |
ID |
NUMBER |
12 |
Yes |
the unique identifier for the stock count. this value is generated by sim. |
count_desc |
varchar2255 |
1 |
1 |
The description for the stock count. |
STOCK_COUNT |
DESCRIPTION |
VARCHAR2 |
255 |
Yes |
the description for the stock count |
group_desc |
varchar2100 |
1 |
1 |
The description of the product group associated to the stock count. |
STOCK_COUNT |
PRODUCT_GROUP_DESCRIPTION |
VARCHAR2 |
100 |
No |
the description from the product group. |
schedule_date |
xs:dateTime |
1 |
1 |
The date the stock count is scheduled for. |
STOCK_COUNT |
SCHEDULE_DATE |
DATE |
|
No |
the date the stock count is scheduled for. |
count_type |
stk_cnt_type |
1 |
1 |
The type of stock count being performed. Valid values are UNIT, UNIT_AMOUNT, PROBLEM_LINE, ADHOC, RMS_SYNC, UNKNOWN. |
STOCK_COUNT |
TYPE |
NUMBER |
2 |
Yes |
"the type of stock count being performed.
1- unit, 2 - unit and amount,
3 - problem line, 4 - Adhoc, 5 - RMS Sync" |
status |
stk_cnt_status |
1 |
1 |
The status of the stock count. Valid values are NEW, COUNT_SCHEDULED, COUNT_IN_PROGRESS, COUNT_COMPLETE, RECOUNT_SCHEDULED, RECOUNT_IN_PROGRESS, RECOUNT_COMPLETE, APPROVAL_SCHEDULED, APPROVAL_IN_PROGRESS, APPROVAL_PROCESSING, APPROVAL_AUTHORIZED, APPROVAL_COMPLETE, CANCELED, UNKNOWN. |
STOCK_COUNT |
STATUS |
NUMBER |
2 |
Yes |
"the status that the stock count is currently in.
0 - New, 1 - Count Scheduled, 2 - Count In progress,
3 - Count Complete, 4 - Recount Scheduled,
5 - Count in progress, 6 - Recount Complete,
7 - Approval Scheduled, 8 - Approval in Progress,
10 - Approval Processing, 12 - Approval Authorized,
14 - Approval Complete, 20 - Canceled" |
display_status |
stk_cnt_display_status |
1 |
1 |
The display status of the stock count. Valid values are NONE, NEW, ACTIVE, IN_PROGRESS, PENDING, PROCESSING, AUTHORIZED, COMPLETED, CANCELED, VIEW_ONLY. |
|
|
|
|
No |
Derived from status. |
left_to_count |
number12 |
1 |
1 |
The total remaining items from all the stock count child(ren). |
STOCK_COUNT_CHILD |
ITEMS_LEFT_TO_COUNT |
NUMBER |
12 |
Yes |
a remaining items to be counted. |
|