Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For AllocDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
alloc_no |
number10 |
1 |
1 |
Contains the number that
uniquely identifies the allocation within the
system. |
stock_allocation |
distro_nbr or cust_order_nbr |
number |
10 |
Yes |
* |
doc_type |
varchar21 |
1 |
1 |
Specifies the type of
document. This value will always be 'A' to signify
an allocation. |
* |
* |
varchar2 |
1 |
* |
* |
physical_wh |
number10 |
1 |
1 |
Description is not
available. |
transshipment_setup |
dc_dest_id |
number |
10 |
Yes |
* |
wh |
number10 |
1 |
1 |
Contains the number of the
warehouse loaction where the allocation will
originate. |
* |
* |
number |
10 |
* |
* |
item |
varchar225 |
1 |
1 |
Description is not
available. |
stock_allocation |
item_id |
varchar2 |
25 |
Yes |
* |
pick_not_before_date |
xs:dateTime |
0 |
1 |
Contains the date on which the
allocation should be released from the warehouse
for delivery to the store
locations. |
* |
* |
RIBDate |
* |
* |
* |
pick_not_after_date |
xs:dateTime |
0 |
1 |
This value is calculated by
adding code_detail.code desc for code 'DATE' and
code_type 'DEFT' to alloc_header.release_date. If
the allocation is closed, pick_not_after_date will
be a day before
pick_not_before_date. |
* |
* |
RIBDate |
* |
* |
* |
order_type |
varchar29 |
0 |
1 |
This field identifies the
order associated with the PO. Allocations created
before PO approval will be marked as 'PREDIST'
ordertypes. Allocations created after PO approval
will be marked as 'PO' order
types. |
* |
* |
varchar2 |
9 |
* |
* |
order_no |
varchar210 |
0 |
1 |
Description is not
available. |
* |
* |
varchar2 |
10 |
* |
* |
order_doc_type |
varchar21 |
1 |
1 |
Description is not
available. |
* |
* |
varchar2 |
1 |
* |
* |
event |
varchar26 |
0 |
1 |
This field contains the event
to which the promotion belongs to. This is an
optional field that provides a method to group
promotions together for tracking and reporting
purposes. |
* |
* |
varchar2 |
6 |
* |
* |
event_description |
varchar21000 |
0 |
1 |
Description is not
available. |
* |
* |
varchar2 |
1000 |
* |
* |
priority |
number4 |
1 |
1 |
A value which indicates the
priority of an allocation. This value will always
be 1. |
* |
* |
number |
4 |
* |
* |
ticket_type_id |
varchar24 |
0 |
1 |
This field contains a
character string which uniquely identifies the
ticket type which is associated with the
item. |
stock_allocation |
ticket_type_id |
varchar2 |
4 |
No |
* |
AllocDtl
|
*
|
0
|
unbounded
|
Description is not
available.
|
|
|
|
|
|
|
context_type |
varchar26 |
0 |
1 |
This field holds the
functional area code to which the transfer relates
to for example Promotions. Valid value is: PROM -
Promotion |
* |
* |
varchar2 |
6 |
* |
* |
context_value |
varchar225 |
0 |
1 |
Description is not
available. |
* |
* |
varchar2 |
25 |
* |
* |
ExtOfAllocDesc:ExtOfAllocDesc
|
*
|
0
|
1
|
Proide an extention hook to
customize AllocDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|