vAssetDepreciation


Columns

Column Type Size Nulls Auto Default Children Parents Comments
AssetNumber int 4 null
AssetDescription varchar 130 null
AssetModel varchar 50 null
AssetSerial varchar 50 null
AssetGLSubAllocationCode varchar 15 null
AssetRoom varchar 15 null
AssetBuilding varchar 15 null
AssetBusinessUnit varchar 15 null
AssetPrivateUseRate decimal 7,2 null
AssetQuantity int 4 null
AssetPurchasedCost money 21,4 null
AssetPurchasedDate datetime 16,3 √ null
AssetPurchasedGLYear int 4 √ null
AssetWrittenDownValue money 21,4 null
AssetLastDepreciationDate datetime 16,3 √ null
AssetDepreciationYearToDate money 21,4 null
AssetPhysicalCountDate datetime 16,3 √ null
AssetPhysicalCountActual int 4 √ null
AssetInsuranceNotifyDate datetime 16,3 √ null
AssetInsuranceNotifyReference varchar 50 null
AssetSalePrice money 21,4 null
AssetDateOfSale datetime 16,3 √ null
AssetSaleGLYear int 4 √ null
AssetProfitOnSale money 21,4 null
AssetSoldFlag int 4 null
AssetTypeCode varchar 15 √ null
AssetTypeDescription varchar 50 √ null
AssetTypeGLCode varchar 15 √ null
AssetTypeGLCodeDescription varchar 50 √ null
AssetTypeGLCodeActiveFlag bit 1 √ null
AssetTypeDepreciationRate decimal 7,2 √ null
AssetTypeDepreciationMethod char 1 √ null
AssetTypeDepreciationDesc varchar 8 null
AssetTypeGLDepreciation varchar 15 √ null
AssetTypeGLDepreciationDesc varchar 50 √ null
AssetTypeGLDepreciationActiveFlag bit 1 √ null
AssetTypeGLAccruedDepreciation varchar 15 √ null
AssetTypeGLAccruedDepnDesc varchar 50 √ null
AssetTypeGLAccruedDepnActiveFlag bit 1 √ null
AssetTypeGLProfitLoss varchar 15 √ null
AssetTypeGLProfitLossDesc varchar 50 √ null
AssetTypeGLProfitLossActiveFlag bit 1 √ null
AssetTypeGLPrivateUse varchar 15 √ null
AssetTypeGLPrivateUseDesc varchar 50 √ null
AssetTypeGLPrivateUseActiveFlag bit 1 √ null
SourceID int 4 √ null
SourceName varchar 100 √ null
SourceAddressFull varchar 200 √ null
SourceAddressComma varchar 200 √ null
AssignedID int 4 null
AssignedName varchar 100 √ null
AssignedAddressFull varchar 200 √ null
AssignedAddressComma varchar 200 √ null
FinanceWrittenDownDate datetime 16,3 √ null
FinanceLastDepreciationDate datetime 16,3 √ null
MainAssetFlag int 4 null
MainAssetNumber int 4 null
MainAssetTypeCode varchar 15 √ null
MainAssetDescription varchar 130 √ null
MainAssetQuantity int 4 √ null
MainAssetPurchasedCost money 21,4 √ null
MainAssetPurchasedDate datetime 16,3 √ null
MainAssetWrittenDownValue money 21,4 √ null
AssetCostCentreCode varchar 15 null
CostCentreDescription varchar 100 √ null
AssetCategory varchar 15 √ null
AssetCategoryDescription varchar 50 √ null
AssetPostingNumber int 4 null
AssetPostingSource varchar 10 null
AssetGLJournalSeq int 4 null
AssetCreditorTransactionSeq int 4 null
AssetPurchOrderNumber int 4 √ null
AssetPurchOrderLine int 4 √ null
AssetDepreciationPostingNumber int 4 √ null
AssetDepreciationType char 1 √ null
AssetDepreciationDate datetime 16,3 √ null
AssetDepreciationAmount money 21,4 √ null
PostingDate datetime 16,3 √ null
PostingDescription varchar 60 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views