-
_db_id
int
-
acceptheader
The 'Accept' header of the customer's web browser.
string
-
acceptlanguageheader
The 'Accept Language' header of the customer's web browser.
string
-
authorizationamount
The sum of all line item prices including taxes in the transaction's currency.
decimal(19,8)
-
authorizationenvironment
The environment in which the transaction was authorized.
string
-
authorizationsaleschannel
The sales channel through which the transaction was placed.
bigint
-
authorizationtimeouton
The date and time when the transaction must be authorized, otherwise it will canceled.
timestamp
-
authorizedon
The date and time when the transaction was authorized.
timestamp
-
autoconfirmationenabled
Whether the transaction can be confirmed automatically or whether this must be done explicitly via the API. Default is true.
boolean
-
billingaddresscity
string
-
billingaddresscommercialregisternumber
string
-
billingaddresscountry
string
-
billingaddressdateofbirth
string
-
billingaddressdependentlocality
string
-
billingaddressemailaddress
string
-
billingaddressfamilyname
string
-
billingaddressgender
string
-
billingaddressgivenname
string
-
billingaddressmobilephonenumber
string
-
billingaddressorganizationform
bigint
-
billingaddressorganizationname
string
-
billingaddressphonenumber
string
-
billingaddresspostalstate
string
-
billingaddresspostcode
string
-
billingaddresssalestaxnumber
string
-
billingaddresssalutation
string
-
billingaddresssocialsecuritynumber
string
-
billingaddresssortingcode
string
-
billingaddressstreet
string
-
chargeretryenabled
Whether the customer can make further payment attempts if the first one has failed. Default is true.
boolean
-
completedamount
The total amount that was completed, in the transaction's currency.
decimal(19,8)
-
completedon
The date and time when the transaction was completed.
timestamp
-
completionbehavior
The behavior that controls when the transaction is completed.
string
-
completionretries
int
-
completiontimeouton
The date and time when the transaction is completed automatically.
timestamp
-
confirmedby
The ID of the user the transaction was confirmed by.
bigint
-
confirmedon
The date and time when the transaction was created.
timestamp
-
createdby
The ID of the user the transaction was created by.
bigint
-
createdon
The date and time when the object was created.
timestamp
-
currency
The three-letter code (ISO 4217 format) of the transaction's currency.
string
-
customeremailaddress
The customer's email address.
string
-
customerid
The unique identifier of the customer in the external system.
string
-
customerspresence
The customer's presence indicates whether and in what way the transaction's customer is present. Default is VIRTUAL_PRESENT.
string
-
deliverydecisionmadeon
This date and time when the decision was made as to whether the order should be shipped.
timestamp
-
devicesessionidentifier
Allows to link the transaction to the data collected from the customer's device.
string
-
emailsdisabled
Whether email sending is deactivated for the transaction. Default is false.
boolean
-
endoflife
The date and time when the transaction reaches its end of live. No further actions can be carried out at this time.
timestamp
-
environment
string
-
environmentselectionstrategy
The strategy for determining whether the transaction is to be processed in the test or production environment.
string
-
failedon
The date and time when the transaction failed.
timestamp
-
failedurl
The URL to redirect the customer back to after they canceled or failed to authenticated their payment.
string
-
failurereason
The reason for the failure of the transaction.
bigint
-
Transaction Group ID
bigint
-
id
A unique identifier for the object.
bigint
-
internetprotocoladdress
The IP address of the customer's device.
string
-
internetprotocoladdresscountry
The country determined from the IP address of the customer's device.
string
-
invoicemerchantreference
The merchant's reference used to identify the invoice.
string
-
javaenabled
Whether Java is enabled on the customer's web browser.
boolean
-
language
The language that is linked to the object.
string
-
lastuseractivitydate
timestamp
-
locktimeout
timestamp
-
merchantreference
The merchant's reference used to identify the transaction.
string
-
migration
int
-
Transaction ID
bigint
-
Payment Connector Configuration ID
bigint
-
plannedpurgedate
The date and time when the object is planned to be permanently removed. If the value is empty, the object will not be removed.
timestamp
-
processingon
The date and time when the processing of the transaction was started.
timestamp
-
refundedamount
The total amount that was refunded, in the transaction's currency.
decimal(19,8)
-
screencolordepth
The screen color depth of the customer's web browser.
string
-
screenheight
The screen height of the customer's web browser.
string
-
screenwidth
The screen width of the customer's web browser.
string
-
shippingaddresscity
string
-
shippingaddresscommercialregisternumber
string
-
shippingaddresscountry
string
-
shippingaddressdateofbirth
string
-
shippingaddressdependentlocality
string
-
shippingaddressemailaddress
string
-
shippingaddressfamilyname
string
-
shippingaddressgender
string
-
shippingaddressgivenname
string
-
shippingaddressmobilephonenumber
string
-
shippingaddressorganizationform
bigint
-
shippingaddressorganizationname
string
-
shippingaddressphonenumber
string
-
shippingaddresspostalstate
string
-
shippingaddresspostcode
string
-
shippingaddresssalestaxnumber
string
-
shippingaddresssalutation
string
-
shippingaddresssocialsecuritynumber
string
-
shippingaddressssortingcode
string
-
shippingaddressstreet
string
-
shippingmethod
The name of the shipping method used to ship the products.
string
-
spaceid
bigint
-
spaceviewid
The ID of the space view this object is linked to.
bigint
-
state
The object's current state.
string
-
successurl
The URL to redirect the customer back to after they successfully authenticated their payment.
string
-
Payment Terminal ID
bigint
-
timezone
The customer's time zone, which affects how dates and times are formatted when communicating with the customer.
string
-
tokenizationmode
The tokenization mode specifies whether and how the tokenization of payment information is applied to the transaction.
string
-
totalappliedfees
The total of all fees charged, in the transaction's currency.
decimal(19,8)
-
totalsettledamount
The total amount that was settled, in the transaction's currency.
decimal(19,8)
-
useragentheader
The 'User Agent' header of the customer's web browser.
string
-
userfailuremessage
The message that can be displayed to the customer explaining why the transaction failed, in the customer's language.
string
-
userinterfacetype
The type of user interface the customer used to provide the payment information.
string
-
version
The version is used for optimistic locking and incremented whenever the object is updated.
int
-
windowheight
The window height of the customer's web browser.
string
-
windowwidth
The window width of the customer's web browser.
string
-
yearstokeep
The number of years the transaction is kept after its authorization.
int