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

Cost

Type: Entity Properties: 50 Contexts: 9 Statussen: 5

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

Contextsbewerken

0: Standaard (CostContext.None)
1: Bestelling (CostContext.ActivePurchase)
2: Inkoopfactuur (CostContext.Invoice)
4: Magazijnmutatie (CostContext.WarehouseMutation)
8: Diversen (CostContext.JobExternal)
16: Credit inkoopfactuur (CostContext.CreditInvoice)
32: Gereedschap (CostContext.JobTool)
64: Memoriaal (CostContext.MemorandumBook)
128: Uren (CostContext.Hour)

Statussenbewerken

-1: Trash (CostStatus.Trash)
0: None (CostStatus.None)
1: Aangemaakt (CostStatus.Created)
2: Actief (CostStatus.Active)
4: Vervallen (CostStatus.Expired)

Propertiesbewerken

Property	Type	Kolom	Width	Nullable	Default
Id	UltimoString	CSTID	36	false
Account	Account	CSTACCID		true
BookDate	Date?	CSTBOOKDATE		true
BudgetPeriod	BudgetPeriod	CSTBDGPID		true
BudgetPeriodForCostType	BudgetPeriod	CSTBDGPIDFORCSTT		true
CalculatedCost	CompanyMoney	CSTCALCULATEDCOST		false	0
Context	Context	CSTCONTEXT		false
CostCenter	CostCenter	CSTCCRID		true
CostType	CostType	CSTCSTTID		true
Customer	Customer	CSTCUSID		true
DataProvider	UltimoString	CSTDATAPROVIDER	50	true
Date	Date?	CSTDATE		true
Department	Department	CSTDEPID		true
Equipment	Equipment	CSTEQMID		true
Exported	Boolean	CSTEXPORTED		false
ExternalCost	CompanyMoney	CSTEXTCOST		false	0
ExternalId	UltimoString	CSTEXTERNALID	50	true
ExternalStatus	UltimoString	CSTEXTERNALSTATUS	50	true
Hours	Decimal	CSTHOURS		false
InvoiceCost	CompanyMoney	CSTINVCOST		false	0
InvoiceLine	InvoiceLine	CSTINVID, CSTINVLLINEID		true	,
Job	Job	CSTJOBID		true
JobExternal	JobExternal	CSTJOBEJOBID, CSTJOBELINEID		true	,
JobTool	JobTool	CSTJOBTJOBID, CSTJOBTLINEID		true	,
JobWeekLabour	JobWeekLabour	CSTJOBWLJOBID, CSTJOBWLWEEK, CSTJOBWLLINEID		true	, ,
LabourCost	CompanyMoney	CSTLABCOST		false	0
MemorandumBookLine	MemorandumBookLine	CSTMEMBID, CSTMEMBLLINEID		true	,
MemorandumCost	CompanyMoney	CSTMEMORANDUMCOST		false	0
ProcessFunction	ProcessFunction	CSTPRFID		true
Project	Project	CSTPRJID		true
ProviderMutationDate	DateTime?	CSTPROVIDERMUTDATE		true
PurchaseCost	CompanyMoney	CSTPURCHCOST		false	0
PurchaseLine	PurchaseLine	CSTPCHID, CSTPCHLID		true	,
RecordChangeDate	DateTime?	CSTRECCHANGEDATE		true
RecordCreateDate	DateTime?	CSTRECCREATEDATE		true	SYSDATETIME
ServiceContract	ServiceContract	CSTSVCID		true
Site	Site	CSTSITID		true
SkillCategory	SkillCategory	CSTSKCID		true
Status	Status	CSTRECSTATUS		false	1
StatusActiveDate	DateTime?	CSTACTIVEDATE		true
StatusActiveEmployee	Employee	CSTACTIVEEMPID		true
StatusCreatedDate	DateTime?	CSTCREATEDDATE		true	SYSDATETIME
StatusCreatedEmployee	Employee	CSTCREATEDEMPID		true	USERID
StatusExpiredDate	DateTime?	CSTEXPIREDDATE		true
StatusExpiredEmployee	Employee	CSTEXPIREDEMPID		true
SystemCompany	Company	CSTCOMPID		false
ToolsCost	CompanyMoney	CSTTLSCOST		false	0
TransferNextTime	Boolean	CSTTRANSFERNEXTTIME		false	0
WarehouseServeOut	WarehouseServeOut	CSTWHSOID		true
WarehouseServeOutCost	CompanyMoney	CSTWHSOCOST		false	0

Brondatabewerken

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