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

Purchase

Type: Entity Properties: 72 Contexts: 2 Statussen: 11

Zie ook het handgeschreven artikel: purchase

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

Contextsbewerken

Statussenbewerken

Propertiesbewerken

Property Type Kolom Width Nullable Default
Id UltimoString PCHID 9 false
Account Account PCHACCID true
AdviceDate DateTime? PCHADVICEDATE true
AdviceEmployee Employee PCHADVICEEMPID true
BookDate Date? PCHBOOKDATE true
Comment1 UltimoString PCHCMNT1 41 true
Comment2 UltimoString PCHCMNT2 41 true
Contact Employee PCHCONTACTEMPID true
Context Context PCHCONTEXT false 1
CostCenter CostCenter PCHCCRID true
Currency Currency PCHCURID false
CurrencyConversionFactor Int16 PCHCURCONVFACTOR false
CurrencyRate Decimal PCHCURRATE false
DataProvider UltimoString PCHDATAPROVIDER 50 true
DeliveryAddress DeliveryAddress PCHDLVAID true A
DeliveryDate Date? PCHDLVDATE true
DeliveryTerms DeliveryTerms PCHDLVTID true
Department Department PCHDEPID true
Description UltimoString PCHDESCR 200 true
Exported Boolean PCHEXPORTED false
ExternalId UltimoString PCHEXTERNALID 50 true
ExternalStatus UltimoString PCHEXTERNALSTATUS 50 true
Extra1 Int16 PCHEXTRA1 false
Extra2 Int16 PCHEXTRA2 false
Extra3 Int32 PCHEXTRA3 false
Extra4 Int32 PCHEXTRA4 false
Extra5 UltimoString PCHEXTRA5 15 true
Extra6 UltimoString PCHEXTRA6 15 true
Extra7 UltimoString PCHEXTRA7 15 true
InvoiceLines List[InvoiceLine] INVLPCHID true
Job Job PCHJOBID true
Language Language PCHLNGID true
NowInvoice CompanyMoney PCHNOWINV false 0
NowInvoiceIncludingVat CompanyMoney PCHNOWINVINCLVAT false 0
NumberOfLines Int32 PCHNUMBEROFLINES false 0
PaymentTerms PaymentTerms PCHPYMTID true
ProviderMutationDate DateTime? PCHPROVIDERMUTDATE true
PurchaseLines List[PurchaseLine] PCHLPCHID false
PurchaseMethod PurchaseMethod PCHPCHMID true S
Receipts List[Receipt] RCPPCHID true
RecordChangeDate DateTime? PCHRECCHANGEDATE true
RecordCreateDate DateTime? PCHRECCREATEDATE true SYSDATETIME
Reference UltimoString PCHREFERENCE 41 true
RequestEmployee Employee PCHREQUESTEMPID true
Site Site PCHSITID true
StandardTotalPriceIncludingVat CompanyMoney PCHSTDTOTPRICEINCLVAT false 0
StandardVatPrice CompanyMoney PCHSTDVATPRICE false 0
Status Status PCHRECSTATUS false
StatusActiveDate DateTime? PCHDATE true
StatusActiveEmployee Employee PCHEMPID true
StatusApprovedDate DateTime? PCHAPPRVDATE true
StatusApprovedEmployee Employee PCHAPPRVEMPID true
StatusCanceledDate DateTime? PCHCANCELDATE true
StatusCanceledEmployee Employee PCHCANCELEMPID true
StatusClosedDate DateTime? PCHCLOSEDATE true
StatusClosedEmployee Employee PCHCLOSEEMPID true
StatusConceptualDate DateTime? PCHCONCEPTDATE true
StatusConceptualEmployee Employee PCHCONCEPTEMPID true
StatusCreatedDate DateTime? PCHCREATEDDATE true SYSDATETIME
StatusCreatedEmployee Employee PCHCREATEDEMPID true USERID
StatusPartialReceivedDate DateTime? PCHPARTRECEIVEDDATE true
StatusPartialReceivedEmployee Employee PCHPARTRECEIVEDEMPID true
StatusReceivedDate DateTime? PCHRECEIVEDDATE true
StatusReceivedEmployee Employee PCHRECEIVEDEMPID true
SystemCompany Company PCHCOMPID false
TenderRequest RequestForQuotation PCHRFQID true
Text UltimoString PCHTEXT true
Total CompanyMoney PCHTOTAL false 0
TransferNextTime Boolean PCHTRANSFERNEXTTIME false
UseFixedExchangeRate Boolean PCHUSEFIXEDEXCHANGERATE false 1
Vendor Vendor PCHVDRID true
Warehouse Warehouse PCHWHSID true

Brondatabewerken