InvoicesappliedPrepayments

Columns


Name	Type	Description
InvoicesInvoiceId [KEY]	Long	InvoicesInvoiceId of InvoicesappliedPrepayments
InvoiceNumber	String	InvoiceNumber of InvoicesappliedPrepayments
LineNumber [KEY]	Int	LineNumber of InvoicesappliedPrepayments
Description	String	Description of InvoicesappliedPrepayments
SupplierSite	String	SupplierSite of InvoicesappliedPrepayments
PurchaseOrder	String	PurchaseOrder of InvoicesappliedPrepayments
Currency	String	Currency of InvoicesappliedPrepayments
AppliedAmount	Double	AppliedAmount of InvoicesappliedPrepayments
IncludedTax	Double	IncludedTax of InvoicesappliedPrepayments
IncludedonInvoiceFlag	Bool	IncludedonInvoiceFlag of InvoicesappliedPrepayments
ApplicationAccountingDate	Date	ApplicationAccountingDate of InvoicesappliedPrepayments

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