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
|