Excel Add-In for Reckon Accounts Hosted

Build 24.0.9062

CustomerMessages

Create, delete, and query Customer Messages.

Columns

Name Type ReadOnly References Description
ID [KEY] String True

The unique identifier of the customer message.

Name String False

The name of the customer message.

IsActive Boolean False

Boolean determining if the customer message is active.

EditSequence String True

A string indicating the revision of the customer message.

TimeCreated Datetime True

The time the customer message was created.

TimeModified Datetime True

The last time the customer message was modified.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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