Bewerken: ReceiptLine

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `RcplRcpId` | nvarchar(9) | Nee | — | — |
| `RcplLineId` | nvarchar(4) | Nee | — | — |
| `RcplContext` | bigint | Nee | ((0)) | — |
| `RcplRecStatus` | int | Nee | ((0)) | — |
| `RcplArtId` | nvarchar(9) | Ja | — | — |
| `RcplArtvPurchCode` | nvarchar(60) | Ja | — | — |
| `RcplCompId` | nvarchar(6) | Nee | — | — |
| `RcplDataProvider` | nvarchar(50) | Ja | — | — |
| `RcplExported` | smallint | Nee | ((0)) | — |
| `RcplExternalId` | nvarchar(50) | Ja | — | — |
| `RcplExternalStatus` | nvarchar(50) | Ja | — | — |
| `RcplExtra1` | smallint | Nee | ((0)) | — |
| `RcplExtra2` | smallint | Nee | ((0)) | — |
| `RcplExtra3` | decimal(21,2) | Nee | ((0)) | — |
| `RcplExtra4` | decimal(21,2) | Nee | ((0)) | — |
| `RcplExtra5` | nvarchar(41) | Ja | — | — |
| `RcplExtra6` | nvarchar(15) | Ja | — | — |
| `RcplExtra7` | nvarchar(15) | Ja | — | — |
| `RcplPchId` | nvarchar(10) | Ja | — | — |
| `RcplPchlId` | nvarchar(4) | Ja | — | — |
| `RcplPrice` | decimal(21,5) | Nee | ((0)) | — |
| `RcplProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `RcplRcvQty` | decimal(21,2) | Nee | ((0)) | — |
| `RcplRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `RcplRetQty` | decimal(21,2) | Nee | ((0)) | — |
| `RcplRetToRcvQty` | decimal(21,2) | Nee | ((0)) | — |
| `RcplTransferNextTime` | smallint | Nee | ((0)) | — |
| `RcplWhslCode` | nvarchar(20) | Ja | — | — |
| `RcplWhslWhsId` | nvarchar(10) | Ja | — | — |