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
The following filters support server-side execution. Other filters are executed client-side.
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. |