Retail Integration Mappings Report Release:15.0.0 (Integration Gateway Services)
Application Integration Gateway Services
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.
XSD Structure

XML-Schema Name:ReceiptDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReceiptDesc in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
schedule_nbr number8 0 1 Contains the Schedule Identifier Number. RMS.n/a n/a n/a n/a No Not used by RMS.
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. RMS.appt_head appt number 9 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

XML-Schema Name:Receipt Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for Receipt in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's 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 RMS.alloc_detail, ordloc, tsfhead to_loc, location, to_loc varchar2 10 Yes Contains the receiving location.
po_nbr varchar212 0 1 Specified the unique identifier of the purchase order, allocation or transfer. RMS.alloc_header, ordhead, tsfhead alloc_no, order_no, tsf_no varchar2 10 (alloc_no), 12 (order_no), 12 (tsf_no) No Specifies the unique identifier of the allocation, purchase order, or transfer.
cust_order_nbr varchar248 0 1 This field holds the master customer order number from OMS. RMS.n/a n/a n/a n/a No Not used by RMS.
fulfill_order_nbr varchar248 0 1 This field holds the number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. RMS.n/a n/a n/a n/a No Not used by RMS.
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. RMS.doc_close_queue doc_type varchar2 1 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 a reference number for a document associated to the shipment (e.g. Fiscal Document ID for Brazilian based transactions). RMS.shipment ref_doc_no number 25 No Contains a reference number for a document associated to the shipment (e.g. Fiscal Document ID for Brazilian based transactions).
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'. RMS.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. RMS.n/a n/a n/a n/a 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 Contains the source location of the shipment. RMS.shipment from_loc varchar2 10 No Contains the source location of the shipment.
from_loc_type varchar21 0 1 Contains the from location type. RMS.shipment from_loc_type varchar2 1 No Contains the from location type.

XML-Schema Name:ReceiptDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReceiptDtl in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
item_id varchar225 1 1 Specifies the item on the allocation, purchase order, or transfer that has been received. RMS.alloc_header, ordloc, tsfdetail item varchar2 25 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). RMS.alloc_detail, ordloc, tsfdetail qty_received, qty_received, received_qty number 12 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. RMS.n/a n/a n/a n/a 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 Identifies the date on which the transaction was written. RMS.shipment receive_date date Fill column length. Yes 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. RMS.appt_detail receipt_no varchar2 17 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. RMS.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. RMS.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 varchar212 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. RMS.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. RMS.n/a n/a n/a n/a 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. RMS.inv_status_codes inv_status_code varchar2 10 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. RMS.inv_status_codes inv_status_code varchar2 10 No This value is used to determine inventory availability only when to_disposition is not specified in the message.
to_wip varchar29 0 1 Description is not available. RMS.n/a n/a n/a n/a No Not used by RMS.
from_wip varchar29 0 1 Description is not available. RMS.n/a n/a n/a n/a No Not used by RMS.
to_trouble varchar29 0 1 Description is not available. RMS.n/a n/a n/a n/a No Not used by RMS.
from_trouble varchar29 0 1 Description is not available. RMS.n/a n/a n/a n/a 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. RMS.n/a n/a n/a n/a 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. RMS.dummy_carton_stage dummy_carton_ind varchar2 1 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. RMS.dummy_carton_stage tampered_ind varchar2 1 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. RMS.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. RMS.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 Contains the actual weight of the item received for the shipment. RMS.shipsku weight_received number 12 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). RMS.shipsku weight_received_uom varchar2 4 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. RMS.ordloc unit_cost number 20 No Contains the unit cost for the item and location on the order.
ReceiptDtlUin * 0 unbounded Collection of UIN(s) associated to the item.

XML-Schema Name:ReceiptDtlUin Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReceiptDtlUin in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
uin varchar2128 1 1 Universal Identification Number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
status number4 1 1 Status associated with the UIN. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:ReceiptCartonDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReceiptCartonDtl in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
carton_status_ind varchar21 0 1 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. RMS.n/a n/a n/a n/a 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 Contains the carton ID for the shipment. RMS.shipsku carton varchar2 20 Yes Contains the carton ID for the shipment.
dest_id varchar210 0 1 Identifies the location to which the stock order is received. RMS.shipment to_loc varchar2 10 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. RMS.n/a n/a n/a n/a Yes Specifies whether the carton receipt is for a Receipt (R), Transhipment (T), or Adjustment (A).
receipt_date xs:dateTime 0 1 This field contains the date on which the carton is received. RMS.shipment receive_date date Fill column length. 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. RMS.appt_detail receipt_no varchar2 17 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. RMS.n/a n/a n/a n/a 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. RMS.inv_status_codes inv_status_code varchar2 10 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 Contains the actual weight of the item received for the carton. RMS.shipsku weight_received number 12 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). RMS.shipsku weight_received_uom varchar2 4 No Contains the unit of measure of the received weight (such as pounds or kilograms).

XML-Schema Name:ReceiptOverage Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReceiptOverage in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
po_nbr varchar212 0 1 Contains purchase order number. RMS.n/a n/a n/a n/a No Not used by RMS.
document_type varchar21 0 1 Contains the document type information. RMS.n/a n/a n/a n/a No Not used by RMS.
asn_nbr varchar230 0 1 Contains Advanced Shipment Notice number. RMS.n/a n/a n/a n/a No Not used by RMS.
ReceiptOverageDtl * 0 unbounded Contains Overage Receipt Detail Information

XML-Schema Name:ReceiptOverageDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReceiptOverageDtl in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
item_id varchar225 0 1 Unique identifier for the item. RMS.n/a n/a n/a n/a No Not used by RMS.
qty_received number12_4 0 1 Contains the quantity of the item received at the location as overage, damaged etc. RMS.n/a n/a n/a n/a No Not used by RMS.
reason_code number4 0 1 Contains the rejection reason code or overage reason code. RMS.n/a n/a n/a n/a No Not used by RMS.
ReceiptOverageUin * 0 unbounded Collection of UIN(s) associated to the item.

XML-Schema Name:ReceiptOverageUin Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReceiptOverageUin in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
uin varchar2128 1 1 Universal Identification Number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
status number4 1 1 Status associated with the UIN. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.