ShipmentTransactionRequestsshipmentsouterPackingUnitspackedLines
Tracks shipment lines that have been packed within a specific packing unit, ensuring accurate mapping and organization.
Columns
| Name | Type | SupportedFinders | Description |
| ShipmentTransactionRequestsTransactionId [KEY] | Long | Unique identifier for the shipment transaction request related to packed lines in an outer packing unit. | |
| ShipmentsDeliveryInterfaceId [KEY] | Long | Identifier for the interface managing shipment delivery within the transaction request. | |
| OuterpackingunitsLPNInterfaceId [KEY] | Long | Unique identifier for the outer packing unit’s License Plate Number (LPN) in the shipment. | |
| DeliveryDetailInterfaceId [KEY] | Long | Identifier for the delivery detail interface associated with the packed line. | |
| ShipmentLine | Long | FindByAttributes | Unique identifier for a specific shipment line in the packed unit. |
| Item | String | FindByAttributes | Name of the item being shipped in the packed line. |
| ItemRevision | String | Version or revision of the item being shipped. | |
| Subinventory | String | Subinventory location used for fulfilling the shipment of the item. | |
| Locator | String | Concatenated inventory locator name that provides the source for shipped material. | |
| ShippedQuantity | Decimal | Total quantity of the item shipped in this packed line. | |
| ShippedQuantityUOMCode | String | Code representing the unit of measure (UOM) for the shipped quantity. | |
| ShippedQuantityUOM | String | UOM used to represent the shipped quantity. | |
| SecondaryShippedQuantity | Decimal | Quantity shipped in an alternate or secondary UOM. | |
| SecondaryShippedQuantityUOMCode | String | Code for the secondary UOM for the shipped quantity. | |
| SecondaryShippedQuantityUOM | String | Secondary UOM for the shipped quantity. | |
| NetWeight | Decimal | Net weight of the shipment line without packaging. | |
| GrossWeight | Decimal | Total weight of the shipment line including packaging. | |
| WeightUOMCode | String | Code for the UOM used for the shipment line's weight. | |
| WeightUOM | String | UOM representing the shipment line's weight. | |
| Volume | Decimal | Volume of the shipment line. | |
| VolumeUOMCode | String | Code for the UOM used for volume. | |
| VolumeUOM | String | UOM representing the shipment line's volume. | |
| LoadingSequence | Decimal | Sequence number determining the order of loading for the shipment line. | |
| TaxationCountry | String | Country where the transaction occurs, relevant for tax calculations. | |
| TransactionBusinessCategory | String | Business classification used in Oracle Fusion Tax for tax categorization. | |
| DocumentFiscalClassification | String | Fiscal classification of the document used for tax reporting. | |
| UserDefinedFiscalClassificationCode | String | User-defined code representing classification for tax requirements. | |
| ProductFiscalClassification | String | Fiscal classification of the product for tax purposes. | |
| IntendedUse | String | Intended use classification for the shipped item. | |
| ProductCategory | String | Category assigned to the product for transaction processing. | |
| LocationOfFinalDischargeCode | String | Code identifying the final discharge location of the shipment. | |
| TaxClassificationCode | String | Code representing a predefined group of taxes for reporting and processing. | |
| ProductTypeCode | String | Code representing the product type of the inventory item. | |
| 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 | Invoice number used for tax compliance and reporting. | |
| TaxInvoiceDate | Date | Date and time when the tax invoice was issued. | |
| AssessableValue | Decimal | Tax assessable value of the item, used by tax authorities. | |
| TaxExemptionCertificateNumber | String | Certificate number for tax exemption, if applicable. | |
| TaxExemptionReasonCode | String | Code specifying the reason for tax exemption. | |
| Order | String | FindByAttributes | Order number associated with the shipment line. |
| SoldToCustomer | String | FindByAttributes | Customer to whom the shipment is sold. |
| CreatedBy | String | User who created the shipment transaction request for the packed line. | |
| CreationDate | Datetime | Timestamp indicating when the packed line transaction was created. | |
| LastUpdatedBy | String | User who last updated the shipment transaction for the packed line. | |
| LastUpdateDate | Datetime | Timestamp of the most recent update to the packed line transaction. | |
| RequestedQuantityToConsume | Decimal | Quantity of the item requested for consumption in this shipment. | |
| QuantityToBackorder | Decimal | Quantity of the item requested to be backordered for this shipment. | |
| TrackingNumber | String | Tracking number assigned to the packed line's shipment. | |
| Attachments | String | Reference to attachments associated with the packed line. | |
| Costs | String | Reference to cost details related to the packed line shipment. | |
| Errors | String | Errors encountered during the processing of the packed line. | |
| DFF | String | DFF used for additional custom attributes in the packed line. | |
| Lots | String | Details of lot numbers associated with the packed line shipment. | |
| Notes | String | Notes or comments related to the packed line shipment. | |
| Serials | String | Serial number details associated with the packed line items. | |
| Carrier | String | FindByAttributes | Carrier responsible for transporting the packed line shipment. |
| ExternalSystemTransactionReference | String | FindByAttributes | Reference to the transaction in an external system. |
| Finder | String | Searchable reference field for locating the packed line transaction. | |
| FromActualShipDate | Datetime | FindByAttributes | Start date range for the actual shipment date of the packed line. |
| FromInitialShipDate | Datetime | FindByAttributes | Start date range for the initially planned shipment date. |
| ModeOfTransportCode | String | FindByAttributes | Code representing the mode of transport (for example, air, sea, land). |
| PackingUnit | String | FindByAttributes | Packing unit associated with the packed line shipment. |
| ServiceLevelCode | String | FindByAttributes | Code representing the shipping service level (for example, standard, express). |
| ShipFromOrganizationCode | String | FindByAttributes | Code identifying the organization shipping the packed line. |
| Shipment | String | FindByAttributes | Shipment identifier for the packed line transaction. |
| ToActualShipDate | Datetime | FindByAttributes | End date range for the actual shipment date of the packed line. |
| ToInitialShipDate | Datetime | FindByAttributes | End date range for the initially planned shipment date. |
| TransactionId | Long | PrimaryKey | Unique transaction ID linking this packed line data to the shipment transaction request. |