 |
Retail Integration Bus Mappings Report
Release: 13.0.1 |
 |
|
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:AppointDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| from_location | appt_head | loc | Yes | The location to which the merchandise has been sent. |
| to_location | n/a | n/a | Yes | Not used by RMS. |
| appt_nbr | appt_head | appt | Yes | An RWMS-generated unique numerical identifier for an Appointment. |
| appt_start_ts | n/a | n/a | Yes | Not used by RMS. |
| appt_action_status | appt_head | status | Yes | The status of the Appointment. Valid values include: SC - Scheduled, MS - Modified Scheduled, AR - Arrived, CL - Closed. |
| AppointDtl | * | * | * | * |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:AppointDtl |
| Tag Name | Table Name | Column Name | API Req | Description |
| item_id | appt_detail | item | Yes | The item shipped to the location under the Appt ID. |
| unit_qty | appt_detail | qty_appointed | Yes | The quantity of the item slated to be sent to the location. |
| po_nbr | appt_detail | doc | Yes | The Purchase Order/Transfer/Allocation corresponding to the shipped merchandise. |
| document_type | appt_detail | doc_type | Yes | The type of document corresponding to the shipped merchandise. Possible choices are 'P'urchase Order, 'T'ransfer and 'A'llocation. |
| asn_nbr | appt_detail | asn | No | This column will hold the Advance Shipping Notice number associated with the Appointment. |