Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AssetNumber | int | 4 | √ | null |
|
|
||
| AssetCount | int | 4 | √ | null |
|
|
||
| AssetNumberMax | int | 4 | √ | null |
|
|
||
| CreditorTransactionSeq | int | 4 | null |
|
|
|||
| GLJournalSeq | int | 4 | null |
|
|
|||
| AssetTypeCode | varchar | 15 | √ | null |
|
|
||
| Description | varchar | 130 | √ | null |
|
|
||
| Model | varchar | 50 | √ | null |
|
|
||
| Serial | varchar | 50 | √ | null |
|
|
||
| GLSubAllocationCode | varchar | 15 | √ | null |
|
|
||
| Quantity | int | 4 | √ | null |
|
|
||
| MainAssetNumberMin | int | 4 | √ | null |
|
|
||
| MainAssetNumberMax | int | 4 | √ | null |
|
|
||
| PrivateRate | decimal | 7,2 | √ | null |
|
|
||
| PurchasedDate | datetime | 16,3 | √ | null |
|
|
||
| PurchasedCost | money | 21,4 | √ | null |
|
|
||
| CostCentreCode | varchar | 15 | √ | null |
|
|
||
| BusinessUnit | varchar | 15 | √ | null |
|
|
||
| Building | varchar | 15 | √ | null |
|
|
||
| Room | varchar | 15 | √ | null |
|
|
||
| AssetCategory | varchar | 15 | √ | null |
|
|
||
| AssignedID | int | 4 | √ | null |
|
|
||
| InsuranceNotifyDate | datetime | 16,3 | √ | null |
|
|
||
| InsuranceNotifyReference | varchar | 50 | √ | null |
|
|
||
| OrderNumber | int | 4 | √ | null |
|
|
||
| LinkedAssetFlag | int | 4 | null |
|
|
|||
| MainLinkedAssetFlag | int | 4 | null |
|
|
|||
| MultipleAssetFlag | int | 4 | null |
|
|
|||
| MultipleAssetMainEachFlag | int | 4 | null |
|
|
|||
| MultipleAssetMainFirstFlag | int | 4 | null |
|
|
Table contained 0 rows