Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ObjectNumber | int | 4 | null |
|
|
|||
| ParentObjectNumberNULLIfTop | int | 4 | √ | null |
|
|
||
| ParentObjectNumber | int | 4 | √ | null |
|
|
||
| Description | varchar | 50 | √ | null |
|
|
||
| DescriptionActual | varchar | 100 | √ | null |
|
|
||
| DescriptionFull | varchar | 100 | √ | null |
|
|
||
| ObjectTypesSeq | varchar | 15 | √ | null |
|
|
||
| ObjectTypesSeqActual | int | 4 | null |
|
|
|||
| DefaultChildObjectTypesSeq | int | 4 | √ | null |
|
|
||
| ObjectTypeCategoryCode | varchar | 15 | √ | null |
|
|
||
| ObjectTypeCategoryCodeActual | varchar | 15 | null |
|
|
|||
| Model | varchar | 50 | null |
|
|
|||
| Serial | varchar | 50 | null |
|
|
|||
| AcquiredDate | datetime | 16,3 | √ | null |
|
|
||
| BarCode | varchar | 20 | null |
|
|
|||
| MasterBarcode | varchar | 20 | √ | null |
|
|
||
| Quantity | int | 4 | null |
|
|
|||
| Room | varchar | 15 | √ | null |
|
|
||
| RoomActual | varchar | 15 | null |
|
|
|||
| AssetNumber | int | 4 | √ | null |
|
|
||
| AssetSynDatabaseCode | varchar | 5 | null |
|
|
|||
| OwnershipType | varchar | 15 | null |
|
|
|||
| Status | varchar | 15 | null |
|
|
|||
| ResponsibleID | int | 4 | √ | null |
|
|
||
| LoanedToID | int | 4 | √ | null |
|
|
||
| InsurancePoliciesSeq | int | 4 | √ | null |
|
|
||
| InsuranceValue | money | 21,4 | null |
|
|
|||
| InsuranceValuedDate | datetime | 16,3 | √ | null |
|
|
||
| MasterObjectFlag | bit | 1 | null |
|
|
|||
| ChildObjectFlagint | int | 4 | null |
|
|
|||
| ChildObjectFlag | bit | 1 | √ | null |
|
|
||
| ChildObjectFlagText | varchar | 5 | √ | null |
|
|
||
| SystemProcessNumber | int | 4 | √ | null |
|
|
||
| ActiveFlag | bit | 1 | null |
|
|
|||
| AccommodationLinkedID | int | 4 | √ | null |
|
|
||
| AccommodationTypeCode | varchar | 15 | null |
|
|
|||
| AccommodationRoomTypeCode | varchar | 15 | null |
|
|
|||
| AccommodationMealsAvailableFlag | bit | 1 | null |
|
|
|||
| AccommodationCapacity | int | 4 | √ | null |
|
|
||
| AccommodationAvailableDateFrom | datetime | 16,3 | √ | null |
|
|
||
| AccommodationAvailableDateTo | datetime | 16,3 | √ | null |
|
|
||
| AccommodationFacilities | varchar | 1000 | null |
|
|
|||
| AccommodationApprovedDate | datetime | 16,3 | √ | null |
|
|
||
| AccommodationApprovedUnder18Flag | bit | 1 | null |
|
|
|||
| AccommodationApprovedFemaleFlag | bit | 1 | null |
|
|
|||
| AccommodationDistanceFromSchool | smallint | 2 | √ | null |
|
|
||
| AccommodationPermissionToCheckFlag | bit | 1 | null |
|
|
|||
| AccommodationWelfareApprovedFlag | bit | 1 | null |
|
|
|||
| AccommodationReligionCode | varchar | 15 | null |
|
|
|||
| AccommodationComment | varchar | 2147483647 | null |
|
|
|||
| AccommodationAgentID | int | 4 | √ | null |
|
|
||
| AccommodationStatusCode | varchar | 15 | null |
|
|
|||
| AccommodationRating | varchar | 15 | null |
|
|
|||
| BookableFlag | bit | 1 | √ | null |
|
|
||
| PhoneExtension | varchar | 15 | null |
|
|
|||
| OverdueChargeAmount | money | 21,4 | null |
|
|
|||
| LocationDescription | varchar | 255 | √ | null |
|
|
Table contained 0 rows