 |
Retail Integration Bus Mappings Report
Release: 13.0.1 |
 |
|
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:WOOutDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| wo_id | tsf-wo-head | tsf_wo_id | Yes | The work order number for this finishing activity. |
| dc_dest_id | tsfhead | from_loc | Yes | The 'from' location for tis transfer. |
| distro_nbr | tsfhead | tsf-no | Yes | The transfer that this work order is part of. |
| WOOutDtl | * | * | * | Child node - see below. |
| distro_parent_nbr | tsfhead | tsf-parent-no | No | The higher level transfer that this transfer belongs to. |
| WOOutXForm | * | * | * | Child node - see below. |
| WOOutPacking | * | * | * | Child node - see below. |
| inv_type | tsfhead | inventory_type | Yes | A code to indicate whether the inventory on the transfer is available. A = available; U = unavailable. |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:WOOutDtl |
| Tag Name | Table Name | Column Name | API Req | Description |
| dest_id | tsfhead | to-loc | Yes | The 'to' location for this transfer. |
| item_id | tsf_wo_detail | item | Yes | The item for this portion of the work order. |
| wip_seq_nbr | * | * | No | Not used. |
| wip_code | * | * | No | Not used. |
| personalization | * | * | No | Not used. |
| instructions | * | * | No | Not used. |
| order_line_nbr | * | * | No | Not used. |
| auto_complete | * | * | No | Not used. |
| WOOutActivity | * | * | * | Child node - see below. |
| inv_status | tsfdetail | inv_status | No | The inventory status of the transfer detail. |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:WOOutActivity |
| Tag Name | Table Name | Column Name | API Req | Description |
| activity_id | tsf_wo_detail | activity_id | No | A code number indicating the activity that will be performed on the item. |
| activity_cost | tsf_wo_detail | unit_cost | No | The per-unit cost of the finishing activity. |
| comments | tsf_wo_detail | comments | No | Any comments regarding this activity. |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:WOOutXForm |
| Tag Name | Table Name | Column Name | API Req | Description |
| from_item | tsf_xform_detail | from_item | No | The original item on the transfer. |
| to_item | tsf_xform_detail | to_item | No | The item which will result from the finishing activity. |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:WOOutPacking |
| Tag Name | Table Name | Column Name | API Req | Description |
| WOOutPackTo | * | * | * | Child node - see below. |
| WOOutPackFrom | * | * | * | Child node - see below. |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:WOOutPackTo |
| Tag Name | Table Name | Column Name | API Req | Description |
| to_item | tsf_packing_detail | item | Yes | The item resulting from the packing process. |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:WOOutPackFrom |
| Tag Name | Table Name | Column Name | API Req | Description |
| from_item | tsf_packing_detail | item | Yes | The item used in the packing process. |