Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| AssetNumber | int | 4 | ((0)) |
|
|
|||||
| AssetTypeCode | varchar | 15 | ('') |
|
|
|||||
| Description | varchar | 130 | ('') |
|
|
|||||
| Model | varchar | 50 | ('') |
|
|
|||||
| Serial | varchar | 50 | ('') |
|
|
|||||
| GLSubAllocationCode | varchar | 15 | ('') |
|
|
|||||
| BusinessUnit | varchar | 15 | ('') |
|
|
|||||
| Building | varchar | 15 | ('') |
|
|
|||||
| Room | varchar | 15 | ('') |
|
|
|||||
| PrivateRate | decimal | 7,2 | ((0.00)) |
|
|
|||||
| Quantity | int | 4 | ((0)) |
|
|
|||||
| ID | int | 4 | ((0)) |
|
|
|||||
| PurchasedDate | datetime | 16,3 | √ | null |
|
|
||||
| PurchasedCost | money | 21,4 | ((0.00)) |
|
|
|||||
| WrittenDownValue | money | 21,4 | ((0.00)) |
|
|
|||||
| DepreciationYearToDate | money | 21,4 | ((0.00)) |
|
|
|||||
| DateOfSale | datetime | 16,3 | √ | null |
|
|
||||
| SalePrice | money | 21,4 | ((0)) |
|
|
|||||
| ProfitOnSale | money | 21,4 | ((0.00)) |
|
|
|||||
| CreditorTransactionSeq | int | 4 | ((0)) |
|
|
|||||
| LastDepreciationDate | datetime | 16,3 | √ | null |
|
|
||||
| GLJournalSeq | int | 4 | ((0)) |
|
|
|||||
| PostingNumber | int | 4 | ((0)) |
|
|
|||||
| PostingSource | varchar | 10 | ('') |
|
|
|||||
| CostCentreCode | varchar | 15 | ('') |
|
|
|||||
| MainAssetNumber | int | 4 | ((0)) |
|
|
|||||
| AssignedID | int | 4 | ((0)) |
|
|
|||||
| AssetCategory | varchar | 15 | √ | ('') |
|
|
||||
| PhysicalCountDate | datetime | 16,3 | √ | null |
|
|
||||
| PhysicalCountActual | int | 4 | √ | null |
|
|
||||
| InsuranceNotifyDate | datetime | 16,3 | √ | null |
|
|
||||
| InsuranceNotifyReference | varchar | 50 | ('') |
|
|
|||||
| SalePostingNumber | int | 4 | ((0)) |
|
|
|||||
| SalePostingSource | varchar | 10 | ('') |
|
|
|||||
| SaleGLJournalSeq | int | 4 | ((0)) |
|
|
|||||
| OrderNumber | int | 4 | √ | null |
|
|
||||
| SaleQuantity | int | 4 | ((0)) |
|
|
|||||
| SaleGeneratedFlag | bit | 1 | ((0)) |
|
|
|||||
| CreatedDate | datetime | 16,3 | √ | null |
|
|
||||
| CreatedBy | varchar | 50 | √ | ('') |
|
|
||||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
||||
| ModifiedBy | varchar | 50 | √ | ('') |
|
|
||||
| OverrideDepreciationRate | decimal | 7,2 | √ | null |
|
|
||||
| OverrideDepreciationMethod | char | 1 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Assets | Primary key | Asc | AssetNumber |
| AK_Assets_AssetTypeCode | Performance | Asc | AssetTypeCode |
| AK_Assets_AssetTypeCode_AssetNumber | Performance | Asc/Asc | AssetNumber + AssetTypeCode |
| AK_Assets_AssignedID | Performance | Asc | AssignedID |
| AK_Assets_CreditorTransactionSeq | Performance | Asc | CreditorTransactionSeq |
| AK_Assets_DateOfSale_PurchasedDate_includes | Performance | Asc/Asc | DateOfSale + PurchasedDate |
| AK_Assets_ID | Performance | Asc | ID |
| AK_Assets_MainAssetNumber | Performance | Asc | MainAssetNumber |
| AK_Assets_PostingNumber | Performance | Asc | PostingNumber |
| AK_Assets_SaleGLJournalSeq | Performance | Asc | SaleGLJournalSeq |
| AK_Assets_Serial | Performance | Asc | Serial |
Relationships
Close relationships within degrees of separation
