ShipmentTransactionRequestsshipmentsouterPackingUnitspackedLines
Tracks shipment lines that have been packed within a specific packing unit, ensuring accurate mapping and organization.
Columns
| Name | Type | 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 | Unique identifier for a specific shipment line in the packed unit. |
| Item | String | 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 | Order number associated with the shipment line. |
| SoldToCustomer | String | 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 | Carrier responsible for transporting the packed line shipment. |
| ExternalSystemTransactionReference | String | Reference to the transaction in an external system. |
| Finder | String | Searchable reference field for locating the packed line transaction. |
| FromActualShipDate | Datetime | Start date range for the actual shipment date of the packed line. |
| FromInitialShipDate | Datetime | Start date range for the initially planned shipment date. |
| ModeOfTransportCode | String | Code representing the mode of transport (for example, air, sea, land). |
| PackingUnit | String | Packing unit associated with the packed line shipment. |
| ServiceLevelCode | String | Code representing the shipping service level (for example, standard, express). |
| ShipFromOrganizationCode | String | Code identifying the organization shipping the packed line. |
| Shipment | String | Shipment identifier for the packed line transaction. |
| ToActualShipDate | Datetime | End date range for the actual shipment date of the packed line. |
| ToInitialShipDate | Datetime | End date range for the initially planned shipment date. |
| TransactionId | Long | Unique transaction ID linking this packed line data to the shipment transaction request. |