InventoryStagedTransactionslots
InventoryStagedTransactionslots
Columns
| Name | Type | Description |
| InventoryStagedTransactionsTransactionInterfaceId [KEY] | Long | InventoryStagedTransactionsTransactionInterfaceId of InventoryStagedTransactionslots |
| TransactionInterfaceId [KEY] | Long | Value that uniquely identifies the transaction. |
| LotNumber [KEY] | String | Lot number for the item. |
| TransactionQuantity | Double | Transaction quantity of the item. |
| PrimaryQuantity | Double | Transaction quantity in the primary unit of measure that the item uses. |
| LotExpirationDate | Date | Date and time when the lot expires. |
| ExpirationActionCode | String | Abbreviation that identifies the expiration action. |
| ExpirationActionDate | Date | Date when the expiration action was performed. |
| ExpirationActionName | String | Name of the expiration action. |
| OriginationDate | Date | Date when the warehouse created the lot. |
| OriginationType | String | Type of origination for the lot. |
| HoldDate | Date | Date when the warehouse applied a hold on the lot. |
| MaturityDate | Date | Date when the lot matures. |
| ReasonName | String | Name of the inventory transaction reason. |
| ReasonCode | String | Abbreviation that identifies the inventory transaction reason. |
| ReasonId | Long | Value that uniquely identifies the reason. |
| SourceCode | String | Abbreviation that identifies the source. |
| SourceLineId | Long | Value that uniquely identifies the source line. |
| StatusId | Long | Value that uniquely identifies the status. |
| StatusCode | String | Abbreviation that identifies the status. |
| GradeCode | String | Abbreviation that identifies the grade. |
| SupplierLotNumber | String | Number that identifies the supplier lot. |
| TerritoryShortName | String | Short name of the territory. |
| LotVolume | Double | Volume of the lot. |
| VolumeUOMName | String | Unit of measure for the lot volume. |
| LotLength | Double | Length of the lot. |
| LengthUOMName | String | Unit of measure for the lot length. |
| LotThickness | Double | Thickness of the lot. |
| LotWidth | Double | Width of the lot. |
| WidthUOMName | String | Unit of measure for the lot width. |
| VendorName | String | Name of the vendor for the lot. |
| SerialTransactionTempId | Long | Value that uniquely identifies the serial transaction. |
| ErrorCode | String | Abbreviation that identifies the error. |
| ProductCode | String | Abbreviation that identifies the product. |
| ProductTransactionId | Long | Value that uniquely identifies the product transaction. |
| SecondaryTransactionQuantity | Double | Transaction quantity of an item in its secondary unit of measure. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |