Shipsku

Contains the unique number identifying a specific shipment of goods within the system. This number will either be system generated or entered by the user.

Due to the fact that there can be multiple Transfers[Distros], Inventory Statuses, or Cartons for the same Shipment/Item, this field contains the sequence number used along with the Shipment number and Item to make the Shipment Item records unique.

Unique identifier for the item.

This column will hold a transfer or allocation number associated with the shipment/item/carton.

Contains distro type that indicates the distro_no is for allocation number or transfer number. If A then allocation If T then transfer

Contains a reference item to the item field.

Identifies the UCC-128 carton number for shipments originating from the Advance Shipment Notification process as carton shipments. This field will be zero for all shipments that are not at a carton level.

This field contains the inventory status, if one exists, for the SHIPSKU record. The inventory status field corresponds to the inventory status type found on the INV_STATUS_TYPES table. This field will contain a valid inv_status for transfer records that have a inventory status, otherwise, this field will contain a -1.

Indicates the status of the SKU on the shipment. Valid values include: H - Hold A - Accept R - Reject C - Carton Received.

Contains the number of items already received for the SKU / Shipment combination. This value is used to compare the quantity expected for a shipment against the quantity actually received.

If the shipment is associated with a purchase order, UNIT_COST contains the cost of the SKU for this Shipment / Location combination based on the purchase order cost for the item and is stored in the order currency. The cost does not include landed cost components. If the shipment is associated with a transfer or allocation, UNIT_COST contains the average cost of the item at the sending location plus any up-charges. If it is for a transfer of type EG (externally generated) and has multiple inventory flows, UNIT_COST contains the average of the flows sending locations average costs plus any up- charges. For transfers or allocations UNIT_COST is stored in the from locations currency.

If the shipment is associated with a purchase order, UNIT_RETAIL contains the retail price of the item based on the associated purchase order and is stored in the local currency. If the shipment is associated with a transfer or allocation, UNIT_RETAIL contains the retail of the item at the from location and is stored in the from locations currency. If it is for a transfer Of type EG (externally generated) and has multiple inventory flows, UNIT_RETAIL contains the average retail of the sending locations.

Contains the number of items expected to be received based on the associated order number or on the suppliers advance shipment notification for this SKU / Shipment combination.

Invoice that the shipment line is matched to.

Contains the type of adjustment made for stock order receipt exceptions. This field is not required and valid values besides NULL are: SL - Shipping Location Faulted RL - Receiving Location Faulted FC - Freight Claim (i.e. missing units are freight claimed) FR - Force Receipt (i.e. what is shipped is received) RE - Received Elsewhere See Comments (i.e. wrong store received the qty) Adjust type RE is set by the Wrong Store Receipt Exception handler, while the rest of the adjust types are entered by the user through the Stock Order Exception Reconciliation Screen. Valid values are contained on the code_detail table with code_type = GART.

Contains the Actual Receiving Store Number when the Carton was received at wrong store.

Contains the ID of the user who reconciled the exception from the Stock Order Exception Reconciliation Screen.

Contains the date the exception was reconciled from the Stock Order Exception Reconciliation Screen.

Indicates the Carton was tampered or not.

Indicates the shipment was dispositioned at Carton level (not BOL level).

Matched Quantity that will be updated by ReIM when the receipt is matched

This column contains the actual weight of the item on received on the shipment.

This column contains the unit of measure of the received weight.

This column contains the expected weight of the item on the shipment.

This column contains the unit of measure of the expected weight.

The cost at which the receipt was originally matched the first time.

Invoice match status. Oracle Retail target column INVC_MATCH_STATUS on SHIPSKU.

This column holds the User id of the user who created the record.

This column holds the record creation date.

This column holds the last updated date of the record

This column holds the User id of the user who last updated the record.

Identifies the dummy carton number assigned by the store system when a carton from the source location is received at the wrong destination. It maps to the container_id field in RIB_ReceiptDtl_REC when ref_container_id is defined and holds the original carton ID.

This field contain the inventory identifier type, which is captured during shipment processing of transfer/allocation.Valid values are found under the Inventory Identifier Types (IIDT) code type, which include Lot (L), Expiry Date (E), Serial Number (S), Import Document (D).

Holds the inventory identifier provided on inventory transaction messages. It is a free-form text id field that will be interfaced and displayed as a text field

This field holds the item's average cost at the source location when it was shipped. It will only contains the cost without any upcharges. This field is used if the system is configured to change inventory ownership to the receiving location when transfer shipments are received.

This field holds the item's receipt cost calculated at the time of receiving. This field is used if the system is configured to change inventory ownership to the receiving location when transfer shipments are received.

This is a unique tracking number that is used to track containers through carrier system.

This holds any comment about the item in the shipment.