Bewerken: ContractLine

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `ConlId` | nvarchar(9) | Nee | — | — |
| `ConlDescr` | nvarchar(200) | Ja | — | — |
| `ConlContext` | bigint | Nee | ((0)) | — |
| `ConlRecStatus` | int | Nee | ((0)) | — |
| `ConlCcrId` | nvarchar(9) | Ja | — | — |
| `ConlChargeFrqFrqpId` | nvarchar(7) | Ja | — | — |
| `ConlChargeMomentFrqFrqpId` | nvarchar(7) | Ja | — | — |
| `ConlCompId` | nvarchar(6) | Nee | — | — |
| `ConlConlcmgId` | nvarchar(7) | Ja | — | — |
| `ConlConltId` | nvarchar(9) | Ja | — | — |
| `ConlCorrCntrlCostMutId` | nvarchar(9) | Ja | — | — |
| `ConlCsttId` | nvarchar(9) | Ja | — | — |
| `ConlEndDate` | date | Ja | — | — |
| `ConlExported` | smallint | Nee | ((0)) | — |
| `ConlIndexable` | smallint | Nee | ((0)) | — |
| `ConlInvoiceOnce` | smallint | Nee | ((0)) | — |
| `ConlNextInvoiceDate` | date | Ja | — | — |
| `ConlPartOfConlId` | nvarchar(9) | Ja | — | — |
| `ConlPaymentFrqCount` | int | Nee | ((0)) | — |
| `ConlPaymentFrqId` | nvarchar(3) | Ja | — | — |
| `ConlPaymentUpFront` | smallint | Nee | ((0)) | — |
| `ConlPrice` | decimal(21,5) | Nee | ((0)) | — |
| `ConlPricePerDay` | decimal(21,5) | Nee | ((0)) | — |
| `ConlRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `ConlRntreclId` | nvarchar(9) | Ja | — | — |
| `ConlSpcId` | nvarchar(40) | Ja | — | — |
| `ConlStartDate` | date | Ja | — | — |
| `ConlStartDateChargePeriod` | date | Ja | — | — |
| `ConlSvcId` | nvarchar(9) | Ja | — | — |
| `ConlVatId` | nvarchar(3) | Ja | — | — |
| `ConlVatPercentage` | decimal(21,2) | Nee | ((0)) | — |
| `ConlVatPrice` | decimal(21,5) | Nee | ((0)) | — |