title: "ProcessFunction (table)" category: reference tags: [table, processfunction, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.ProcessFunction
Schema: dba
Aantal kolommen: 141
Zie ook de entity-pagina: ../entities/ProcessFunction
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
PrfId |
nvarchar(50) | Nee | — | — |
PrfDescr |
nvarchar(200) | Ja | — | — |
PrfContext |
bigint | Nee | ((1)) | — |
PrfRecStatus |
int | Nee | ((0)) | — |
PrfActiveDate |
datetimeoffset(7) | Ja | — | — |
PrfActiveEmpId |
nvarchar(9) | Ja | — | — |
PrfAddressLine1 |
nvarchar(100) | Ja | — | — |
PrfAddressLine2 |
nvarchar(100) | Ja | — | — |
PrfCadDocId |
nvarchar(11) | Ja | — | — |
PrfCadHandle |
decimal(21,0) | Nee | ((0)) | — |
PrfCadHandleDocId |
nvarchar(11) | Ja | — | — |
PrfCcrId |
nvarchar(9) | Ja | — | — |
PrfCity |
nvarchar(40) | Ja | — | — |
PrfCntrId |
nvarchar(9) | Ja | — | — |
PrfCode |
nvarchar(12) | Ja | — | — |
PrfCompId |
nvarchar(6) | Nee | — | — |
PrfContactEmpId |
nvarchar(9) | Ja | — | — |
PrfCopyFromPrfId |
nvarchar(50) | Ja | — | — |
PrfCostLY |
decimal(21,5) | Nee | ((0)) | — |
PrfCritical |
smallint | Nee | ((0)) | — |
PrfCurrentMntsDate |
date | Ja | — | — |
PrfCurrentMntsId |
nvarchar(11) | Ja | — | — |
PrfDataProvider |
nvarchar(50) | Ja | — | — |
PrfDateState |
datetimeoffset(7) | Ja | — | — |
PrfDecId |
nvarchar(15) | Ja | — | — |
PrfDepId |
nvarchar(11) | Ja | — | — |
PrfDeprActivated |
smallint | Nee | ((0)) | — |
PrfDepreciationDate |
date | Ja | — | — |
PrfDeprLife |
smallint | Nee | ((0)) | — |
PrfDeprStartdate |
date | Ja | — | — |
PrfDrawingNr |
nvarchar(20) | Ja | — | — |
PrfEcoDeprmId |
nvarchar(3) | Ja | — | — |
PrfEqmId |
nvarchar(24) | Ja | — | — |
PrfEqmtId |
nvarchar(9) | Ja | — | — |
PrfExported |
smallint | Nee | ((0)) | — |
PrfExternalId |
nvarchar(50) | Ja | — | — |
PrfExternalStatus |
nvarchar(50) | Ja | — | — |
PrfExtra1 |
smallint | Nee | ((0)) | — |
PrfExtra2 |
decimal(21,2) | Nee | ((0)) | — |
PrfExtra3 |
decimal(21,2) | Nee | ((0)) | — |
PrfExtra4 |
decimal(21,2) | Nee | ((0)) | — |
PrfExtra5 |
decimal(21,2) | Nee | ((0)) | — |
PrfExtra6 |
nvarchar(5) | Ja | — | — |
PrfExtra7 |
nvarchar(5) | Ja | — | — |
PrfExtra8 |
nvarchar(5) | Ja | — | — |
PrfExtra9 |
nvarchar(5) | Ja | — | — |
PrfFromGeocodeX |
decimal(21,10) | Nee | ((0)) | — |
PrfFromGeocodeY |
decimal(21,10) | Nee | ((0)) | — |
PrfGeocodeX |
decimal(21,10) | Nee | ((0)) | — |
PrfGeocodeY |
decimal(21,10) | Nee | ((0)) | — |
PrfGeoId |
nvarchar(8) | Ja | — | — |
PrfImageFile |
nvarchar(max) | Ja | — | — |
PrfImageFile2 |
nvarchar(max) | Ja | — | — |
PrfImageFile3 |
nvarchar(max) | Ja | — | — |
PrfImageFile4 |
nvarchar(max) | Ja | — | — |
PrfImpId |
nvarchar(11) | Ja | — | — |
PrfImportedCriticality |
smallint | Nee | ((0)) | — |
PrfInstDate |
date | Ja | — | — |
PrfLastPmMaintDate |
date | Ja | — | — |
PrfLastPmModel |
nvarchar(5) | Ja | — | — |
PrfLocation |
nvarchar(26) | Ja | — | — |
PrfLocId |
nvarchar(14) | Ja | — | — |
PrfLowestLevelForExport |
smallint | Nee | ((0)) | — |
PrfLtaId |
nvarchar(10) | Ja | — | — |
PrfMaintTotal |
decimal(21,5) | Nee | ((0)) | — |
PrfMaintYear |
decimal(21,5) | Nee | ((0)) | — |
PrfManagVdrId |
nvarchar(6) | Ja | — | — |
PrfManufId |
nvarchar(6) | Ja | — | — |
PrfManufYear |
int | Nee | ((0)) | — |
PrfMissingDate |
datetimeoffset(7) | Ja | — | — |
PrfMissingEmpId |
nvarchar(9) | Ja | — | — |
PrfMntsId |
nvarchar(11) | Ja | — | — |
PrfModel |
nvarchar(19) | Ja | — | — |
PrfObjImpPmTasksToProcess |
int | Nee | ((0)) | — |
PrfPartOfPrfId |
nvarchar(50) | Ja | — | — |
PrfProdId |
nvarchar(9) | Ja | — | — |
PrfProductionLossPerHour |
decimal(21,5) | Nee | ((0)) | — |
PrfProviderMutDate |
datetimeoffset(7) | Ja | — | — |
PrfProvinceStateRegion |
nvarchar(40) | Ja | — | — |
PrfPurchPrice |
decimal(21,5) | Nee | ((0)) | — |
PrfRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
PrfRef1 |
nvarchar(12) | Ja | — | — |
PrfRef2 |
nvarchar(12) | Ja | — | — |
PrfRef3 |
nvarchar(12) | Ja | — | — |
PrfRef4 |
nvarchar(12) | Ja | — | — |
PrfRef5 |
nvarchar(12) | Ja | — | — |
PrfRegisterObjectDowntime |
smallint | Nee | ((0)) | — |
PrfRemovalDate |
datetimeoffset(7) | Ja | — | — |
PrfRemovalEmpId |
nvarchar(9) | Ja | — | — |
PrfRemovalReason |
nvarchar(61) | Ja | — | — |
PrfReplCost |
decimal(21,5) | Nee | ((0)) | — |
PrfReplDate |
date | Ja | — | — |
PRFREPLLIFE |
int | Nee | ((0)) | — |
PrfReplYear |
smallint | Nee | ((0)) | — |
PrfResidualValue |
decimal(21,5) | Nee | ((0)) | — |
PrfRiscId |
nvarchar(5) | Ja | — | — |
PrfRiskScore |
decimal(21,2) | Nee | ((0)) | — |
PrfSerialNr |
nvarchar(40) | Ja | — | — |
PrfSetUpDate |
datetimeoffset(7) | Ja | — | — |
PrfSetUpEmpId |
nvarchar(9) | Ja | — | — |
PrfSitId |
nvarchar(8) | Ja | — | — |
PrfSpcId |
nvarchar(40) | Ja | — | — |
PrfState |
decimal(21,2) | Nee | ((0)) | — |
PrfSvcId |
nvarchar(9) | Ja | — | — |
PrfTaxDeprmId |
nvarchar(3) | Ja | — | — |
PrfTech1 |
nvarchar(12) | Ja | — | — |
PrfTech10 |
nvarchar(12) | Ja | — | — |
PrfTech2 |
nvarchar(12) | Ja | — | — |
PrfTech3 |
nvarchar(12) | Ja | — | — |
PrfTech4 |
nvarchar(12) | Ja | — | — |
PrfTech5 |
nvarchar(12) | Ja | — | — |
PrfTech6 |
nvarchar(12) | Ja | — | — |
PrfTech7 |
nvarchar(12) | Ja | — | — |
PrfTech8 |
nvarchar(12) | Ja | — | — |
PrfTech9 |
nvarchar(12) | Ja | — | — |
PrfTechDeprLife |
smallint | Nee | ((0)) | — |
PrfText1 |
nvarchar(max) | Ja | — | — |
PrfTillGeocodeX |
decimal(21,10) | Nee | ((0)) | — |
PrfTillGeocodeY |
decimal(21,10) | Nee | ((0)) | — |
PrfTopOfPrfId |
nvarchar(50) | Ja | — | — |
PrfTransferNextTime |
smallint | Nee | ((0)) | — |
PrfTypeNr |
nvarchar(180) | Ja | — | — |
PrfUrgId |
nvarchar(11) | Ja | — | — |
PrfUseSpecificFailTypes |
smallint | Nee | ((0)) | — |
PrfVdrId |
nvarchar(6) | Ja | — | — |
PrfWantedMntsId |
nvarchar(11) | Ja | — | — |
PrfWarrentDate |
date | Ja | — | — |
PrfWhsId |
nvarchar(10) | Ja | — | — |
PrfZipCode |
nvarchar(10) | Ja | — | — |
PrfTopOfPrfIdWithinContext |
nvarchar(50) | Ja | — | — |
PrfNextPmMaintDate |
date | Ja | — | — |
PrfNextPmModel |
nvarchar(5) | Ja | — | — |
PrfNextPmMaintJobId |
nvarchar(12) | Ja | — | — |
PrfFileExtension |
nvarchar(5) | Nee | — | — |
PRFTEXT1_FT |
varbinary(max) | Ja | — | — |
PrfObjraId |
nvarchar(8) | Ja | — | — |
PrfRiscIdCriticality |
nvarchar(5) | Ja | — | — |
PrfScoreCritical |
decimal(21,2) | Nee | ((0)) | — |
PrfLowestLevelAssessment |
smallint | Nee | ((0)) | — |
PrfRisOcId |
nvarchar(9) | Ja | — | — |
PrfCriticalityRemarkText |
nvarchar(max) | Ja | — | — |
Computed columnsbewerken
PrfFileExtension—(N'.html')PRFTEXT1_FT—(case when [PRFTEXT1] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([PRFTEXT1],(5))=N'<html' then [PRFTEXT1] else N'<html lang="en-gb">'+[PRFTEXT1] end) end)
Trigger-gevulde kolommenbewerken
PrfCostLY← TRGU_UmmGlobals, TRSD_COST, TRSM_COSTPrfMaintTotal← TRSD_COST, TRSM_COSTPrfMaintYear← TRGU_UmmGlobals, TRSD_COST, TRSM_COSTPrfObjImpPmTasksToProcess← TRGD_ObjectImportedPmTask, TRGI_ObjectImportedPmTask, TRGU_ObjectImportedPmTaskPrfPartOfPrfId← TRGD_ProcessFunction, TRGI_ProcessFunction, TRGU_ProcessFunctionPrfReplCost← TRGU_CompanyPrfTopOfPrfId← TRGD_ProcessFunction, TRGI_ProcessFunction, TRGU_ProcessFunctionPrfTopOfPrfIdWithinContext← TRGD_ProcessFunction, TRGI_ProcessFunction, TRGU_ProcessFunction
Brondatabewerken
- DB-schema —
lookup_table_schema("ProcessFunction")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("ProcessFunction")· ../entities/ProcessFunction Properties, contexts, statussen. Bron:Entities.xml.