po


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
addressmultilinepoview.POID Implied Constraint R
poitem.poId FK5poexh8btghl7kg7bj3n92rwp R
poitem_aud.poId Implied Constraint R
postpo.poId FKflcgqogakpdiphosae64nie5d R
receipt.poId FKk8sytdefvbkrsflw0969hegxk R
receipt_aud.poId Implied Constraint R
ship.poId FKr80r1a8p7al7rupcrfsspu16w R
ship_aud.poId Implied Constraint R
shipcartonpoview.POID Implied Constraint R
buyer VARCHAR 100 √ null
buyerId INT 10 null
sysuser.id FKgixl2jgj96g06pvy04yn6utvw R
carrierId INT 10 null
carrier.id FK79ybfw24fkkuhhx7t2ubq4swp R
carrierServiceId INT 10 √ null
carrierservice.id FKPoCarrierService R
currencyId INT 10 √ null
currency.id FKrr9ng5rglebl56v6gh7dpxwjr R
currencyRate DOUBLE 22 √ null
customerSO VARCHAR 25 √ null
dateCompleted DATETIME 26 √ null
dateConfirmed DATETIME 26 √ null
dateCreated DATETIME 26 √ null
dateFirstShip DATETIME 26 √ null
dateIssued DATETIME 26 √ null
dateLastModified DATETIME 26 √ null
dateRevision DATETIME 26 √ null
deliverTo VARCHAR 30 √ null
email VARCHAR 256 √ null
fobPointId INT 10 null
fobpoint.id FK9v45cfml9phvbpnno56yavhsv R
issuedByUserId INT 10 √ null
sysuser.id FKPoIssuedByUser R
locationGroupId INT 10 null
locationgroup.id FKns1kxfo7dgixcekw34hu4bnt4 R
note LONGTEXT 2147483647 √ null
num VARCHAR 25 null
paymentTermsId INT 10 null
paymentterms.id FKe5r6hfyipyk5lrny0ndcxwhqn R
phone VARCHAR 256 √ null
qbClassId INT 10 √ null
qbclass.id FKlb47qhwbc6t1ravynsr45uh8k R
remitAddress VARCHAR 90 √ null
remitCity VARCHAR 30 √ null
remitCountryId INT 10 √ null
remitStateId INT 10 √ null
remitToName VARCHAR 60 √ null
remitZip VARCHAR 10 √ null
revisionNum INT 10 √ null
shipTermsId INT 10 null
shipterms.id FKtnvorwamne54x6ughnkw10osw 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
postatus.id FKr6htame66mxfb2w8gs32vjojn R
taxRateId INT 10 √ null
taxrate.id FKkxodwtwddm7c1fpyq7bk86hu7 R
taxRateName VARCHAR 31 √ null
totalIncludesTax BIT 1 null
totalTax DECIMAL 28,9 √ null
typeId INT 10 null
potype.id FKq4xe0mr2qrhbashos3evvmgky R
url VARCHAR 256 √ null
username VARCHAR 100 √ null
vendorContact VARCHAR 30 √ null
vendorId INT 10 null
vendor.id FKq3hdd263xn41vrctjg1g6txud R
vendorSO VARCHAR 25 √ null
customFields JSON 1073741824 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK79ybfw24fkkuhhx7t2ubq4swp Performance Asc carrierId
FK9v45cfml9phvbpnno56yavhsv Performance Asc fobPointId
FKe5r6hfyipyk5lrny0ndcxwhqn Performance Asc paymentTermsId
FKgixl2jgj96g06pvy04yn6utvw Performance Asc buyerId
FKkxodwtwddm7c1fpyq7bk86hu7 Performance Asc taxRateId
FKlb47qhwbc6t1ravynsr45uh8k Performance Asc qbClassId
FKns1kxfo7dgixcekw34hu4bnt4 Performance Asc locationGroupId
FKPoCarrierService Performance Asc carrierServiceId
FKPoIssuedByUser Performance Asc issuedByUserId
FKq3hdd263xn41vrctjg1g6txud Performance Asc vendorId
FKq4xe0mr2qrhbashos3evvmgky Performance Asc typeId
FKr6htame66mxfb2w8gs32vjojn Performance Asc statusId
FKrr9ng5rglebl56v6gh7dpxwjr Performance Asc currencyId
FKtnvorwamne54x6ughnkw10osw Performance Asc shipTermsId
UKdp7rb75np4g21k831rpgdpfgi Must be unique Asc num

Relationships

Close relationships within degrees of separation