Bewerken: InvoiceOutLine

Sectie: Kolommen

Reden:

## Kolommen

| 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 | — | — |