| Name | Description | Type | Additional information |
|---|---|---|---|
| Id |
Unique Id for the project item (Required) |
string |
None. |
| TypeId |
TypeId: 1 = Product, 2 = Labor, 3 = Allowance, 4 = Bundled Cable, 5 = Placeholder (Required) |
byte |
None. |
| SIItemId |
SIItemId - unique id of an item in SI - can be used for updates to SI project. This will be blank for adjustment items and phase labor items (calculated items). |
string |
None. |
| LaborType |
LaborType: Item, Phase |
string |
None. |
| COChangeTypeId |
The change order change type Id. 1 = Added on Change Order, 2 = Deleted on Change Order. |
byte |
None. |
| ManufacturerId |
Id for the manufacturer. |
string |
None. |
| Manufacturer |
Manufacturer for the project item. Required for product and labor. |
string |
None. |
| Model |
Model for the project item. Required for product and labor. |
string |
None. |
| PackageName |
Package Name for the allowance, bundled cable and placeholder (required). |
string |
None. |
| PartNumber |
Part Number |
string |
None. |
| Category |
Category |
string |
None. |
| Subcategory |
Subcategory |
string |
None. |
| Description |
Short description |
string |
None. |
| ComponentId |
Component ID |
string |
None. |
| BulkItem |
Bulk Item |
boolean |
None. |
| SerialNumber |
Serial number |
string |
None. |
| IPAddress |
IP Address 1 |
string |
None. |
| IPAddress2 |
IP Address 2 |
string |
None. |
| MACAddress1 |
MAC Address 1 |
string |
None. |
| MACAddress2 |
MAC Address 2 |
string |
None. |
| IsOfe |
If project item owner furnished |
boolean |
None. |
| IsNonBillable |
Is project item non-billable |
boolean |
None. |
| Quantity |
Quantity of the project item. For bulk wire is the wire length. For variable labor and phase labor is the labor hours. |
decimal number |
None. |
| PriceType |
Price Type of the item |
string |
None. |
| UnitCost |
Unit Cost |
decimal number |
None. |
| UnitPriceWithoutDiscount |
Unit Price (does not includes Discount) |
decimal number |
None. |
| UnitPrice |
Unit Price (includes Discount) |
decimal number |
None. |
| UnitPriceRounded |
Rounded Unit Price |
decimal number |
None. |
| Discount |
Discount |
decimal number |
None. |
| LaborCalculationMethodId |
Id of the LaborCalculation. Fixed = 1, Variable = 2, Phase = 3 |
byte |
None. |
| Phase |
Phase |
string |
None. |
| LaborHours |
For products the labor hours are the associated labor hours for that product. Fixed labor has labor hours as 0 (quantity is 1). Variable labor has labor hours of the item (equal to quantity). Phase labor has labor hours as 0 (quantity has the total labor hours for the phase). |
decimal number |
None. |
| LaborTypes |
Comma separated list of item labor types |
string |
None. |
| ItemLaborTypes |
Collection of labor types for item with name and hours |
Collection of ItemLaborType |
None. |
| ProductAdjustment |
Product Adjustment |
decimal number |
None. |
| MiscPartAdjustment |
Miscellaneous Parts Adjustment |
decimal number |
None. |
| LaborAdjustment |
Labor Adjustment |
decimal number |
None. |
| InstallPrice |
Install Price is the sum of product price and labor price to install the item |
decimal number |
None. |
| IsTaxable |
Is project item taxable. Applicable if project has IsItemLevelTax = false |
boolean |
None. |
| TaxId |
Tax ID for the project item in project taxes. Applicable if project has IsItemLevelTax = true |
string |
None. |
| AvalaraTaxCode |
Avalara tax code |
string |
None. |
| AvalaraLaborTaxCode |
Avalara labor tax code |
string |
None. |
| AcctgName |
Accounting Item Name |
string |
None. |
| IncludedAccessory |
Included Accessory |
boolean |
None. |
| Vendor |
Vendor |
string |
None. |
| OrderUom |
UOM |
string |
None. |
| OrderUomUnits |
UOM units |
integer |
None. |
| DoNotOrder |
Do not order item |
boolean |
None. |
| BulkWire |
Item is Bulk Wire |
boolean |
None. |
| RackMounted |
Rack Mounted |
boolean |
None. |
| LocationId |
Location Id for the project item in project locations |
string |
None. |
| SystemId |
System Id for the project item in project systems |
string |
None. |
| ParentId |
If project item is an accessory id of the parent item |
string |
None. |
| CatalogId |
Id of the item in the SI catalog |
string |
None. |
| PackageId |
If project item is in a package Id of the package (in Packages) |
integer |
None. |
| SolutionId |
If project item is in a solution Id of the solution (in Packages) |
integer |
None. |
| OrderStatus |
Order Status (Ordered, Not Ordered etc.). |
string |
None. |
| OrderNumber |
Order Number |
string |
None. |
| OrderedDate |
Ordered Date |
date |
None. |
| ExpectedDeliveryDate |
Expected Delivery Date |
date |
None. |
| ReceivedDate |
Received Date |
date |
None. |
| Picked |
Picked (Is Item Picked?) |
boolean |
None. |
| PickedDate |
Picked Date |
date |
None. |
| Installed |
Installed (Is Item Installed?) |
boolean |
None. |
| InstalledDate |
Installed Date |
date |
None. |
| InstalledNotes |
Install Notes |
string |
None. |
| TrackingNumber |
Tracking Number |
string |
None. |
| UpdatedOn |
Date the project item was updated. Populated only when data is returned unit wise (non aggregated). Not populated for calculated items like adjustments and phase labor. |
date |
None. |
| CustomField1 |
Project item custom field 1 |
string |
None. |
| CustomField2 |
Project item custom field 2 |
string |
None. |
| CustomField3 |
Project item custom field 3 |
string |
None. |
| CustomField4 |
Project item custom field 4 |
string |
None. |
| CustomField5 |
Project item custom field 5 |
string |
None. |
| CustomField6 |
Project item custom field 6 |
decimal number |
None. |
| CustomField7 |
Project item custom field 7 |
decimal number |
None. |
| CustomField8 |
Project item custom field 8 |
decimal number |
None. |
| CustomField9 |
Project item custom field 9 |
date |
None. |
| CustomField10 |
Project item custom field 10 |
date |
None. |
| CustomField11 |
Project item custom field 11 |
date |
None. |
| CustomField12 |
Project item custom field 12 |
string |
None. |
| CustomField13 |
Project item custom field 13 |
string |
None. |
| CustomField14 |
Project item custom field 14 |
string |
None. |
| CustomField15 |
Project item custom field 15 |
string |
None. |
| CustomField16 |
Project item custom field 16 |
string |
None. |
| CustomField17 |
Project item custom field 17 |
string |
None. |
| CustomField18 |
Project item custom field 18 |
string |
None. |
| CustomField19 |
Project item custom field 19 |
boolean |
None. |
| CustomField20 |
Project item custom field 20 |
boolean |
None. |
| CustomField21 |
Project item custom field 21 |
boolean |
None. |
| CustomField22 |
Project item custom field 22 |
boolean |
None. |
| CustomField23 |
Project item custom field 23 |
string |
None. |
| CustomField24 |
Project item custom field 24 |
string |
None. |
| CustomField25 |
Project item custom field 25 |
string |
None. |
| CustomField26 |
Project item custom field 26 |
string |
None. |