InventoryOnhandBalancesinventoryTrackingAttributes
InventoryOnhandBalancesinventoryTrackingAttributes
Columns
| Name | Type | Description |
| InventoryOnhandBalancesInventoryItemId [KEY] | Long | InventoryOnhandBalancesInventoryItemId of InventoryOnhandBalancesinventoryTrackingAttributes |
| InventoryOnhandBalancesLocatorId [KEY] | Long | InventoryOnhandBalancesLocatorId of InventoryOnhandBalancesinventoryTrackingAttributes |
| InventoryOnhandBalancesOrganizationId [KEY] | Long | InventoryOnhandBalancesOrganizationId of InventoryOnhandBalancesinventoryTrackingAttributes |
| InventoryOnhandBalancesOwningPartySiteId [KEY] | Long | InventoryOnhandBalancesOwningPartySiteId of InventoryOnhandBalancesinventoryTrackingAttributes |
| InventoryOnhandBalancesRevision [KEY] | String | InventoryOnhandBalancesRevision of InventoryOnhandBalancesinventoryTrackingAttributes |
| InventoryOnhandBalancesSubinventoryCode [KEY] | String | InventoryOnhandBalancesSubinventoryCode of InventoryOnhandBalancesinventoryTrackingAttributes |
| InventoryOnhandBalancesSubinventoryGroup [KEY] | String | InventoryOnhandBalancesSubinventoryGroup of InventoryOnhandBalancesinventoryTrackingAttributes |
| InventoryOnhandBalancesSummaryLevel [KEY] | String | InventoryOnhandBalancesSummaryLevel of InventoryOnhandBalancesinventoryTrackingAttributes |
| InventoryProjectId [KEY] | Long | InventoryProjectId of InventoryOnhandBalancesinventoryTrackingAttributes |
| InventoryTaskId [KEY] | Long | InventoryTaskId of InventoryOnhandBalancesinventoryTrackingAttributes |
| CountryOfOriginCode [KEY] | String | CountryOfOriginCode of InventoryOnhandBalancesinventoryTrackingAttributes |
| PrimaryQuantity | Double | PrimaryQuantity of InventoryOnhandBalancesinventoryTrackingAttributes |
| ConsignedQuantity | Double | ConsignedQuantity of InventoryOnhandBalancesinventoryTrackingAttributes |
| InventoryProject | String | InventoryProject of InventoryOnhandBalancesinventoryTrackingAttributes |
| InventoryTask | String | InventoryTask of InventoryOnhandBalancesinventoryTrackingAttributes |
| CountryOfOrigin | String | CountryOfOrigin of InventoryOnhandBalancesinventoryTrackingAttributes |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| InventoryItemId | Long | InventoryItemId |
| LocatorId | Long | LocatorId |
| OrganizationId | Long | OrganizationId |
| OwningPartySiteId | Long | OwningPartySiteId |
| Revision | String | Revision |
| SubinventoryCode | String | SubinventoryCode |
| SubinventoryGroup | String | SubinventoryGroup |
| SummaryLevel | String | SummaryLevel |
| Finder | String | finder |