Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| DepreciationSeq | int identity | 4 | √ | null |
|
|
||||
| AssetNumber | int | 4 | ((0)) |
|
|
|||||
| PostingNumber | int | 4 | ((0)) |
|
|
|||||
| DepreciationType | char | 1 | ('') |
|
|
|||||
| DepreciationDate | datetime | 16,3 | √ | null |
|
|
||||
| DepreciationAmount | money | 21,4 | ((0)) |
|
|
|||||
| DepreciationRate | decimal | 7,2 | ((0.00)) |
|
|
|||||
| DepreciationMethod | char | 1 | ('') |
|
|
|||||
| InitialWrittenDownValue | money | 21,4 | ((0)) |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__AssetDepreciatio__2057CCD0 | Primary key | Asc | DepreciationSeq |
| AK_AssetDepreciation_AssetNumber | Performance | Asc | AssetNumber |
| AK_AssetDepreciation_PostingNumber | Performance | Asc | PostingNumber |
Relationships
Close relationships within degrees of separation
