Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For SOStatusDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
cust_order_nbr |
varchar210 |
1 |
1 |
Description is not available. |
* |
* |
varchar2 |
* |
* |
* |
dest_id |
varchar210 |
1 |
1 |
Description is not available. |
stock_allocation |
dest_id |
varchar2 |
10 |
* |
* |
item_id |
varchar225 |
1 |
1 |
Description is not available. |
stock_allocation |
item_id |
varchar2 |
25 |
* |
* |
order_line_nbr |
number3 |
1 |
1 |
Derived as ROWNUM. |
stock_allocation_cid |
order_line_nbr |
number |
3 |
No |
Derived as ROWNUM. |
unit_qty |
number12_4 |
1 |
1 |
The difference beween the number of ITEM units shipped versus the receiving count for the given ITEM. This is subtracted from the document-line-item-unit-count to yield an over/under variance between what a supplier said was shipped and what was counted and received at by the store's staff. |
stock_allocation |
requested_unit_qty |
number |
12 |
* |
* |
status |
varchar22 |
1 |
1 |
The status of the stock order. Valid values are: 'DS' - Details Selected, 'DU' - Details Un-Selected, 'NI' - Line Cancellation, 'PP' - Distributed, 'PU' - Un-Distributed, 'RS' - Return To Stock, 'EX' - Expired, 'SR' - Store Reassign, 'SC' - Store Cancellation. |
stock_allocation |
item_status |
varchar2 |
1 |
* |
* |
user_id |
varchar230 |
0 |
1 |
Description is not available. |
* |
* |
varchar2 |
* |
* |
* |
updated_date |
xs:dateTime |
0 |
1 |
Description is not available. |
* |
* |
RIBDate |
* |
* |
* |
ExtOfSOStatusDesc:ExtOfSOStatusDtl
|
*
|
0
|
1
|
Provide an extension hook to customize SOStatusDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|