|
Application
|
Store Inventory Management
|
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/PORef/v1
|
|
Version
|
1.0
|
|
Description
|
This is root element of this document which contains name space definitions for the document elements.
|
|
|
|
|
|
XML-Schema Name:PORef
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For PORef |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
| doc_type |
varchar21 |
1 |
1 |
Indicates the type of document this message is for. This field will always have a value of 'P'. |
NA |
NA |
NA |
NA |
NA |
NA |
| order_no |
varchar210 |
1 |
1 |
Description is not available. |
NA |
NA |
NA |
NA |
NA |
NA |
|
PODtlRef
|
*
|
0
|
unbounded
|
Not Yet Available
|
|
|
|
|
|
|
|
ExtOfPORef:ExtOfPORef
|
*
|
0
|
1
|
Provide an extension hook to customize PORef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
LocOfPORef:LocOfPORef
|
*
|
0
|
1
|
Provide an extension hook to localize PORef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:PODtlRef
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For PODtlRef |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
| item |
varchar225 |
1 |
1 |
Not Yet Available |
RK_ORDER_ITM |
ID_ITM |
VARCHAR2 |
25 |
Yes |
Unique identifier of the item in the order |
| physical_location_type |
varchar21 |
1 |
1 |
Description is not available. |
NA |
NA |
NA |
NA |
NA |
NA |
| physical_location |
number10 |
1 |
1 |
Not Yet Available |
RK_ORDER_ITM |
ID_STR_RT |
NUMBER |
10 |
Yes |
Indicates the store id of the purchase order |
|
ExtOfPORef:ExtOfPODtlRef
|
*
|
0
|
1
|
Provide an extension hook to customize PODtlRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
LocOfPORef:LocOfPODtlRef
|
*
|
0
|
1
|
Provide an extension hook to localize PODtlRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:ExtOfPODtlRef
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfPODtlRef |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
|
XML-Schema Name:LocOfPODtlRef
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For LocOfPODtlRef |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
InPORef:InPODtlRef
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
BrPORef:BrPODtlRef
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:ExtOfPORef
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfPORef |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
|
XML-Schema Name:LocOfPORef
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For LocOfPORef |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
InPORef:InPORef
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
BrPORef:BrPORef
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
