Inbound_shipments
An order is identified as an inbound shipment when the vendor physically packs the purchase order items to ship to one of the buyer’s receiving destinations. Inbound Shipment Management enables you to track shipments when they leave the supplier to the receiving destination, and then into the buyer’s inventory.
The table’s data is available only for accounts with the Inbound Shipment Management feature enabled.
Columns
| Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
| bill_status |
VARCHAR2 |
2 |
|
|
|
|
Bill status |
| currency_id |
NUMBER |
|
39 |
0 |
currency_id
|
Currencies
|
Currency ID |
| date_actual_delivery |
TIMESTAMP |
|
|
|
|
|
Actual delivery date |
| date_actual_shipping |
TIMESTAMP |
|
|
|
|
|
Actual shipping date |
| date_create |
TIMESTAMP |
|
|
|
|
|
Date created |
| date_expected_delivery |
TIMESTAMP |
|
|
|
|
|
Expected delivery date |
| date_expected_shipping |
TIMESTAMP |
|
|
|
|
|
Expected shipping date |
| inboundshipment_id |
NUMBER |
|
39 |
0 |
|
|
Inbound shipment ID |
| memo |
VARCHAR2 |
3000 |
|
|
|
|
memo |
| shipment_number |
NUMBER |
|
39 |
0 |
|
|
Shipment number |
| status |
VARCHAR2 |
64 |
|
|
|
|
Inbound shipment status |
Primary key
| PK Column Name |
| inboundshipment_id |
Foreign keys in this table
| FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
| inbound_shipments_currencies_fk |
currency_id |
Currencies |
currency_id |
1 |