taxrate


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
customer.taxRateId FKdjai2kvporlupbtelejvebh21 R
customer_aud.taxRateId Implied Constraint R
itemadjust.taxRateId FKhvpil6mta70ljvm479yx8s7vu R
itemadjust_aud.taxRateId Implied Constraint R
kititem.taxRateId FK69o19mjn68kqokl05iid361fu R
kititem_aud.taxRateId Implied Constraint R
part.taxId FKj7exys6ksj7osv0evb6seyjoi R
po.taxRateId FKkxodwtwddm7c1fpyq7bk86hu7 R
po_aud.taxRateId Implied Constraint R
poitem.taxId FKhpe2eson7udwig00uqhbe9q8d R
product.taxId FKomhtsqhqgt8v81tmu4vjb3kuf R
receiptitem.taxId FK7nnbc9ama1wr4yux4csnqit2v R
so.taxRateId FKd2xrax3c18ffbu5n9uxrq8rf8 R
so_aud.taxRateId Implied Constraint R
soitem.taxId FK6dht8w6kdbym0i89kb9l6iy80 R
vendor.taxRateId FKc6gsxq6y86dn2lv3ukdd0f5r2 R
vendor_aud.taxRateId Implied Constraint R
accountingHash VARCHAR 30 √ null
accountingId VARCHAR 36 √ null
activeFlag BIT 1 null
code VARCHAR 5 √ null
dateCreated DATETIME 26 √ null
dateLastModified DATETIME 26 √ null
defaultFlag BIT 1 null
description VARCHAR 256 √ null
name VARCHAR 31 null
orderTypeId INT 10 √ null
ordertype.id FK4p83gy522cshq5r4wn9l2xcme R
rate DOUBLE 22 √ null
taxAccountId INT 10 √ null
asaccount.id FK7yro48jdp8us6w877mdtrf7qi R
typeCode VARCHAR 25 √ null
typeId INT 10 null
taxratetype.id FKi7xub8a6vro89g9v0cyen4cd4 R
unitCost DECIMAL 28,9 √ null
vendorId INT 10 √ null
vendor.id FKtoec9s9y0ir9d9jc9n5jbtrvd R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK4p83gy522cshq5r4wn9l2xcme Performance Asc orderTypeId
FK7yro48jdp8us6w877mdtrf7qi Performance Asc taxAccountId
FKi7xub8a6vro89g9v0cyen4cd4 Performance Asc typeId
FKtoec9s9y0ir9d9jc9n5jbtrvd Performance Asc vendorId
UKmik31fyg32pxhh3ogjfnqbe6q Must be unique Asc name

Relationships

Close relationships within degrees of separation