title: "MaintenancePartActivity (table)" category: reference tags: [table, maintenancepartactivity, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.MaintenancePartActivity
Schema: dba
Aantal kolommen: 39
Zie ook de entity-pagina: ../entities/MaintenancePartActivity
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
MntpaMntpId |
nvarchar(11) | Nee | — | — |
MntpaMntaId |
nvarchar(11) | Nee | — | — |
MntpaContext |
bigint | Nee | ((0)) | — |
MntpaRecStatus |
int | Nee | ((0)) | — |
MntpaCcrId |
nvarchar(9) | Ja | — | — |
MntpaCompId |
nvarchar(6) | Nee | — | — |
MntpaConditionAftAct |
nvarchar(11) | Ja | — | — |
MntpaCsttId |
nvarchar(9) | Ja | — | — |
MntpaDataProvider |
nvarchar(50) | Ja | — | — |
MntpaExported |
smallint | Nee | ((0)) | — |
MntpaExternalCost |
decimal(21,5) | Nee | ((0)) | — |
MntpaExternalId |
nvarchar(50) | Ja | — | — |
MntpaExternalStatus |
nvarchar(50) | Ja | — | — |
MntpaExtraCost |
decimal(21,5) | Nee | ((0)) | — |
MntpaHoursPerUnt |
decimal(21,4) | Nee | ((0)) | — |
MntpaHtcId |
nvarchar(5) | Ja | — | — |
MntpaImplementationPerc |
decimal(21,2) | Nee | ((0)) | — |
MntpaInspectionCycle |
smallint | Nee | ((0)) | — |
MntpaInspectionTime |
decimal(21,2) | Nee | ((0)) | — |
MntpaLabCost |
decimal(21,5) | Nee | ((0)) | — |
MntpaMaintenanceCycle |
smallint | Nee | ((0)) | — |
MntpaMaintenanceTime |
decimal(21,2) | Nee | ((0)) | — |
MntpaMaintTimesPerYear |
smallint | Nee | ((0)) | — |
MntpaMaterialCost |
decimal(21,5) | Nee | ((0)) | — |
MntpaMnttId |
nvarchar(11) | Ja | — | — |
MntpaNextMntsId |
nvarchar(11) | Ja | — | — |
MntpaObservationsPerCycle |
int | Nee | ((0)) | — |
MntpaPercOfReplacementCost |
decimal(21,2) | Nee | ((0)) | — |
MntpaProviderMutDate |
datetimeoffset(7) | Ja | — | — |
MntpaQty |
decimal(21,2) | Nee | ((0)) | — |
MntpaRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
MntpaStateImprovement |
smallint | Nee | ((0)) | — |
MntpaStdCostExLab |
decimal(21,5) | Nee | ((0)) | — |
MntpaStdTotalCost |
decimal(21,5) | Nee | ((0)) | — |
MntpaText |
nvarchar(max) | Ja | — | — |
MntpaToolsCost |
decimal(21,5) | Nee | ((0)) | — |
MntpaTransferNextTime |
smallint | Nee | ((0)) | — |
MntpaUntId |
nvarchar(6) | Ja | — | — |
MntpaUntPrice |
decimal(21,5) | Nee | ((0)) | — |
Trigger-gevulde kolommenbewerken
MntpaExtraCost← TRSD_MAINTENANCEPARTACTEXTRA, TRSM_MAINTENANCEPARTACTEXTRA
Brondatabewerken
- DB-schema —
lookup_table_schema("MaintenancePartActivity")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("MaintenancePartActivity")· ../entities/MaintenancePartActivity Properties, contexts, statussen. Bron:Entities.xml.