Bewerken: PurchaseAdviceLine

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `PadlPadId` | nvarchar(9) | Nee | — | — |
| `PadlArtId` | nvarchar(9) | Nee | — | — |
| `PadlContext` | bigint | Nee | ((0)) | — |
| `PadlRecStatus` | int | Nee | ((0)) | — |
| `PadlArtvPurchCode` | nvarchar(60) | Ja | — | — |
| `PadlCcrId` | nvarchar(9) | Ja | — | — |
| `PadlCompId` | nvarchar(6) | Nee | — | — |
| `PadlConcept` | smallint | Nee | ((0)) | — |
| `PadlCurId` | nvarchar(5) | Nee | — | — |
| `PadlDepId` | nvarchar(11) | Ja | — | — |
| `PadlDiscount` | decimal(21,2) | Nee | ((0)) | — |
| `PadlDlvDate` | datetimeoffset(7) | Ja | — | — |
| `PadlExported` | smallint | Nee | ((0)) | — |
| `PadlExtra1` | smallint | Nee | ((0)) | — |
| `PadlExtra2` | smallint | Nee | ((0)) | — |
| `PadlExtra3` | int | Nee | ((0)) | — |
| `PadlExtra4` | int | Nee | ((0)) | — |
| `PadlExtra5` | nvarchar(15) | Ja | — | — |
| `PadlExtra6` | nvarchar(15) | Ja | — | — |
| `PadlExtra7` | nvarchar(15) | Ja | — | — |
| `PadlGrossPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PadlGrossTotPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PadlLeadTime` | int | Nee | ((0)) | — |
| `PadlPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PadlPurchase` | smallint | Nee | ((0)) | — |
| `PadlPurchQty` | decimal(21,2) | Nee | ((0)) | — |
| `PadlQtyPurchUnt` | decimal(21,2) | Nee | ((0)) | — |
| `PadlRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `PadlSitId` | nvarchar(8) | Ja | — | — |
| `PadlTotPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PadlTotPriceInclVat` | decimal(21,5) | Nee | ((0)) | — |
| `PadlUntDescr` | nvarchar(9) | Ja | — | — |
| `PadlVatId` | nvarchar(3) | Ja | — | — |
| `PadlVatPercentage` | decimal(21,2) | Nee | ((0)) | — |
| `PadlVatPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PadlVdrId` | nvarchar(6) | Ja | — | — |
| `PadlWhsId` | nvarchar(10) | Ja | — | — |