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 |