InventoryOnhandBalanceslotslotSerials
InventoryOnhandBalanceslotslotSerials
Columns
| Name | Type | Description |
| InventoryOnhandBalancesInventoryItemId [KEY] | Long | InventoryOnhandBalancesInventoryItemId of InventoryOnhandBalanceslotslotSerials |
| InventoryOnhandBalancesLocatorId [KEY] | Long | InventoryOnhandBalancesLocatorId of InventoryOnhandBalanceslotslotSerials |
| InventoryOnhandBalancesOrganizationId [KEY] | Long | InventoryOnhandBalancesOrganizationId of InventoryOnhandBalanceslotslotSerials |
| InventoryOnhandBalancesOwningPartySiteId [KEY] | Long | InventoryOnhandBalancesOwningPartySiteId of InventoryOnhandBalanceslotslotSerials |
| InventoryOnhandBalancesRevision [KEY] | String | InventoryOnhandBalancesRevision of InventoryOnhandBalanceslotslotSerials |
| InventoryOnhandBalancesSubinventoryCode [KEY] | String | InventoryOnhandBalancesSubinventoryCode of InventoryOnhandBalanceslotslotSerials |
| InventoryOnhandBalancesSubinventoryGroup [KEY] | String | InventoryOnhandBalancesSubinventoryGroup of InventoryOnhandBalanceslotslotSerials |
| InventoryOnhandBalancesSummaryLevel [KEY] | String | InventoryOnhandBalancesSummaryLevel of InventoryOnhandBalanceslotslotSerials |
| LotsLotNumber [KEY] | String | LotsLotNumber of InventoryOnhandBalanceslotslotSerials |
| LotsOwningPartySiteId [KEY] | Long | LotsOwningPartySiteId of InventoryOnhandBalanceslotslotSerials |
| SerialNumber [KEY] | String | SerialNumber of InventoryOnhandBalanceslotslotSerials |
| MaterialStatusId | Long | MaterialStatusId of InventoryOnhandBalanceslotslotSerials |
| InventoryProjectId [KEY] | Long | InventoryProjectId of InventoryOnhandBalanceslotslotSerials |
| InventoryTaskId [KEY] | Long | InventoryTaskId of InventoryOnhandBalanceslotslotSerials |
| CountryOfOriginCode [KEY] | String | CountryOfOriginCode of InventoryOnhandBalanceslotslotSerials |
| OwningPartySiteId [KEY] | Long | OwningPartySiteId of InventoryOnhandBalanceslotslotSerials |
| MaterialStatus | String | MaterialStatus of InventoryOnhandBalanceslotslotSerials |
| OwningPartySite | String | OwningPartySite of InventoryOnhandBalanceslotslotSerials |
| OwningPartyId | Long | OwningPartyId of InventoryOnhandBalanceslotslotSerials |
| OwningParty | String | OwningParty of InventoryOnhandBalanceslotslotSerials |
| InventoryProject | String | InventoryProject of InventoryOnhandBalanceslotslotSerials |
| InventoryTask | String | InventoryTask of InventoryOnhandBalanceslotslotSerials |
| CountryOfOrigin | String | CountryOfOrigin of InventoryOnhandBalanceslotslotSerials |
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 |