Bewerken: Invoice

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `InvId` | nvarchar(9) | Nee | — | — |
| `InvDescr` | nvarchar(200) | Ja | — | — |
| `InvContext` | bigint | Nee | ((1)) | — |
| `InvRecStatus` | int | Nee | ((0)) | — |
| `InvBookDate` | date | Ja | — | — |
| `InvCompId` | nvarchar(6) | Nee | — | — |
| `InvCurConvFactor` | smallint | Nee | ((0)) | — |
| `InvCurId` | nvarchar(5) | Nee | — | — |
| `InvCurRate` | decimal(21,5) | Nee | ((0)) | — |
| `InvDataProvider` | nvarchar(50) | Ja | — | — |
| `InvDate` | datetimeoffset(7) | Ja | — | — |
| `InvDepId` | nvarchar(11) | Ja | — | — |
| `InvEmpId` | nvarchar(9) | Ja | — | — |
| `InvExported` | smallint | Nee | ((0)) | — |
| `InvExternalId` | nvarchar(50) | Ja | — | — |
| `InvExternalStatus` | nvarchar(50) | Ja | — | — |
| `InvExtra1` | smallint | Nee | ((0)) | — |
| `InvExtra2` | int | Nee | ((0)) | — |
| `InvExtra3` | int | Nee | ((0)) | — |
| `InvExtra4` | nvarchar(15) | Ja | — | — |
| `InvExtra5` | nvarchar(15) | Ja | — | — |
| `InvExtra6` | nvarchar(15) | Ja | — | — |
| `InvPchId` | nvarchar(10) | Ja | — | — |
| `InvProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `InvPurchaseAddType` | smallint | Nee | ((0)) | — |
| `InvRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `InvSitId` | nvarchar(8) | Ja | — | — |
| `InvStdTotPrice` | decimal(21,5) | Nee | ((0)) | — |
| `InvStdTotPriceInclVat` | decimal(21,5) | Nee | ((0)) | — |
| `InvStdVatPrice` | decimal(21,5) | Nee | ((0)) | — |
| `InvText` | nvarchar(max) | Ja | — | — |
| `InvTotal` | decimal(21,5) | Nee | ((0)) | — |
| `InvTransferNextTime` | smallint | Nee | ((0)) | — |
| `InvVdrId` | nvarchar(6) | Ja | — | — |
| `InvFileExtension` | nvarchar(5) | Nee | — | — |
| `InvText_FT` | varbinary(max) | Ja | — | — |