part_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FKq5ciejt20syacn3fb8qbc38i2 R
REVTYPE TINYINT 3 √ null
abcCode VARCHAR 1 √ null
accountingHash VARCHAR 30 √ null
accountingId VARCHAR 36 √ null
activeFlag BIT 1 √ null
adjustmentAccountId INT 10 √ null
alertNote VARCHAR 256 √ null
alwaysManufacture BIT 1 √ null
cogsAccountId INT 10 √ null
configurable BIT 1 √ null
consumptionRate DECIMAL 28,9 √ null
controlledFlag BIT 1 √ null
cycleCountTol DECIMAL 28,9 √ null
dateCreated DATETIME 26 √ null
defaultBomId INT 10 √ null
defaultOutsourcedReturnItemId INT 10 √ null
defaultPoItemTypeId INT 10 √ null
defaultProductId INT 10 √ null
description VARCHAR 252 √ null
details LONGTEXT 2147483647 √ null
height DECIMAL 28,9 √ null
inventoryAccountId INT 10 √ null
lastChangedUser VARCHAR 100 √ null
leadTime INT 10 √ null
leadTimeToFulfill INT 10 √ null
len DECIMAL 28,9 √ null
num VARCHAR 70 √ null
partClassId INT 10 √ null
part.id Implied Constraint R
pickInUomOfPart BIT 1 √ null
receivingTol DECIMAL 28,9 √ null
revision VARCHAR 15 √ null
scrapAccountId INT 10 √ null
serializedFlag BIT 1 √ null
sizeUomId INT 10 √ null
stdCost DECIMAL 28,9 √ null
taxId INT 10 √ null
trackingFlag BIT 1 √ null
typeId INT 10 √ null
uomId INT 10 √ null
uom.id Implied Constraint R
upc VARCHAR 31 √ null
url VARCHAR 256 √ null
varianceAccountId INT 10 √ null
weight DECIMAL 28,9 √ null
weightUomId INT 10 √ null
width DECIMAL 28,9 √ null
customFields JSON 1073741824 √ null

Indexes

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

Relationships

Close relationships within degrees of separation