InventoryTire

Table:
inventory_tire
Model Version:
f3bdcf342899b4bc
JSON Schema:
InventoryTire
availableQuantity
number
binLocation
Nullable
string
categoryType
Nullable
string
AT, XL ...
companyId
string
construction
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
discountCents
integer
discountPercent
number
discountValueType
Percent, FixedCents
federalExciseTaxCents
integer
hasSetRetailCost
boolean
used to determine whether we should push updates to suggested retail cost down to retailCostCents
id
Primary Key
string
inventoryNumber
Nullable
string
inventoryTireTemplateId
Nullable
string
This is explicitly not a foreign key to persist this connection for consumer processing after inventory tire template deletion
isRunFlat
boolean
isStudded
boolean
loadIndex
Nullable
integer
loadRange
Nullable
string
locationId
string
markedForDeletion
boolean
if the record is pending deletion because of the template being deleted
maxCriticalQuantity
Nullable
number
maxTirePressurePSI
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
onEstimateQuantity
number
outerDiameterUnit
mm, in
outerDiameterValue
Nullable
number
partNumber
Nullable
string
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
sectionWidthUnit
mm, in
sectionWidthValue
Nullable
number
serviceType
Nullable
string
showNote
boolean
show note on estimates & invoices
showPartNumber
boolean
show number on estimate & invoice
showPriceAndQuantity
boolean
show on estimates and invoices
sidewallAspectValue
Nullable
number
size
Nullable
string
sizeFormat
Conventional, OffRoadSAE
sku
Nullable
string
speedRating
Nullable
string
suggestedRetailCostCents
Nullable
integer
taxable
boolean
US specific
taxableGST
boolean
CA specific
taxableHST
boolean
CA specific
taxablePST
boolean
CA specific
temperature_UTQG
Nullable
string
tireModelId
string
traction_UTQG
Nullable
string
treadDepthUnit
mm, in
treadDepthValue
Nullable
number
treadWear_UTQG
Nullable
number
updatedDate
Nullable
date-time
url
Nullable
string
userId
Nullable
string
wasteTireFeeCents
integer
wheelDiameterUnit
mm, in
wheelDiameterValue
Nullable
number
wholesaleCostCents
Nullable
integer