PurchaseBillItems
Return line items in all purchase bill types for an AccountRight company file.
Table Specific Information
Select
Only the PurchaseBillId and BillType columns support server-side filtering with equality comparisons. If no BillType is specified, all bill types are returned unless a specific filter is applied. PurchaseBillItems supports the following bill types: Item, Service, Professional, and Miscellaneous.
- PurchaseBillId supports the = comparison operator.
- BillType supports the = comparison operator.
Columns
| Name | Type | References | 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 |
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. | |
| JobID | Uuid |
Jobs.ID | 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 |
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. | |
| 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. | |
| 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 |
CompanyFiles.ID | ID of the company file. Takes precedence over the CompanyFileId property. |