ReceivingReceiptTransactionRequestsserialItemSerialsserialAttributesDFF

Columns


Name	Type	Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY]	Long	ReceivingReceiptTransactionRequestsInterfaceTransactionId of ReceivingReceiptTransactionRequestsserialItemSerialsserialAttributesDFF
SerialitemserialsFromSerialNumber [KEY]	String	SerialitemserialsFromSerialNumber of ReceivingReceiptTransactionRequestsserialItemSerialsserialAttributesDFF
TransactionInterfaceId [KEY]	Long	TransactionInterfaceId of ReceivingReceiptTransactionRequestsserialItemSerialsserialAttributesDFF
FromSerialNumber [KEY]	String	FromSerialNumber of ReceivingReceiptTransactionRequestsserialItemSerialsserialAttributesDFF
_FLEX_Context	String	Descriptive flexfield context name for serial attributes. 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 serial attributes. This attribute is applicable when the warehouse places the item under lot and serial control.

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