JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

SalesOrdersForOrderHublineslotSerials

The Lot Serials resource manages the lot serial details for returns and inventory transaction order lines.

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 Decimal Quantity of lots and serials.
SecondaryQuantity Decimal 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.
Finder String Finder of SalesOrdersForOrderHublineslotSerials
FromDate Date FromDate of SalesOrdersForOrderHublineslotSerials
HeaderId Long HeaderId of SalesOrdersForOrderHublineslotSerials
OrderKey String OrderKey of SalesOrdersForOrderHublineslotSerials
OrderNumber String OrderNumber of SalesOrdersForOrderHublineslotSerials
SourceTransactionNumber String SourceTransactionNumber of SalesOrdersForOrderHublineslotSerials
SourceTransactionSystem String SourceTransactionSystem of SalesOrdersForOrderHublineslotSerials
ToDate Date ToDate of SalesOrdersForOrderHublineslotSerials

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