| 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 BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
| template_id |
number12 |
1 |
1 |
Template identifier |
|
I |
|
|
No |
Not used by SIM. Future Scoped. |
| store_id |
number10 |
1 |
1 |
SIM store identifier |
|
|
|
|
No |
Not used by SIM. Future Scoped. |
| description |
varchar2250 |
1 |
1 |
Description of the template. |
|
|
|
|
No |
Not used by SIM. Future Scoped. |
| status |
str_adj_status |
1 |
1 |
Status of the template. Valid values are IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN, NO_VALUE. |
|
|
|
|
No |
Not used by SIM. Future Scoped. |
| comments |
varchar22000 |
0 |
1 |
Comments about the template |
|
|
|
|
No |
Not used by SIM. Future Scoped. |
| create_date |
xs:dateTime |
1 |
1 |
The date the template was created |
|
|
|
|
No |
Not used by SIM. Future Scoped. |
| create_user_name |
varchar2128 |
1 |
1 |
The user that created the template |
|
|
|
|
No |
Not used by SIM. Future Scoped. |
| approve_date |
xs:dateTime |
0 |
1 |
The date the template was approved |
|
|
|
|
No |
Not used by SIM. Future Scoped. |
| approve_user_name |
varchar2128 |
0 |
1 |
The user that approved the template |
|
|
|
|
No |
Not used by SIM. Future Scoped. |
|
StrAdjTplItm
|
*
|
0
|
1000
|
Collection of inventory adjustment template line items.
|
|
|
|
|
|
|
