ShipmentTransactionRequestsshipmentsunpackedLines
Maintains information about shipment lines that remain unpacked, providing insight into pending packing tasks.
Columns
| Name | Type | SupportedFinders | Description |
| ShipmentTransactionRequestsTransactionId [KEY] | Long | Unique identifier for the shipment transaction request related to unpacked shipment lines. | |
| ShipmentsDeliveryInterfaceId [KEY] | Long | Identifier for the interface managing shipment delivery in the transaction request. | |
| DeliveryDetailInterfaceId [KEY] | Long | Unique identifier for the shipment delivery detail. | |
| ShipmentLine | Long | FindByAttributes | Unique identifier for a specific shipment line. |
| Item | String | FindByAttributes | Name of the item included in the shipment. |
| ItemRevision | String | Revision number of the item being shipped. | |
| Subinventory | String | Subinventory used to fulfill the shipment item. | |
| Locator | String | Concatenated inventory locator name for material sourcing. | |
| ShippedQuantity | Decimal | Total quantity of the item shipped. | |
| ShippedQuantityUOMCode | String | Code representing the unit of measure (UOM) for the shipped quantity. | |
| ShippedQuantityUOM | String | UOM for the shipped quantity. | |
| SecondaryShippedQuantity | Decimal | Shipped quantity in the secondary UOM. | |
| SecondaryShippedQuantityUOMCode | String | Code representing the secondary UOM. | |
| SecondaryShippedQuantityUOM | String | Secondary UOM for the shipped quantity. | |
| NetWeight | Decimal | Net weight of the shipment line, excluding packaging. | |
| GrossWeight | Decimal | Gross weight of the shipment line, including packaging. | |
| WeightUOMCode | String | Code representing the UOM for weight. | |
| WeightUOM | String | UOM for the weight of the shipment line. | |
| Volume | Decimal | Volume occupied by the shipment line. | |
| VolumeUOMCode | String | Code representing the UOM for volume. | |
| VolumeUOM | String | UOM for the shipment line's volume. | |
| LoadingSequence | Decimal | Loading sequence number for arranging shipment lines. | |
| TaxationCountry | String | Country where the transaction occurs for tax purposes. | |
| TransactionBusinessCategory | String | Business classification for tax processing in Oracle Fusion Tax. | |
| DocumentFiscalClassification | String | Fiscal classification for tax reporting. | |
| UserDefinedFiscalClassificationCode | String | User-defined tax classification code. | |
| ProductFiscalClassification | String | Product fiscal classification for tax calculations. | |
| IntendedUse | String | Intended use classification for the shipment item. | |
| ProductCategory | String | Product category of the shipment item. | |
| LocationOfFinalDischargeCode | String | Code identifying the final discharge location. | |
| TaxClassificationCode | String | Code identifying a group of applicable taxes. | |
| ProductTypeCode | String | Code specifying the product type for inventory classification. | |
| FirstPartyTaxRegistrationNumber | String | Tax registration number of the first party in the transaction. | |
| ThirdPartyTaxRegistrationNumber | String | Tax registration number of the third party in the transaction. | |
| TaxInvoiceNumber | String | Tax invoice number issued for tax compliance. | |
| TaxInvoiceDate | Date | Date the tax invoice was issued. | |
| AssessableValue | Decimal | Value of the item for tax assessment. | |
| TaxExemptionCertificateNumber | String | Certificate number proving tax exemption. | |
| TaxExemptionReasonCode | String | Code representing the reason for tax exemption. | |
| Order | String | FindByAttributes | Order number associated with the shipment. |
| SoldToCustomer | String | FindByAttributes | Customer to whom the shipment is sold. |
| CreatedBy | String | User who created the shipment record. | |
| CreationDate | Datetime | Date and time the shipment record was created. | |
| LastUpdatedBy | String | User who last updated the shipment record. | |
| LastUpdateDate | Datetime | Date and time the shipment record was last updated. | |
| RequestedQuantityToConsume | Decimal | Requested quantity to be consumed for the shipment line. | |
| QuantityToBackorder | Decimal | Quantity requested for backorder. | |
| TrackingNumber | String | Tracking number assigned to the shipment line. | |
| Carrier | String | FindByAttributes | Carrier responsible for transporting the shipment. |
| ExternalSystemTransactionReference | String | FindByAttributes | Reference for the transaction in an external system. |
| Finder | String | Searchable reference field for locating shipment records. | |
| FromActualShipDate | Datetime | FindByAttributes | Start date range for actual shipment. |
| FromInitialShipDate | Datetime | FindByAttributes | Start date range for initially planned shipment. |
| ModeOfTransportCode | String | FindByAttributes | Code representing the mode of transport (for example, air, sea, land). |
| PackingUnit | String | FindByAttributes | Packing unit for the shipment. |
| ServiceLevelCode | String | FindByAttributes | Code representing the shipping service level. |
| ShipFromOrganizationCode | String | FindByAttributes | Code identifying the shipping organization. |
| Shipment | String | FindByAttributes | Unique identifier for the shipment. |
| ToActualShipDate | Datetime | FindByAttributes | End date range for actual shipment. |
| ToInitialShipDate | Datetime | FindByAttributes | End date range for initially planned shipment. |
| TransactionId | Long | PrimaryKey | Unique transaction ID linking this shipment to the transaction request. |