Application
|
Retail Merchandizing System
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/TsfRef/v1
|
Version
|
1.0
|
Description
|
This is root element of this document which contains name space definitions for the document elements.
|
|
|
|
XML-Schema Name:TsfRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For TsfRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
tsf_no |
number10 |
1 |
1 |
The number that uniquely identifies the transfer within the system. |
tsfhead |
tsf_no |
null |
null |
Yes |
The number to uniquely identify the transfer within the system. |
doc_type |
varchar21 |
1 |
1 |
NA |
* |
* |
null |
null |
Yes |
Defaults to T for RMS transfers. |
physical_from_loc |
number10 |
1 |
1 |
NA |
store, wh |
store, physical_wh |
number |
10 |
Yes |
Physical location of the from_loc. |
from_loc |
varchar210 |
1 |
1 |
The location number of the transfer from location. This will be either a store or warehouse number based on the from_loc_type field. |
tsfhead |
from_loc |
null |
null |
Yes |
The location number of the Transfer From location. This will be either a store or warehouse number, based on the from_loc_type field. |
physical_to_loc |
number10 |
1 |
1 |
NA |
store, wh |
store, physical_wh |
number |
10 |
Yes |
Physical location of the to_loc. |
to_loc |
varchar210 |
1 |
1 |
The location number of the transfer to location. This will be either a store or warehouse number based on the to_loc_type field. |
tsfhead |
to_loc |
null |
null |
Yes |
The location number of the Transfer To location. This will be either a store or warehouse number, based on the to_loc_type field. |
TsfDtlRef
|
*
|
0
|
unbounded
|
Child Node - see below.
|
|
|
|
|
|
|
tsf_parent_no |
number10 |
0 |
1 |
Description is not available. |
NA |
NA |
NA |
NA |
NA |
NA |
ExtOfTsfRef:ExtOfTsfRef
|
*
|
0
|
1
|
Provide an extension hook to customize TsfRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfTsfRef:LocOfTsfRef
|
*
|
0
|
1
|
Provide an extension hook to localize TsfRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:TsfDtlRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For TsfDtlRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
item |
varchar225 |
1 |
1 |
Unique alphanumeric value that identifies the item. |
tsfdetail |
item |
varchar2 |
25 |
Yes |
Unique alphanumeric value to identify the item. |
ExtOfTsfRef:ExtOfTsfDtlRef
|
*
|
0
|
1
|
Provide an extension hook to customize TsfDtlRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfTsfRef:LocOfTsfDtlRef
|
*
|
0
|
1
|
Provide an extension hook to localize TsfDtlRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfTsfDtlRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ExtOfTsfDtlRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:LocOfTsfDtlRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For LocOfTsfDtlRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
InTsfRef:InTsfDtlRef
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrTsfRef:BrTsfDtlRef
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfTsfRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ExtOfTsfRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:LocOfTsfRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For LocOfTsfRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
InTsfRef:InTsfRef
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrTsfRef:BrTsfRef
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|