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

PurchaseLine

Type: Entity Properties: 88 Contexts: 2 Statussen: 13

Zie ook het handgeschreven artikel: purchase-line

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

Contextsbewerken

0: Standaard (PurchaseLineContext.None)
1: Inkoop (PurchaseLineContext.Purchase)

Statussenbewerken

-1: Trash (PurchaseLineStatus.Trash)
0: None (PurchaseLineStatus.None)
1: Open (PurchaseLineStatus.Created)
2: Goedgekeurd (PurchaseLineStatus.Approved)
4: Actief (PurchaseLineStatus.Active)
8: Ontvangstregel (PurchaseLineStatus.AddedReceiptLine)
16: Factuurregel (PurchaseLineStatus.AddedInvoiceLine)
32: Gesloten (PurchaseLineStatus.Closed)
64: Deels ontvangen (PurchaseLineStatus.PartReceived)
128: Concept (PurchaseLineStatus.Conceptual)
256: Ontvangen (PurchaseLineStatus.Received)
1024: Vervallen (PurchaseLineStatus.Canceled)
2048: Aanvraag (PurchaseLineStatus.Requested)

Propertiesbewerken

Property	Type	Kolom	Width	Nullable	Default
Id.LineId	UltimoString	PCHLLINEID	4	false
Id.Purchase	Purchase	PCHLPCHID		false
Account	Account	PCHLACCID		true
Article	Article	PCHLARTID		true
ArticleVendorPurchaseCode	UltimoString	PCHLARTVDRPURCHCODE	60	true
ArticleWarehouseLocation	ArticleWarehouseLocation	PCHLARTWHSLARTID, PCHLARTWHSLWHSLWHSID, PCHLARTWHSLWHSLCODE		true	, ,
BookCostOnServiceContract	Boolean	PCHLBOOKCOSTONSVC		false	0
CalculatedArticlePreparationQuantity	Decimal	PCHLCALCARTPREPQUANTITY		false
CalculatedArticlePurchaseQuantity	Decimal	PCHLCALCARTPURCHQUANTITY		false
CalculatedArticleRepairQuantity	Decimal	PCHLCALCARTREPQUANTITY		false
CalculateDeliveryDate	Boolean	PCHLCALCULATEDLVDATE		false
Call	UltimoString	PCHLCALL	2	true
Charge	Boolean	PCHLCHARGE		false	0
ChargeRaise	Raise	PCHLCHARGERSEID		true
Concept	Int16	PCHLCONCEPT		false
Context	Context	PCHLCONTEXT		false
CostCenter	CostCenter	PCHLCCRID		true
Costs	List[Cost]	CSTPCHID, CSTPCHLID		true	,
CostType	CostType	PCHLCSTTID		true
Currency	Currency	PCHLCURID		false
Customer	Customer	PCHLCUSID		true
DataProvider	UltimoString	PCHLDATAPROVIDER	50	true
DeliveryDate	Date?	PCHLDLVDATE		true
Department	Department	PCHLDEPID		true
Description	UltimoString	PCHLDESCR	200	true
Discount	Decimal	PCHLDISCOUNT		false
Equipment	Equipment	PCHLEQMID		true
Exported	Boolean	PCHLEXPORTED		false
ExternalId	UltimoString	PCHLEXTERNALID	50	true
ExternalStatus	UltimoString	PCHLEXTERNALSTATUS	50	true
Extra1	Int16	PCHLEXTRA1		false
Extra2	Int16	PCHLEXTRA2		false
Extra3	Int32	PCHLEXTRA3		false
Extra4	Int32	PCHLEXTRA4		false
Extra5	UltimoString	PCHLEXTRA5	15	true
Extra6	UltimoString	PCHLEXTRA6	15	true
Extra7	UltimoString	PCHLEXTRA7	15	true
GrossPrice	TransactionMoney	PCHLGROSSPRICE		false	0
GrossTotalPrice	TransactionMoney	PCHLGROSSTOTPRICE		false	0
InputToReceiveQuantity	Decimal	PCHLINPTORCVQTY		false
InvoiceLine	InvoiceLine	PCHLINVID, PCHLINVLLINEID		true	,
InvoiceLines	List[InvoiceLine]	INVLPCHID, INVLPCHLID		true	,
InvoicePrice	CompanyMoney	PCHLINVPRICE		false	0
InvoiceQuantity	Decimal	PCHLINVQTY		false
Job	Job	PCHLJOBID		true
LeadTime	Int32	PCHLLEADTIME		false
Price	TransactionMoney	PCHLPRICE		false	0
ProcessFunction	ProcessFunction	PCHLPRFID		true
Project	Project	PCHLPRJID		true
ProviderMutationDate	DateTime?	PCHLPROVIDERMUTDATE		true
PurchaseQuantity	Decimal	PCHLPURCHQTY		false	1
PurchaseRequestLines	List[PurchaseRequestLine]	PCHRLPCHID, PCHRLPCHLID		true	,
QuantityPurchaseUnit	Decimal	PCHLQTYPURCHUNT		false	1
ReceiptLine	ReceiptLine	PCHLRCPID, PCHLRCPLLINEID		true	,
ReceivedQuantity	Decimal	PCHLRCVQTY		false
RecordChangeDate	DateTime?	PCHLRECCHANGEDATE		true
RecordCreateDate	DateTime?	PCHLRECCREATEDATE		true	SYSDATETIME
RemainingCommitExcludingVat	CompanyMoney	PCHLREMAININGCOMMITEXCLVAT		false	0
RemainingCommitIncludingVat	CompanyMoney	PCHLREMAININGCOMMITINCLVAT		false	0
Repair	Boolean	PCHLREPAIR		false	0
Return	Decimal	PCHLRETOUR		false
ReturnToReceiveQuantity	Decimal	PCHLRETTORCVQTY		false
ServiceContractLine	ServiceContractLine	PCHLSVCID, PCHLSVCLLINEID		true	,
Site	Site	PCHLSITID		true
SkillCategory	SkillCategory	PCHLSKCID		true
StandardTotalCreditInvoicePrice	CompanyMoney	PCHLSTDTOTCREDINVPRICE		false	0
StandardTotalCreditInvoicePriceIncludingVat	CompanyMoney	PCHLSTDTOTCRDINVPRINCLVAT		false	0
StandardTotalCreditInvoiceQuantity	Decimal	PCHLSTDTOTCREDINVQTY		false
StandardTotalInvoicePrice	CompanyMoney	PCHLSTDTOTINVPRICE		false	0
StandardTotalInvoicePriceIncludingVat	CompanyMoney	PCHLSTDTOTINVPRICEINCLVAT		false	0
StandardTotalPrice	CompanyMoney	PCHLSTDTOTPRICE		false	0
StandardTotalPriceIncludingVat	CompanyMoney	PCHLSTDTOTPRICEINCLVAT		false	0
StandardVatPrice	CompanyMoney	PCHLSTDVATPRICE		false	0
Status	Status	PCHLRECSTATUS		false
StockArticle	Boolean	PCHLSTOCKART		false	0
SystemCompany	Company	PCHLCOMPID		false
Text	UltimoString	PCHLTEXT		true
Tool	UltimoString	PCHLTLS	2	true
ToReceiveQuantity	Decimal	PCHLTORCVQTY		false
TotalPrice	TransactionMoney	PCHLTOTPRICE		false	0
TotalPriceIncludingVat	TransactionMoney	PCHLTOTPRICEINCLVAT		false	0
TransferNextTime	Boolean	PCHLTRANSFERNEXTTIME		false
UnitDescription	UltimoString	PCHLUNTDESCR	9	true
Vat	Vat	PCHLVATID		true
VatPercentage	Decimal	PCHLVATPERCENTAGE		false
VatPrice	TransactionMoney	PCHLVATPRICE		false	0
Vendor	Vendor	PCHLVDRID		true
Warehouse	Warehouse	PCHLWHSID		true

Brondatabewerken

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