PurchaseOrderLinkedTransactions
Query Reckon Purchase Order Linked Transactions.
Table Specific Information
Linked transactions are transactions that have been associated with the PurchaseOrder specified by the PurchaseOrderId column.
Columns
Name | Type | References | Description |
ID [KEY] | String | The unique identifier in the format PurchaseOrderId|ItemLineId. | |
PurchaseOrderId | String | The purchase order identifier. | |
VendorName | String |
Vendors.Name | Vendor name this purchase order is issued to. Either VendorName or VendorId must have a value when inserting. |
VendorId | String |
Vendors.ID | Vendor Id this purchase order is issued to. Either VendorName or VendorId must have a value when inserting. |
VendorMessage | String | Message to appear to vendor. | |
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 | Transaction date. If it is set in the WHERE clause of a SELECT query, the pseudo columns StartDate and EndDate are overwritten with the value. | |
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 purchase order and linked transaction. | |
TimeModified | Datetime | When the purchase order was last modified. | |
TimeCreated | Datetime | When the purchase order was created. |
Pseudo-Columns
Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
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. |