Bewerken: PaymentTransaction

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `PymtrId` | nvarchar(9) | Nee | — | — |
| `PymtrDescr` | nvarchar(200) | Ja | — | — |
| `PymtrContext` | bigint | Nee | ((0)) | — |
| `PymtrRecStatus` | int | Nee | ((0)) | — |
| `PymtrArtId` | nvarchar(9) | Ja | — | — |
| `PymtrCcrId` | nvarchar(9) | Ja | — | — |
| `PymtrCompId` | nvarchar(6) | Nee | — | — |
| `PymtrCreateMspValueForQty` | smallint | Nee | ((1)) | — |
| `PymtrCurId` | nvarchar(5) | Nee | — | — |
| `PymtrDataProvider` | nvarchar(50) | Ja | — | — |
| `PymtrDate` | datetimeoffset(7) | Ja | — | — |
| `PymtrDepId` | nvarchar(11) | Ja | — | — |
| `PymtrDiscount` | decimal(21,2) | Nee | ((0)) | — |
| `PymtrEmpId` | nvarchar(9) | Ja | — | — |
| `PymtrEqmId` | nvarchar(24) | Ja | — | — |
| `PymtrEqmmspvEqmId` | nvarchar(24) | Ja | — | — |
| `PymtrEqmmspvfqEqmId` | nvarchar(24) | Ja | — | — |
| `PymtrEqmmspvfqLineId` | nvarchar(14) | Ja | — | — |
| `PymtrEqmmspvfqMspId` | nvarchar(70) | Ja | — | — |
| `PymtrEqmmspvLineId` | nvarchar(14) | Ja | — | — |
| `PymtrEqmmspvMspId` | nvarchar(70) | Ja | — | — |
| `PymtrExported` | smallint | Nee | ((0)) | — |
| `PymtrExternalId` | nvarchar(50) | Ja | — | — |
| `PymtrExternalStatus` | nvarchar(50) | Ja | — | — |
| `PymtrImportedArtDescr` | nvarchar(200) | Ja | — | — |
| `PymtrImportedArtvPurchCode` | nvarchar(60) | Ja | — | — |
| `PymtrImportedPymcCode` | nvarchar(40) | Ja | — | — |
| `PymtrInvlInvId` | nvarchar(9) | Ja | — | — |
| `PymtrInvlLineId` | nvarchar(4) | Ja | — | — |
| `PymtrLocation` | nvarchar(255) | Ja | — | — |
| `PymtrMspValue` | decimal(21,0) | Nee | ((0)) | — |
| `PymtrPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PymtrProcessMspValue` | smallint | Nee | ((1)) | — |
| `PymtrProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `PymtrPymcId` | nvarchar(6) | Ja | — | — |
| `PymtrPymtrrId` | nvarchar(6) | Ja | — | — |
| `PymtrQuantity` | decimal(21,2) | Nee | ((0)) | — |
| `PymtrRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `PymtrReplacementVehicle` | smallint | Nee | ((0)) | — |
| `PymtrSitId` | nvarchar(8) | Ja | — | — |
| `PymtrStdTotPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PymtrStdTotPriceInclVat` | decimal(21,5) | Nee | ((0)) | — |
| `PymtrStdVatPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PymtrTransactionNumber` | nvarchar(60) | Ja | — | — |
| `PymtrTransferNextTime` | smallint | Nee | ((0)) | — |
| `PymtrVatPercentage` | decimal(21,2) | Nee | ((0)) | — |
| `PymtrVdrId` | nvarchar(6) | Ja | — | — |