ReceivablesCreditMemosreceivablesCreditMemoDistributions
ReceivablesCreditMemosreceivablesCreditMemoDistributions
Columns
Name | Type | Description |
ReceivablesCreditMemosCustomerTransactionId [KEY] | Long | The unique identifier of the credit memo. |
DistributionId [KEY] | Long | The unique identifier of the credit memo distribution. |
AccountedAmount | Double | The amount of the distribution in the ledger currency. |
Amount | Double | The amount of the distribution in the credit memo currency. |
Comments | String | The user-defined comments about the distribution. |
CreatedBy | String | The user who created the record. |
CreationDate | Datetime | The date and time when the record was created. |
DetailedTaxLineNumber | Long | The number of the tax line of a credit memo line associated with the distribution. |
CreditMemoLineNumber | Long | The number of the credit memo line associated with the distribution. |
LastUpdateDate | Datetime | The date and time the record was last updated. |
LastUpdatedBy | String | The user who last updated the record. |
Percent | Double | The percentage of the line amount mapped to this distribution. |
AccountClass | String | The account class of the distribution. Valid values are Revenue, Receivable, Freight, and Tax. |
AccountCombination | String | The account code combination for the distribution. |
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 |