Bewerken: Purchase

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `PchId` | nvarchar(10) | Nee | — | — |
| `PchDescr` | nvarchar(200) | Ja | — | — |
| `PchContext` | bigint | Nee | ((1)) | — |
| `PchRecStatus` | int | Nee | ((0)) | — |
| `PchAccId` | nvarchar(11) | Ja | — | — |
| `PchAdviceDate` | datetimeoffset(7) | Ja | — | — |
| `PchAdviceEmpId` | nvarchar(9) | Ja | — | — |
| `PchApprvDate` | datetimeoffset(7) | Ja | — | — |
| `PchApprvEmpId` | nvarchar(9) | Ja | — | — |
| `PchBookDate` | date | Ja | — | — |
| `PchCancelDate` | datetimeoffset(7) | Ja | — | — |
| `PchCancelEmpId` | nvarchar(9) | Ja | — | — |
| `PchCcrId` | nvarchar(9) | Ja | — | — |
| `PchCloseDate` | datetimeoffset(7) | Ja | — | — |
| `PchCloseEmpId` | nvarchar(9) | Ja | — | — |
| `PchCmnt1` | nvarchar(41) | Ja | — | — |
| `PchCmnt2` | nvarchar(41) | Ja | — | — |
| `PchCompId` | nvarchar(6) | Nee | — | — |
| `PchConceptDate` | datetimeoffset(7) | Ja | — | — |
| `PchConceptEmpId` | nvarchar(9) | Ja | — | — |
| `PchContactEmpId` | nvarchar(9) | Ja | — | — |
| `PchCreatedDate` | datetimeoffset(7) | Ja | — | — |
| `PchCreatedEmpId` | nvarchar(9) | Ja | — | — |
| `PchCurConvFactor` | smallint | Nee | ((0)) | — |
| `PchCurId` | nvarchar(5) | Nee | — | — |
| `PchCurRate` | decimal(21,5) | Nee | ((0)) | — |
| `PchDataProvider` | nvarchar(50) | Ja | — | — |
| `PchDate` | datetimeoffset(7) | Ja | — | — |
| `PchDepId` | nvarchar(11) | Ja | — | — |
| `PchDlvaId` | nvarchar(2) | Ja | — | — |
| `PchDlvDate` | date | Ja | — | — |
| `PchDlvtId` | nvarchar(3) | Ja | — | — |
| `PchEmpId` | nvarchar(9) | Ja | — | — |
| `PchExported` | smallint | Nee | ((0)) | — |
| `PchExternalId` | nvarchar(50) | Ja | — | — |
| `PchExternalStatus` | nvarchar(50) | Ja | — | — |
| `PchExtra1` | smallint | Nee | ((0)) | — |
| `PchExtra2` | smallint | Nee | ((0)) | — |
| `PchExtra3` | int | Nee | ((0)) | — |
| `PchExtra4` | int | Nee | ((0)) | — |
| `PchExtra5` | nvarchar(15) | Ja | — | — |
| `PchExtra6` | nvarchar(15) | Ja | — | — |
| `PchExtra7` | nvarchar(15) | Ja | — | — |
| `PchJobId` | nvarchar(12) | Ja | — | — |
| `PchLngId` | nvarchar(3) | Ja | — | — |
| `PchNowInv` | decimal(21,5) | Nee | ((0)) | — |
| `PchNowInvInclVat` | decimal(21,5) | Nee | ((0)) | — |
| `PchNumberOfLines` | int | Nee | ((0)) | — |
| `PchPartReceivedDate` | datetimeoffset(7) | Ja | — | — |
| `PchPartReceivedEmpId` | nvarchar(9) | Ja | — | — |
| `PchPchmId` | nvarchar(3) | Ja | — | — |
| `PchProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `PchPymtId` | nvarchar(5) | Ja | — | — |
| `PchRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `PchReceivedDate` | datetimeoffset(7) | Ja | — | — |
| `PchReceivedEmpId` | nvarchar(9) | Ja | — | — |
| `PchReference` | nvarchar(41) | Ja | — | — |
| `PchRequestEmpId` | nvarchar(9) | Ja | — | — |
| `PchRfqId` | nvarchar(5) | Ja | — | — |
| `PchSitId` | nvarchar(8) | Ja | — | — |
| `PchStdTotPriceInclVat` | decimal(21,5) | Nee | ((0)) | — |
| `PchStdVatPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PchText` | nvarchar(max) | Ja | — | — |
| `PchTotal` | decimal(21,5) | Nee | ((0)) | — |
| `PchTransferNextTime` | smallint | Nee | ((0)) | — |
| `PchUseFixedExchangeRate` | smallint | Nee | ((1)) | — |
| `PchVdrId` | nvarchar(6) | Ja | — | — |
| `PchWhsId` | nvarchar(10) | Ja | — | — |
| `PchFileExtension` | nvarchar(5) | Nee | — | — |
| `PCHTEXT_FT` | varbinary(max) | Ja | — | — |