XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for XAlloc in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
alloc_no |
number10 |
1 |
1 |
Contains the unique identifier of the allocation. This field is not editable once the allocation is created in RMS. This should fall within the range of RMS ids already designated for allocations. |
alloc_header |
alloc_no |
number |
10 |
Yes |
Contains the unique identifier of the allocation. This field is not editable once the allocation is created in RMS. This should fall within the range of RMS IDs already designated for allocations. |
alloc_desc |
varchar2300 |
1 |
1 |
Contains the user defined description of the allocation. This field is always editable. |
alloc_header |
alloc_desc |
varchar2 |
300 |
Yes |
Contains the user defined description of the allocation. This field is always editable. |
order_no |
number12 |
0 |
1 |
Contains the purchase order with which the allocation is associated in order to perform a cross-dock allocation. This field is not editable once the allocation has been created in RMS. |
alloc_header |
order_no |
varchar2 |
12 |
No |
Contains the purchase order with which the allocation is associated in order to perform a cross-dock allocation. This field is not editable once the allocation has been created in RMS. |
item |
varchar225 |
1 |
1 |
Contains the transaction level item that is being allocated. This field is not editable once the allocation has been created in RMS. |
alloc_header |
item |
varchar2 |
25 |
Yes |
Contains the transaction level item that is being allocated. This field is not editable once the allocation has been created in RMS. |
from_loc |
number10 |
1 |
1 |
Contains the location that is the source of the allocation. This must be a valid stockholding store or warehouse predefined in RMS. This field is not editable once the allocation has been created in RMS. |
alloc_header |
wh |
number |
10 |
Yes |
Contains the number of the warehouse location from where the allocation originates. This field is not editable once the allocation has been created in RMS. |
release_date |
xs:dateTime |
0 |
1 |
Contains the earliest date on which the warehouse should ship the allocation. This field is editable assuming that the warehouse has not yet started processing on the Allocation. This date cannot be in the past. |
alloc_header |
release_date |
RIBDate |
Fill column length. |
No |
Contains the earliest date on which the warehouse should ship the allocation. This field is editable assuming that the warehouse has not yet started processing on the Allocation. This date cannot be in the past. |
origin_ind |
varchar26 |
0 |
1 |
Indicates the source application that sends the allocation. Valid values are 'AIP' and 'EG'. It will be defaulted to 'EG' in RMS if not defined. |
alloc_header |
origin_ind |
varchar2 |
6 |
No |
Identifies the origin point of the allocation. Valid values are AIP, EG, RMS, ELC. If this is null, the value is defaulted to EG. |
XAllocDtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|