ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF

Columns


Name	Type	Description
ReceivablesInvoicesCustomerTransactionId [KEY]	Long	ReceivablesInvoicesCustomerTransactionId of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF
ReceivablesinvoiceinstallmentsInstallmentId [KEY]	Long	ReceivablesinvoiceinstallmentsInstallmentId of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF
PaymentScheduleId [KEY]	Long	PaymentScheduleId of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF
_FLEX_Context	String	__FLEX_Context of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF
_FLEX_Context_DisplayValue	String	__FLEX_Context_DisplayValue of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF

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