ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTaxLines
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTaxLines
Columns
| Name | Type | Description |
| ReceivablesCreditMemosCustomerTransactionId [KEY] | Long | The unique identifier of the credit memo. |
| ReceivablescreditmemolinesCustomerTransactionLineId [KEY] | Long | The unique identifier of the credit memo line. |
| CustomerTrxLineId [KEY] | Long | The unique identifier of each separate tax line of the credit memo. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date and time when the record was created. |
| LastUpdateDate | Datetime | The date and time when the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
| TaxJurisdictionCode | String | The tax jurisdiction code assigned to the tax line. |
| TaxRate | Double | The tax rate assigned to the credit memo line. |
| TaxRateCode | String | The tax rate code assigned to the credit memo line. |
| TaxRegimeCode | String | The tax regime code assigned to the tax line. |
| TaxStatusCode | String | The tax status code assigned to the tax line. |
| Tax | String | The code of the tax assigned to the tax line. |
| TaxAmount | Double | The tax amount on the credit memo line in the entered currency. |
| TaxableAmount | Double | The amount on the credit memo line eligible for taxation. The tax rate is applied to the taxable amount. |
| TaxPointBasis | String | The transaction event that's the basis for tax on the credit memo line. |
| TaxPointDate | Date | The date when the taxpayer becomes liable for paying the tax to the tax authority. |
| TaxLineNumber | Int | The line number of the tax line of the credit memo line. |
| PlaceOfSupply | Int | The location where the transaction on the credit memo line is determined to take place for tax purposes. |
| TaxInclusiveIndicator | String | The option that indicates whether the credit memo line amount is inclusive of tax. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BindAccountingDate | Date | BindAccountingDate |
| BindAllowCompletion | String | BindAllowCompletion |
| BindBillToCustomer | String | BindBillToCustomer |
| BindBillToCustomerNumber | String | BindBillToCustomerNumber |
| BindBillToSite | String | BindBillToSite |
| BindBusinessUnit | String | BindBusinessUnit |
| BindCreditMemoCurrency | String | BindCreditMemoCurrency |
| BindCreditMemoStatus | String | BindCreditMemoStatus |
| BindCrossReference | String | BindCrossReference |
| BindDeliveryMethod | String | BindDeliveryMethod |
| BindDocumentNumber | Long | BindDocumentNumber |
| BindIntercompany | String | BindIntercompany |
| BindPrimarySalesperson | String | BindPrimarySalesperson |
| BindPrintStatus | String | BindPrintStatus |
| BindPurchaseOrder | String | BindPurchaseOrder |
| BindShipToCustomerName | String | BindShipToCustomerName |
| BindShipToSite | String | BindShipToSite |
| BindTransactionDate | Date | BindTransactionDate |
| BindTransactionNumber | String | BindTransactionNumber |
| BindTransactionSource | String | BindTransactionSource |
| BindTransactionType | String | BindTransactionType |
| CustomerTransactionId | Long | CustomerTransactionId |
| Finder | String | finder |