title: "Purchase (table)" category: reference tags: [table, purchase, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.Purchase
Schema: dba
Aantal kolommen: 70
Zie ook de entity-pagina: ../entities/Purchase
Kolommenbewerken
| 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 | — | — |
Computed columnsbewerken
PchFileExtension—(N'.html')PCHTEXT_FT—(case when [PCHTEXT] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([PCHTEXT],(5))=N'<html' then [PCHTEXT] else N'<html lang="nl">'+[PCHTEXT] end) end)
Trigger-gevulde kolommenbewerken
PchDlvDate← TRGD_PurchaseLine, TRGI_PurchaseLine, TRGU_PurchaseLinePchNowInv← TRSD_INVOICELINE, TRSM_INVOICELINEPchNowInvInclVat← TRSD_INVOICELINE, TRSM_INVOICELINEPchNumberOfLines← TRSD_PURCHASELINE, TRSM_PURCHASELINEPchStdTotPriceInclVat← TRSD_PURCHASELINE, TRSM_PURCHASELINEPchStdVatPrice← TRSD_PURCHASELINE, TRSM_PURCHASELINEPchTotal← TRSD_PURCHASELINE, TRSM_PURCHASELINE
Brondatabewerken
- DB-schema —
lookup_table_schema("Purchase")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("Purchase")· ../entities/Purchase Properties, contexts, statussen. Bron:Entities.xml.