ReceivingReceiptRequestslinesASNLineDFF

Columns


Name	Type	Description
ReceivingReceiptRequestsHeaderInterfaceId [KEY]	Long	ReceivingReceiptRequestsHeaderInterfaceId of ReceivingReceiptRequestslinesASNLineDFF
LinesInterfaceTransactionId [KEY]	Long	LinesInterfaceTransactionId of ReceivingReceiptRequestslinesASNLineDFF
InterfaceTransactionId [KEY]	Long	InterfaceTransactionId of ReceivingReceiptRequestslinesASNLineDFF
_FLEX_Context	String	Descriptive flexfield context name for advanced shipment notice (ASN) line request.
_FLEX_Context_DisplayValue	String	Descriptive flexfield context display value for advanced shipment notice (ASN) line request.

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