JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

SalesOrdersForOrderHublineslotSerials

SalesOrdersForOrderHublineslotSerials

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublineslotSerials
LinesFulfillLineId [KEY] Long LinesFulfillLineId of SalesOrdersForOrderHublineslotSerials
ItemRevisionNumber String Value that identifies the item revision.
ItemSerialNumberFrom String Starting serial number of a range of serial numbers.
ItemSerialNumberTo String Ending serial number of a range of serial numbers.
LocatorId Long Locator where the application ships or receives the item.
LotNumber String Identifies the quantity for the item.
LotSerialId [KEY] Long LotSerialId of SalesOrdersForOrderHublineslotSerials
SourceLotSerialId String Value that uniquely identifies the lot and serial. The source application assigns this value.
Quantity Double Quantity of lots and serials.
SecondaryQuantity Double SecondaryQuantity of SalesOrdersForOrderHublineslotSerials
Locator String Concatenated segments for the locator flexfields from where the item is shipped from or received into.
DeletedFlag Bool Contains one of the following values: true or false. If true, then lot and serial lines are deleted during the patch or upsert operation. If false, then lot and serial lines are not deleted. This is a transient attribute. Use this attribute only on an order line that includes an inventory transaction. This attribute does not have a default value.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
FromDate Date FromDate
HeaderId String HeaderId
OrderKey String OrderKey
OrderNumber String OrderNumber
SourceTransactionNumber String SourceTransactionNumber
SourceTransactionSystem String SourceTransactionSystem
ToDate Date ToDate
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839