ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials

Columns


Name	Type	Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY]	Long	ReceivingReceiptTransactionRequestsInterfaceTransactionId of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
LotserialitemlotsLotNumber [KEY]	String	LotserialitemlotsLotNumber of ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials
FromSerialNumber [KEY]	String	Starting serial number in a range of serial numbers of the receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial control.
ToSerialNumber	String	Ending serial number in a range of serial numbers of the receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial control.
VendorSerialNumber	String	Supplier serial number for the serial range of the receipt transaction request. 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