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