Bewerken: Receipt

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `RcpId` | nvarchar(9) | Nee | — | — |
| `RcpDescr` | nvarchar(200) | Ja | — | — |
| `RcpContext` | bigint | Nee | ((1)) | — |
| `RcpRecStatus` | int | Nee | ((0)) | — |
| `RcpApprvDate` | datetimeoffset(7) | Ja | — | — |
| `RcpApprvEmpId` | nvarchar(9) | Ja | — | — |
| `RcpCompId` | nvarchar(6) | Nee | — | — |
| `RcpCurConvFactor` | smallint | Nee | ((0)) | — |
| `RcpCurId` | nvarchar(5) | Nee | — | — |
| `RcpCurRate` | decimal(21,5) | Nee | ((0)) | — |
| `RcpDataProvider` | nvarchar(50) | Ja | — | — |
| `RcpDate` | datetimeoffset(7) | Ja | — | — |
| `RcpExported` | smallint | Nee | ((0)) | — |
| `RcpExternalId` | nvarchar(50) | Ja | — | — |
| `RcpExternalStatus` | nvarchar(50) | Ja | — | — |
| `RcpExtra1` | smallint | Nee | ((0)) | — |
| `RcpExtra2` | smallint | Nee | ((0)) | — |
| `RcpExtra3` | int | Nee | ((0)) | — |
| `RcpExtra4` | int | Nee | ((0)) | — |
| `RcpExtra5` | nvarchar(15) | Ja | — | — |
| `RcpExtra6` | nvarchar(15) | Ja | — | — |
| `RcpExtra7` | nvarchar(15) | Ja | — | — |
| `RcpPackingSlip` | nvarchar(20) | Ja | — | — |
| `RcpPchId` | nvarchar(10) | Ja | — | — |
| `RcpPreApprvDate` | datetimeoffset(7) | Ja | — | — |
| `RcpPreApprvEmpId` | nvarchar(9) | Ja | — | — |
| `RcpProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `RcpRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `RcpSitId` | nvarchar(8) | Ja | — | — |
| `RcpText` | nvarchar(max) | Ja | — | — |
| `RcpTransferNextTime` | smallint | Nee | ((0)) | — |
| `RcpVdrId` | nvarchar(6) | Ja | — | — |
| `RcpWhsId` | nvarchar(10) | Ja | — | — |