title: "UmmSettings (table)" category: reference tags: [table, ummsettings, datamodel] source: database-schema.json date: 2026-04-17 status: published

dba.UmmSettings

Schema: dba Aantal kolommen: 158

Kolommenbewerken

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)) —

Trigger-gevulde kolommenbewerken

Brondatabewerken