Transaction Type

The Transaction Type menu holds the accounting model and the item configuration. It is used for inserting the financial data transactions.

For using transaction types in conjunction with Core Banking, see Transaction Types Used in Core Banking.

HINT  
Users can insert, delete, or export Transaction Types tables.

Creating Transaction Types

1. Log into the FintechOS Portal.

2. Expand the General Ledger Configurations menu and select Transaction Type. The Transaction Operation Types List page opens.

3. At the top-right corner of the page, click the Insert button to create a new transaction type.

4. Fill in the following fields:

Field Required Data Type Details
Settings
Name Yes Text The name of the transaction type.
Transaction Code Yes Text The code of the transaction type.
Is Automatic Transaction Yes Bool This checkbox marks the transaction as automatic. If selected here, then you cannot select it within the contract operations.
IMPORTANT!  
If a transaction type is marked as an automatic transaction (Is Automatic Transaction = True), then that transaction type cannot be selected in the Events page when closing contract events.
Is System Transactions No Bool This checkbox marks the transaction as being neither a credit of the account, nor an allocation of funds, but a transaction that does not influence other transactions within the account. System transactions are meant to be used only for accounting. It is used when there's a need of a transaction for the sole purpose of generating accounting entries (accruals, provisions).
Real Time Process   Bool This checkbox marks the transaction as to be processed in real-time. If the value is True, then the transaction is processed right away. If the value is False, then the transaction is inserted as a bank account transaction queue record.
Edit Form No Lookup The form used to edit this transaction type. The lookup only shows forms defined on the Contract Event entity.
Only One Draft No Bool If you select this checkbox, there can be only one record of this transaction type in Draft status created at the contract level.
Generate New Contract Version No Bool This checkbox allows you to specify if a new contract version should be generated by this transaction type.
Commission Type No Lookup The commission type applicable for this transaction type. Return fee commissions are filtered out and can't be selected.
Return Commission Type No Lookup The return fee commission type applicable for this transaction type. Only return fee commissions can be selected.
Process Type Yes Option set This field associates the process type with the transaction operation type, which makes the connection with the transaction motor of bank accounts. Select one of the processes defined within the system.
NOTE  
There is no integration at this point with a payment gateway.
Accounting Configurations
Generates Accounting Entry Yes Bool This checkbox allows you to create an entry in the general ledger. It generates records in the Accounting Entry entity.
OL Master Entity Yes Lookup The entity referenced by the accounting systems.
Purge Configurations
To Be Purged No Bool This checkbox marks the transaction as purgeable. If selected, it allows you to purge or archive records in Draft status.
Purge Number of Days Yes Whole Number The default number of calendar days that a record can be kept in Draft status before it is purged. For additional information, see the Core Banking System Parameters page. This field is displayed only when To Be Purged = True.
Master Purge Entity Yes Lookup The master purge entity under which the draft records are. This field is displayed only when To Be Purged = True.
 

5. Click Save and reload.

IMPORTANT!  
If a transaction type is marked to automatically generate accounting entries (Generates Accounting Entry = True), then the following sections are displayed: Transaction Value Type, Transaction Item Accounting Configuration, and Transaction Accounting Models.

Transaction Value Type

Transaction value types are defined as header items or detail items. Header items are the general details of a transaction (for example date, customer, currency, and so on). The detail items are grouped into numeric or text information.

In this section, users can create and determine the values calculated for each transaction. The additional data from here is used in the Transaction Accounting Models section.

1. To add a new transaction value type, click the Insert button under the Transaction Value Type section. The Add Transaction Value Type page opens.

2. Fill in the following fields:

Field RequiredTypeDescription
Value Type NameNoTextThe name of the value type.
Transaction TypeNoLookupThe transaction value type.
TypeNoOption SetThe type of the transaction. The following options are available:
  • [none]
  • Numeric
  • Text
Value Type AttributeNoLookupThe value of a specific attribute from the source entity. It is a list of all the attributes defined in the SourceEntityId field from the FTOS_GL_TransactionType entity.
Is HeaderNoBoolWhen selected, it defines the header items of the transaction.
FormulaNoTextSupports only basic math operations: addition (+), subtraction (-), multiplication (*), and division (/). Input a specific formula based on the Value Type Attribute chosen.
 

3. Click Save and close.

When a transaction value type is marked as a header item, (Is Header = True), the transaction values are set into the attribute values of the FTOS_GL_OperationTransaction entity. If the Value Type Name field is not an attribute of that entity, then the following error is displayed:

Name should be an attribute name from header table FTOS_GL_ OperationTransaction.

A json with default values is sent when using the function for setting the operation transaction values. The json has the following form:

Copy
[
  {
    attributeName: 'DescriptionText',
    value: 'Disburse 1500'
   },
   {
    attributeName: 'ProvisionAmount',
    value: '15.00'
   }
]
 

The json checks if there is any default value for the attributeName, from the Value Type Name field. If no values are returned, the Formula field is checked. When neither field returned any values, the source entity of the attribute from the Value Type Attribute field is checked.

Transaction Item Accounting Configuration

The Transaction Item Accounting Configuration section holds the configuration of each transaction. It helps define an account from the Accounting Chart.

This section holds the configuration for an item with the respective chart account. It represents the listing of the names of the accounts for the company inserted in the Legal Entity menu.

1. To add a new transaction item accounting configuration, click the Insert button under the Transaction Item Accounting Configuration section. The Add Transaction Item Accounting Config page opens.

2. Fill in the following fields:

 

FieldRequiredTypeDescription
Accounting SystemYesLookup The accounting system.
Accounting ScopeYesLookupThe accounting scope.
Chart AccountYesLookupThe accounting chart.
Operational ItemNoLookupThe item of operations.
CurrencyNoLookupThe currency of the accounting entry line.
Take From ProductNoBoolIf true, then the configurations for each transaction are inherited from the banking product level.

 

3. Click Save and close.

Transaction Accounting Models

This section holds the accounting models, all the rules used in order to generate accounting entries for each transaction.

The details from the Debit Account Rule and the Credit Account Rule are defined by the information from the Transaction Item Accounting Configuration section. All other details are defined by the information from the Transaction Value Type section.

1. To add a new transaction accounting model, click the Insert button under the Transaction Accounting Models section. The Add Transaction Accounting Model page opens.

2. Fill in the following fields:

FieldRequiredTypeDescription
Transaction TypeNoLookupThe transaction type. It is auto-filled.
Accounting SystemNoLookupThe accounting system.
Line ConditionNoText The condition applied in order to post the accounting entry line.
Debit Account RuleNoText The accounting entry value of the debit account. It is auto-filled.
Debit Customer Rule NoText The rule to save the partner transaction in the debit-credit relationship. It is auto-filled.
Accounting Entry Value RuleNoText The posted accounting entry value.
Item Rule NoText The transaction item of the accounting entry line. It is auto-filled.
EntityId RuleNoText The internal status of the record.
Transaction Detail RuleNoText The rule to identify and post the ID of the operational transaction detail.
Credit Account RuleNoText The credit account of the accounting entry line. It is auto-filled.
Credit Customer RuleNoText It is auto-filled by the destination partner ID.
currencyRuleNoText The accounting entry line currency. It is auto-filled.
DescriptionRuleNoText The description of the generated accounting entry. It is auto-filled.
Transaction Id RuleNoText The related contract ID of the transaction.
Transaction Value TypeNoLookupThe value type of the transaction. It is defined in the Transaction Value Type section.
 

3. Click Save and close.