Bewerken: Job

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `JobId` | nvarchar(12) | Nee | — | — |
| `JobDescr` | nvarchar(200) | Ja | — | — |
| `JobContext` | bigint | Nee | ((1)) | — |
| `JobRecStatus` | int | Nee | ((0)) | — |
| `JobAcceptDate` | datetimeoffset(7) | Ja | — | — |
| `JobAccepted` | smallint | Nee | ((0)) | — |
| `JobAcceptEmpId` | nvarchar(9) | Ja | — | — |
| `JobActId` | nvarchar(5) | Ja | — | — |
| `JobActiveDate` | datetimeoffset(7) | Ja | — | — |
| `JobActiveEmpId` | nvarchar(9) | Ja | — | — |
| `JobActualMoveDate` | date | Ja | — | — |
| `JobAllowChangeKntId` | smallint | Nee | ((0)) | — |
| `JobAllowChangeSdrtId` | smallint | Nee | ((0)) | — |
| `JobAllowMultijobPlanningFieldsToExpand` | smallint | Nee | ((1)) | — |
| `JobApprvDate` | datetimeoffset(7) | Ja | — | — |
| `JobApprvEmpId` | nvarchar(9) | Ja | — | — |
| `JobArtId` | nvarchar(9) | Ja | — | — |
| `JobBldfId` | nvarchar(23) | Ja | — | — |
| `JobBldId` | nvarchar(11) | Ja | — | — |
| `JobBldpId` | nvarchar(11) | Ja | — | — |
| `JobBofId` | nvarchar(4) | Ja | — | — |
| `JobCancelled` | smallint | Nee | ((0)) | — |
| `JobCateringCount` | smallint | Nee | ((0)) | — |
| `JobCcId` | nvarchar(2) | Ja | — | — |
| `JobCcrId` | nvarchar(9) | Ja | — | — |
| `JobChangeJobId` | nvarchar(12) | Ja | — | — |
| `JobChangeLinkDate` | date | Ja | — | — |
| `JobChangeWoId` | nvarchar(9) | Ja | — | — |
| `JobCharge` | smallint | Nee | ((0)) | — |
| `JobChgId` | nvarchar(6) | Ja | — | — |
| `JobClassificationImpId` | nvarchar(11) | Ja | — | — |
| `JobCloseDate` | datetimeoffset(7) | Ja | — | — |
| `JobCloseEmpId` | nvarchar(9) | Ja | — | — |
| `JobCompId` | nvarchar(6) | Nee | — | — |
| `JobComplDate` | datetimeoffset(7) | Ja | — | — |
| `JobComplEmpId` | nvarchar(9) | Ja | — | — |
| `JobConvertedDurationToHours` | smallint | Nee | ((1)) | — |
| `JobCreatedByServiceDesk` | smallint | Nee | ((0)) | — |
| `JobCrmId` | nvarchar(6) | Ja | — | — |
| `JobCsttId` | nvarchar(9) | Ja | — | — |
| `JobCurrWeek` | int | Nee | ((0)) | — |
| `JobCusContactEmpId` | nvarchar(9) | Ja | — | — |
| `JobCusId` | nvarchar(6) | Ja | — | — |
| `JobCusSId` | nvarchar(10) | Ja | — | — |
| `JobCustomerReference` | nvarchar(100) | Ja | — | — |
| `JobDataProvider` | nvarchar(50) | Ja | — | — |
| `JobDecId` | nvarchar(15) | Ja | — | — |
| `JobDepId` | nvarchar(11) | Ja | — | — |
| `JobDocId` | nvarchar(11) | Ja | — | — |
| `JobDownDate` | datetimeoffset(7) | Ja | — | — |
| `JobDowntimeRequired` | smallint | Nee | ((0)) | — |
| `JobDuration` | decimal(21,2) | Nee | ((0)) | — |
| `JobDurationCalc` | decimal(21,2) | Nee | ((0)) | — |
| `JobEmpId` | nvarchar(9) | Ja | — | — |
| `JobEqmAvailableCount` | smallint | Nee | ((0)) | — |
| `JobEqmId` | nvarchar(24) | Ja | — | — |
| `JobEqmInv` | decimal(21,5) | Nee | ((0)) | — |
| `JobEqmNotAvailableCount` | smallint | Nee | ((0)) | — |
| `JobEqmtId` | nvarchar(9) | Ja | — | — |
| `JobExecWindowQty` | decimal(21,2) | Nee | ((0)) | — |
| `JobExecWindowStartDate` | datetimeoffset(7) | Ja | — | — |
| `JobExecWindowStopDate` | datetimeoffset(7) | Ja | — | — |
| `JobExecWindowTimuId` | nvarchar(11) | Ja | — | — |
| `JobExported` | smallint | Nee | ((0)) | — |
| `JobExportedDate` | datetimeoffset(7) | Ja | — | — |
| `JobExtCalc` | decimal(21,5) | Nee | ((0)) | — |
| `JobExtCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobExternalId` | nvarchar(50) | Ja | — | — |
| `JobExternalStatus` | nvarchar(50) | Ja | — | — |
| `JobExtInv` | decimal(21,5) | Nee | ((0)) | — |
| `JobExtra1` | smallint | Nee | ((0)) | — |
| `JobExtra10` | nvarchar(5) | Ja | — | — |
| `JobExtra11` | nvarchar(5) | Ja | — | — |
| `JobExtra12` | int | Nee | ((0)) | — |
| `JobExtra2` | int | Nee | ((0)) | — |
| `JobExtra3` | nvarchar(6) | Ja | — | — |
| `JobExtra4` | nvarchar(5) | Ja | — | — |
| `JobExtra5` | int | Nee | ((0)) | — |
| `JobExtra6` | int | Nee | ((0)) | — |
| `JobExtra7` | nvarchar(5) | Ja | — | — |
| `JobExtra8` | nvarchar(5) | Ja | — | — |
| `JobExtra9` | nvarchar(5) | Ja | — | — |
| `JobExtTariff` | decimal(21,5) | Nee | ((0)) | — |
| `JobFalId` | nvarchar(9) | Ja | — | — |
| `JobFeedbackText` | nvarchar(max) | Ja | — | — |
| `JobFileId` | nvarchar(100) | Ja | — | — |
| `JobFinishDate` | datetimeoffset(7) | Ja | — | — |
| `JobFinishEmpId` | nvarchar(9) | Ja | — | — |
| `JobFmanId` | nvarchar(5) | Ja | — | — |
| `JobGeocodeX` | decimal(21,6) | Nee | ((0)) | — |
| `JobGeocodeY` | decimal(21,6) | Nee | ((0)) | — |
| `JobHours` | decimal(21,2) | Nee | ((0)) | — |
| `JobHoursCalc` | decimal(21,2) | Nee | ((0)) | — |
| `JobHoursInv` | decimal(21,2) | Nee | ((0)) | — |
| `JobHoursToPlanFromResources` | decimal(21,2) | Nee | ((0)) | — |
| `JobHtcId` | nvarchar(5) | Ja | — | — |
| `JobImageFile` | nvarchar(max) | Ja | — | — |
| `JobImagefile2` | nvarchar(max) | Ja | — | — |
| `JobImagefile3` | nvarchar(max) | Ja | — | — |
| `JobImagefile4` | nvarchar(max) | Ja | — | — |
| `JobImpId` | nvarchar(11) | Ja | — | — |
| `JobImportedDate` | datetimeoffset(7) | Ja | — | — |
| `JobIncId` | nvarchar(10) | Ja | — | — |
| `JobInspectionLines` | int | Nee | ((0)) | — |
| `JobInvomId` | nvarchar(6) | Ja | — | — |
| `JobInvOutTermFixedPrice` | smallint | Nee | ((0)) | — |
| `JobInvOutTermFrqQty` | smallint | Nee | ((0)) | — |
| `JobInvOutTermFxdPriceCst` | decimal(21,5) | Nee | ((0)) | — |
| `JobInvOutTermPayInTerms` | smallint | Nee | ((0)) | — |
| `JobInvOutTermTermFromDate` | date | Ja | — | — |
| `JobInvOutTermTermFrqId` | nvarchar(3) | Ja | — | — |
| `JobInvOutTermTermQty` | smallint | Nee | ((0)) | — |
| `JobInvOutTermTermStdDescr` | nvarchar(100) | Ja | — | — |
| `JobIoTermCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobIoTermInv` | decimal(21,5) | Nee | ((0)) | — |
| `JobIsMaster` | smallint | Nee | ((0)) | — |
| `JobIsMultijob` | smallint | Nee | ((0)) | — |
| `JobIspId` | nvarchar(11) | Ja | — | — |
| `JobItilChangeJobId` | nvarchar(12) | Ja | — | — |
| `JobItrId` | nvarchar(5) | Ja | — | — |
| `JobJpId` | nvarchar(11) | Ja | — | — |
| `JobKndId` | nvarchar(11) | Ja | — | — |
| `JobKnowledgeTopicCount` | int | Nee | ((0)) | — |
| `JobKntId` | nvarchar(11) | Ja | — | — |
| `JobKwsId` | nvarchar(3) | Ja | — | — |
| `JobLabCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobLabInv` | decimal(21,5) | Nee | ((0)) | — |
| `JobLotoApplicable` | smallint | Nee | ((0)) | — |
| `JobMasterJobId` | nvarchar(12) | Ja | — | — |
| `JobMatCalc` | decimal(21,5) | Nee | ((0)) | — |
| `JobMatCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobMatInv` | decimal(21,5) | Nee | ((0)) | — |
| `JobMeettId` | nvarchar(13) | Ja | — | — |
| `JobMemorandumCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobMjId` | nvarchar(12) | Ja | — | — |
| `JobMjtId` | nvarchar(4) | Ja | — | — |
| `JobMjtlLineId` | nvarchar(2) | Ja | — | — |
| `JobMjtlMjtId` | nvarchar(4) | Ja | — | — |
| `JobMoveFromSpcId` | nvarchar(40) | Ja | — | — |
| `JobMoveToSpcId` | nvarchar(40) | Ja | — | — |
| `JobNoPermit` | smallint | Nee | ((0)) | — |
| `JobObjiLine` | nvarchar(6) | Ja | — | — |
| `JobObjiObjIspId` | nvarchar(6) | Ja | — | — |
| `JobOpenDate` | datetimeoffset(7) | Ja | — | — |
| `JobOpenEmpId` | nvarchar(9) | Ja | — | — |
| `JobOperationLossHours` | decimal(21,3) | Nee | ((0)) | — |
| `JobOriginalSchStartDate` | date | Ja | — | — |
| `JobOriginalSvcTargetDate` | datetimeoffset(7) | Ja | — | — |
| `JobParentJobId` | nvarchar(12) | Ja | — | — |
| `JobPchrlTotBookCostExlVat` | decimal(21,5) | Nee | ((0)) | — |
| `JobPchrlTotBookCostInclVat` | decimal(21,5) | Nee | ((0)) | — |
| `JobPchTotalBookCostExlVat` | decimal(21,5) | Nee | ((0)) | — |
| `JobPchTotalBookCostInclVat` | decimal(21,5) | Nee | ((0)) | — |
| `JobPercComplete` | decimal(21,2) | Nee | ((0)) | — |
| `JobPlanHours` | decimal(21,2) | Nee | ((0)) | — |
| `JobPmId` | nvarchar(5) | Ja | — | — |
| `JobPmjId` | nvarchar(3) | Ja | — | — |
| `JobPmjPmwId` | nvarchar(5) | Ja | — | — |
| `JobPostpDate` | datetimeoffset(7) | Ja | — | — |
| `JobPostpEmpId` | nvarchar(9) | Ja | — | — |
| `JobPostpEndDate` | datetimeoffset(7) | Ja | — | — |
| `JobPostpRemark` | nvarchar(61) | Ja | — | — |
| `JobPrddId` | nvarchar(6) | Ja | — | — |
| `JobPrfId` | nvarchar(50) | Ja | — | — |
| `JobPriId` | nvarchar(4) | Ja | — | — |
| `JobPrjId` | nvarchar(6) | Ja | — | — |
| `JobProblemJobId` | nvarchar(12) | Ja | — | — |
| `JobProc` | nvarchar(41) | Ja | — | — |
| `JobProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `JobPrsId` | nvarchar(11) | Ja | — | — |
| `JobPurchCommit` | decimal(21,5) | Nee | ((0)) | — |
| `JobPurchCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobPurchInv` | decimal(21,5) | Nee | ((0)) | — |
| `JobRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `JobRelcId` | nvarchar(5) | Ja | — | — |
| `JobReleaseDate` | date | Ja | — | — |
| `JobReleaseTillDate` | date | Ja | — | — |
| `JobRemarkChar1` | nvarchar(20) | Ja | — | — |
| `JobRemarkChar2` | nvarchar(20) | Ja | — | — |
| `JobRemarkChar3` | nvarchar(20) | Ja | — | — |
| `JobRemarkChar4` | nvarchar(20) | Ja | — | — |
| `JobRemarkChar5` | nvarchar(20) | Ja | — | — |
| `JobRemarkChar6` | nvarchar(10) | Ja | — | — |
| `JobRemarkChar7` | nvarchar(10) | Ja | — | — |
| `JobRemarkDate1` | date | Ja | — | — |
| `JobRemarkDate2` | date | Ja | — | — |
| `JobRemarkDateTime1` | datetimeoffset(7) | Ja | — | — |
| `JobRemarkDateTime2` | datetimeoffset(7) | Ja | — | — |
| `JobRemarkDouble1` | decimal(21,2) | Nee | ((0)) | — |
| `JobRemarkDouble2` | decimal(21,2) | Nee | ((0)) | — |
| `JobRemarkInt1` | int | Nee | ((0)) | — |
| `JobRemarkInt2` | int | Nee | ((0)) | — |
| `JobRemarkInt3` | int | Nee | ((0)) | — |
| `JobRemarkInt4` | int | Nee | ((0)) | — |
| `JobRemarkInt5` | smallint | Nee | ((0)) | — |
| `JobRemarkSmallInt1` | smallint | Nee | ((0)) | — |
| `JobRemarkSmallInt2` | smallint | Nee | ((0)) | — |
| `JobRemarkSmallInt3` | smallint | Nee | ((0)) | — |
| `JobRemarkSmallInt4` | smallint | Nee | ((0)) | — |
| `JobRemarkSmallInt5` | smallint | Nee | ((0)) | — |
| `JobRemarkSpcId` | nvarchar(40) | Ja | — | — |
| `JobRemarkText1` | nvarchar(max) | Ja | — | — |
| `JobRemarkText2` | nvarchar(max) | Ja | — | — |
| `JobReportCommId` | nvarchar(5) | Ja | — | — |
| `JobReportDate` | datetimeoffset(7) | Ja | — | — |
| `JobReportEmpId` | nvarchar(41) | Ja | — | — |
| `JobReportFKEmpId` | nvarchar(9) | Ja | — | — |
| `JobReportText` | nvarchar(max) | Ja | — | — |
| `JobReportVdrId` | nvarchar(6) | Ja | — | — |
| `JobRequestDate` | datetimeoffset(7) | Ja | — | — |
| `JobRequestEmpId` | nvarchar(9) | Ja | — | — |
| `JobResCalc` | decimal(21,5) | Nee | ((0)) | — |
| `JobResCapacity` | int | Nee | ((0)) | — |
| `JobResDuration` | decimal(21,2) | Nee | ((0)) | — |
| `JobResEmpId` | nvarchar(9) | Ja | — | — |
| `JobResEndCleaningDate` | datetimeoffset(7) | Ja | — | — |
| `JobResEndDate` | datetimeoffset(7) | Ja | — | — |
| `JobReslayId` | nvarchar(9) | Ja | — | — |
| `JobResReservedBy` | nvarchar(40) | Ja | — | — |
| `JobResSpcId` | nvarchar(40) | Ja | — | — |
| `JobResStartDate` | datetimeoffset(7) | Ja | — | — |
| `JobResStartPrepareDate` | datetimeoffset(7) | Ja | — | — |
| `JobSafdId` | nvarchar(6) | Ja | — | — |
| `JobSafiId` | nvarchar(6) | Ja | — | — |
| `JobScheduledMoveDate` | date | Ja | — | — |
| `JobSchedulerRemarkText` | nvarchar(50) | Ja | — | — |
| `JobSchStartDate` | datetimeoffset(7) | Ja | — | — |
| `JobSdrtId` | nvarchar(4) | Ja | — | — |
| `JobSelfServiceRequest` | smallint | Nee | ((0)) | — |
| `JobServiceDeskToBoDate` | datetimeoffset(7) | Ja | — | — |
| `JobServiceDeskToBoEmpId` | nvarchar(9) | Ja | — | — |
| `JobShllId` | nvarchar(13) | Ja | — | — |
| `JobSignatureFile` | nvarchar(max) | Ja | — | — |
| `JobSitId` | nvarchar(8) | Ja | — | — |
| `JobSkcId` | nvarchar(9) | Ja | — | — |
| `JobSlaSvcId` | nvarchar(9) | Ja | — | — |
| `JobSolvedByReporter` | smallint | Nee | ((0)) | — |
| `JobSpcId` | nvarchar(40) | Ja | — | — |
| `JobSrvId` | nvarchar(6) | Ja | — | — |
| `JobSrvlId` | nvarchar(6) | Ja | — | — |
| `JobStandardStopJob` | smallint | Nee | ((0)) | — |
| `JobState` | decimal(21,2) | Nee | ((0)) | — |
| `JobStopRelated` | smallint | Nee | ((0)) | — |
| `JobSualLineId` | nvarchar(10) | Ja | — | — |
| `JobSualSuaId` | nvarchar(10) | Ja | — | — |
| `JobSupportLine` | smallint | Nee | ((0)) | — |
| `JobSvcFinishdate` | datetimeoffset(7) | Ja | — | — |
| `JobSvcFinishPercTarget` | decimal(21,0) | Nee | ((0)) | — |
| `JobSvcId` | nvarchar(9) | Ja | — | — |
| `JobSvcReasonResponseExceeded` | nvarchar(max) | Ja | — | — |
| `JobSvcReasonTargetExceeded` | nvarchar(max) | Ja | — | — |
| `JobSvcResponsedate` | datetimeoffset(7) | Ja | — | — |
| `JobSvcResponsePercTarget` | decimal(21,0) | Nee | ((0)) | — |
| `JobSvcTargetdate` | datetimeoffset(7) | Ja | — | — |
| `JobSvcTargetResponsedate` | datetimeoffset(7) | Ja | — | — |
| `JobTargetDate` | datetimeoffset(7) | Ja | — | — |
| `JobTariff` | decimal(21,5) | Nee | ((0)) | — |
| `JobText` | nvarchar(max) | Ja | — | — |
| `JobTlsCalc` | decimal(21,5) | Nee | ((0)) | — |
| `JobTlsCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobTlsInv` | decimal(21,5) | Nee | ((0)) | — |
| `JobTransferNextTime` | smallint | Nee | ((0)) | — |
| `JobUnapprovedHoursCalculated` | decimal(21,2) | Nee | ((0)) | — |
| `JobUnapprovedHoursPlanned` | decimal(21,2) | Nee | ((0)) | — |
| `JobUpDate` | datetimeoffset(7) | Ja | — | — |
| `JobUrgId` | nvarchar(11) | Ja | — | — |
| `JobUseEquipmentReservation` | smallint | Nee | ((1)) | — |
| `JobUseStdCatering` | smallint | Nee | ((0)) | — |
| `JobUseWorkScheduleForPlanning` | smallint | Nee | ((1)) | — |
| `JobVdrId` | nvarchar(6) | Ja | — | — |
| `JobVerifyDate` | datetimeoffset(7) | Ja | — | — |
| `JobVerifyEmpId` | nvarchar(9) | Ja | — | — |
| `JobVerifyNeeded` | smallint | Nee | ((0)) | — |
| `JobWoId` | nvarchar(9) | Ja | — | — |
| `JobWotId` | nvarchar(6) | Ja | — | — |
| `JobYrpId` | nvarchar(9) | Ja | — | — |
| `JobYrpslCalc` | decimal(21,5) | Nee | ((0)) | — |
| `JobExceedsOriginalTimeEstimate` | smallint | Nee | — | — |
| `JobHoursToPlan` | decimal(21,2) | Nee | — | — |
| `JobNonServDeskServRequest` | smallint | Nee | — | — |
| `JobPercCompleteRaw` | decimal(21,2) | Nee | — | — |
| `JobPurchaseRequestCalc` | decimal(21,5) | Nee | — | — |
| `JobPurchCalc` | decimal(21,5) | Nee | — | — |
| `JobTotalCalc` | decimal(21,5) | Nee | — | — |
| `JobTotalCost` | decimal(21,5) | Nee | — | — |
| `JobTotalInv` | decimal(21,5) | Nee | — | — |
| `JobFileExtension` | nvarchar(5) | Nee | — | — |
| `JOBFEEDBACKTEXT_FT` | varbinary(max) | Ja | — | — |
| `JOBREPORTTEXT_FT` | varbinary(max) | Ja | — | — |
| `JOBTEXT_FT` | varbinary(max) | Ja | — | — |
| `JobAcceptanceRemarkText` | nvarchar(max) | Ja | — | — |
| `JobRejectAcceptanceDate` | datetimeoffset(7) | Ja | — | — |
| `JobRejectAcceptanceEmpId` | nvarchar(9) | Ja | — | — |
| `JobAcceptanceStatement` | nvarchar(max) | Ja | — | — |
| `JobRequestedResponse` | smallint | Nee | ((0)) | — |
| `JobRequestedCustomerSatisfaction` | smallint | Nee | ((0)) | — |
| `JobExecutionDays` | int | Nee | ((0)) | — |
| `JobExtensionDays` | int | Nee | ((0)) | — |
| `JobFinalFinishDate` | date | Ja | — | — |
| `JobOriginalFinalFinishDate` | date | Ja | — | — |
| `JobNumberOfMaterials` | int | Nee | ((0)) | — |
| `JobHideInSelectionList` | smallint | Nee | ((0)) | — |
| `JobFsnId` | nvarchar(9) | Ja | — | — |
| `JobLastUsedMaterialInStockIndicator` | smallint | Nee | ((0)) | — |
| `JobCmptId` | nvarchar(5) | Ja | — | — |
| `JobRmyId` | nvarchar(5) | Ja | — | — |
| `JobCmptpId` | nvarchar(5) | Ja | — | — |
| `JobRcaId` | nvarchar(6) | Ja | — | — |