Oracle Portal
 Retail Integration Bus Mappings Report    

Application Name: Retail Merchandising System
XML-Schema or Node Name:ReceiptDesc.xsd
Tag Name Table Name Column Name API Req Description
appt_nbr appt_head appt No Unique identifier for receiving a group of items. This is usually an RDM-generated unique numerical identifier for an Appointment.
Receipt * * * *

Application Name: Retail Merchandising System
XML-Schema or Node Name:Receipt
Tag Name Table Name Column Name API Req Description
dc_dest_id alloc_detail, ordloc, tsf to_loc, location, to_loc Yes This element corresponds to different RMS tables, depending on the document_type. 'A' - ALLOC_DETAIL.TO_LOC, 'P' - ORDLOC.LOCATION, 'T' - TSFHEAD.TO_LOC
po_nbr alloc_header, ordhead, tsf alloc_no, ordloc, tsf_no No Specifies the unique identifier of the allocation, purchase order, or transfer.
document_type doc_close_queue doc_type Yes Specifies whether the receipt is for an allocation 'A', purchase order 'P', or transfer 'T'. Types 'D' and 'V' are also valid document types that are treated the same as transfers.
asn_nbr shipment asn No Used to relate the receipt message to the previous ASN message, be it ASNIn or ASNOut. This field is required for doc types 'A' and 'T', not required for doc_type 'P'.
ReceiptDtl * * * *
ReceiptCartonDtl * * * *
receipt_type n/a n/a No This field is required when receiving a transfer or allocation to determine if the receipt is at the 'BL' (BOL) level or 'SK' (SKU) level. It is not used for a PO receipt.
from_loc shipment from_loc No The originating location
from_loc_type shipment from_loc_type No From location type

Application Name: Retail Merchandising System
XML-Schema or Node Name:ReceiptDtl
Tag Name Table Name Column Name API Req Description
item_id alloc_header, ordloc, tsf item Yes Specifies the item on the allocation, purchase order, or transfer that has been received.
unit_qty alloc_detail, ordloc, tsf qty_received Yes Contains the quantity received for the allocation, purchase order, or transfer. The shipment record is also updated with the quantity received (SHIPSKU.QTY_RECEIVED)
receipt_xactn_type n/a n/a Yes Specifies whether the receipt detail line item is for a 'R'eceipt, 'T'ransshipment, or 'A'djustment. For purchase order receiving, Transshipments are not allowed. For stock order (ie. Allocation and Transfer) receiving, Transshipments are handled the same way as 'R'eceipt type.
receipt_date shipment receive_date No Identifies the date the transaction was written.
receipt_nbr shipment ext_ref_no_out No An externally generated numerical identifier corresponding to the successful reception of the item at the location.
dest_id alloc_detail to_loc No Only used for doc_type of 'P', when the purchase order has an allocation attached to it. This element specifies the location to which the allocation is being sent.
container_id shipsku carton Yes Identifies the UCC-128 carton number for shipments originating from the Advance Shipment Notification process as carton shipments.
distro_nbr alloc_header alloc_no No Only used for doc_type of 'P', when the purchase order has an allocation attached to it. This element specifies the allocation id.
distro_doc_type n/a n/a No Only used for doc_type of 'P', when the purchase order has an allocation attached to it. When populated, this value should always be 'A' to specify an allocation.
to_disposition inv_status_codes inv_status_code No This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table.
from_disposition inv_status_codes inv_status_code No This value is used to determine inventory availability only if the to_disposition is not specified in the message.
to_wip n/a * No Not used by RMS.
from_wip n/a * No Not used by RMS.
to_trouble n/a * No Not used by RMS.
from_trouble n/a * No Not used by RMS.
user_id n/a * No Not used by RMS.
dummy_carton_ind dummy_carton_stage dummy_carton_ind No Indicates if this carton is a dummy carton. This field is only used for transfer receipts.
tampered_carton_ind dummy_carton_stage tampered_ind No Indicates if the carton was tampered. This field is only used for transfer receipts.
unit_cost ordloc unit_cost No Only used for doc_type of 'P'. Specifies the unit_cost for the item on the order. Cost is converted to the order's currency before insert/update.
shipped_qty shipsku qty_expected No Only used for doc_type of 'P'. Updates the number of items expected to be received, originally set by the ASN process.
weight shipsku weight_received No Contains the actual weight of the item on received for the shipment.
weight_uom shipsku weight_received_uom No Contains the unit of measure of the received weight (e.g. pounds, kilograms).

Application Name: Retail Merchandising System
XML-Schema or Node Name:ReceiptCartonDtl
Tag Name Table Name Column Name API Req Description
carton_status_ind n/a n/a Yes Denotes the status of the carton received. It can be ?A?ctual, ?D?ummy or ?O?verage. This field is only used for stock order receiving.
container_id shipsku carton Yes Contains the carton ID for the shipment.
dest_id shipsku to_loc No Identifies the location to which the stock order is received.
receipt_xactn_type n/a n/a Yes Specifies whether the carton receipt is for a 'R'eceipt, 'T'ranshipment, or 'A'djustment.
receipt_date shipment receive_date No This field contains the date the carton is received.
receipt_nbr shipment ext_ref_no_out No This field holds the externally generated number when the shipment is received at the location.
user_id n/a n/a No Not used by RMS.
to_disposition inv_status_codes inv_status_code No This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table.
weight shipsku weight_received No Contains the actual weight of the item on received for the carton.
weight_uom shipsku weight_received_uom No Contains the unit of measure of the received weight (e.g. pounds, kilograms).