Retail Integration Bus Mappings Report Release:13.1 (Retail Merchandizing System)
Application Retail Merchandizing System
Target Name Space http://www.oracle.com/retail/integration/base/bo/ReceiptDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:ReceiptDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ReceiptDesc
Table Name Column Name API Type Column Length API Required API Description
appt_nbr number9 0 1 Unique identifier for receiving a group of items. This is usually an RDM-generated unique numerical identifier for an Appointment. appt_head appt null null No Unique identifier for receiving a group of items. This is usually an RDM-generated unique numerical identifier for an Appointment.
Receipt * 1 unbounded Description is not available.
ExtOfReceiptDesc:ExtOfReceiptDesc * 0 1 Provide an extension hook to customize ReceiptDesc. NA NA NA NA NA NA

XML-Schema Name:Receipt Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For Receipt
Table Name Column Name API Type Column Length API Required API Description
dc_dest_id varchar210 1 1 This element corresponds to different RMS tables, depending on the document_type. 'A' - ALLOC_DETAIL.TO_LOC, 'P' - ORDLOC.LOCATION, 'T' - TSFHEAD.TO_LOC alloc_detail, ordloc, tsf to_loc, location, to_loc varchar2 10 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 varchar210 0 1 Specified the unique identifier of the purchase order, allocation or transfer alloc_header, ordhead, tsf alloc_no, ordloc, tsf_no null null No Specifies the unique identifier of the allocation, purchase order, or transfer.
document_type varchar21 1 1 Specified 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. doc_close_queue doc_type null null 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 varchar230 0 1 Used to relate the receipt message to the previous ASN message. this field is required for doc types 'A' and 'T', not required for doc_type 'P' shipment asn varchar2 30 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 * 0 unbounded Description is not available.
ReceiptCartonDtl * 0 unbounded Description is not available.
receipt_type varchar22 0 1 This fied 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 n/a n/a null null 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 varchar210 0 1 Description is not available. shipment from_loc varchar2 10 No The originating location
from_loc_type varchar21 0 1 Description is not available. shipment from_loc_type varchar2 1 No From location type
ExtOfReceiptDesc:ExtOfReceipt * 0 1 Provide an extension hook to customize Receipt. NA NA NA NA NA NA

