ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines
Columns
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId [KEY] | Long | ReceivablesInvoicesCustomerTransactionId of ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines |
| ReceivablesinvoicelinesCustomerTransactionLineId [KEY] | Long | ReceivablesinvoicelinesCustomerTransactionLineId of ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines |
| CustomerTransactionLineId [KEY] | Long | The line resource is used to identify each of the separate tax lines of a transaction line. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date and time the record was created. |
| LastUpdatedBy | String | The user who last updated the record. |
| LastUpdateDate | Datetime | The date on which the record is last updated. |
| TaxJurisdictionCode | String | The tax jurisdiction code assigned to the invoice line tax line. |
| TaxRate | Double | The tax rate assigned to the invoice line tax line. |
| TaxRateCode | String | The tax rate code assigned to the invoice line tax line. |
| TaxRegimeCode | String | The tax regime code assigned to the invoice line tax line. |
| TaxStatusCode | String | The tax status code assigned to the invoice line tax line. |
| Tax | String | The code of the tax assigned to the invoice line tax line. |
| TaxAmount | Double | The tax amount on the invoice line tax line in the entered currency. |
| TaxableAmount | Double | The amount on the invoice line eligible for taxation. The tax rate is applied to the taxable amount. |
| TaxPointBasis | String | The transaction event that is the basis for tax on the invoice line tax line. |
| TaxPointDate | Date | The date on which the taxpayer becomes liable for paying the tax to the tax authority. Valid values are delivery date, invoice date, and pickup date. |
| TaxLineNumber | Int | The line number of the tax line of the invoice line. |
| PlaceOfSupply | Int | The location where the transaction is determined to take place for the tax on the invoice line. |
| TaxInclusiveIndicator | String | Option that indicates whether the invoice line amount is inclusive of tax. |
Pseudo-Columns
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 |