Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim 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. |
n/a |
n/a |
null |
null |
No |
Not used by SIM |
dest_id |
varchar210 |
1 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
item_id |
varchar225 |
1 |
1 |
Description is not available. |
TR_LTM_ICD_MR |
ID_ITM |
null |
null |
Yes |
An identifier which represents an ITEM. |
order_line_nbr |
number3 |
1 |
1 |
Derived as ROWNUM. |
n/a |
n/a |
null |
null |
No |
Not used by SIM |
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. |
TR_LTM_ICD_MR |
QU_UN_SHP |
null |
null |
No |
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. |
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. |
n/a |
n/a |
null |
null |
Yes |
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. |
user_id |
varchar230 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by SIM |
updated_date |
xs:dateTime |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by SIM |
ExtOfSOStatusDesc:ExtOfSOStatusDtl
|
*
|
0
|
1
|
Provide an extension hook to customize SOStatusDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|