XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrAdjTpHdCriVo 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 |
store_id |
number10 |
1 |
1 |
Include only templates created at this store |
INV_ADJUST_TEMPLATE |
STORE_ID |
NUMBER |
10,0 |
Yes |
Store identifier. |
from_date |
xs:dateTime |
0 |
1 |
Include only templates created at or after this date |
INV_ADJUST_TEMPLATE |
APPROVE_DATE, CREATE_DATE |
Date |
Fill column length. |
Yes |
The date template was created/approved |
to_date |
xs:dateTime |
0 |
1 |
Include only templates created at or before this date |
INV_ADJUST_TEMPLATE |
APPROVE_DATE, CREATE_DATE |
Date |
Fill column length. |
Yes |
The date the template was created/approved |
item_id |
varchar225 |
0 |
1 |
Include only templates containing this sku number |
INV_ADJUST_TEMPLATE_ITEM |
ITEM_ID |
25 |
VARCHAR2 |
Yes |
The item identifier. |
template_id |
number12 |
0 |
1 |
Include only templates with this template identifier |
INV_ADJUST_TEMPLATE |
ID |
NUMBER |
12,0 |
Yes |
Template identifier. |
description |
varchar2250 |
0 |
1 |
Include only templates with descriptions containing this text |
INV_ADJUST_TEMPLATE |
DESCRIPTION |
VARCHAR2 |
250 |
Yes |
Description of the template. |
reason_id |
number12 |
0 |
1 |
Include only templates with at least one line item containing this reason identifier |
INV_ADJUST_TEMPLATE_ITEM |
INV_ADJUST_REASON_ID |
NUMBER |
12,0 |
Yes |
The identifier of the associated inventory adjustment reason code. |
status |
str_adj_status |
1 |
1 |
Include only templates with this status. Valid values are IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN, NO_VALUE. |
INV_ADJUST_TEMPLATE |
STATUS |
NUMBER |
2,0 |
Yes |
Current status of the template 1=In Progress, 2=Complete, 3=Cancelled. |
user_name |
varchar2128 |
0 |
1 |
Include only templates created by this user |
INV_ADJUST_TEMPLATE |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The user that created the template. |