Application
|
Retail Warehouse Management System
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/POScheduleDesc/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:POScheduleDesc
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for POScheduleDesc in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
schedule_nbr |
number8 |
0 |
1 |
Contains the Inbound Schedule number created in RFM. |
schedule |
schd_nbr |
number |
8 |
Yes |
Contains the Inbound Schedule number created in RFM. |
physical_wh |
varchar210 |
0 |
1 |
Contains the Physical Warehouse number. |
transshipment_setup |
dc _dest_id |
varchar2 |
10 |
Yes |
Contains the Physical Warehouse number |
POSchedule
|
*
|
1
|
unbounded
|
Contains the array of POSchedule records.
|
|
|
|
|
|
|
|
|
XML-Schema Name:POSchedule
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for POSchedule in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
requisition_nbr |
varchar212 |
0 |
1 |
Contains the PO number. |
schedule_detail |
po_nbr |
varchar2 |
12 |
Yes |
Contains the PO number for the schedule |
requisition_type |
varchar21 |
0 |
1 |
The requistion type will always be Purchase Order. |
po |
doc_type |
varchar2 |
1 |
No |
The requisition type will always be Purchase Order.'P' |
POScheduleDtl
|
*
|
0
|
unbounded
|
Contains the array of POSchedule Detail records.
|
|
|
|
|
|
|
|
|
XML-Schema Name:POScheduleDtl
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for POScheduleDtl in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
item_id |
varchar225 |
0 |
1 |
Contains the Item Number. |
schedule_detail |
item_id |
varchar2 |
25 |
Yes |
Contains the Item Number in the PO |
consolidate_qty |
number12_4 |
0 |
1 |
Contains the consolidated quantities of the item in PO. |
schedule_detail |
unit_qty |
number |
12 |
Yes |
Contains the consolidated quantities of the item in PO. |
|
|