CreditMemoLinkedTransactions
Query Reckon Credit Memo Linked Transactions.
Table Specific Information
Linked transactions are transactions that have been associated with the CreditMemo specified by the CreditMemoId column.
Columns
| Name | Type | References | Description |
| ID [KEY] | String | The unique identifier in the format CreditMemoId|ItemLineId. | |
| CreditMemoId | String |
CreditMemos.ID | The credit memo identifier. |
| ReferenceNumber | String | The transaction reference number. | |
| TxnNumber | Integer | The transaction number. An identifying number for the transaction, different from the Reckon-generated Id. | |
| Date | Date | The date of the transaction. If it is set in the WHERE clause of a SELECT query, the pseudo columns StartDate and EndDate are overwritten with the value. | |
| CustomerName | String | The name of the customer on the credit memo. | |
| TransactionId | String | The Id of the linked transaction. | |
| TransactionAmount | Double | The amount of the linked transaction. | |
| TransactionDate | Date | The date of the linked transaction. | |
| TransactionReferenceNumber | String | The reference number of the linked transaction. | |
| TransactionType | String | The type of linked transaction. | |
| TransactionLinkType | String | The link type between the credit memo and linked transaction. | |
| TimeModified | Datetime | When the credit memo was last modified. | |
| TimeCreated | Datetime | When the credit memo was created. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| StartTxnDate | String | This pseudo column is deprecated and should no longer be used. Earliest transaction date to search for. | |
| EndTxnDate | String | This pseudo column is deprecated and should no longer be used. Latest transaction date to search for. | |
| StartModifiedDate | String | This pseudo column is deprecated and should no longer be used. Earliest modified date to search for. | |
| EndModifiedDate | String | This pseudo column is deprecated and should no longer be used. Latest modified date to search for. | |
| ItemPriceLevel | String | Item price level name. Reckon will not return the price level. |