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

PurchaseRequestLine

Type: Entity Properties: 107 Contexts: 2 Statussen: 18

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

Contextsbewerken

Statussenbewerken

Propertiesbewerken

Property Type Kolom Width Nullable Default
Id UltimoString PCHRLID 8 false
_PurchaseRequestLines List[ObjectDocument] _OBJDOCPCHRLID true
Account Account PCHRLACCID true
Article Article PCHRLARTID true
ArticleVendorPurchaseCode UltimoString PCHRLARTVDRPURCHCODE 60 true
AttachedToTender Boolean PCHRLTENDER false 0
BookCostOnServiceContract Boolean PCHRLBOOKCOSTONSVC false 0
BookDate Date? PCHRLBOOKDATE true
CalculatedArticlePreparationQuantity Decimal PCHRLCALCARTPREPQUANTITY false
CalculateDeliveryDateMethod Int16 PCHRLCALCDLVDATEMETHOD false
CalculateRequestedDeliveryDate Boolean PCHRLCALCULATEREQDLVDATE false 0
Charge Boolean PCHRLCHARGE false 0
ChargeRaise Raise PCHRLCHARGERSEID true
ChargeRaisePercentage Decimal PCHRLCHARGERAISEPERC false 0
Concept Boolean PCHRLCONCEPT false 0
Context Context PCHRLCONTEXT false 1
CostCenter CostCenter PCHRLCCRID true
CostType CostType PCHRLCSTTID true
CreatedForStop Boolean PCHRLCREATEDFORSTOP false 0
CreatedFromAdvice Boolean PCHRLCREATEDFROMADVICE false 0
Currency Currency PCHRLCURID false
CurrencyConversionFactor Int16 PCHRLCURCONVFACTOR false
CurrencyRate Decimal PCHRLCURRATE false
Customer Customer PCHRLCUSID true
DataProvider UltimoString PCHRLDATAPROVIDER 50 true
DeliveredQuantity Decimal PCHRLDELIVEREDQUANTITY false
DeliveryDaysBeforeStartJob Int16 PCHRLDLVDAYSBEFSTARTJOB false
Department Department PCHRLDEPID true
Description UltimoString PCHRLDESCR 200 true
Discount Decimal PCHRLDISCOUNT false
Equipment Equipment PCHRLEQMID true
Exported Boolean PCHRLEXPORTED false
ExternalId UltimoString PCHRLEXTERNALID 50 true
ExternalStatus UltimoString PCHRLEXTERNALSTATUS 50 true
GrossPrice TransactionMoney PCHRLGROSSPRICE false 0
GrossTotalPrice TransactionMoney PCHRLGROSSTOTPRICE false 0
InternalChargeLine InternalChargeLine PCHRLINVOID, PCHRLINVOLLINEID true ,
InvoiceCost CompanyMoney PCHRLINVCOST false 0
InvoiceQuantity Decimal PCHRLINVQTY false 0
Job Job PCHRLJOBID true
JobJobPlan JobJobPlan PCHRLJOBJPLID true
JobPlan JobPlan PCHRLJPID true
JobSelected Boolean PCHRLJOBSELECTED false 0
LeadTime Int32 PCHRLLEADTIME false
OriginalStatus Int32 PCHRLORGRECSTATUS false 0
PickedQuantity Decimal PCHRLPICKEDQUANTITY false
PickListLines List[PickListLine] PLTLPCHRLID true
PrePurchaseCreatedStatus Status PCHRLPREPURCHCREATEDSTATUS false 0
Price TransactionMoney PCHRLPRICE false 0
ProcessFunction ProcessFunction PCHRLPRFID true
Project Project PCHRLPRJID true
ProviderMutationDate DateTime? PCHRLPROVIDERMUTDATE true
Purchase Boolean PCHRLPURCHASE false 0
PurchaseAdvice PurchaseAdvice PCHRLPADID true
PurchaseLine PurchaseLine PCHRLPCHID, PCHRLPCHLID true ,
PurchaseQuantity Decimal PCHRLPURCHQTY false 1
PurchaseRequest PurchaseRequest PCHRLPCHRID true
QuantityPurchaseUnit Decimal PCHRLQTYPURCHUNT false 1
RecordChangeDate DateTime? PCHRLRECCHANGEDATE true
RecordCreateDate DateTime? PCHRLRECCREATEDATE true SYSDATETIME
Repair Boolean PCHRLREPAIR false 0
RequestedDeliveryDate Date? PCHRLREQUESTEDDLVDATE true
RequestEmployee Employee PCHRLREQUESTEMPID true USERID
ReservedQuantity Decimal PCHRLRESERVEDQUANTITY false
Selected Boolean PCHRLSELECTED false 0
ServiceContractLine ServiceContractLine PCHRLSVCID, PCHRLSVCLLINEID true ,
Site Site PCHRLSITID true
SkillCategory SkillCategory PCHRLSKCID true
StandardTotalPrice CompanyMoney PCHRLSTDTOTPRICE false 0
StandardTotalPriceIncludingVat CompanyMoney PCHRLSTDTOTPRICEINCLVAT false 0
StandardVatPrice CompanyMoney PCHRLSTDVATPRICE false 0
Status Status PCHRLRECSTATUS false
StatusApprovedDate DateTime? PCHRLAPPRVDATE true
StatusApprovedEmployee Employee PCHRLAPPRVEMPID true
StatusClosedDate DateTime? PCHRLCLOSEDDATE true
StatusClosedEmployee Employee PCHRLCLOSEDEMPID true
StatusConceptDate DateTime? PCHRLCONCEPTDATE true
StatusConceptEmployee Employee PCHRLCONCEPTEMPID true
StatusCreatedDate DateTime? PCHRLCREATDATE true SYSDATETIME
StatusCreatedEmployee Employee PCHRLCREATEMPID true USERID
StatusDeliveredDate DateTime? PCHRLDELIVEREDDATE true
StatusDeliveredEmployee Employee PCHRLDELIVEREDEMPID true
StatusPartiallyDeliveredDate DateTime? PCHRLPARTDELIVEREDDATE true
StatusPartiallyDeliveredEmployee Employee PCHRLPARTDELIVEREDEMPID true
StatusRejectedDate DateTime? PCHRLREJECTDATE true
StatusRejectedEmployee Employee PCHRLREJECTEMPID true
StatusRequestedDate DateTime? PCHRLREQUESTEDDATE true SYSDATETIME
StatusRequestedEmployee Employee PCHRLREQUESTEDEMPID true USERID
StatusReservedDate DateTime? PCHRLRESERVEDDATE true
StatusReservedEmployee Employee PCHRLRESERVEDEMPID true
StatusTenderDate DateTime? PCHRLTENDERDATE true
StatusTenderEmployee Employee PCHRLTENDEREMPID true
StockArticle Boolean PCHRLSTOCKART false 0
SystemCompany Company PCHRLCOMPID false
Tender PurchaseRequest PCHRLTENDERPCHRID true
TenderRequest RequestForQuotation PCHRLRFQID true
Text UltimoString PCHRLTEXT true
ToDeliverQuantity Decimal PCHRLTODELIVERQUANTITY false
TotalPrice TransactionMoney PCHRLTOTPRICE false 0
TotalPriceIncludingVat TransactionMoney PCHRLTOTPRICEINCLVAT false 0
TransferNextTime Boolean PCHRLTRANSFERNEXTTIME false
UnitDescription UltimoString PCHRLUNTDESCR 9 true
Vat Vat PCHRLVATID true
VatPercentage Decimal PCHRLVATPERCENTAGE false
VatPrice TransactionMoney PCHRLVATPRICE false 0
Vendor Vendor PCHRLVDRID true
Warehouse Warehouse PCHRLWHSID true

Brondatabewerken