Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms 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. |
alloc_header |
alloc_no |
number |
10 |
Yes |
Contains the number that uniquely identifies the allocation within the system. |
doc_type |
varchar21 |
1 |
1 |
Specifies the type of
document. This value will always be 'A' to signify
an allocation. |
n/a |
n/a |
null |
null |
Yes |
Specifies the type of document. This value will always be 'A' to signify an allocation. |
physical_wh |
number10 |
1 |
1 |
Description is not
available. |
wh |
physical_wh |
null |
null |
Yes |
The physical wh location where the allocation will originate. |
wh |
number10 |
1 |
1 |
Contains the number of the
warehouse loaction where the allocation will
originate. |
alloc_header |
wh |
number |
10 |
Yes |
Contains the number of the warehouse loaction where the allocation will originate. |
item |
varchar225 |
1 |
1 |
Description is not
available. |
alloc_header |
item |
varchar2 |
25 |
Yes |
Unique alphanumeric value that identifies the item. |
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. |
alloc_header |
release_date |
RIBDate |
* |
No |
Contains the date on which the allocation should be released from the warehouse for delivery to the store locations. |
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. |
n/a |
n/a |
null |
null |
No |
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. |
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. |
alloc_header |
order_type |
varchar2 |
9 |
No |
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. |
order_no |
varchar210 |
0 |
1 |
Description is not
available. |
alloc_header |
order_no |
varchar2 |
10 |
No |
Contains the order number to which the allocation applies. |
order_doc_type |
varchar21 |
1 |
1 |
Description is not
available. |
n/a |
n/a |
null |
null |
Yes |
This value will always be 'P'. |
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. |
rpm_promo_event |
prom_event_id |
null |
null |
No |
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. |
event_description |
varchar21000 |
0 |
1 |
Description is not
available. |
rpm_promo_event |
description |
null |
null |
No |
This field contains the description of the promotional event. |
priority |
number4 |
1 |
1 |
A value which indicates the
priority of an allocation. This value will always
be 1. |
n/a |
n/a |
null |
null |
Yes |
A value which indicates the priority of an allocation. This value will always be 1. |
ticket_type_id |
varchar24 |
0 |
1 |
This field contains a
character string which uniquely identifies the
ticket type which is associated with the
item. |
item_ticket |
ticket_type_id |
null |
null |
No |
This field contains a character string which uniquely identifies the ticket type which is associated with the item. |
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 |
alloc_header |
context_type |
null |
null |
No |
This field holds the functional area code to which the transfer relates to for example Promotions. Valid value is: PROM - Promotion |
context_value |
varchar225 |
0 |
1 |
Description is not
available. |
alloc_header |
context_value |
varchar2 |
25 |
No |
The value for the context type |
ExtOfAllocDesc:ExtOfAllocDesc
|
*
|
0
|
1
|
Proide an extention hook to
customize AllocDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|