| Name | Description | Type | Additional information |
|---|---|---|---|
| Id |
Unique Id for the project item (Required) |
string |
None. |
| TypeId |
TypeId: 1 = Product, 2 = Labor Item, 3 = Allowance, 4 = Bundled Cable, 5 = Placeholder (Required) Product and Labor items can be posted to a project. Allowances, Bundled Cable and placeholders cannot be posted to a project. |
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. |
| IsOptional |
Is project item optional |
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. |
| TotalLaborHours |
Total Labor Hours includes Base, Misc, Mgt and Design hours and accounts for wire length (if any) and quantity |
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. |
| OriginalApprovedItemId |
Original Approved Item Id. The Original SI Item Id of an approved replaced item or an approved item whose quantity is reduced. |
string |
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. |
| CustomField27 |
Project item custom field 27 |
string |
None. |
| CustomField28 |
Project item custom field 28 |
string |
None. |
| CustomField29 |
Project item custom field 29 |
string |
None. |
| CustomField30 |
Project item custom field 30 |
string |
None. |
| CustomField31 |
Project item custom field 31 |
string |
None. |
| CustomField32 |
Project item custom field 32 |
string |
None. |
| CustomField33 |
Project item custom field 33 |
string |
None. |
| CustomField34 |
Project item custom field 34 |
string |
None. |
| CustomField35 |
Project item custom field 35 |
string |
None. |
| CustomField36 |
Project item custom field 36 |
string |
None. |
| CustomField37 |
Project item custom field 37 |
string |
None. |
| CustomField38 |
Project item custom field 38 |
string |
None. |
| CustomField39 |
Project item custom field 39 |
string |
None. |
| CustomField40 |
Project item custom field 40 |
string |
None. |
| CustomField41 |
Project item custom field 41 |
string |
None. |
| CustomField42 |
Project item custom field 42 |
string |
None. |
| CustomField43 |
Project item custom field 43 |
string |
None. |
| CustomField44 |
Project item custom field 44 |
string |
None. |
| CustomField45 |
Project item custom field 45 |
string |
None. |
| CustomField46 |
Project item custom field 46 |
string |
None. |
| CustomField47 |
Project item custom field 47 |
string |
None. |
| CustomField48 |
Project item custom field 48 |
string |
None. |
| CustomField49 |
Project item custom field 49 |
string |
None. |
| CustomField50 |
Project item custom field 50 |
decimal number |
None. |
| CustomField51 |
Project item custom field 51 |
decimal number |
None. |
| CustomField52 |
Project item custom field 52 |
decimal number |
None. |
| CustomField53 |
Project item custom field 53 |
decimal number |
None. |
| CustomField54 |
Project item custom field 54 |
decimal number |
None. |
| CustomField55 |
Project item custom field 55 |
decimal number |
None. |
| CustomField56 |
Project item custom field 56 |
decimal number |
None. |
| CustomField57 |
Project item custom field 57 |
decimal number |
None. |
| CustomField58 |
Project item custom field 58 |
decimal number |
None. |
| CustomField59 |
Project item custom field 59 |
date |
None. |
| CustomField60 |
Project item custom field 60 |
date |
None. |
| CustomField61 |
Project item custom field 61 |
date |
None. |
| CustomField62 |
Project item custom field 62 |
date |
None. |
| CustomField63 |
Project item custom field 63 |
date |
None. |
| CustomField64 |
Project item custom field 64 |
date |
None. |
| CustomField65 |
Project item custom field 65 |
date |
None. |
| CustomField66 |
Project item custom field 66 |
date |
None. |
| CustomField67 |
Project item custom field 67 |
date |
None. |
| CustomField68 |
Project item custom field 68 |
boolean |
None. |
| CustomField69 |
Project item custom field 69 |
boolean |
None. |
| CustomField70 |
Project item custom field 70 |
boolean |
None. |
| CustomField71 |
Project item custom field 71 |
boolean |
None. |
| CustomField72 |
Project item custom field 72 |
boolean |
None. |
| CustomField73 |
Project item custom field 73 |
boolean |
None. |
| CustomField74 |
Project item custom field 74 |
boolean |
None. |
| CustomField75 |
Project item custom field 75 |
boolean |
None. |