PurchaseBillItems
Return all purchase bill types for an AccountRight company file.
Table Specific Information
Select
Only the PurchaseBillId and BillType columns, when using the equality comparison, are supported for server side filtering. If left unspecified, the BillType column will default to 'Item'.
Columns
| Name | Type | Description |
| PurchaseBillId | Uuid | Unique identifier in the form of a guid. |
| Date | Datetime | Transaction date entry. |
| Description | String | Description text for the line. |
| Total | Decimal | Total amount for the line item only. |
| Type | String | Bill 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. |
| BillQuantity | Decimal | The quantity of goods shipped. |
| ReceivedQuantity | Decimal | The quantity of goods received. |
| BackorderQuantity | Decimal | Please note: To be implemented when Purchase Order functionality is available. |
| UnitPrice | Decimal | Price per unit. |
| DiscountPercent | Double | Discount rate applicable to the line item. |
| 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. |
| JobID | Uuid | Unique job identifier in the form of a guid. |
| JobName | String | Name assigned to the job. |
| JobNumber | String | Number assigned to the job. |
| JobURI | String | Uniform resource identifier associated with the job object. |
| 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. |
| 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. |
| RowID | Integer | Sequence of the entry within the item. |
| RowVersion | String | Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time. |
| BillType | String | Type of the bill. One of: Item,Service,Professional,Miscellaneous. |
| CompanyFileId | String | The ID of the company file. Takes precedence over the CompanyFileId connection property. |