NameDescriptionTypeAdditional 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.

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 (BETA)

string

None.

CustomField28

Project item custom field 28 (BETA)

string

None.

CustomField29

Project item custom field 29 (BETA)

string

None.

CustomField30

Project item custom field 30 (BETA)

string

None.

CustomField31

Project item custom field 31 (BETA)

string

None.

CustomField32

Project item custom field 32 (BETA)

string

None.

CustomField33

Project item custom field 33 (BETA)

string

None.

CustomField34

Project item custom field 34 (BETA)

string

None.

CustomField35

Project item custom field 35 (BETA)

string

None.

CustomField36

Project item custom field 36 (BETA)

string

None.

CustomField37

Project item custom field 37 (BETA)

string

None.

CustomField38

Project item custom field 38 (BETA)

string

None.

CustomField39

Project item custom field 39 (BETA)

string

None.

CustomField40

Project item custom field 40 (BETA)

string

None.

CustomField41

Project item custom field 41 (BETA)

string

None.

CustomField42

Project item custom field 42 (BETA)

string

None.

CustomField43

Project item custom field 43 (BETA)

string

None.

CustomField44

Project item custom field 44 (BETA)

string

None.

CustomField45

Project item custom field 45 (BETA)

string

None.

CustomField46

Project item custom field 46 (BETA)

string

None.

CustomField47

Project item custom field 47 (BETA)

string

None.

CustomField48

Project item custom field 48 (BETA)

string

None.

CustomField49

Project item custom field 49 (BETA)

string

None.

CustomField50

Project item custom field 50 (BETA)

decimal number

None.

CustomField51

Project item custom field 51 (BETA)

decimal number

None.

CustomField52

Project item custom field 52 (BETA)

decimal number

None.

CustomField53

Project item custom field 53 (BETA)

decimal number

None.

CustomField54

Project item custom field 54 (BETA)

decimal number

None.

CustomField55

Project item custom field 55 (BETA)

decimal number

None.

CustomField56

Project item custom field 56 (BETA)

decimal number

None.

CustomField57

Project item custom field 57 (BETA)

decimal number

None.

CustomField58

Project item custom field 58 (BETA)

decimal number

None.

CustomField59

Project item custom field 59 (BETA)

date

None.

CustomField60

Project item custom field 60 (BETA)

date

None.

CustomField61

Project item custom field 61 (BETA)

date

None.

CustomField62

Project item custom field 62 (BETA)

date

None.

CustomField63

Project item custom field 63 (BETA)

date

None.

CustomField64

Project item custom field 64 (BETA)

date

None.

CustomField65

Project item custom field 65 (BETA)

date

None.

CustomField66

Project item custom field 66 (BETA)

date

None.

CustomField67

Project item custom field 67 (BETA)

date

None.

CustomField68

Project item custom field 68 (BETA)

boolean

None.

CustomField69

Project item custom field 69 (BETA)

boolean

None.

CustomField70

Project item custom field 70 (BETA)

boolean

None.

CustomField71

Project item custom field 71 (BETA)

boolean

None.

CustomField72

Project item custom field 72 (BETA)

boolean

None.

CustomField73

Project item custom field 73 (BETA)

boolean

None.

CustomField74

Project item custom field 74 (BETA)

boolean

None.

CustomField75

Project item custom field 75 (BETA)

boolean

None.