SaleInvoiceItems
Returns Sales Invoice Items for invoices of all types in an AccountRight company file.
Table Specific Information
Select
Only the SaleInvoiceId and InvoiceType columns support server-side filtering with equality comparisons. If no InvoiceType is specified, all invoice types are returned unless a specific filter is applied. SaleInvoiceItems supports the following invoice types: Item, Service, Professional, TimeBilling, and Miscellaneous.
- SaleInvoiceId supports the = comparison operator.
- InvoiceType supports the = comparison operator.
Columns
| Name | Type | References | 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 |
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. | |
| JobID | Uuid |
TaxCodes.ID | 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 |
TaxCodes.ID | 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,TimeBilling,Miscellaneous. | |
| CompanyFileId | String |
CompanyFiles.ID | ID of the company file. Takes precedence over the CompanyFileId property. |