OnhandQuantityDetails
OnhandQuantityDetails
Columns
| Name | Type | Description |
| OrganizationId [KEY] | Long | OrganizationId of OnhandQuantityDetails |
| OrganizationCode | String | OrganizationCode of OnhandQuantityDetails |
| InventoryItemId [KEY] | Long | InventoryItemId of OnhandQuantityDetails |
| ItemNumber | String | ItemNumber of OnhandQuantityDetails |
| SubinventoryCode [KEY] | String | SubinventoryCode of OnhandQuantityDetails |
| LocatorId [KEY] | Long | LocatorId of OnhandQuantityDetails |
| LotNumber [KEY] | String | LotNumber of OnhandQuantityDetails |
| OnhandQuantity | Double | OnhandQuantity of OnhandQuantityDetails |
| SecondaryOnhandQuantity | Long | SecondaryOnhandQuantity of OnhandQuantityDetails |
| ReceivingQuantity | Double | ReceivingQuantity of OnhandQuantityDetails |
| SecondaryReceivingQuantity | Double | SecondaryReceivingQuantity of OnhandQuantityDetails |
| ReservedQuantity | Double | ReservedQuantity of OnhandQuantityDetails |
| SecondaryReservedQuantity | Double | SecondaryReservedQuantity of OnhandQuantityDetails |
| InboundQuantity | Double | InboundQuantity of OnhandQuantityDetails |
| SecondaryInboundQuantity | Double | SecondaryInboundQuantity of OnhandQuantityDetails |
| ConsignedQuantity | Double | ConsignedQuantity of OnhandQuantityDetails |
| SecondaryConsignedQuantity | Double | SecondaryConsignedQuantity of OnhandQuantityDetails |
| OwningOrganizationId | Long | OwningOrganizationId of OnhandQuantityDetails |
| OwningOrganization | String | OwningOrganization of OnhandQuantityDetails |
| SerialNumber [KEY] | String | SerialNumber of OnhandQuantityDetails |
| PrimaryUOMCode | String | PrimaryUOMCode of OnhandQuantityDetails |
| SecondaryUOMCode | String | SecondaryUOMCode of OnhandQuantityDetails |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |