AssetsArchive


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SEQ int identity 4 √ null
AssetNumber int 4 √ null
AssetTypeCode varchar 15 √ null
Description varchar 130 √ null
Model varchar 50 √ null
Serial varchar 50 √ null
GLSubAllocationCode varchar 15 √ null
BusinessUnit varchar 15 √ null
Building varchar 15 √ null
Room varchar 15 √ null
PrivateRate decimal 7,2 √ null
Quantity int 4 √ null
ID int 4 √ null
PurchasedDate datetime 16,3 √ null
PurchasedCost money 21,4 √ null
WrittenDownValue money 21,4 √ null
DepreciationYearToDate money 21,4 √ null
DateOfSale datetime 16,3 √ null
SalePrice money 21,4 √ null
ProfitOnSale money 21,4 √ null
CreditorTransactionSeq int 4 √ null
LastDepreciationDate datetime 16,3 √ null
GLJournalSeq int 4 √ null
PostingNumber int 4 √ null
PostingSource varchar 10 √ null
CostCentreCode varchar 15 √ null
MainAssetNumber int 4 √ null
AssignedID int 4 √ null
AssetCategory varchar 15 √ null
PhysicalCountDate datetime 16,3 √ null
PhysicalCountActual int 4 √ null
InsuranceNotifyDate datetime 16,3 √ null
InsuranceNotifyReference varchar 50 √ null
SalePostingNumber int 4 √ null
SalePostingSource varchar 10 √ null
SaleGLJournalSeq int 4 √ null
OrderNumber int 4 √ null
SaleQuantity int 4 √ null
SaleGeneratedFlag bit 1 √ null
CreatedDate datetime 16,3 √ null
CreatedBy varchar 50 √ null
ModifiedDate datetime 16,3 √ null
ModifiedBy varchar 50 √ null

Table contained -1 rows