Bewerken: InvoiceOut

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `InvoId` | nvarchar(9) | Nee | — | — |
| `InvoDescr` | nvarchar(200) | Ja | — | — |
| `InvoContext` | bigint | Nee | ((1)) | — |
| `InvoRecStatus` | int | Nee | ((0)) | — |
| `InvoBookDate` | date | Ja | — | — |
| `InvoCcrId` | nvarchar(9) | Ja | — | — |
| `InvoCompId` | nvarchar(6) | Nee | — | — |
| `InvoCostCalc` | decimal(21,5) | Nee | ((0)) | — |
| `InvoCreateDate` | date | Ja | — | — |
| `InvoCreditCompleted` | smallint | Nee | ((0)) | — |
| `InvoCreditCompletedDate` | datetimeoffset(7) | Ja | — | — |
| `InvoCreditCompletedEmpId` | nvarchar(9) | Ja | — | — |
| `InvoCusId` | nvarchar(6) | Ja | — | — |
| `InvoDepId` | nvarchar(11) | Ja | — | — |
| `InvoEqmCost` | decimal(21,5) | Nee | ((0)) | — |
| `InvoEqmId` | nvarchar(24) | Ja | — | — |
| `InvoEqmInv` | decimal(21,5) | Nee | ((0)) | — |
| `InvoExported` | smallint | Nee | ((0)) | — |
| `InvoExtCost` | decimal(21,5) | Nee | ((0)) | — |
| `InvoExtCostCalc` | decimal(21,5) | Nee | ((0)) | — |
| `InvoExtInv` | decimal(21,5) | Nee | ((0)) | — |
| `InvoInvDate` | date | Ja | — | — |
| `InvoInvocId` | nvarchar(14) | Ja | — | — |
| `InvoInvpId` | nvarchar(14) | Ja | — | — |
| `InvoIotCalc` | decimal(21,5) | Nee | ((0)) | — |
| `InvoIotCost` | decimal(21,5) | Nee | ((0)) | — |
| `InvoIotInv` | decimal(21,5) | Nee | ((0)) | — |
| `InvoJobId` | nvarchar(12) | Ja | — | — |
| `InvoLabCost` | decimal(21,5) | Nee | ((0)) | — |
| `InvoLabInv` | decimal(21,5) | Nee | ((0)) | — |
| `InvoLabourCostCalc` | decimal(21,5) | Nee | ((0)) | — |
| `InvoPrfId` | nvarchar(50) | Ja | — | — |
| `InvoPrjId` | nvarchar(6) | Ja | — | — |
| `InvoPurchCost` | decimal(21,5) | Nee | ((0)) | — |
| `InvoPurchCostCalc` | decimal(21,5) | Nee | ((0)) | — |
| `InvoPurchInv` | decimal(21,5) | Nee | ((0)) | — |
| `InvoRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `InvoResCalc` | decimal(21,5) | Nee | ((0)) | — |
| `InvoResCost` | decimal(21,5) | Nee | ((0)) | — |
| `InvoResInv` | decimal(21,5) | Nee | ((0)) | — |
| `InvoResocId` | nvarchar(4) | Ja | — | — |
| `InvoResocResId` | nvarchar(6) | Ja | — | — |
| `INVORRECOSTINV` | decimal(21,5) | Nee | ((0)) | — |
| `InvoSkcId` | nvarchar(9) | Ja | — | — |
| `InvoSourceInvoId` | nvarchar(9) | Ja | — | — |
| `InvoSvcId` | nvarchar(9) | Ja | — | — |
| `InvoTlsCost` | decimal(21,5) | Nee | ((0)) | — |
| `InvoTlsCostCalc` | decimal(21,5) | Nee | ((0)) | — |
| `InvoTlsInv` | decimal(21,5) | Nee | ((0)) | — |
| `InvoTotCostVatId` | nvarchar(3) | Ja | — | — |
| `InvoTotCostVatPercentage` | decimal(21,2) | Nee | ((0)) | — |
| `InvoTotCostVatPrice` | decimal(21,5) | Nee | ((0)) | — |
| `InvoVdrId` | nvarchar(6) | Ja | — | — |
| `InvoWhsoCost` | decimal(21,5) | Nee | ((0)) | — |
| `InvoWhsoCostCalc` | decimal(21,5) | Nee | ((0)) | — |
| `InvoWhsoInv` | decimal(21,5) | Nee | ((0)) | — |
| `InvoWotId` | nvarchar(6) | Ja | — | — |
| `InvoTotCost` | decimal(21,2) | Nee | — | — |
| `InvoDataProvider` | nvarchar(50) | Ja | — | — |
| `InvoProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `InvoTransferNextTime` | smallint | Nee | ((0)) | — |
| `InvoExternalId` | nvarchar(50) | Ja | — | — |
| `InvoExternalStatus` | nvarchar(50) | Ja | — | — |