Bewerken: Account

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `AccId` | nvarchar(11) | Nee | — | — |
| `AccDescr` | nvarchar(200) | Ja | — | — |
| `AccContext` | bigint | Nee | ((1)) | — |
| `AccRecStatus` | int | Nee | ((0)) | — |
| `AccCompId` | nvarchar(6) | Nee | — | — |
| `AccDataProvider` | nvarchar(50) | Ja | — | — |
| `AccExported` | smallint | Nee | ((0)) | — |
| `AccExternalId` | nvarchar(50) | Ja | — | — |
| `AccExternalStatus` | nvarchar(50) | Ja | — | — |
| `AccExtra1` | int | Nee | ((0)) | — |
| `AccExtra2` | nvarchar(15) | Ja | — | — |
| `AccExtra3` | nvarchar(15) | Ja | — | — |
| `AccExtra4` | nvarchar(15) | Ja | — | — |
| `AccInvoiced` | decimal(21,5) | Nee | ((0)) | — |
| `AccInvoicedLY` | decimal(21,5) | Nee | ((0)) | — |
| `AccMemorandumCostBY` | decimal(21,5) | Nee | ((0)) | — |
| `AccMemorandumCostLY` | decimal(21,5) | Nee | ((0)) | — |
| `AccProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `AccPurchased` | decimal(21,5) | Nee | ((0)) | — |
| `AccPurchasedLY` | decimal(21,5) | Nee | ((0)) | — |
| `AccRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `AccTransferNextTime` | smallint | Nee | ((0)) | — |