InventoryPart

Table:
inventory_part
Model Version:
3431babdcb192a9c
JSON Schema:
availableQuantity
number
binLocation
Nullable
string
brandId
Nullable
string
categoryId
Nullable
string
companyId
string
computed_fullText
Nullable
string
createdDate
date-time
deleted
boolean
deletedDate
Nullable
date-time
deletedReason
Nullable
string
deletedUserId
Nullable
string
hasSetRetailCost
boolean
id
Primary Key
string
inventoryPartTemplateId
Nullable
string
locationId
string
markedForDeletion
boolean
maxCriticalQuantity
Nullable
number
metadata
Nullable
object
minCriticalQuantity
Nullable
number
name
string
normalizedPartNumber
Nullable
string
normalizedSKU
Nullable
string
note
Nullable
string
number
Nullable
string
onEstimateQuantity
number
otherLocationsAvailableQuantity
number
pricingMatrixDate
Nullable
date-time
pricingMatrixId
Nullable
string
quantity
number
reorderQuantity
number
reservedQuantity
number
retailCostCents
integer
showCostAndQuantity
boolean
showNote
boolean
showPartNumber
boolean
sku
Nullable
string
specification
Nullable
object
suggestedRetailCostCents
Nullable
integer
taxable
boolean
taxableGST
boolean
taxableHST
boolean
taxablePST
boolean
templatePhotoBlobId
Nullable
string
type
Nullable
string
updatedDate
Nullable
date-time
url
Nullable
string
userId
Nullable
string
vendorId
Nullable
string
wholesaleCostCents
Nullable
integer