|
Application
|
Store Inventory Management
|
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/RTVReqRef/v1
|
|
Version
|
1.0
|
|
Description
|
This is root element of this document which contains name space definitions for the document elements.
|
|
XSD Structure
|
|
|
|
XML-Schema Name:RTVReqRef
|
Version:15.0.0
|
Return to Top
|
| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for RTVReqRef 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 |
| rtv_order_no |
number10 |
1 |
1 |
Contains the number that uniquely identifies the return to vendor within the system. |
RTV |
ID |
NUMBER |
12,0 |
Yes |
Contains the number that uniquely identifies the return to vendor within the system. |
|
RTVReqDtlRef
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
|
|
|
XML-Schema Name:RTVReqDtlRef
|
Version:15.0.0
|
Return to Top
|
| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for RTVReqDtlRef 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 |
| seq_no |
number8 |
1 |
1 |
This field will contain a sequence number which makes the record unique when combined with the RTV_ORDER_NO field. |
RTV_LINE_ITEM |
EXTERNAL_ID |
NUMBER |
12,0 |
No |
This field will contain a sequence number which makes the record unique when combined with the RTV_ORDER_NO field. |
| item |
varchar225 |
0 |
1 |
Unique identifier for the item on the RTV. |
RTV_LINE_ITEM |
ITEM_ID |
varchar2 |
25 |
Yes |
Unique identifier for the item on the RTV. |
|
|
