 |
Retail Integration Bus Mappings Report
|
 |
|
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:AllocDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| alloc_no | stock_allocation | distro_nbr or cust_order_nbr | Yes | * |
| doc_type | * | * | * | * |
| physical_wh | transshipment_setup | dc_dest_id | Yes | * |
| wh | * | * | * | * |
| item | stock_allocation | item_id | Yes | * |
| pick_not_before_date | * | * | * | * |
| pick_not_after_date | * | * | * | * |
| order_type | * | * | * | * |
| order_no | * | * | * | * |
| order_doc_type | * | * | * | * |
| event | * | * | * | * |
| event_description | * | * | * | * |
| priority | * | * | * | * |
| ticket_type_id | stock_allocation | ticket_type_id | No | * |
| AllocDtl | * | * | * | * |
| context_type | * | * | * | * |
| context_value | * | * | * | * |
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:AllocDtl |
| Tag Name | Table Name | Column Name | API Req | Description |
| physical_to_loc | * | * | * | * |
| to_loc | stock_allocation | dest_id | Yes | * |
| loc_type | * | * | * | * |
| qty_allocated | stock_allocation | requested_unit_qty | Yes | * |
| price | stock_allocation | retail_price | No | * |
| selling_uom | stock_allocation | selling_uom | No | * |
| priority | stock_allocation | priority | Yes | * |
| store_ord_mult | stock_allocation | store_ord_mult | Yes | * |
| AllocDtlTckt | * | * | * | * |
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:AllocDtlTckt |
| Tag Name | Table Name | Column Name | API Req | Description |
| comp_item | component_ticketing | component_item_id | Yes | * |
| comp_price | component_ticketing | retail_price | Yes | * |
| comp_selling_uom | component_ticketing | selling_uom | Yes | * |