Bewerken: PurchaseAdvice

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `PadId` | nvarchar(9) | Nee | — | — |
| `PadDescr` | nvarchar(200) | Ja | — | — |
| `PadContext` | bigint | Nee | ((1)) | — |
| `PadRecStatus` | int | Nee | ((0)) | — |
| `PadAccId` | nvarchar(11) | Ja | — | — |
| `PadCcrId` | nvarchar(9) | Ja | — | — |
| `PadCompId` | nvarchar(6) | Nee | — | — |
| `PadConcept` | smallint | Nee | ((0)) | — |
| `PadDate` | datetimeoffset(7) | Ja | — | — |
| `PadDepId` | nvarchar(11) | Ja | — | — |
| `PadExported` | smallint | Nee | ((0)) | — |
| `PadGroupOnCcr` | smallint | Nee | ((0)) | — |
| `PadGroupOnDep` | smallint | Nee | ((0)) | — |
| `PadGroupOnSit` | smallint | Nee | ((0)) | — |
| `PadGroupOnWarehouse` | smallint | Nee | ((0)) | — |
| `PadPurchase` | smallint | Nee | ((0)) | — |
| `PadQty` | int | Nee | ((0)) | — |
| `PadRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `PadSearchOnCcr` | smallint | Nee | ((0)) | — |
| `PadSearchOnDep` | smallint | Nee | ((0)) | — |
| `PadSearchOnSit` | smallint | Nee | ((0)) | — |
| `PadSearchOnWarehouse` | smallint | Nee | ((0)) | — |
| `PadSelectMethod` | smallint | Nee | ((0)) | — |
| `PadSitId` | nvarchar(8) | Ja | — | — |
| `PadUseCcrAsExpenseCarr` | smallint | Nee | ((0)) | — |
| `PadUseDepAsExpenseCarr` | smallint | Nee | ((0)) | — |
| `PadUseSitAsExpenseCarr` | smallint | Nee | ((0)) | — |
| `PadWhsId` | nvarchar(10) | Ja | — | — |