po_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FKtcxtnjt3c8qbv560db3dl01i8 R
REVTYPE TINYINT 3 √ null
buyer VARCHAR 100 √ null
buyerId INT 10 √ null
carrierId INT 10 √ null
carrier.id Implied Constraint R
carrierServiceId INT 10 √ null
currencyId INT 10 √ null
currency.id Implied Constraint 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
dateRevision DATETIME 26 √ null
deliverTo VARCHAR 30 √ null
email VARCHAR 256 √ null
fobPointId INT 10 √ null
fobpoint.id Implied Constraint R
issuedByUserId INT 10 √ null
locationGroupId INT 10 √ null
note LONGTEXT 2147483647 √ null
num VARCHAR 25 √ null
paymentTermsId INT 10 √ null
paymentterms.id Implied Constraint R
phone VARCHAR 256 √ null
qbClassId INT 10 √ null
qbclass.id Implied Constraint 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
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
taxRateId INT 10 √ null
taxrate.id Implied Constraint R
taxRateName VARCHAR 31 √ null
totalIncludesTax BIT 1 √ null
totalTax DECIMAL 28,9 √ null
typeId INT 10 √ null
url VARCHAR 256 √ null
username VARCHAR 100 √ null
vendorContact VARCHAR 30 √ null
vendorId INT 10 √ null
vendor.id Implied Constraint R
vendorSO VARCHAR 25 √ null
customFields JSON 1073741824 √ null

Indexes

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

Relationships

Close relationships within degrees of separation