CData BizTalk Adapter for Reckon 2019 - Online Help
Questions / Feedback?

PurchaseOrderLinkedTransactions

CData BizTalk Adapter for Reckon 2019 - Build 19.0.7354

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

PurchaseOrders.ID

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.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0