XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrAdjHdrCriVo 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 adjustments created at this store |
INV_ADJUST |
STORE_ID |
NUMBER |
10,0 |
Yes |
Store identifier. |
from_date |
xs:dateTime |
0 |
1 |
Include only adjustments created at or after this date |
INV_ADJUST |
CREATE_DATE, APPROVE_DATE |
Date |
|
Yes |
The date the adjustment was created/approved |
to_date |
xs:dateTime |
0 |
1 |
Include only adjustments created at or before this date |
INV_ADJUST |
CREATE_DATE, APPROVE_DATE |
DATE |
|
Yes |
The date the adjustment was created/approved |
item_id |
varchar225 |
0 |
1 |
Include only adjustments containing this sku number |
INV_ADJUST_LINE_ITEM |
INV_ADJUST_LINE_ITEM |
VARCHAR2 |
25 |
Yes |
The item identifier. |
adjustment_id |
number12 |
0 |
1 |
Include only adjustments with this adjustment identifier |
INV_ADJUST |
ID |
NUMBER |
12,0 |
Yes |
Adjustment identifier. |
reason_id |
number12 |
0 |
1 |
Include only adjustments in which at least one line item contains this adjustment reason identifier |
INV_ADJUST_LINE_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 adjustments with this status. Valid values are IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN, NO_VALUE. |
INV_ADJUST |
STATUS |
NUMBER |
2,0 |
Yes |
Indicates the current status of the adjustment. Possible values
1- In Progress, 2- Completed, 3- Canceled |
user_name |
varchar2128 |
0 |
1 |
Include only adjustments created by this user |
INV_ADJUST |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The user that created the adjustment. |
nonsellable_type_id |
number12 |
0 |
1 |
Include only adjustments that contain this non-sellable quantity type (sub-bucket) identifier. |
INV_ADJUST_REASON |
TO_NONSELLABLE_TYPE_ID |
NUMBER |
12,0 |
Yes |
To Unavailable Sub-Bucket |
template_id |
number12 |
0 |
1 |
Include only adjustments that were created from the indicated template |
INV_ADJUST |
INV_ADJUST_TEMPLATE_ID |
NUMBER |
12,0 |
No |
Template used to create the adjustment. |
search_limit |
number3 |
1 |
1 |
Maximum number of records to return |
|
|
|
|
Yes |
Maximum number of records to return |