Part

Table:
part
Model Version:
51f4978fda40d4d7
JSON Schema:
Part
binLocation
string
categoryId
Nullable
string
companyId
string
createdDate
date-time
discountCents
integer
discountPercent
number
discountValueType
Percent, FixedCents
fixedPriceLimitPriceCents
Nullable
integer
fixedPriceLimitQuantity
Nullable
number
fixedPriceLimitType
Nullable
None, Quantity, Price
id
Primary Key
string
inventoryPartId
Nullable
string
inventoryStatus
OnEstimate, InventoryReduced, None
labels
object
locationId
string
metadata
Nullable
object
motorApplicationId
Nullable
integer
motorCommercialPartsId
Nullable
integer
name
string
note
string
orderId
string
ordinal
number
partNumber
Nullable
string
pcDbTerminologyId
Nullable
integer
pricingMatrixDate
Nullable
date-time
pricingMatrixId
Nullable
string
purchaseOrderPartId
Nullable
string
purchaseStatus
Nullable
Cancelled, Draft, Fulfilled, Ordered, Received
quantity
number
reduceInventoryCount
boolean
reserved
boolean
retailCostCents
integer
serviceId
string
showCostAndQuantity
boolean
showNote
boolean
showPartNumber
boolean
sourceItemId
Nullable
string
taxable
boolean
taxableGST
boolean
taxableHST
boolean
taxablePST
boolean
updatedDate
Nullable
date-time
url
Nullable
string
vendorId
Nullable
string
wholesaleCostCents
Nullable
integer