SaleOrderItems
Returns all sale order types for an AccountRight company file.
Table Specific Information
Select
Only the SaleOrderId and OrderType columns support server-side filtering with equality comparisons. If no OrderType is specified, all order types are returned unless a specific filter is applied. SaleOrderItems supports the following order types: Item, Service, Professional, TimeBilling, and Miscellaneous.
- SaleOrderId supports the = comparison operator.
- OrderType supports the = comparison operator.
Columns
| Name | Type | References | Description |
| SaleOrderId | Uuid | Unique identifier in the form of a guid. | |
| DiscountPercent | Double | Discount rate applicable to the line of the sale order. | |
| Description | String | Description text for the sale line. | |
| RowID | Integer | Sequence of the entry within the item sale order set. | |
| RowVersion | String | The RowVersion or the line item. | |
| ShipQuantity | Decimal | The quantity of goods shipped. | |
| Total | Decimal | Order line type, can consist of the following: Transaction - All fields detailed in Lines array are consumable. Header - Only allows you to POST to Description element. Subtotal - Calculated value that is read-only. | |
| Type | String | Line type, can consist of the following: Transaction - All fields detailed in Lines array are consumable. Header - Only allows you to POST to Description element. Subtotal - Calculated value that is read-only. | |
| UnitPrice | Decimal | Price per unit. | |
| AccountID | Uuid |
Accounts.ID | Unique identifier for the account in the form of a guid. |
| AccountDisplayID | String | Account code. Format includes separator ie 4-1100 | |
| AccountName | String | Name of the account. | |
| AccountURI | String | Uniform resource identifier associated with the account object. | |
| ItemID | Uuid |
Items.ID | Unique identifier in the form of a guid. |
| ItemName | String | Name of the item. | |
| ItemNumber | String | The number assigned to the item. | |
| ItemURI | String | Uniform resource identifier associated with the item. | |
| TaxCodeID | Uuid |
TaxCodes.ID | Unique guid identifier belonging to the assigned tax code. |
| TaxCodeCode | String | 3 digit tax code. | |
| TaxCodeURI | String | Uniform resource identifier associated with the tax code object. | |
| OrderType | String | Type of the order. One of: Item,Service,Professional,TimeBilling,Miscellaneous. | |
| Comment | String | Sales Order Comment | |
| ShippingMethod | String | Shipping Method | |
| PromisedDate | Datetime | Transaction Promised Date. | |
| CompanyFileId | String |
CompanyFiles.ID | ID of the company file. Takes precedence over the CompanyFileId property. |