XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrAdjDesc 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 |
adjustment_id |
number12 |
1 |
1 |
Unique identifier |
INV_ADJUST |
ID |
NUMBER |
12,0 |
Yes |
Adjustment identifier. |
store_id |
number10 |
1 |
1 |
Store identifier |
INV_ADJUST |
STORE_ID |
NUMBER |
10,0 |
Yes |
Store identifier. |
reference_id |
number12 |
0 |
1 |
Adjustment identifier of original adjustment used to create this adjustment |
INV_ADJUST |
REFERENCE_ID |
NUMBER |
12,0 |
No |
This is the identifier of the inventory adjustment this was copied from. |
template_id |
number12 |
0 |
1 |
Template identifier of template used to create the inventory adjustment |
INV_ADJUST |
INV_ADJUST_TEMPLATE_ID |
NUMBER |
12,0 |
No |
Template used to create the adjustment. |
status |
str_adj_status |
1 |
1 |
Status of the adjustment. 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 |
comments |
varchar22000 |
0 |
1 |
Comments about the adjustment |
INV_ADJUST |
COMMENTS |
VARCHAR2 |
2000 |
No |
Comments associated to the adjustment. |
create_date |
xs:dateTime |
1 |
1 |
Date the adjustment was created |
INV_ADJUST |
CREATE_DATE |
Date |
|
Yes |
The date the adjustment was created. |
create_user_name |
varchar2128 |
1 |
1 |
User that created the adjustment |
INV_ADJUST |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The user that created the adjustment. |
approve_date |
xs:dateTime |
0 |
1 |
Date the adjustment was approved |
INV_ADJUST |
APPROVE_DATE |
Date |
|
No |
The date the adjustment was approved. |
approve_user_name |
varchar2128 |
0 |
1 |
User that approved the adjustment |
INV_ADJUST |
APPROVE_USER |
VARCHAR2 |
128 |
No |
The user that approved the adjustment. |
StrAdjItm
|
*
|
0
|
unbounded
|
Collection of store inventory adjustment line items
|
|
|
|
|
|
|