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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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 |