ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf

Columns


Name	Type	Description
ReceivablesInvoicesCustomerTransactionId [KEY]	Long	ReceivablesInvoicesCustomerTransactionId of ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf
ReceivablesinvoicelinesCustomerTransactionLineId [KEY]	Long	ReceivablesinvoicelinesCustomerTransactionLineId of ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf
CustomerTrxLineId [KEY]	Long	CustomerTrxLineId of ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf
_FLEX_Context	String	__FLEX_Context of ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf
_FLEX_Context_DisplayValue	String	__FLEX_Context_DisplayValue of ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
AccountingDate	Date	AccountingDate
AllowCompletion	String	AllowCompletion
BillToCustomerName	String	BillToCustomerName
BillToCustomerNumber	String	BillToCustomerNumber
BillToSite	String	BillToSite
BillingDate	Date	BillingDate
BusinessUnit	String	BusinessUnit
CrossReference	String	CrossReference
CustomerTransactionId	Long	CustomerTransactionId
DocumentNumber	Long	DocumentNumber
DueDate	Date	DueDate
FirstPartyTaxRegistration	String	FirstPartyTaxRegistration
InvoiceCurrencyCode	String	InvoiceCurrencyCode
InvoiceStatus	String	InvoiceStatus
LegalEntityIdentifier	String	LegalEntityIdentifier
PaymentTerms	String	PaymentTerms
PurchaseOrder	String	PurchaseOrder
ShipToCustomerName	String	ShipToCustomerName
ShipToSite	String	ShipToSite
ThirdPartyTaxRegistration	String	ThirdPartyTaxRegistration
TransactionDate	Date	TransactionDate
TransactionNumber	String	TransactionNumber
TransactionSource	String	TransactionSource
TransactionType	String	TransactionType
Finder	String	finder