title: "PmjRes (table)" category: reference tags: [table, pmjres, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.PmjRes
Schema: dba
Aantal kolommen: 24
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
PmjrPmwId |
nvarchar(5) | Nee | — | — |
PmjrPmjId |
nvarchar(3) | Nee | — | — |
PmjrLineId |
nvarchar(9) | Nee | — | — |
PmjrContext |
bigint | Nee | ((0)) | — |
PmjrRecStatus |
int | Nee | ((0)) | — |
PmjrCompId |
nvarchar(6) | Nee | — | — |
PmjrCost |
decimal(21,5) | Nee | ((0)) | — |
PmjrCrmId |
nvarchar(6) | Ja | — | — |
PmjrExported |
smallint | Nee | ((0)) | — |
PmjrExtra1 |
smallint | Nee | ((0)) | — |
PmjrExtra2 |
int | Nee | ((0)) | — |
PmjrExtra3 |
nvarchar(5) | Ja | — | — |
PmjrHours |
decimal(21,2) | Nee | ((0)) | — |
PmjrNextWeek |
smallint | Nee | ((0)) | — |
PmjrQty |
decimal(21,2) | Nee | ((0)) | — |
PmjrRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
PmjrTariff |
decimal(21,5) | Nee | ((0)) | — |
PmjrVatId |
nvarchar(3) | Ja | — | — |
PmjrDataProvider |
nvarchar(50) | Ja | — | — |
PmjrProviderMutDate |
datetimeoffset(7) | Ja | — | — |
PmjrTransferNextTime |
smallint | Nee | ((0)) | — |
PmjrExternalId |
nvarchar(50) | Ja | — | — |
PmjrExternalStatus |
nvarchar(50) | Ja | — | — |
PmjrPmIPId |
nvarchar(9) | Ja | — | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("PmjRes")Alle kolommen met types, triggers, computed. Bron:database-schema.json.