Bewerken: UmmSettings

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `UmmId` | nvarchar(9) | Nee | — | — |
| `UmmContext` | bigint | Nee | ((0)) | — |
| `UmmRecStatus` | int | Nee | ((0)) | — |
| `UmmActPurchCopy` | smallint | Nee | ((0)) | — |
| `UmmActPurchMethod` | smallint | Nee | ((0)) | — |
| `UmmAddEmpLabourDateLine` | smallint | Nee | ((0)) | — |
| `UmmAllowInvNoRec` | smallint | Nee | ((0)) | — |
| `UmmAskPrfEqmOnCreateJob` | smallint | Nee | ((0)) | — |
| `UmmAskPrintJobDoc` | smallint | Nee | ((0)) | — |
| `UmmAskPurchClose` | smallint | Nee | ((0)) | — |
| `UmmAuthApprvJob` | smallint | Nee | ((0)) | — |
| `UmmAuthColumnsToReso` | smallint | Nee | ((0)) | — |
| `UmmAutoResOnJobExecWithJobs` | bigint | Nee | ((0)) | — |
| `UmmBookCostIncludingVat` | smallint | Nee | ((0)) | — |
| `UmmBookDateSysDate` | smallint | Nee | ((0)) | — |
| `UmmCatDlvMinBeforeStartTime` | int | Nee | ((0)) | — |
| `UmmCheck24Hours` | smallint | Nee | ((0)) | — |
| `UmmCheckInvoMask` | smallint | Nee | ((0)) | — |
| `UmmClearJobReportDatePo` | smallint | Nee | ((0)) | — |
| `UmmComposeAdrDescrAddCity` | smallint | Nee | ((1)) | — |
| `UmmComposeAdrDescrAddCntr` | smallint | Nee | ((0)) | — |
| `UmmComposeAdrDescrAddProv` | smallint | Nee | ((0)) | — |
| `UmmComposeEmpDescr` | nvarchar(10) | Ja | — | — |
| `UmmComposeEmpDescrWithTitle` | smallint | Nee | ((0)) | — |
| `UmmCompressEmpllJob` | smallint | Nee | ((0)) | — |
| `UmmContrCompCostGenerateYrs` | int | Nee | ((0)) | — |
| `UmmCopyJobwlTextToJob` | smallint | Nee | ((0)) | — |
| `UmmCostDisableAccount` | smallint | Nee | ((0)) | — |
| `UmmCostDisableBudgetPeriod` | smallint | Nee | ((0)) | — |
| `UmmCostDisableCostCenter` | smallint | Nee | ((0)) | — |
| `UmmCostDisableCostType` | smallint | Nee | ((0)) | — |
| `UmmCostDisableCustomer` | smallint | Nee | ((0)) | — |
| `UmmCostDisableDepartment` | smallint | Nee | ((0)) | — |
| `UmmCostDisableEquipment` | smallint | Nee | ((0)) | — |
| `UmmCostDisableJob` | smallint | Nee | ((0)) | — |
| `UmmCostDisableProcessFunction` | smallint | Nee | ((0)) | — |
| `UmmCostDisableServContract` | smallint | Nee | ((0)) | — |
| `UmmCostFindMethod` | smallint | Nee | ((0)) | — |
| `UmmCreatePchBasedPadlConc` | smallint | Nee | ((0)) | — |
| `UmmCustomerCode` | nvarchar(40) | Ja | — | — |
| `UmmCustomJobAndPrsComb` | nvarchar(max) | Ja | — | — |
| `UmmDefaultCntrId` | nvarchar(9) | Ja | — | — |
| `UmmDefaultHoursVatId` | nvarchar(3) | Ja | — | — |
| `UmmDepFindMethod` | smallint | Nee | ((0)) | — |
| `UmmDiscountCalcMethod` | smallint | Nee | ((0)) | — |
| `UmmDontUseWo` | smallint | Nee | ((0)) | — |
| `UmmEmailSender` | nvarchar(100) | Ja | — | — |
| `UmmEnableSpecialEmployeeFilter` | smallint | Nee | ((1)) | — |
| `UmmEqMoveCascade` | smallint | Nee | ((0)) | — |
| `UmmExchangeCrdId` | nvarchar(32) | Ja | — | — |
| `UmmExchangeEmailAddress` | nvarchar(50) | Ja | — | — |
| `UmmExchangeEnabled` | smallint | Nee | ((0)) | — |
| `UmmExchangeSubscribeToImport` | smallint | Nee | ((0)) | — |
| `UmmExchPartUseEqmIdAutoKey` | smallint | Nee | ((0)) | — |
| `UmmExportDataProviderName` | nvarchar(50) | Ja | — | — |
| `UmmExported` | smallint | Nee | ((0)) | — |
| `UmmExtraJobAndPrsComb` | nvarchar(max) | Ja | — | — |
| `UMMFileGroupTables` | nvarchar(128) | Ja | — | — |
| `UmmFirstDayOfWeek` | smallint | Nee | ((0)) | — |
| `UmmHistPeriod` | smallint | Nee | ((0)) | — |
| `UmmHourDlgModus` | smallint | Nee | ((0)) | — |
| `UmmHourDlgUseDefHourCode` | smallint | Nee | ((0)) | — |
| `UmmHoursPerDay` | smallint | Nee | ((0)) | — |
| `UmmInvApprMethod` | smallint | Nee | ((0)) | — |
| `UmmInvIsRcvd` | smallint | Nee | ((0)) | — |
| `UmmInvMorePchAllowed` | smallint | Nee | ((0)) | — |
| `UmmInvoiceOutPer` | smallint | Nee | ((0)) | — |
| `UmmInvOutAddZeroAmountNZV` | smallint | Nee | ((0)) | — |
| `UmmInvOutAddZeroAmountRows` | smallint | Nee | ((0)) | — |
| `UmmJobActiveMask` | smallint | Nee | ((0)) | — |
| `UmmJobApproveMask` | smallint | Nee | ((0)) | — |
| `UmmJobCloseMask` | smallint | Nee | ((0)) | — |
| `UmmJobCloseWoDep2JobDep` | smallint | Nee | ((0)) | — |
| `UmmJobCompleteMask` | smallint | Nee | ((0)) | — |
| `UmmJobCreatMask` | smallint | Nee | ((0)) | — |
| `UmmJobFinishMask` | smallint | Nee | ((0)) | — |
| `UmmJobPostponeMask` | smallint | Nee | ((0)) | — |
| `UmmJobSendEmailOnFinish` | smallint | Nee | ((0)) | — |
| `UmmJobSendEmailOnSend` | smallint | Nee | ((0)) | — |
| `UmmJobWsId` | nvarchar(8) | Ja | — | — |
| `UMMKeysAreMandatoryUppercase` | smallint | Nee | ((1)) | — |
| `UmmLabourUseJobTariff` | smallint | Nee | ((0)) | — |
| `UmmManageStockPerWarehouse` | smallint | Nee | ((0)) | — |
| `UmmMaxHoursAfterShiftStart` | smallint | Nee | ((4)) | — |
| `UmmMaxHoursBeforeShiftStart` | smallint | Nee | ((4)) | — |
| `UmmMoreRcvThanPchNotAllow` | smallint | Nee | ((0)) | — |
| `UmmOverlapPrepareClean` | smallint | Nee | ((0)) | — |
| `UmmPadDefaultPurchase` | smallint | Nee | ((0)) | — |
| `UmmPartPrjJobUseAutoKey` | smallint | Nee | ((0)) | — |
| `UmmPchForArtEqualEmpId` | smallint | Nee | ((0)) | — |
| `UmmPmContactEmailAddress` | nvarchar(80) | Ja | — | — |
| `UmmBusinessIntelligenceLanguage` | nvarchar(10) | Ja | — | — |
| `UmmBusinessIntelligenceTimeZone` | nvarchar(32) | Ja | — | — |
| `UmmBusinessIntelligenceTimeZoneMapping` | nvarchar(128) | Ja | — | — |
| `UmmPrjWoNrDigits` | smallint | Nee | ((0)) | — |
| `UmmPrjWoUseAutoKey` | smallint | Nee | ((0)) | — |
| `UmmRcpWsId` | nvarchar(8) | Ja | — | — |
| `UmmRcvdIsPurch` | smallint | Nee | ((0)) | — |
| `UmmRecalcSpcmamImmediately` | smallint | Nee | ((0)) | — |
| `UmmRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `UmmReqToProcessPymtrr` | smallint | Nee | ((3)) | — |
| `UmmResPlannerSnapTime` | int | Nee | ((0)) | — |
| `UmmResSnapPrepareCleanTime` | int | Nee | ((0)) | — |
| `UmmResSnapTime` | int | Nee | ((0)) | — |
| `UmmRstCalcCap` | smallint | Nee | ((0)) | — |
| `UmmSendPmSuccessEmail` | smallint | Nee | ((0)) | — |
| `UmmSpcrWsId` | nvarchar(8) | Ja | — | — |
| `UmmStdCatArt1` | nvarchar(9) | Ja | — | — |
| `UmmStdCatArt2` | nvarchar(9) | Ja | — | — |
| `UmmStdCatArt3` | nvarchar(9) | Ja | — | — |
| `UmmStdCatArt4` | nvarchar(9) | Ja | — | — |
| `UmmStockLevelPerSite` | smallint | Nee | ((0)) | — |
| `UmmSummaryUseQueryHint` | smallint | Nee | ((0)) | — |
| `UmmSyncPlanWithJobSched` | bigint | Nee | ((0)) | — |
| `UmmTargetDateFromSlaToJob` | smallint | Nee | ((1)) | — |
| `UmmUrlApiZipCode` | nvarchar(200) | Ja | — | — |
| `UmmUrlApiZipCodeHouseNumber` | nvarchar(200) | Ja | — | — |
| `UmmUseBdgpContext` | int | Nee | ((0)) | — |
| `UmmUseJobCsttId` | smallint | Nee | ((0)) | — |
| `UmmUseProcessFunction` | smallint | Nee | ((0)) | — |
| `UmmUseRoles` | smallint | Nee | ((0)) | — |
| `UmmUseRreTaxAdmExport` | smallint | Nee | ((0)) | — |
| `UmmUseStdCateringDefaultOn` | smallint | Nee | ((0)) | — |
| `UmmWeekOfYearRule` | smallint | Nee | ((0)) | — |
| `UmmWeightedAveragePeriod` | int | Nee | ((0)) | — |
| `UmmWoActiveMask` | smallint | Nee | ((0)) | — |
| `UmmWoApproveMask` | smallint | Nee | ((0)) | — |
| `UmmWoCloseMask` | smallint | Nee | ((0)) | — |
| `UmmWoCompleteMask` | smallint | Nee | ((0)) | — |
| `UmmWoCreatMask` | smallint | Nee | ((0)) | — |
| `UmmWoFinishMask` | smallint | Nee | ((0)) | — |
| `UmmWoJobsNrDigits` | smallint | Nee | ((0)) | — |
| `UmmWoPostponeMask` | smallint | Nee | ((0)) | — |
| `UmmCostDisableProject` | smallint | Nee | ((0)) | — |
| `UmmOutgoingEmailActive` | smallint | Nee | ((1)) | — |
| `UmmEmailSenderName` | nvarchar(100) | Ja | — | — |
| `UmmUseCustomSmtp` | smallint | Nee | ((0)) | — |
| `UmmCustomSmtpHost` | nvarchar(50) | Ja | — | — |
| `UmmCustomSmtpPort` | int | Nee | ((0)) | — |
| `UmmCustomSmtpUserName` | nvarchar(50) | Ja | — | — |
| `UmmCustomSmtpPassword` | nvarchar(50) | Ja | — | — |
| `UmmCustomSmtpEnableSsl` | smallint | Nee | ((0)) | — |
| `UmmCustomSmtpCrdId` | nvarchar(32) | Ja | — | — |
| `UmmCustomSmtpAuthenticationMethod` | smallint | Nee | ((0)) | — |
| `UmmDataCompression` | smallint | Nee | ((0)) | — |
| `UmmShareArticlesBetweenCompanies` | smallint | Nee | ((0)) | — |
| `UmmPurchPricePerSite` | smallint | Nee | ((0)) | — |
| `UmmAutoSortOrderInspectionLinesTS` | smallint | Nee | ((1)) | — |
| `UmmAutoSortOrderInspectionLinesFleetInfraMT` | smallint | Nee | ((1)) | — |
| `UmmUsePurchaseRequestWithHeader` | smallint | Nee | ((0)) | — |
| `UmmUseApprovalLevelsForPurchaseRequests` | smallint | Nee | ((0)) | — |
| `UmmUseApprovalLevelsForPurchaseOrders` | smallint | Nee | ((0)) | — |
| `UmmUseDepartmentAsCostUnit` | smallint | Nee | ((0)) | — |
| `UmmEnable21CFRPart11` | smallint | Nee | ((0)) | — |
| `UmmPmUpdateAutoApproveProposals` | smallint | Nee | ((0)) | — |
| `UmmPmUpdateDeviationThreshold` | int | Nee | ((20)) | — |
| `UmmPmUpdateMinimumJobs` | int | Nee | ((6)) | — |
| `UmmPmUpdateLookBackPeriod` | int | Nee | ((365)) | — |