XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for AllocDesc in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's 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 |
12 |
Yes |
A number which uniquely identifies a distribution order. |
doc_type |
varchar21 |
1 |
1 |
Specifies the type of document. This value will always be 'A' to signify an allocation. |
* |
* |
RIB or/and RSB |
Fill column length. |
* |
* |
physical_wh |
number10 |
1 |
1 |
The physical warehouse location from which the allocation will originate. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
wh |
number10 |
1 |
1 |
Contains the number of the warehouse loaction where the allocation will originate. |
* |
* |
number |
10 |
* |
* |
item |
varchar225 |
1 |
1 |
Unique alphanumeric value that identifies the item. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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. |
* |
* |
RIB or/and RSB |
Fill column length. |
* |
* |
order_no |
varchar212 |
0 |
1 |
Contains the order number to which the allocation applies. |
* |
* |
varchar2 |
12 |
* |
* |
order_doc_type |
varchar21 |
1 |
1 |
Description is not
available. |
* |
* |
RIB or/and RSB |
Fill column length. |
* |
* |
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. |
* |
* |
RIB or/and RSB |
Fill column length. |
* |
* |
event_description |
varchar21000 |
0 |
1 |
This field contains the description of the promotional event. |
* |
* |
RIB or/and RSB |
Fill column length. |
* |
* |
priority |
number4 |
0 |
1 |
A value which indicates the priority of an allocation. This value will always be 1. |
* |
* |
RIB or/and RSB |
Fill column length. |
* |
* |
ticket_type_id |
varchar24 |
0 |
1 |
This field contains a character string which uniquely identifies the ticket type which is associated with the item. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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 |
stock_order |
order_type |
varchar2 |
9 |
* |
If context_type is REPAIR populate order_type with 'REPAIR' |
context_value |
varchar225 |
0 |
1 |
Contains the value relating to the context type. |
* |
* |
* |
* |
* |
Fill this description. |
alloc_status |
varchar21 |
0 |
1 |
Contains the value relating to the allocation status. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |