Retail Integration Bus Mappings Report
Release: 13.0.1 |
Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:AllocDesc.xsd |
Tag Name | Table Name | Column Name | API Req | Description |
alloc_no | alloc_header | alloc_no | Yes | Contains the number that uniquely identifies the allocation within the system. |
doc_type | n/a | n/a | Yes | Specifies the type of document. This value will always be 'A' to signify an allocation. |
physical_wh | wh | physical_wh | Yes | The physical wh location where the allocation will originate. |
wh | alloc_header | wh | Yes | Contains the number of the warehouse loaction where the allocation will originate. |
item | alloc_header | item | Yes | Unique alphanumeric value that identifies the item. |
pick_not_before_date | alloc_header | release_date | No | Contains the date on which the allocation should be released from the warehouse for delivery to the store locations. |
pick_not_after_date | 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 will be a day before pick_not_before_date. |
order_type | alloc_header | order_type | 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 | alloc_header | order_no | No | Contains the order number to which the allocation applies. |
order_doc_type | n/a | n/a | Yes | This value will always be 'P'. |
event | rpm_promo_event | prom_event_id | 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 | rpm_promo_event | description | No | This field contains the description of the promotional event. |
priority | n/a | n/a | Yes | A value which indicates the priority of an allocation. This value will always be 1. |
ticket_type_id | item_ticket | ticket_type_id | No | This field contains a character string which uniquely identifies the ticket type which is associated with the item. |
AllocDtl | * | * | * | * |
context_type | alloc_header | context_type | No | This field holds the functional area code to which the transfer relates to for example Promotions. Valid value is: PROM - Promotion |
context_value | alloc_header | context_value | No | The value for the context type |
Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:AllocDtl |
Tag Name | Table Name | Column Name | API Req | Description |
physical_to_loc | alloc_detail | to_loc | Yes | This field contains the physical location to which the allocation is being sent. The loc_type field determinds if the location is a store or a warehouse. |
to_loc | alloc_detail | to_loc | Yes | This field contains the location to which the allocation is being sent. The loc_type field determinds if the location is a store or a warehouse. |
loc_type | item_loc | loc_type | Yes | This field contains the type of location in the loctaion field. Valid values are 'S'tore and 'W'arehouse. |
qty_allocated | alloc_detail | qty_allocated | Yes | Contains the total number of items allocated. |
price | item_loc | selling_unit_retail | No | This field holds the unit retail in the selling unit of measure for the item/zone combination. This field is stored in the local currency. |
selling_uom | item_loc | selling_uom | No | This field holds the selling unit of measure for an item's single-unit retail. |
priority | n/a | n/a | Yes | A value which indicates the priority of an allocation. This value will always be 1. |
store_ord_mult | item_loc | store_ord_mult | Yes | This column contains the multiple in which the item needs to be shipped from a warehouse to the location. |
AllocDtlTckt | * | * | * | * |
Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:AllocDtlTckt |
Tag Name | Table Name | Column Name | API Req | Description |
comp_item | packitem_breakout | item | Yes | Alphanumeric value that identifies the item within the pack. |
comp_price | item_loc | selling_unit_retail | Yes | This field holds the unit retail in the selling unit of measure for the item/zone combination. This field is stored in the local currency. |
comp_selling_uom | item_loc | selling_uom | Yes | This field holds the selling unit of measure for an item's single-unit retail. |