Bewerken: JobInvOutTerm

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `JobiotJobId` | nvarchar(12) | Nee | — | — |
| `JobiotLineId` | nvarchar(9) | Nee | — | — |
| `JobiotDescr` | nvarchar(200) | Ja | — | — |
| `JobiotContext` | bigint | Nee | ((0)) | — |
| `JobiotRecStatus` | int | Nee | ((0)) | — |
| `JobiotBookDate` | date | Ja | — | — |
| `JobiotCcrId` | nvarchar(9) | Ja | — | — |
| `JobiotCompId` | nvarchar(6) | Nee | — | — |
| `JobiotCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobiotCsttId` | nvarchar(9) | Ja | — | — |
| `JobiotCusId` | nvarchar(6) | Ja | — | — |
| `JobiotDepId` | nvarchar(11) | Ja | — | — |
| `JobiotEqmId` | nvarchar(24) | Ja | — | — |
| `JobiotExported` | smallint | Nee | ((0)) | — |
| `JobiotInvCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobiotInvoId` | nvarchar(9) | Ja | — | — |
| `JobiotInvolLineId` | nvarchar(8) | Ja | — | — |
| `JobiotOrgRecStatus` | int | Nee | ((0)) | — |
| `JobiotPrfId` | nvarchar(50) | Ja | — | — |
| `JobiotPrjId` | nvarchar(6) | Ja | — | — |
| `JobiotRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `JobiotSkcId` | nvarchar(9) | Ja | — | — |
| `JobiotTermSeqNo` | smallint | Nee | ((0)) | — |
| `JobiotVatId` | nvarchar(3) | Ja | — | — |
| `JobiotVatPercentage` | decimal(21,2) | Nee | ((0)) | — |