JDBC Driver for Reckon

Build 24.0.9062

Templates

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.

使用できる値は次のとおりです。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.

使用できる値は次のとおりです。ACTIVE, INACTIVE, ALL, NA

デフォルト値はALLです。

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062