OnhandQuantityDetailsConsignedQuantityDetails
OnhandQuantityDetailsConsignedQuantityDetails
Columns
Name | Type | Description |
OnhandQuantityDetailsInventoryItemId [KEY] | Long | OnhandQuantityDetailsInventoryItemId of OnhandQuantityDetailsConsignedQuantityDetails |
OnhandQuantityDetailsLocatorId [KEY] | Long | OnhandQuantityDetailsLocatorId of OnhandQuantityDetailsConsignedQuantityDetails |
OnhandQuantityDetailsLotNumber [KEY] | String | OnhandQuantityDetailsLotNumber of OnhandQuantityDetailsConsignedQuantityDetails |
OnhandQuantityDetailsOrganizationId [KEY] | Long | OnhandQuantityDetailsOrganizationId of OnhandQuantityDetailsConsignedQuantityDetails |
OnhandQuantityDetailsSerialNumber [KEY] | String | OnhandQuantityDetailsSerialNumber of OnhandQuantityDetailsConsignedQuantityDetails |
OnhandQuantityDetailsSubinventoryCode [KEY] | String | OnhandQuantityDetailsSubinventoryCode of OnhandQuantityDetailsConsignedQuantityDetails |
ConsignedQuantity | Double | ConsignedQuantity of OnhandQuantityDetailsConsignedQuantityDetails |
SecondaryConsignedQuantity | Double | SecondaryConsignedQuantity of OnhandQuantityDetailsConsignedQuantityDetails |
PartyName [KEY] | String | PartyName of OnhandQuantityDetailsConsignedQuantityDetails |
PartyType [KEY] | String | PartyType of OnhandQuantityDetailsConsignedQuantityDetails |
PartyNumber [KEY] | String | PartyNumber of OnhandQuantityDetailsConsignedQuantityDetails |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
InventoryItemId | Long | InventoryItemId |
LocatorId | Long | LocatorId |
LotNumber | String | LotNumber |
OrganizationId | Long | OrganizationId |
SerialNumber | String | SerialNumber |
SubinventoryCode | String | SubinventoryCode |
Finder | String | finder |