CData JDBC Driver for Reckon 2019 - Online Help
Questions / Feedback?

Templates

CData JDBC Driver for Reckon 2019 - Build 19.0.7354

Query Reckon templates.

Columns

Name Type References Description
ID [KEY] String The unique identifier of the template.
Name String The name of the template.
IsActive Boolean Boolean determining if the template is active.
TemplateType String The type of template. This may be BuildAssembly, CreditMemo, Estimate, Invoice, PurchaseOrder, SalesOrder, or SalesReceipt.
EditSequence String A string indicating the revision of the template.
TimeCreated Datetime The time the template was created.
TimeModified Datetime The last time the template was modified.

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
StartModifiedDate String This pseudo column is deprecated and should no longer be used. Earliest modified date to search for (in yyyy-MM-dd, MM-dd-yy, MM-dd-yyyy, MM/dd/yy, or MM/dd/yyyy format)
EndModifiedDate String This pseudo column is deprecated and should no longer be used. Latest modified date to search for (in yyyy-MM-dd, MM-dd-yy, MM-dd-yyyy, MM/dd/yy, or MM/dd/yyyy format).
NameMatch String This pseudo column is deprecated and should no longer be used. The type of match to use if specifying the name.

The allowed values are CONTAINS, EXACT, STARTSWITH, ENDSWITH.

ActiveStatus String This pseudo column is deprecated and should no longer be used. Limits the search to active or inactive records only or all records.

The allowed values are ACTIVE, INACTIVE, ALL, NA.

The default value is ALL.

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