|
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.
|
|
|
|
|
|
XML-Schema Name:POScheduleDesc
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For POScheduleDesc |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
| schedule_nbr |
number8 |
0 |
1 |
Contains the Inbound Schedule number created in RFM. |
|
|
|
|
|
Contains the Inbound Schedule number created in RFM. |
| physical_wh |
varchar210 |
0 |
1 |
Contains the Physical Warehouse number. |
|
|
|
|
|
Contains the Physical Warehouse number |
|
POSchedule
|
*
|
1
|
unbounded
|
Contains the array of POSchedule records.
|
|
|
|
|
|
|
|
ExtOfPOScheduleDesc:ExtOfPOScheduleDesc
|
*
|
0
|
1
|
Provide an extension hook to customize POScheduleDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
LocOfPOScheduleDesc:LocOfPOScheduleDesc
|
*
|
0
|
1
|
Provide an extension hook to localize POScheduleDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:POSchedule
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For POSchedule |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
| requisition_nbr |
varchar210 |
0 |
1 |
Contains the PO number. |
|
|
|
|
|
Contains the PO number. |
| requisition_type |
varchar21 |
0 |
1 |
The requistion type will always be Purchase Order. |
|
|
|
|
|
The requistion type will always be Purchase Order. |
|
POScheduleDtl
|
*
|
0
|
unbounded
|
Contains the array of POSchedule Detail records.
|
|
|
|
|
|
|
|
ExtOfPOScheduleDesc:ExtOfPOSchedule
|
*
|
0
|
1
|
Provide an extension hook to customize POSchedule.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
LocOfPOScheduleDesc:LocOfPOSchedule
|
*
|
0
|
1
|
Provide an extension hook to localize POSchedule.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:POScheduleDtl
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For POScheduleDtl |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
| item_id |
varchar225 |
0 |
1 |
Contains the Item Number. |
|
|
|
|
|
Contains the Item Number. |
| consolidate_qty |
number12_4 |
0 |
1 |
Contains the consolidated quantities of the item in PO. |
|
|
|
|
|
Contains the consolidated quantities of the item in PO. |
|
ExtOfPOScheduleDesc:ExtOfPOScheduleDtl
|
*
|
0
|
1
|
Provide an extension hook to customize POScheduleDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
LocOfPOScheduleDesc:LocOfPOScheduleDtl
|
*
|
0
|
1
|
Provide an extension hook to localize POScheduleDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:ExtOfPOScheduleDtl
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfPOScheduleDtl |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
|
XML-Schema Name:LocOfPOScheduleDtl
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For LocOfPOScheduleDtl |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
InPOScheduleDesc:InPOScheduleDtl
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
BrPOScheduleDesc:BrPOScheduleDtl
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:ExtOfPOSchedule
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfPOSchedule |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
|
XML-Schema Name:LocOfPOSchedule
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For LocOfPOSchedule |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
InPOScheduleDesc:InPOSchedule
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
BrPOScheduleDesc:BrPOSchedule
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:ExtOfPOScheduleDesc
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfPOScheduleDesc |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
|
XML-Schema Name:LocOfPOScheduleDesc
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For LocOfPOScheduleDesc |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
InPOScheduleDesc:InPOScheduleDesc
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
BrPOScheduleDesc:BrPOScheduleDesc
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
