XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for AllocDesc 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 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 |
n/a |
n/a |
Yes |
Specifies the type of document. This value will always be 'A' to signify an allocation. |
physical_wh |
number10 |
1 |
1 |
The physical warehouse location from which the allocation will originate. |
wh |
physical_wh |
number |
10 |
Yes |
The physical warehouse location from which 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 location from which the allocation will originate. |
item |
varchar225 |
1 |
1 |
Unique alphanumeric value that identifies the item. |
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 |
Fill column length. |
No |
Contains the date on which the allocation should be released from the warehouse for delivery to 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 |
n/a |
n/a |
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 is 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 type of the order. Allocations created before PO approval are marked as PREDIST order types. Allocations created after PO approval are marked as PO order types. |
order_no |
varchar212 |
0 |
1 |
Contains the order number to which the allocation applies. |
alloc_header |
order_no |
number |
12 |
No |
Contains the order number to which the allocation applies. |
order_doc_type |
varchar21 |
1 |
1 |
Description is not
available. |
n/a |
n/a |
n/a |
n/a |
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 |
promo_event_id |
varchar2 |
6 |
No |
This field contains the event to which the promotion belongs. This is an optional field that provides a method to group promotions together for tracking and reporting purposes. |
event_description |
varchar21000 |
0 |
1 |
This field contains the description of the promotional event. |
rpm_promo_event |
description |
varchar2 |
1000 |
No |
This field contains the description of the promotional event. |
priority |
number4 |
0 |
1 |
A value which indicates the priority of an allocation. This value will always be 1. |
n/a |
n/a |
n/a |
n/a |
Yes |
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 |
varchar2 |
4 |
No |
This field contains a character string to uniquely identify the ticket type 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 |
varchar2 |
6 |
No |
This field contains the functional area code to which the transfer relates to (for example, PROM - Promotion). |
context_value |
varchar225 |
0 |
1 |
Contains the value relating to the context type. |
alloc_header |
context_value |
varchar2 |
25 |
No |
Contains the value relating to the context type. |
alloc_status |
varchar21 |
0 |
1 |
Contains the value relating to the allocation status. |
alloc_header |
status |
varchar2 |
10 |
Yes |
This contains the status of the allocation. Valid values are: W = Worksheet, R = Reserved, A = Approved, C = Closed, X = Allocation is being externally closed. |