ShipmentTransactionRequestsshipmentsunpackedLines
ShipmentTransactionRequestsshipmentsunpackedLines
Columns
| Name | Type | Description |
| ShipmentTransactionRequestsTransactionId [KEY] | Long | ShipmentTransactionRequestsTransactionId of ShipmentTransactionRequestsshipmentsunpackedLines |
| ShipmentsDeliveryInterfaceId [KEY] | Long | ShipmentsDeliveryInterfaceId of ShipmentTransactionRequestsshipmentsunpackedLines |
| DeliveryDetailInterfaceId [KEY] | Long | DeliveryDetailInterfaceId of ShipmentTransactionRequestsshipmentsunpackedLines |
| ShipmentLine | Long | Value that uniquely identifies the shipment line. |
| Item | String | Name of the item. |
| ItemRevision | String | Revision of the item. |
| Subinventory | String | Subinventory to use when fulfilling the item to be shipped. |
| Locator | String | Concatenated name of the inventory locator that provides the source for material that ships. |
| ShippedQuantity | Double | Shipped quantity. |
| ShippedQuantityUOMCode | String | Code that identifies the unit of measure for the shipped quantity. |
| ShippedQuantityUOM | String | Unit of measure for the shipped quantity. |
| SecondaryShippedQuantity | Double | Shipped quantity, in the secondary unit of measure. |
| SecondaryShippedQuantityUOMCode | String | Code that identifies the secondary unit of measure for the shipped quantity. |
| SecondaryShippedQuantityUOM | String | Secondary unit of measure for the shipped quantity. |
| NetWeight | Double | Net weight of the shipment line. |
| GrossWeight | Double | Gross weight of the shipment line. |
| WeightUOMCode | String | Code that identifies the unit of measure for the weight of the shipment line. |
| WeightUOM | String | Unit of measure for the weight of the shipment line. |
| Volume | Double | Volume of the shipment line. |
| VolumeUOMCode | String | Code that identifies the unit of measure for the volume of the shipment line. |
| VolumeUOM | String | Unit of measure for the volume of the shipment line. |
| LoadingSequence | Double | Sequence to use when loading the shipment line. |
| TaxationCountry | String | Country where the transaction occurs. The tax authority uses this attribute for taxation purposes. |
| TransactionBusinessCategory | String | Name of the business classification. Oracle Fusion Tax uses this value to identify and categorize each transaction that resides outside of Oracle Fusion Tax into a transaction that resides inside Oracle Fusion Tax. |
| DocumentFiscalClassification | String | Document fiscal classification. |
| UserDefinedFiscalClassificationCode | String | Abbreviation that identifies the classification for each tax requirement that you cannot define using the fiscal classification types that already exist. |
| ProductFiscalClassification | String | Product fiscal classification of the transaction line. |
| IntendedUse | String | Name of the intended use classification. |
| ProductCategory | String | Product category of the transaction line. |
| LocationOfFinalDischargeCode | String | Abbreviation that identifies the final discharge location. |
| TaxClassificationCode | String | Abbreviation that identifies a group of taxes for reporting and processing. The tax authority uses this attribute for taxation purposes. |
| ProductTypeCode | String | Abbreviation that identifies the product type of the inventory item. |
| FirstPartyTaxRegistrationNumber | String | Number that identifies tax registration for the first party of the transaction. The tax authority uses this attribute for taxation purposes. |
| ThirdPartyTaxRegistrationNumber | String | Number that identifies tax registration for the third party of the transaction. The tax authority uses this attribute for taxation purposes. |
| TaxInvoiceNumber | String | Number of the tax invoice that you use to meet tax reporting that different countries require. |
| TaxInvoiceDate | Date | Date and time of the tax invoice that you use to meet tax reporting that different countries require. |
| AssessableValue | Double | Value of the item. Each tax authority can use a different assessable value for each item. The tax authority uses this attribute for taxation purposes. |
| TaxExemptionCertificateNumber | String | Number that identifies the certificate for tax exemption. The tax authority uses this attribute for taxation purposes. |
| TaxExemptionReasonCode | String | Abbreviation that identifies the reason for tax exemption. The tax authority uses this attribute for taxation purposes. |
| Order | String | Order of ShipmentTransactionRequestsshipmentsunpackedLines |
| SoldToCustomer | String | SoldToCustomer of ShipmentTransactionRequestsshipmentsunpackedLines |
| CreatedBy | String | CreatedBy of ShipmentTransactionRequestsshipmentsunpackedLines |
| CreationDate | Datetime | CreationDate of ShipmentTransactionRequestsshipmentsunpackedLines |
| LastUpdatedBy | String | LastUpdatedBy of ShipmentTransactionRequestsshipmentsunpackedLines |
| LastUpdateDate | Datetime | LastUpdateDate of ShipmentTransactionRequestsshipmentsunpackedLines |
| RequestedQuantityToConsume | Double | Requested quantity to consume for this shipment for the shipment line. This attribute is associated with a feature that requires opt in. |
| QuantityToBackorder | Double | Quantity requested to be back ordered for the shipment line. This attribute is associated with a feature that requires opt in. |
| TrackingNumber | String | Tracking number of the shipment line. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Carrier | String | Carrier |
| ExternalSystemTransactionReference | String | ExternalSystemTransactionReference |
| FromActualShipDate | Datetime | FromActualShipDate |
| FromInitialShipDate | Datetime | FromInitialShipDate |
| ModeOfTransportCode | String | ModeOfTransportCode |
| PackingUnit | String | PackingUnit |
| ServiceLevelCode | String | ServiceLevelCode |
| ShipFromOrganizationCode | String | ShipFromOrganizationCode |
| Shipment | String | Shipment |
| ToActualShipDate | Datetime | ToActualShipDate |
| ToInitialShipDate | Datetime | ToInitialShipDate |
| TransactionId | Long | TransactionId |
| Finder | String | finder |