Application
|
Retail Warehouse Management System
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/CustRetDesc/v1
|
Version
|
1.0
|
Description
|
This is root element of this document which contains name space definitions for the document elements.
|
|
|
|
XML-Schema Name:CustRetDesc
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For CustRetDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
from_location |
number10 |
1 |
1 |
Description is not available. |
transshipment_setup |
dc_dest_id |
varchar2 |
10 |
Yes |
* |
rma_nbr |
varchar220 |
1 |
1 |
Description is not available. |
returns_upload |
rma_nbr |
varchar2 |
20 |
Yes |
* |
pro_nbr |
varchar218 |
1 |
1 |
Description is not available. |
returns_upload |
pro_nbr |
varchar2 |
18 |
Yes |
* |
comments |
varchar2250 |
0 |
1 |
Description is not available. |
returns_upload |
comments |
varchar2 |
300 |
Yes |
* |
CustRetItem
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
return_date |
xs:dateTime |
0 |
1 |
Description is not available. |
* |
* |
RIBDate |
* |
* |
* |
ExtOfCustRetDesc:ExtOfCustRetDesc
|
*
|
0
|
1
|
Provide an extension hook to customize CustRetDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:CustRetItem
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For CustRetItem |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
item_id |
varchar225 |
1 |
1 |
Description is not available. |
returns_upload |
item_id |
varchar2 |
25 |
Yes |
* |
CustRetItemQty
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfCustRetDesc:ExtOfCustRetItem
|
*
|
0
|
1
|
Provide an extension hook to customize CustRetItem.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:CustRetItemQty
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For CustRetItemQty |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
unit_qty |
number12_4 |
1 |
1 |
Description is not available. |
returns_upload |
unit_qty |
number |
12 |
Yes |
* |
from_wip |
varchar26 |
0 |
1 |
Description is not available. |
returns_upload |
from_wip_code |
varchar2 |
6 |
Yes |
* |
to_wip |
varchar26 |
0 |
1 |
Description is not available. |
returns_upload |
to_wip_code |
varchar2 |
6 |
Yes |
* |
from_disposition |
varchar24 |
0 |
1 |
Description is not available. |
returns_upload |
from_disposition |
varchar2 |
4 |
Yes |
* |
to_disposition |
varchar24 |
0 |
1 |
Description is not available. |
returns_upload |
to_disposition |
varchar2 |
4 |
Yes |
* |
saleable |
varchar21 |
0 |
1 |
Description is not available. |
returns_upload |
saleable |
varchar2 |
1 |
Yes |
* |
CustRetItemQtyDtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfCustRetDesc:ExtOfCustRetItemQty
|
*
|
0
|
1
|
Provide an extension hook to customize CustRetItemQty.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:CustRetItemQtyDtl
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For CustRetItemQtyDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
unit_qty |
number12_4 |
1 |
1 |
Description is not available. |
returns_upload |
unit_qty |
number |
12 |
Yes |
* |
reason_code |
varchar26 |
0 |
1 |
Description is not available. |
returns_upload |
reason_code |
varchar2 |
6 |
Yes |
* |
action_code |
varchar26 |
0 |
1 |
Description is not available. |
returns_upload |
action_code |
varchar2 |
6 |
Yes |
* |
replacement_item |
varchar225 |
0 |
1 |
Description is not available. |
returns_upload |
replacement_item |
varchar2 |
25 |
Yes |
* |
replace_unit_qty |
number12_4 |
0 |
1 |
Description is not available. |
returns_upload |
replace_unit_qty |
number |
12 |
Yes |
* |
ExtOfCustRetDesc:ExtOfCustRetItemQtyDtl
|
*
|
0
|
1
|
Provide an extension hook to customize CustRetItemQtyDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfCustRetItemQtyDtl
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfCustRetItemQtyDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfCustRetItemQty
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfCustRetItemQty |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfCustRetItem
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfCustRetItem |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfCustRetDesc
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfCustRetDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|