Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PABXCallsSeq | int | 4 | null |
|
|
|||
| CallDate | datetime | 16,3 | √ | null |
|
|
||
| CallDuration | int | 4 | null |
|
|
|||
| CallCost | money | 21,4 | null |
|
|
|||
| CallDialledNumber | varchar | 24 | null |
|
|
|||
| CallPABXExtension | varchar | 10 | null |
|
|
|||
| CallPABXPIN | int | 4 | √ | null |
|
|
||
| CallPABXPINInReservedListFlag | bit | 1 | √ | null |
|
|
||
| CallPABXPINReservedDescription | varchar | 50 | null |
|
|
|||
| xiPABXSeq | int | 4 | null |
|
|
|||
| xiPABXTable | varchar | 20 | √ | null |
|
|
||
| ObjectLoansSeq | int | 4 | √ | null |
|
|
||
| ObjectLoanLoanedDate | datetime | 16,3 | √ | null |
|
|
||
| ObjectLoanReturnedDate | datetime | 16,3 | √ | null |
|
|
||
| ObjectLoanComment | varchar | 255 | null |
|
|
|||
| ObjectLoanPABXPIN | int | 4 | √ | null |
|
|
||
| ObjectLoanID | int | 4 | √ | null |
|
|
||
| ObjectLoanSurname | varchar | 30 | null |
|
|
|||
| ObjectLoanPreferred | varchar | 20 | null |
|
|
|||
| ObjectLoanMailName | varchar | 100 | null |
|
|
|||
| ObjectLoanPABXPINStatusCode | varchar | 15 | null |
|
|
|||
| ObjectLoanPABXPINStatusDescription | varchar | 50 | null |
|
|
|||
| ObjectLoanPABXPINStatusSynergyMeaning | varchar | 15 | null |
|
|
|||
| ObjectLoanDebtorID | int | 4 | √ | null |
|
|
||
| ObjectLoanDebtorSurname | varchar | 30 | null |
|
|
|||
| ObjectLoanDebtorPreferred | varchar | 20 | null |
|
|
|||
| ObjectLoanDebtorMailName | varchar | 100 | null |
|
|
|||
| ObjectBookingsSeq | int | 4 | √ | null |
|
|
||
| ObjectBookingDateFrom | datetime | 16,3 | √ | null |
|
|
||
| ObjectBookingDateTo | datetime | 16,3 | √ | null |
|
|
||
| ObjectBookingComment | varchar | 255 | √ | null |
|
|
||
| ObjectBookingsTypeCode | varchar | 15 | null |
|
|
|||
| ObjectBookingsTypeDescription | varchar | 30 | null |
|
|
|||
| ObjectBookingsTypePABXBillingMethod | varchar | 15 | null |
|
|
|||
| ObjectNumber | int | 4 | √ | null |
|
|
||
| ObjectDescription | varchar | 100 | null |
|
|
|||
| ObjectModel | varchar | 50 | null |
|
|
|||
| ObjectSerial | varchar | 50 | null |
|
|
|||
| ObjectAcquiredDate | datetime | 16,3 | √ | null |
|
|
||
| ObjectBarCode | varchar | 20 | null |
|
|
|||
| ObjectQuantity | int | 4 | √ | null |
|
|
||
| ObjectPhoneExtension | varchar | 15 | null |
|
|
|||
| ObjectTypesSeq | int | 4 | √ | null |
|
|
||
| ObjectTypeDescription | varchar | 50 | null |
|
|
|||
| ObjectTypeMeaning | varchar | 20 | null |
|
|
|||
| ObjectTypeCategoryCode | varchar | 15 | null |
|
|
|||
| ObjectTypeCategoryDescription | varchar | 50 | null |
|
|
|||
| ObjectTypeCategorySynergyMeaning | varchar | 15 | null |
|
|
|||
| ObjectStatusCode | varchar | 15 | null |
|
|
|||
| ObjectStatusDescription | varchar | 50 | null |
|
|
|||
| ObjectStatusSynergyMeaning | varchar | 15 | null |
|
|
|||
| ObjectRoomCode | varchar | 15 | null |
|
|
|||
| ObjectRoomDescription | varchar | 50 | null |
|
|
|||
| ObjectRoomCampusCode | varchar | 3 | null |
|
|
|||
| DebtorTransactionSeq | int | 4 | √ | null |
|
|
||
| DebtorTransactionDate | datetime | 16,3 | √ | null |
|
|
||
| DebtorTransactionStudentID | int | 4 | √ | null |
|
|
||
| DebtorTransactionPostingNumber | int | 4 | √ | null |
|
|
||
| DebtorTransactionFeeCode | varchar | 15 | null |
|
|
|||
| DebtorTransactionAmount | money | 21,4 | √ | null |
|
|
||
| DebtorTransactionPostingDate | datetime | 16,3 | √ | null |
|
|
||
| DebtorTransactionPostingDescription | varchar | 60 | √ | null |
|
|
||
| DebtorTransactionPostingCompleteFlag | bit | 1 | √ | null |
|
|
||
| DebtorTransactionPrintVersion | smallint | 2 | √ | null |
|
|
||
| DebtorTransactionDebtorID | int | 4 | √ | null |
|
|
||
| DebtorTransactionDebtorStudentID | int | 4 | √ | null |
|
|
||
| DebtorTransactionSurname | varchar | 30 | null |
|
|
|||
| DebtorTransactionPreferred | varchar | 20 | null |
|
|
|||
| DebtorTransactionMailName | varchar | 100 | null |
|
|
Table contained 0 rows