ReceivingReceiptTransactionRequestsDFF
ReceivingReceiptTransactionRequestsDFF
Columns
| Name | Type | Description |
| ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] | Long | ReceivingReceiptTransactionRequestsInterfaceTransactionId of ReceivingReceiptTransactionRequestsDFF |
| InterfaceTransactionId [KEY] | Long | InterfaceTransactionId of ReceivingReceiptTransactionRequestsDFF |
| _FLEX_Context | String | Descriptive flexfield context name for receipt transaction requests. |
| _FLEX_Context_DisplayValue | String | Descriptive flexfield context display name for receipt transaction requests. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DocumentNumber | String | DocumentNumber |
| ExternalSystemTransactionReference | String | ExternalSystemTransactionReference |
| FromDate | Datetime | FromDate |
| GroupId | Long | GroupId |
| 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 |