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

XML-Schema Name:ReceiptDesc Version:13.2.0 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
schedule_nbr number8 0 1 Contains the Schedule Identifier Number n/a null null No
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 numeric identifier for receiving a group of items. This is usually generated by RDM for an appointment.
Receipt * 1 unbounded Description is not available.
ReceiptOverage * 0 unbounded Contains the Receipt Overage Information NA NA NA NA NA NA
ExtOfReceiptDesc:ExtOfReceiptDesc * 0 1 Provide an extension hook to customize ReceiptDesc. NA NA NA NA NA NA
LocOfReceiptDesc:LocOfReceiptDesc * 0 1 Provide an extension hook to localize ReceiptDesc. NA NA NA NA NA NA

XML-Schema Name:Receipt Version:13.2.0 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 specific 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 also are valid document types and are treated the same as transfers.
ref_doc_no number10 0 1 Contains the Nota Fiscal id for Brazil locations. NA NA NA NA NA NA
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 (ASNIn or ASNOut). This field is required for doc types A and T, but it is 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 whether the receipt is at the BOL (BL) level or SKU (SK) level. It is not used for PO receipts.
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
LocOfReceiptDesc:LocOfReceipt * 0 1 Provide an extension hook to localize Receipt. NA NA NA NA NA NA

XML-Schema Name:ReceiptDtl Version:13.2.0 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 Receipt (R), Transshipment (T), or Adjustment (A). For purchase order receiving, transshipments are not allowed. For a stock order (such as allocation and transfer) receiving, transshipments are handled the same way as receipt type.
receipt_date xs:dateTime 0 1 Description is not available. shipment receive_date null null No Identifies the date on which 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 item when it is received 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 when doc_type = 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 when doc_type = 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 whether the inventory is available, based on the code's INV_STATUS value in 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 when 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 whether 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 whether the carton was tampered with and is used only 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 when doc_type = 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 when doc_type = P. Updates the number of items expected to be received and is 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 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 (such as pounds or kilograms).
gross_cost number20_4 0 1 Contains the Unit cost and Expenses incurred on an item in a particular transaction. NA NA NA NA NA NA
ExtOfReceiptDesc:ExtOfReceiptDtl * 0 1 Provide an extension hook to customize ReceiptDtl. NA NA NA NA NA NA
LocOfReceiptDesc:LocOfReceiptDtl * 0 1 Provide an extension hook to localize ReceiptDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfReceiptDtl Version:13.2.0 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:LocOfReceiptDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfReceiptDtl
Table Name Column Name API Type Column Length API Required API Description
InReceiptDesc:InReceiptDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrReceiptDesc:BrReceiptDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ReceiptCartonDtl Version:13.2.0 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 Actual (A), Dummy (D), or Overage (O). This field is used only 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 Receipt (R), Transhipment (T), or Adjustment (A).
receipt_date xs:dateTime 0 1 Description is not available. shipment receive_date null null No This field contains the date on which 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 number that is externally generated 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, based on the code's INV_STATUS value in 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 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 (such as pounds or kilograms).
ExtOfReceiptDesc:ExtOfReceiptCartonDtl * 0 1 Provide an extension hook to customize ReceiptCartonDtl. NA NA NA NA NA NA
LocOfReceiptDesc:LocOfReceiptCartonDtl * 0 1 Provide an extension hook to localize ReceiptCartonDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfReceiptCartonDtl Version:13.2.0 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:LocOfReceiptCartonDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfReceiptCartonDtl
Table Name Column Name API Type Column Length API Required API Description
InReceiptDesc:InReceiptCartonDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrReceiptDesc:BrReceiptCartonDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfReceipt Version:13.2.0 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:LocOfReceipt Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfReceipt
Table Name Column Name API Type Column Length API Required API Description
InReceiptDesc:InReceipt * 0 unbounded India Localization. NA NA NA NA NA NA
BrReceiptDesc:BrReceipt * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ReceiptOverage Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ReceiptOverage
Table Name Column Name API Type Column Length API Required API Description
po_nbr varchar210 0 1 Contains Purchase order number NA NA NA NA NA NA
document_type varchar21 0 1 Contains the document type information NA NA NA NA NA NA
asn_nbr varchar230 0 1 Contains Advanced Shipment Notice number NA NA NA NA NA NA
ReceiptOverageDtl * 0 unbounded Contains Overage Receipt Detail Information NA NA NA NA NA NA
ExtOfReceiptDesc:ExtOfReceiptOverage * 0 1 Provide an extension hook to customize ReceiptOverage. NA NA NA NA NA NA
LocOfReceiptDesc:LocOfReceiptOverage * 0 1 Provide an extension hook to localize ReceiptOverage. NA NA NA NA NA NA

XML-Schema Name:ReceiptOverageDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ReceiptOverageDtl
Table Name Column Name API Type Column Length API Required API Description
item_id varchar225 0 1 Contains the Item Number NA NA NA NA NA NA
qty_received number12_4 0 1 Contains the quantity of the item received at the location as overage, damaged etc. NA NA NA NA NA NA
reason_code number4 0 1 Contains the rejection reason code or overage reason code NA NA NA NA NA NA
ExtOfReceiptDesc:ExtOfReceiptOverageDtl * 0 1 Provide an extension hook to customize ReceiptOverageDtl. NA NA NA NA NA NA
LocOfReceiptDesc:LocOfReceiptOverageDtl * 0 1 Provide an extension hook to localize ReceiptOverageDtl. NA NA NA NA NA NA

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

XML-Schema Name:LocOfReceiptOverageDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfReceiptOverageDtl
Table Name Column Name API Type Column Length API Required API Description
InReceiptDesc:InReceiptOverageDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrReceiptDesc:BrReceiptOverageDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

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

XML-Schema Name:LocOfReceiptOverage Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfReceiptOverage
Table Name Column Name API Type Column Length API Required API Description
InReceiptDesc:InReceiptOverage * 0 unbounded India Localization. NA NA NA NA NA NA
BrReceiptDesc:BrReceiptOverage * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfReceiptDesc Version:13.2.0 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

XML-Schema Name:LocOfReceiptDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfReceiptDesc
Table Name Column Name API Type Column Length API Required API Description
InReceiptDesc:InReceiptDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrReceiptDesc:BrReceiptDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA