vendor


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
location.defaultVendorId FKo7qub3x04qf08t0p66p4kjo62 R
po.vendorId FKq3hdd263xn41vrctjg1g6txud R
po_aud.vendorId Implied Constraint R
rmaitem.vendorId FK7wejyg9945fkksqjr94mmx1ko R
rmaitem_aud.vendorId Implied Constraint R
taxrate.vendorId FKtoec9s9y0ir9d9jc9n5jbtrvd R
taxrate_aud.vendorId Implied Constraint R
vendorcontactview.VENDORID Implied Constraint R
vendorcostrule.vendorId FK28xtr178lx6dwthse9a07m9tw R
vendorcostrule_aud.vendorId Implied Constraint R
vendorparts.vendorId FKcf0jm5pdmdpf5qw6j36txx449 R
vendorparts_aud.vendorId Implied Constraint R
accountId INT 10 null
account.id FKjwg91uh46u5hf3h71nd1mbj40 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 FKnrlf4sdg58qevuqn6c91e1kbf R
currencyRate DOUBLE 22 √ null
dateEntered DATETIME 26 √ null
dateLastModified DATETIME 26 √ null
defaultCarrierId INT 10 null
carrier.id FK1j3nbsjqg4lmst3gn7fbay8vm R
defaultCarrierServiceId INT 10 √ null
carrierservice.id FKVendorCarrierService R
defaultPaymentTermsId INT 10 null
paymentterms.id FKlw0m775ep4h0g56332mvlniq8 R
defaultShipTermsId INT 10 null
shipterms.id FK7gb4jl1tn8271gsv3lj9u8qg5 R
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
vendorstatus.id FK786fmhlwef0lumhmtcdgaww5l R
sysUserId INT 10 √ null
sysuser.id Implied Constraint R
taxRateId INT 10 √ null
taxrate.id FKc6gsxq6y86dn2lv3ukdd0f5r2 R
url VARCHAR 256 √ null
customFields JSON 1073741824 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK1j3nbsjqg4lmst3gn7fbay8vm Performance Asc defaultCarrierId
FK786fmhlwef0lumhmtcdgaww5l Performance Asc statusId
FK7gb4jl1tn8271gsv3lj9u8qg5 Performance Asc defaultShipTermsId
FKc6gsxq6y86dn2lv3ukdd0f5r2 Performance Asc taxRateId
FKjwg91uh46u5hf3h71nd1mbj40 Performance Asc accountId
FKlw0m775ep4h0g56332mvlniq8 Performance Asc defaultPaymentTermsId
FKnrlf4sdg58qevuqn6c91e1kbf Performance Asc currencyId
FKVendorCarrierService Performance Asc defaultCarrierServiceId
UKkdb9k9pj6r0qvq5n36n0pdok2 Must be unique Asc name
vendorAccountNumIdx Performance Asc accountNum

Relationships

Close relationships within degrees of separation