XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrAdjTplDesc 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 |
template_id |
number12 |
1 |
1 |
Template identifier |
INV_ADJUST_TEMPLATE |
ID |
NUMBER |
12,0 |
Yes |
Template identifier. |
store_id |
number10 |
1 |
1 |
SIM store identifier |
INV_ADJUST_TEMPLATE |
STORE_ID |
NUMBER |
10,0 |
Yes |
Store Identifier |
description |
varchar2250 |
1 |
1 |
Description of the template. |
INV_ADJUST_TEMPLATE |
DESCRIPTION |
VARCHAR2 |
250 |
Yes |
Description of the template. |
status |
str_adj_status |
1 |
1 |
Status of the template. 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. |
comments |
varchar22000 |
0 |
1 |
Comments about the template |
INV_ADJUST_TEMPLATE |
COMMENTS |
VARCHAR2 |
2000 |
No |
Comments associated with the template. |
create_date |
xs:dateTime |
1 |
1 |
The date the template was created |
INV_ADJUST_TEMPLATE |
CREATE_DATE |
DATE |
|
Yes |
The date the template was created. |
create_user_name |
varchar2128 |
1 |
1 |
The user that created the template |
INV_ADJUST_TEMPLATE |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The user that created the template. |
approve_date |
xs:dateTime |
0 |
1 |
The date the template was approved |
INV_ADJUST_TEMPLATE |
APPROVE_DATE |
DATE |
|
Yes |
The date the template was approved. |
approve_user_name |
varchar2128 |
0 |
1 |
The user that approved the template |
INV_ADJUST_TEMPLATE |
APPROVE_USER |
VARCHAR2 |
128 |
No |
The user that approved the template. |
StrAdjTplItm
|
*
|
0
|
1000
|
Collection of inventory adjustment template line items.
|
|
|
|
|
|
|