ObjectsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ObjectNumber int 4 null
ObjectModifiedDate datetime 16,3 √ null
ObjectModifiedBy varchar 30 √ null
ParentObjectNumber int 4 √ null
Description varchar 100 null
ObjectTypeCategoryCode varchar 15 null
Model varchar 50 null
Serial varchar 50 null
AcquiredDate datetime 16,3 √ null
BarCode varchar 20 null
Quantity int 4 null
Room varchar 15 null
AssetNumber int 4 √ null
AssetSynDatabaseCode varchar 5 null
OwnershipType varchar 15 null
Status varchar 15 null
ResponsibleID int 4 √ null
LoanedToID int 4 √ null
InsurancePolicyCode varchar 15 null
InsuranceValue money 21,4 null
InsuranceValuedDate datetime 16,3 √ null
MasterObjectFlag bit 1 null
SystemProcessNumber int 4 √ null
ObjectTypesSeq int 4 null
DefaultChildObjectTypesSeq int 4 √ null
InsurancePoliciesSeq int 4 √ null
ActiveFlag bit 1 null
PhoneExtension varchar 15 null
ObjectsHistorySeq int identity 4 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_ObjectsHistory_ObjectsHistorySeq Primary key Asc ObjectsHistorySeq