ODBC Driver for Reckon

Build 24.0.9060

StatementCharges

Create, update, delete, and query Reckon Statement Charges.

Table Specific Information

To add a StatementCharge, specify the CustomerName or CustomerId and the ItemName or ItemId.

Select

By default, SupportEnhancedSQL is set to true, and the following will be honored if present. Other filters will be executed client side. If SupportEnhancedSQL is set to false, only the following filters will be honored.

Reckon allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can only be used with the equals or = comparison. The available columns for StatementCharges are Id, Date, TimeModified, ReferenceNumber, CustomerName, CustomerId, IsPaid, AccountsReceivable, and AccountsReceivableId. TimeModified and Date may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. ReferenceNumber may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax. For example:

SELECT * FROM StatementCharges WHERE TimeModified > '1/1/2011' AND TimeModified < '2/1/2011' AND ReferenceNumber LIKE '%12345%'

Columns

Name Type ReadOnly References Description
ID [KEY] String True

The unique identifier.

TxnNumber Integer True

The transaction number. An identifying number for the transaction, different from the Reckon-generated Id.

ReferenceNumber String False

Transaction reference number.

CustomerName String False

Customers.FullName

Customer name this transaction is recorded under. Either CustomerName or CustomerId must have a value when inserting.

CustomerId String False

Customers.ID

Customer Id this transaction is recorded under. Either CustomerName or CustomerId must have a value when inserting.

Date Date False

Transaction date.

ItemName String False

Items.FullName

A reference to the item for the transaction.

ItemId String False

Items.ID

A reference to the item for the transaction.

Quantity Double False

Quantity in stock for this inventory item.

Rate Double False

The unit rate charged for this item.

Amount Double False

Amount of the transaction.

Balance Double True

The balance remaining on the transaction.

Description String False

A textual description of the StatementCharge.

AccountsReceivable String False

Accounts.FullName

A reference to the name of the accounts-receivable account where the money received from this transaction will be deposited.

AccountsReceivableId String False

Accounts.ID

A reference to the Id of the accounts-receivable account where the money received from this transaction will be deposited.

Class String False

Class.FullName

A reference to the class of the transaction.

ClassId String False

Class.ID

A reference to the class of the transaction.

BilledDate Date False

Date when the customer was billed.

DueDate Date False

Date when the payment is due.

IsPaid Boolean True

Indicates whether this statement charge has been paid.

CustomFields String False

Custom fields returned from Reckon and formatted into XML.

EditSequence String True

An identifier used for versioning for this copy of the object.

TimeModified Datetime True

When the statement charge was last modified.

TimeCreated Datetime True

When the statement charge was created.

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