receiptitem


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
postpoitem.receiptItemId FKp03lkg4xf890l9el812jkcvrx R
postsoitem.receiptItemId FKav50uh4o7bn076v5l19aqdikj R
billVendorFlag BIT 1 null
billedTotalCost DECIMAL 28,9 √ null
mcBilledTotalCost DECIMAL 28,9 √ null
carrierId INT 10 √ null
carrier.id FKgnpf1ucchpx48emkf1uy5ikwb R
customerId INT 10 √ null
customer.id FKa6ys8h5icpegfhvvtrqr0l6n3 R
dateBilled DATETIME 26 √ null
dateLastModified DATETIME 26 √ null
dateReceived DATETIME 26 √ null
dateReconciled DATETIME 26 √ null
deliverTo VARCHAR 30 √ null
landedTotalCost DECIMAL 28,9 √ null
mcLandedTotalCost DECIMAL 28,9 √ null
locationId INT 10 √ null
location.id Implied Constraint R
orderTypeId INT 10 null
ordertype.id FKoig8kulfvaw0scrgi86jdaw23 R
packageCount INT 10 √ null
partId INT 10 √ null
part.id FKidqu7nms2hqyr3qlgaiu95dud R
partTypeId INT 10 null
parttype.id FKtqs16jjg57yn5mg5d61osoeyd R
poItemId INT 10 √ null
poitem.id FKct73aik026yusq2aemgxqy7a2 R
qty DECIMAL 28,9 √ null
reason VARCHAR 90 √ null
receiptId INT 10 null
receipt.id FKhgu7j8jnv2c6h0sraqh2pqqph R
refNo VARCHAR 20 √ null
responsibilityId INT 10 √ null
responsibility.id Implied Constraint R
shipItemId INT 10 √ null
soItemId INT 10 √ null
soitem.id FKnm4lsdmiir6vr44nn6ud4snqj R
statusId INT 10 null
receiptitemstatus.id FK5vo9fll6inbxe82m7utbm20rm R
tagId BIGINT 19 √ null
tag.id Implied Constraint R
taxId INT 10 √ null
taxrate.id FK7nnbc9ama1wr4yux4csnqit2v R
taxRate DOUBLE 22 √ null
trackingNum VARCHAR 30 √ null
typeId INT 10 null
receiptitemtype.id FKcddq9ae9kw17avpo74s84mamf R
uomId INT 10 null
uom.id FK1s1h8w2bxtnva4248h7w6e0or R
xoItemId INT 10 √ null
xoitem.id FKp5ylf9bhlswke1698pvbdw1dj R
outsourcedCost DECIMAL 28,9 √ null
carrierServiceId INT 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK1s1h8w2bxtnva4248h7w6e0or Performance Asc uomId
FK5vo9fll6inbxe82m7utbm20rm Performance Asc statusId
FK7nnbc9ama1wr4yux4csnqit2v Performance Asc taxId
FKa6ys8h5icpegfhvvtrqr0l6n3 Performance Asc customerId
FKcddq9ae9kw17avpo74s84mamf Performance Asc typeId
FKct73aik026yusq2aemgxqy7a2 Performance Asc poItemId
FKgnpf1ucchpx48emkf1uy5ikwb Performance Asc carrierId
FKhgu7j8jnv2c6h0sraqh2pqqph Performance Asc receiptId
FKidqu7nms2hqyr3qlgaiu95dud Performance Asc partId
FKnm4lsdmiir6vr44nn6ud4snqj Performance Asc soItemId
FKoig8kulfvaw0scrgi86jdaw23 Performance Asc orderTypeId
FKp5ylf9bhlswke1698pvbdw1dj Performance Asc xoItemId
FKtqs16jjg57yn5mg5d61osoeyd Performance Asc partTypeId
ReceiptItemDateBilledIdx Performance Asc dateBilled
ReceiptItemDateReceivedIdx Performance Asc dateReceived
ReceiptItemDateReconciledIdx Performance Asc dateReconciled

Relationships

Close relationships within degrees of separation