XML-Schema Name:ReceiptDtl Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ReceiptDtl
Table Name Column Name API Type Column Length API Required API Description
item_id varchar225 1 1 Specifieds the item on the allocation, purchase order, or transfer that has been received. alloc_header, ordloc, tsf item null null Yes Specifies the item on the allocation, purchase order, or transfer that has been received.
unit_qty number12_4 1 1 Contains the quantity received for the allocation, purchase order, or transfer. The shipment record is also updated with the quantity received (SHIPSKU.QTY_RECEIVED) alloc_detail, ordloc, tsf qty_received null null 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 varchar21 1 1 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. n/a n/a null null 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 xs:dateTime 0 1 Description is not available. shipment receive_date null null No Identifies the date the transaction was written.
receipt_nbr varchar217 1 1 An externally generated numerical identifier corresponding to the successful reception of the item at the location. shipment ext_ref_no_out null null No An externally generated numerical identifier corresponding to the successful reception of the item at the location.
dest_id varchar210 0 1 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. alloc_detail to_loc varchar2 10 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 varchar220 0 1 Identifies the Carton number for shipments originating from the Advance Shipment Notification process as carton shipments shipsku carton varchar2 20 Yes Identifies the UCC-128 carton number for shipments originating from the Advance Shipment Notification process as carton shipments.
distro_nbr varchar210 0 1 Only used for doc_type of 'P', when the purchase order has an allocation attached to it. This element specifies the allocation id. alloc_header alloc_no varchar2 10 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 varchar21 0 1 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. n/a n/a null null 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 varchar24 0 1 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. inv_status_codes inv_status_code varchar2 4 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 varchar24 0 1 This value is used to determine inventory availability. It is not used by SIM. inv_status_codes inv_status_code varchar2 4 No This value is used to determine inventory availability only if the to_disposition is not specified in the message.
to_wip varchar26 0 1 Description is not available. n/a * varchar2 6 No Not used by RMS.
from_wip varchar26 0 1 Description is not available. n/a * varchar2 6 No Not used by RMS.
to_trouble varchar22 0 1 Description is not available. n/a * varchar2 2 No Not used by RMS.
from_trouble varchar22 0 1 Description is not available. n/a * varchar2 2 No Not used by RMS.
user_id varchar230 0 1 Identifies the point of origin for this inventory control document. An originator may be a program (for automatically generated documents) or a person n/a * varchar2 30 No Not used by RMS.
dummy_carton_ind varchar21 0 1 Indicates if this carton is a dummy carton. This field is only used for transfer receipts. dummy_carton_stage dummy_carton_ind null null No Indicates if this carton is a dummy carton. This field is only used for transfer receipts.
tampered_carton_ind varchar21 0 1 Indicates if the carton was tampered. This field is only used for transfer receipts. dummy_carton_stage tampered_ind null null No Indicates if the carton was tampered. This field is only used for transfer receipts.
unit_cost number20_4 0 1 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. ordloc unit_cost number 20 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 number12_4 0 1 Only used for doc_type of 'P'. Updates the number of items expected to be received, originally set by the ASN process. shipsku qty_expected number 12 No Only used for doc_type of 'P'. Updates the number of items expected to be received, originally set by the ASN process.
weight number12_4 0 1 Description is not available. shipsku weight_received null null No Contains the actual weight of the item on received for the shipment.
weight_uom varchar24 0 1 Contains the unit of measure of the received weight (e.g. pounds, kilograms). shipsku weight_received_uom null null No Contains the unit of measure of the received weight (e.g. pounds, kilograms).
ExtOfReceiptDesc:ExtOfReceiptDtl * 0 1 Provide an extension hook to customize ReceiptDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfReceiptDtl Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfReceiptDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ReceiptCartonDtl Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ReceiptCartonDtl
Table Name Column Name API Type Column Length API Required API Description
carton_status_ind varchar21 0 1 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. n/a n/a null null 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 varchar220 0 1 Description is not available. shipsku carton null null Yes Contains the carton ID for the shipment.
dest_id varchar210 0 1 Description is not available. shipsku to_loc null null No Identifies the location to which the stock order is received.
receipt_xactn_type varchar21 1 1 Specifies whether the carton receipt is for a 'R'eceipt, 'T'ranshipment, or 'A'djustment. n/a n/a null null Yes Specifies whether the carton receipt is for a 'R'eceipt, 'T'ranshipment, or 'A'djustment.
receipt_date xs:dateTime 0 1 Description is not available. shipment receive_date null null No This field contains the date the carton is received.
receipt_nbr varchar217 0 1 This field holds the externally generated number when the shipment is received at the location. shipment ext_ref_no_out null null No This field holds the externally generated number when the shipment is received at the location.
user_id varchar230 0 1 Description is not available. n/a n/a null null No Not used by RMS.
to_disposition varchar24 0 1 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. inv_status_codes inv_status_code null null 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 number12_4 0 1 Description is not available. shipsku weight_received null null No Contains the actual weight of the item on received for the carton.
weight_uom varchar24 0 1 Contains the unit of measure of the received weight (e.g. pounds, kilograms). shipsku weight_received_uom null null No Contains the unit of measure of the received weight (e.g. pounds, kilograms).
ExtOfReceiptDesc:ExtOfReceiptCartonDtl * 0 1 Provide an extension hook to customize ReceiptCartonDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfReceiptCartonDtl Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfReceiptCartonDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfReceipt Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfReceipt
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfReceiptDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfReceiptDesc
Table Name Column Name API Type Column Length API Required API Description