OnHandLotUOMConvRecords
Returns on-hand balances with lot primary and secondary quantities by subinventory, including conversion history and transaction details.
Columns
| Name | Type | SupportedFinders | Description |
| LotConversionId [KEY] | Long | PrimaryKey | The value that uniquely identifies the lot conversion record. |
| OnhandConvHistoryId [KEY] | Long | PrimaryKey | The value that uniquely identifies the on-hand conversion history record. |
| OnhandUpdateType | Decimal | The on-hand update type. | |
| LotNumber | String | The number that identifies the lot. | |
| Revision | String | The revision of the item. | |
| InventoryItemId | Long | The value that uniquely identifies the inventory item. | |
| OrganizationId | Long | The value that uniquely identifies the organization. | |
| SubinventoryCode | String | The code of the subinventory. | |
| LicensePlateNumberId | Decimal | The value that uniquely identifies the license plate number. | |
| LocatorId | Decimal | The value that uniquely identifies the locator. | |
| LocatorName | String | The name of the locator. | |
| ProjectId | Decimal | The value that uniquely identifies the project. | |
| ProjectNumber | String | The number of the project. | |
| TaskId | Decimal | The value that uniquely identifies the task. | |
| TaskNumber | String | The number of the task. | |
| CountryOfOrigin | String | The code of the country of origin. | |
| CountryOfOriginName | String | The name of the country of origin. | |
| OldPrimaryQuantity | Decimal | The primary quantity of the lot before the latest lot-specific unit of measure conversion rate. | |
| OldSecondaryQuantity | Decimal | The secondary quantity of the lot before the latest lot-specific unit of measure conversion rate. | |
| NewPrimaryQuantity | Decimal | The new primary quantity of the lot from the latest lot-specific unit of measure conversion rate. | |
| NewSecondaryQuantity | Decimal | The new secondary quantity of the lot from the latest lot-specific unit of measure conversion rate. | |
| TransactionPrimaryQuantity | Decimal | The primary quantity of the transaction. | |
| TransactionSecondaryQuantity | Decimal | The secondary quantity of the transaction. | |
| TransactionUpdateControl | String | Specifies whether the transaction has been updated. | |
| CreatedBy | String | The user who created the record. | |
| CreationDate | Datetime | The date when the record was created. | |
| LastUpdatedBy | String | The user who last updated the record. | |
| LastUpdateDate | Datetime | The date of the last update to the record. | |
| LastUpdateLogin | String | The login of the user who last updated the record. | |
| LicensePlateNumber | String | The license plate number. | |
| OrganizationName | String | The name of the organization. | |
| OwningEntityId | Long | The value that uniquely identifies the entity that holds ownership of the on-hand material. | |
| SupplierName | String | The name of the supplier. | |
| SupplierSite | String | The site of the supplier. | |
| OnhandUpdateTypeMeaning | String | The meaning of the on-hand update type. | |
| SubinventoryName | String | The name of the subinventory. | |
| BindInventoryItemId | Long | FindByTypeOrgItemLot | The unique identifier for the inventory item, used with the Finder column. |
| BindLotNumber | String | FindByTypeOrgItemLot | The unique identifier for the lot, used with the Finder column. |
| BindOnhandUpdateType | Long | FindByTypeOrgItemLot | The unique identifier for the method used to update on-hand balances, used with the Finder column. |
| BindOrganizationId | Long | FindByTypeOrgItemLot | The unique identifier for the organization, used with the Finder column. |
| Finder | String | The name of the finder method used to search and filter records. |