InboundShipmentItem
Lists individual items associated with inbound shipments, including quantities, costs, and item details.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Unique identifier for the inbound shipment item record, serving as the primary key. | |
| expectedrate | Decimal | The anticipated cost per unit of the item in the inbound shipment, based on initial estimates. | |
| inboundshipment | String | Reference to the associated inbound shipment, indicating the batch or shipment this item belongs to. | |
| incoterm | String | International Commercial Term (Incoterm) defining the shipping and delivery responsibilities between buyer and seller. | |
| pocurrency | String | The currency used for the purchase order associated with this inbound shipment item. | |
| porate | Decimal | The exchange rate applied to the purchase order currency for cost calculations. | |
| purchaseordertransaction | String | The purchase order number linked to this inbound shipment item, referencing the procurement transaction. | |
| quantitybilled | Double | The total number of units that have been invoiced for this inbound shipment item. | |
| quantityexpected | Double | The number of units initially expected to be received in the inbound shipment. | |
| quantityreceived | Double | The actual number of units received for this item in the inbound shipment. | |
| quantityremaining | Double | The remaining quantity of this item yet to be received, calculated as expected quantity minus received quantity. | |
| receivinglocation | String | The warehouse or location where the inbound shipment item is being received and stored. | |
| shipmentitemamount | Decimal | The total monetary value of this inbound shipment item, calculated based on unit cost and quantity. | |
| shipmentitemdescription | String | Detailed description of the inbound shipment item, including product specifications or additional notes. | |
| shipmentitemeffectivedate | Date | The date on which this inbound shipment item becomes effective for financial and inventory purposes. | |
| shipmentitemexchangerate | Decimal | The exchange rate applicable to this shipment item for conversion between purchase currency and base currency. | |
| shipmentitemtransaction | String | Reference to the specific line item within the purchase order transaction related to this inbound shipment. | |
| totalunitcost | Decimal | The complete cost per unit of the item, including any additional landed costs such as shipping, duties, and taxes. | |
| unit | String | The unit of measure for this inbound shipment item, such as pieces, kilograms, or cartons. | |
| unitlandedcost | Decimal | The total landed cost per unit of this item, incorporating base cost, freight, duties, and other applicable charges. |