SaleOrderItems
Returns all sale order types for an AccountRight company file.
Table Specific Information
Select
Only the SaleOrderId and OrderType columns, when using the equality comparison, are supported for server side filtering. If left unspecified, the OrderType column will default to 'Item'.
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. |