Inbound_shipment_items

The Inbound Shipment Items contain the information regarding each individual purchase order items that are included in the Inbound Shipment.

Columns

Name Type Length Precision Scale References In Description
amount NUMBER 20 2 Amount
currency_id NUMBER 39 0 currency_id
Currencies
Currency ID
date_effective TIMESTAMP Effective date
exchange_rate NUMBER 30 15 Base exchange rate
fx_rate NUMBER 30 15 Exchange rate
inboundshipment_id NUMBER 39 0 inboundshipment_id
Inbound_shipments
Inbound shipment ID
inboundshipmentitem_id NUMBER 39 0 Inbound shipment item ID
incoterm_id NUMBER 39 0 Incoterm ID
item_id NUMBER 39 0 item_id
Items
Item ID
item_type VARCHAR2 11 Item type
line_id NUMBER 39 0 Line ID
po_num VARCHAR2 138 Purchase order number
quantity_billed NUMBER 39 0 Quantity billed
quantity_expected NUMBER 18 8 Quantity expected
quantity_received NUMBER 39 0 Quantity received
quantity_remaining NUMBER 39 0 Quantity remaining
receiving_location_id NUMBER 39 0 Receiving location ID
unit_id NUMBER 39 0 uom_id
Uom
Unit ID
unit_rate NUMBER 18 8 Unit rate
vendor_id NUMBER 39 0 vendor_id
Vendors
Vendor ID
vendor_name VARCHAR2 200 Vendor name

Primary key

PK Column Name
inboundshipmentitem_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
inbound_shipment_items_currencies_fk currency_id Currencies currency_id 1
inbound_shipment_items_inbound_shipments_fk inboundshipment_id Inbound_shipments inboundshipment_id 1
inbound_shipment_items_items_fk item_id Items item_id 1
inbound_shipment_items_uom_fk unit_id Uom uom_id 1
inbound_shipment_items_vendors_fk vendor_id Vendors vendor_id 1