CapEx_tblItem

48150 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ItemID int 4 null
VW_CapEx_RequestItems.ItemID Implied ConstraintR
RequestN varchar 10 null
Description varchar 2147483647 √ null
Cost money 21,4 √ null
Quantity int 4 √ null
Total money 21,4 √ null
RequestID int 4 √ null
CapEx_tblRequest.RequestID Implied ConstraintR
AVA_insdate datetime2 16 (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK_tblItem Primary key Asc ItemID

Relationships

Close relationships within degrees of separation