ReceivingReceiptTransactionRequestslotItemLotslotAttributesDFF

Columns


Name	Type	Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY]	Long	ReceivingReceiptTransactionRequestsInterfaceTransactionId of ReceivingReceiptTransactionRequestslotItemLotslotAttributesDFF
LotitemlotsLotNumber [KEY]	String	LotitemlotsLotNumber of ReceivingReceiptTransactionRequestslotItemLotslotAttributesDFF
TransactionInterfaceId [KEY]	Long	TransactionInterfaceId of ReceivingReceiptTransactionRequestslotItemLotslotAttributesDFF
LotNumber [KEY]	String	LotNumber of ReceivingReceiptTransactionRequestslotItemLotslotAttributesDFF
_FLEX_Context	String	Descriptive flexfield context name for lot attributes. This attribute is applicable when the warehouse places the item under lot control.
_FLEX_Context_DisplayValue	String	Descriptive flexfield context display name for lot attributes. This attribute is applicable when the warehouse places the item under lot 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