ShippingMethods
Create, update, delete, and query Reckon Shipping Methods.
Table Specific Information
Select
The following filters support server-side execution. Other filters are executed client-side.
Reckon Accounts Hosted 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 ShippingMethods are Id, TimeModified, Name, and IsActive. TimeModified may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. Name may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax. For example:
SELECT * FROM ShippingMethods WHERE TimeModified > '1/1/2011' AND TimeModified < '2/1/2011' AND Name LIKE '%12345%'
Insert
To insert a ShippingMethod, specify the Name column.Columns
| Name | Type | ReadOnly | References | Description |
| ID [KEY] | String | True |
The unique identifier of the shipping method. | |
| Name | String | False |
The name of the shipping method. | |
| IsActive | Boolean | False |
Boolean determining if the shipping method is active. | |
| EditSequence | String | True |
A string indicating the revision of the shipping method. | |
| TimeCreated | Datetime | True |
The time the shipping method was created. | |
| TimeModified | Datetime | True |
The last time the shipping method was modified. |