InvoicesappliedPrepayments
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 |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
InvoiceId | Long | InvoiceId |
Finder | String | finder |