InventoryPart

Table:
inventory_part
Model Version:
c733d7869eee4a13
JSON Schema:
InventoryPart
availableQuantity
number
binLocation
Nullable
string
brandId
Nullable
string
categoryId
Nullable
string
companyId
string
computed_fullText
Nullable
string
createdDate
date-time
deleted
boolean
if the record has been deleted
deletedDate
Nullable
date-time
the date that the record was deleted or null if not deleted
deletedReason
Nullable
string
the reason that the record was deleted
deletedUserId
Nullable
string
the user that deleted the record or null if not deleted
hasSetRetailCost
boolean
used to determine whether we should push updates to suggested retail cost down to retailCostCents
id
Primary Key
string
inventoryPartTemplateId
Nullable
string
This is explicitly not a foreign key to persist this connection for consumer processing after inventory part template deletion
locationId
string
markedForDeletion
boolean
if the record is marked for deletion because of the template being deleted
maxCriticalQuantity
Nullable
number
metadata
Nullable
object
metadata reserved for customers to control
minCriticalQuantity
Nullable
number
name
string
normalizedPartNumber
Nullable
string
normalizedSKU
Nullable
string
note
Nullable
string
number
Nullable
string
onEstimateQuantity
number
otherLocationsAvailableQuantity
integer
pricingMatrixDate
Nullable
date-time
datetime when pricingMatrixId was set, for determining if matrix has been changed
pricingMatrixId
Nullable
string
quantity
number
reorderQuantity
number
reservedQuantity
number
retailCostCents
integer
showCostAndQuantity
boolean
show cost/quantity on estimate & invoice
showNote
boolean
show note on estimate & invoice
showPartNumber
boolean
show number on estimate & invoice
sku
Nullable
string
specification
Nullable
object
suggestedRetailCostCents
Nullable
integer
taxable
boolean
US specific
taxableGST
boolean
CA specific
taxableHST
boolean
CA specific
taxablePST
boolean
CA specific
templatePhotoBlobId
Nullable
string
type
Nullable
string
updatedDate
Nullable
date-time
url
Nullable
string
userId
Nullable
string
vendorId
Nullable
string
wholesaleCostCents
Nullable
integer