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

PaymentTransaction

Type: Entity Properties: 42 Contexts: 3 Statussen: 6

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

Contextsbewerken

0: Standaard (PaymentTransactionContext.None)
1: Geïmporteerde tankbeurten (PaymentTransactionContext.Refueling)
2: Handmatig aangemaakte tankbeurten (PaymentTransactionContext.RefuelingCreatedManually)

Statussenbewerken

-1: Trash (PaymentTransactionStatus.Trash)
0: None (PaymentTransactionStatus.None)
1: Aangemaakt (PaymentTransactionStatus.Created)
2: Ongeldig (PaymentTransactionStatus.Invalid)
4: Geldig (PaymentTransactionStatus.Valid)
8: Incompleet (PaymentTransactionStatus.Incomplete)

Propertiesbewerken

Property	Type	Kolom	Width	Nullable	Default
Id	UltimoString	PYMTRID	9	false
Article	Article	PYMTRARTID		true
Context	Context	PYMTRCONTEXT		false
CostCenter	CostCenter	PYMTRCCRID		true
CreateMeasurementPointValueForQuantity	Boolean	PYMTRCREATEMSPVALUEFORQTY		false	1
Currency	Currency	PYMTRCURID		false
DataProvider	UltimoString	PYMTRDATAPROVIDER	50	true
Date	DateTime?	PYMTRDATE		true
Department	Department	PYMTRDEPID		true
Description	UltimoString	PYMTRDESCR	200	true
Discount	Decimal	PYMTRDISCOUNT		false	0
Employee	Employee	PYMTREMPID		true
Equipment	Equipment	PYMTREQMID		true
EquipmentMeasurementPointValue	EquipmentMeasurementPointValue	PYMTREQMMSPVEQMID, PYMTREQMMSPVMSPID, PYMTREQMMSPVLINEID		true	, ,
EquipmentMeasurementPointValueForQuantity	EquipmentMeasurementPointValue	PYMTREQMMSPVFQEQMID, PYMTREQMMSPVFQMSPID, PYMTREQMMSPVFQLINEID		true	, ,
Exported	Boolean	PYMTREXPORTED		false	0
ExternalId	UltimoString	PYMTREXTERNALID	50	true
ExternalStatus	UltimoString	PYMTREXTERNALSTATUS	50	true
ImportedArticleDescription	UltimoString	PYMTRIMPORTEDARTDESCR	200	true
ImportedArticleVendorPurchaseCode	UltimoString	PYMTRIMPORTEDARTVPURCHCODE	60	true
ImportedPaymentCardCode	UltimoString	PYMTRIMPORTEDPYMCCODE	40	true
InvoiceLine	InvoiceLine	PYMTRINVLINVID, PYMTRINVLLINEID		true	,
Location	UltimoString	PYMTRLOCATION	255	true
MeasurementPointValue	Decimal	PYMTRMSPVALUE		false	0
PaymentCard	PaymentCard	PYMTRPYMCID		true
PaymentTransactionRun	PaymentTransactionRun	PYMTRPYMTRRID		true
Price	TransactionMoney	PYMTRPRICE		false	0
ProcessMeasurementPointValue	Boolean	PYMTRPROCESSMSPVALUE		false	1
ProviderMutationDate	DateTime?	PYMTRPROVIDERMUTDATE		true
Quantity	Decimal	PYMTRQUANTITY		false	0
RecordCreateDate	DateTime?	PYMTRRECCREATEDATE		true	SYSDATETIME
ReplacementVehicle	Boolean	PYMTRREPLACEMENTVEHICLE		false	0
Site	Site	PYMTRSITID		true
StandardTotalPrice	TransactionMoney	PYMTRSTDTOTPRICE		false	0
StandardTotalPriceIncludingVat	TransactionMoney	PYMTRSTDTOTPRICEINCLVAT		false	0
StandardVatPrice	TransactionMoney	PYMTRSTDVATPRICE		false	0
Status	Status	PYMTRRECSTATUS		false
SystemCompany	Company	PYMTRCOMPID		false
TransactionNumber	UltimoString	PYMTRTRANSACTIONNUMBER	60	true
TransferNextTime	Boolean	PYMTRTRANSFERNEXTTIME		false	0
VatPercentage	Decimal	PYMTRVATPERCENTAGE		false	0
Vendor	Vendor	PYMTRVDRID		true

Brondatabewerken

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