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