ShippingMethods
Manages QuickBooks Shipping Methods, supporting creation, updates, deletion, and queries for shipping-related information.
Table Specific Information
Select
The following filters support server-side execution. Other filters are executed client-side.
QuickBooks 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 | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
A unique identifier assigned to each shipping method, used to differentiate it from others in the system. | |
| Name | String | False | 15 |
The descriptive name of the shipping method, such as 'FedEx Overnight' or 'Standard Ground Shipping.' | |
| IsActive | Boolean | False |
Indicates whether the shipping method is currently active and available for use in transactions. A value of true means it is active. | ||
| EditSequence | String | True | 16 |
A system-generated value that tracks changes to the shipping method record, used to prevent conflicts during updates. | |
| TimeCreated | Datetime | True |
The date and time when the shipping method record was first created in QuickBooks. | ||
| TimeModified | Datetime | True |
The date and time when the shipping method record was last updated, reflecting its most recent modification. |