vendor_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FKee0v1kejt5e00h5b2jfq2pvmu R
REVTYPE TINYINT 3 √ null
accountId INT 10 √ null
account.id Implied Constraint R
accountNum VARCHAR 30 √ null
accountingHash VARCHAR 30 √ null
accountingId VARCHAR 36 √ null
activeFlag BIT 1 √ null
creditLimit DECIMAL 28,9 √ null
currencyId INT 10 √ null
currency.id Implied Constraint R
currencyRate DOUBLE 22 √ null
dateEntered DATETIME 26 √ null
defaultCarrierId INT 10 √ null
defaultCarrierServiceId INT 10 √ null
defaultPaymentTermsId INT 10 √ null
defaultShipTermsId INT 10 √ null
lastChangedUser VARCHAR 100 √ null
leadTime INT 10 √ null
minOrderAmount DECIMAL 28,9 √ null
name VARCHAR 41 √ null
note VARCHAR 256 √ null
statusId INT 10 √ null
sysUserId INT 10 √ null
sysuser.id Implied Constraint R
taxRateId INT 10 √ null
taxrate.id Implied Constraint R
url VARCHAR 256 √ null
customFields JSON 1073741824 √ null

Indexes

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

Relationships

Close relationships within degrees of separation