InventoryOnhandBalanceslots
InventoryOnhandBalanceslots
Columns
Name | Type | Description |
InventoryOnhandBalancesInventoryItemId [KEY] | Long | InventoryOnhandBalancesInventoryItemId of InventoryOnhandBalanceslots |
InventoryOnhandBalancesLocatorId [KEY] | Long | InventoryOnhandBalancesLocatorId of InventoryOnhandBalanceslots |
InventoryOnhandBalancesOrganizationId [KEY] | Long | InventoryOnhandBalancesOrganizationId of InventoryOnhandBalanceslots |
InventoryOnhandBalancesOwningPartySiteId [KEY] | Long | InventoryOnhandBalancesOwningPartySiteId of InventoryOnhandBalanceslots |
InventoryOnhandBalancesRevision [KEY] | String | InventoryOnhandBalancesRevision of InventoryOnhandBalanceslots |
InventoryOnhandBalancesSubinventoryCode [KEY] | String | InventoryOnhandBalancesSubinventoryCode of InventoryOnhandBalanceslots |
InventoryOnhandBalancesSubinventoryGroup [KEY] | String | InventoryOnhandBalancesSubinventoryGroup of InventoryOnhandBalanceslots |
InventoryOnhandBalancesSummaryLevel [KEY] | String | InventoryOnhandBalancesSummaryLevel of InventoryOnhandBalanceslots |
LotNumber [KEY] | String | LotNumber of InventoryOnhandBalanceslots |
PrimaryQuantity | Double | PrimaryQuantity of InventoryOnhandBalanceslots |
OwningPartySiteId [KEY] | Long | OwningPartySiteId of InventoryOnhandBalanceslots |
OwningPartyType | String | OwningPartyType of InventoryOnhandBalanceslots |
OwningPartyId | Double | OwningPartyId of InventoryOnhandBalanceslots |
OwningParty | String | OwningParty of InventoryOnhandBalanceslots |
OwningPartySite | String | OwningPartySite of InventoryOnhandBalanceslots |
MaterialStatusId | Long | MaterialStatusId of InventoryOnhandBalanceslots |
MaterialStatus | String | MaterialStatus of InventoryOnhandBalanceslots |
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 |
InventoryItemId | Long | InventoryItemId |
LocatorId | Long | LocatorId |
OrganizationId | Long | OrganizationId |
Revision | String | Revision |
SubinventoryCode | String | SubinventoryCode |
SubinventoryGroup | String | SubinventoryGroup |
SummaryLevel | String | SummaryLevel |
Finder | String | finder |