part


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
bomitem.partId FKtews6ftw81upyqqyiwq111asn R
bomitem_aud.partId Implied Constraint R
costlayer.partId FKribfolfn35uurbih7ihfeid6o R
costlayer_aud.partId Implied Constraint R
defaultlocation.partId FKguy7k5jah0gilvn1es2yga2rk R
defaultlocation_aud.partId Implied Constraint R
inventorylog.partId FK1dfktk3okp61o0as2gny8uhe6 R
moitem.partId FKd8mneun66c2jrw2a17iv9bft1 R
moitem_aud.partId Implied Constraint R
nextorderview.PARTID Implied Constraint R
nextorderview.PARTUOMID Implied Constraint R
part.defaultOutsourcedReturnItemId FKOutsourcedReturnItem R
part_aud.partClassId Implied Constraint R
partcost.partId FKi279ok5sm27lfqfesn8prvuid R
partcost_aud.partId Implied Constraint R
partcosthistory.partId FKk144etyg26a63ov9xo4e3plrx R
partreorder.partId FKsf0ux19nlycsw7t1fe6g1iemi R
partreorder_aud.partId Implied Constraint R
parttotracking.partId FKl6hy8hlv7qx4t6gyjc60xcggi R
parttotracking_aud.partId Implied Constraint R
pickitem.partId FK2opakx1e66pm5v4ihd7lyr4rn R
pickitem_aud.partId Implied Constraint R
poitem.outsourcedPartId FKoutsourcedPart R
poitem.partId FKf3vvwrjw9dt3ddo2lrthqxa5r R
poitem_aud.partId Implied Constraint R
product.partId FKj9v7tao0cke6neukmq70q0i14 R
product_aud.partId Implied Constraint R
qohview.PARTID Implied Constraint R
qtyallocated.PARTID Implied Constraint R
qtyallocatedmo.PARTID Implied Constraint R
qtyallocatedpo.PARTID Implied Constraint R
qtyallocatedso.PARTID Implied Constraint R
qtyallocatedtoreceive.PARTID Implied Constraint R
qtyallocatedtosend.PARTID Implied Constraint R
qtycommitted.PARTID Implied Constraint R
qtydropship.PARTID Implied Constraint R
qtyinventory.PARTID Implied Constraint R
qtyinventorytotals.PARTID Implied Constraint R
qtynotavailable.PARTID Implied Constraint R
qtynotavailabletopick.PARTID Implied Constraint R
qtyonhand.PARTID Implied Constraint R
qtyonorder.PARTID Implied Constraint R
qtyonordermo.PARTID Implied Constraint R
qtyonorderpo.PARTID Implied Constraint R
qtyonorderso.PARTID Implied Constraint R
qtyonordertoreceive.PARTID Implied Constraint R
qtyonordertosend.PARTID Implied Constraint R
receiptitem.partId FKidqu7nms2hqyr3qlgaiu95dud R
receiptitem_aud.partId Implied Constraint R
tag.partId FKekotaub2vdb0x3ixgb8fgr2dl R
tagtrackingnoserialview.PARTID Implied Constraint R
tagtrackingview.PARTID Implied Constraint R
vendorcostrule.partId FKp530eoh5nd0jb6mcbyofg3tj5 R
vendorcostrule_aud.partId Implied Constraint R
vendorparts.partId FKqtwhw8awevq0akqru3p5ce2i2 R
vendorparts_aud.partId Implied Constraint R
watch.itemId FKq74qsmdcqycr2cxyqk2cvlvyh R
woitem.partId FK52gp8xaf702gn14muj4go2q1t R
woitem_aud.partId Implied Constraint R
xoitem.partId FKtqq5fxenrwruxkstwbmh75xlu R
xoitem_aud.partId Implied Constraint R
abcCode VARCHAR 1 √ null
accountingHash VARCHAR 30 √ null
accountingId VARCHAR 36 √ null
activeFlag BIT 1 null
adjustmentAccountId INT 10 √ null
asaccount.id FK1tjoy7axycg81d1jj8fxdibgw R
alertNote VARCHAR 256 √ null
alwaysManufacture BIT 1 null
cogsAccountId INT 10 √ null
asaccount.id FKeyunpip5cqrlelvtrcc1rukaq R
configurable BIT 1 null
consumptionRate DECIMAL 28,9 0.000000000
controlledFlag BIT 1 null
cycleCountTol DECIMAL 28,9 √ null
dateCreated DATETIME 26 √ null
dateLastModified DATETIME 26 √ null
defaultBomId INT 10 √ null
bom.id FKgo6p90v4bag4p6flg0wq9igl3 R
defaultOutsourcedReturnItemId INT 10 √ null
part.id FKOutsourcedReturnItem R
defaultPoItemTypeId INT 10 √ null
poitemtype.id FKPoItemType R
defaultProductId INT 10 √ null
product.id FKd66hs7743k1fatmsronlq7l5v R
description VARCHAR 252 √ null
details LONGTEXT 2147483647 √ null
height DECIMAL 28,9 √ null
inventoryAccountId INT 10 √ null
asaccount.id FKce78r5mq7swada1brt8m1x852 R
lastChangedUser VARCHAR 100 √ null
leadTime INT 10 √ null
len DECIMAL 28,9 √ null
num VARCHAR 70 null
partClassId INT 10 √ null
pickInUomOfPart BIT 1 null
receivingTol DECIMAL 28,9 √ null
revision VARCHAR 15 √ null
scrapAccountId INT 10 √ null
asaccount.id FK84ru0seuvjnpvr9o1nldwynd9 R
serializedFlag BIT 1 null
sizeUomId INT 10 √ null
uom.id FKehqatujavsaf5bfxw6n1c702t R
stdCost DECIMAL 28,9 √ null
taxId INT 10 √ null
taxrate.id FKj7exys6ksj7osv0evb6seyjoi R
trackingFlag BIT 1 null
typeId INT 10 null
parttype.id FKc5wpf2q8fjmwr9xhnvpxk7stt R
uomId INT 10 null
uom.id FKhinn05th5neilep4wj1m7jw02 R
upc VARCHAR 31 √ null
url VARCHAR 256 √ null
varianceAccountId INT 10 √ null
asaccount.id FKm4swbkft1n14fdtnnywbguyl5 R
weight DECIMAL 28,9 √ null
weightUomId INT 10 √ null
uom.id FK3680fxg2n0j7yrjj4fq9elsq9 R
width DECIMAL 28,9 √ null
customFields JSON 1073741824 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK1tjoy7axycg81d1jj8fxdibgw Performance Asc adjustmentAccountId
FK3680fxg2n0j7yrjj4fq9elsq9 Performance Asc weightUomId
FK84ru0seuvjnpvr9o1nldwynd9 Performance Asc scrapAccountId
FKc5wpf2q8fjmwr9xhnvpxk7stt Performance Asc typeId
FKce78r5mq7swada1brt8m1x852 Performance Asc inventoryAccountId
FKd66hs7743k1fatmsronlq7l5v Performance Asc defaultProductId
FKehqatujavsaf5bfxw6n1c702t Performance Asc sizeUomId
FKeyunpip5cqrlelvtrcc1rukaq Performance Asc cogsAccountId
FKgo6p90v4bag4p6flg0wq9igl3 Performance Asc defaultBomId
FKhinn05th5neilep4wj1m7jw02 Performance Asc uomId
FKj7exys6ksj7osv0evb6seyjoi Performance Asc taxId
FKm4swbkft1n14fdtnnywbguyl5 Performance Asc varianceAccountId
FKOutsourcedReturnItem Performance Asc defaultOutsourcedReturnItemId
FKPoItemType Performance Asc defaultPoItemTypeId
partDescriptionIdx Performance Asc description
partNumIdx Performance Asc num
partUPCIdx Performance Asc upc
UKqnd735nbo16erc7luyqe8bchn Must be unique Asc num

Relationships

Close relationships within degrees of separation