XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ForpHdrDesc 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 |
reverse_pick_id |
number12 |
1 |
1 |
Fulfillment order reverse pick identifier. |
FUL_ORD_RV_PICK |
ID |
NUMBER |
12,0 |
Yes |
Unique SIM identifier. |
status |
forp_status |
1 |
1 |
Current status. Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN. |
FUL_ORD_RV_PICK |
STATUS |
NUMBER |
4,0 |
Yes |
The current status of the reverse pick 0 - New, 1 - In Progress, 2 - Completed, 3 - Canceled |
create_user_name |
varchar2128 |
1 |
1 |
User that created this reverse pick. |
FUL_ORD_RV_PICK |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The user that created this reverse pick. |
create_date |
xs:dateTime |
1 |
1 |
Date the reverse pick was created. |
FUL_ORD_RV_PICK |
ID |
NUMBER |
12,0 |
Yes |
Unique SIM identifier. |
|