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

PurchaseAdviceLine

Type: Entity Properties: 37 Contexts: 1 Statussen: 2

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

Property	Type	Kolom	Width	Nullable	Default
Id.Article	Article	PADLARTID		false
Id.PurchaseAdvice	PurchaseAdvice	PADLPADID		false
ArticleVendorPurchaseCode	UltimoString	PADLARTVPURCHCODE	60	true
Concept	Boolean	PADLCONCEPT		false	0
Context	Context	PADLCONTEXT		false
CostCenter	CostCenter	PADLCCRID		true
Currency	Currency	PADLCURID		false
DeliveryDate	DateTime?	PADLDLVDATE		true
Department	Department	PADLDEPID		true
Discount	Decimal	PADLDISCOUNT		false
Exported	Boolean	PADLEXPORTED		false
Extra1	Int16	PADLEXTRA1		false
Extra2	Int16	PADLEXTRA2		false
Extra3	Int32	PADLEXTRA3		false
Extra4	Int32	PADLEXTRA4		false
Extra5	UltimoString	PADLEXTRA5	15	true
Extra6	UltimoString	PADLEXTRA6	15	true
Extra7	UltimoString	PADLEXTRA7	15	true
GrossPrice	TransactionMoney	PADLGROSSPRICE		false	0
GrossTotalPrice	TransactionMoney	PADLGROSSTOTPRICE		false	0
LeadTime	Int32	PADLLEADTIME		false
Price	TransactionMoney	PADLPRICE		false	0
Purchase	Boolean	PADLPURCHASE		false
PurchaseQuantity	Decimal	PADLPURCHQTY		false
QuantityPurchaseUnit	Decimal	PADLQTYPURCHUNT		false	1
RecordCreateDate	DateTime?	PADLRECCREATEDATE		true	SYSDATETIME
Site	Site	PADLSITID		true
Status	Status	PADLRECSTATUS		false
SystemCompany	Company	PADLCOMPID		false
TotalPrice	TransactionMoney	PADLTOTPRICE		false	0
TotalPriceIncludingVat	TransactionMoney	PADLTOTPRICEINCLVAT		false	0
UnitDescription	UltimoString	PADLUNTDESCR	9	true
Vat	Vat	PADLVATID		true
VatPercentage	Decimal	PADLVATPERCENTAGE		false
VatPrice	TransactionMoney	PADLVATPRICE		false	0
Vendor	Vendor	PADLVDRID		true
Warehouse	Warehouse	PADLWHSID		true

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