SaleInvoiceItems
Return all sale invoice types for an AccountRight company file.
Table Specific Information
Select
Only the SaleInvoiceId and InvoiceType columns, when using the equality comparison, are supported for server side filtering. If left unspecified, the InvoiceType column will default to 'Item'.
Columns
| Name | Type | Description |
| SaleInvoiceId | Uuid | Unique identifier in the form of a guid. |
| DiscountPercent | Double | Discount rate applicable to the line of the sale invoice. |
| Description | String | Description text for the sale line. |
| CostOfGoodsSold | Decimal | Cost Of the Goods Sold |
| RowID | Integer | Sequence of the entry within the item sale invoice set. |
| RowVersion | String | The RowVersion or the line item. |
| ShipQuantity | Decimal | The quantity of goods shipped. |
| Total | Decimal | Invoice 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 | The type of the invoice. |
| UnitPrice | Decimal | Price per unit. |
| AccountID | Uuid | 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 | 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 | 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. |
| JobID | Uuid | Unique guid identifier belonging to the job for the line of the item sale. |
| JobNumber | String | Number assigned to the job. |
| JobName | String | Name assigned to the job. |
| JobURI | String | Uniform resource identifier associated with the job object. |
| LocationID | Uuid | Unique identifier for location in the form of a guid. |
| LocationIdentifier | String | Identifier assigned to the location. |
| LocationName | String | Name assigned to the location. |
| LocationURI | String | Uniform resource identifier associated with the location object. |
| InvoiceType | String | The type of the invoice. One of: Item,Service,Professional,Miscellaneous. |
| CompanyFileId | String | The ID of the company file. Takes precedence over the CompanyFileId connection property. |