Application
|
Retail Merchandizing System
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/SOStatusDesc/v1
|
Version
|
1.1
|
Description
|
This is root element of this document which contains name space definitions for the document elements.
|
|
|
|
XML-Schema Name:SOStatusDesc
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For SOStatusDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
dc_dest_id |
varchar210 |
1 |
1 |
Description is not available. |
tsfhead, alloc_detail |
to_loc, store |
null |
null |
No |
Contains the location number of the stock order receiving location. |
distro_nbr |
varchar210 |
0 |
1 |
Contains the stock order number. This is either the transfer or allocation number in RMS. |
alloc_header, tsfhead |
alloc_no, tsf_no |
null |
null |
No |
Contains the stock order number. This is either the transfer or allocation number in RMS. |
distro_document_type |
varchar21 |
1 |
1 |
Specifies whether the stock order status pertains to an allocation 'A', or transfer 'T'. Types 'D'C Created Stock Order,'C'ustomer Order, and 'V'irtual Distro are also valid document types but will be ignored by the RMS API. |
n/a |
n/a |
null |
null |
Yes |
Specifies whether the stock order status pertains to an Allocation (A) or transfer (T). Types D (DC Created Stock Order,C (Customer Order), and V (Virtual Distro) also are valid document types, but they are ignored by the RMS API. |
SOStatusDtl
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
context_type |
varchar26 |
0 |
1 |
This field holds the functional area code to which the transfer relates to. Valid values are PROM and REPAIR. |
tsfhead |
context_type |
null |
varchar2(6) |
No |
This field holds the functional area code to which the transfer relates to. Valid values are PROM and REPAIR. |
context_value |
varchar225 |
0 |
1 |
This field holds the value relating to the context type like Promotion number. |
tsfhead |
context_value |
null |
varchar2(10) |
No |
This field holds the value relating to the context type like Promotion number. |
ExtOfSOStatusDesc:ExtOfSOStatusDesc
|
*
|
0
|
1
|
Provide an extension hook to customize SOStatusDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfSOStatusDesc:LocOfSOStatusDesc
|
*
|
0
|
1
|
Provide an extension hook to localize SOStatusDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:SOStatusDtl
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms 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 RMS. |
dest_id |
varchar210 |
1 |
1 |
Description is not available. |
tsfhead, alloc_detail |
to_loc, store |
null |
null |
No |
Contains the location number of the stock order receiving location. |
item_id |
varchar225 |
1 |
1 |
Description is not available. |
tsfdetail, alloc_header |
item |
null |
null |
Yes |
Unique identifier for the item. |
order_line_nbr |
number3 |
1 |
1 |
Derived as ROWNUM. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
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. |
alloc_detail, tsfdetail |
qty_allocated, tsf_qty |
null |
null |
Yes |
The quantity of the item pertaining to the stock order status message. |
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 |
|
Yes |
The status of the stock order. Valid values are DS (Details Selected), DU (Details Unselected), NI (Line Cancellation), PP (Distributed), PU (Undistributed), RS (Return To Stock), EX (Expired), SR (Store Reassign), and SC (Store Cancellation). |
user_id |
varchar230 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
updated_date |
xs:dateTime |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
ExtOfSOStatusDesc:ExtOfSOStatusDtl
|
*
|
0
|
1
|
Provide an extension hook to customize SOStatusDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfSOStatusDesc:LocOfSOStatusDtl
|
*
|
0
|
1
|
Provide an extension hook to localize SOStatusDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfSOStatusDtl
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ExtOfSOStatusDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:LocOfSOStatusDtl
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For LocOfSOStatusDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
InSOStatusDesc:InSOStatusDtl
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrSOStatusDesc:BrSOStatusDtl
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfSOStatusDesc
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ExtOfSOStatusDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:LocOfSOStatusDesc
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For LocOfSOStatusDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
InSOStatusDesc:InSOStatusDesc
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrSOStatusDesc:BrSOStatusDesc
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|