title: "PurchaseRequest" category: reference tags: [entity, purchase-request, datamodel] source: Entities.xml date: 2026-04-17 status: published

PurchaseRequest

Type: Entity Properties: 52 Contexts: 4 Statussen: 13

Zie ook het handgeschreven artikel: purchase-request

DB-schema: lookup_table_schema("PurchaseRequest") · ../tables/PurchaseRequest

Contextsbewerken

0: Bestelaanvraag (PurchaseRequestContext.None)
1: Bestelaanvraag (PurchaseRequestContext.Standard)
2: Offertetraject (PurchaseRequestContext.Tender)
4: Bestelaanvraag (PurchaseRequestContext.OrderRequest)

Statussenbewerken

-1: Trash (PurchaseRequestStatus.Trash)
0: None (PurchaseRequestStatus.None)
1: Aangemaakt (PurchaseRequestStatus.Created)
2: Aanvraag (PurchaseRequestStatus.Requested)
4: Concept (PurchaseRequestStatus.Concept)
8: Goedgekeurd (PurchaseRequestStatus.Approved)
16: Bestelling aangemaakt (PurchaseRequestStatus.PurchaseCreated)
32: Afgewezen (PurchaseRequestStatus.Rejected)
64: Actief (PurchaseRequestStatus.Active)
128: Gesloten (PurchaseRequestStatus.Closed)
256: Deels geleverd (PurchaseRequestStatus.PartiallyDelivered)
512: Geleverd (PurchaseRequestStatus.Delivered)
2048: Besteladvies (PurchaseRequestStatus.PurchaseAdvice)

Propertiesbewerken

Property	Type	Kolom	Width	Nullable	Default
Id	UltimoString	PCHRID	11	false
Account	Account	PCHRACCID		true
Charge	Boolean	PCHRCHARGE		false	0
Context	Context	PCHRCONTEXT		false	1
CostCenter	CostCenter	PCHRCCRID		true
CostType	CostType	PCHRCSTTID		true
CreatedFromJob	Boolean	PCHRCREATEDFROMJOB		false	0
Currency	Currency	PCHRCURID		false
DataProvider	UltimoString	PCHRDATAPROVIDER	50	true
Date	Date?	PCHRDATE		true	SYSDATE
Department	Department	PCHRDEPID		true
Description	UltimoString	PCHRDESCR	200	true
EmailSubjects	List[EmailSubject]	EMLSPCHRID		true
Exported	Boolean	PCHREXPORTED		false
ExternalId	UltimoString	PCHREXTERNALID	50	true
ExternalStatus	UltimoString	PCHREXTERNALSTATUS	50	true
FinalReplyDate	DateTime?	PCHRFINALREPLYDATE		true
Job	Job	PCHRJOBID		true
Lines	List[PurchaseRequestLine]	PCHRLPCHRID		true
ProviderMutationDate	DateTime?	PCHRPROVIDERMUTDATE		true
RecordChangeDate	DateTime?	PCHRRECCHANGEDATE		true
RecordCreateDate	DateTime?	PCHRRECCREATEDATE		true	SYSDATETIME
RequestedDeliveryDate	Date?	PCHRREQUESTEDDLVDATE		true
RequestedDeliverySpace	Space	PCHRREQUESTEDDLVSPCID		true
RequestEmployee	Employee	PCHRREQUESTEMPID		true	USERID
Site	Site	PCHRSITID		true
StandardTotalPrice	CompanyMoney	PCHRSTDTOTALPRICE		false	0
StandardTotalPriceIncludingVat	CompanyMoney	PCHRSTDTOTPRICEINCLVAT		false	0
StandardVatPrice	CompanyMoney	PCHRSTDVATPRICE		false	0
Status	Status	PCHRRECSTATUS		false
StatusActiveDate	DateTime?	PCHRACTIVEDATE		true
StatusActiveEmployee	Employee	PCHRACTIVEEMPID		true
StatusApprovedDate	DateTime?	PCHRAPPROVEDDATE		true
StatusApprovedEmployee	Employee	PCHRAPPROVEDEMPID		true
StatusClosedDate	DateTime?	PCHRCLOSEDDATE		true
StatusClosedEmployee	Employee	PCHRCLOSEDEMPID		true
StatusConceptDate	DateTime?	PCHRCONCEPTDATE		true
StatusConceptEmployee	Employee	PCHRCONCEPTEMPID		true
StatusCreatedDate	DateTime?	PCHRCREATEDDATE		true	SYSDATETIME
StatusCreatedEmployee	Employee	PCHRCREATEDEMPID		true	USERID
StatusDeliveredDate	DateTime?	PCHRDELIVEREDDATE		true
StatusDeliveredEmployee	Employee	PCHRDELIVEREDEMPID		true
StatusPartiallyDeliveredDate	DateTime?	PCHRPARTDELIVEREDDATE		true
StatusPartiallyDeliveredEmployee	Employee	PCHRPARTDELIVEREDEMPID		true
StatusRejectedDate	DateTime?	PCHRREJECTEDDATE		true
StatusRejectedEmployee	Employee	PCHRREJECTEDEMPID		true
StatusRequestedDate	DateTime?	PCHRREQUESTEDDATE		true	SYSDATETIME
StatusRequestedEmployee	Employee	PCHRREQUESTEDEMPID		true	USERID
SystemCompany	Company	PCHRCOMPID		false
Text	UltimoString	PCHRTEXT		true
TotalPrice	TransactionMoney	PCHRTOTPRICE		false	0
TransferNextTime	Boolean	PCHRTRANSFERNEXTTIME		false	0

Brondatabewerken

Entity-definitie — lookup_entity("PurchaseRequest") Model-perspectief (properties, contexts, statussen). Bron: Entities.xml.
DB-schema — lookup_table_schema("PurchaseRequest") · ../tables/PurchaseRequest DB-perspectief (triggers, computed, defaults). Bron: database-schema.json.
Workflows — find_workflows("", entity="PurchaseRequest") Before/After Save events voor PurchaseRequest. Bron: workflows.xml.