ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
ReceivingReceiptRequestslineslotItemLotslotNumbersDFF
Columns
| Name | Type | Description |
| ReceivingReceiptRequestsHeaderInterfaceId [KEY] | Long | ReceivingReceiptRequestsHeaderInterfaceId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF |
| LinesInterfaceTransactionId [KEY] | Long | LinesInterfaceTransactionId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF |
| LotitemlotsLotNumber [KEY] | String | LotitemlotsLotNumber of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF |
| TransactionInterfaceId [KEY] | Long | TransactionInterfaceId of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF |
| LotNumber [KEY] | String | LotNumber of ReceivingReceiptRequestslineslotItemLotslotNumbersDFF |
| _FLEX_Context | String | Descriptive flexfield context name for lots. 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 lots. This attribute is applicable when the warehouse places the item under lot and serial control. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| CustomerId | Long | CustomerId |
| CustomerPartyName | String | CustomerPartyName |
| DocumentNumber | String | DocumentNumber |
| ExternalSystemTransactionReference | String | ExternalSystemTransactionReference |
| FromDate | Datetime | FromDate |
| FromOrganizationCode | String | FromOrganizationCode |
| FromOrganizationId | Long | FromOrganizationId |
| GroupId | Long | GroupId |
| HeaderInterfaceId | Long | HeaderInterfaceId |
| ItemId | Long | ItemId |
| ItemNumber | String | ItemNumber |
| OrganizationCode | String | OrganizationCode |
| OrganizationId | Long | 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 |
| VendorId | Long | VendorId |
| VendorName | String | VendorName |
| VendorNumber | String | VendorNumber |
| Finder | String | finder |