pickitem_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FKt57jp0r9d68qcyax4tcnccxol R
REVTYPE TINYINT 3 √ null
destTagId BIGINT 19 √ null
orderId INT 10 √ null
orderTypeId INT 10 √ null
ordertype.id Implied Constraint R
partId INT 10 √ null
part.id Implied Constraint R
pickId INT 10 √ null
pick.id Implied Constraint R
poItemId INT 10 √ null
qty DECIMAL 28,9 √ null
shipId INT 10 √ null
ship.id Implied Constraint R
slotNum INT 10 √ null
soItemId INT 10 √ null
srcLocationId INT 10 √ null
srcTagId BIGINT 19 √ null
statusId INT 10 √ null
tagId BIGINT 19 √ null
tag.id Implied Constraint R
typeId INT 10 √ null
uomId INT 10 √ null
uom.id Implied Constraint R
woItemId INT 10 √ null
xoItemId INT 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc id + REV
FKt57jp0r9d68qcyax4tcnccxol Performance Asc REV

Relationships

Close relationships within degrees of separation