Bewerken: Department

Sectie: Properties

Reden:

## Properties

| Property | Type | Kolom | Width | Nullable | Default |
|----------|------|-------|-------|----------|---------|
| Id | UltimoString | DEPID | 11 | false |  |
| AddressLine1 | UltimoString | DEPADDRESSLINE1 | 100 | true |  |
| AddressLine2 | UltimoString | DEPADDRESSLINE2 | 100 | true |  |
| CadReportColor | UltimoString | DEPCADREPORTCOLOR | 6 | true |  |
| CadReportPattern | CadReportPattern | DEPCRPTPID |  | true |  |
| CadReportPatternAngle | Int32 | DEPCADREPORTPATTERNANGLE |  | false | 0 |
| CadReportPatternScale | Decimal | DEPCADREPORTPATTERNSCALE |  | false | 0 |
| ChildDepartments | List[Department] | DEPPARTOFDEPID |  | true |  |
| City | UltimoString | DEPCITY | 40 | true |  |
| Comment | UltimoString | DEPCMNT1 | 71 | true |  |
| Context | Context | DEPCONTEXT |  | false | 1 |
| CostCenter | CostCenter | DEPCCRID |  | true |  |
| CostCurrentYear | CompanyMoney | DEPCOSTBY |  | false | 0 |
| CostLastYear | CompanyMoney | DEPCOSTLY |  | false | 0 |
| Country | Country | DEPCNTRID |  | true | DefaultCountryId |
| DataProvider | UltimoString | DEPDATAPROVIDER | 50 | true |  |
| Date | Date? | DEPDATE |  | true |  |
| DebtorNumber | UltimoString | DEPDEBTORNR | 9 | true |  |
| DefaultPrinter | Printer | DEPPRTID |  | true |  |
| Description | UltimoString | DEPDESCR | 200 | true |  |
| EmailAddress | UltimoString | DEPEMAILADDRESS | 100 | true |  |
| Employee | Employee | DEPEMPID |  | true |  |
| Exported | Boolean | DEPEXPORTED |  | false |  |
| ExternalId | UltimoString | DEPEXTERNALID | 50 | true |  |
| ExternalStatus | UltimoString | DEPEXTERNALSTATUS | 50 | true |  |
| Extra1 | Int16 | DEPEXTRA1 |  | false |  |
| Extra2 | Int32 | DEPEXTRA2 |  | false |  |
| Extra3 | Int32 | DEPEXTRA3 |  | false |  |
| Extra4 | UltimoString | DEPEXTRA4 | 5 | true |  |
| Extra5 | UltimoString | DEPEXTRA5 | 5 | true |  |
| GroupRecordAuthorizations | List[GroupRecordAuthorization] | SGRADEPID |  | true |  |
| Invest | CompanyMoney | DEPINVEST |  | false | 0 |
| Invoice | UltimoString | DEPINVOICE | 2 | true |  |
| InvoiceOutPerServiceContract | Boolean | DEPINVOPERSVC |  | false | 1 |
| Jobs | List[Job] | JOBDEPID |  | true |  |
| LedgerCode1 | UltimoString | DEPLGCODE1 | 11 | true |  |
| LedgerCode2 | UltimoString | DEPLGCODE2 | 11 | true |  |
| LedgerCode3 | UltimoString | DEPLGCODE3 | 11 | true |  |
| LedgerCode4 | UltimoString | DEPLGCODE4 | 11 | true |  |
| LedgerCode5 | UltimoString | DEPLGCODE5 | 11 | true |  |
| Location | UltimoString | DEPLOCATION | 27 | true |  |
| LongTermAsset | LongTermAsset | DEPLTAID |  | true |  |
| LowestLevelForExport | Boolean | DEPLOWESTLEVELFOREXPORT |  | false | 0 |
| PartOfDepartment | Department | DEPPARTOFDEPID |  | true |  |
| ProductDossiers | List[ProductDossier] | PRDDDEPID |  | true |  |
| ProviderMutationDate | DateTime? | DEPPROVIDERMUTDATE |  | true |  |
| ProvinceStateRegion | UltimoString | DEPPROVINCESTATEREGION | 40 | true |  |
| RecordChangeDate | DateTime? | DEPRECCHANGEDATE |  | true |  |
| RecordCreateDate | DateTime? | DEPRECCREATEDATE |  | true | SYSDATETIME |
| Replace | Decimal | DEPREPLACE |  | false |  |
| SafetyDossiers | List[SafetyDossier] | SAFDDEPID |  | true |  |
| Site | Site | DEPSITID |  | true |  |
| Status | Status | DEPRECSTATUS |  | false |  |
| SystemCompany | Company | DEPCOMPID |  | false |  |
| TariffGroup | TariffGroup | DEPTRFGID |  | true |  |
| Text | UltimoString | DEPTEXT |  | true |  |
| TopOfDepartmentId | Department | DEPTOPOFDEPID |  | true |  |
| TotalCost | CompanyMoney | DEPMAINTTOT |  | false | 0 |
| TransferNextTime | Boolean | DEPTRANSFERNEXTTIME |  | false |  |
| UserRecordAuthorizations | List[UserRecordAuthorization] | SUSERADEPID |  | true |  |
| ZipCode | UltimoString | DEPZIPCODE | 10 | true |  |