Application
|
Retail Fiscal Management
|
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 |
rfm 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 |
rfm 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 |
rfm 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 |
rfm 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 |
rfm 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 |
rfm 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 |
rfm 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 |
rfm 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 |
rfm 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
|
|
|