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.

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