XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOStatusDesc 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 |
wo_id |
varchar215 |
1 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
distro_nbr |
varchar212 |
1 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
distro_doc_type |
varchar21 |
1 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
distro_parent_nbr |
varchar212 |
0 |
1 |
The higher level transfer that this transfer is part of. |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
distro_parent_type |
varchar21 |
0 |
1 |
NA |
|
null |
null |
null |
null |
null |
item |
varchar225 |
0 |
1 |
The item on which the work order has been completed. If an item transformation occurred, this should be the resultant item. |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
wh |
number10 |
1 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
loc_type |
varchar21 |
1 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
location |
number10 |
1 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
seq_no |
number4 |
1 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
wip_code |
varchar29 |
1 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
instructions |
varchar2300 |
1 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
complete_date |
xs:dateTime |
1 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
completed_qty |
number12 |
0 |
1 |
The quantity of the item on which work has been completed. |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
completed_ind |
varchar21 |
1 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
WOStatusInvAdj
|
*
|
0
|
unbounded
|
NA
|
|
|
|
|
|
|