XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ReceiptDtl in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
item_id |
varchar225 |
1 |
1 |
Specifies the item on the allocation, purchase order, or transfer that has been received. |
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). |
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. |
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. |
shipment |
receive_date |
date |
|
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. |
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. |
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 |
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. |
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 |
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. |
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. |
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 |
varchar26 |
0 |
1 |
Description is not available. |
n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
from_wip |
varchar26 |
0 |
1 |
Description is not available. |
n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
to_trouble |
varchar22 |
0 |
1 |
Description is not available. |
n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
from_trouble |
varchar22 |
0 |
1 |
Description is not available. |
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. |
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. |
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. |
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. |
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 |
Contains the actual weight of the item received for the shipment. |
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). |
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. |
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.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|