Veritran Docs

trxl_id

int(10)

Registry's ID

trxl_write_timestamp

timestamp

Date and time of the registry

trxl_msg_typ

int(4)

Type of transactional message

trxl_msg_stat

int(2)

Message status

trxl_orig_pro_env

varchar2(2)

Environment of the process that originated the request

trxl_orig_pro_siteid

number(2)

Site ID of the process that originated the request

trxl_orig_pro_node

varchar(4)

Node of the process that originated the request

trxl_orig_pro_name

varchar(16)

Logical name of the process that originated the request

trxl_hld_orig_pro_env

varchar2(4)

Environment of the first process that originated the request

trxl_hld_orig_pro_siteid

number(2)

Site ID of the first process that originated the request

trxl_hld_orig_pro_node

varchar(4)

Node of the first process that originated the request

trxl_hld_orig_pro_name

varchar(16)

Logical name of the first process that originated the request

trxl_originator

char(1)

Indicates where was the request regenerated from

trxl_responder

char(1)

Indicates where the response is generated from

trxl_excpt_flg

char(1)

Exceptions found while the transaction was executing

trxl_host_id

varchar(4)

Host code that receives the transaction

trxl_step_id

int(1)

Transaction step where the host is involved

trxl_proc_step1, trxl_proc_step2, trxl_proc_step3, trxl_proc_step4

char(1)

Transaction step and it's result in transactions that support authorization in several steps.

trxl_host_step1, trxl_host_step2, ,trxl_host_step3 trxl_host_step4

varchar(4)

Host code that receives the transaction after each step

trxl_tran_dat

date

Date of the transaction: yyyymmdd

trxl_tran_tim

time

Time of the transaction: hhmmsscc

trxl_post_dat

date

Date of the transaction registered in the transaction log, set by the Device Handler or the Host Interface

trxl_term_id

varchar(36)

Identifier of the terminal that executed the transaction. It identifies, for example, a mobile app installed in a particular device

trxl_term_ln

varchar(4)

Identifier of the terminal's VT-NET network

trxl_seq_num

int(5)

Sequence number that identifies a transaction. Each terminal has its own sequence number

trxl_term_typ

char(2)

Type of terminal where the transaction originated from

trxl_rvsl_cde

int(2)

Reversal transaction code set by the Device Handler or the Host Interface

trxl_compl_req

char(1)

Indicates if the host needs a completion notification

trxl_orig_compl_req

char(1)

Indicates if it is necessary to receive a transaction confirmation from the origin device

trxl_reversible

char(1)

Indicates if it is necessary to set a reversal transaction if there is no confirmation of a response

trxl_resp

char(3)

Transaction's response code that is unique for each installation

trxl_auth_dest

varchar(16)

Authorizator's name

trxl_entry_tim

datetime

Timestamp that determines when the request enters the system. This is set by the Device Handler or the Host Interface

trxl_exit_tim

dametime

Timestamp that determines when the request exits the system for an external authorization. This is set by the Device Handler or the Host Interface

trxl_re_entry_tim

datetime

Timestamp that determines when the request reenters the system after an external authorization. This is set by the Device Handler or the Host Interface

trxl_transaction_code (*)

int(4)

Transaction code that is unique for each installation

trxl_institution_code  (*)

varchar(4)

Code of the client's Institution

trxl_client_id_type (*)

varchar(4)

Client identifier type

trxl_client_id (*)

varchar(64)

Client identifier, with AES-128-CBC encryption

trxl_card_number (*)

varchar(30)

Client's card number. It can be ommited, or it can hide several digits

trxl_host_post_date (*)

date

Authorizator host post date

trxl_host_current_date (*)

date

Authorizator host date

trxl_host_current_time (*)

time

Authorizator host time

trxl_host_seq_number (*)

varchar(20)

Authorizator host sequence number

trxl_host_terminal (*)

varchar(20)

Authorizator host terminal code

trxl_configuration_group (*)

int(2)

Mobile app's configuration group

trxl_authorization_code (*)

varchar(10)

Transaction's authorization code, generated as a security measure when the transaction requires it

trxl_banners_group (*)

int(3)

Mobile app's banners group

trxl_client_alt_id (*)

varchar(64)

Client's alternative identifier, with AES-128-CBC encryption

trxl_amount1, trxl_amount, trxl_amount3, trxl_amount4 (*)

float

Amounts involved in a transaction

trxl_date1, trxl_date2, trxl_date3, trxl_date4(*)

date

Dates involved in a transaction

trxl_account_pri_id1, trxl_account_pri_id2, trxl_account_pri_id3, trxl_account_pri_id4 (*)

varchar(10)

Primary identifier of the accounts involved in a transaction. For example, an account type

trxl_account_sec_id1, trxl_account_sec_id2, trxl_account_sec_id3, trxl_account_sec_id4 (*)

varchar(10)

Secondary identifier of the accounts involved in a transaction. For example, an account sub-type

trxl_account1, trxl_account2, trxl_account3, trxl_account4 (*)

varchar(35)

Account numbers involved in a transaction

trxl_text1, trxl_text2, trxl_text3, trxl_text4 (*)

varchar(255)

Texts or descriptions involved in a transaction

trxl_flag1, trxl_flag2, trxl_flag3, trxl_flag4 (*)

char(1)

Flags involved in a transaction

trxl_auth_code_step1, trxl_auth_code_step2, trxl_auth_code_step3, trxl_auth_code_step4 (*)

varchar(10)

Authorization code related to an authorization's step. It is generated as a security measure by the authorizator when the transaction requires it

trxl_currency1, trxl_currency2 (*)

int(3)

Code of the currency involved in the transaction, using the numeric ANSI encoding scheme

trxl_detail

varchar (4000)

Additional information about the transaction and the origin device

trxl_tech_detail

clob

Detailed information about the transaction's steps

trxl_host_begin

timestamp

Date when the host received the transaction

trxl_host_end

timestamp

Date when the host returns the transaction

trxl_client_plain_id

varchar2(64)

User's identifier (without encrypting)

trxl_channel

varchar2(35)

Channel that receives the transaction (web, mobile or smartPOS)

trxl_used_version

number(10)

Transaction version used by the host

trxl_requested_version

number(10)

Transaction version requested to the host

trxl_timeout

number(10)

Timeout assigned for the transaction

trxl_auth_methods_desc

varchar2(255)

Authentication method used by the final user (fingerprint, face recognition, password, etc)

trxl_rcdc_name_id

varchar2(64)

Name of the Bluegreen experiment running during the transaction execution

trxl_rc_path

varchar2(20)

Path that took the transaction during a Bluegreen experiment (NULL equals BLUE)

trxl_session_id

varchar2(3000)

Transaction's session identifier

trxs_id

int(10)

Table's identifier

trxs_post_dat

date

Summary date

trxs_msg_typ

int(4)

Message type

trxs_transaction_code

int(4)

Transaction code

trxs_resp

char(3)

Response code

trxs_count

int(10)

Number of transactions

trxs_write_timestamp

datetime

Date and time of the registry's creation

trxs_max_trxl_id

int(10)

Last identifier in the transaction logs table

trxs_verify

char(8)

Data's integrity hash