title: "JobMat (table)" category: reference tags: [table, jobmat, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.JobMat
Schema: dba
Aantal kolommen: 61
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
JobmJobId |
nvarchar(12) | Nee | — | — |
JobmLineId |
nvarchar(9) | Nee | — | — |
JobmContext |
bigint | Nee | ((0)) | — |
JobmRecStatus |
int | Nee | ((0)) | — |
JobmArtId |
nvarchar(9) | Ja | — | — |
JobmArtReserved |
smallint | Nee | ((0)) | — |
JobmBookDate |
date | Ja | — | — |
JobmCatArtId |
nvarchar(9) | Ja | — | — |
JobmCcrId |
nvarchar(9) | Ja | — | — |
JobmChargeRaisePerc |
decimal(21,2) | Nee | ((0)) | — |
JobmCompId |
nvarchar(6) | Nee | — | — |
JobmCostCalcDecimals |
smallint | Nee | ((0)) | — |
JobmCostDecimals |
smallint | Nee | ((0)) | — |
JobmCsttId |
nvarchar(9) | Ja | — | — |
JobmCusId |
nvarchar(6) | Ja | — | — |
JobmDataProvider |
nvarchar(50) | Ja | — | — |
JobmDepId |
nvarchar(11) | Ja | — | — |
JobmDiscount |
decimal(21,0) | Nee | — | — |
JobmDiscountTariff |
decimal(21,5) | Nee | — | — |
JobmDlvTime |
time(7) | Ja | — | — |
JobmEqmId |
nvarchar(24) | Ja | — | — |
JobmExported |
smallint | Nee | ((0)) | — |
JobmExternalId |
nvarchar(50) | Ja | — | — |
JobmExternalStatus |
nvarchar(50) | Ja | — | — |
JobmExtra1 |
smallint | Nee | ((0)) | — |
JobmExtra2 |
int | Nee | ((0)) | — |
JobmExtra3 |
nvarchar(5) | Ja | — | — |
JobmInvCost |
decimal(21,5) | Nee | ((0)) | — |
JobmInvoId |
nvarchar(9) | Ja | — | — |
JobmInvolLineId |
nvarchar(8) | Ja | — | — |
JobmInvQty |
decimal(21,2) | Nee | ((0)) | — |
JobmJobjplId |
nvarchar(6) | Ja | — | — |
JobmJpId |
nvarchar(11) | Ja | — | — |
JobmOrgRecStatus |
int | Nee | ((0)) | — |
JobmOrgResQty |
decimal(21,2) | Nee | ((0)) | — |
JobmPlanQty |
decimal(21,2) | Nee | ((0)) | — |
JobmPrfId |
nvarchar(50) | Ja | — | — |
JobmPrice |
decimal(21,5) | Nee | ((0)) | — |
JobmPriceCalc |
decimal(21,5) | Nee | ((0)) | — |
JobmPrjId |
nvarchar(6) | Ja | — | — |
JobmProviderMutDate |
datetimeoffset(7) | Ja | — | — |
JobmQty |
decimal(21,2) | Nee | ((0)) | — |
JobmQtyIn |
decimal(21,2) | Nee | ((0)) | — |
JobmRaisePerc |
decimal(21,2) | Nee | ((0)) | — |
JobmRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
JobmResQty |
decimal(21,2) | Nee | ((0)) | — |
JobmSkcId |
nvarchar(9) | Ja | — | — |
JobmTotalPriceDecimals |
smallint | Nee | ((0)) | — |
JobmTransferNextTime |
smallint | Nee | ((0)) | — |
JobmVatId |
nvarchar(3) | Ja | — | — |
JobmVatPercentage |
decimal(21,2) | Nee | ((0)) | — |
JobmWhsId |
nvarchar(10) | Ja | — | — |
JobmWhslCode |
nvarchar(20) | Ja | — | — |
JobmWhslWhsId |
nvarchar(10) | Ja | — | — |
JobmWhsoId |
nvarchar(9) | Ja | — | — |
JobmWhsolLineId |
nvarchar(9) | Ja | — | — |
JobmCost |
decimal(21,5) | Nee | — | — |
JobmCostCalc |
decimal(21,5) | Nee | — | — |
JobmTotalPrice |
decimal(21,5) | Nee | — | — |
JobmSitId |
nvarchar(8) | Ja | — | — |
JobmPickedQuantity |
decimal(21,2) | Nee | ((0)) | — |
Computed columnsbewerken
JobmCost—(CONVERT([decimal](21,5),round((([Jobmqty]-[Jobmqtyin])*[Jobmprice])*((1)+[Jobmraiseperc]/(100)),[JobmCostDecimals])))JobmCostCalc—(CONVERT([decimal](21,5),round(([JobmPlanQty]*[JobmPriceCalc])*((1)+[Jobmraiseperc]/(100)),[JobmCostCalcDecimals])))JobmTotalPrice—(CONVERT([decimal](21,5),round(([Jobmqty]-[Jobmqtyin])*[Jobmprice],[JobmTotalPriceDecimals])))
Trigger-gevulde kolommenbewerken
JobmBookDate← TRGU_JobMatJobmCostCalcDecimals← TRGI_JobMat, TRGU_SFIELDJobmCostDecimals← TRGI_JobMat, TRGU_SFIELDJobmTotalPriceDecimals← TRGI_JobMat, TRGU_SFIELDJobmSitId← TRGI_JobMat, TRGU_Job, TRGU_JobMat
Brondatabewerken
- DB-schema —
lookup_table_schema("JobMat")Alle kolommen met types, triggers, computed. Bron:database-schema.json.