so


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
addressmultilinesoview.SOID Implied Constraint R
mo.soId FK3gxa9fjew75ayg25qbye2r645 R
mo_aud.soId Implied Constraint R
postransaction.soId FKclhwjbgh7nyfv54ie4d2ojuu1 R
postransaction_aud.soId Implied Constraint R
postso.soId FKc1drjhmt7ltmm9vs6m75hme2r R
receipt.soId FK9rp80kxbn28aau62wg4m9lgis R
receipt_aud.soId Implied Constraint R
ship.soId FKhe2bfi51splcp6r21qfbqh6ka R
ship_aud.soId Implied Constraint R
shipcartonsoview.SOID Implied Constraint R
shipnumview.soid Implied Constraint R
shippingemailview.SOID Implied Constraint R
soitem.soId FKcebj5n3me5rnbhlg99n6as0m R
soitem_aud.soId Implied Constraint R
totalpaidview.soId Implied Constraint R
woitem.sortId Implied Constraint R
woitem_aud.sortId Implied Constraint R
billToAddress VARCHAR 90 √ null
billToCity VARCHAR 30 √ null
billToCountryId INT 10 √ null
billToName VARCHAR 60 √ null
billToStateId INT 10 √ null
billToZip VARCHAR 10 √ null
calCategoryId INT 10 √ null
calcategory.id FKsoCalCategory R
carrierId INT 10 null
carrier.id FKk6i192qsul06clopj5ob27nt9 R
carrierServiceId INT 10 √ null
carrierservice.id FKm215p3f6igsm3crbqq7nweok1 R
cost DECIMAL 28,9 √ null
createdByUserId INT 10 √ null
sysuser.id FKSoCreatedByUserId R
currencyId INT 10 √ null
currency.id FKnf15cjucepcvuj3mki9ccea0u R
currencyRate DOUBLE 22 √ null
customerContact VARCHAR 30 √ null
customerId INT 10 null
customer.id FKd10kh3o7nusuv0bh378q7nw2t R
customerPO VARCHAR 25 √ null
dateCalStart DATETIME 26 √ null
dateCalEnd DATETIME 26 √ null
dateCompleted DATETIME 26 √ null
dateCreated DATETIME 26 √ null
dateExpired DATETIME 26 √ null
dateFirstShip DATETIME 26 √ null
dateIssued DATETIME 26 √ null
dateLastModified DATETIME 26 √ null
dateRevision DATETIME 26 √ null
email VARCHAR 256 √ null
estimatedTax DECIMAL 28,9 √ null
fobPointId INT 10 null
fobpoint.id FKfnw0ujo5hna8wul5dedib947e R
locationGroupId INT 10 null
locationgroup.id FKrypf38gxheyggehl4ssm4l2mt R
mcTotalTax DECIMAL 28,9 √ null
note LONGTEXT 2147483647 √ null
num VARCHAR 25 null
paymentLink VARCHAR 256 √ null
paymentTermsId INT 10 null
paymentterms.id FKe0itupe5oygyvberlmd9mfni0 R
phone VARCHAR 256 √ null
priorityId INT 10 null
priority.id FKtceqy7ddohwa7ftaluxt9rir3 R
qbClassId INT 10 √ null
qbclass.id FK8vbusriy3fhgbfn893wp6d7ia R
registerId INT 10 √ null
register.id Implied Constraint R
shipToResidential BIT 1 null
revisionNum INT 10 √ null
salesman VARCHAR 100 √ null
salesmanId INT 10 null
sysuser.id FKj68pnq4bc4buyden2dik5nqf5 R
salesmanInitials VARCHAR 5 √ null
shipTermsId INT 10 √ null
shipterms.id FKpas03n83xxcfccgg0406rxkvv R
shipToAddress VARCHAR 90 √ null
shipToCity VARCHAR 30 √ null
shipToCountryId INT 10 √ null
ship.id Implied Constraint R
shipToName VARCHAR 60 √ null
shipToStateId INT 10 √ null
ship.id Implied Constraint R
shipToZip VARCHAR 10 √ null
statusId INT 10 null
sostatus.id FKcf3l72blx98ducs1ti11soy3y R
taxRate DOUBLE 22 √ null
taxRateId INT 10 √ null
taxrate.id FKd2xrax3c18ffbu5n9uxrq8rf8 R
taxRateName VARCHAR 31 √ null
toBeEmailed BIT 1 null
toBePrinted BIT 1 null
totalIncludesTax BIT 1 null
totalTax DECIMAL 28,9 √ null
subTotal DECIMAL 28,9 0.000000000
totalPrice DECIMAL 28,9 0.000000000
typeId INT 10 null
sotype.id FK2dderdafefd4w7yixduwc0crq R
url VARCHAR 256 √ null
username VARCHAR 100 √ null
vendorPO VARCHAR 25 √ null
customFields JSON 1073741824 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK2dderdafefd4w7yixduwc0crq Performance Asc typeId
FK8vbusriy3fhgbfn893wp6d7ia Performance Asc qbClassId
FKcf3l72blx98ducs1ti11soy3y Performance Asc statusId
FKd10kh3o7nusuv0bh378q7nw2t Performance Asc customerId
FKd2xrax3c18ffbu5n9uxrq8rf8 Performance Asc taxRateId
FKe0itupe5oygyvberlmd9mfni0 Performance Asc paymentTermsId
FKfnw0ujo5hna8wul5dedib947e Performance Asc fobPointId
FKj68pnq4bc4buyden2dik5nqf5 Performance Asc salesmanId
FKk6i192qsul06clopj5ob27nt9 Performance Asc carrierId
FKm215p3f6igsm3crbqq7nweok1 Performance Asc carrierServiceId
FKnf15cjucepcvuj3mki9ccea0u Performance Asc currencyId
FKpas03n83xxcfccgg0406rxkvv Performance Asc shipTermsId
FKrypf38gxheyggehl4ssm4l2mt Performance Asc locationGroupId
FKsoCalCategory Performance Asc calCategoryId
FKSoCreatedByUserId_idx Performance Asc createdByUserId
FKtceqy7ddohwa7ftaluxt9rir3 Performance Asc priorityId
UK6u05sv6ksninol838pj0no8s Must be unique Asc num

Relationships

Close relationships within degrees of separation