title: "InvoiceOutLine (table)" category: reference tags: [table, invoiceoutline, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.InvoiceOutLine
Schema: dba
Aantal kolommen: 110
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
InvolInvoId |
nvarchar(9) | Nee | — | — |
InvolLineId |
nvarchar(8) | Nee | — | — |
InvolDescr |
nvarchar(200) | Ja | — | — |
InvolContext |
bigint | Nee | ((0)) | — |
InvolRecStatus |
int | Nee | ((0)) | — |
InvolAmount |
decimal(21,2) | Nee | ((0)) | — |
InvolCcrId |
nvarchar(9) | Ja | — | — |
InvolCompId |
nvarchar(6) | Nee | — | — |
InvolConlcId |
nvarchar(9) | Ja | — | — |
InvolConlcmId |
nvarchar(9) | Ja | — | — |
InvolConlId |
nvarchar(9) | Ja | — | — |
InvolCorrectionInvoId |
nvarchar(9) | Ja | — | — |
InvolCorrectionLineId |
nvarchar(8) | Ja | — | — |
InvolCostCalc |
decimal(21,5) | Nee | ((0)) | — |
InvolCostVatId |
nvarchar(3) | Ja | — | — |
InvolCostVatPercentage |
decimal(21,5) | Nee | ((0)) | — |
InvolCostVatPrice |
decimal(21,5) | Nee | ((0)) | — |
InvolCsttId |
nvarchar(9) | Ja | — | — |
InvolCusId |
nvarchar(6) | Ja | — | — |
InvolDepId |
nvarchar(11) | Ja | — | — |
InvolEqmCost |
decimal(21,5) | Nee | ((0)) | — |
InvolEqmId |
nvarchar(24) | Ja | — | — |
InvolEqmInv |
decimal(21,5) | Nee | ((0)) | — |
InvolExported |
smallint | Nee | ((0)) | — |
InvolExtCalcQty |
decimal(21,2) | Nee | ((0)) | — |
InvolExtCost |
decimal(21,5) | Nee | ((0)) | — |
InvolExtCostCalc |
decimal(21,5) | Nee | ((0)) | — |
InvolExtCostInv |
decimal(21,5) | Nee | ((0)) | — |
InvolExtQty |
decimal(21,2) | Nee | ((0)) | — |
InvolExtQtyInv |
decimal(21,2) | Nee | ((0)) | — |
InvolHoursCost |
decimal(21,2) | Nee | ((0)) | — |
InvolHoursInv |
decimal(21,2) | Nee | ((0)) | — |
InvolIncludeInCorrection |
smallint | Nee | ((0)) | — |
InvolInvlInvId |
nvarchar(9) | Ja | — | — |
InvolInvlLineId |
nvarchar(4) | Ja | — | — |
InvolInvocId |
nvarchar(14) | Ja | — | — |
InvolIotCost |
decimal(21,5) | Nee | ((0)) | — |
InvolIotCostCalc |
decimal(21,5) | Nee | ((0)) | — |
InvolIotInv |
decimal(21,5) | Nee | ((0)) | — |
InvolJobeJobId |
nvarchar(12) | Ja | — | — |
InvolJobeLineId |
nvarchar(9) | Ja | — | — |
InvolJobId |
nvarchar(12) | Ja | — | — |
InvolJobiotJobId |
nvarchar(12) | Ja | — | — |
InvolJobiotLineId |
nvarchar(9) | Ja | — | — |
InvolJobjplId |
nvarchar(6) | Ja | — | — |
InvolJobmJobId |
nvarchar(12) | Ja | — | — |
InvolJobmLineId |
nvarchar(9) | Ja | — | — |
InvolJobrJobId |
nvarchar(12) | Ja | — | — |
InvolJobrLineId |
nvarchar(9) | Ja | — | — |
InvolJobtJobId |
nvarchar(12) | Ja | — | — |
InvolJobtLineId |
nvarchar(9) | Ja | — | — |
InvolJobwlJobId |
nvarchar(12) | Ja | — | — |
InvolJobwlLineId |
nvarchar(9) | Ja | — | — |
InvolJobwlWeek |
int | Ja | — | — |
InvolLabCost |
decimal(21,5) | Nee | ((0)) | — |
InvolLabInv |
decimal(21,5) | Nee | ((0)) | — |
InvolLabourCalcHours |
decimal(21,2) | Nee | ((0)) | — |
InvolLabourCostCalc |
decimal(21,5) | Nee | ((0)) | — |
InvolMatInvQty |
decimal(21,2) | Nee | ((0)) | — |
InvolMatPlanQty |
decimal(21,2) | Nee | ((0)) | — |
InvolMatQty |
decimal(21,2) | Nee | ((0)) | — |
InvolMatQtyIn |
decimal(21,2) | Nee | ((0)) | — |
InvolPchrlId |
nvarchar(8) | Ja | — | — |
InvolPeriodFromDate |
date | Ja | — | — |
InvolPeriodTillDate |
date | Ja | — | — |
InvolPrfId |
nvarchar(50) | Ja | — | — |
InvolPrjId |
nvarchar(6) | Ja | — | — |
InvolPurchCalcQty |
decimal(21,2) | Nee | ((0)) | — |
InvolPurchCost |
decimal(21,5) | Nee | ((0)) | — |
InvolPurchCostCalc |
decimal(21,5) | Nee | ((0)) | — |
InvolPurchCostInv |
decimal(21,5) | Nee | ((0)) | — |
InvolPurchQty |
decimal(21,2) | Nee | ((0)) | — |
InvolPurchQtyInv |
decimal(21,2) | Nee | ((0)) | — |
InvolRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
InvolResCost |
decimal(21,5) | Nee | ((0)) | — |
InvolResCostCalc |
decimal(21,5) | Nee | ((0)) | — |
InvolResInv |
decimal(21,5) | Nee | ((0)) | — |
InvolReslId |
nvarchar(11) | Ja | — | — |
InvolResocId |
nvarchar(4) | Ja | — | — |
InvolResocResId |
nvarchar(6) | Ja | — | — |
INVOLRRECOSTINV |
decimal(21,5) | Nee | ((0)) | — |
InvolSkcId |
nvarchar(9) | Ja | — | — |
InvolSvcId |
nvarchar(9) | Ja | — | — |
InvolTlsCalcHours |
decimal(21,2) | Nee | ((0)) | — |
InvolTlsCalcQty |
decimal(21,2) | Nee | ((0)) | — |
InvolTlsCost |
decimal(21,5) | Nee | ((0)) | — |
InvolTlsCostCalc |
decimal(21,5) | Nee | ((0)) | — |
InvolTlsHoursCost |
decimal(21,2) | Nee | ((0)) | — |
InvolTlsHoursInv |
decimal(21,2) | Nee | ((0)) | — |
InvolTlsInv |
decimal(21,5) | Nee | ((0)) | — |
InvolTlsQty |
decimal(21,2) | Nee | ((0)) | — |
InvolTlsQtyInv |
decimal(21,2) | Nee | ((0)) | — |
InvolTotCostVatId |
nvarchar(3) | Ja | — | — |
InvolTotCostVatPercentage |
decimal(21,2) | Nee | ((0)) | — |
InvolWhsoCost |
decimal(21,5) | Nee | ((0)) | — |
InvolWhsoCostCalc |
decimal(21,5) | Nee | ((0)) | — |
InvolWhsoInv |
decimal(21,5) | Nee | ((0)) | — |
InvolWhsoInvQty |
decimal(21,2) | Nee | ((0)) | — |
InvolWhsolLineId |
nvarchar(9) | Ja | — | — |
InvolWhsolWhsoId |
nvarchar(9) | Ja | — | — |
InvolWhsoQty |
decimal(21,2) | Nee | ((0)) | — |
InvolWhsoQtyIn |
decimal(21,2) | Nee | ((0)) | — |
InvolCost |
decimal(21,2) | Nee | — | — |
InvolTotCost |
decimal(21,2) | Nee | — | — |
INVOLTOTCOSTVATPRICE |
decimal(21,2) | Nee | — | — |
InvolDataProvider |
nvarchar(50) | Ja | — | — |
InvolProviderMutDate |
datetimeoffset(7) | Ja | — | — |
InvolTransferNextTime |
smallint | Nee | ((0)) | — |
InvolExternalId |
nvarchar(50) | Ja | — | — |
InvolExternalStatus |
nvarchar(50) | Ja | — | — |
Computed columnsbewerken
InvolCost—(CONVERT([decimal](21,2),((((((([INVOLEQMINV]+[INVOLEXTCOSTINV])+[INVOLIOTINV])+[INVOLLABINV])+[INVOLPURCHCOSTINV])+[INVOLRESINV])+[INVOLTLSINV])+[INVOLWHSOINV])+[INVOLRRECOSTINV]))InvolTotCost—(CONVERT([decimal](21,2),((((((((([INVOLEQMINV]+[INVOLEXTCOSTINV])+[INVOLIOTINV])+[INVOLLABINV])+[INVOLPURCHCOSTINV])+[INVOLRESINV])+[INVOLTLSINV])+[INVOLWHSOINV])+[INVOLRRECOSTINV])*([InvolTotCostVatPercentage]+(100)))/(100)))INVOLTOTCOSTVATPRICE—(CONVERT([decimal](21,2),((((((((([INVOLEQMINV]+[INVOLEXTCOSTINV])+[INVOLIOTINV])+[INVOLLABINV])+[INVOLPURCHCOSTINV])+[INVOLRESINV])+[INVOLTLSINV])+[INVOLWHSOINV])+[INVOLRRECOSTINV])*[InvolTotCostVatPercentage])/(100)))
Brondatabewerken
- DB-schema —
lookup_table_schema("InvoiceOutLine")Alle kolommen met types, triggers, computed. Bron:database-schema.json.