Transaction Type

You can enter financial data transactions using the Transaction Type menu, which contains the accounting model and item configuration. You can insert, delete, or export Transaction Types tables.

For using transaction types in conjunction with Loan Management, see Transaction Types Used in Loan Management.

Creating Transaction Types

  1. In FintechOS Portal, click the main menu > General Ledger Configurations > Transaction Type menu item to open the Transaction Types List page.

  2. Click the Insert button to create a new transaction type.

  3. In the newly displayed Add Transaction Type page’s Settings, fill in the following fields:

    • Name: Enter the name of the transaction type.

    • Transaction Code: Enter the code of the transaction type.

    • Process Type: 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.

    • Edit Form: Select the form used to edit this transaction type. The lookup only shows forms defined on the Contract Event entity.

    • Transaction Operation Type: The transaction operation type makes the connection with the transaction motor of bank accounts. Select one of the transaction operation types defined within the system.

    • Is System Transaction: Select this checkbox to mark the transaction as neither an account credit nor an allocation of funds but a transaction that does not affect other transactions in 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).

    • Is Automatic Transaction: This checkbox marks the transaction as automatic. If you select it, then you cannot select the transaction type within the contract operations.

    • Real Time Process: If you select this checkbox, then the transaction is processed right away. If you do not select it, then the transaction is inserted as a bank account transaction queue record. This checkbox marks the transaction as to be processed in real-time.

    • Only One Draft: If you select this checkbox, there can only be one record of this transaction type in the Draft status created at the contract level.

    • Generate New Contract Version: If you select this checkbox, then a new contract version is generated by this transaction type.

    • Commission Type: Select the commission type applicable for this transaction type. Return fee commissions are filtered out and can't be selected.

    • Return Commission Type: Select the return fee commission type applicable for this transaction type. You can only select fee commissions.

    • Is Clawback Transaction: If selected, this checkbox marks the transaction as generating a clawback commission. The transaction type is to be used in third-party management invoicing activities. Default value: False.

  4. In the Accounting Configurations section, fill in the following fields:

    • Generates Accounting Entry: Select this checkbox to create an entry in the general ledger. It generates records in the Accounting Entry entity.

    • OL Master Entity: Select the entity referenced by the accounting systems.

  5. In the Purge Configurations section, fill in the following fields:

    • To Be Purged: This checkbox marks the transaction as purgeable. Select it so that you can purge or archive records in Draft status.

    • Purge Number of Days: Enter the default number of calendar days that a record can be kept in Draft status before it is purged. For additional information, see the Loan Management System Parameters page. This field is displayed only when the To Be Purged checkbox is selected.

    • Master Purge Entity: Select the master purge entity under which the draft records are. This field is displayed only when the To Be Purged is selected.

  6. Click the Save and reload button.

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

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.

You can create and determine the values calculated for each transaction in the Transaction Value Type section. 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:

    • Value Type Name: Enter the name of the value type.

    • Transaction Type: Select the transaction value type.

    • Type: Select the type of the transaction. The following options are available: Numeric or Text.

    • Value Type Attribute: Select the value of a specific attribute from the source entity. It is a list of all the attributes defined in the SourceEntityId field from the GL TransactionType entity.

    • Is Header: When selected, it defines the header items of the transaction.

    • Formula: Supports only basic math operations: addition (+), subtraction (-), multiplication (*), and division (/). Input a specific formula based on the Value Type Attribute chosen.

  3. Click the Save and close button.

When a transaction value type is marked as a header item, the transaction values are set into the attribute values of the Operation Transaction entity. If the Value Type Name field is not an attribute of that entity, then an error is displayed.

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.

You can define an account from the Accounting Chart in the Transaction Item Accounting Configuration section, which holds the configuration of each transaction. The section 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:

    • Accounting System: Select the accounting system.

    • Accounting Scope: Select the accounting scope.

    • Chart Account: Select the accounting chart.

    • Operational Item: Select the item of operations.

    • Currency: Select the currency of the accounting entry line.

    • Take From Product: If you select this checkbox, then the configurations for each transaction are inherited from the banking product level.

  3. Click the Save and close button.

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:

    • Transaction Type: The transaction type. It is auto-filled.

    • Accounting System: Select the accounting system.

    • Line Condition: Enter the condition applied in order to post the accounting entry line.

    • Debit Account Rule: The accounting entry value of the debit account. It is auto-filled.

    • Debit Customer Rule: The rule to save the partner transaction in the debit-credit relationship. It is auto-filled.

    • Accounting Entry Value Rule: Enter the posted accounting entry value.

    • Item Rule: The transaction item of the accounting entry line. It is auto-filled.

    • EntityId Rule: Enter the internal status of the record.

    • Transaction Detail Rule: Enter the rule to identify and post the ID of the operational transaction detail.

    • Credit Account Rule: Enter the credit account of the accounting entry line. It is auto-filled.

    • Credit Customer Rule: It is auto-filled by the destination partner ID.

    • currencyRule: The accounting entry line currency. It is auto-filled.

    • DescriptionRule: The description of the generated accounting entry. It is auto-filled.

    • Transaction Id Rule: Enter the related contract ID of the transaction.

    • Transaction Value Type: Select the value type of the transaction. It is defined in the Transaction Value Type section.

  3. Click the Save and close button.