ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF
Columns
| Name | Type | Description |
| ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] | Long | ReceivingReceiptTransactionRequestsInterfaceTransactionId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF |
| LotserialitemlotsLotNumber [KEY] | String | LotserialitemlotsLotNumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF |
| LotserialitemserialsFromSerialNumber [KEY] | String | LotserialitemserialsFromSerialNumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF |
| TransactionInterfaceId [KEY] | Long | TransactionInterfaceId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF |
| FromSerialNumber [KEY] | String | FromSerialNumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerialsserialNumbersDFF |
| _FLEX_Context | String | Descriptive flexfield context name for serials. This attribute is applicable when the warehouse places the item under lot and serial control. |
| _FLEX_Context_DisplayValue | String | Descriptive flexfield context display value for serials. This attribute is applicable when the warehouse places the item under lot and serial control. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DocumentNumber | String | DocumentNumber |
| ExternalSystemTransactionReference | String | ExternalSystemTransactionReference |
| FromDate | Datetime | FromDate |
| GroupId | Long | GroupId |
| InterfaceTransactionId | Long | InterfaceTransactionId |
| ItemId | String | ItemId |
| ItemNumber | String | ItemNumber |
| OrganizationCode | String | OrganizationCode |
| OrganizationId | String | OrganizationId |
| POHeaderId | Long | POHeaderId |
| ProcessingStatusCode | String | ProcessingStatusCode |
| RMANumber | String | RMANumber |
| ReceiptAdviceHeaderId | Long | ReceiptAdviceHeaderId |
| ShipmentHeaderId | Long | ShipmentHeaderId |
| ShipmentNumber | String | ShipmentNumber |
| SourceDocumentCode | String | SourceDocumentCode |
| ToDate | Datetime | ToDate |
| TransactionStatusCode | String | TransactionStatusCode |
| TransactionType | String | TransactionType |
| TransferOrderHeaderId | Long | TransferOrderHeaderId |
| Finder | String | finder |