poitem


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
pickitem.poItemId FK9u8545r37n3q106tfo5fkaocc R
postpoitem.poItemId FKij8ivfkbmalljkkdfahj3yu8t R
receiptitem.poItemId FKct73aik026yusq2aemgxqy7a2 R
shipitem.poItemId FK22ksf1230bq10soxnmtswrun6 R
customerId INT 10 √ null
customer.id FK3dj4sp3qfhpad5na6a6wtg69o R
dateLastFulfillment DATETIME 26 √ null
dateScheduledFulfillment DATETIME 26 null
description VARCHAR 256 √ null
mcTotalCost DECIMAL 28,9 √ null
note LONGTEXT 2147483647 √ null
partId INT 10 √ null
part.id FKf3vvwrjw9dt3ddo2lrthqxa5r R
outsourcedPartId INT 10 √ null
part.id FKoutsourcedPart R
partNum VARCHAR 70 null
poId INT 10 null
po.id FK5poexh8btghl7kg7bj3n92rwp R
poLineItem INT 10 null
qbClassId INT 10 √ null
qbclass.id FKsw0wyn1bfufeaytdc88hsdvhd R
qtyFulfilled DECIMAL 28,9 √ null
qtyPicked DECIMAL 28,9 √ null
qtyToFulfill DECIMAL 28,9 √ null
repairFlag BIT 1 null
revLevel VARCHAR 15 √ null
statusId INT 10 null
poitemstatus.id FKo4wmcnjgsn9p0xjmtofe6ax1a R
taxId INT 10 √ null
taxrate.id FKhpe2eson7udwig00uqhbe9q8d R
taxRate DOUBLE 22 null
tbdCostFlag BIT 1 null
totalCost DECIMAL 28,9 √ null
typeId INT 10 null
poitemtype.id FKmyqkkfh88r099du7wf3ey23ci R
unitCost DECIMAL 28,9 √ null
uomId INT 10 √ null
uom.id Implied Constraint R
vendorPartNum VARCHAR 70 null
outsourcedPartNumber VARCHAR 70 null
outsourcedPartDescription VARCHAR 256 null
customFields JSON 1073741824 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK3dj4sp3qfhpad5na6a6wtg69o Performance Asc customerId
FK5poexh8btghl7kg7bj3n92rwp Performance Asc poId
FKf3vvwrjw9dt3ddo2lrthqxa5r Performance Asc partId
FKhpe2eson7udwig00uqhbe9q8d Performance Asc taxId
FKmyqkkfh88r099du7wf3ey23ci Performance Asc typeId
FKo4wmcnjgsn9p0xjmtofe6ax1a Performance Asc statusId
FKoutsourcedPart Performance Asc outsourcedPartId
FKsw0wyn1bfufeaytdc88hsdvhd Performance Asc qbClassId

Relationships

Close relationships within degrees of separation