InventoryOnhandBalanceslotsinventoryTrackingAttributes
InventoryOnhandBalanceslotsinventoryTrackingAttributes
Columns
| Name | Type | Description |
| InventoryOnhandBalancesInventoryItemId [KEY] | Long | InventoryOnhandBalancesInventoryItemId of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| InventoryOnhandBalancesLocatorId [KEY] | Long | InventoryOnhandBalancesLocatorId of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| InventoryOnhandBalancesOrganizationId [KEY] | Long | InventoryOnhandBalancesOrganizationId of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| InventoryOnhandBalancesOwningPartySiteId [KEY] | Long | InventoryOnhandBalancesOwningPartySiteId of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| InventoryOnhandBalancesRevision [KEY] | String | InventoryOnhandBalancesRevision of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| InventoryOnhandBalancesSubinventoryCode [KEY] | String | InventoryOnhandBalancesSubinventoryCode of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| InventoryOnhandBalancesSubinventoryGroup [KEY] | String | InventoryOnhandBalancesSubinventoryGroup of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| InventoryOnhandBalancesSummaryLevel [KEY] | String | InventoryOnhandBalancesSummaryLevel of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| LotsLotNumber [KEY] | String | LotsLotNumber of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| LotsOwningPartySiteId [KEY] | Long | LotsOwningPartySiteId of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| InventoryProjectId [KEY] | Long | InventoryProjectId of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| InventoryTaskId [KEY] | Long | InventoryTaskId of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| CountryOfOriginCode [KEY] | String | CountryOfOriginCode of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| PrimaryQuantity | Double | PrimaryQuantity of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| ConsignedQuantity | Double | ConsignedQuantity of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| InventoryProject | String | InventoryProject of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| InventoryTask | String | InventoryTask of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
| CountryOfOrigin | String | CountryOfOrigin of InventoryOnhandBalanceslotsinventoryTrackingAttributes |
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 |