Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AssetSeq | int identity | 4 | √ | null |
|
|
||
| TransactionSeq | int | 4 | ((0)) |
|
|
|||
| AssetTypeCode | varchar | 15 | ('') |
|
|
|||
| Description | varchar | 130 | ('') |
|
|
|||
| Model | varchar | 50 | ('') |
|
|
|||
| Serial | varchar | 50 | ('') |
|
|
|||
| GLSubAllocationCode | varchar | 15 | ('') |
|
|
|||
| Quantity | int | 4 | ((0)) |
|
|
|||
| PrivateRate | decimal | 7,2 | ((0)) |
|
|
|||
| PurchasedDate | datetime | 16,3 | √ | null |
|
|
||
| PurchasedCost | money | 21,4 | ((0)) |
|
|
|||
| CostCentreCode | varchar | 15 | ('') |
|
|
|||
| BusinessUnit | varchar | 15 | ('') |
|
|
|||
| Building | varchar | 15 | ('') |
|
|
|||
| Room | varchar | 15 | ('') |
|
|
|||
| LinkedAssetFlag | bit | 1 | ((0)) |
|
|
|||
| MainLinkedAssetFlag | bit | 1 | ((0)) |
|
|
|||
| LinkedAssetNumber | int | 4 | ((0)) |
|
|
|||
| LinkedAssetSeq | int | 4 | ((0)) |
|
|
|||
| AssetNumber | int | 4 | ((0)) |
|
|
|||
| AssetCategory | varchar | 15 | ('') |
|
|
|||
| AssignedID | int | 4 | ((0)) |
|
|
|||
| InsuranceNotifyDate | datetime | 16,3 | √ | null |
|
|
||
| InsuranceNotifyReference | varchar | 50 | ('') |
|
|
|||
| OrderNumber | int | 4 | √ | null |
|
|
||
| CreateMultipleFlag | bit | 1 | ((0)) |
|
|
|||
| CreateMultipleMainEachFlag | bit | 1 | ((0)) |
|
|
|||
| CreateMultipleMainFirstFlag | bit | 1 | ((0)) |
|
|
Table contained -1 rows